Skip to content

NTSB investigations, 1968, TN

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MIA69D0305Accident · No injuriesClosedBeech K35 · Crossville, TNDec 30, 1968 · N6057E · Substantial damage NTSB MIA69F0308Accident · No injuriesClosedCessna 150 · Gallatin, TNDec 14, 1968 · N8349J · Substantial damage NTSB MIA69D0307Accident · No injuriesClosedBell 47G-2 · Crossville, TNNov 27, 1968 · N1200W · Substantial damage NTSB MIA69F0263Accident · Serious injuriesClosedPiper PA-24 · Lawrenceburg, TNNov 25, 1968 · N5781P · Destroyed NTSB MIA69F0251Accident · No injuriesClosedCessna 310K · Finley, TNNov 24, 1968 · N6955L · Substantial damage NTSB MIA69F0261Accident · Serious injuriesClosedAeronca 65-TAC · Lafayette, TNNov 22, 1968 · N46605 · Destroyed NTSB MIA69A0025Accident · 1 fatalClosedCessna 150G · Fayetteville, TNNov 4, 1968 · N8501J · Destroyed NTSB MIA69D0209Accident · Minor injuriesClosedCessna 172 · Raleigh, TNOct 27, 1968 · N35534 · Destroyed NTSB MIA69D0206Accident · No injuriesClosedPiper PA-28 · Trenton, TNOct 20, 1968 · N7135R · Substantial damage NTSB MIA69F0196Accident · No injuriesClosedMooney M20F · Chattanooga, TNOct 14, 1968 · N9703M · Substantial damage NTSB MIA69D0191Accident · No injuriesClosedPiper PA-22 · Paris, TNOct 9, 1968 · N5737D · Substantial damage NTSB MIA69F0192Accident · No injuriesClosedPiper L-4J · Memphis, TNOct 7, 1968 · N66332 · Substantial damage NTSB MIA69D0170Accident · No injuriesClosedAeronca 7AC · Fayetteville, TNSep 22, 1968 · N50902 · Substantial damage NTSB MIA69F0127Accident · No injuriesClosedMaule M-4C · Chattanooga, TNAug 26, 1968 · N9851M · Substantial damage NTSB MIA69F0119Accident · No injuriesClosedBeech D35 · Lenoir City, TNAug 24, 1968 · N2132D · Substantial damage NTSB MIA69D0091Accident · No injuriesClosedCessna 150 · Lebanon, TNAug 22, 1968 · N50284 · Substantial damage NTSB MIA69D0108Accident · No injuriesClosedPiper PA-24 · Chapel Hill, TNAug 11, 1968 · N7677P · Substantial damage NTSB MIA69F0078Accident · No injuriesClosedCessna 172 · Nashville, TNAug 10, 1968 · N8254L · Substantial damage NTSB MIA69F0090Accident · Serious injuriesClosedPiper PA-25 · Selmer, TNAug 6, 1968 · N6650Z · Substantial damage NTSB MIA69F0146Accident · Serious injuriesClosedPiper PA-18A · Fayetteville, TNAug 1, 1968 · N2411P · Destroyed NTSB MIA69D0077Accident · No injuriesClosedCessna 140 · Winchstr Spg, TNJul 31, 1968 · N73014 · Substantial damage NTSB MIA69A0006Accident · 1 fatalClosedCessna 150 · Woodbury, TNJul 31, 1968 · N5631E · 2 aircraft · Destroyed NTSB MIA69D0035Accident · No injuriesClosedCessna 182 · Knoxville, TNJul 11, 1968 · N2047R · Substantial damage NTSB MIA68A0110Accident · No injuriesClosedConvair 340 · Memphis, TNJun 30, 1968 · N4813C · Substantial damage NTSB MIA69F0041Accident · No injuriesClosedBeech A23 · Knoxville, TNJun 29, 1968 · N1461L · Substantial damage NTSB MIA69F0005Accident · No injuriesClosedAero Comdr 520 · Nashville, TNJun 17, 1968 · N359T · Substantial damage NTSB MIA68A0105Accident · 1 fatalClosedCessna 172 · Benton, TNJun 8, 1968 · N3909F · Destroyed NTSB MIA68F0525Accident · No injuriesClosedCessna 150 · Donelson, TNJun 7, 1968 · N2996J · Substantial damage NTSB MIA68D0550Accident · No injuriesClosedCessna 150 · Tellico Plns, TNJun 7, 1968 · N8301G · Substantial damage NTSB MIA68D0539Accident · No injuriesClosedCessna 150 · Gallatin, TNMay 31, 1968 · N8266S · Substantial damage NTSB MIA68F0514Accident · No injuriesClosedCessna 195 · Nashville, TNMay 28, 1968 · N3434V · Substantial damage NTSB MIA68D0522Accident · Minor injuriesClosedCessna 210 · Memphis, TNMay 25, 1968 · N6635X · Substantial damage NTSB MIA68F0487Accident · No injuriesClosedBeech N35 · Chattanooga, TNMay 8, 1968 · N1307Z · Substantial damage NTSB MIA68F0516Accident · No injuriesClosedBeech C-45G · Nashville, TNMay 3, 1968 · N72Q · Substantial damage NTSB MIA68F0521Accident · No injuriesClosedMooney M20G · Byrdstown, TNApr 26, 1968 · N3960N · Substantial damage NTSB MIA68F0469Accident · 1 fatalClosedSisu 1A · Eagleville, TNApr 21, 1968 · N331A · Destroyed NTSB MIA68D0452Accident · No injuriesClosedCessna 411 · Memphis, TNApr 8, 1968 · N3212R · Substantial damage NTSB MIA68F0463Accident · No injuriesClosedCessna 172 · Knoxville, TNMar 31, 1968 · N1457F · Substantial damage NTSB MIA68F0441Accident · No injuriesClosedCessna 150 · Murfreesboro, TNMar 30, 1968 · N7019S · Substantial damage NTSB MIA68D0460Accident · No injuriesClosedPiper PA-24 · Memphis, TNMar 29, 1968 · N8705P · Substantial damage NTSB MIA68F0450Accident · No injuriesClosedCessna 172 · Powell, TNMar 22, 1968 · N5966R · Destroyed NTSB MIA68F0442Accident · Serious injuriesClosedBeech F35 · Cowan, TNMar 21, 1968 · N3330C · Destroyed NTSB MIA68D0443Accident · Minor injuriesClosedAeronca 7AC · Mckinnon, TNMar 6, 1968 · N82506 · Substantial damage NTSB MIA68F0416Accident · Serious injuriesClosedPiper PA-28 · Nashville, TNMar 3, 1968 · N5578W · Substantial damage NTSB MIA68F0435Accident · No injuriesClosedCessna 182 · Chattanooga, TNFeb 28, 1968 · N3518Y · Substantial damage NTSB MIA68A0067Accident · No injuriesClosedDouglas DC-6 · Chattanooga, TNFeb 15, 1968 · N1906M · Substantial damage NTSB MIA68F0398Accident · No injuriesClosedPiper PA-24 · Millington, TNFeb 9, 1968 · N6284P · Substantial damage NTSB MIA68D0405Accident · Minor injuriesClosedAeronca 7AC · Jacksboro, TNJan 31, 1968 · N1648E · Substantial damage NTSB MIA68D0387Accident · No injuriesClosedCessna 172 · Nashville, TNJan 29, 1968 · N4207F · Substantial damage NTSB MIA68D0397Accident · No injuriesClosedCessna 172 · Roan Mountn, TNJan 24, 1968 · CF-PXN · Destroyed