Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 MIA68F0395Accident · No injuriesClosedBeech F35 · Centerville, TNDec 22, 1967 · N337AA · Substantial damage NTSB MIA68F0271Accident · No injuriesClosedMooney M20D · Nashville, TNNov 26, 1967 · N6658U · Substantial damage NTSB MIA68D0277Accident · No injuriesClosedCessna 140 · White Bluff, TNNov 18, 1967 · N4228N · Substantial damage NTSB MIA68D0251Accident · No injuriesClosedCessna 140 · Collegedale, TNNov 4, 1967 · N2026V · Substantial damage NTSB MIA68D0249Accident · No injuriesClosedCessna 182 · Dayton, TNOct 31, 1967 · N3586F · Substantial damage NTSB MIA68D0229Accident · No injuriesClosedLuscombe 8E · Tullahoma, TNOct 28, 1967 · N1585B · Substantial damage NTSB MIA68D0232Accident · No injuriesClosedCessna 182 · Nashville, TNOct 25, 1967 · N3208U · Substantial damage NTSB MIA68F0227Accident · Serious injuriesClosedBeech F35 · Nashville, TNOct 11, 1967 · N5000B · Substantial damage NTSB MIA68F0243Accident · No injuriesClosedCessna 310 · Memphis, TNOct 10, 1967 · N95E · Substantial damage NTSB MIA68F0224Accident · No injuriesClosedPiper PA-23 · Nashville, TNOct 1, 1967 · N5100Y · Substantial damage NTSB MIA68A0031Accident · 3 fatalClosedPiper PA-12 · Nashville, TNSep 30, 1967 · N4386M · Destroyed NTSB MIA68F0196Accident · Minor injuriesClosedCessna 172E · Murfreesboro, TNSep 29, 1967 · N8693U · Substantial damage NTSB MIA68F0144Accident · No injuriesClosedCessna 150G · Centerville, TNSep 16, 1967 · N8349J · Substantial damage NTSB MIA68D0209Accident · No injuriesClosedBeech A23 · Alcoa, TNSep 4, 1967 · N744SR · Substantial damage NTSB MIA68F0154Accident · No injuriesClosedPiper PA-28 · Dayton, TNSep 2, 1967 · N7904W · Substantial damage NTSB MIA68A0021Accident · 1 fatalClosedPiper J3C-65 · Jacks Creek, TNAug 22, 1967 · N92076 · Destroyed NTSB MIA68D0112Accident · No injuriesClosedAero Comdr 100 · Nashville, TNAug 14, 1967 · N2953T · Substantial damage NTSB MIA68F0126Accident · Minor injuriesClosedPiper PA-28 · Nashville, TNAug 11, 1967 · N9662W · Substantial damage NTSB MIA68F0100Accident · No injuriesClosedChampion 7FC · Columbia, TNAug 10, 1967 · N9842Y · Substantial damage NTSB MIA68F0074Accident · No injuriesClosedPiper PA-31 · Millington, TNAug 1, 1967 · N9019Y · Substantial damage NTSB MIA68F0096Accident · No injuriesClosedPiper PA-24 · Chattanooga, TNJul 30, 1967 · N5427P · Substantial damage NTSB MIA68D0075Accident · No injuriesClosedCessna 150 · Clarksville, TNJul 29, 1967 · N2938S · Substantial damage NTSB MIA68D006UAccident · No injuriesClosedCessna 150 · Lawrenceburg, TNJul 21, 1967 · N8969S · Substantial damage NTSB MIA68A0004Accident · 1 fatalClosedErco 415-C · Como, TNJul 5, 1967 · N9415Z · Destroyed NTSB MIA68F0023Accident · No injuriesClosedPiper PA-28 · Doyle, TNJul 2, 1967 · N9146J · Substantial damage NTSB MIA67A0131Accident · 3 fatalClosedMaule M4 · Crossville, TNJun 30, 1967 · N9818M · Destroyed NTSB MIA68D0017Accident · No injuriesClosedPiper PA-22 · Hohenwald, TNJun 27, 1967 · N3301B · Substantial damage NTSB MIA68F0028Accident · No injuriesClosedCessna 320B · Memphis, TNJun 23, 1967 · N9805L · Substantial damage NTSB MIA67F0574Accident · No injuriesClosedCessna 150 · Springfield, TNJun 17, 1967 · N8685G · Substantial damage NTSB MIA68D0009Accident · No injuriesClosedPiper PA-23 · Jackson, TNJun 16, 1967 · N3237P · Substantial damage NTSB MIA67D0003Accident · No injuriesClosedBeech 23 · Crossville, TNJun 10, 1967 · N2394L · Substantial damage NTSB MIA67F0569Accident · No injuriesClosedPiper PA-24 · Murfreesboro, TNJun 9, 1967 · N6191P · Substantial damage NTSB MIA67F0548Accident · No injuriesClosedBoeing A75N1 · Millington, TNJun 3, 1967 · N59252 · Substantial damage NTSB MIA67D0568Accident · No injuriesClosedBoeing A75N1 · Morristown, TNJun 3, 1967 · N1203M · Substantial damage NTSB MIA67F0570Accident · No injuriesClosedBeech D50E · Memphis, TNMay 28, 1967 · N9612Y · Substantial damage NTSB MIA67D0555Accident · No injuriesClosedPiper PA-24 · Oak Ridge, TNMay 19, 1967 · N7598P · Substantial damage NTSB MIA67A0119Accident · 1 fatalClosedPiper PA-28 · Somerville, TNMay 9, 1967 · N4347J · Destroyed NTSB MIA67F0536Accident · No injuriesClosedCessna 188 · Memphis, TNMay 8, 1967 · N5526S · Substantial damage NTSB MIA67D0501Accident · No injuriesClosedBeech A23 · Rogersville, TNApr 30, 1967 · N1494L · Substantial damage NTSB MIA67A0117Accident · 1 fatalClosedBeech V35 · Andersonvill, TNApr 28, 1967 · N911X · 2 aircraft · Destroyed NTSB MIA67D0506Accident · No injuriesClosedCessna 182 · Tullahoma, TNApr 21, 1967 · N2285G · Substantial damage NTSB MIA67F0499Accident · No injuriesClosedBeech P35 · Knoxville, TNApr 18, 1967 · N8576M · Substantial damage NTSB MIA67F0466Accident · No injuriesClosedCessna 205 · Memphis, TNApr 11, 1967 · N8435Z · Substantial damage NTSB MIA67D0459Accident · No injuriesClosedPiper PA-24 · Millington, TNMar 28, 1967 · N8705P · Substantial damage NTSB MIA67F0451Accident · Minor injuriesClosedBeech A23 · Monterey, TNMar 26, 1967 · N5670S · Destroyed NTSB MIA67F0475Accident · No injuriesClosedBeech 35 · Rockwood, TNMar 25, 1967 · N2717V · Substantial damage NTSB MIA67F0461Accident · Minor injuriesClosedCessna 172 · Collegedale, TNMar 25, 1967 · N9122B · Destroyed NTSB MIA67D0460Accident · No injuriesClosedCessna 172 · Sewanee, TNMar 18, 1967 · N6925X · Substantial damage NTSB MIA67F0434Accident · Serious injuriesClosedSchweitzer TG-3A · Eagleville, TNMar 12, 1967 · N1438M · Destroyed NTSB MIA67A0091Accident · No injuriesClosedLockheed Ga 382B · Memphis, TNMar 7, 1967 · N9258R · No damage