Dataset: Aircraft Accidents

About this Dataset

Aircraft Accidents

The air crash data was collected from the Bureau of Aircraft Accidents Archives website and regards only scheduled revenue flights.

The period covered: from 2000 to mid-2023

Data source: Bureau of Aircraft Accidents Archives

Tables

Aircraft Accidents

@kaggle.yanasemenova_aircraft_accidents.aircraft_accidents

53 KB
679 rows
16 columns


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
);