NTSB investigations, 1969, 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, 1969, 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\") = 1969
    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 CHI70F0387Accident · Serious injuriesClosedCessna 150 · Lebanon, KYDec 8, 1969 · N3669J · DestroyedNTSB CHI70F0378Accident · Serious injuriesClosedCessna 172 · Ford, KYNov 20, 1969 · N84173 · DestroyedNTSB MKC70A0026Accident · 1 fatalClosedCessna 182 · Elizabethtown, KYNov 9, 1969 · N6475A · DestroyedNTSB CHI70F0329Accident · No injuriesClosedCessna 150 · Cherokee Sta, KYNov 8, 1969 · N22664 · Substantial damageNTSB CHI70A0031Accident · 6 fatalClosedPiper PA-32 · Jonestown, KYNov 8, 1969 · N3668W · DestroyedNTSB CHI70D0269Accident · No injuriesClosedPiper PA-22 · Walsh, KYOct 4, 1969 · N4677Z · Substantial damageNTSB CHI70D0277Accident · No injuriesClosedCessna 177 · Columbia, KYOct 3, 1969 · N3248T · Substantial damageNTSB CHI70D0327Accident · Serious injuriesClosedCessna 150 · Columbia, KYSep 28, 1969 · N7771F · DestroyedNTSB CHI70D0268Accident · No injuriesClosedPiper PA-25 · Lynnville, KYSep 25, 1969 · N7260Z · Substantial damageNTSB CHI70D0024Accident · No injuriesClosedCessna 150 · Louisville, KYSep 15, 1969 · N5747G · Substantial damageNTSB CHI70D0216Accident · No injuriesClosedPiper PA-28 · Georgetown, KYSep 5, 1969 · N8477W · Substantial damageNTSB CHI70F0239Accident · Minor injuriesClosedPiper PA-28 · Frankfort, KYSep 3, 1969 · N1514J · Substantial damageNTSB CHI70F0245Accident · No injuriesClosedErco 415-C · Berea, KYSep 2, 1969 · N2806H · Substantial damageNTSB CHI70F0189Accident · Minor injuriesClosedCessna 175A · Columbia, KYAug 17, 1969 · N6940E · Substantial damageNTSB CHI70F0169Accident · Minor injuriesClosedDehavilland DHC1B2 · Henderson, KYAug 15, 1969 · N280S · Substantial damageNTSB CHI70F0166Accident · Minor injuriesClosedCassutt HL-1 · Henderson, KYAug 15, 1969 · N4651T · Substantial damageNTSB CHI70D0172Accident · No injuriesClosedHughes 269B · Paint Lick, KYAug 10, 1969 · N9467F · Substantial damageNTSB CHI70D0178Accident · No injuriesClosedCessna 150 · Owensboro, KYAug 7, 1969 · N6367S · Substantial damageNTSB CHI70D0180Accident · No injuriesClosedPiper PA-28R · Denniston, KYAug 3, 1969 · N7483J · Substantial damageNTSB CHI70D0165Accident · No injuriesClosedCessna 210 · Lexington, KYJul 29, 1969 · N9578T · Substantial damageNTSB CHI70F0199Accident · Minor injuriesClosedCessna 177 · Shelbyville, KYJul 28, 1969 · N29557 · DestroyedNTSB CHI70F0171Accident · Serious injuriesClosedPiper PA-23 · Corbin, KYJul 22, 1969 · N4754P · Substantial damageNTSB CHI70F0181Accident · No injuriesClosedPiper PA-25 · Harrodsburg, KYJul 12, 1969 · XB-VUU · Substantial damageNTSB CHI70D0068Accident · No injuriesClosedRyan ST-3KR · Bowling Green, KYJul 6, 1969 · N54403 · Substantial damageNTSB CHI70D0124Accident · No injuriesClosedCessna 182 · Fulton, KYJul 4, 1969 · N2922F · Substantial damageNTSB CHI70A0001Accident · 2 fatalClosedPiper PA-18 · Lagrange, KYJul 3, 1969 · N5976Z · DestroyedNTSB CHI70F0081Accident · No injuriesClosedPiper PA-30 · Owensboro, KYJun 19, 1969 · N8760Y · Substantial damageNTSB CHI70D0056Accident · No injuriesClosedBell 47G-4A · Cumberland, KYJun 19, 1969 · N520PA · Substantial damageNTSB CHI70D0010Accident · No injuriesClosedRepublic RC-3 · Albany, KYJun 8, 1969 · N6011K · Substantial damageNTSB CHI70D0023Accident · No injuriesClosedPiper PA-28 · Hardinsburg, KYJun 7, 1969 · N1520J · Substantial damageNTSB CHI70D0021Accident · No injuriesClosedPiper J3C-65 · Shepherdsville, KYJun 4, 1969 · N6719H · Substantial damageNTSB CHI70F0008Accident · Serious injuriesClosedCessna 150 · Lexington, KYMay 28, 1969 · N50829 · DestroyedNTSB CHI69D0669Accident · Minor injuriesClosedCessna 150H · Middletown, KYMay 13, 1969 · N22373 · Substantial damageNTSB CHI70F0002Accident · No injuriesClosedMooney M20F · Waddy, KYMay 12, 1969 · N3292F · Substantial damageNTSB CHI69F0658Accident · Minor injuriesClosedCessna 210-5 · Fort Knox, KYMay 10, 1969 · N8342Z · DestroyedNTSB CHI69I0093Incident · No injuriesClosedFairchild FH-227 · Ashland, KYMay 9, 1969 · N708U · Minor damageNTSB CHI70F0004Accident · No injuriesClosedCallair A-9 · Cayce, KYMay 5, 1969 · N3583G · Substantial damageNTSB CHI69I0091Incident · No injuriesClosedBeech D18S · Lexington, KYMay 5, 1969 · N57CC · Minor damageNTSB CHI70D0001Accident · No injuriesClosedCessna 140 · Shepherdsville, KYMay 4, 1969 · N3598V · Substantial damageNTSB CHI69A0089Accident · 1 fatalClosedCessna 150 · Prospect, KYApr 30, 1969 · N8498G · DestroyedNTSB CHI69F0592Accident · No injuriesClosedCessna 172 · Somerset, KYApr 25, 1969 · N3943S · Substantial damageNTSB CHI69D0644Accident · No injuriesClosedPiper PA-18 · Henderson, KYApr 16, 1969 · N3294Z · Substantial damageNTSB CHI69F0583Accident · Minor injuriesClosedCessna 140 · West Paducah, KYApr 12, 1969 · N72616 · DestroyedNTSB CHI69F0561Accident · Minor injuriesClosedCessna 172I · Florence, KYApr 11, 1969 · N35582 · Substantial damageNTSB CHI69A0080Accident · 1 fatalClosedPiper PA-23 · Bowling Green, KYMar 12, 1969 · N3017P · DestroyedNTSB CHI69F0553Accident · No injuriesClosedBeech 65-80 · Louisville, KYMar 5, 1969 · N503SB · Substantial damage