Skip to content

NTSB investigations, 1972, 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, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MIA73FKW14Accident · No injuriesClosedPiper PA-28 · Chuckey, TNDec 31, 1972 · N8032W · Substantial damage NTSB MIA73AM067Accident · 2 fatalClosedCessna 150H · Beechgrove, TNDec 25, 1972 · N22545 · Destroyed NTSB MIA73DKW13Accident · Minor injuriesClosedCessna 182B · Gainesboro, TNDec 12, 1972 · N2491G · Substantial damage NTSB MIA73DKW12Accident · No injuriesClosedCessna 172G · Waverly, TNDec 1, 1972 · N5965R · Substantial damage NTSB MIA73AM058Accident · 3 fatalClosedBeech G35 · Nashville, TNNov 27, 1972 · N4548D · Destroyed NTSB MIA73DKW11Accident · Serious injuriesClosedCessna 177 · Flagpond, TNNov 25, 1972 · N2360Y · Substantial damage NTSB MIA73FLT12Accident · Serious injuriesClosedPiper PA-30 · Memphis, TNNov 6, 1972 · N7684Y · Destroyed NTSB MIA73DLT13Accident · No injuriesClosedGrumman G-164 · Wynnburg, TNNov 6, 1972 · N493Y · Substantial damage NTSB MIA73DLT11Accident · No injuriesClosedHughes 269B · Millington, TNNov 1, 1972 · N9468F · Substantial damage NTSB MIA73DKW10Accident · No injuriesClosedPiper PA-24 · Kingston, TNOct 22, 1972 · N119Q · Substantial damage NTSB MIA73AM042Accident · 2 fatalClosedCessna 150L · Eads, TNOct 16, 1972 · N18142 · Destroyed NTSB MIA73AM040Accident · 3 fatalClosedCessna 172K · Oliver Spgs, TNOct 13, 1972 · N79433 · Destroyed NTSB MIA73FKW09Accident · No injuriesClosedCessna 337G · Knoxville, TNOct 4, 1972 · N1826M · Substantial damage NTSB MIA73DLT10Accident · No injuriesClosedCessna 172 · Stantonville, TNOct 1, 1972 · N9167B · Substantial damage NTSB MIA73FLT08Accident · 1 fatalClosedPiper PA-25 · Newbern, TNSep 27, 1972 · N6306Z · Destroyed NTSB MIA73FLT07Accident · No injuriesClosedCessna 150K · Memphis, TNSep 27, 1972 · N5772G · Substantial damage NTSB MIA73FLT05Accident · No injuriesClosedCessna 150F · Memphis, TNSep 23, 1972 · N8279S · Substantial damage NTSB MIA73DLT04Accident · No injuriesClosedPiper PA-25 · Jackson, TNSep 15, 1972 · N4747Y · Substantial damage NTSB MIA73DKW08Accident · No injuriesClosedVolmer Jnsn VJ-22 · Nashville, TNSep 7, 1972 · N2416 · Substantial damage NTSB MIA73FKW06Accident · Minor injuriesClosedCessna 172 · Morristown, TNAug 31, 1972 · N7854T · Substantial damage NTSB MIA73FKW05Accident · No injuriesClosedCessna 182N · Gatlinburg, TNAug 23, 1972 · N7265G · Substantial damage NTSB MIA73AM014Accident · 5 fatalClosedCessna 421 · Cleveland, TNAug 7, 1972 · N123QF · Destroyed NTSB MIA73AM012Accident · 1 fatalClosedPiper PA-22 · N.Johsnville, TNJul 26, 1972 · N4525Z · Destroyed NTSB CHI73AC008Accident · Serious injuriesClosedConvair 880 · Knoxville, TNJul 22, 1972 · N8810E · No damage NTSB MIA73DKW04Accident · No injuriesClosedCessna 172 · Clarksville, TNJul 16, 1972 · N1705F · Substantial damage NTSB MIA73DLT01Accident · Serious injuriesClosedCessna 150 · Milan, TNJul 14, 1972 · N2940J · Substantial damage NTSB MIA73FKW02Accident · No injuriesClosedCessna 337 · Alcoa, TNJul 11, 1972 · N86118 · Substantial damage NTSB MIA73FKW01Accident · No injuriesClosedGreat Lakes 2T-1A · Chattanooga, TNJul 9, 1972 · N828K · Substantial damage NTSB MIA73FKW03Accident · No injuriesClosedBeech 56TC · Springfield, TNJul 8, 1972 · N3792Q · Substantial damage NTSB MIA72DLT16Accident · Minor injuriesClosedPiper PA-25 · Trimble, TNJun 29, 1972 · N4837Y · Destroyed NTSB MIA72DKW31Accident · No injuriesClosedCessna 210 · Elizabethton, TNJun 26, 1972 · N6198R · Substantial damage NTSB MIA72AM140Accident · 1 fatalClosedAmer Avco AA-1 · Byrdstown, TNJun 23, 1972 · N101FT · Destroyed NTSB MIA72AM137Accident · 1 fatalClosedRyan PT-22 · Arlington, TNJun 17, 1972 · N47554 · Destroyed NTSB MIA72AM132Accident · 1 fatalClosedBeech D18S · Nashville, TNJun 10, 1972 · N7526 · Substantial damage NTSB MIA72FKW30Accident · Serious injuriesClosedCessna 172F · Pulaski, TNJun 9, 1972 · N7823U · Substantial damage NTSB MIA72DKW29Accident · No injuriesClosedChampion 7ECA · Concord, TNMay 24, 1972 · N5188X · Substantial damage NTSB MIA72FKW28Accident · No injuriesClosedPiper J3C-65 · Elizabethton, TNMay 23, 1972 · N98429 · Substantial damage NTSB MIA72FKW27Accident · No injuriesClosedPiper PA-25 · Athens, TNMay 20, 1972 · N7091Z · Destroyed NTSB MIA72FKW26Accident · Serious injuriesClosedPiper PA-32 · Smithville, TNMay 7, 1972 · N4842S · Destroyed NTSB MIA72DKW25Accident · No injuriesClosedCessna 150G · Rogersville, TNApr 29, 1972 · N8595J · Substantial damage NTSB MIA72FKW24Accident · Minor injuriesClosedCessna 150L · Hixson, TNApr 21, 1972 · N1785Q · Destroyed NTSB MIA72AM103Accident · 2 fatalClosedMooney M20A · Memphis, TNMar 29, 1972 · N6062X · Destroyed NTSB MIA72AM101Accident · 4 fatalClosedSwearingen SA26AT · Nashville, TNMar 28, 1972 · N4111X · Destroyed NTSB MIA72DKW22Accident · No injuriesClosedBeech G35 · Smyrna, TNMar 3, 1972 · N4548D · Substantial damage NTSB MIA72FLT12Accident · Serious injuriesClosedCessna 150 · Yorkville, TNFeb 28, 1972 · N6532F · Destroyed NTSB MIA72DKW19Accident · No injuriesClosedCessna 421B · Nashville, TNFeb 23, 1972 · N8084Q · Substantial damage NTSB MIA72DKW18Accident · No injuriesClosedBeech G35 · Sevierville, TNFeb 19, 1972 · N4665D · Substantial damage NTSB MIA72AM080Accident · 2 fatalClosedCessna 182D · Morrison, TNFeb 13, 1972 · N9044X · Destroyed NTSB MIA72DKW17Accident · Serious injuriesClosedPiper PA-28 · Dunlap, TNFeb 10, 1972 · N95122 · Destroyed NTSB MIA72DKW15Accident · No injuriesClosedBeech C35 · Copperhill, TNFeb 5, 1972 · N5902C · Substantial damage