Boeing 737: Aircraft Risk Analytics

• To explore the risk of airplanes crash based on the events happened in the period of 2018-2019
• To describe the risk percentage of flight aviation commercial airlines
• To process data cleaning about severe risk data
• Data Visualisation: Airplane crashes in 2018-2019 Q1
• Case study: Boeing 737 Max 8
• Market Response Analysis

Getting Data Source of data are from the database of the following links

• https://aviation-safety.net/database/
• http://www.planecrashinfo.com/database.htm
• In addition, my favorite Wolfram Alpha queries

As data are in the raw form, I use Python xml library to parse data from the link and cleaning data in excel for visualisation purpose.

Database shows that the landing may have the highest risk of accident for the flight, but who knows..

RiskData

             phase perc
1 loadingUnloading   12
2          takeoff   12
3         iniClimb    8
4           flapUp   10
5           Cruise    8
6          descent    4
7         iniAppro   10
8       finalAppro   11
9          landing   25

The fatalities greater than 20

         Date          AcType Fata
1 11 Feb 2018  Antonov_AN-148   71
2 18 Feb 2018          EP_ATS   66
3 06 Mar 2018 Antonov_An-26RF   39
4 12 Mar 2018    DHC-8_402Q-8   51
5 11 Apr 2018 Ilyushin76-TD7T  257
6 18 May 2018       Boeing737  112
7 04 Aug 2018 Junkers_JU-52HB   20
8 29 Oct 2018       Boeing737  189
9 10 Mar 2019       Boeing737  157

The fatalities data history

         Date    Operator Fata
1 18 May 2018      Cubana  112
2 29 Oct 2018     LionAir  189
3 10 Mar 2019 EthiopoaAir  157

       Operator Status num
1     SouthWest   oper  31
2   AmericanAir   susp  22
3     AirCanada   oper  20
4        NorAir   oper  18
5    ChinaSouth   susp  16
6      AirChina   susp  14
7      FlyDubai   oper  14
8       LionAir   susp  14
9     ChinaEast   susp  13
10       United   oper  12
11      WestJet   oper  12
12    TuiTravel   oper  11
13    XiamenAir   susp   9
14    HainanAir   susp   8
15     SpiceJet   oper   8
16      Turkish   oper   8
17          GOL   susp   7
18  ShandongAir   susp   7
19       AerCap   oper   6
20   Aeromexico   susp   6
21         Copa   oper   5
22 EthiopianAir   susp   5
23     QatarAir   oper   5
24  ShenzhenAir   susp   5
25      SilkAir   susp   5

Almost a third of 737 Max 8 fleet is grounded with the ground order.

Stock of BA declined 6.15 percent at 20 March 2019.