Air Crashes Full Data 1908 -2024

Contains record of air incidents including location, aircraft, fatalities & date

@kaggle.jogwums_air_crashes_full_data_1908_2023

Table List

2 tables(430.25 KB)

Aircrahesfulldataupdated 2024

Aircrashesfulldata

@kaggle.jogwums_air_crashes_full_data_1908_2023.aircrashesfulldata

212.25 KB
5030 rows
12 columns

year Year	quarter Quarter	month Month	day Day	country_region Country/Region	aircraft_manufacturer Aircraft Manufacturer	aircraft Aircraft	location Location	operator Operator	sum_of_fatalities_air Sum Of Fatalities (air)	sum_of_aboard Sum Of Aboard
1908	Qtr 3	September	17	Virginia	Wright Flyer	Wright Flyer III?	Fort Myer Virginia	Army U.S. - Military	1	2
1909	Qtr 3	September	7	France?	Wright	Wright ByplaneSC1	Juvisy-sur-Orge France?	nan	1	1
1912	Qtr 3	July	12	New	Dirigible?	Dirigible?	Atlantic City New	Navy U.S. - JerseyMilitary	5	5
1913	Qtr 3	August	6	British	Curtiss	Curtiss seaplane?	Victoria British	Canada Columbia Private	1	1
1913	Qtr 3	September	9	nan	Zeppelin	Zeppelin L 1 (airship)?	Over the North SeaMilitary - German Navy	nan	14	20
1913	Qtr 4	October	17	Germany	Zeppelin	Zeppelin L 2 (airship)?	Near Johannisthal Germany	Navy German - Military	28	28
1915	Qtr 1	March	5	Belgium	Zeppelin	Zeppelin L 8 (airship)?	Tienen Belgium	Navy German - Military	17	41
1915	Qtr 3	September	3	Germany	Zeppelin	Zeppelin L 10 (airship)?	Off Cuxhaven Germany	Navy German - Military	19	19
1916	Qtr 3	July	28	Bulgeria	Schutte	Schutte Lanz S	Near Jambol Bulgeria	Army German - Military	20	20
1916	Qtr 3	September	24	England	Zeppelin	Zeppelin L 32 (airship)?	Billericay England	Navy German - Military	22	22


CREATE TABLE aircrashesfulldata (
  "year" BIGINT,
  "quarter" VARCHAR,
  "month" VARCHAR,
  "day" BIGINT,
  "country_region" VARCHAR,
  "aircraft_manufacturer" VARCHAR,
  "aircraft" VARCHAR,
  "location" VARCHAR,
  "operator" VARCHAR,
  "sum_of_ground" BIGINT,
  "sum_of_fatalities_air" BIGINT,
  "sum_of_aboard" BIGINT
);