NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 CHI67F0358Accident · No injuriesClosedBeech F35 · Erlanger, KYNov 28, 1966 · N5057B · Substantial damageNTSB CHI67D0394Accident · No injuriesClosedPiper PA-24 · Greensburg, KYNov 6, 1966 · N6311P · Substantial damageNTSB CHI67A0060Accident · 4 fatalClosedBeech G35 · Cadiz, KYNov 5, 1966 · N4674D · DestroyedNTSB CHI67A0057Accident · 1 fatalClosedHughes 269B · Lexington, KYOct 28, 1966 · N9461F · DestroyedNTSB CHI67D0408Accident · No injuriesClosedMooney M20C · Pikeville, KYOct 25, 1966 · N6064Q · Substantial damageNTSB CHI67D0342Accident · Minor injuriesClosedCessna 150D · London, KYOct 21, 1966 · N4145U · Substantial damageNTSB CHI67D0308Accident · No injuriesClosedPiper PA-24 · Danville, KYOct 21, 1966 · N6176P · Substantial damageNTSB CHI67F0307Accident · No injuriesClosedPiper PA-22 · Somerset, KYOct 5, 1966 · N4751A · Substantial damageNTSB CHI67F0151Accident · No injuriesClosedPiper PA-30 · Louisville, KYSep 14, 1966 · N7727Y · Substantial damageNTSB CHI67D0227Accident · No injuriesClosedBeech A23 · Columbia, KYSep 1, 1966 · N5789V · Substantial damageNTSB CHI67F0150Accident · No injuriesClosedBeech D35 · Hazard, KYAug 27, 1966 · N3442B · Substantial damageNTSB CHI67F0177Accident · Serious injuriesClosedPiper PA-28 · Williamstown, KYAug 21, 1966 · N9401J · DestroyedNTSB CHI67A0023Accident · No injuriesClosedHawker-Sdly DH-125 · Paducah, KYAug 15, 1966 · N926G · Substantial damageNTSB CHI67A0021Accident · 1 fatalClosedCessna 172 · Chavies, KYAug 8, 1966 · N3894L · DestroyedNTSB CHI67F0119Accident · Minor injuriesClosedCessna 172 · Shelbyville, KYAug 7, 1966 · N8590B · Substantial damageNTSB CHI67D0246Accident · No injuriesClosedPiper PA-24 · Lancaster, KYJul 16, 1966 · N5557P · Substantial damageNTSB CHI67D0074Accident · No injuriesClosedPiper J-3 · Columbia, KYJul 9, 1966 · N6104H · Substantial damageNTSB CHI67A0005Accident · No injuriesClosedBell 47G-2A · Slemp, KYJul 9, 1966 · N73219 · Substantial damageNTSB CHI67I0003Incident · No injuriesClosedNord 262 · Erlanger, KYJul 7, 1966 · N26210 · Minor damageNTSB CHI67D0149Accident · No injuriesClosedCessna 210 · Glasgow, KYJul 4, 1966 · N4907U · Substantial damageNTSB CHI66F0776Accident · No injuriesClosedPiper PA23 · Louisville, KYJun 13, 1966 · N1258P · Substantial damageNTSB CHI66A0093Accident · 1 fatalClosedBoeing B75N1 · Franklin, KYMay 28, 1966 · N4629N · DestroyedNTSB CHI66D0737Accident · No injuriesClosedPiper PA-22 · Flemingsburg, KYApr 29, 1966 · N3647Z · Substantial damageNTSB CHI66D0710Accident · No injuriesClosedCessna 310 · Lexington, KYApr 28, 1966 · N3056D · Substantial damageNTSB CHI66D0713Accident · Minor injuriesClosedCessna 172E · Albany, KYApr 7, 1966 · N5737T · DestroyedNTSB CHI66D0655Accident · No injuriesClosedBeech V35 · Mt Sterling, KYApr 1, 1966 · N2073W · Substantial damageNTSB CHI66A0071Accident · 2 fatalClosedBeech J35 · Corinth, KYMar 2, 1966 · N8354D · DestroyedNTSB CHI66A0069Accident · 2 fatalClosedPiper PA-22 · London, KYFeb 19, 1966 · N6750B · DestroyedNTSB CHI66F0564Accident · No injuriesClosedBeechcraft G35 · Manchester, KYFeb 6, 1966 · N4297D · Substantial damageNTSB CHI66D0525Accident · No injuriesClosedBeechcraft A35 · Cynthiana, KYJan 11, 1966 · N275H · Substantial damageNTSB CHI66D0519Accident · No injuriesClosedCessna 150 · Russelville, KYJan 9, 1966 · N5986E · Substantial damageNTSB CHI66A0061Accident · 2 fatalClosedCessna 182G · Maysville, KYJan 4, 1966 · N2141R · Destroyed