Commercial Flight Air Accidents 2008-2012
_Vypsb.png "Commercial Flight Air Accidents 2008-2012")
Completion Date:
Project Overview
Airflight accidents are tragic, but the worst tragedy would be when its fatality rate skyrocket. The safety of flights and the people who fly or operate them should be the number one priority of airline operations. With the use of PowerBI platform, we will compile and analyze (Commercial Airline Accidents in USA from 2008-2012”). Data from (ICAO) comprises of all accidents from 2008 -2022 but the report is focused on 2008-2012 period. In the event of these accidents, various kinds of injuries happened to passengers and the cabin crews. Some injuries were Fatal, Critical condition, Minor and others had None. We will group these injuries based on their severeness which are Fatal/Critical injuries and None/Minor injuries. We are analyzing fatal/critical injuries and None/Minor injuries over the period. The primary objective of this project is prevention. Identifying trends and creating relationship between causes of air accidents and consequences can help in the prevention of similar accidents from occurring in the future. As Peter Drucker famously said, “What gets measured gets done.”
Role:
Problem Statement
Approximately 10.5 million yearly averages of scheduled commercial flights in the United States from 2008 to 2012 with a total of 144 recorded accidents. About 33.33% of these accidents were either Fatal or with critical injuries. Even though total accidents are gradually decreasing, Fatal and Critical injuries are trending high. Statistics shows that up to 80% of all aviation accidents can be attributed to human error. The most dangerous times include takeoff and landing, but Fatal and critical injury accidents dominates while enroute and during approach. Pilot error is thought to account for 53% of aircraft accidents, with mechanical failure 21% and weather conditions 11%.
Executive Summary
Data Dictionary
Key Takeaways
Next Steps
From the data, we can see that most of the accidents that happen enroute and during approach are fatal and the causes are Turbulence and System Component Failure. The planes involve in accidents in these 2 flight phases (Enroute and Approach) are made with Jet, Turboprop and Jet engines.
Here are my suggestions.
System Component failure can be avoided by enforcing strict safety requirement standard on manufacturers and using high skilled Technicians for maintenance.
Air Turbulence is a natural movement of air current up and down, ripple out, change direction and speed around the plane. The highest cause of plane crash during approach. This can be easily predicted. Train pilots on how to use weather instruments in the plane to avoid the worst storms. Most importantly, proper commutation system with the pilot and controllers
From the report, Jet engine accidents fatality rate are mostly while enroute, Turboprop engine fatalities occurs mostly during approach and Piston engines occurs while enroute and during approach. About 80% of commercial flight engines are made by Jet. As manufacturers and Pilots aren\\\'t perfect, I would suggest we create more safety inventions that may curb fatality rate in case of accident. Like inbuilt parachute to land smoothly in case of failure.
In reference to the plane crash on February 12, 2009, in which the aircraft crashed into a house during approach due to the flight crew\\\'s improper response to an impending stall and killed all on board and one in the house. We can get to the root of avoiding any causes of fatal plane crash as more data arrive and more recommendations are properly followed.
