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

Cases per year

19642026
NTSB investigations, 1965, 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\") = 1965
    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 CHI66F0502Accident · No injuriesClosedBeechcraft B55 · Paducah, KYDec 24, 1965 · N5812S · Substantial damageNTSB CHI66A0057Accident · 2 fatalClosedCessna 172 · Stone, KYDec 10, 1965 · N3947S · DestroyedNTSB CHI66A0056Accident · 6 fatalClosedAero CDR 680 · Kite, KYDec 6, 1965 · N6819S · DestroyedNTSB CHI66F0489Accident · No injuriesClosedBeechcraft B-95 · Gilbertsville, KYDec 3, 1965 · N962T · Substantial damageNTSB CHI66F0404Accident · No injuriesClosedBeech C35 · Georgetown, KYNov 13, 1965 · N1950D · Substantial damageNTSB DCA66A0003Accident · 58 fatalClosedBoeing B-727 · Constance, KYNov 8, 1965 · N1996 · DestroyedNTSB CHI66F0396Accident · No injuriesClosedCessna 172 · Lexington, KYNov 7, 1965 · N5681T · Substantial damageNTSB CHI66A0043Accident · 3 fatalClosedBeech 35 · Reed, KYOct 24, 1965 · N443B · DestroyedNTSB CHI66D0393Accident · No injuriesClosedCessna 182 · Golden Pond, KYOct 9, 1965 · N8483S · Substantial damageNTSB CHI66F0326Accident · No injuriesClosedPiper PA-28 · Fulton, KYOct 8, 1965 · N8711W · Substantial damageNTSB CHI66F0383Accident · No injuriesClosedBeechcraft 95 · Louisville, KYOct 5, 1965 · N2740Y · Substantial damageNTSB CHI66F0335Accident · Minor injuriesClosedAeronca 7AC · Poplar Plains, KYOct 3, 1965 · N84001 · DestroyedNTSB CHI66D0320Accident · No injuriesClosedCessna 210 · Munfordville, KYSep 28, 1965 · N3656Y · Substantial damageNTSB CHI66A0025Accident · 1 fatalClosedDouglas DC3 · Louisville, KYSep 10, 1965 · N272R · 2 aircraft · Substantial damageNTSB CHI66F0210Accident · No injuriesClosedTaylorcraft BC12-D · Richardville, KYSep 6, 1965 · N44133 · Substantial damageNTSB CHI66F0302Accident · No injuriesClosedMooney M20C · Owensboro, KYSep 1, 1965 · N6487U · Substantial damageNTSB CHI66F0200Accident · No injuriesClosedCessna 175 · Somerset, KYAug 15, 1965 · N7104 · DestroyedNTSB CHI66F0148Accident · No injuriesClosedPiper PA-28 · Georgetown, KYJul 31, 1965 · N5873W · Substantial damageNTSB CHI66F0139Accident · Serious injuriesClosedPiper PA-22 · Golden Pond, KYJul 30, 1965 · N9224D · Substantial damageNTSB CHI66F0100Accident · No injuriesClosedPiper PA-25 · Melber, KYJul 26, 1965 · N6251Z · Substantial damageNTSB CHI66A0010Accident · No injuriesClosedHughes 269A-1 · Lynch, KYJul 26, 1965 · N8938F · Substantial damageNTSB CHI66D0084Accident · No injuriesClosedCessna 182 · Greenville, KYJul 16, 1965 · N5155D · Substantial damageNTSB CHI66F0083Accident · No injuriesClosedPiper PA-24 · Winchester, KYJul 7, 1965 · N7522P · Substantial damageNTSB UNK65X1514Accident · No injuriesClosedCessna 170 · West Liberty, KYJul 5, 1965 · N3836V · Substantial damageNTSB CHI66F0044Accident · Serious injuriesClosedCessna 170B · Herndon, KYJul 5, 1965 · N2276D · DestroyedNTSB CHI66A0004Accident · 1 fatalClosedAeronca 7AC · Pulaski, KYJul 5, 1965 · N2009E · DestroyedNTSB CHI66F0079Accident · No injuriesClosedPiper PA-22 · Columbia, KYJul 4, 1965 · N4550A · Substantial damageNTSB CHI66F0063Accident · No injuriesClosedMooney M20C · Paintsville, KYJun 26, 1965 · N5651Q · Substantial damageNTSB CHI66F0001Accident · No injuriesClosedPiper PA-24 · Louisville, KYJun 24, 1965 · N6780P · Substantial damageNTSB CHI66F0024Accident · No injuriesClosedPiper PA-28B · Murray, KYJun 12, 1965 · N5633W · Substantial damageNTSB CHI66F0039Accident · No injuriesClosedAeronca 7AC · Water Valley, KYJun 7, 1965 · N7556E · Substantial damageNTSB CHI65A0099Accident · 2 fatalClosedBeechcraft K35 · Whitesburg, KYJun 2, 1965 · N129JD · DestroyedNTSB CHI66F0066Accident · No injuriesClosedMooney M20C · Pikeville, KYMay 30, 1965 · N6508U · DestroyedNTSB CHI66F0019Accident · No injuriesClosedCessna 172 · Georgetown, KYMay 29, 1965 · N3921S · DestroyedNTSB CHI65F0204Accident · No injuriesClosedCessna 120 · Monticello, KYMay 23, 1965 · N72892 · Substantial damageNTSB CHI65F0125Accident · No injuriesClosedAeronca 7AC · Buffalo, KYMay 11, 1965 · N83459 · DestroyedNTSB CHI65F0126Accident · No injuriesClosedPiper PA-22 · Paducah, KYMay 8, 1965 · N3605A · Substantial damageNTSB CHI65D0103Accident · No injuriesClosedCessna 182C · Pikeville, KYApr 17, 1965 · N8785T · Substantial damageNTSB CHI65F0096Accident · No injuriesClosedPiper PA-24 · Monticello, KYApr 14, 1965 · N7410P · Substantial damageNTSB CHI65F0097Accident · No injuriesClosedPiper PA-25 · Berlin, KYApr 11, 1965 · N7366Z · Substantial damageNTSB CHI65F0086Accident · No injuriesClosedAeronca 7AC · Cynthiana, KYApr 4, 1965 · N83135 · Substantial damageNTSB CHI65D0065Accident · No injuriesClosedCessna 172 · Winchester, KYMar 22, 1965 · N3777S · Substantial damageNTSB CHI65D0045Accident · No injuriesClosedCessna 150 · Arrollton, KYMar 12, 1965 · N5738E · Substantial damageNTSB CHI65F0075Accident · Serious injuriesClosedBeechcraft M-35 · Smithland, KYMar 8, 1965 · N9627R · DestroyedNTSB CHI65F0050Accident · No injuriesClosedPiper PA-28 · Paducah, KYFeb 22, 1965 · N5498W · Substantial damageNTSB CHI65I0072Incident · No injuriesClosedBoeing B-727 · Covington, KYFeb 6, 1965 · N1975 · No damageNTSB CHI65F0015Accident · Serious injuriesClosedMooney M20A · Versailles, KYFeb 3, 1965 · N1098B · DestroyedNTSB CHI65F0017Accident · Minor injuriesClosedCessna 182 · Lexington, KYJan 31, 1965 · N3188Y · Substantial damageNTSB UNK65X1306Accident · No injuriesClosedCessna 172 · Manchester, KYJan 18, 1965 · N7879T · Substantial damageNTSB CHI65F0024Accident · No injuriesClosedMooney M20E · Louisville, KYJan 12, 1965 · N1937Y · Substantial damage