Skip to content

NTSB investigations, 1967, KY

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

19642026

NTSB investigations, 1967, KY per year, 1964–2026: 1,465 cases
1964	46
1965	51
1966	32
1967	36
1968	54
1969	46
1970	39
1971	50
1972	51
1973	43
1974	40
1975	35
1976	42
1977	35
1978	51
1979	39
1980	43
1981	30
1982	39
1983	31
1984	22
1985	31
1986	20
1987	28
1988	22
1989	9
1990	17
1991	11
1992	24
1993	19
1994	15
1995	9
1996	18
1997	12
1998	12
1999	14
2000	15
2001	14
2002	14
2003	21
2004	19
2005	15
2006	16
2007	11
2008	16
2009	14
2010	20
2011	9
2012	14
2013	11
2014	5
2015	13
2016	11
2017	11
2018	5
2019	13
2020	7
2021	11
2022	15
2023	13
2024	13
2025	15
2026	8

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" = 'KY' 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\" = 'KY' 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" = 'KY' 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 CHI68D0527Accident · No injuriesClosedPiper PA-28 · Georgetown, KYDec 24, 1967 · N5873W · Substantial damage NTSB DCA68A0002Accident · 69 fatalClosedConvair 880 · Constance, KYNov 20, 1967 · N821TW · Destroyed NTSB CHI68F0494Accident · No injuriesClosedBeech C-18 · Cynthiana, KYNov 19, 1967 · N75595 · Substantial damage NTSB CHI68A0046Accident · 3 fatalClosedCessna 172E · Jamestown, KYNov 19, 1967 · N5460T · Destroyed NTSB CHI68A0043Accident · 1 fatalClosedBoeing 707 · Erlanger, KYNov 6, 1967 · N742TW · Destroyed NTSB CHI68F0376Accident · No injuriesClosedBeech D18S · Erlanger, KYOct 5, 1967 · N117J · Substantial damage NTSB CHI68F0330Accident · No injuriesClosedNavion A · Louisville, KYSep 30, 1967 · N4222K · Destroyed NTSB CHI68F0323Accident · Minor injuriesClosedBeech 35 · Mentor, KYSep 24, 1967 · N9662H · Substantial damage NTSB CHI68D0299Accident · No injuriesClosedPiper PA-22 · Worthington, KYSep 24, 1967 · N4882Z · Substantial damage NTSB CHI68D0261Accident · No injuriesClosedAero Comdr 500-U · Bowling Green, KYSep 5, 1967 · N213RC · Substantial damage NTSB CHI68F0301Accident · No injuriesClosedMooney M20C · Hazard, KYSep 1, 1967 · N2553W · Substantial damage NTSB CHI68F0244Accident · No injuriesClosedBeech 95C-55 · Lexington, KYAug 13, 1967 · N3738Q · Substantial damage NTSB CHI68F0212Accident · No injuriesClosedBeech A23 · Lexington, KYJul 23, 1967 · N2323W · Substantial damage NTSB CHI68F0203Accident · No injuriesClosedGrumman G-164A · Golden Pond, KYJul 18, 1967 · N632U · Destroyed NTSB CHI68A0016Accident · 1 fatalClosedBeech S35 · Cubage, KYJul 6, 1967 · N7923K · Destroyed NTSB CHI68F0159Accident · No injuriesClosedPiper PA-24 · Sonora, KYJul 3, 1967 · N7502P · Substantial damage NTSB CHI68D0015Accident · No injuriesClosedPiper PA-23 · Lexington, KYJul 2, 1967 · N5935Y · Substantial damage NTSB CHI68A0139Accident · 2 fatalClosedBeech 35-B33 · Smith Mills, KYJun 24, 1967 · N8659M · Destroyed NTSB CHI68F0085Accident · Serious injuriesClosedPiper PA-28 · Campbellsburg, KYJun 18, 1967 · N5902W · Substantial damage NTSB CHI67A0135Accident · 4 fatalClosedBeech 35 · Louisville, KYJun 18, 1967 · N3296V · Destroyed NTSB CHI67I0134Incident · No injuriesClosedDouglas DC-8 · Convington, KYJun 17, 1967 · N807E · Substantial damage NTSB CHI67A0130Accident · Serious injuriesClosedPiper PA-22 · Barrier, KYJun 12, 1967 · N1782P · Destroyed NTSB CHI68F0109Accident · Serious injuriesClosedCessna 150 · Murray, KYJun 11, 1967 · N2599J · Substantial damage NTSB CHI68D0164Accident · No injuriesClosedGrumman G-164 · Central City, KYJun 5, 1967 · N10258 · Destroyed NTSB CHI68F0066Accident · No injuriesClosedBeech A23 · Junction City, KYMay 29, 1967 · N2311W · Substantial damage NTSB CHI68D0077Accident · No injuriesClosedCessna 172H · Franklin, KYMay 29, 1967 · N3801R · Substantial damage NTSB CHI68D0009Accident · No injuriesClosedCessna 182 · Somerset, KYMay 26, 1967 · N3032Y · Substantial damage NTSB CHI67D0620Accident · No injuriesClosedPiper PA-24 · London, KYApr 30, 1967 · N6407P · Substantial damage NTSB CHI67F0677Accident · No injuriesClosedCessna 172G · Edmonton, KYApr 26, 1967 · N3609L · Substantial damage NTSB CHI67D0579Accident · No injuriesClosedLuscombe 8A · Hazel Green, KYApr 9, 1967 · CF-VMF · Substantial damage NTSB CHI67D0610Accident · No injuriesClosedPiper PA-28 · West Liberty, KYApr 8, 1967 · N5894W · Substantial damage NTSB CHI67A0112Accident · 9 fatalClosedBeech C-45H · Lexington, KYApr 3, 1967 · N3727G · Destroyed NTSB CHI67D0531Accident · No injuriesClosedChampion 7GCA · Campbellsville, KYMar 14, 1967 · N9537S · Substantial damage NTSB CHI67F0542Accident · Serious injuriesClosedCessna 140 · Pine Top, KYFeb 22, 1967 · N89499 · Destroyed NTSB CHI67A0100Accident · 3 fatalClosedAero Comdr 520 · Jetson, KYFeb 22, 1967 · N2628B · Destroyed NTSB CHI67F0475Accident · No injuriesClosedCessna 172C · Paducah, KYFeb 14, 1967 · N1807Y · Substantial damage