NTSB investigations, 1981, TN
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 1981
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") = 1981 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 ATL82FKW03Accident · Serious injuriesClosedBeech V35B · Concord, TNNTSB ATL82FKW02Accident · No injuriesClosedCessna 150 · Whitwell, TNNTSB ATL82FA013Accident · 2 fatalClosedHughes 269A · Elizabethton, TNNTSB ATL82FA012Accident · 1 fatalClosedPiper PA-28 · Powell, TNNTSB ATL82FA006Accident · 1 fatalClosedCessna A150L · Oak Ridge, TNNTSB ATL82DLT01Accident · No injuriesClosedCessna A188B · Kenton, TNNTSB ATL82DKW01Accident · No injuriesClosedPiper PA-28 · Jacksboro, TNNTSB ATL81FA115Accident · 1 fatalClosedPitts S-1 · Cleveland, TNNTSB ATL81FKW26Accident · Serious injuriesClosedTaylorcraft DCO-65 · Pleasant View, TNNTSB ATL81FKW25Accident · No injuriesClosedCessna 152 · Columbia, TNNTSB ATL81FKW24Accident · Serious injuriesClosedBensen B8 · Hixson, TNNTSB ATL81FLT15Accident · No injuriesClosedAir Tractor AT-301 · Obion, TNNTSB ATL81FKW23Accident · No injuriesClosedCessna 182G · Athens, TNNTSB ATL81FLT13Accident · Serious injuriesClosedCessna 150 · Jackson, TNNTSB ATL81FKW22Accident · No injuriesClosedCessna 210 · Winchester, TNNTSB ATL81DKW21Accident · No injuriesClosedTexas Hel M-47A · Rickman, TNNTSB ATL81FKW20Accident · Minor injuriesClosedCessna 206 · Kingsport, TNNTSB ATL81FA100Accident · 4 fatalClosedPiper PA-24 · Center Grove, TNNTSB ATL81FA099Accident · 2 fatalClosedAeronca 7AC · Rogersville, TNNTSB ATL81FA097Accident · 3 fatalClosedPiper PA-28R · Sweetwater, TNNTSB ATL81FLT12Accident · Minor injuriesClosedCessna 172 · Brownsville, TNNTSB ATL81FLT10Accident · 1 fatalClosedPitts S1S · Savannah, TNNTSB ATL81FLT09Accident · Minor injuriesClosedCessna 150 · Bolivar, TNNTSB ATL81FA079Accident · 3 fatalClosedCessna 182 · Elizabethton, TNNTSB ATL81FA072Accident · 1 fatalClosedPiper PA-30 · Smyrna, TNNTSB ATL81FLT08Accident · No injuriesClosedHughes 269C · Ridgely, TNNTSB ATL81FLT07Accident · No injuriesClosedPiper PA-25 · Pickwick Dam, TNNTSB ATL81DKW19Accident · No injuriesClosedCessna 152 · Collegedale, TNNTSB ATL81FKW18Accident · No injuriesClosedPiper PA-22 · Tullahoma, TNNTSB ATL81DKW16Accident · No injuriesClosedHughes 369D · Ashland City, TNNTSB ATL81FKW15Accident · No injuriesClosedEnstrom F-28A · Knoxville, TNNTSB ATL81FLT06Accident · No injuriesClosedGrumman G-164B · Brownsville, TNNTSB ATL81DKW14Accident · Minor injuriesClosedVolksplane 1 · Crossville, TNNTSB ATL81FKW12Accident · No injuriesClosedCessna 150F · Lebanon, TNNTSB ATL81FA048Accident · 1 fatalClosedCessna 172P · Woodbury, TNNTSB ATL81FKW11Accident · No injuriesClosedPiper PA-28 · Woodbury, TNNTSB ATL81FKW10Accident · No injuriesClosedCessna U206F · Crossville, TNNTSB ATL81FKW09Accident · Minor injuriesClosedPiper PA-32 · Nashville, TNNTSB ATL81IA037Incident · No injuriesClosedCessna 414 · Jackson, TNNTSB ATL81FA035Accident · 2 fatalClosedAeronca 11AC · Maryville, TNNTSB ATL81FKW08Accident · No injuriesClosedCessna 182RG · Sevierville, TNNTSB ATL81FKW06Accident · No injuriesClosedCessna 177RG · Nashville, TNNTSB MKC81FA012Accident · No injuriesClosedBeech F35 · Paris, TN