Baselight

Airline Safety

Airline Incidents and Accidents from 1985 to 2014

@fivethirtyeight.airline_safety

Airline Safety
@fivethirtyeight.airline_safety.airline_safety

Column Definition
airline Airline (asterisk indicates that regional subsidiaries are included)
avail_seat_km_per_week Available seat kilometers flown every week
incidents_85_99 Total number of incidents, 1985–1999
fatal_accidents_85_99 Total number of fatal accidents, 1985–1999
fatalities_85_99 Total number of fatalities, 1985–1999
incidents_00_14 Total number of incidents, 2000–2014
fatal_accidents_00_14 Total number of fatal accidents, 2000–2014
fatalities_00_14 Total number of fatalities, 2000–2014
  • 8.49 KB
  • 56 rows
  • 8 columns
airline

Airline

avail_seat_km_per_week

Avail Seat Km Per Week

incidents_85_99

Incidents 85–99

fatal_accidents_85_99

Fatal Accidents 85–99

fatalities_85_99

Fatalities 85–99

incidents_00_14

Incidents 00–14

fatal_accidents_00_14

Fatal Accidents 00–14

fatalities_00_14

Fatalities 00–14

Aer Lingus3209067342
Aeroflot*119767231876141286188
Aerolineas Argentinas38580364861
Aeromexico*59687181331645
Air Canada186525380222
Air France30040026611447962337
Air India*8692535522132941158
Air New Zealand*7101748173517
Alaska Airlines*96534677355188
Alitalia69801249872504

CREATE TABLE airline_safety (
  "airline" VARCHAR,
  "avail_seat_km_per_week" BIGINT,
  "incidents_85_99" BIGINT,
  "fatal_accidents_85_99" BIGINT,
  "fatalities_85_99" BIGINT,
  "incidents_00_14" BIGINT,
  "fatal_accidents_00_14" BIGINT,
  "fatalities_00_14" BIGINT
);

Share link

Anyone who has the link will be able to view this.