Baselight

Airplane Crash Data Since 1908

Aircraft Accidents from 1908 to 2019

@kaggle.cgurkan_airplane_crash_data_since_1908

Loading...
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.