fivethirtyeight: airline-safety/airline-safety: 56 rows

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

56 rows

descending

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

Advanced export

JSON shape: default, array, newline-delimited

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

Airline Safety: airline-safety.csv

56 rows

Advanced export