All Plane Crashes In History

All plane crashes in history. Contains all plane crashes.

@kaggle.aryan112345_all_plane_crashes_in_history

Planecrash

@kaggle.aryan112345_all_plane_crashes_in_history.planecrash

date Date	location_operator Location / Operator	aircraft_type_registration Aircraft Type / Registration	fatalities Fatalities
17 Sep 1908	Fort Myer, VirginiaMilitary - U.S. Army	Wright Flyer III?	1/2(0)
07 Sep 1909	Juvisy-sur-Orge, France?	Wright ByplaneSC1	1/1(0)
12 Jul 1912	Atlantic City, New JerseyMilitary - U.S. Navy	Dirigible?	5/5(0)
06 Aug 1913	Victoria, British Columbia, CanadaPrivate	Curtiss seaplane?	1/1(0)
09 Sep 1913	Over the North SeaMilitary - German Navy	Zeppelin L-1 (airship)?	14/20(0)
17 Oct 1913	Near Johannisthal, GermanyMilitary - German Navy	Zeppelin L-2 (airship)?	28/28(0)
05 Mar 1915	Tienen, BelgiumMilitary - German Navy	Zeppelin L-8 (airship)?	17/41(0)
03 Sep 1915	Off Cuxhaven, GermanyMilitary - German Navy	Zeppelin L-10 (airship)?	19/19(0)
28 Jul 1916	Near Jambol, BulgeriaMilitary - German Army	Schutte-Lanz S-L-10 (airship)?	20/20(0)
24 Sep 1916	Billericay, EnglandMilitary - German Navy	Zeppelin L-32 (airship)?	22/22(0)


CREATE TABLE planecrash (
  "date" VARCHAR,
  "location_operator" VARCHAR,
  "aircraft_type_registration" VARCHAR,
  "fatalities" VARCHAR
);