Plane Crash Dataset (03.04.2023)

Aviation accidents database (civil, military and commercial)

@kaggle.kamilkarczmarczyk_plane_crash_dataset_03042023

Table List

1 table(979.46 KB)

Data Ready

@kaggle.kamilkarczmarczyk_plane_crash_dataset_03042023.data_ready

979.46 KB
5028 rows
17 columns

date Date	time Time:	location Location:	ac_type AC Type:	operator Operator:	route Route:	cn_ln Cn / Ln:	flight Flight #:	is_military Is Military	military_country Military Country	aboard_all Aboard All	aboard_passengers Aboard Passengers	fatalities_all Fatalities All	fatalities_passengers Fatalities Passengers	registration Registration:	summary Summary:
18.03.1946	nan	Between Chungking and Shanghai, China	nan	China National Aviation Corporation	Chunking - Shanghai	nan	nan	No	nan	?	?	?	?	139	Disappeared while en route. Plane never located.
09.11.1944	nan	Seljord, Norway	nan	Military - U.S. Army Air Corps	nan	nan	nan	Yes	U.S. Army Air Corps	?	?	?	?	42-52196	nan
09.05.1989	nan	Near Tainjin, China	Bell 412	Aero Asahi	nan	33070	nan	No	nan	?	?	10	?	JA9596	nan
20.02.1992	nan	En route from Argentina to California	Boeing B-747	Aerolineas Argentinas	nan	nan	386	No	nan	?	?	1	?	nan	A passenger died of cholera while en route.
13.03.1954	nan	Dien Bien Phu, South Vietnam	C-46	Aigle Azur	nan	nan	nan	No	nan	?	?	?	?	nan	Shot down.
10.04.1953	nan	Near Anchieta Island, Brazil	Doublas Dc-3	REAL	nan	nan	nan	No	nan	?	?	26	?	nan	nan
01.10.1942	nan	Kunming, China	Douglas C-47	China National Aviation Corporation	nan	nan	nan	No	nan	?	?	?	?	69	Crashed while attempting to land after losing oil pressure on one engine.
26.12.1936	nan	Nanking, China	Douglas DC-2	China National Aviation Corporation	nan	nan	nan	No	nan	?	?	?	?	NC14269	nan
13.06.1956	nan	Over North Carolina	Douglas DC-3	Piedmont	nan	nan	nan	No	nan	?	?	1	1	nan	A passenger fell to his death after the door of the plane opened.
22.12.1952	nan	Damascus, Syria	Douglas DC-3	Syrian Air	nan	nan	nan	No	nan	?	?	9	?	nan	nan


CREATE TABLE data_ready (
  "date" VARCHAR,
  "time" VARCHAR,
  "location" VARCHAR,
  "ac_type" VARCHAR,
  "operator" VARCHAR,
  "route" VARCHAR,
  "cn_ln" VARCHAR,
  "flight" VARCHAR,
  "is_military" VARCHAR,
  "military_country" VARCHAR,
  "aboard_all" VARCHAR,
  "aboard_passengers" VARCHAR,
  "fatalities_all" VARCHAR,
  "fatalities_passengers" VARCHAR,
  "ground" DOUBLE,
  "registration" VARCHAR,
  "summary" VARCHAR
);