Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 MIA71AM098Accident · Serious injuriesClosedMooney M20F · Cleveland, TNDec 29, 1970 · N575JA · Substantial damage NTSB CHI71AC048Accident · Serious injuriesClosedBoeing 747 · Knoxville, TNDec 27, 1970 · N9898 · No damage NTSB MIA71FKW24Accident · Serious injuriesClosedSchweizer TG-3A · Eagleville, TNDec 5, 1970 · N63904 · Substantial damage NTSB MIA71DKW25Accident · No injuriesClosedAeronca 7AC · Lafayette, TNNov 30, 1970 · N84406 · Substantial damage NTSB MIA71FKW26Accident · No injuriesClosedTaylorcraft BC12-D · Jasper, TNNov 26, 1970 · N96789 · Substantial damage NTSB MIA71DKW23Accident · No injuriesClosedCessna 177 · Greenville, TNNov 21, 1970 · N30176 · Substantial damage NTSB MIA71DKW21Accident · No injuriesClosedCessna 182 · Nashville, TNNov 13, 1970 · N2557G · Substantial damage NTSB MIA71DKD11Accident · Serious injuriesClosedAeronca 65-CA · Brownsville, TNNov 10, 1970 · N34564 · Destroyed NTSB MIA71DKW22Accident · No injuriesClosedCessna 150 · Whitwell, TNNov 9, 1970 · N3211X · Substantial damage NTSB MIA71FKW20Accident · No injuriesClosedBellanca 17-30 · Crossville, TNNov 8, 1970 · N4800V · Destroyed NTSB MIA71DKW19Accident · No injuriesClosedCessna 182 · Madisonville, TNNov 7, 1970 · N4996D · Substantial damage NTSB MIA71DKD10Accident · No injuriesClosedPiper PA-28 · Millington, TNOct 30, 1970 · N5869U · Substantial damage NTSB MIA71FKW17Accident · No injuriesClosedCessna 210D · Chattanooga, TNOct 26, 1970 · N3852Y · Substantial damage NTSB MIA71FKW16Accident · No injuriesClosedCessna 150 · Lafollette, TNOct 25, 1970 · N3644J · Substantial damage NTSB MIA71FKW15Accident · Minor injuriesClosedStinson 108 · Portland, TNOct 23, 1970 · N97402 · Substantial damage NTSB MIA71DKW18Accident · No injuriesClosedPiper PA-28 · Bluff City, TNOct 19, 1970 · N98301 · Substantial damage NTSB MIA71DKW14Accident · No injuriesClosedCessna 182 · Gainsboro, TNOct 18, 1970 · N4732D · Substantial damage NTSB MIA71DKW12Accident · No injuriesClosedLuscombe 8F · Dunlap, TNSep 29, 1970 · N1949B · Substantial damage NTSB MIA71DKD08Accident · No injuriesClosedBeech T-34B · Arlington, TNSep 20, 1970 · N74894 · Substantial damage NTSB MIA71AM028Accident · 2 fatalClosedBeech 23 · Gates, TNSep 18, 1970 · N2331Q · Destroyed NTSB MIA71DKW13Accident · No injuriesClosedPiper PA-28 · Crossville, TNSep 13, 1970 · N4905L · Substantial damage NTSB MIA71FKD07Accident · No injuriesClosedCessna 177 · Savannah, TNSep 10, 1970 · N30024 · Destroyed NTSB MIA71FKW10Accident · Minor injuriesClosedCessna 190 · Maryville, TNSep 8, 1970 · N4460C · Destroyed NTSB MIA71FKW09Accident · No injuriesClosedCessna 177 · Portland, TNSep 7, 1970 · N3463T · Substantial damage NTSB MIA71FKD06Accident · Serious injuriesClosedCessna 150C · Memphis, TNSep 6, 1970 · N7831Z · Substantial damage NTSB MIA71FKW08Accident · No injuriesClosedBeech 95-55 · Chattanooga, TNSep 5, 1970 · N912Q · Substantial damage NTSB MIA71AM022Accident · 2 fatalClosedPiper PA-23 · Chattanooga, TNSep 4, 1970 · N4417P · Destroyed NTSB MIA71FKW07Accident · No injuriesClosedCessna 310L · Knoxville, TNAug 22, 1970 · N3329X · Substantial damage NTSB MIA71FKW06Accident · Serious injuriesClosedMooney M20C · Athens, TNAug 20, 1970 · N7857V · Substantial damage NTSB MIA71DKD05Accident · No injuriesClosedAeronca 11AC · Arlington, TNAug 15, 1970 · N3889E · Substantial damage NTSB MIA71AM016Accident · 2 fatalClosedHughes 269B · Memphis, TNAug 15, 1970 · N9304F · Destroyed NTSB MIA71FKW04Accident · No injuriesClosedCessna 205 · Clarksville, TNAug 2, 1970 · N4811U · Substantial damage NTSB MIA71DKW05Accident · No injuriesClosedCessna 210 · Sneedville, TNAug 1, 1970 · N9616T · Substantial damage NTSB MIA71DKD03Accident · No injuriesClosedPiper PA-25 · Bolivar, TNAug 1, 1970 · N4617Y · Substantial damage NTSB MIA71DKW03Accident · No injuriesClosedLuscombe 8A · Elizabethton, TNJul 23, 1970 · N717M · Substantial damage NTSB MIA71FKW02Accident · Minor injuriesClosedCessna 140 · Powell, TNJul 18, 1970 · N3560V · Destroyed NTSB MIA71DKW01Accident · No injuriesClosedBellanca 14-13 · Lawrenceburg, TNJul 18, 1970 · N74480 · Substantial damage NTSB MIA71DKD02Accident · No injuriesClosedCessna 150 · Millington, TNJul 14, 1970 · N6494G · Substantial damage NTSB MIA71AM006Accident · 1 fatalClosedPiper PA-28 · Hillsboro, TNJul 9, 1970 · N7223F · Destroyed NTSB MIA71FKD01Accident · No injuriesClosedSikorsky S-64E · Union City, TNJul 3, 1970 · N6962R · Substantial damage NTSB MIA70DKW13Accident · No injuriesClosedCessna 150 · Robbins, TNJun 18, 1970 · N7952Z · Substantial damage NTSB MIA70FKW08Accident · No injuriesClosedPiper PA-24 · Chattanooga, TNMay 22, 1970 · N5481P · Substantial damage NTSB MIA70DKW07Accident · No injuriesClosedCessna 150 · Madisonville, TNMay 17, 1970 · N7170X · Substantial damage NTSB MIA70FKW06Accident · Serious injuriesClosedCessna 150 · Chattanooga, TNMay 11, 1970 · N5864E · Destroyed NTSB MIA70FKW05Accident · Serious injuriesClosedGlobe GC-1B · Vonore, TNMay 11, 1970 · N3780K · Substantial damage NTSB MIA70AM085Accident · 4 fatalClosedPiper PA-28 · New Tazewell, TNApr 25, 1970 · N95354 · Destroyed NTSB MIA70FKW04Accident · No injuriesClosedStinson 108-1 · Knoxville, TNApr 4, 1970 · N8721K · Substantial damage NTSB MIA70FKW03Accident · Minor injuriesClosedCessna 150J · College Grve, TNApr 3, 1970 · N51409 · Destroyed NTSB MIA70DKD01Accident · No injuriesClosedPiper PA-25 · Bolivar, TNApr 1, 1970 · N6566Z · Substantial damage NTSB FTW70AF057Accident · 3 fatalClosedCessna 310F · Millington, TNMar 18, 1970 · N6705X · Destroyed