Skip to content

NTSB investigations, 1969, TN

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 MIA70F0282Accident · No injuriesClosedPiper PA-12 · Crossville, TNDec 29, 1969 · N2301M · Substantial damage NTSB MIA70F0277Accident · No injuriesClosedPiper PA-28 · Byrdstown, TNDec 27, 1969 · N5022W · Substantial damage NTSB MIA70D0270Accident · Minor injuriesClosedCessna 150 · Spring City, TNDec 26, 1969 · N60192 · Destroyed NTSB MIA70A0049Accident · 1 fatalClosedPiper PA-30 · Crossville, TNDec 23, 1969 · N7884Y · Destroyed NTSB MIA70I0047Incident · No injuriesClosedDouglas DC-9 · Nashville, TNDec 14, 1969 · N974VJ · Minor damage NTSB MIA70A0048Accident · 1 fatalClosedCessna 210B · Mountain Cty, TNDec 11, 1969 · N38T · Destroyed NTSB MIA70D0243Accident · No injuriesClosedCessna 170A · Memphis, TNDec 8, 1969 · N5514C · Substantial damage NTSB MIA70D0234Accident · No injuriesClosedCessna 150G · Cookeville, TNNov 30, 1969 · N6307S · Substantial damage NTSB MIA70F0241Accident · Serious injuriesClosedAeronca 0-58B · Conasauga, TNNov 29, 1969 · N46680 · Substantial damage NTSB MIA70F0229Accident · No injuriesClosedCessna 195 · Nashville, TNNov 13, 1969 · N999V · Substantial damage NTSB MIA70F0230Accident · No injuriesClosedPiper PA-31 · Alcoa, TNOct 25, 1969 · N515JH · Substantial damage NTSB MIA70F0203Accident · No injuriesClosedGlobe GC-1B · Gallatin, TNOct 4, 1969 · N2424B · Substantial damage NTSB MIA70F0195Accident · Serious injuriesClosedBoeing E-75 · Milan, TNOct 2, 1969 · N5058V · Destroyed NTSB MIA70F0159Accident · No injuriesClosedGrumman 164A · Barretville, TNOct 2, 1969 · N5289 · Substantial damage NTSB MIA70D0194Accident · No injuriesClosedCessna 210 · Millington, TNSep 25, 1969 · N7424E · Substantial damage NTSB MIA70F0135Accident · No injuriesClosedCessna 150 · Knoxville, TNSep 20, 1969 · N3262J · Substantial damage NTSB MIA70F0129Accident · No injuriesClosedPiper PA-28 · Blountville, TNSep 14, 1969 · N98301 · Substantial damage NTSB MIA70D0124Accident · No injuriesClosedCessna 150 · Murfreesboro, TNSep 6, 1969 · N23362 · Substantial damage NTSB MIA70F0137Accident · Minor injuriesClosedBoeing PT-17 · Knoxville, TNAug 30, 1969 · N55A · Destroyed NTSB MIA70F0123Accident · Serious injuriesClosedCessna 175A · White Side, TNAug 22, 1969 · N6745E · Destroyed NTSB MIA70A0014Accident · 1 fatalClosedBeech C-45G · Brentwood, TNAug 22, 1969 · N311U · Destroyed NTSB MIA70A0011Accident · 1 fatalClosedPiper J-3 · Lafayette, TNAug 1, 1969 · N70223 · No damage NTSB MIA70D0100Accident · No injuriesClosedCessna 205 · Spring City, TNJul 31, 1969 · N4811U · Substantial damage NTSB MIA70F0074Accident · Minor injuriesClosedBell 47D1 · Pigeon Forge, TNJul 17, 1969 · N2794A · Substantial damage NTSB MIA70F0058Accident · No injuriesClosedCessna 310H · Athens, TNJul 16, 1969 · N1040Q · Substantial damage NTSB MIA70D0061Accident · No injuriesClosedCessna 150 · Lobelville, TNJul 14, 1969 · N61200 · Substantial damage NTSB MIA70F0065Accident · No injuriesClosedPiper PA-28 · Powell, TNJul 12, 1969 · N5037W · Substantial damage NTSB MIA70D0067Accident · No injuriesClosedCessna 120 · Medina, TNJul 8, 1969 · N72977 · Substantial damage NTSB MIA70D0053Accident · Serious injuriesClosedBell 47G-5 · Hampton, TNJul 5, 1969 · N7841S · Destroyed NTSB MIA70F0022Accident · No injuriesClosedBeech 19A · Knoxville, TNJun 21, 1969 · N9105T · Substantial damage NTSB MIA69I0088Incident · No injuriesClosedDouglas DC-9 · Chattanooga, TNJun 9, 1969 · N8946E · No damage NTSB MIA69D0485Accident · No injuriesClosedAeronca 7AC · Clarksville, TNJun 7, 1969 · N84764 · Substantial damage NTSB MIA70F0025Accident · Minor injuriesClosedBeech 35 · Lobelville, TNMay 28, 1969 · N464B · Substantial damage NTSB MIA69F0461Accident · No injuriesClosedAeronca 7AC · Cleveland, TNMay 3, 1969 · N2665E · Substantial damage NTSB MIA69D0441Accident · No injuriesClosedCessna 177 · Dyersburg, TNMay 2, 1969 · N2294Y · Substantial damage NTSB MIA69I0072Incident · No injuriesClosedBoeing 727 · Nashville, TNMay 1, 1969 · N8139N · Minor damage NTSB MIA69F0439Accident · No injuriesClosedCessna 150 · Wrigley, TNApr 20, 1969 · N7186S · Substantial damage NTSB MIA69A0070Accident · No injuriesClosedDouglas DC-3A · Cleveland, TNApr 18, 1969 · N742J · Substantial damage NTSB MIA69F0408Accident · No injuriesClosedCessna 150 · Mt Joliet, TNApr 16, 1969 · N9372S · Substantial damage NTSB MIA69A0066Accident · 1 fatalClosedPiper PA-28 · Greeneville, TNApr 13, 1969 · N5793F · Destroyed NTSB MIA69F0427Accident · No injuriesClosedCessna 182 · Copperhill, TNApr 3, 1969 · N42745 · Substantial damage NTSB MIA69F0423Accident · No injuriesClosedCessna 150E · Cumingsville, TNMar 29, 1969 · N3022J · Substantial damage NTSB MIA69A0061Accident · 4 fatalClosedPiper PA-28 · Crossville, TNMar 29, 1969 · N5150L · Destroyed NTSB MIA69A0059Accident · 5 fatalClosedAero Comdr 560-A · Crossville, TNMar 29, 1969 · N2761B · Destroyed NTSB MIA69F0398Accident · No injuriesClosedCessna 182 · Chattanooga, TNMar 23, 1969 · N8372S · Destroyed NTSB MIA69A0064Accident · 4 fatalClosedMooney M20F · Pikesville, TNMar 23, 1969 · N6445Q · Destroyed NTSB MIA69F0380Accident · No injuriesClosedCessna 310N · Memphis, TNMar 21, 1969 · N5028J · Substantial damage NTSB MIA69A0062Accident · 1 fatalClosedCessna 177 · Murfreesboro, TNMar 10, 1969 · N29420 · Destroyed NTSB MIA69F0373Accident · No injuriesClosedPiper PA-24 · Dyersburg, TNMar 8, 1969 · N5568P · Substantial damage NTSB MIA69A0053Accident · 1 fatalClosedCessna 182C · Gatlinburg, TNFeb 12, 1969 · N8973T · Destroyed