NTSB investigations, 1964, 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.

Cases per year

19642026
NTSB investigations, 1964, KY per year, 1964–2026: 1,465 cases
196446
196551
196632
196736
196854
196946
197039
197150
197251
197343
197440
197535
197642
197735
197851
197939
198043
198130
198239
198331
198422
198531
198620
198728
198822
19899
199017
199111
199224
199319
199415
19959
199618
199712
199812
199914
200015
200114
200214
200321
200419
200515
200616
200711
200816
200914
201020
20119
201214
201311
20145
201513
201611
201711
20185
201913
20207
202111
202215
202313
202413
202515
20268

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1964
    AND 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.

NTSB UNK65X1029Accident · No injuriesClosedCessna 172D · Louisville, KYDec 16, 1964 · N2070Y · Substantial damageNTSB UNK65X0828Accident · No injuriesClosedCurtiss C-46 · Covington, KYNov 25, 1964 · N611Z · Substantial damageNTSB UNK65X0794Accident · No injuriesClosedChampion 116 · Ano, KYNov 22, 1964 · N5498N · Substantial damageNTSB UNK65X0787Accident · 1 fatalClosedCessna 182A · Pikesville, KYNov 22, 1964 · N4996D · No damageNTSB UNK65X0642Accident · No injuriesClosedPiper PA23 · Bardstown, KYNov 10, 1964 · N3341P · Substantial damageNTSB UNK65X0607Accident · No injuriesClosedCessna 172 · Columbus, KYNov 8, 1964 · N7986X · Substantial damageNTSB UNK65X0511Accident · No injuriesClosedPiper PA23 · Cynthiana, KYNov 1, 1964 · N1143P · Substantial damageNTSB UNK65X0332Accident · No injuriesClosedNavion A · Lancaster, KYOct 18, 1964 · N4000G · Substantial damageNTSB UNK65X0302Accident · No injuriesClosedPiper PA18 · Ft Knox, KYOct 17, 1964 · N4056A · Substantial damageNTSB UNK65X0300Accident · 1 fatalClosedBensen Gyro B8MEJ · Berea, KYOct 16, 1964 · N3402G · Substantial damageNTSB UNK65X0215Accident · No injuriesClosedCulver V · Scottsville, KYOct 10, 1964 · N80271 · Substantial damageNTSB UNK65X0183Accident · No injuriesClosedBellanca 1419 · Pikeville, KYOct 7, 1964 · N6853D · Substantial damageNTSB UNK65X0136Accident · No injuriesClosedCessna 172D · Lynn Grove, KYOct 4, 1964 · N2060Y · DestroyedNTSB UNK64X4209Accident · No injuriesClosedBeechcraft K35 · Murray, KYSep 29, 1964 · N5008 · Substantial damageNTSB UNK64X4078Accident · No injuriesClosedHughes 269A · Bryantsville, KYSep 20, 1964 · N8930F · Substantial damageNTSB UNK64X3281Accident · No injuriesClosedCessna 175 · Henderson, KYAug 8, 1964 · N9303B · Substantial damageNTSB UNK64X3271Accident · No injuriesClosedPiper PA18 · Cynthiana, KYAug 8, 1964 · N248T · Substantial damageNTSB UNK64X3180Accident · Minor injuriesClosedPiper J3 · Berea, KYAug 2, 1964 · N40909 · DestroyedNTSB UNK64X3095Accident · 1 fatalClosedPiper PA-24 · Elizabethtown, KYJul 28, 1964 · N7529P · DestroyedNTSB UNK64X2874Accident · No injuriesClosedBeechcraft 23 · Winchester, KYJul 17, 1964 · N2350Q · Substantial damageNTSB UNK64X2866Accident · No injuriesClosedBrantly B2B · Hazard, KYJul 16, 1964 · N2254U · Substantial damageNTSB UNK64X2789Accident · Minor injuriesClosedPiper PA28 · Golden Pond, KYJul 12, 1964 · N5256W · DestroyedNTSB UNK64X2766Accident · No injuriesClosedBeechcraft G17S · Danville, KYJul 11, 1964 · N333 · DestroyedNTSB UNK64X2701Accident · No injuriesClosedCessna 140 · Bowling Green, KYJul 7, 1964 · N2403V · Substantial damageNTSB UNK64X2677Accident · No injuriesClosedPiper PA24 · Lexington, KYJul 6, 1964 · N8387P · Substantial damageNTSB UNK64X2621Accident · No injuriesClosedBoeing A75N1 · Adairville, KYJul 3, 1964 · N55570 · Substantial damageNTSB UNK64X2417Accident · Minor injuriesClosedPiper J3 · Hazard, KYJun 21, 1964 · N15758 · Substantial damageNTSB UNK64X2359Accident · No injuriesClosedBeechcraft H35 · Golden Pond, KYJun 18, 1964 · N7930D · Substantial damageNTSB UNK64X2207Accident · Serious injuriesClosedBell 47D1 · Gilbertsville, KYJun 9, 1964 · N8060E · Substantial damageNTSB UNK64X2126Accident · No injuriesClosedPiper PA24 · Jackson, KYJun 5, 1964 · N5848P · Substantial damageNTSB UNK64X2022Accident · No injuriesClosedBellanca 1413 · Golden Pond, KYMay 30, 1964 · N74333 · Substantial damageNTSB UNK64X1885Accident · No injuriesClosedPiper PA24 · Lexington, KYMay 22, 1964 · N5145P · Substantial damageNTSB UNK64X1805Accident · No injuriesClosedCessna 170B · Tompkinsville, KYMay 17, 1964 · N4308B · Substantial damageNTSB UNK64X1552Accident · No injuriesClosedAeronca 7AC · Harlan, KYMay 1, 1964 · N1847E · Substantial damageNTSB UNK64X1488Accident · No injuriesClosedAero Comm 560 · Paducah, KYApr 27, 1964 · N2677B · Substantial damageNTSB UNK64X1261Accident · No injuriesClosedCessna 210 · Springfield, KYApr 11, 1964 · N7485E · Substantial damageNTSB UNK64X1177Accident · No injuriesClosedCessna 172 · Morehead, KYApr 5, 1964 · N7544T · Substantial damageNTSB UNK64X1167Accident · No injuriesClosedCessna 172 · Russell Spgs, KYApr 4, 1964 · N8198X · Substantial damageNTSB UNK64X1051Accident · No injuriesClosedCessna 205 · Erlanger, KYMar 27, 1964 · N8286Z · Substantial damageNTSB UNK64X0956Accident · Minor injuriesClosedBeechcraft F35 · Murray, KYMar 16, 1964 · N3388C · DestroyedNTSB UNK64X0949Accident · No injuriesClosedCessna 172 · Moorehead, KYMar 16, 1964 · N8342B · DestroyedNTSB UNK64X0913Accident · Minor injuriesClosedCessna 172 · Georgetown, KYMar 14, 1964 · N1804V · Substantial damageNTSB UNK64X0894Accident · No injuriesClosedPiper PA24 · Louisville, KYMar 12, 1964 · N7829P · Substantial damageNTSB UNK64X0461Accident · No injuriesClosedBeechcraft 23 · Olive Hill, KYFeb 5, 1964 · N2314J · Substantial damageNTSB UNK64X0193Accident · No injuriesClosedBeechcraft B35 · Covington, KYJan 9, 1964 · CFKVL · Substantial damageNTSB UNK64X0156Accident · No injuriesClosedBeechcraft B35 · Pikeville, KYJan 4, 1964 · N9766Y · Substantial damage