Skip to content

NTSB investigations, KY

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, newest first

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 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 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 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 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 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