Big Data Analysis Assignment: Bird Strikes and SAS Analytics

This project analyzes bird strike data using SAS Visual Analytics. The assignment covers various aspects of bird strikes, including the number of distinct species involved, the percentage of time pilots were warned, the top airlines affected, and the proportion of strikes involving medium and large wildlife. It also investigates the likelihood of strikes based on sky conditions and precipitation, identifies the species with the largest total cost, and examines the most common flight phases for strikes. The analysis includes the use of dashboards, histograms, and crosstabs to present findings. The project also considers the time of day for strikes involving specific bird species and provides a geomap of bird strike data. The project also presents the bird strike count by airport.

Running head: BIG DATA ANALYSIS ASSIGNMENT 1
BIRDSTRIKES - SAS Visual
Analytics Data Source
By (Name of Student)
(University/ Institution)
(Course Code)
(Date of Submission)
(Professor’s Name)

BIG DATA ANALYSIS GROUP ASSIGNMENT 2
Table of Contents
Background Information...................................................................................................................................
Question 1:........................................................................................................................................................
Question 2: How many different species (distinct) have been involved in bird strikes?....................................
Question 3: Where the data has been recorded, what percentage of the time was the pilot warned of
birds or wildlife?................................................................................................................................................
Question 4: What are the top five airline/operators involved in bird strikes?...................................................
Question 5: What proportion (percentage) of bird strikes involved medium and large wildlife?......................
Question 7: Has a bird strike ever occurred whilst the aircraft was parked? If so, in how many
instances?..........................................................................................................................................................
Question 8: Is a bird strike more likely to happen when there is
no cloud as compared with
overcast
conditions?.........................................................................................................................................................
Question 9: In what precipitation conditions is a bird strike most likely to happen?.........................................
Question 10: Which species of wildlife had the largest total cost? How much was this?...........................
Question 11: For the most costly species of wildlife, which phase of flight was the most common for a
bird strike?.........................................................................................................................................................
Conclusion.....................................................................................................................................................
References.........................................................................................................................................................
Cover Letter......................................................................................................................................................
REFLECTIONS...............................................................................................................................................
(Second Group Member).............................................................................................................................
(Third Group Member)...............................................................................................................................
(Fourth Group Member).............................................................................................................................

BIG DATA ANALYSIS GROUP ASSIGNMENT 3
Background Information
A bird strike is strictly defined as a collision between a bird and an aircraft which is in flight or on a
take-off or landing roll (Mohammed, et al 2013). The term is often expanded to cover other wildlife
strikes including bats or ground animals. Bird Strike is common and can be a significant threat to
aircraft safety. Bird strikes have not only been a safety concern to civil aviation but also to and
military aircrafts. Bird strikes happen when aircraft are close to the ground. The front facing
components of an aircraft which include the nacelles, windshield, wind leading edge, compressor
blade, etc. are often most susceptible to such strikes (Storace et al., 2018). It is therefore critical to
ensure that the different structural parts are able to withstand such high velocity impact. Moreover,
they should also be in a position to guarantee the safe landing of the aircraft after the strike.
Confirmation gauges, which incorporate checking the basic uprightness of airframes and
motors, are built up by U.S. Government Aviation organization (FAA) and European Joint Aviation
Authority (JAA) (Storace, et al, 2018). These experimental confirmations, which result in the harm of
models and the organic peril of utilizing genuine fowls, can be exorbitant and tedious. The utilization
of PC reenactment to mimic the feathered creature sway on new basic segments fills in as an amazing
asset for the improvement of new parts by limiting the quantity of experimental testing (Storace, et al,
2018). It permits the effect reaction of various basic and material parameters to be examined before
the genuine creation of the models, along these lines decreasing time and cost brought about in
experimental testing.
Impact among air ship and winged animal has been a worry since they undermine the security
of the general population on board the air ship, results in exorbitant fixes and on account of business
air ship, a misfortune in income. It is a danger that takes steps to debilitate the open confidences

