NTSB investigations, 1964, TN
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1964
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") = 1964 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 UNK65X1193Accident · 5 fatalClosedPiper PA-22 · Pelham, TNNTSB UNK65X1187Accident · Minor injuriesClosedPiper J3C · Roellen, TNNTSB UNK65X0966Accident · No injuriesClosedLuscombe 8A · Tullahoma, TNNTSB UNK65X0939Accident · No injuriesClosedBeechraft 35 · Knoxville, TNNTSB UNK65X0843Accident · 1 fatalClosedCessna 172 · Troy, TNNTSB UNK65X0776Accident · No injuriesClosedBeechcraft H18 · Knoxville, TNNTSB UNK65X0748Accident · No injuriesClosedPiper PA22 · Cookeville, TNNTSB UNK65X0678Accident · No injuriesClosedBoeing 707 123B · Nashville, TNNTSB UNK65X0654Accident · No injuriesClosedPiper PA22 · Sanburg, TNNTSB UNK65X0648Accident · No injuriesClosedCessna 150 · Johnson City, TNNTSB UNK65X0603Accident · 2 fatalClosedBeechcraft 23 · Grd Junction, TNNTSB UNK65X0546Accident · Serious injuriesClosedPiper PA22 · Gleason, TNNTSB UNK65X0542Accident · No injuriesClosedCessna 210 · Knoxville, TNNTSB UNK65X0500Accident · No injuriesClosedStinson 108-3 · Sewanee, TNNTSB UNK65X0479Accident · 3 fatalClosedBeechcraft C-50 · Shelbyville, TNNTSB UNK65X0258Accident · No injuriesClosedPiper PA24 · Murfreesburg, TNNTSB UNK65X0250Accident · 1 fatalClosedTaylorcraft BC12D · Savannah, TNNTSB UNK65X0194Accident · No injuriesClosedGlobe GC1B · Powell, TNNTSB UNK65X0120Accident · No injuriesClosedCessna 182 · Celina, TNNTSB UNK64X3977Accident · Serious injuriesClosedPiper J3C · Jonesboro, TNNTSB UNK64X3971Accident · No injuriesClosedBeechcraft 65-80 · Seward Afb, TNNTSB UNK64X3787Accident · No injuriesClosedPiper J3 · Rock Is, TNNTSB UNK64X3698Accident · No injuriesClosedPiper J3 · Chattanooga, TNNTSB UNK64X3401Accident · Serious injuriesClosedCessna 172 · Crossville, TNNTSB UNK64X3299Accident · No injuriesClosedCessna 150 · Columbia, TNNTSB UNK64X3279Accident · No injuriesClosedCessna 120 · Portland, TNNTSB UNK64X3272Accident · No injuriesClosedNavion · Memphis, TNNTSB UNK64X3232Accident · No injuriesClosedPiper PA23 · Memphis, TNNTSB UNK64X3140Accident · 2 fatalClosedBeechcraft 35-B33 · Nashville, TNNTSB UNK64X3107Accident · No injuriesClosedBeechcraft K35 · Humboldt, TNNTSB UNK64X3080Accident · 1 fatalClosedPiper J3C-65 · Springfield, TNNTSB UNK64X3012Accident · Minor injuriesClosedCessna 150 · Ducktown, TNNTSB UNK64X2976Accident · Minor injuriesClosedStinson 108 · Madison, TNNTSB UNK64X2822Accident · No injuriesClosedCessna 175A · Memphis, TNNTSB UNK64X2742Accident · 39 fatalClosedViscount 745D · Parrotsville, TNNTSB UNK64X2722Accident · 1 fatalClosedCaravelle · Knoxville, TNNTSB UNK64X2419Accident · Minor injuriesClosedAeronca 7AC · Sharon, TNNTSB UNK64X2414Accident · No injuriesClosedPiper PA11 · Lawrenceburg, TNNTSB UNK64X2405Accident · Serious injuriesClosedTaylorcraft BC12D · Oneida, TNNTSB UNK64X2320Accident · 2 fatalClosedCessna 175 · Clarksville, TNNTSB UNK64X2297Accident · No injuriesClosedCessna 210 · Centerville, TNNTSB UNK64X2186Accident · No injuriesClosedBeechraft B23 · Chuckey, TNNTSB UNK64X2122Accident · No injuriesClosedCessna 182 · Clarksville, TNNTSB UNK64X2111Accident · Minor injuriesClosedPiper PA22 · Covington, TNNTSB UNK64X2072Accident · No injuriesClosedCessna 310C · Lexington, TNNTSB UNK64X2056Accident · No injuriesClosedBeechcraft D-18S · Memphis, TNNTSB UNK64X2034Accident · No injuriesClosedCessna 182C · Chattanooga, TNNTSB UNK64X1895Accident · No injuriesClosedPiper PA28 · Madison, TNNTSB UNK64X1771Accident · No injuriesClosedCessna 150 · Clarkrange, TNNTSB UNK64X1737Accident · No injuriesClosedBeechcraft 35 · Athens, TN