Fatal NTSB investigations, 1973, Outside the U.S.
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1962 | 1 |
|---|---|
| 1964 | 20 |
| 1965 | 18 |
| 1966 | 15 |
| 1967 | 16 |
| 1968 | 16 |
| 1969 | 14 |
| 1970 | 14 |
| 1971 | 11 |
| 1972 | 17 |
| 1973 | 16 |
| 1974 | 11 |
| 1975 | 11 |
| 1976 | 1 |
| 1977 | 6 |
| 1978 | 11 |
| 1979 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 2 |
| 1987 | 9 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 9 |
| 1992 | 11 |
| 1993 | 11 |
| 1994 | 10 |
| 1995 | 24 |
| 1996 | 37 |
| 1997 | 37 |
| 1998 | 43 |
| 1999 | 53 |
| 2000 | 77 |
| 2001 | 66 |
| 2002 | 59 |
| 2003 | 71 |
| 2004 | 75 |
| 2005 | 97 |
| 2006 | 89 |
| 2007 | 87 |
| 2008 | 90 |
| 2009 | 90 |
| 2010 | 98 |
| 2011 | 120 |
| 2012 | 119 |
| 2013 | 124 |
| 2014 | 107 |
| 2015 | 130 |
| 2016 | 131 |
| 2017 | 133 |
| 2018 | 137 |
| 2019 | 140 |
| 2020 | 91 |
| 2021 | 107 |
| 2022 | 125 |
| 2023 | 98 |
| 2024 | 110 |
| 2025 | 109 |
| 2026 | 109 |
Latest cases
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE year(c.\"eventDate\") = 1973
AND c.\"eventCountry\" <> 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE year(c."eventDate") = 1973 AND c."eventCountry" <> 'USA' AND c."highestInjuryLevel" = 'Fatal' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB OAK74DJY09Accident · 2 fatalClosedCessna 150 · Tagaytay City, RPNTSB MIA74AM054Accident · 3 fatalClosedLake L4-200 · Bimini, Burkina FasoNTSB UNK74X0101Incident · 31 fatalClosedBoeing 707 · Rome, ItalyNTSB FTW74DRD20Accident · 2 fatalClosedCessna 182 · Mexico City, MexicoNTSB UNK74X0100Accident · 1 fatalClosedBeech D55 · Honiara, BPNTSB LAX74OL040Accident · 5 fatalClosedBeech 95-B55 · R.Buena Vista, MexicoNTSB LAX74OL033Accident · 9 fatalClosedSikorsky S-62A · Requena, PeruNTSB MIA74OKT63Accident · 10 fatalClosedNorman BN-2A · Don Don, HANTSB DCA74RZ002Accident · 78 fatalClosedBoeing 707 · Papeete, FPNTSB MIA74RM002Accident · 2 fatalClosedPiper PA-23 · Nassau, Burkina FasoNTSB FTW73DQG43Accident · 2 fatalClosedMitsubishi MU-2B · Cedillos C, MexicoNTSB MIA73RM108Accident · 1 fatalClosedPiper PA-23 · Staniel Cay, Burkina FasoNTSB MIA73RM100Accident · 2 fatalClosedLockheed L18 · Chub Cay, Burkina FasoNTSB LAX74OL025Accident · 3 fatalClosedCessna 175 · San L Gonzaga, MexicoNTSB UNK73X0111Accident · 3 fatalClosedLockheed PV-1 · Chimichagua, ColombiaNTSB MIA73RM094Accident · 1 fatalClosedBeech E18S · Grn Trtl C, Burkina Faso