NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 MIA67F0349Accident · 1 fatalClosedCessna P206A · Dyersburg, TNNTSB MIA67F0317Accident · No injuriesClosedMooney M20C · Nashville, TNNTSB MIA67A0062Accident · 1 fatalClosedAero Comdr 680 · Spring City, TNNTSB MIA67F0295Accident · No injuriesClosedBeech B50 · Nashville, TNNTSB MIA67F0268Accident · 1 fatalClosedPiper PA-28 · Whiteville, TNNTSB MIA67F0277Accident · No injuriesClosedCessna 150 · Somerville, TNNTSB MIA67F0267Accident · Serious injuriesClosedCessna 182 · Dyersburg, TNNTSB MIA67F0297Accident · No injuriesClosedLuscombe 8A · Johnson City, TNNTSB MIA67F0263Accident · Minor injuriesClosedMooney M20A · Paris, TNNTSB MIA67F0187Accident · No injuriesClosedPiper PA-28 · Chattanooga, TNNTSB MIA67D0214Accident · No injuriesClosedCessna 182E · Nashville, TNNTSB MIA67F0232Accident · No injuriesClosedPiper J-3 · Whiteville, TNNTSB MIA67F0219Accident · No injuriesClosedCessna 150 · Ashland City, TNNTSB MIA67F0235Accident · No injuriesClosedPiper PA-24 · Maryville, TNNTSB MIA67A0040Accident · 3 fatalClosedMooney M20E · Dunlap, TNNTSB MIA67F0186Accident · No injuriesClosedPiper PA-12 · Fayetteville, TNNTSB MIA67D0181Accident · Serious injuriesClosedSchleicher KA-6CR · Johnson City, TNNTSB MIA67A0032Accident · 2 fatalClosedSchweizer TG-3A · Lewisburg, TNNTSB MIA67F0166Accident · No injuriesClosedPiper PA-28 · Bristol, TNNTSB MIA67A0022Accident · 2 fatalClosedPiper PA-28 · Greenville, TNNTSB MIA67F0113Accident · No injuriesClosedBeech 95-55 · Nashville, TNNTSB MIA67D0086Accident · No injuriesClosedCessna 172 · Tiptonville, TNNTSB MIA67A0054Accident · 1 fatalClosedMooney M20C · Roan Mountn, TNNTSB MIA67F0101Accident · No injuriesClosedPiper PA-30 · Nashville, TNNTSB MIA67F0009Accident · Minor injuriesClosedPiper PA12 · Gallatin, TNNTSB MIA67A0007Accident · No injuriesClosedBell 47D1 · Powell, TNNTSB MIA67F0100Accident · Minor injuriesClosedAero Comdr 520 · Linden, TNNTSB MIA67D0013Accident · No injuriesClosedBeech A23 · Rockwood, TNNTSB MIA67D0012Accident · No injuriesClosedCessna 182G · Cleveland, TNNTSB MIA67F0002Accident · No injuriesClosedForney F1A · Mt Pleasant, TNNTSB MIA66F0593Accident · No injuriesClosedCessna 337 · Knoxville, TNNTSB MIA67F0003Accident · Minor injuriesClosedPiper PA28 · Bristol, TNNTSB MIA66F0598Accident · No injuriesClosedBeech A23 · Warrensburg, TNNTSB MIA66F0578Accident · Minor injuriesClosedPiper PA-22 · Parsons, TNNTSB MIA66D0597Accident · No injuriesClosedAeronca 7AC · Nashville, TNNTSB MIA67D0007Accident · No injuriesClosedPiper PA22 · Tullahoma, TNNTSB MIA67F0042Accident · Serious injuriesClosedPiper PA-24 · Livingston, TNNTSB MIA66D0574Accident · Minor injuriesClosedAeronca 7AC · Fayetteville, TNNTSB MIA66D0573Accident · No injuriesClosedCessna 170B · Johnson City, TNNTSB MIA66F0548Accident · Serious injuriesClosedCessna 150 · Knoxville, TNNTSB MIA66A0133Accident · 1 fatalClosedFairchild 24G · Memphis, TNNTSB MIA66F0543Accident · Serious injuriesClosedCessna 170B · Greenville, TNNTSB MIA66F0522Accident · No injuriesClosedPiper PA-24 · Nashville, TNNTSB MIA66D0517Accident · No injuriesClosedCessna 182 · Shelbyville, TNNTSB MIA66A0119Accident · Serious injuriesClosedBell 47G-2 · Lafollette, TNNTSB MIA66A0118Accident · 1 fatalClosedCessna 185A · Lafollette, TNNTSB MIA66A0115Accident · 4 fatalClosedBeech 95 · Milligan, TNNTSB MIA66D0476Accident · Minor injuriesClosedChampion 7FC · Millington, TNNTSB MIA66A0107Accident · 2 fatalClosedPiper PA-23 · Gallatin, TNNTSB MIA66F0449Accident · Minor injuriesClosedPiper PA-22 · Greenville, TN