Airplane Crash Data Since 1908
Aircraft Accidents from 1908 to 2019
@kaggle.cgurkan_airplane_crash_data_since_1908
Aircraft Accidents from 1908 to 2019
@kaggle.cgurkan_airplane_crash_data_since_1908
The aviation accident database throughout the world, from 1908-2019.
There are similar dataset available on Kaggle. This dataset is cleaned versioned and source code is available on github.
Data is scraped from planecrashinfo.com. Below you can find the dataset column descriptions:
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
Find the root cause of plane crashes. Find any insights from dataset such as
CREATE TABLE airplane_crashes_and_fatalities_since_1908_20190820105639 (
"date" TIMESTAMP,
"time" VARCHAR,
"location" VARCHAR,
"operator" VARCHAR,
"flight" VARCHAR -- Flight #,
"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
);
Anyone who has the link will be able to view this.