Civil Aviation Accidents

Aviation Safety Network (ASN) global database

@kaggle.warcoder_civil_aviation_accidents

Table List

1 table(766.69 KB)

Aviation Accident

@kaggle.warcoder_civil_aviation_accidents.aviation_accident

766.69 KB
23917 rows
9 columns

date Date	type Type	registration Registration	operator Operator	fatalities Fatalities	location Location	country Country	cat Cat	year Year
date unk.	Antonov An-12B	T-1206	Indonesian AF	nan	nan	Unknown country	U1	unknown
date unk.	Antonov An-12B	T-1204	Indonesian AF	nan	nan	Unknown country	U1	unknown
date unk.	Antonov An-12B	T-1201	Indonesian AF	nan	nan	Unknown country	U1	unknown
date unk.	Antonov An-12BK	nan	Soviet AF	nan	Tiksi Airport (IKS)	Russia	A1	unknown
date unk.	Antonov An-12BP	CCCP-11815	Soviet AF	0	Massawa Airport ...	Eritrea	A1	unknown
date unk.	Antonov An-12BP	CCCP-12172	Soviet AF	nan	nan	Russia	U1	unknown
date unk.	Antonov An-2	CCCP-N574	GUSMP, Directorate of Polar Aviation	nan	unknown	Russia	A1	unknown
date unk.	Antonov An-2	CCCP-01216	Aeroflot	0	Chita region	Russia	A2	unknown
date unk.	Antonov An-24B	RA-47794	Russian AF	0	nan	Russia	A1	unknown
date unk.	Antonov An-26	01 red	Soviet AF	0	Orenburg Air Base	Russia	O1	unknown


CREATE TABLE aviation_accident (
  "date" VARCHAR,
  "type" VARCHAR,
  "registration" VARCHAR,
  "operator" VARCHAR,
  "fatalities" VARCHAR,
  "location" VARCHAR,
  "country" VARCHAR,
  "cat" VARCHAR,
  "year" VARCHAR
);