Safety of World Airlines

To analyze the data few assumptions were made which are mentioned below:

• All the crashes were included regardless of the cause.
• Safety Score was calculated based on the Number of Available Seats per Kilometer (ASKs), assuming ASK will be constant since 1985 for each airline.

About the data:

The data is for 56 airlines operating since 1985 and includes the following fields:

• Airlines Name
• Avail seats per km per week
• Incidents 85-99
• Fatal Accidents 85-99
• Fatalities 85-99
• Incidents 00-14
• Fatal Accidents 00-14
• Fatalities 00-14

Exploratory Analysis:

As part of the analysis, various calculations were done and new data was introduced to find answers. Here is the list of calculations:

• Avail Seat Per million: ASK values were used to calculate the Safety Score throughout the analysis per million kms.
• Fatal Accident Rate per seat per km: Formula used [Fatal Accidents 00 14]/[Avail Seat Per million]*100
• Fatal Accident Rate per seat per km 85-99: Formula used: [Fatal Accidents 85 99]/[Avail Seat Per million]*100
• Fatalities Rate per seat per km: Formula used [Fatalities 00 14]/[Avail Seat Per million]*100
• Fatalities Rate per seat per km 85-99 : Formula used [Fatalities 85 99]/[Avail Seat Per million]*100
• Incident Rate per km: Formula used [Incidents 00 14]/[Avail Seat Per million]* 100
• Incident Rate per km 85-99: Formula used [Incidents 85 99]/[Avail Seat Per million]* 100
• Safety Score: Created this formula by Summing up all three categories with individual rates. The lower the number the safer the Airline. [Fatal Accident rate per seat per km]+[Fatalities rate per seat per km]+[Incident rate per km]+ [Fatal Accident rate per seat per km 85-99]+ [Fatal Accident rate per seat per km 85-99] + [Incident rate per km 85-99]

Also, I have imported some additional fields from the data available on the internet. These fields are Continent, Country (the country for each airline’s base country), and Per capita GDP of the Airline's Home country (the latest GPD of each country).

Key Observations:

To find the safest airlines, I calculated the Safety Score (Formula mentioned above) for each airline - The Lower the Safety Score, the Safer the Airline.

• Top 10 airlines in terms of Safety are depicted in Green and the bottom 10 airlines in terms of Safety are depicted in Red on the dashboard.
• A Plot between Incidents and Avail seat per km per week are depicting a trend – the more the Airlines fly the higher the incident rates, with some outliers i.e. Ethiopian Airlines and Aeroflot both airlines have had a high number of incidents.
• A Plot between Fatalities and Avail seat per km per week is not depicting any trend.
• A Plot between Fatal Accidents and Avail seat per km per week is not depicting any trend and is highly unpredictable.
• Interestingly, when comparing the Airlines’ Safety data with the GDP of their respective country, it looks like the developed country’s airlines are safer as compared to developing countries with SAS and Gulf Air as outliers.

Fallacies of this Approach:

o In general, all commercial airlines follow similar safety guidelines as governed by ICAO – International Civil Aviation Organization, to ensure safety and growth.

o There is no regional incidents/accidents data available to show if the accidents are happening in a particular region