NTSB investigations, 1968, KY

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1968, 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\") = 1968
    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 CHI69F0380Accident · Minor injuriesClosedAero Comdr 500-A · Paducah, KYNov 27, 1968 · N9381R · DestroyedNTSB CHI69D0478Accident · No injuriesClosedCessna 150 · Pikeville, KYNov 26, 1968 · N2981S · Substantial damageNTSB CHI69F0361Accident · No injuriesClosedMooney M20E · Louisville, KYNov 17, 1968 · N5731Q · Substantial damageNTSB CHI69D0352Accident · Minor injuriesClosedBensen B8M · Gilbertsville, KYNov 10, 1968 · N336Y · DestroyedNTSB CHI69F0322Accident · Minor injuriesClosedPiper J3C-65 · Nicholasville, KYOct 27, 1968 · N68928 · Substantial damageNTSB CHI69D0323Accident · No injuriesClosedMaule M-4 · Midway, KYOct 26, 1968 · N9826M · Substantial damageNTSB CHI69F0279Accident · No injuriesClosedCessna 150 · Hodgenville, KYOct 22, 1968 · N3032S · Substantial damageNTSB CHI69D0280Accident · No injuriesClosedCessna 172 · Edmonton, KYOct 3, 1968 · N7714T · Substantial damageNTSB CHI69D0243Accident · No injuriesClosedCessna 182H · Louisville, KYSep 29, 1968 · N8513S · Substantial damageNTSB CHI69F0293Accident · Minor injuriesClosedPiper PA-22 · Morningview, KYSep 28, 1968 · N3542A · Substantial damageNTSB CHI69A0031Accident · Serious injuriesClosedCessna 402 · Paducah, KYSep 17, 1968 · N3259Q · DestroyedNTSB CHI69F0244Accident · No injuriesClosedCessna 150 · Oscar, KYSep 7, 1968 · N23354 · Substantial damageNTSB CHI69F0290Accident · No injuriesClosedPiper PA-30 · Manchester, KYSep 6, 1968 · N7185Y · Substantial damageNTSB CHI69F0262Accident · Serious injuriesClosedPiper PA-28 · Burgin, KYSep 3, 1968 · N7016R · DestroyedNTSB CHI69D0282Accident · No injuriesClosedCessna 150 · Lynnville, KYAug 25, 1968 · N4422U · DestroyedNTSB CHI69A0020Accident · Serious injuriesClosedCessna 172H · Aurora, KYAug 16, 1968 · N1453F · DestroyedNTSB CHI69F0185Accident · No injuriesClosedCessna 172F · Georgetown, KYAug 12, 1968 · N8596U · Substantial damageNTSB CHI69F0237Accident · No injuriesClosedPiper PA-23 · Somerset, KYAug 10, 1968 · N2088P · Substantial damageNTSB CHI69F0229Accident · No injuriesClosedCessna 182K · Somerset, KYAug 8, 1968 · N2472Q · Substantial damageNTSB CHI69D0122Accident · Minor injuriesClosedCessna 120 · Mannsville, KYAug 2, 1968 · N2536N · Substantial damageNTSB CHI69F0216Accident · No injuriesClosedBeech 95-C55 · Cherokee, KYAug 1, 1968 · N411L · Substantial damageNTSB CHI69D0273Accident · No injuriesClosedCessna 182 · Carrollton, KYAug 1, 1968 · N5684B · Substantial damageNTSB CHI69F0152Accident · No injuriesClosedSikorsky S-58A · Robinson Creek, KYJul 28, 1968 · N4247 · Substantial damageNTSB CHI69F0110Accident · No injuriesClosedPiper PA-28 · Hebron, KYJul 27, 1968 · N7326W · Substantial damageNTSB CHI69D0215Accident · Minor injuriesClosedBeech 35 · Prestonburg, KYJul 26, 1968 · N2930V · DestroyedNTSB CHI69D0124Accident · No injuriesClosedCessna 172G · Allen, KYJul 25, 1968 · N3999L · DestroyedNTSB CHI69D0105Accident · No injuriesClosedPiper PA-30 · Prestonsburg, KYJul 25, 1968 · N8045Y · Substantial damageNTSB CHI69F0177Accident · No injuriesClosedPiper J3C-65 · Cynthiana, KYJul 21, 1968 · N32754 · Substantial damageNTSB CHI69D0097Accident · No injuriesClosedPiper PA-22 · Salyersville, KYJul 14, 1968 · N7137D · Substantial damageNTSB CHI69A0004Accident · 1 fatalClosedPiper PA-28 · Hazard, KYJul 4, 1968 · N9804W · DestroyedNTSB CHI69D0206Accident · No injuriesClosedCessna 150 · Mt Sterling, KYJul 2, 1968 · N1247Y · Substantial damageNTSB CHI69A0002Accident · Minor injuriesClosedCessna 177 · Pikeville, KYJul 2, 1968 · N3345T · Substantial damageNTSB CHI69F0074Accident · Minor injuriesClosedHughes 269B · Louisville, KYJun 24, 1968 · N9465F · Substantial damageNTSB CHI69D0035Accident · Minor injuriesClosedPiper PA-28 · Lewisburg, KYJun 12, 1968 · N4215J · DestroyedNTSB CHI69F0028Accident · Serious injuriesClosedNavion A · Fountain Run, KYJun 9, 1968 · N8718H · DestroyedNTSB CHI69F0041Accident · Minor injuriesClosedCessna 172 · Campbellsville, KYMay 30, 1968 · N3704S · DestroyedNTSB CHI69F0002Accident · 1 fatalClosedPitts SPL S-1C · Lone Oak, KYMay 27, 1968 · N1114S · DestroyedNTSB CHI68F0736Accident · No injuriesClosedPiper PA-30 · Louisville, KYMay 10, 1968 · N8331Y · Substantial damageNTSB CHI68F0711Accident · No injuriesClosedCessna 150 · West Paducah, KYApr 26, 1968 · N4127U · Substantial damageNTSB CHI68D0697Accident · No injuriesClosedPiper PA-28 · Cropper, KYApr 21, 1968 · N1514J · Substantial damageNTSB CHI68F0731Accident · No injuriesClosedCessna 150 · Frankfort, KYApr 20, 1968 · N4616X · Substantial damageNTSB CHI68F0688Accident · Serious injuriesClosedPiper PA-22 · Midway, KYApr 6, 1968 · N4838Z · DestroyedNTSB CHI68F0693Accident · No injuriesClosedPiper PA-28 · Campbellsville, KYMar 28, 1968 · N5846W · Substantial damageNTSB CHI68D0659Accident · No injuriesClosedCessna 182 · Harlan, KYMar 17, 1968 · N4996D · Substantial damageNTSB CHI68D0599Accident · No injuriesClosedAero Comdr 560A · Lexington, KYFeb 28, 1968 · N2731B · Substantial damageNTSB CHI68D0624Accident · No injuriesClosedBeech A23-24 · Owensboro, KYFeb 25, 1968 · N3666Q · Substantial damageNTSB CHI68D0597Accident · No injuriesClosedAeronca 7AC · Princeton, KYFeb 13, 1968 · N85783 · Substantial damageNTSB CHI68D0602Accident · No injuriesClosedPiper PA-30 · Pikeville, KYFeb 12, 1968 · N8363Y · Substantial damageNTSB CHI68F0660Accident · No injuriesClosedCessna 182C · River, KYFeb 9, 1968 · N2657G · Substantial damageNTSB CHI68F0572Accident · Minor injuriesClosedCessna 150F · Junction City, KYFeb 6, 1968 · N3581L · Destroyed