BIG DATA ANALYSIS GROUP ASSIGNMENT 4
towards the avionics enterprises (Mohammed, et al 2013). Global boards of trustees, for example, the
International winged animal strike panel, the U.S and Italian flying creature strike advisory group, and
so on., have been framed to counter the danger presented by flying creature strikes, to more readily
comprehend the idea of strikes and to execute measures to avoid such strikes (Mohammed, et al
2013).
The Federal Aviation Administration (FAA) is a legislative body of the United States with
forces to manage all parts of common avionics in that country just as over its encompassing global
waters. Its forces incorporate the development and task of airplane terminals, air traffic the executives,
the affirmation of work force and flying machine, and the assurance of U.S. resources amid the
dispatch or reentry of business space vehicles. Controls over neighboring universal waters were
designated to the FAA by power of the International Civil Aviation Organization.
Formed in August 1958, the FAA supplanted the previous Civil Aeronautics Administration
(CAA) and later turned into an office inside the US Department of Transportation. By giving access to
open, the mission of Government is to improve city administrations, activities and bolster
straightforwardness and responsibility.
Research on Measures Taken to Reduce Bird Strikes
 Some airports are trying fields of prairie grass to deter birds from the area. There is no place to
eat, nest, or rest so they continue on to another area (Houston, 2016)
 Several airports have introduced bees as a method of keeping large birds away (Houston,
2016)
 Carla J. Dove is helping to improve aviation safety by identifying species of bird remains from
bird strikes (Tedeschi, 2017)

BIG DATA ANALYSIS GROUP ASSIGNMENT 5
 There are some organizations and even groups of civilians who use culling to rid a known
species of bird or problem area of the risk of causing bird strikes. This is done both legally and
illegally

BIG DATA ANALYSIS GROUP ASSIGNMENT 6
TASK 2
Reporting / Dashboards & Research/18 Questions
Phase of Flight
Observation
Bird strikes may occur during any phase of flight but are most likely during the take-off, initial climb,
approach and landing phases due to the greater numbers of birds fly at lower levels.
Origin of State Verses Sky Condition
Observation:

BIG DATA ANALYSIS GROUP ASSIGNMENT 7
By comparing the origin of state and the condition of the sky, it can be noted that the California state
had the highest frequency followed closely be the Texas while Florida State on the other had the least
frequency.
Observation

BIG DATA ANALYSIS GROUP ASSIGNMENT 8
The above histogram suggests the sky condition for the bird strike incidences. It can be seen that most
of the bird strikes and prone during no cloud while least when there exist some clouds.
Struck % According to Sky Conditions in Different States
California Texas Texas Texas California California Texas Texas
No Cloud Some Cloud No Clouds Overcast Some Clouds
0
5
10
15
20
25
30
35
30.89
24.59
10.83
0.21 0.73
8.21 8.09
0.22
S t ru ck % Acc o rd in g t o S k y Co n d iti o n s in Diff eren t S t at es
Observation
California State had the highest stuck percentage of about 30.89 which can be said to be as a result of
no cloud sky condition while Texas State with some cloud had the lowest stuck frequency.

BIG DATA ANALYSIS GROUP ASSIGNMENT 9
Top Airlines and their Costs
Observation

BIG DATA ANALYSIS GROUP ASSIGNMENT 10
By basing on the top airlines small size has the highest stuck frequency while large sized lowest
frequency.
On the airline cost, business Airlines produces the highest cost followed by the United Airlines
Question 1:
Done on SAS Dashboard !
Question 2: How many different species (distinct) have been involved in
bird strikes?

BIG DATA ANALYSIS GROUP ASSIGNMENT 11
Explanation
Based on the Teradata analysis of our bird strike data, there are a total of 602 distinct species involved
in bird strike. The table above shows the number.
Question 3: Where the data has been recorded, what percentage of the
time was the pilot warned of birds or wildlife?
Question 4: What are the top five airline/operators involved in bird strikes?

BIG DATA ANALYSIS GROUP ASSIGNMENT 12
Explanation
In regard to the airline operators involved, the following are top five;
1. Military
2. United Airlines
3. Southwest Airlines
4. Business
5. Fedex Express