Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 IAD74DLT11Accident · No injuriesClosedAero Comdr 500-A · Memphis, TNDec 27, 1973 · N6143X · Substantial damage NTSB IAD74DKW21Accident · No injuriesClosedLuscombe 8A · Morristown, TNDec 25, 1973 · N25215 · Substantial damage NTSB IAD74AI032Accident · No injuriesClosedDehavilland DH-104 · Knoxville, TNDec 6, 1973 · N10BB · Substantial damage NTSB IAD74AI031Accident · 3 fatalClosedPiper PA-28 · Jamestown, TNDec 1, 1973 · N8477W · Destroyed NTSB DCA74AZ011Accident · Serious injuriesClosedDouglas DC-9 · Chattanooga, TNNov 27, 1973 · N3323L · Destroyed NTSB IAD74II026Incident · No injuriesClosedBeech D18S · Knoxville, TNNov 14, 1973 · N3556C · Minor damage NTSB MIA74FLT03Accident · Minor injuriesClosedPiper PA-34 · Memphis, TNNov 4, 1973 · N56068 · Substantial damage NTSB IAD74AI022Accident · 2 fatalClosedCessna 150L · Gatlinburg, TNNov 2, 1973 · N99PR · Destroyed NTSB IAD74DLT10Accident · No injuriesClosedHughes 269B · Millington, TNNov 1, 1973 · N9570F · Destroyed NTSB IAD74DLT09Accident · No injuriesClosedCessna 150L · Atoka, TNNov 1, 1973 · N17227 · Destroyed NTSB IAD74FKW19Accident · Minor injuriesClosedPiper PA-28R · Knoxville, TNOct 17, 1973 · N21LK · Substantial damage NTSB IAD74DLT08Accident · No injuriesClosedPiper PA-28 · Memphis, TNOct 15, 1973 · N98182 · Substantial damage NTSB IAD74AI021Accident · 1 fatalClosedCessna 172 · Lewisburg, TNOct 13, 1973 · N7108T · Destroyed NTSB IAD74FKW18Accident · Serious injuriesClosedCessna 150H · Cleveland, TNOct 12, 1973 · N6533S · Destroyed NTSB IAD74DLT07Accident · No injuriesClosedCessna A188B · Collierville, TNOct 3, 1973 · N21710 · Substantial damage NTSB IAD74AI020Accident · No injuriesClosedLear Jet 25 · Sevierville, TNSep 24, 1973 · N777RA · Substantial damage NTSB IAD74AI019Accident · 1 fatalClosedAmer Avco AA-1B · Jackson, TNSep 22, 1973 · N9912L · Destroyed NTSB IAD74FKW16Accident · No injuriesClosedCessna 180 · Fayetteville, TNSep 8, 1973 · N5347D · Substantial damage NTSB FTW74IF013Incident · No injuriesClosedBoeing 707 · Memphis, TNSep 5, 1973 · N7595A · Minor damage NTSB IAD74DKW14Accident · No injuriesClosedPiper PA-28 · Chattanooga, TNAug 28, 1973 · N1884T · Substantial damage NTSB IAD74DLT06Accident · No injuriesClosedPiper PA-28 · Somerville, TNAug 24, 1973 · N7503R · Substantial damage NTSB IAD74DKW13Accident · Minor injuriesClosedCessna 210J · Sewanee, TNAug 22, 1973 · N3391S · Substantial damage NTSB IAD74FLT05Accident · No injuriesClosedPiper PA-23 · Memphis, TNAug 20, 1973 · N1130P · Substantial damage NTSB IAD74II011Incident · No injuriesClosedBoeing 727 · Memphis, TNAug 14, 1973 · N7279 · Minor damage NTSB IAD74FLT04Accident · No injuriesClosedPiper PA-23 · Jackson, TNAug 11, 1973 · N5163Y · Minor damage NTSB IAD74FKW12Accident · No injuriesClosedBeech 65-80 · Chattanooga, TNAug 8, 1973 · N1WF · Substantial damage NTSB IAD74II007Incident · No injuriesClosedDouglas DC-9 · Chattanooga, TNJul 31, 1973 · N3310L · Minor damage NTSB IAD74FKW09Accident · No injuriesClosedPiper PA-24 · Madison, TNJul 28, 1973 · N6258P · Substantial damage NTSB IAD74DKW11Accident · No injuriesClosedCessna 182D · Sparta, TNJul 28, 1973 · N8820X · Substantial damage NTSB IAD74DLT03Accident · No injuriesClosedOldfield GT.LKS · Tiptonville, TNJul 24, 1973 · N962 · Substantial damage NTSB IAD74DLT02Accident · Serious injuriesClosedPiper PA-25 · Brownsville, TNJul 20, 1973 · N8811L · Destroyed NTSB IAD74FKW05Accident · Minor injuriesClosedCessna 150G · Chattanooga, TNJul 14, 1973 · N4733X · Substantial damage NTSB IAD74DKW07Accident · No injuriesClosedVolksplane WE-1 · Rogersville, TNJul 14, 1973 · N2452 · Substantial damage NTSB IAD74FKW04Accident · Minor injuriesClosedPiper PA-22 · Oak Ridge, TNJul 13, 1973 · N8860C · Substantial damage NTSB IAD74DLT01Accident · No injuriesClosedCessna 140 · Arlington, TNJul 8, 1973 · N89330 · Substantial damage NTSB IAD74DKW02Accident · No injuriesClosedAmer Avco AA1 · Decatur, TNJul 4, 1973 · N5736L · Destroyed NTSB IAD73DKW01Accident · No injuriesClosedCessna 150D · Dixon Spring, TNJul 1, 1973 · N4486U · Substantial damage NTSB IAD73FLT23Accident · No injuriesClosedPiper PA-23 · Dyersburg, TNJun 30, 1973 · N2153P · Substantial damage NTSB IAD73FLT22Accident · No injuriesClosedPiper PA-25 · Silerton, TNJun 28, 1973 · N7035Z · Destroyed NTSB IAD73FLT21Accident · Minor injuriesClosedGrumman G-164A · Covington, TNJun 28, 1973 · N7964 · Substantial damage NTSB IAD73FKW29Accident · Serious injuriesClosedCessna 172 · Crossville, TNJun 28, 1973 · N84368 · Destroyed NTSB IAD74DKW03Accident · No injuriesClosedAeronca 7BCM · Gibbs Com, TNJun 24, 1973 · N2762C · Substantial damage NTSB IAD73FLT19Accident · No injuriesClosedCessna 150 · Covington, TNJun 18, 1973 · N3918J · Substantial damage NTSB IAD73DKW28Accident · No injuriesClosedBeech F33A · Elizabethton, TNJun 15, 1973 · N44SP · Substantial damage NTSB IAD73FLT18Accident · Serious injuriesClosedPiper PA-28 · Crump, TNJun 2, 1973 · N6267W · Substantial damage NTSB IAD73DLT20Accident · No injuriesClosedAeronca 7FC · Ripley, TNMay 30, 1973 · N4884E · Substantial damage NTSB IAD73FKW26Accident · No injuriesClosedCessna 210 · Athens, TNMay 20, 1973 · N1822F · Substantial damage NTSB IAD73FKW25Accident · Minor injuriesClosedCessna 150 · Stroudsville, TNMay 14, 1973 · N18672 · Substantial damage NTSB IAD73FLT16Accident · No injuriesClosedHughes 269A · Memphis, TNMay 8, 1973 · N8885F · Substantial damage NTSB IAD73II008Incident · No injuriesClosedBeech 65-80 · Jackson, TNApr 26, 1973 · N143 · Minor damage