Skip to content

NTSB investigations, 1978, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 IAD79FA023Accident · 1 fatalClosedPiper PA-34 · Blountville, TNDec 16, 1978 · N3024R · Destroyed NTSB IAD79FA021Accident · 1 fatalClosedCessna 150L · Bolivar, TNDec 4, 1978 · N1540Q · Substantial damage NTSB IAD79FKW02Accident · Serious injuriesClosedBeech A23 · Knoxville, TNDec 3, 1978 · N2308Q · Destroyed NTSB IAD79FLT01Accident · No injuriesClosedCessna 150 · Covington, TNNov 29, 1978 · N5585G · Substantial damage NTSB IAD79FA017Accident · 1 fatalClosedSwearingen SA26-T · Memphis, TNNov 22, 1978 · N2301N · Destroyed NTSB IAD79FA008Accident · 2 fatalClosedCessna 310I · Portland, TNNov 7, 1978 · N8037M · Destroyed NTSB IAD79FKW01Accident · 2 fatalClosedCessna 150G · Evensville, TNOct 28, 1978 · N3637J · Destroyed NTSB IAD79FA006Accident · 1 fatalClosedCessna 120 · Covington, TNOct 28, 1978 · N1811V · Substantial damage NTSB IAD78IA002Incident · No injuriesClosedPiper PA-30 · Selmer, TNOct 4, 1978 · N7020Y · Minor damage NTSB IAD79FA018Accident · 1 fatalClosedCessna 152 · Linden, TNOct 1, 1978 · N25955 · Destroyed NTSB IAD78FA111Accident · No injuriesClosedPiper PA-31 · Blountville, TNSep 19, 1978 · N7700L · Substantial damage NTSB IAD78FKW11Accident · Minor injuriesClosedHughes 269A · Columbia, TNSep 10, 1978 · N8808F · Substantial damage NTSB IAD78FA108Accident · 1 fatalClosedGrum Amer AA-5 · Jackson, TNSep 10, 1978 · N1375R · Destroyed NTSB IAD78DKW12Accident · No injuriesClosedMooney M20E · Coryton, TNSep 9, 1978 · N5962Q · Substantial damage NTSB IAD78FLT11Accident · No injuriesClosedCessna U206 · Memphis, TNSep 8, 1978 · N60768 · Substantial damage NTSB IAD78IA107Incident · No injuriesClosedBeech E18S · Blountville, TNSep 5, 1978 · N2070A · Minor damage NTSB IAD78FLT10Accident · Serious injuriesClosedRockwell 680F · Memphis, TNAug 22, 1978 · N680RG · Destroyed NTSB IAD78FKW10Accident · No injuriesClosedCessna 182 · Westmoreland, TNAug 9, 1978 · N735RT · Substantial damage NTSB IAD78FKW09Accident · Minor injuriesClosedLet-Np-K L-13 · Benton, TNAug 2, 1978 · N96AS · Substantial damage NTSB IAD78FLT08Accident · Minor injuriesClosedCessna 152 · Memphis, TNJul 31, 1978 · N49915 · Substantial damage NTSB IAD78FA084Accident · 1 fatalClosedCessna 172B · Selmer, TNJul 22, 1978 · N7684X · Destroyed NTSB IAD78FLT07Accident · No injuriesClosedAir Tractor AT301 · Ridgely, TNJul 18, 1978 · N4422S · Substantial damage NTSB IAD78FA087Accident · Minor injuriesClosedBell 47G2 · Pigeon Forge, TNJul 16, 1978 · N47WJ · Substantial damage NTSB IAD78FKW08Accident · No injuriesClosedCessna 172 · S.Pittsburg, TNJun 8, 1978 · N12982 · Substantial damage NTSB IAD78DA070Accident · No injuriesClosedDouglas DC-3 · Nashville, TNJun 8, 1978 · N51D · Substantial damage NTSB IAD78IA071Incident · No injuriesClosedPiper PA-32R · Chattanooga, TNJun 4, 1978 · N8929C · Minor damage NTSB IAD78FKW06Accident · Minor injuriesClosedCessna 210 · Powell, TNJun 4, 1978 · N2397F · Destroyed NTSB IAD78DLT06Accident · Serious injuriesClosedStitts SA3B · Camden, TNMay 27, 1978 · N5771 · Substantial damage NTSB IAD78FKW07Accident · Minor injuriesClosedRyan ST-3KR · Columbia, TNMay 21, 1978 · N54008 · Substantial damage NTSB DCA78AA013Accident · 6 fatalClosedSud Avtn DA-20 · Memphis, TNMay 18, 1978 · N121GW · 2 aircraft · Destroyed NTSB IAD78FA063Accident · No injuriesClosedBell 47J-2A · Memphis, TNMay 16, 1978 · N1155W · Substantial damage NTSB IAD78DKW05Accident · No injuriesClosedCessna 150 · Philadelphia, TNMay 11, 1978 · N66560 · Substantial damage NTSB IAD78FLT05Accident · No injuriesClosedHiller UH12E · Paris, TNApr 28, 1978 · N87600 · Substantial damage NTSB IAD78FA059Accident · No injuriesClosedCessna 402B · Knoxville, TNApr 11, 1978 · N6367X · Substantial damage NTSB IAD78FLT03Accident · No injuriesClosedPiper PA-18 · Tigrett, TNMar 22, 1978 · N3486Z · Destroyed NTSB IAD78FA049Accident · 4 fatalClosedCessna 177 · Maryville, TNMar 17, 1978 · N3379T · Destroyed NTSB IAD78FA043Accident · 2 fatalClosedPiper PA-22 · Camden, TNFeb 18, 1978 · N1693P · Destroyed NTSB IAD78FLT02Accident · No injuriesClosedPiper PA-28 · Tiptonville, TNJan 29, 1978 · N3666R · Substantial damage NTSB IAD78FKW04Accident · Serious injuriesClosedPiper PA-28 · Benton, TNJan 28, 1978 · N5733W · Substantial damage NTSB IAD78FA028Accident · 5 fatalClosedCessna 421B · Knoxville, TNJan 3, 1978 · N41037 · Destroyed