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 ATL80FA079Accident · No injuriesClosedLear Jet 25 · Paducah, KYJul 30, 1980 · N8CL · Substantial damage NTSB ATL80FA078Accident · 3 fatalClosedPiper PA-28 · Pikeville, KYJul 26, 1980 · N8357W · Destroyed NTSB ATL80FLQ22Accident · No injuriesClosedGrumman G-164A · Garfield, KYJul 14, 1980 · N5401 · Destroyed NTSB ATL80DLQ21Accident · No injuriesClosedCessna 172 · Morgantown, KYJul 8, 1980 · N1618F · Substantial damage NTSB ATL80FA058Accident · 4 fatalClosedCessna 172N · West Liberty, KYJun 20, 1980 · N734YT · Destroyed NTSB ATL80FLQ20Accident · No injuriesClosedPiper PA-32 · Louisville, KYJun 10, 1980 · N2032M · Substantial damage NTSB ATL80FLQ19Accident · Serious injuriesClosedErco 415-C · Shepherdstown, KYJun 7, 1980 · N99652 · Substantial damage NTSB ATL80DLQ23Accident · No injuriesClosedGrumman G-164B · Scottsville, KYJun 3, 1980 · N48721 · Substantial damage NTSB IAD80DLQ18Accident · Minor injuriesClosedCessna 150L · Bowling Green, KYMay 26, 1980 · N16178 · Destroyed NTSB ATL80IA046Incident · No injuriesClosedAerospatle SA341G · Greasy Creek, KYMay 14, 1980 · N341SC · No damage NTSB ATL80FA045Accident · 1 fatalClosedCessna 150 · Pikeville, KYMay 10, 1980 · N50931 · Destroyed NTSB IAD80FA042Accident · 1 fatalClosedPiper PA-28 · Bowling Green, KYApr 22, 1980 · N32992 · Destroyed NTSB IAD80FLQ17Accident · No injuriesClosedPiper PA-28 · Anchorage, KYApr 20, 1980 · N1744J · Substantial damage NTSB IAD80FA040Accident · 4 fatalClosedPiper PA-28 · Falmouth, KYApr 20, 1980 · N8907J · Destroyed NTSB IAD80FLQ16Accident · Minor injuriesClosedBellanca 7ECA · Lexington, KYApr 2, 1980 · N11857 · Substantial damage NTSB IAD80FLQ15Accident · Minor injuriesClosedBell 206L · Pikeville, KYMar 11, 1980 · N2780Y · Destroyed NTSB IAD80FLQ14Accident · Serious injuriesClosedPiper PA-24 · Lexington, KYFeb 29, 1980 · N8574P · Substantial damage NTSB IAD80FA028Accident · No injuriesClosedCessna 404 · Lexington, KYFeb 25, 1980 · N406EX · Substantial damage NTSB IAD80FA027Accident · 1 fatalClosedCessna 150 · Reidland, KYFeb 24, 1980 · N1678Q · Destroyed NTSB IAD80DLQ13Accident · Serious injuriesClosedCessna 177 · Albany, KYFeb 23, 1980 · N3491T · Destroyed NTSB IAD80FLQ12Accident · No injuriesClosedCessna 150 · Louisville, KYFeb 17, 1980 · N63416 · Substantial damage NTSB IAD80DLQ11Accident · No injuriesClosedMooney M20F · Albany, KYJan 26, 1980 · N6960V · Substantial damage NTSB IAD80FLQ10Accident · Serious injuriesClosedHughes 500D · Dione, KYJan 11, 1980 · N9163F · Destroyed NTSB IAD80FLQ08Accident · Minor injuriesClosedBell 206B · Shelbyville, KYJan 4, 1980 · N77HB · Substantial damage NTSB IAD80DLQ09Accident · Minor injuriesClosedCessna 172M · Gilbertsville, KYJan 4, 1980 · N4493R · Substantial damage 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