Aircraft Accidents

Aircraft Accidents that happened with scheduled revenue flights in 21st century.

@kaggle.yanasemenova_aircraft_accidents

Table List

1 table(53 KB)

Aircraft Accidents

@kaggle.yanasemenova_aircraft_accidents.aircraft_accidents

53 KB
679 rows
16 columns

date Date	operator Operator	a_c_type A/C Type	location Location	people_on_board People On Board	total_fatalities Total Fatalities	crew_on_board Crew On Board	crew_fatalities Crew Fatalities	pax_on_board Pax On Board	pax_fatalities Pax Fatalities	other_fatalities Other Fatalities	registration Registration	survivors Survivors	flight_phase Flight Phase	cause Cause	terrain_type Terrain Type
Mon Jan 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	SAM AIR	Cessna 208A Caravan	Elelim, Special Region of Papua	6	6	2	2	4	4		PK-SMW	No	Flight	Investigation in process	Mountains
Sun Jan 15 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Yeti Airlines	ATR72-500	Pokhara, Gandaki	72	72	4	4	68	68		9N-ANC	No	Landing(descent or approach)	Investigation in process	Airport (less than 10km from airport)
Mon Jan 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	Нарьян-Мар	PZL-Mielec AN-2	Karatayka, Nenets Autonomous Okrug	12	2	2	1	10	1		RA-71165	Yes	Flight	Weather	Plain, valley
Fri Nov 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	LATAM	Airbus A320	Lima-Callao-Jorge Chávez, Lima	108	2	6		102		2	CC-BHB	Yes	Takeoff(climb)	Human factor	Airport (less than 10km from airport)
Sun Nov 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Percision Air	ATR42-500	Bukoba, Kagera Region	43	19	4	2	39	17		5H-PWF	Yes	Landing(descent or approach)	Unknown	Lake, sea, ocean, river
Sun Oct 23 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	KOREAN AIR	Airbus A330	Mactan, Cebu	176		11		165			HL7525	Yes	Landing(descent or approach)	Unknown	Airport (less than 10km from airport)
Thu Oct 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SAETA PERU	Cessna 208B Grand Caravan	San Lorenzo, Loreto	12		2		10			OB-2228	Yes	Flight	Technical failure	Plain, valley
Tue Sep 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	SAETA PERU	BAe Jetstream 31	El Estrecho, Loreto	17	1	2		15	1		OB-2152	Yes	Takeoff(climb)	Unknown	Airport (less than 10km from airport)
Mon Jul 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	JUBBA Airways	Fokker 50	Mogadishu-Aden Abdulle, Banaadir (بنادر‎)	36		4		32			5Y-JXN	Yes	Landing(descent or approach)	Unknown	Airport (less than 10km from airport)
Tue Jun 21 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	RED Air	McDonnell Douglas MD-82	Miami-Intl, Florida	126		7		119			HI1064	Yes	Landing(descent or approach)	Unknown	Airport (less than 10km from airport)


CREATE TABLE aircraft_accidents (
  "date" TIMESTAMP,
  "operator" VARCHAR,
  "a_c_type" VARCHAR,
  "location" VARCHAR,
  "people_on_board" DOUBLE,
  "total_fatalities" BIGINT,
  "crew_on_board" DOUBLE,
  "crew_fatalities" DOUBLE,
  "pax_on_board" DOUBLE,
  "pax_fatalities" DOUBLE,
  "other_fatalities" DOUBLE,
  "registration" VARCHAR,
  "survivors" VARCHAR,
  "flight_phase" VARCHAR,
  "cause" VARCHAR,
  "terrain_type" VARCHAR
);