NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 ATL81DLT02Accident · No injuriesClosedPiper PA-28R · Reelfoot Lake, TNNTSB ATL81FA024Accident · 2 fatalClosedPiper PA-30 · Sunbright, TNNTSB ATL81FA021Accident · 4 fatalClosedCessna T210N · Tazewell, TNNTSB ATL81FKW05Accident · 2 fatalClosedVarieze 1 · Signal Mt, TNNTSB ATL81IA015Incident · Serious injuriesClosedBoeing 707 · Memphis, TNNTSB ATL81FKW04Accident · Minor injuriesClosedBeech E35 · Chattanooga, TNNTSB ATL80DKW03Accident · No injuriesClosedGrumman G-164B · Portland, TNNTSB ATL81FKW02Accident · Minor injuriesClosedBell 47G · Clarksville, TNNTSB ATL80FKW01Accident · No injuriesClosedCessna 172 · Nashville, TNNTSB ATL80FKW23Accident · No injuriesClosedCessna 152 · Murfreesboro, TNNTSB ATL80FKW22Accident · No injuriesClosedQuickie 01 · Collegedale, TNNTSB ATL80DKW21Accident · No injuriesClosedChampion 7ECA · Lawrenceburg, TNNTSB ATL80DKW20Accident · No injuriesClosedPiper PA-12 · Crossville, TNNTSB ATL80DLT12Accident · No injuriesClosedPiper PA-28 · Union City, TNNTSB ATL80FKW19Accident · 1 fatalClosedErco 415-C · Nashville, TNNTSB ATL80FLT11Accident · Minor injuriesClosedPiper PA-23 · Jackson, TNNTSB ATL80FKW18Accident · Minor injuriesClosedCessna 150L · Jonesboro, TNNTSB ATL80DKW17Accident · No injuriesClosedCessna 170 · Tazewell, TNNTSB ATL80FA074Accident · 2 fatalClosedPiper PA-28R · Reliance, TNNTSB ATL80FKW16Accident · Serious injuriesClosedPiper PA-32 · Sparta, TNNTSB ATL80DKW15Accident · No injuriesClosedBell 47G-3B · Livingston, TNNTSB ATL80FA065Accident · 5 fatalClosedPiper PA-23 · Rockford, TNNTSB ATL80DKW14Accident · No injuriesClosedCessna 152 · Greenville, TNNTSB ATL80FLT08Accident · Serious injuriesClosedPitts S1A · Oakland, TNNTSB ATL80FLT07Accident · No injuriesClosedHughes 269C · Martin, TNNTSB IAD80DKW13Accident · Serious injuriesClosedCallair A9 · Centerville, TNNTSB ATL80FKW12Accident · Minor injuriesClosedCessna 206 · Mcminnville, TNNTSB IAD80FLT06Accident · No injuriesClosedGrumman G-164A · Montezuma, TNNTSB IAD80FKW11Accident · No injuriesClosedCessna 152 · Murfreesboro, TNNTSB IAD80FA034Accident · 2 fatalClosedCessna 152 · Apison, TNNTSB IAD80FLT05Accident · Serious injuriesClosedCessna 152 · Memphis, TNNTSB IAD80FA032Accident · 1 fatalClosedPiper PA-28R · Alcoa, TNNTSB IAD80FKW10Accident · Serious injuriesClosedPiper PA-32 · Gatlinburg, TNNTSB IAD80FA029Accident · 1 fatalClosedCessna 182K · Hartsville, TNNTSB IAD80FKW09Accident · 1 fatalClosedDer Jagger Wilson · Loudon, TNNTSB IAD80FKW08Accident · Serious injuriesClosedCessna 172 · Tn Ridge, TNNTSB IAD80DKW07Accident · No injuriesClosedCessna A150L · Oliver Spgs, TNNTSB IAD80FLT04Accident · Minor injuriesClosedCessna 150 · Jackson, TNNTSB IAD80FKW06Accident · No injuriesClosedSchweizer 1-26E · Benton, TNNTSB IAD80FKW05Accident · No injuriesClosedPiper PA-28 · Carryville, TNNTSB IAD80FKW04Accident · Serious injuriesClosedRaven S55A · Knoxville, TN