Skip to content

NTSB investigations, 1971, TN

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MIA72FKW12Accident · Serious injuriesClosedCessna 140 · Knoxville, TNDec 31, 1971 · N76180 · Destroyed NTSB MIA72FKW13Accident · No injuriesClosedPiper PA-24 · Brentwood, TNDec 29, 1971 · N6425P · Substantial damage NTSB MIA72FKW10Accident · No injuriesClosedBeech B95 · Rockwood, TNDec 27, 1971 · N9890R · Substantial damage NTSB MIA72DLT11Accident · No injuriesClosedRobertson 205 · Dyer, TNDec 25, 1971 · N1825Z · Substantial damage NTSB MIA72DKW11Accident · No injuriesClosedChampion 7ECA · Lafollette, TNDec 23, 1971 · N7585F · Substantial damage NTSB MIA72DLT10Accident · No injuriesClosedCessna 177 · Brownsville, TNNov 28, 1971 · N3248T · Substantial damage NTSB MIA72FKW08Accident · Minor injuriesClosedPiper PA-23 · Maloneyville, TNNov 23, 1971 · N3498P · Destroyed NTSB MIA72FKW07Accident · Minor injuriesClosedLuscombe 8A · Ducktown, TNNov 2, 1971 · N37032 · Destroyed NTSB MIA72DLT09Accident · Minor injuriesClosedAero Comdr A9B · Buena Vista, TNOct 13, 1971 · N7666V · Substantial damage NTSB MIA72FKW06Accident · No injuriesClosedPiper PA-28 · Fayetteville, TNSep 30, 1971 · N6967W · Substantial damage NTSB MIA72IM027Incident · No injuriesClosedBeech C45G · Nashville, TNSep 17, 1971 · N80323 · Minor damage NTSB MIA72FLT08Accident · No injuriesClosedPiper PA-18 · Ramer, TNSep 7, 1971 · N4091Z · Substantial damage NTSB MIA72FLT07Accident · Minor injuriesClosedCessna 172 · Humboldt, TNSep 5, 1971 · N5498R · Substantial damage NTSB MIA72FKW05Accident · Serious injuriesClosedBeech 95-C55 · Alcoa, TNAug 26, 1971 · N5726V · Destroyed NTSB MIA72FKW04Accident · No injuriesClosedPiper PA-25 · Murfreesboro, TNAug 23, 1971 · N4719Y · Substantial damage NTSB MIA72AM015Accident · 2 fatalClosedCessna 421A · Athens, TNAug 20, 1971 · N3198K · Destroyed NTSB MIA72AM012Accident · 2 fatalClosedPiper PA-23 · Hillsboro, TNAug 15, 1971 · N1358P · Destroyed NTSB MIA72FLT04Accident · Minor injuriesClosedPiper PA-25 · Pinson, TNAug 12, 1971 · N6036Z · Substantial damage NTSB MIA72FKW03Accident · No injuriesClosedCessna 172 · Gallatin, TNAug 11, 1971 · N46531 · Substantial damage NTSB MIA72AM009Accident · 1 fatalClosedBeech C-45G · Centerville, TNAug 3, 1971 · N9672C · Destroyed NTSB MIA72FKW02Accident · Minor injuriesClosedBeech A23 · Allons, TNAug 1, 1971 · N22TD · Destroyed NTSB MIA72DLT03Accident · No injuriesClosedCessna 150 · Millington, TNJul 31, 1971 · N6806G · Substantial damage NTSB MIA72FKW01Accident · No injuriesClosedCessna 172 · Elizabethton, TNJul 6, 1971 · N2800L · Substantial damage NTSB MIA71DKW55Accident · No injuriesClosedStinson L-5G · Murfreesboro, TNJun 27, 1971 · N7701B · Substantial damage NTSB MIA71DLT20Accident · No injuriesClosedPiper PA-23 · Jackson, TNJun 26, 1971 · N5979Y · Substantial damage NTSB MIA71AM110Accident · 2 fatalClosedPiper PA-28 · Murfreesboro, TNJun 9, 1971 · N5115L · Destroyed NTSB MIA71FKW54Accident · Minor injuriesClosedAero Comdr 200 · Livingston, TNJun 6, 1971 · N5502M · Destroyed NTSB MIA71DLT17Accident · No injuriesClosedTaylorcraft BC12-D · Millington, TNJun 5, 1971 · N44281 · Substantial damage NTSB MIA71FKW53Accident · Serious injuriesClosedWiggins WM-1 · Clarksville, TNJun 4, 1971 · N15W · Substantial damage NTSB MIA71FKW52Accident · No injuriesClosedHughes 269B · Chattanooga, TNMay 27, 1971 · N9326F · Substantial damage NTSB MIA71FKW51Incident · No injuriesClosedLake LA-4 · Blountville, TNMay 21, 1971 · N6679L · Minor damage NTSB MIA71FLT16Accident · Minor injuriesClosedCessna 150 · Memphis, TNMay 14, 1971 · N8301G · Substantial damage NTSB MIA71FKW50Accident · No injuriesClosedPiper PA-30 · Shelbyville, TNMay 6, 1971 · N8129Y · Substantial damage NTSB MIA71FLT14Accident · Serious injuriesClosedCessna 150 · Memphis, TNMay 4, 1971 · N6943F · Substantial damage NTSB MIA71DKW49Accident · No injuriesClosedCessna 210 · Clarksville, TNMay 2, 1971 · N6161F · Substantial damage NTSB MIA71FKW48Accident · No injuriesClosedBeech A23-19 · Athens, TNApr 23, 1971 · N5998S · Substantial damage NTSB MIA71FKW47Accident · No injuriesClosedWaco S 20522R · Chattanooga, TNApr 18, 1971 · N987WA · Substantial damage NTSB MIA71FKW46Accident · Serious injuriesClosedMooney M20F · Elizabethton, TNApr 18, 1971 · N9237M · Destroyed NTSB MIA71FKW44Accident · No injuriesClosedCessna 150 · Murfreesboro, TNApr 5, 1971 · N22651 · Substantial damage NTSB MIA71FKW45Accident · Serious injuriesClosedBensen B8M · Dayton, TNApr 4, 1971 · N3675 · Substantial damage NTSB MIA71DKW43Accident · No injuriesClosedBeech K35 · Alcoa, TNMar 31, 1971 · N9905D · Substantial damage NTSB MIA71FKW42Accident · No injuriesClosedCessna 172 · New Tazewell, TNMar 27, 1971 · N35469 · Substantial damage NTSB MIA71FKW41Accident · No injuriesClosedCessna 172 · Oliver Sprgs, TNMar 26, 1971 · N3882L · Substantial damage NTSB MIA71DKW40Accident · Serious injuriesClosedHughes 269 · Lafollette, TNMar 25, 1971 · N9421F · Destroyed NTSB MIA71AM082Accident · 1 fatalClosedMooney M20C · Knoxville, TNMar 13, 1971 · N6911N · Destroyed NTSB MIA71FKW39Accident · No injuriesClosedCessna 172K · Oneida, TNMar 6, 1971 · N79434 · Substantial damage NTSB MIA71FKD12Accident · Minor injuriesClosedPiper PA-22 · Union City, TNFeb 20, 1971 · N8630C · Destroyed NTSB MIA71DKW36Accident · No injuriesClosedCessna 150 · Murfreesboro, TNFeb 20, 1971 · N7019S · Substantial damage NTSB MIA71DKW38Accident · No injuriesClosedCessna 150 · Murfreesboro, TNFeb 18, 1971 · N22651 · Substantial damage NTSB MIA71FKW37Accident · No injuriesClosedCessna 182 · Sevierville, TNFeb 6, 1971 · N92272 · Substantial damage