Airline Safety: airline-safety.csv

Table actions

This table contains the data behind the story Should Travelers Avoid Flying Airlines That Have Had Crashes in the Past?

Header 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

Source: Aviation Safety Network

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette

3 rows where incidents_85_99 = 0

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ airline avail_seat_km_per_week incidents_85_99 fatal_accidents_85_99 fatalities_85_99 incidents_00_14 fatal_accidents_00_14 fatalities_00_14
16 16 Cathay Pacific* 2582459303 0 0 0 2 0 0
27 27 Hawaiian Airlines 493877795 0 0 0 1 0 0
49 49 TAP - Air Portugal 619130754 0 0 0 0 0 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "airline-safety/airline-safety" (
"airline" TEXT,
  "avail_seat_km_per_week" INTEGER,
  "incidents_85_99" INTEGER,
  "fatal_accidents_85_99" INTEGER,
  "fatalities_85_99" INTEGER,
  "incidents_00_14" INTEGER,
  "fatal_accidents_00_14" INTEGER,
  "fatalities_00_14" INTEGER
);