Skip to content

NTSB investigations, 1978, KY

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1978, 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") = 1978 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\") = 1978
    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") = 1978
  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 IAD79FLQ05Accident · No injuriesClosedCessna 150 · Bardstown, KYDec 9, 1978 · N5920T · Substantial damage NTSB IAD79DLQ06Accident · No injuriesClosedCessna 140 · Shelbyville, KYNov 22, 1978 · N90143 · Substantial damage NTSB IAD79FLQ04Accident · No injuriesClosedPiper PA-32R · Paintsville, KYNov 6, 1978 · N31910 · Substantial damage NTSB IAD79FLQ03Accident · No injuriesClosedWaco ASO · Mt Sterling, KYOct 29, 1978 · N11253 · Substantial damage NTSB IAD79DLQ02Accident · Minor injuriesClosedGlobe GC-1B · Pikeville, KYOct 28, 1978 · N3270K · Substantial damage NTSB IAD79IA003Incident · No injuriesClosedCessna 404 · Covington, KYOct 11, 1978 · N37144 · Minor damage NTSB IAD79FA001Accident · 5 fatalClosedPiper PA-31P · Lexington, KYOct 3, 1978 · N338J · Destroyed NTSB IAD79DLQ01Accident · No injuriesClosedCessna 150 · Campbellsville, KYOct 2, 1978 · N61150 · Substantial damage NTSB IAD78FLQ37Accident · No injuriesClosedPiper PA-22 · Richmond, KYSep 25, 1978 · N830A · Substantial damage NTSB IAD78FLQ36Accident · No injuriesClosedCessna T210M · Owensboro, KYSep 23, 1978 · N732KP · Substantial damage NTSB IAD78FLQ35Accident · No injuriesClosedPiper PA-34 · Covington, KYSep 19, 1978 · N1440T · Substantial damage NTSB IAD78FLQ33Accident · Serious injuriesClosedPiper J3C · Lebanon, KYSep 19, 1978 · N42948 · Substantial damage NTSB IAD78FLQ34Accident · No injuriesClosedHughes 269A · Lexington, KYSep 18, 1978 · N8938F · Substantial damage NTSB IAD78FLQ32Accident · Minor injuriesClosedCessna 172D · Corbin, KYSep 11, 1978 · N2678U · Substantial damage NTSB IAD78FA105Accident · 2 fatalClosedCessna 150 · Louisville, KYSep 2, 1978 · N18123 · 2 aircraft · Destroyed NTSB IAD78FA097Accident · 4 fatalClosedCessna 195 · Whitesburg, KYAug 20, 1978 · N11DK · Destroyed NTSB IAD78FLQ31Accident · No injuriesClosedSmith Mini · Louisville, KYAug 18, 1978 · N846Z · Substantial damage NTSB IAD78FLT09Accident · No injuriesClosedCessna 150 · Covington, KYAug 10, 1978 · N51285 · 2 aircraft · Substantial damage NTSB IAD78FA114Accident · 1 fatalClosedBellanca 8KCAB · Princeton, KYAug 10, 1978 · N205HL · Destroyed NTSB IAD78FLQ30Accident · No injuriesClosedPiper PA-34 · Mt Sterling, KYAug 4, 1978 · N1083U · Substantial damage NTSB IAD78DLQ28Accident · No injuriesClosedCessna 152 · Owensboro, KYJul 30, 1978 · N24334 · Substantial damage NTSB IAD78FLQ27Accident · Minor injuriesClosedCessna 172 · Leitchfield, KYJul 29, 1978 · N7336G · Substantial damage NTSB IAD78FLQ26Accident · No injuriesClosedPiper PA-34 · Louisville, KYJul 23, 1978 · N415HE · Substantial damage NTSB IAD78FLQ24Accident · No injuriesClosedCessna 210L · Leitchfield, KYJul 11, 1978 · N1778X · Substantial damage NTSB IAD78FLQ23Accident · Serious injuriesClosedBell 206B · Salyersville, KYJul 11, 1978 · N55EA · Minor damage NTSB IAD78DLQ25Accident · No injuriesClosedCessna 182F · Flemingsburg, KYJul 11, 1978 · N3566U · Substantial damage NTSB IAD78FLQ22Accident · Serious injuriesClosedCessna 150K · Russell Spgs, KYJun 30, 1978 · N5905G · Substantial damage NTSB IAD78FLQ20Accident · Serious injuriesClosedPiper PA-22 · Hazard, KYJun 22, 1978 · N6117D · Substantial damage NTSB IAD78FA073Accident · 1 fatalClosedPiper PA-23 · Marion, KYJun 22, 1978 · N5421Y · Destroyed NTSB IAD78DLQ21Accident · No injuriesClosedPiper PA-34 · Decoy, KYJun 22, 1978 · N55800 · Substantial damage NTSB IAD78FA067Accident · Serious injuriesClosedBoeing 727 · Erlanger, KYMay 21, 1978 · N1974 · Minor damage NTSB IAD78FA064Accident · No injuriesClosedCessna 404 · Covington, KYMay 16, 1978 · N5422G · Substantial damage NTSB IAD78FLQ17Accident · No injuriesClosedGrumman G-164B · Monticello, KYMay 12, 1978 · N6611K · Substantial damage NTSB IAD78FLQ18Accident · No injuriesClosedLuscombe 8A · Louisville, KYMay 11, 1978 · N71328 · Substantial damage NTSB IAD78DLQ19Accident · No injuriesClosedPiper PA-12 · Bowling Green, KYMay 10, 1978 · N3052M · Substantial damage NTSB IAD78FLQ16Accident · No injuriesClosedMooney M20F · Danville, KYApr 20, 1978 · N9518M · Substantial damage NTSB IAD78FLT04Accident · No injuriesClosedPiper PA-24 · Covington, KYApr 15, 1978 · N707UB · Substantial damage NTSB IAD78FLQ15Accident · No injuriesClosedCessna 177 · Morehead, KYApr 14, 1978 · N2892X · Substantial damage NTSB IAD78FLQ14Accident · Minor injuriesClosedPiper PA-22 · Crestview Hill, KYMar 27, 1978 · N3232Z · Substantial damage NTSB IAD78DA053Accident · Minor injuriesClosedCessna 182 · Hazard, KYMar 20, 1978 · N21531 · Substantial damage NTSB IAD78FA052Accident · 2 fatalClosedCessna 172E · Leitchfield, KYMar 17, 1978 · N5615T · Destroyed NTSB IAD78DLQ12Accident · No injuriesClosedHughes 269A · Lexington, KYMar 14, 1978 · N8938F · Substantial damage NTSB IAD78FA048Accident · 3 fatalClosedAero Comdr 681 · Greenup, KYMar 8, 1978 · N5NP · Destroyed NTSB IAD78DLQ13Accident · No injuriesClosedCessna 182 · Gilbertsville, KYMar 5, 1978 · N42032 · Substantial damage NTSB IAD78FLQ11Accident · Serious injuriesClosedStits SA-11A · Corbin, KYFeb 19, 1978 · N21DW · Substantial damage NTSB IAD78FLQ10Accident · No injuriesClosedCessna 150 · Frankfort, KYFeb 18, 1978 · N6776F · Substantial damage NTSB IAD78DLQ09Accident · No injuriesClosedCessna 182P · Lexington, KYJan 22, 1978 · N7371Q · Substantial damage NTSB IAD78DLQ08Accident · No injuriesClosedMitsubishi MU-2 · Hawesville, KYJan 19, 1978 · N115S · Destroyed NTSB IAD78FLQ07Accident · Minor injuriesClosedPiper PA-24 · Campbellsville, KYJan 6, 1978 · N8791P · Destroyed NTSB IAD78FA030Accident · 1 fatalClosedBeech 55 · Lexington, KYJan 6, 1978 · N25N · Destroyed