Group Report: ITECH1103 - Bird Strike Data Analysis and Insights

This report presents a comprehensive analysis of bird strike data, undertaken as a group assignment for the ITECH1103 Big Data and Analytics course. The analysis utilizes SAS Visual Analytics to explore a provided dataset, aiming to identify significant trends and patterns related to bird strikes and their impact on aviation. The report addresses a series of questions, including the number of species involved, warning systems, top airline operators affected, and the phases of flight most susceptible to strikes. It delves into the cost implications of different wildlife species, examines time-of-day patterns for specific species like Bald Eagles and Canadian geese, and employs techniques such as cross-tabulation and geomaps to visualize the data. Furthermore, the analysis investigates bird strike counts and costs by airport, comparing the findings to derive insights. Finally, the report concludes with a cluster analysis on variables such as time out of service and total cost, providing a detailed description of how the clusters differ. The overall goal is to provide actionable insights into mitigating the risks associated with bird strikes and improving aviation safety.

Running head: 18 QUESTIONS 1
18 QUESTIONS Report
By (Name of Student)
(Institutional Affiliation)
(Date of Submission)
(Code)

18 QUESTIONS 2
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?

18 QUESTIONS 3
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?

18 QUESTIONS 4
Question 6: In which phase of flight would the aircraft be most likely to experience a bird
strike?

18 QUESTIONS 5
Question 7: Has a bird strike ever occurred whilst the aircraft was parked? If so, in how
many instances?

18 QUESTIONS 6
Question 8: Is a bird strike more likely to happen when there is no cloud as compared with
overcast conditions?

18 QUESTIONS 7
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?

18 QUESTIONS 8
Question 11: For the most costly species of wildlife, which phase of flight was the most
common for a bird strike?

18 QUESTIONS 9
Question 12: For the species Bald Eagle and Canadian goose, examine the time of day that
bird strikes occur to see if there are any differences between the two species. Hint: you will
need to use a filter on the species of wildlife and also use two categories.
Question 13: Investigate using a crosstab for the data values Pilot warned of bird strike,
Altitude bin, and the total cost.
Question 14: Create a Geomap of the bird strike data.

18 QUESTIONS 10
Question 15: Using the sum of the number of records, investigate the bird strike count by
airport. Hint: remove any missing data and use a sort.

18 QUESTIONS 11
Question 16: Investigate the bird strike cost by airport. Hint: remove any missing data and
use a sort on the cost.

18 QUESTIONS 12
Question 17: Compare the answers of the two questions above. What does this indicate?