Skip to content

NTSB investigations, 1979, KY

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 IAD80FLQ07Accident · Serious injuriesClosedPiper PA-28R · Whitesburg, KYDec 31, 1979 · N5061S · Substantial damage NTSB IAD80DLQ06Accident · No injuriesClosedCessna 172F · Corbin, KYDec 21, 1979 · N8820U · Substantial damage NTSB IAD80FA017Accident · 7 fatalClosedBeech A65 · Lexington, KYDec 16, 1979 · N154F · Destroyed NTSB IAD80FLQ05Accident · No injuriesClosedPiper PA-38 · Louisville, KYNov 29, 1979 · N2459G · Substantial damage NTSB IAD80FA006Accident · Minor injuriesClosedPiper PA-23 · Harlan, KYOct 29, 1979 · N62727 · Substantial damage NTSB IAD80DLT02Accident · No injuriesClosedCessna 172 · Fulton, KYOct 27, 1979 · N9891Q · Substantial damage NTSB IAD80FLQ04Accident · No injuriesClosedBeech H18S · Covington, KYOct 19, 1979 · N24K · Substantial damage NTSB IAD80FLQ01Accident · Minor injuriesClosedBeech A-35 · Grayson, KYOct 13, 1979 · N786B · Substantial damage NTSB IAD80DLQ03Accident · No injuriesClosedCessna 152 · Bowling Green, KYOct 13, 1979 · N47109 · Substantial damage NTSB DCA80AA002Accident · 8 fatalClosedPiper PA-31 · Covington, KYOct 8, 1979 · N6642L · Destroyed NTSB IAD80FLQ02Accident · No injuriesClosedCessna 150L · Winchester, KYOct 1, 1979 · N19205 · Substantial damage NTSB IAD79FA093Accident · 1 fatalClosedCessna 170 · Horsebranch, KYSep 30, 1979 · N3423C · Destroyed NTSB IAD79FA094Accident · No injuriesClosedCessna 150M · Louisville, KYSep 29, 1979 · N6096K · Substantial damage NTSB IAD79FA088Accident · No injuriesClosedCessna 172 · Paducah, KYSep 22, 1979 · N739CZ · Substantial damage NTSB IAD79FA075Accident · No injuriesClosedBeech V35 · Somerset, KYSep 4, 1979 · N614L · Substantial damage NTSB IAD79DA070Incident · No injuriesClosedPiper PA-31 · Covington, KYAug 29, 1979 · N9167Y · Minor damage NTSB IAD79FLQ23Accident · Minor injuriesClosedCessna 172E · Erlanger, KYAug 13, 1979 · N5470T · Substantial damage NTSB IAD79FA065Accident · 1 fatalClosedCessna 172 · Jenkins, KYJul 26, 1979 · N9138B · Destroyed NTSB IAD79FLQ21Accident · 2 fatalClosedGreat Lakes 2T-1A · Versailles, KYJul 21, 1979 · N3716F · Destroyed NTSB IAD79FLQ20Accident · No injuriesClosedCessna 172 · Louisville, KYJul 17, 1979 · N18171 · Substantial damage NTSB IAD79FLQ19Accident · Minor injuriesClosedPiper PA-24 · Somerset, KYJul 17, 1979 · N8076P · Substantial damage NTSB IAD79FLQ18Accident · Minor injuriesClosedBeech 35 · Maysville, KYJul 15, 1979 · N3393V · Substantial damage NTSB IAD79DLQ17Accident · No injuriesClosedPiper PA-28 · Hazard, KYJun 22, 1979 · N40977 · Substantial damage NTSB IAD79FLQ15Accident · Minor injuriesClosedCessna 150 · Saidee, KYJun 5, 1979 · N60698 · Substantial damage NTSB IAD79FA053Accident · 1 fatalClosedCessna 172N · Mackville, KYJun 1, 1979 · N1667E · Destroyed NTSB IAD79DLQ14Accident · No injuriesClosedRice Spcl · Bowling Green, KYJun 1, 1979 · N691 · Substantial damage NTSB IAD79DLQ13Accident · No injuriesClosedCessna 210 · Pirates Cove, KYMay 18, 1979 · N1189Q · Destroyed NTSB IAD79FLQ12Accident · No injuriesClosedCessna 150 · Berea, KYMay 17, 1979 · N4684X · Substantial damage NTSB IAD79FLQ11Accident · No injuriesClosedEnstrom F-28-C · Shelbyville, KYMay 16, 1979 · N559H · Substantial damage NTSB IAD79FLQ10Accident · Serious injuriesClosedCessna 150 · Richmond, KYMay 7, 1979 · N22992 · Destroyed NTSB IAD79DLQ16Accident · Serious injuriesClosedMaule M-5 · Greenville, KYMay 7, 1979 · N9101E · No damage NTSB IAD79FA048Accident · 2 fatalClosedCessna 172A · Albany, KYMay 5, 1979 · N7687T · Destroyed NTSB IAD79FA045Accident · 3 fatalClosedPiper PA-28 · Cynthiana, KYApr 27, 1979 · N39939 · Destroyed NTSB IAD79FA040Accident · No injuriesClosedBeech D-18S · Louisville, KYMar 15, 1979 · N80204 · Substantial damage NTSB IAD79FLQ09Accident · Minor injuriesClosedBell 47G4 · Russellville, KYMar 12, 1979 · N1218W · Substantial damage NTSB IAD79DLQ08Accident · No injuriesClosedCessna 206 · Glasgow, KYMar 9, 1979 · N94036 · Substantial damage NTSB IAD79FA035Accident · 4 fatalClosedPiper PA-32R · Glenville, KYFeb 23, 1979 · N2754Q · Destroyed NTSB IAD79FA032Accident · 1 fatalClosedN.American Navion · Somerset, KYFeb 22, 1979 · N8921H · Substantial damage NTSB IAD79FLQ07Accident · No injuriesClosedCessna 182 · Elkton, KYJan 16, 1979 · N2912Y · Destroyed