Dataset: Airplane Crash Data Since 1908

About this Dataset

Airplane Crash Data Since 1908

Context

The aviation accident database throughout the world, from 1908-2019.

All civil and commercial aviation accidents of scheduled and non-scheduled passenger airliners worldwide, which resulted in a fatality (including all U.S. Part 121 and Part 135 fatal accidents)
All cargo, positioning, ferry and test flight fatal accidents.
All military transport accidents with 10 or more fatalities.
All commercial and military helicopter accidents with greater than 10 fatalities.
All civil and military airship accidents involving fatalities.
Aviation accidents involving the death of famous people.
Aviation accidents or incidents of noteworthy interest.

There are similar dataset available on Kaggle. This dataset is cleaned versioned and source code is available on github.

Content

Data is scraped from planecrashinfo.com. Below you can find the dataset column descriptions:

Date: Date of accident, in the format - January 01, 2001
Time: Local time, in 24 hr. format unless otherwise specified
Airline/Op: Airline or operator of the aircraft
Flight #: Flight number assigned by the aircraft operator
Route: Complete or partial route flown prior to the accident
AC Type: Aircraft type
Reg: ICAO registration of the aircraft
cn / ln: Construction or serial number / Line or fuselage number
Aboard: Total aboard (passengers / crew)
Fatalities: Total fatalities aboard (passengers / crew)
Ground: Total killed on the ground
Summary: Brief description of the accident and cause if known

Acknowledgements

The original data is from the Plane Crash info website (http://www.planecrashinfo.com/database.htm). Dataset is scraped with Python. Source code is also public on Github

Inspiration

Find the root cause of plane crashes. Find any insights from dataset such as

Which operators are the worst
Which aircrafts are the worst

Tables

Airplane Crashes And Fatalities Since 1908–20190820105639

@kaggle.cgurkan_airplane_crash_data_since_1908.airplane_crashes_and_fatalities_since_1908_20190820105639

962.98 KB
4967 rows
17 columns


CREATE TABLE airplane_crashes_and_fatalities_since_1908_20190820105639 (
  "date" TIMESTAMP,
  "time" VARCHAR,
  "location" VARCHAR,
  "operator" VARCHAR,
  "flight" VARCHAR,
  "route" VARCHAR,
  "ac_type" VARCHAR,
  "registration" VARCHAR,
  "cn_ln" VARCHAR,
  "aboard" DOUBLE,
  "aboard_passangers" DOUBLE,
  "aboard_crew" DOUBLE,
  "fatalities" DOUBLE,
  "fatalities_passangers" DOUBLE,
  "fatalities_crew" DOUBLE,
  "ground" DOUBLE,
  "summary" VARCHAR
);