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 CHI66F0066Accident · No injuriesClosedMooney M20C · Pikeville, KYMay 30, 1965 · N6508U · Destroyed NTSB CHI66F0019Accident · No injuriesClosedCessna 172 · Georgetown, KYMay 29, 1965 · N3921S · Destroyed NTSB CHI65F0204Accident · No injuriesClosedCessna 120 · Monticello, KYMay 23, 1965 · N72892 · Substantial damage NTSB CHI65F0125Accident · No injuriesClosedAeronca 7AC · Buffalo, KYMay 11, 1965 · N83459 · Destroyed NTSB CHI65F0126Accident · No injuriesClosedPiper PA-22 · Paducah, KYMay 8, 1965 · N3605A · Substantial damage NTSB CHI65D0103Accident · No injuriesClosedCessna 182C · Pikeville, KYApr 17, 1965 · N8785T · Substantial damage NTSB CHI65F0096Accident · No injuriesClosedPiper PA-24 · Monticello, KYApr 14, 1965 · N7410P · Substantial damage NTSB CHI65F0097Accident · No injuriesClosedPiper PA-25 · Berlin, KYApr 11, 1965 · N7366Z · Substantial damage NTSB CHI65F0086Accident · No injuriesClosedAeronca 7AC · Cynthiana, KYApr 4, 1965 · N83135 · Substantial damage NTSB CHI65D0065Accident · No injuriesClosedCessna 172 · Winchester, KYMar 22, 1965 · N3777S · Substantial damage NTSB CHI65D0045Accident · No injuriesClosedCessna 150 · Arrollton, KYMar 12, 1965 · N5738E · Substantial damage NTSB CHI65F0075Accident · Serious injuriesClosedBeechcraft M-35 · Smithland, KYMar 8, 1965 · N9627R · Destroyed NTSB CHI65F0050Accident · No injuriesClosedPiper PA-28 · Paducah, KYFeb 22, 1965 · N5498W · Substantial damage NTSB CHI65I0072Incident · No injuriesClosedBoeing B-727 · Covington, KYFeb 6, 1965 · N1975 · No damage NTSB CHI65F0015Accident · Serious injuriesClosedMooney M20A · Versailles, KYFeb 3, 1965 · N1098B · Destroyed NTSB CHI65F0017Accident · Minor injuriesClosedCessna 182 · Lexington, KYJan 31, 1965 · N3188Y · Substantial damage NTSB UNK65X1306Accident · No injuriesClosedCessna 172 · Manchester, KYJan 18, 1965 · N7879T · Substantial damage NTSB CHI65F0024Accident · No injuriesClosedMooney M20E · Louisville, KYJan 12, 1965 · N1937Y · Substantial damage NTSB CHI65A0067Accident · 4 fatalClosedBeechcraft E18S · Henderson, KYJan 3, 1965 · N208UB · Destroyed NTSB UNK65X1029Accident · No injuriesClosedCessna 172D · Louisville, KYDec 16, 1964 · N2070Y · Substantial damage NTSB UNK65X0828Accident · No injuriesClosedCurtiss C-46 · Covington, KYNov 25, 1964 · N611Z · Substantial damage NTSB UNK65X0794Accident · No injuriesClosedChampion 116 · Ano, KYNov 22, 1964 · N5498N · Substantial damage NTSB UNK65X0787Accident · 1 fatalClosedCessna 182A · Pikesville, KYNov 22, 1964 · N4996D · No damage NTSB UNK65X0642Accident · No injuriesClosedPiper PA23 · Bardstown, KYNov 10, 1964 · N3341P · Substantial damage NTSB UNK65X0607Accident · No injuriesClosedCessna 172 · Columbus, KYNov 8, 1964 · N7986X · Substantial damage NTSB UNK65X0511Accident · No injuriesClosedPiper PA23 · Cynthiana, KYNov 1, 1964 · N1143P · Substantial damage NTSB UNK65X0332Accident · No injuriesClosedNavion A · Lancaster, KYOct 18, 1964 · N4000G · Substantial damage NTSB UNK65X0302Accident · No injuriesClosedPiper PA18 · Ft Knox, KYOct 17, 1964 · N4056A · Substantial damage NTSB UNK65X0300Accident · 1 fatalClosedBensen Gyro B8MEJ · Berea, KYOct 16, 1964 · N3402G · Substantial damage NTSB UNK65X0215Accident · No injuriesClosedCulver V · Scottsville, KYOct 10, 1964 · N80271 · Substantial damage NTSB UNK65X0183Accident · No injuriesClosedBellanca 1419 · Pikeville, KYOct 7, 1964 · N6853D · Substantial damage NTSB UNK65X0136Accident · No injuriesClosedCessna 172D · Lynn Grove, KYOct 4, 1964 · N2060Y · Destroyed NTSB UNK64X4209Accident · No injuriesClosedBeechcraft K35 · Murray, KYSep 29, 1964 · N5008 · Substantial damage NTSB UNK64X4078Accident · No injuriesClosedHughes 269A · Bryantsville, KYSep 20, 1964 · N8930F · Substantial damage NTSB UNK64X3281Accident · No injuriesClosedCessna 175 · Henderson, KYAug 8, 1964 · N9303B · Substantial damage NTSB UNK64X3271Accident · No injuriesClosedPiper PA18 · Cynthiana, KYAug 8, 1964 · N248T · Substantial damage NTSB UNK64X3180Accident · Minor injuriesClosedPiper J3 · Berea, KYAug 2, 1964 · N40909 · Destroyed NTSB UNK64X3095Accident · 1 fatalClosedPiper PA-24 · Elizabethtown, KYJul 28, 1964 · N7529P · Destroyed NTSB UNK64X2874Accident · No injuriesClosedBeechcraft 23 · Winchester, KYJul 17, 1964 · N2350Q · Substantial damage NTSB UNK64X2866Accident · No injuriesClosedBrantly B2B · Hazard, KYJul 16, 1964 · N2254U · Substantial damage NTSB UNK64X2789Accident · Minor injuriesClosedPiper PA28 · Golden Pond, KYJul 12, 1964 · N5256W · Destroyed NTSB UNK64X2766Accident · No injuriesClosedBeechcraft G17S · Danville, KYJul 11, 1964 · N333 · Destroyed NTSB UNK64X2701Accident · No injuriesClosedCessna 140 · Bowling Green, KYJul 7, 1964 · N2403V · Substantial damage NTSB UNK64X2677Accident · No injuriesClosedPiper PA24 · Lexington, KYJul 6, 1964 · N8387P · Substantial damage NTSB UNK64X2621Accident · No injuriesClosedBoeing A75N1 · Adairville, KYJul 3, 1964 · N55570 · Substantial damage NTSB UNK64X2417Accident · Minor injuriesClosedPiper J3 · Hazard, KYJun 21, 1964 · N15758 · Substantial damage NTSB UNK64X2359Accident · No injuriesClosedBeechcraft H35 · Golden Pond, KYJun 18, 1964 · N7930D · Substantial damage NTSB UNK64X2207Accident · Serious injuriesClosedBell 47D1 · Gilbertsville, KYJun 9, 1964 · N8060E · Substantial damage NTSB UNK64X2126Accident · No injuriesClosedPiper PA24 · Jackson, KYJun 5, 1964 · N5848P · Substantial damage NTSB UNK64X2022Accident · No injuriesClosedBellanca 1413 · Golden Pond, KYMay 30, 1964 · N74333 · Substantial damage