Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 IAD76AI044Accident · 4 fatalClosedBellanca 17-31 · Butler, TNDec 25, 1975 · N14707 · Destroyed NTSB IAD76FLT06Accident · Serious injuriesClosedErco 415-C · Parsons, TNDec 20, 1975 · N87122 · Substantial damage NTSB IAD76DKW16Accident · Minor injuriesClosedCessna 120 · Crab Orchard, TNDec 17, 1975 · N2138V · Substantial damage NTSB IAD76FKW18Accident · No injuriesClosedCessna 150 · Knoxville, TNDec 16, 1975 · N10878 · Substantial damage NTSB IAD76DKW15Accident · Serious injuriesClosedBeech A45 · Lafollette, TNDec 13, 1975 · N430JW · Substantial damage NTSB IAD76DLT05Accident · Minor injuriesClosedCessna 172 · Memphis, TNNov 16, 1975 · N7518X · Substantial damage NTSB IAD76AI033Accident · 5 fatalClosedMitsubishi MU-2K · Jefferson City, TNNov 13, 1975 · N69QJ · Destroyed NTSB IAD76II029Incident · Minor injuriesClosedDouglas DC9-32 · Knoxville, TNNov 7, 1975 · N1286L · No damage NTSB IAD76DLT0FAccident · No injuriesClosedCessna 206 · Humboldt, TNOct 17, 1975 · N8640Z · Substantial damage NTSB IAD76FKW13Accident · No injuriesClosedErco 415-C · Winchester, TNOct 4, 1975 · N87168 · Destroyed NTSB IAD76II019Incident · No injuriesClosedBoeing 737 · Bristol, TNOct 1, 1975 · N744 · No damage NTSB IAD76FKW12Accident · Serious injuriesClosedCessna 172M · Nashville, TNSep 29, 1975 · N5047R · Substantial damage NTSB IAD76FKW11Accident · 2 fatalClosedSidewinder S-9 · Portland, TNSep 15, 1975 · N2SF · Destroyed NTSB IAD76DKW10Accident · No injuriesClosedBellanca 7ECA · Knoxville, TNSep 14, 1975 · N5237X · Substantial damage NTSB IAD75FKW08Accident · Serious injuriesClosedCessna 150 · Philadelphia, TNSep 3, 1975 · N19230 · Substantial damage NTSB IAD76II014Incident · No injuriesClosedBell 47G-2 · Pigeon Forge, TNAug 29, 1975 · N6755D · Minor damage NTSB IAD76AI009Accident · 1 fatalClosedPiper PA-18 · Gallatin, TNAug 17, 1975 · N14328 · Destroyed NTSB IAD76FKW07Accident · Minor injuriesClosedCessna 172E · Townsend, TNAug 13, 1975 · N234FB · Destroyed NTSB IAD76FLT03Accident · No injuriesClosedCessna 150H · Arlington, TNAug 12, 1975 · N7082S · Substantial damage NTSB IAD7LDLT02Accident · Minor injuriesClosedGrumman G-164 · Dyersburg, TNAug 8, 1975 · N8506H · Destroyed NTSB IAD76II006Incident · No injuriesClosedDouglas DC-7 · Nashville, TNAug 4, 1975 · N6357C · Minor damage NTSB IAD76FLT01Accident · No injuriesClosedCessna 188 · Ripley, TNAug 2, 1975 · N3517Q · Destroyed NTSB IAD76FKW03Accident · No injuriesClosedCessna 170B · Lafayette, TNJul 21, 1975 · N8364A · Substantial damage NTSB IAD76FKW02Accident · No injuriesClosedCessna 337A · Lebanon, TNJul 20, 1975 · N5398S · Substantial damage NTSB IAD76II004Incident · No injuriesClosedDouglas DC-8 · Smyrna, TNJul 18, 1975 · N912CM · No damage NTSB IAD76II002Incident · No injuriesClosedCessna 150 · Nashville, TNJul 13, 1975 · N1623Q · 2 aircraft · No damage NTSB IAD76DKW01Accident · No injuriesClosedAmer Avco AA1-A · Collegedale, TNJul 3, 1975 · N9392L · Substantial damage NTSB MKC75AN124Accident · 2 fatalClosedPiper PA-28 · Coker Creek, TNJun 29, 1975 · N5571U · Destroyed NTSB IAD75DLT13Accident · Minor injuriesClosedPiper PA-28 · Bells, TNJun 29, 1975 · N7382W · Substantial damage NTSB IAD76FKW05Accident · No injuriesClosedCessna 411A · Chattanooga, TNJun 28, 1975 · N69DB · Substantial damage NTSB IAD75FKW20Accident · Minor injuriesClosedCessna 182J · Crossville, TNJun 28, 1975 · N2612F · Substantial damage NTSB IAD75FKW19Accident · No injuriesClosedCessna 150 · Crossville, TNJun 16, 1975 · N2676J · Substantial damage NTSB IAD75DKW22Accident · No injuriesClosedBlanik L-13 · Benton Tn, TNJun 9, 1975 · N90639 · Substantial damage NTSB IAD75AI062Accident · 2 fatalClosedLockheed 18 · Rockwood, TNMay 29, 1975 · N75G · Destroyed NTSB IAD75DKW18Accident · No injuriesClosedCessna 150 · Murfreesboro, TNMay 26, 1975 · N6905G · Substantial damage NTSB IAD75FLT11Accident · No injuriesClosedCessna 182A · Covington, TNMay 24, 1975 · N6063B · Substantial damage NTSB IAD76FKW17Accident · Serious injuriesClosedBell 47H1 · Nashville, TNMay 20, 1975 · N13172 · Substantial damage NTSB IAD75II061Incident · Minor injuriesClosedPiper PA-28 · Milan, TNMay 19, 1975 · N7594W · Minor damage NTSB IAD75AI060Accident · 2 fatalClosedCessna 172 · Tullahoma, TNMay 18, 1975 · N13224 · Destroyed NTSB IAD75AI059Accident · 3 fatalClosedBeech 95-B55 · Ripley, TNMay 17, 1975 · N9259Q · Destroyed NTSB IAD75FLT12Accident · Serious injuriesClosedCessna 411 · Memphis, TNMay 15, 1975 · N617JC · Destroyed NTSB IAD75FKW16Accident · No injuriesClosedPiper PA-32 · Sevierville, TNMay 13, 1975 · N44641 · Substantial damage NTSB IAD75DKW15Accident · No injuriesClosedTaylorcraft BC12-D · Pikeville, TNMay 11, 1975 · N44050 · Substantial damage NTSB IAD75FKW14Accident · No injuriesClosedCessna 150 · Columbia, TNMay 6, 1975 · N10850 · Substantial damage NTSB IAD75DLT10Accident · No injuriesClosedPiper PA-25 · Montezuma, TNApr 20, 1975 · N8649L · Destroyed NTSB IAD75FKW13Accident · No injuriesClosedBell 47H · Nashville, TNApr 1, 1975 · N981B · Substantial damage NTSB IAD75DKW11Accident · No injuriesClosedCessna 140 · Knoxville, TNApr 1, 1975 · N89687 · Substantial damage NTSB IAD75DKW12Accident · Serious injuriesClosedDehavilland DHC-3 · Winchester, TNMar 17, 1975 · N22UT · Substantial damage NTSB NYC75AN093Accident · 1 fatalClosedCessna 170 · Byrdstown, TNMar 16, 1975 · N4082V · Destroyed NTSB IAD75AI052Accident · Minor injuriesClosedAero Comdr 1121 · Tullahoma, TNMar 13, 1975 · N711JT · Substantial damage