Skip to content

NTSB investigations, 1979, TN

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1979, TN per year, 1962–2026: 2,140 cases
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

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") = 1979 AND c."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1979
    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") = 1979
  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 IAD80DKW03Accident · No injuriesClosedPiper PA-28 · Rockwood, TNDec 18, 1979 · N29218 · Substantial damage NTSB IAD80FA016Accident · 1 fatalClosedPiper PA-23 · Knoxville, TNDec 14, 1979 · N3242P · Destroyed NTSB IAD80FLT03Accident · No injuriesClosedCessna 172 · Collierville, TNDec 11, 1979 · N1184U · Substantial damage NTSB IAD80DKW02Accident · No injuriesClosedCallair A-9 · Greeneville, TNNov 6, 1979 · N8267H · Substantial damage NTSB IAD80FA007Accident · 5 fatalClosedMitsubishi MU-2F · Nashville, TNNov 1, 1979 · N873Q · Destroyed NTSB IAD80FKW01Accident · No injuriesClosedCessna 150 · Collegedale, TNOct 25, 1979 · N714BM · Substantial damage NTSB IAD80FLT01Accident · 2 fatalClosedBayles Spec 1 · Jackson, TNOct 13, 1979 · N8237E · Destroyed NTSB IAD80FA002Accident · 2 fatalClosedMooney M20J · Pikeville, TNOct 4, 1979 · N201YY · Destroyed NTSB IAD79FKW21Accident · Minor injuriesClosedMooney M-20K · Benton, TNSep 30, 1979 · N231C · Substantial damage NTSB IAD79FKW20Accident · Minor injuriesClosedLake 4-200 · Nashville, TNAug 30, 1979 · N6175V · Destroyed NTSB IAD79FA067Accident · 1 fatalClosedBenson R8M · Fayetteville, TNAug 19, 1979 · N86531 · Destroyed NTSB IAD79DLT06Accident · No injuriesClosedPiper PA-24 · Mckenzie, TNAug 4, 1979 · N5345P · Destroyed NTSB IAD79DKW19Accident · No injuriesClosedChampion 7FC · Whitebluff, TNJul 28, 1979 · N7580E · Substantial damage NTSB IAD79DKW18Accident · Minor injuriesClosedBeech A35 · Greeneville, TNJul 19, 1979 · N534B · Substantial damage NTSB IAD79FKW17Accident · Minor injuriesClosedGrumman G-164 · Crossville, TNJul 16, 1979 · N740Y · Destroyed NTSB IAD79FA062Accident · No injuriesClosedCessna 402 · Clarksville, TNJul 15, 1979 · N4009Q · 2 aircraft · Substantial damage NTSB IAD79DKW16Accident · No injuriesClosedCessna A185 · Elizabethton, TNJul 5, 1979 · N70083 · Substantial damage NTSB IAD79DLT05Accident · No injuriesClosedPiper PA-25 · Covington, TNJun 21, 1979 · N7260Z · Substantial damage NTSB IAD79FKW13Accident · No injuriesClosedCessna 177RG · Nashville, TNJun 10, 1979 · N35647 · Substantial damage NTSB IAD79FKW15Accident · Minor injuriesClosedPiper PA-22 · Dunlap, TNJun 6, 1979 · N8619C · Destroyed NTSB IAD79FKW12Accident · Serious injuriesClosedMooney M-20E · Oak Ridge, TNMay 28, 1979 · N1254X · Substantial damage NTSB IAD79FKW14Accident · No injuriesClosedSchleicher KA8B · Benton, TNMay 26, 1979 · N170DR · Destroyed NTSB IAD79DKW11Accident · No injuriesClosedCessna 172 · Cleveland, TNMay 25, 1979 · N5052H · Substantial damage NTSB IAD79FKW10Accident · Minor injuriesClosedTaylorcraft F-19 · Elk Valley, TNMay 24, 1979 · N3679T · Substantial damage NTSB IAD79FA046Accident · No injuriesClosedCessna 421 · Sevierville, TNMay 4, 1979 · N123SM · Substantial damage NTSB IAD79FKW09Accident · No injuriesClosedCessna 172 · Murfreesboro, TNApr 26, 1979 · N20388 · Substantial damage NTSB IAF79FLT04Accident · No injuriesClosedCessna 150 · Memphis, TNApr 17, 1979 · N6099G · Substantial damage NTSB IAD79FLT03Accident · No injuriesClosedGrumman G-164 · Newbern, TNApr 10, 1979 · N6604 · Substantial damage NTSB IAD79FA042Accident · 2 fatalClosedCessna 175 · Livingston, TNApr 1, 1979 · N6734E · Destroyed NTSB IAD79FKW08Accident · Serious injuriesClosedPiper PA-28 · Mcdonald, TNMar 17, 1979 · N8517F · Substantial damage NTSB IAD79FLT02Accident · No injuriesClosedPiper PA-25 · Ridgely, TNMar 9, 1979 · N4381Y · Substantial damage NTSB IAD79FKW07Accident · No injuriesClosedPiper PA-25 · Sparta, TNMar 6, 1979 · N4390Y · Destroyed NTSB IAD79AA034Accident · Minor injuriesClosedBeech 3NM · Memphis, TNFeb 24, 1979 · N12VT · 2 aircraft · Destroyed NTSB IAD79FKW06Accident · 2 fatalClosedCessna 150F · Bristol, TNFeb 20, 1979 · N8555G · Substantial damage NTSB IAD79FKW05Accident · Minor injuriesClosedPiper PA-22 · Gatlinburg, TNFeb 12, 1979 · N3649Z · Destroyed NTSB IAD79FKW04Accident · No injuriesClosedCessna 310Q · Sevierville, TNFeb 6, 1979 · N377WB · Substantial damage NTSB IAD79FA028Accident · Serious injuriesClosedPiper PA-32 · Paris, TNJan 15, 1979 · N4815S · Destroyed NTSB IAD79FKW03Accident · Minor injuriesClosedCessna 210 · Crossville, TNJan 6, 1979 · N6911R · Destroyed