Skip to content

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 IAD78FA024Accident · Minor injuriesClosedCessna 150 · Arlington, TNDec 22, 1977 · N6431K · 2 aircraft · Substantial damage NTSB IAD78FA018Accident · 2 fatalClosedCessna 172H · Dickson, TNDec 4, 1977 · N75923 · Destroyed NTSB IAD78FA017Accident · 2 fatalClosedCessna 172H · Cades Cove, TNDec 1, 1977 · N8821Z · Destroyed NTSB IAD78DKW03Accident · No injuriesClosedCessna 150 · Johnson City, TNOct 31, 1977 · N63074 · Substantial damage NTSB IAD78DKW02Accident · No injuriesClosedCessna 414 · Oneida, TNOct 28, 1977 · N1603T · Substantial damage NTSB IAD78FA006Accident · 1 fatalClosedPiper J-3 · Pulaski, TNOct 22, 1977 · N98067 · Destroyed NTSB IAD78FLT01Accident · Minor injuriesClosedCessna 172 · Covington, TNOct 13, 1977 · N79322 · Substantial damage NTSB IAD78FA003Accident · 1 fatalClosedBellanca 7GCBC · Sparta, TNOct 10, 1977 · N10988 · Destroyed NTSB IAD78FKW01Accident · Minor injuriesClosedCessna 150 · Spring Hill, TNOct 2, 1977 · N5848E · Destroyed NTSB IAD77FA068Accident · 2 fatalClosedCessna 210L · Smithville, TNSep 25, 1977 · N2199S · Destroyed NTSB IAD77FKW29Accident · Serious injuriesClosedAero Comdr 100 · Clifton, TNSep 6, 1977 · N3681X · Destroyed NTSB IAD77FA064Accident · 2 fatalClosedPiper PA-28 · Harriman, TNSep 5, 1977 · N32044 · Destroyed NTSB IAD77DKW30Accident · No injuriesClosedSchleicher KA6CR · Benton, TNSep 4, 1977 · N201V · Minor damage NTSB IAD77DKW28Accident · No injuriesClosedCessna 188 · Charlotte, TNAug 30, 1977 · N5525S · Substantial damage NTSB IAD77FLT06Accident · Serious injuriesClosedCessna 150H · Millington, TNAug 24, 1977 · N23321 · Destroyed NTSB IAD77DLT05Accident · No injuriesClosedPiper PA-25 · Trimble, TNAug 23, 1977 · N8945L · Substantial damage NTSB IAD77FKW27Accident · Serious injuriesClosedBell 47G2A · Jamestown, TNAug 15, 1977 · N2880B · Substantial damage NTSB IAD77DKW26Accident · No injuriesClosedCessna 172 · Beersheba Spgs, TNAug 13, 1977 · N4295F · Substantial damage NTSB IAD77DKW25Accident · No injuriesClosedBell 206L · Knoxville, TNAug 4, 1977 · N970CR · Substantial damage NTSB IAD77FA055Accident · 1 fatalClosedBoeing A75N-1 · Union City, TNAug 2, 1977 · N46998 · Destroyed NTSB IAD77FKW24Accident · Minor injuriesClosedPiper PA-22 · Pulaski, TNJul 29, 1977 · N3159Z · Destroyed NTSB IAD78FA010Accident · 1 fatalClosedStinson 108-3 · Knoxville, TNJul 27, 1977 · N6734M · Destroyed NTSB IAD77DKW23Accident · No injuriesClosedCessna 150 · Celina, TNJul 27, 1977 · N3155V · Substantial damage NTSB IAD77IA052Incident · No injuriesClosedBoeing 727 · Memphis, TNJul 13, 1977 · N9278 · Minor damage NTSB IAD78FA079Accident · Serious injuriesClosedCessna 421 · Nashville, TNJul 8, 1977 · N1504G · Destroyed NTSB IAD77FKW21Accident · No injuriesClosedGrumman G-164B · Dunlap, TNJun 25, 1977 · N48668 · Substantial damage NTSB IAD77FKW20Accident · 2 fatalClosedCessna 172 · Midtown Commun, TNJun 18, 1977 · N7129A · Destroyed NTSB IAD77DKW19Accident · Minor injuriesClosedCessna 150 · Center Hill Lk, TNJun 11, 1977 · N6098K · Destroyed NTSB IAD77DLT04Accident · No injuriesClosedCessna 180 · Centennial Isl, TNJun 6, 1977 · N25NW · Substantial damage NTSB IAD77FKW18Accident · Serious injuriesClosedBeech 58P · Knoxville, TNMay 2, 1977 · N6039S · Substantial damage NTSB IAD77FA035Accident · 1 fatalClosedBeech C23 · Knoxville, TNApr 19, 1977 · N9224S · Destroyed NTSB IAD77DKW17Accident · No injuriesClosedBeech 35 · Sewanee, TNApr 11, 1977 · N3195V · Substantial damage NTSB IAD77DLT03Accident · No injuriesClosedRaven RX6 · Huntingdon, TNApr 10, 1977 · N1035R · Substantial damage NTSB IAD77FA032Accident · 4 fatalClosedPiper PA-28 · Powell, TNMar 26, 1977 · N8690W · Destroyed NTSB IAD77FLT02Accident · No injuriesClosedBellanca 14-13 · Parsons, TNFeb 25, 1977 · N86841 · Substantial damage NTSB IAD77DKW16Accident · No injuriesClosedPiper PA-24 · Greenville, TNFeb 25, 1977 · N5349P · Substantial damage NTSB IAD77FKW15Accident · No injuriesClosedCessna 150 · Gallatin, TNFeb 21, 1977 · N10858 · Substantial damage NTSB IAD77FLT01Accident · Serious injuriesClosedPiper PA-28 · Tiptonville, TNFeb 20, 1977 · N5305W · Substantial damage NTSB IAD77DKW14Accident · Minor injuriesClosedCessna 177 · Lafayette, TNFeb 16, 1977 · N43980 · Destroyed NTSB IAD77FKW13Accident · No injuriesClosedCessna 172 · Jamestown, TNFeb 11, 1977 · N4028F · Substantial damage NTSB IAD77FA019Accident · 3 fatalClosedPiper PA30 · Dyersburg, TNJan 29, 1977 · N8719Y · Destroyed NTSB IAD77FA018Accident · 2 fatalClosedCessna 177RG · Chattanooga, TNJan 29, 1977 · N7506V · Destroyed NTSB IAD77FKW12Accident · No injuriesClosedPiper PA28 · Crossville, TNJan 13, 1977 · N5884W · Substantial damage