Skip to content

NTSB investigations, 1974, TN

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1974, 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") = 1974 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\") = 1974
    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") = 1974
  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 IAD75FKW08Accident · No injuriesClosedBeech A35 · Tullahoma, TNDec 21, 1974 · N756B · Substantial damage NTSB IAD75FLT06Accident · No injuriesClosedCessna 150 · Brunswick, TNDec 19, 1974 · N2908V · Substantial damage NTSB IAD75FLT05Accident · Minor injuriesClosedCessna 205 · Memphis, TNDec 18, 1974 · N8377Z · Substantial damage NTSB IAD75FKW07Accident · Serious injuriesClosedCessna 172 · Livingston, TNDec 18, 1974 · N1384F · Substantial damage NTSB IAD75II033Incident · No injuriesClosedCessna 310Q · Knoxville, TNNov 30, 1974 · N7548Q · 2 aircraft · Substantial damage NTSB IAD75AI034Accident · 3 fatalClosedPiper PA-28R · Toone, TNNov 30, 1974 · N5092S · Destroyed NTSB IAD75DKW05Accident · Minor injuriesClosedCessna 172 · Cleveland, TNNov 5, 1974 · N2888Q · Substantial damage NTSB IAD75AI024Accident · 1 fatalClosedCessna 150 · Johnson City, TNOct 13, 1974 · N60125 · Destroyed NTSB IAD75AI021Accident · 1 fatalClosedBoeing 75 · Somerville, TNOct 7, 1974 · N66489 · Destroyed NTSB IAD75DLQ07Accident · Minor injuriesClosedBoeing A75-N1 · Union City, TNSep 19, 1974 · N65200 · Substantial damage NTSB IAD75FKW06Accident · 1 fatalClosedCessna 172 · Twinton, TNSep 14, 1974 · N7549T · Destroyed NTSB IAD75AI012Accident · 1 fatalClosedCessna A188B · Smyrna, TNSep 13, 1974 · N53235 · Destroyed NTSB IAD75FLT04Accident · No injuriesClosedPiper PA-25 · Germantown, TNSep 2, 1974 · N7428Z · Substantial damage NTSB IAD75FLT03Accident · Serious injuriesClosedPiper PA-25 · Germantown, TNSep 2, 1974 · N7485Z · Destroyed NTSB IAD75AI008Accident · 1 fatalClosedGlobe GC-1B · Manchester, TNAug 20, 1974 · N3716K · Substantial damage NTSB IAD75AI010Accident · 2 fatalClosedBeech A24R · Wartburg, TNAug 12, 1974 · N24667 · Destroyed NTSB IAD75FKW03Accident · No injuriesClosedPiper PA-25 · Springfield, TNJul 28, 1974 · N6032Z · Substantial damage NTSB IAD75DLT02Accident · No injuriesClosedGrumman G-164A · New Castle, TNJul 22, 1974 · N6533 · Substantial damage NTSB IAD75AI001Accident · 1 fatalClosedBeech 65-90 · Knoxville, TNJul 16, 1974 · N113TC · Destroyed NTSB IAD75FKW04Accident · Minor injuriesClosedGlobe GC-1A · Tullahoma, TNJul 14, 1974 · N2450B · Destroyed NTSB IAD75FKW01Accident · Minor injuriesClosedTennie II · Smyrna, TNJul 14, 1974 · N4XX · Substantial damage NTSB IAD75DKW02Accident · No injuriesClosedPiper PA-28 · Johnson City, TNJul 14, 1974 · N5861U · Substantial damage NTSB IAD75FLT01Accident · No injuriesClosedPiper PA-25 · Selmer, TNJul 11, 1974 · N4907Y · Destroyed NTSB IAD74FLT14Accident · No injuriesClosedCessna 182K · Dyersburg, TNApr 22, 1974 · N2890R · Substantial damage NTSB IAD74DKW34Accident · No injuriesClosedCessna 150G · Surgoinsvile, TNApr 21, 1974 · N3176X · Substantial damage NTSB IAD74DKW33Accident · Minor injuriesClosedCessna 205 · Jonesboro, TNApr 18, 1974 · N8124Z · Substantial damage NTSB IAD74II055Incident · No injuriesClosedBeech G18 · Nashville, TNApr 8, 1974 · N1291N · Minor damage NTSB IAD74FKW31Accident · Minor injuriesClosedCessna 182 · Nashville, TNMar 31, 1974 · N3149R · Substantial damage NTSB IAD74DKW32Accident · No injuriesClosedBeech 23 · Oneida, TNMar 31, 1974 · N2313Q · Substantial damage NTSB IAD74DKW29Accident · No injuriesClosedCessna 175 · Nashville, TNMar 30, 1974 · N6836E · Destroyed NTSB IAD74AI043Accident · Minor injuriesClosedBeech D18S · Tullahoma, TNFeb 14, 1974 · N313A · Destroyed NTSB NYC74AN073Accident · 1 fatalClosedCessna 172 · Woodbury, TNFeb 7, 1974 · N52170 · Destroyed NTSB IAD74AI040Accident · 4 fatalClosedPiper PA-28 · Speedwell, TNFeb 3, 1974 · N4888L · Destroyed NTSB IAD74DKW25Accident · No injuriesClosedAeronca 7AC · Dayton, TNJan 30, 1974 · N83053 · Substantial damage NTSB IAD74FLT13Accident · No injuriesClosedCessna 150H · Memphis, TNJan 27, 1974 · N23321 · Substantial damage NTSB IAD74FKW24Accident · Serious injuriesClosedHiller Acft FH1100 · Knoxville, TNJan 23, 1974 · N441FH · Minor damage NTSB IAD74FLT12Accident · Minor injuriesClosedCessna A188A · Trenton, TNJan 16, 1974 · N9983G · Substantial damage NTSB IAD74FKW23Accident · No injuriesClosedPiper PA-30 · Morristown, TNJan 16, 1974 · N8030Y · Substantial damage NTSB IAD74FKW22Accident · Minor injuriesClosedAeronca L-16 · Tullahoma, TNJan 12, 1974 · N66329 · Substantial damage