Skip to content

NTSB investigations, 1975, 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, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 IAD76AI045Accident · 1 fatalClosedMooney M20E · Mt Olivet, KYDec 28, 1975 · N1263X · Destroyed NTSB IAD76II041Incident · No injuriesClosedDouglas DC-3C · Louisville, KYDec 15, 1975 · N45 · Minor damage NTSB IAD76FLQ11Accident · No injuriesClosedCessna 172 · Paris, KYDec 7, 1975 · N5635R · Substantial damage NTSB IAD76AI025Accident · No injuriesClosedBeech E18S · Lexington, KYNov 17, 1975 · N5611D · Substantial damage NTSB IAD76FLQ10Accident · No injuriesClosedPiper PA-22 · Lagrange, KYNov 15, 1975 · N6161D · Substantial damage NTSB IAD76FLQ09Accident · No injuriesClosedCessna 150L · Olmstead, KYOct 13, 1975 · N1295Q · Substantial damage NTSB IAD76AI018Accident · 1 fatalClosedCessna 150L · Louisville, KYSep 30, 1975 · N5370Q · Destroyed NTSB IAD76FLQ05Accident · Serious injuriesClosedCessna 177A · London, KYSep 29, 1975 · N30388 · Substantial damage NTSB IAD76AI022Accident · 1 fatalClosedPiper PA-32 · Hindman, KYSep 24, 1975 · N15292 · Destroyed NTSB IAD76DLQ08Accident · Serious injuriesClosedOsprey 1-V · Paducah, KYSep 13, 1975 · N12JV · Destroyed NTSB IAD76DLQ07Accident · No injuriesClosedHughes 269C · Campton, KYAug 22, 1975 · N9605 · Destroyed NTSB IAD76DLQ06Accident · Minor injuriesClosedPiper PA-28 · Lake City, KYAug 4, 1975 · N9621W · Substantial damage NTSB IAD76FLQ04Accident · Minor injuriesClosedStinson V-77 · Cave City, KYAug 2, 1975 · N9360H · Destroyed NTSB IAD76FLQ03Accident · Serious injuriesClosedBellanca 17-31 · Louisville, KYJul 13, 1975 · N100BV · Substantial damage NTSB IAD7LFLQ02Accident · No injuriesClosedAero Comdr 100 · Franklin, KYJul 6, 1975 · N3762X · Substantial damage NTSB IAD76AI001Accident · 2 fatalClosedAeronca 058B · Pikeville, KYJul 5, 1975 · N52354 · Destroyed NTSB IAD76FLQ01Accident · No injuriesClosedBeech J35 · Sparta, KYJul 1, 1975 · N3066C · Substantial damage NTSB IAD75FLQ25Accident · Serious injuriesClosedCessna 170A · California, KYJun 29, 1975 · N9288A · Substantial damage NTSB IAD75AI063Accident · No injuriesClosedCessna 320B · Bowling Green, KYJun 6, 1975 · N551X · Substantial damage NTSB IAD7KDLQ26Accident · No injuriesClosedCessna 150 · Versailles, KYMay 18, 1975 · N10770 · Substantial damage NTSB IAD75DLQ24Accident · No injuriesClosedCessna 182 · Russell Spgs, KYMay 14, 1975 · N71773 · Substantial damage NTSB IAD75FLQ22Accident · Serious injuriesClosedPiper PA-28 · Berea, KYMay 13, 1975 · N32519 · Substantial damage NTSB IAD75DLQ23Accident · No injuriesClosedBeech A23 · Mannington, KYMay 5, 1975 · N3666Q · Substantial damage NTSB IAD75FLQ21Accident · No injuriesClosedPiper PA-25 · Skylight, KYApr 26, 1975 · N6062Z · Substantial damage NTSB IAD75FLQ20Accident · Serious injuriesClosedVolksplane VP-1 · Utica, KYApr 22, 1975 · N39WA · Substantial damage NTSB IAD75FLQ19Accident · Serious injuriesClosedHughes 369 · Allen, KYMar 21, 1975 · N9007F · Destroyed NTSB IAD75FLQ18Accident · No injuriesClosedHughes 369HS · Mt Sterling, KYMar 10, 1975 · N9114F · Substantial damage NTSB IAD75FLQ17Accident · No injuriesClosedAero Comdr 500B · Louisville, KYMar 3, 1975 · N6399U · Substantial damage NTSB IAD75AI049Accident · 1 fatalClosedAero Comdr 500S · S Portsmouth, KYFeb 21, 1975 · N9179N · Destroyed NTSB IAD75DLQ14Accident · Minor injuriesClosedMooney M20 · Pine Knot, KYFeb 8, 1975 · N9653M · Substantial damage NTSB IAD75FLQ16Accident · No injuriesClosedCessna 150 · Georgetown, KYFeb 7, 1975 · N6557S · Substantial damage NTSB IAD75II046Incident · No injuriesClosedBeech 55 · Hazard, KYJan 29, 1975 · N77RR · Minor damage NTSB IAD75DLQ13Accident · No injuriesClosedCessna 172 · Albany, KYJan 17, 1975 · N2315U · Substantial damage NTSB IAD75AI041Accident · 3 fatalClosedPiper PA-28R · Paintsville, KYJan 12, 1975 · N2699R · Destroyed NTSB IAD75DLQ12Accident · No injuriesClosedBeech 23 · Gilbertsville, KYJan 9, 1975 · N9771L · Substantial damage