Skip to content

NTSB investigations, 1974, KY

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1974, KY per year, 1964–2026: 1,466 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	9

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") = 1974 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\") = 1974
    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") = 1974
  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 IAD75FLQ11Accident · Serious injuriesClosedAero Comdr 500B · Paducah, KYDec 29, 1974 · N553HH · Substantial damage NTSB IAD75DLQ10Accident · No injuriesClosedCessna 150 · Paducah, KYDec 14, 1974 · N60391 · Substantial damage NTSB IAD75FLQ09Accident · Minor injuriesClosedCessna 150J · Owensboro, KYNov 28, 1974 · N50969 · Substantial damage NTSB IAD75DLQ08Accident · No injuriesClosedCessna 180 · Sandy Hook, KYOct 9, 1974 · N2428C · Substantial damage NTSB IAD75AI019Accident · 1 fatalClosedCessna 182 · Relief, KYOct 6, 1974 · N84311 · Substantial damage NTSB IAD75FLQ05Accident · Minor injuriesClosedCessna 210K · Joy, KYAug 18, 1974 · N8213M · Destroyed NTSB IAD75DLQ06Accident · No injuriesClosedCessna 188 · Owensboro, KYAug 10, 1974 · N5689J · Substantial damage NTSB IAD75FLQ04Accident · Minor injuriesClosedCessna 182A · Bowling Green, KYAug 6, 1974 · N2196G · Substantial damage NTSB IAD75ALQ03Accident · Minor injuriesClosedBell 47D1 · Clinton, KYJul 19, 1974 · N8282E · Substantial damage NTSB IAD75FLQ02Accident · No injuriesClosedHughes 269B · Dreyfus, KYJul 7, 1974 · N9467F · Destroyed NTSB IAD75FLQ01Accident · No injuriesClosedCessna 140 · Symsonia, KYJul 6, 1974 · N73052 · Destroyed NTSB IAD74FLQ40Accident · Minor injuriesClosedPiper PA-22 · Elizabethtown, KYJun 29, 1974 · N1928P · Substantial damage NTSB IAD74FLQ42Accident · 1 fatalClosedAeronca 7GCA · Allensville, KYJun 26, 1974 · N268S · Destroyed NTSB IAD74FL043Accident · No injuriesClosedPiper PA-28 · Cynthiana, KYJun 22, 1974 · N563FL · Substantial damage NTSB NYC74AN111Accident · 1 fatalClosedAmer Avco AA1-B · Prospect, KYJun 19, 1974 · N6274L · Destroyed NTSB IAD74FLQ39Accident · No injuriesClosedCessna 180 · Bowling Green, KYJun 12, 1974 · N3196C · Substantial damage NTSB IAD74FLQ38Accident · Minor injuriesClosedMooney M20C · Clarkson, KYJun 10, 1974 · N7173U · Substantial damage NTSB NYC74AN102Accident · 3 fatalClosedBeech 35 · Hopkinsville, KYJun 5, 1974 · N2939V · Destroyed NTSB NYC74AN099Accident · 1 fatalClosedBeech P35 · Verne, KYJun 1, 1974 · N1547S · Destroyed NTSB IAD74DLQ41Accident · No injuriesClosedCessna 150 · Richmond, KYMay 30, 1974 · N51218 · Substantial damage NTSB IAD74FLQ35Accident · No injuriesClosedAmer Avco AA-5 · Louisville, KYMay 29, 1974 · N5442L · Substantial damage NTSB IAD74DLQ36Accident · Minor injuriesClosedErco 415-C · Centertown, KYMay 29, 1974 · N3474H · Substantial damage NTSB IAD74DLQ37Accident · No injuriesClosedPiper PA-28 · Monticello, KYMay 27, 1974 · N55605 · Substantial damage NTSB IAD74FLQ33Accident · Serious injuriesClosedBoeing E75 · Clay, KYMay 23, 1974 · N1068N · Destroyed NTSB IAD74FLQ32Accident · No injuriesClosedPiper PA-24 · Hopkinsville, KYMay 14, 1974 · N8814P · Substantial damage NTSB IAD74DLQ31Accident · No injuriesClosedBeech V35 · Owensboro, KYMay 10, 1974 · N59095 · Substantial damage NTSB IAD74FLQ28Accident · No injuriesClosedPiper PA-30 · Louisville, KYApr 29, 1974 · N8172Y · Substantial damage NTSB IAD74DLQ34Accident · Minor injuriesClosedPiper J3C-65 · Louisville, KYApr 20, 1974 · N67194 · Substantial damage NTSB IAD74FL025Accident · Minor injuriesClosedCessna 210 · Mt Olivet, KYApr 13, 1974 · N9681T · Substantial damage NTSB IAD74DLQ19Accident · No injuriesClosedAeronca 7FC · Falmouth, KYApr 7, 1974 · N8952R · Substantial damage NTSB IAD74DLQ29Accident · Minor injuriesClosedCessna 150 · Mentor, KYMar 9, 1974 · N50152 · Substantial damage NTSB IAD74AI051Accident · 2 fatalClosedCessna 170B · Glencoe, KYMar 5, 1974 · N2412D · Destroyed NTSB IAD74FL027Accident · No injuriesClosedCessna 150 · Frankfort, KYFeb 18, 1974 · N6045G · Substantial damage NTSB IAD74FLQ26Accident · No injuriesClosedAmer Avco AA-5 · Fulton, KYFeb 11, 1974 · N71PP · Substantial damage NTSB IAD74AI042Accident · 3 fatalClosedAero Comdr 680FP · Cynthiana, KYFeb 5, 1974 · N46832 · Destroyed NTSB IAD74DLQ24Accident · Minor injuriesClosedBell 47J-2 · Royalton, KYFeb 1, 1974 · N711JW · Destroyed NTSB IAD74DLQ23Accident · No injuriesClosedBeech A36 · Hazard, KYJan 28, 1974 · N765T · Substantial damage NTSB IAD74FLQ21Accident · Minor injuriesClosedHughes 269B · Louisville, KYJan 9, 1974 · N9465F · Substantial damage NTSB IAD74DLQ22Accident · No injuriesClosedBeech 19 · Falmouth, KYJan 8, 1974 · N9938R · Destroyed NTSB IAD74FLQ18Accident · No injuriesClosedBeech P35 · Louisville, KYJan 2, 1974 · N1543Z · Substantial damage