Fatal NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 MIA66S0003Accident · 1 fatalClosedMooney M20E · Georgetwn, Burkina FasoNTSB FTW66S0002Accident · 2 fatalClosedErco 415-C · Saltillo, MexicoNTSB COL65AA373Accident · 4 fatalClosedCurtiss C-46 · Urrao, ColombiaNTSB UNK66X0105Accident · 1 fatalClosedBeechcraft 35 · La Pesca, MexicoNTSB UNK66X0102Accident · 2 fatalClosedMooney M20 · British Clmba, CanadaNTSB UNK65X1537Accident · 3 fatalClosedBeechcraft C-45H · Bao Trai, VMNTSB UNK65X1534Accident · 30 fatalClosedBoeing 707 121B · Montserrat Bwi, Marshall IslandsNTSB CAN65C0036Accident · 3 fatalClosedBeech B35 · Coutts Albta, CanadaNTSB UNK65X1517Accident · 1 fatalClosedPiper J-3 · Weibrsbrn, GeorgiaNTSB CAN65AF367Accident · 1 fatalClosedPiper PA-23 · Gander Nf, CanadaNTSB UNK65X1484Accident · 2 fatalClosedPiper PA-22 · Stuttgart, GeorgiaNTSB UNK65X1474Accident · 2 fatalClosedDouglas DC-3 · Waterville, CanadaNTSB MIA65S0003Accident · 1 fatalClosedBeechcraft AT-11 · Freeport, Burkina FasoNTSB UNK65X1355Accident · 4 fatalClosedCessna 336 · Mexico City, MexicoNTSB UNK65X1354Accident · 4 fatalClosedCessna 210 · Mexico City, MexicoNTSB UNK65X1299Accident · 3 fatalClosedCessna 210 · Stockholm, SWNTSB UNK65X1279Accident · 4 fatalClosedPiper PA-28 · Marheim, GeorgiaNTSB UNK65X1219Accident · 1 fatalClosedPiper PA-28 · El Fuerte, Mexico