NTSB investigations, 1964
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 | 72 |
|---|---|
| 1963 | 78 |
| 1964 | 5,253 |
| 1965 | 5,377 |
| 1966 | 5,912 |
| 1967 | 6,339 |
| 1968 | 5,199 |
| 1969 | 5,027 |
| 1970 | 4,915 |
| 1971 | 4,825 |
| 1972 | 4,430 |
| 1973 | 4,398 |
| 1974 | 4,565 |
| 1975 | 4,403 |
| 1976 | 4,314 |
| 1977 | 4,412 |
| 1978 | 4,624 |
| 1979 | 4,165 |
| 1980 | 3,921 |
| 1981 | 3,836 |
| 1982 | 3,545 |
| 1983 | 3,514 |
| 1984 | 3,405 |
| 1985 | 3,055 |
| 1986 | 2,831 |
| 1987 | 2,774 |
| 1988 | 2,685 |
| 1989 | 2,502 |
| 1990 | 2,479 |
| 1991 | 2,419 |
| 1992 | 2,328 |
| 1993 | 2,283 |
| 1994 | 2,229 |
| 1995 | 2,281 |
| 1996 | 2,150 |
| 1997 | 2,121 |
| 1998 | 2,195 |
| 1999 | 2,175 |
| 2000 | 2,183 |
| 2001 | 2,031 |
| 2002 | 2,000 |
| 2003 | 2,062 |
| 2004 | 1,930 |
| 2005 | 2,001 |
| 2006 | 1,826 |
| 2007 | 1,984 |
| 2008 | 1,882 |
| 2009 | 1,783 |
| 2010 | 1,786 |
| 2011 | 1,848 |
| 2012 | 1,834 |
| 2013 | 1,561 |
| 2014 | 1,534 |
| 2015 | 1,581 |
| 2016 | 1,662 |
| 2017 | 1,635 |
| 2018 | 1,687 |
| 2019 | 1,626 |
| 2020 | 1,396 |
| 2021 | 1,645 |
| 2022 | 1,700 |
| 2023 | 1,678 |
| 2024 | 1,693 |
| 2025 | 1,655 |
| 2026 | 1,342 |
Where
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\") = 1964 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") = 1964 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 UNK65X1205Accident · No injuriesClosedBrantly B2 · Peck, IDNTSB UNK65X1204Accident · No injuriesClosedCessna 182 · Benton, PANTSB UNK65X1203Accident · 2 fatalClosedPiper PA24 · Cushing, OKNTSB UNK65X1202Accident · Serious injuriesClosedMooney MK-20D · Vandalia, OHNTSB UNK65X1201Accident · No injuriesClosedPiper PA-24 · Apple Valley, CANTSB UNK65X1200Accident · Minor injuriesClosedNavion A · Lorain, OHNTSB UNK65X1199Accident · No injuriesClosedCessna 180 · Rice Lake, WINTSB UNK65X1198Accident · No injuriesClosedCessna 182 · Houston, TXNTSB UNK65X1197Accident · No injuriesClosedBeechraft T34B · Jacksonville, FLNTSB UNK65X1196Accident · No injuriesClosedPiper PA28 · Aberdeen, OHNTSB UNK65X1195Accident · No injuriesClosedPiper PA24 · El Reno, OKNTSB UNK65X1194Accident · No injuriesClosedAero Cmdr 560E · Laconia, NHNTSB LAX65A0058Accident · 2 fatalClosedBeechcraft T34A · Wrightwood, CANTSB UNK65X1193Accident · 5 fatalClosedPiper PA-22 · Pelham, TNNTSB UNK65X1192Accident · 3 fatalClosedCessna 182E · Ventura, CANTSB UNK65X1191Accident · 4 fatalClosedPiper PA-28 · Gorman, CANTSB UNK65X1190Accident · Serious injuriesClosedAero Comdr 520 · Miami Beach, FLNTSB UNK65X1189Accident · 4 fatalClosedCurtis-Writ C-46A · Detroit, MINTSB UNK65X1188Accident · Minor injuriesClosedConvair CV-340 · Saugus, CANTSB UNK65X1187Accident · Minor injuriesClosedPiper J3C · Roellen, TNNTSB MIA65D0013Accident · No injuriesClosedBeechraft F35 · Ponce, PRNTSB UNK65X1186Incident · No injuriesClosedDouglas DC-8 · Newark, NJNTSB UNK65X1185Accident · 1 fatalClosedGlobe GC1B · Mt Vernon, ARNTSB UNK65X1184Accident · No injuriesClosedTaylorcraft DCO · Vinita, OKNTSB UNK65X1183Accident · Serious injuriesClosedPiper PA-28 · North Bend, WANTSB UNK65X1182Accident · Serious injuriesClosedStinson 108-3 · Van Nuys, CANTSB UNK65X1181Accident · Minor injuriesClosedPiper PA17 · Strandburg, SDNTSB UNK65X1180Accident · No injuriesClosedPiper PA28 · Morgantown, WVNTSB UNK65X1179Accident · No injuriesClosedDehaviland DH104 · Nashua, NHNTSB UNK65X1178Accident · Serious injuriesClosedTempco D-16 · Madison, MSNTSB UNK65X1177Accident · 1 fatalClosedHeadskinner SJ-1 · Magnolia, OHNTSB UNK65X1176Accident · 2 fatalClosedPiper PA-28 · Terry, MTNTSB UNK65X1175Accident · No injuriesClosedBeechraft 35 · Raleigh, NCNTSB UNK65X1174Accident · No injuriesClosedAeronca 7FC · Oswego, ILNTSB UNK65X1173Accident · Serious injuriesClosedCessna 205 · Littleton, CONTSB UNK65X1172Accident · No injuriesClosedPiper PA-24 · Opelousas, LANTSB UNK65X1171Accident · No injuriesClosedCessna 182F · Duchesne, UTNTSB UNK65X1170Accident · No injuriesClosedNavion A · Spanish Fork, UTNTSB UNK65X1169Accident · No injuriesClosedBeechraft P35 · Allegan, MINTSB UNK65X1168Accident · No injuriesClosedBeechraft D35 · San Diego, CANTSB UNK65X1167Accident · No injuriesClosedCessna 210 · Houston, TXNTSB UNK65X1166Accident · 1 fatalClosedPiper PA-28 · King Salmon, AKNTSB UNK65X1165Accident · No injuriesClosedMooney M20D · Dallas, TXNTSB UNK65X1164Accident · 5 fatalClosedCessna 182G · Boulder Creek, CANTSB UNK65X1163Accident · 1 fatalClosedCessna 150C · Tallahassee, FLNTSB UNK65X1162Accident · No injuriesClosedCessna 195 · Miami, FLNTSB UNK65X1161Accident · Serious injuriesClosedCessna 172 · Swan Valley, IDNTSB UNK65X1160Accident · No injuriesClosedPiper PA28 · Wichita, KSNTSB UNK65X1159Accident · No injuriesClosedCessna 150 · Cushing, OKNTSB UNK65X1158Accident · No injuriesClosedBeechraft AT11 · Kansas City, MO