NTSB investigations, 1965, TN
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 |
|---|---|
| 1963 | 2 |
| 1964 | 74 |
| 1965 | 56 |
| 1966 | 58 |
| 1967 | 58 |
| 1968 | 51 |
| 1969 | 57 |
| 1970 | 56 |
| 1971 | 58 |
| 1972 | 56 |
| 1973 | 62 |
| 1974 | 39 |
| 1975 | 56 |
| 1976 | 53 |
| 1977 | 43 |
| 1978 | 40 |
| 1979 | 38 |
| 1980 | 41 |
| 1981 | 43 |
| 1982 | 28 |
| 1983 | 41 |
| 1984 | 35 |
| 1985 | 34 |
| 1986 | 36 |
| 1987 | 37 |
| 1988 | 36 |
| 1989 | 26 |
| 1990 | 29 |
| 1991 | 26 |
| 1992 | 25 |
| 1993 | 26 |
| 1994 | 27 |
| 1995 | 38 |
| 1996 | 33 |
| 1997 | 34 |
| 1998 | 21 |
| 1999 | 28 |
| 2000 | 26 |
| 2001 | 25 |
| 2002 | 23 |
| 2003 | 35 |
| 2004 | 27 |
| 2005 | 22 |
| 2006 | 19 |
| 2007 | 23 |
| 2008 | 24 |
| 2009 | 21 |
| 2010 | 25 |
| 2011 | 23 |
| 2012 | 29 |
| 2013 | 17 |
| 2014 | 24 |
| 2015 | 24 |
| 2016 | 25 |
| 2017 | 20 |
| 2018 | 13 |
| 2019 | 24 |
| 2020 | 24 |
| 2021 | 20 |
| 2022 | 26 |
| 2023 | 26 |
| 2024 | 29 |
| 2025 | 29 |
| 2026 | 15 |
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\") = 1965
AND c.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA' 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 MIA66F0362Accident · No injuriesClosedMooney M20C · Jackson, TNNTSB MIA66F0372Accident · Minor injuriesClosedNavion A · Cumblnd City, TNNTSB MIA66D0385Accident · No injuriesClosedBellanca 14-13 · Knoxville, TNNTSB MIA66F0345Accident · Minor injuriesClosedCessna 310C · Memphis, TNNTSB MIA66F0386Accident · No injuriesClosedBeechcraft 23 · Knoxville, TNNTSB MIA66F0378Accident · No injuriesClosedPiper PA-24 · Nashville, TNNTSB MIA66F0335Accident · No injuriesClosedBeechcraft H35 · Crossville, TNNTSB MIA66F0323Accident · No injuriesClosedPiper PA-24 · Memphis, TNNTSB MIA66F0336Accident · No injuriesClosedErcoupe 415-C · Winchester, TNNTSB MIA66F0329Accident · No injuriesClosedPiper PA-28 · Columbia, TNNTSB MIA66D0322Accident · No injuriesClosedPiper PA-28 · Bolivar, TNNTSB MIA66F0334Accident · Serious injuriesClosedCessna 172D · Lake City, TNNTSB MIA66D0330Accident · No injuriesClosedPitt S-1-C · Nashville, TNNTSB MIA66D0290Accident · No injuriesClosedMooney M20B · Waverly, TNNTSB MIA66D0302Accident · No injuriesClosedPiper PA-24 · Chattanooga, TNNTSB MIA66F0291Accident · No injuriesClosedLuscombe 8A · Fayetteville, TNNTSB MIA66D0259Accident · No injuriesClosedPiper PA-22 · Tullahoma, TNNTSB MIA66F0258Accident · No injuriesClosedCessna 140 · Fayetteville, TNNTSB MIA66F0236Accident · No injuriesClosedBeechcraft 95-B55 · Nashville, TNNTSB MIA66F0204Accident · No injuriesClosedPiper PA-23 · Memphis, TNNTSB MIA66F0220Accident · 1 fatalClosedPiper PA-11 · Jackson, TNNTSB MIA66F0228Accident · No injuriesClosedCessna 210 · Dayton, TNNTSB MIA66D0234Accident · No injuriesClosedPiper PA-22 · White Pine, TNNTSB MIA66D0200Accident · No injuriesClosedAeronca 11AC · Sneedville, TNNTSB MIA66D0129Accident · No injuriesClosedCessna 182 · Nashville, TNNTSB MIA66D0141Accident · Minor injuriesClosedErcoupe 415-G · Baxter, TNNTSB MIA66D0120Accident · No injuriesClosedPiper PA-22 · Memphis, TNNTSB MIA66D0117Accident · No injuriesClosedPiper PA-12 · Murfreesboro, TNNTSB MIA66D0125Accident · No injuriesClosedAeronca 7AC · Athens, TNNTSB MIA66A0012Accident · 1 fatalClosedStinson 108-3 · Oliver Sprgs, TNNTSB MIA66F0161Accident · No injuriesClosedBeechcraft E-35 · Pressman Home, TNNTSB MIA66D0062Accident · No injuriesClosedCessna 150D · Columbia, TNNTSB MIA66F0081Accident · No injuriesClosedPiper PA-28 · Gallatin, TNNTSB MIA66F0080Accident · Minor injuriesClosedCessna 150 · Tiptonville, TNNTSB MIA66F0078Accident · No injuriesClosedPiper PA-30 · Shelbyville, TNNTSB MIA66F0045Accident · 1 fatalClosedCessna 210-5 · Del Rio, TNNTSB MIA66F0041Accident · No injuriesClosedBeechcraft B33 · Powell, TNNTSB MIA66D0043Accident · Minor injuriesClosedCessna 140 · Chattanooga, TNNTSB MIA66F0133Accident · No injuriesClosedPiper PA-28 · Ooltewah, TNNTSB MIA65F0124Accident · Serious injuriesClosedCessna 172 · Rutherford, TNNTSB MIA65A0117Accident · 3 fatalClosedPiper PA-24 · Chattanooga, TNNTSB MIA65F0123Accident · No injuriesClosedPiper J3L · Chattanooga, TNNTSB MIA65F0096Accident · No injuriesClosedCessna 337 · Alcoa, TNNTSB MIA66D0238Accident · No injuriesClosedBeechcraft C-35 · Mcminnville, TNNTSB MIA65D0074Accident · No injuriesClosedCessna 140 · Knoxville, TNNTSB MIA65F0053Accident · No injuriesClosedPiper PA-28 · Memphis, TNNTSB MIA65D0045Accident · No injuriesClosedPiper PA-25 · Trenton, TNNTSB MIA65F0040Accident · No injuriesClosedPiper PA-22 · Lavinia, TNNTSB MIA65F0050Accident · No injuriesClosedCessna 182 · Murfreesboro, TNNTSB MIA65F0025Accident · No injuriesClosedPiper PA-24 · Knoxville, TN