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 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 NTSB IAD78DLQ06Accident · No injuriesClosedSikorsky S58F · Harold, KYJan 4, 1978 · N885 · Substantial damage NTSB IAD78FA023Accident · No injuriesClosedHamilton E18S · Covington, KYDec 20, 1977 · N342T · Substantial damage NTSB IAD78FA020Accident · 1 fatalClosedPiper PA-28R · Elizabethtown, KYDec 10, 1977 · N9406N · Destroyed NTSB IAD78FLQ05Accident · Minor injuriesClosedPiper PA-28 · Somerset, KYDec 3, 1977 · N55024 · Substantial damage NTSB IAD78FLQ04Accident · No injuriesClosedCessna 310J · Paducah, KYNov 6, 1977 · N3166L · Substantial damage NTSB IAD78FA007Accident · Serious injuriesClosedCessna 402A · Madisonville, KYOct 27, 1977 · N4559Q · Substantial damage NTSB IAD78FLQ03Accident · No injuriesClosedPiper PA-23 · Lexington, KYOct 26, 1977 · N12E · Substantial damage NTSB IAD78FLQ02Accident · Minor injuriesClosedCessna 150 · Owensboro, KYOct 15, 1977 · N19225 · Substantial damage NTSB IAD78FA005Accident · 3 fatalClosedBeech D35 · Livingston, KYOct 15, 1977 · N2982B · Destroyed NTSB IAD77FLQ24Accident · No injuriesClosedCessna A188B · Shepardsville, KYSep 16, 1977 · N9621G · Substantial damage NTSB IAD77FLQ23Accident · No injuriesClosedCessna A188B · Hopkinsville, KYSep 12, 1977 · N53315 · Substantial damage NTSB IAD77FLQ22Accident · No injuriesClosedCessna 205 · Falls Of Rough, KYSep 2, 1977 · N3157Z · Substantial damage NTSB IAD77FA063Accident · 1 fatalClosedCessna 172M · Manchester, KYAug 29, 1977 · N20430 · No damage NTSB IAD77DLQ20Accident · Minor injuriesClosedCallair A9 · Sturgis, KYAug 22, 1977 · N9666Z · Substantial damage NTSB IAD77FLQ21Accident · No injuriesClosedBellanca 17-31 · Lexington, KYAug 19, 1977 · N14747 · Substantial damage NTSB IAD77IA056Incident · No injuriesClosedPiper PA-32 · Paducah, KYAug 2, 1977 · N56684 · Minor damage NTSB IAD77DA053Accident · 1 fatalClosedGrum Amer AA-1 · Vine Grove, KYJul 14, 1977 · N5652L · Substantial damage NTSB IAD77FLQ19Accident · Minor injuriesClosedPiper PA28 · Glasgow, KYJul 8, 1977 · N32285 · Substantial damage NTSB IAD77FLQ18Accident · Minor injuriesClosedPiper PA32 · Caneyville, KYJul 6, 1977 · N3885W · Destroyed NTSB IAD77FLQ17Accident · Minor injuriesClosedAmerican AA-1A · Elliotville, KYJul 4, 1977 · N9257L · Substantial damage NTSB IAD77FLQ16Accident · No injuriesClosedPiper PA-34 · Georgetown, KYJul 2, 1977 · N55195 · Substantial damage NTSB IAD77FLQ15Accident · Serious injuriesClosedPiper PA-25 · Albany, KYJun 20, 1977 · N4650Y · Destroyed NTSB IAD77FA044Accident · 3 fatalClosedBellanca 14-19 · Robinson Creek, KYJun 6, 1977 · N1293R · Destroyed NTSB IAD77FLQ14Accident · Serious injuriesClosedHughes 269C · Louisville, KYMay 31, 1977 · N9498F · Substantial damage NTSB IAD77FLQ13Accident · No injuriesClosedPiper PA-24 · Rough River, KYMay 14, 1977 · N5656P · Substantial damage NTSB IAD77FLQ12Accident · 1 fatalClosedBeech F35 · Pikeville, KYMay 1, 1977 · N4238B · Substantial damage NTSB IAD77FLQ10Accident · Minor injuriesClosedCessna 172 · Louisville, KYApr 17, 1977 · N1752F · Substantial damage NTSB IAD77DLQ11Accident · Minor injuriesClosedCessna 150 · Prestonburg, KYApr 14, 1977 · N7046N · Substantial damage NTSB IAD77FA034Accident · 3 fatalClosedPiper PA-28 · Glasgow, KYApr 13, 1977 · N7165W · Destroyed NTSB IAD77DLQ08Accident · No injuriesClosedCessna 182G · Bronston, KYMar 28, 1977 · N2470R · Substantial damage NTSB IAD77DA026Accident · Minor injuriesClosedBell 206B · Prestonburg, KYMar 3, 1977 · N9929K · Destroyed NTSB IAD77FLQ07Accident · Minor injuriesClosedAeronca 7AC · Elizabethtown, KYFeb 20, 1977 · N82244 · Destroyed NTSB IAD77FA023Accident · Serious injuriesClosedBeechcraft D-18S · Covington, KYFeb 14, 1977 · N321D · Destroyed NTSB IAD77DA022Accident · 1 fatalClosedPiper PA-18 · Louisville, KYFeb 13, 1977 · N128T · Destroyed NTSB IAD77DLQ05Accident · No injuriesClosedCessna 150M · Covington, KYFeb 7, 1977 · N9114U · Substantial damage NTSB IAD77FLQ06Accident · No injuriesClosedPiper PA-23 · Louisville, KYFeb 1, 1977 · N4651P · Substantial damage