NTSB investigations, 1976, 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, 1976, 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\") = 1976
    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 IAD77DLQ04Accident · Minor injuriesClosedCessna 150 · Trenton, KYDec 22, 1976 · N11269 · DestroyedNTSB IAD77DLQ03Accident · Minor injuriesClosedCessna 175 · Middlesboro, KYDec 14, 1976 · N7244M · Substantial damageNTSB IAD77FA014Accident · 4 fatalClosedPiper PA-23 · Lexington, KYNov 28, 1976 · N4423P · DestroyedNTSB IAD77FLQ02Accident · No injuriesClosedCessna 150 · Hopkinsville, KYOct 16, 1976 · N23270 · Substantial damageNTSB IAD77FA001Accident · 1 fatalClosedCessna 182 · Hudson, KYOct 2, 1976 · N2907Y · DestroyedNTSB IAD76FLQ01Accident · No injuriesClosedGrumman G-164A · Elkton, KYOct 1, 1976 · N5401 · DestroyedNTSB IAD76FLQ36Accident · No injuriesClosedMitsubishi MU-2B · Louisville, KYSep 29, 1976 · N122G · Substantial damageNTSB IAD76DLQ33Accident · Minor injuriesClosedDehavilland MK23 · Chavies, KYSep 29, 1976 · N31105 · Substantial damageNTSB IAD76AI101Accident · Minor injuriesClosedRepublic RC-3 · Danville, KYSep 25, 1976 · N6468K · DestroyedNTSB IAD76DLQ35Accident · No injuriesClosedGrumman G-164 · Elkton, KYSep 14, 1976 · N463Y · DestroyedNTSB IAD76DLQ32Accident · No injuriesClosedAmerican AA-1 · Murray, KYAug 28, 1976 · N5745L · Substantial damageNTSB IAD76DIJ17Accident · Minor injuriesClosedCessna 182 · Kimball, KYAug 25, 1976 · N91688 · DestroyedNTSB IAD76DLQ31Accident · No injuriesClosedPiper PA-28 · Frakes, KYAug 21, 1976 · N7709W · Substantial damageNTSB IAD76II093Incident · No injuriesClosedBeech B99 · Owensboro, KYAug 13, 1976 · N12AK · No damageNTSB IAD76FLQ34Accident · Minor injuriesClosedCessna 175 · Bedford, KYAug 11, 1976 · N8152T · Substantial damageNTSB IAD76DLQ30Accident · No injuriesClosedCessna 182 · Covington, KYAug 10, 1976 · N2766F · Substantial damageNTSB IAD76FLQ37Accident · 1 fatalClosedPitts S-1S · Owensboro, KYJul 30, 1976 · N7PJ · DestroyedNTSB IAD76AI085Accident · 1 fatalClosedGrum Amer AA-5A · Lexington, KYJul 22, 1976 · N9778U · DestroyedNTSB IAD76DLQ29Accident · No injuriesClosedPiper PA-25 · Smithland, KYJul 12, 1976 · N8641L · Substantial damageNTSB IAD76DLQ27Accident · No injuriesClosedPiper PA-28 · Williamsburg, KYJul 8, 1976 · N44534 · Substantial damageNTSB IAD76AI081Accident · 3 fatalClosedCessna 150 · Elkhorn City, KYJul 4, 1976 · N9238U · Substantial damageNTSB IAD76DLQ25Accident · No injuriesClosedCessna 150 · Hodgenville, KYJul 3, 1976 · N10660 · Substantial damageNTSB IAD76FLQ26Accident · Serious injuriesClosedPiper PA-18A · Albany, KYJul 1, 1976 · N3589A · Substantial damageNTSB IAD76DLQ28Accident · No injuriesClosedCessna 150 · Cynthiana, KYJun 26, 1976 · N8621J · 2 aircraft · Minor damageNTSB IAD76FLQ24Accident · Serious injuriesClosedPiper PA-24 · Cold Springs, KYJun 20, 1976 · N6232P · Substantial damageNTSB IAD76AI076Accident · 2 fatalClosedPiper PA-23 · West Liberty, KYJun 12, 1976 · N852PS · DestroyedNTSB IAD76FLQ23Accident · No injuriesClosedPiper PA-28 · Richmond, KYJun 5, 1976 · N32219 · Substantial damageNTSB IAD76DLQ22Accident · No injuriesClosedBeech C35 · Bronston, KYMay 24, 1976 · N631Z · Substantial damageNTSB IAD76AI074Accident · 2 fatalClosedCassutt IIM · Sturgis, KYMay 23, 1976 · N18PM · 2 aircraft · DestroyedNTSB IAD76AI072Accident · 2 fatalClosedAerostar 600 · Morganfield, KYMay 8, 1976 · N7549S · DestroyedNTSB IAD76AI071Accident · 1 fatalClosedPiper PA-24 · Farmers, KYMay 6, 1976 · N6026P · DestroyedNTSB IAD76FLQ21Accident · No injuriesClosedPiper PA-28 · Jeffersontown, KYMay 1, 1976 · N7214F · Substantial damageNTSB IAD76FLQ20Accident · No injuriesClosedPiper PA-31P · Paintsville, KYApr 27, 1976 · N6845L · Substantial damageNTSB IAD76DLQ19Accident · No injuriesClosedMooney M20 · Whitesburg, KYApr 24, 1976 · N7462V · Substantial damageNTSB IAD76FLQ18Accident · No injuriesClosedPiper PA-34 · Lexington, KYApr 20, 1976 · N55322 · Substantial damageNTSB IAD76FLQ17Accident · Minor injuriesClosedPiper PA-32 · Louisville, KYApr 6, 1976 · N711PF · Substantial damageNTSB IAD76FLQ16Accident · Minor injuriesClosedCessna 140 · Bardstown, KYMar 18, 1976 · N2216N · Substantial damageNTSB IAD76AI061Accident · 1 fatalClosedBeech C23 · Owensboro, KYMar 9, 1976 · N2162W · DestroyedNTSB IAD76DLQ14Accident · No injuriesClosedMine-Copter R100 · Pikeville, KYFeb 20, 1976 · N2137 · Substantial damageNTSB IAD76FLQ13Accident · No injuriesClosedCessna 172D · Lexington, KYFeb 10, 1976 · N2765U · Substantial damageNTSB IAD76AI049Accident · Serious injuriesClosedBeech E18S · Ft Campbell, KYJan 13, 1976 · N218A · Substantial damageNTSB IAD76FLQ12Accident · No injuriesClosedPiper PA-28 · Elizabethtown, KYJan 3, 1976 · N32288 · Substantial damage