Skip to content

NTSB investigations, 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, 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 IAD74FLQ33Accident · Serious injuriesClosedBoeing E75 · Clay, KYMay 23, 1974 · N1068N · Destroyed NTSB IAD74FLQ32Accident · No injuriesClosedPiper PA-24 · Hopkinsville, KYMay 14, 1974 · N8814P · Substantial damage NTSB IAD74DLQ31Accident · No injuriesClosedBeech V35 · Owensboro, KYMay 10, 1974 · N59095 · Substantial damage NTSB IAD74FLQ28Accident · No injuriesClosedPiper PA-30 · Louisville, KYApr 29, 1974 · N8172Y · Substantial damage NTSB IAD74DLQ34Accident · Minor injuriesClosedPiper J3C-65 · Louisville, KYApr 20, 1974 · N67194 · Substantial damage NTSB IAD74FL025Accident · Minor injuriesClosedCessna 210 · Mt Olivet, KYApr 13, 1974 · N9681T · Substantial damage NTSB IAD74DLQ19Accident · No injuriesClosedAeronca 7FC · Falmouth, KYApr 7, 1974 · N8952R · Substantial damage NTSB IAD74DLQ29Accident · Minor injuriesClosedCessna 150 · Mentor, KYMar 9, 1974 · N50152 · Substantial damage NTSB IAD74AI051Accident · 2 fatalClosedCessna 170B · Glencoe, KYMar 5, 1974 · N2412D · Destroyed NTSB IAD74FL027Accident · No injuriesClosedCessna 150 · Frankfort, KYFeb 18, 1974 · N6045G · Substantial damage NTSB IAD74FLQ26Accident · No injuriesClosedAmer Avco AA-5 · Fulton, KYFeb 11, 1974 · N71PP · Substantial damage NTSB IAD74AI042Accident · 3 fatalClosedAero Comdr 680FP · Cynthiana, KYFeb 5, 1974 · N46832 · Destroyed NTSB IAD74DLQ24Accident · Minor injuriesClosedBell 47J-2 · Royalton, KYFeb 1, 1974 · N711JW · Destroyed NTSB IAD74DLQ23Accident · No injuriesClosedBeech A36 · Hazard, KYJan 28, 1974 · N765T · Substantial damage NTSB IAD74FLQ21Accident · Minor injuriesClosedHughes 269B · Louisville, KYJan 9, 1974 · N9465F · Substantial damage NTSB IAD74DLQ22Accident · No injuriesClosedBeech 19 · Falmouth, KYJan 8, 1974 · N9938R · Destroyed NTSB IAD74FLQ18Accident · No injuriesClosedBeech P35 · Louisville, KYJan 2, 1974 · N1543Z · Substantial damage NTSB IAD74AI037Accident · 1 fatalClosedBellanca 7KCAB · Munfordville, KYDec 29, 1973 · N711RD · Destroyed NTSB IAD74DLQ20Accident · No injuriesClosedCessna 172 · Moreland, KYDec 26, 1973 · N20351 · Substantial damage NTSB IAD74FLQ17Accident · No injuriesClosedCessna 177 · Dycusburg, KYDec 11, 1973 · N3250T · Substantial damage NTSB IAD74AI033Accident · Minor injuriesClosedBeech D18 · Covington, KYDec 7, 1973 · N199L · Substantial damage NTSB IAD74AI027Accident · 2 fatalClosedCessna 170 · Glasgow, KYNov 18, 1973 · N3556C · Destroyed NTSB IAD74FLQ15Accident · Minor injuriesClosedPiper PA-23 · Albany, KYNov 5, 1973 · N345E · Substantial damage NTSB IAD74AI025Accident · 2 fatalClosedMooney M20C · Cromwell, KYNov 4, 1973 · N3361X · Destroyed NTSB IAD74DLQ13Accident · No injuriesClosedBeech 35-A33 · Paducah, KYOct 24, 1973 · N975B · Substantial damage NTSB IAD74FLQ12Accident · No injuriesClosedCessna 172K · Williamsburg, KYOct 10, 1973 · N7042G · Substantial damage NTSB IAD74FLQ11Accident · No injuriesClosedPiper PA-28 · Louisville, KYOct 10, 1973 · N5253W · Substantial damage NTSB IAD74DLQ10Accident · No injuriesClosedBeech E55 · Hazard, KYSep 26, 1973 · N1792W · Substantial damage NTSB IAD74FLQ09Accident · No injuriesClosedCessna 337C · Murray, KYSep 24, 1973 · N2531S · Substantial damage NTSB IAD74FLQ08Accident · Minor injuriesClosedPiper PA-36 · Russellville, KYSep 16, 1973 · N56444 · Substantial damage NTSB IAD74DLQ07Accident · No injuriesClosedBeech A23 · Owensboro, KYSep 9, 1973 · N3524R · Substantial damage NTSB IAD74AI018Accident · 4 fatalClosedCessna 310H · Paintsville, KYSep 9, 1973 · N1834H · Destroyed NTSB IAD74AI014Accident · 1 fatalClosedCessna 150 · Eddyville, KYAug 31, 1973 · N8052F · Destroyed NTSB IAD74FLQ06Accident · No injuriesClosedAeronca 7AC · Cromwell, KYAug 21, 1973 · N84156 · Substantial damage NTSB IAD74FLQ04Accident · No injuriesClosedSiai-Marche S.205 · Bardstown, KYAug 19, 1973 · N986WA · Substantial damage NTSB IAD74AI008Accident · 1 fatalClosedCessna 172 · Loretto, KYAug 1, 1973 · N6853A · Destroyed NTSB IAD74DLQ03Accident · No injuriesClosedMooney M20C · Paducah, KYJul 30, 1973 · N6600U · Substantial damage NTSB IAD74FLQ02Accident · 1 fatalClosedCessna 182C · Mt.Sterling, KYJul 20, 1973 · N8901T · Substantial damage NTSB IAD74AI004Accident · 2 fatalClosedNavion A · Henderson, KYJul 14, 1973 · N8620H · Destroyed NTSB IAD74FLQ01Accident · No injuriesClosedPiper PA-24 · Louisville, KYJul 10, 1973 · N5186P · Substantial damage NTSB IAD74DLQ05Accident · Minor injuriesClosedCessna 150 · Campbellsville, KYJul 7, 1973 · N4746X · Substantial damage NTSB IAD73FIQ35Accident · No injuriesClosedGreat Lakes 2T-1R · Louisville, KYJun 24, 1973 · N3290 · Substantial damage NTSB IAD73FLQ36Accident · Serious injuriesClosedAeronca 7AC · Paris, KYJun 18, 1973 · N3060E · Substantial damage NTSB IAD73AI018Accident · No injuriesClosedBeech E18S · Covington, KYJun 14, 1973 · N136C · 2 aircraft · Minor damage NTSB IAD73FLQ34Accident · Minor injuriesClosedCessna 150H · Park City, KYJun 9, 1973 · N23168 · Destroyed NTSB IAD73FLQ33Accident · No injuriesClosedBeech J35 · Lexington, KYJun 9, 1973 · N593B · Substantial damage NTSB IAD73FLQ31Accident · No injuriesClosedPine Air SV · Richmond, KYMay 22, 1973 · N4530V · Substantial damage NTSB IAD73FLQ32Accident · Serious injuriesClosedBeech B23 · Middlesboro, KYMay 18, 1973 · N7634R · Substantial damage NTSB IAD73FLQ30Accident · Minor injuriesClosedAeronca 7AC · Murray, KYMay 13, 1973 · N81941 · Substantial damage NTSB IAD73FLQ29Accident · No injuriesClosedCessna 172 · Falmouth, KYMay 13, 1973 · N7922G · Substantial damage