Airline Safety: airline-safety.csv

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

56 rows sorted by avail_seat_km_per_week

View and edit SQL

Suggested facets: incidents_85_99, fatal_accidents_85_99, incidents_00_14, fatal_accidents_00_14, fatalities_00_14

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
47 TACA 259373346 3 1 3 1 1 3
30 Kenya Airways 277414794 2 0 0 2 2 283
39 Royal Air Maroc 295705339 5 3 51 3 0 0
26 Gulf Air 301379762 1 0 0 3 1 143
1 Aer Lingus 320906734 2 0 0 0 0 0
45 Sri Lankan / AirLanka 325582976 2 1 14 4 0 0
22 El Al 335448023 1 1 4 1 0 0
36 Pakistan International 348563137 8 3 234 10 2 46
13 Austrian Airlines 358239823 1 0 0 1 0 0
3 Aerolineas Argentinas 385803648 6 0 0 1 0 0
14 Avianca 396922563 5 3 323 0 0 0
37 Philippine Airlines 413007158 7 4 74 2 1 1
18 Condor 417982610 2 1 16 0 0 0
56 Xiamen Airlines 430462962 9 1 82 2 0 0
23 Ethiopian Airlines 488560643 25 5 167 5 2 92
27 Hawaiian Airlines 493877795 0 0 0 1 0 0
24 Finnair 506464950 1 0 0 0 0 0
19 COPA 550491507 3 1 47 0 0 0
21 Egyptair 557699891 8 3 282 4 1 14
4 Aeromexico* 596871813 3 1 64 5 0 0
25 Garuda Indonesia 613356665 10 3 260 4 2 22
49 TAP - Air Portugal 619130754 0 0 0 0 0 0
54 Vietnam Airlines 625084918 7 3 171 1 0 0
43 South African 651502442 2 1 159 1 0 0
40 SAS* 682971852 5 0 0 6 1 110
10 Alitalia 698012498 7 2 50 4 0 0
8 Air New Zealand* 710174817 3 0 0 5 1 7
46 SWISS* 792601299 2 1 229 3 0 0
17 China Airlines 813216487 12 6 535 2 1 225
41 Saudi Arabian 859673901 7 2 313 11 0 0
7 Air India* 869253552 2 1 329 4 1 158
9 Alaska Airlines* 965346773 5 0 0 5 1 88
33 LAN Airlines 1001965891 3 2 21 0 0 0
55 Virgin Atlantic 1005248585 1 0 0 0 0 0
35 Malaysia Airlines 1039171244 3 1 34 3 2 537
28 Iberia 1173203126 4 1 148 5 0 0
2 Aeroflot* 1197672318 76 14 128 6 1 88
48 TAM 1509195646 8 3 98 7 2 188
29 Japan Airlines 1574217531 3 1 520 0 0 0
50 Thai Airways 1702802250 8 4 308 2 1 1
32 Korean Air 1734522605 12 5 425 1 0 0
11 All Nippon Airways 1841234177 3 1 1 7 0 0
5 Air Canada 1865253802 2 0 0 2 0 0
31 KLM* 1874561773 7 1 3 1 0 0
38 Qantas* 1917428984 1 0 0 5 0 0
51 Turkish Airlines 1946098294 8 3 64 8 2 84
42 Singapore Airlines 2376857805 2 2 6 2 1 83
53 US Airways / America West* 2455687887 16 7 224 11 2 23
16 Cathay Pacific* 2582459303 0 0 0 2 0 0
6 Air France 3004002661 14 4 79 6 2 337
15 British Airways* 3179760952 4 0 0 6 0 0
44 Southwest Airlines 3276525770 1 0 0 8 0 0
34 Lufthansa* 3426529504 6 1 2 3 0 0
12 American* 5228357340 21 5 101 17 3 416
20 Delta / Northwest* 6525658894 24 12 407 24 2 51
52 United / Continental* 7139291291 19 8 319 14 2 109

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
);
Powered by Datasette · Query took 43.336ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub