NTSB investigations, 1980, 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, 1980, 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\") = 1980
    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 ATL81DLQ08Accident · No injuriesClosedAmer Avco AA-5A · Murry, KYDec 27, 1980 · N26930 · Substantial damageNTSB ATL81FLQ07Accident · Minor injuriesClosedPiper PA-23 · Louisville, KYDec 6, 1980 · N2116P · DestroyedNTSB ATL81FA022Accident · 3 fatalClosedSwearigen SA26AT · Albany, KYDec 2, 1980 · N177MF · DestroyedNTSB ATL81FLQ06Accident · Minor injuriesClosedCessna 182 · Hazard, KYNov 30, 1980 · N2879R · Substantial damageNTSB ATL81FLQ05Accident · No injuriesClosedHelio Acft HT-295 · Mt Sterling, KYNov 20, 1980 · N5384G · DestroyedNTSB ATL81FA018Accident · 2 fatalClosedPiper PA-28 · Corbin, KYNov 15, 1980 · N6964J · DestroyedNTSB ATL81FA016Accident · 3 fatalClosedBell 206B · Liberty, KYNov 13, 1980 · N90015 · DestroyedNTSB ATL81DLQ04Accident · No injuriesClosedGreat Lakes Baby · Burnside, KYOct 21, 1980 · N29BP · Minor damageNTSB ATL81DLQ03Accident · Serious injuriesClosedCessna 172M · Waddy, KYOct 13, 1980 · N64517 · Substantial damageNTSB ATL81DLQ02Accident · No injuriesClosedBell 47G-2A · South Shore, KYOct 13, 1980 · N9726 · DestroyedNTSB ATL80DLQ01Accident · No injuriesClosedPiper PA-25 · Paducah, KYOct 1, 1980 · N7243Z · Substantial damageNTSB ATL80FLQ29Accident · No injuriesClosedPiper PA-31 · Paducah, KYSep 18, 1980 · N777EB · Substantial damageNTSB ATL80FLQ28Accident · Minor injuriesClosedPiper PA-28 · Morehead, KYSep 14, 1980 · N6481W · DestroyedNTSB ATL80DLQ27Accident · No injuriesClosedCessna 150M · Somerset, KYAug 30, 1980 · N704FG · Substantial damageNTSB ATL80DLQ25Accident · Serious injuriesClosedSchweizer SGS233 · Frankfort, KYAug 10, 1980 · N17894 · DestroyedNTSB ATL80FA083Accident · 1 fatalClosedCessna 150 · Henderson, KYAug 9, 1980 · N7265X · DestroyedNTSB ATL80FLQ26Accident · No injuriesClosedCessna P210N · Lexington, KYAug 3, 1980 · N4794K · Substantial damageNTSB ATL80FLQ24Accident · Serious injuriesClosedPiper PA-28 · Louisville, KYAug 1, 1980 · N2089C · Substantial damageNTSB ATL80FA079Accident · No injuriesClosedLear Jet 25 · Paducah, KYJul 30, 1980 · N8CL · Substantial damageNTSB ATL80FA078Accident · 3 fatalClosedPiper PA-28 · Pikeville, KYJul 26, 1980 · N8357W · DestroyedNTSB ATL80FLQ22Accident · No injuriesClosedGrumman G-164A · Garfield, KYJul 14, 1980 · N5401 · DestroyedNTSB ATL80DLQ21Accident · No injuriesClosedCessna 172 · Morgantown, KYJul 8, 1980 · N1618F · Substantial damageNTSB ATL80FA058Accident · 4 fatalClosedCessna 172N · West Liberty, KYJun 20, 1980 · N734YT · DestroyedNTSB ATL80FLQ20Accident · No injuriesClosedPiper PA-32 · Louisville, KYJun 10, 1980 · N2032M · Substantial damageNTSB ATL80FLQ19Accident · Serious injuriesClosedErco 415-C · Shepherdstown, KYJun 7, 1980 · N99652 · Substantial damageNTSB ATL80DLQ23Accident · No injuriesClosedGrumman G-164B · Scottsville, KYJun 3, 1980 · N48721 · Substantial damageNTSB IAD80DLQ18Accident · Minor injuriesClosedCessna 150L · Bowling Green, KYMay 26, 1980 · N16178 · DestroyedNTSB ATL80IA046Incident · No injuriesClosedAerospatle SA341G · Greasy Creek, KYMay 14, 1980 · N341SC · No damageNTSB ATL80FA045Accident · 1 fatalClosedCessna 150 · Pikeville, KYMay 10, 1980 · N50931 · DestroyedNTSB IAD80FA042Accident · 1 fatalClosedPiper PA-28 · Bowling Green, KYApr 22, 1980 · N32992 · DestroyedNTSB IAD80FLQ17Accident · No injuriesClosedPiper PA-28 · Anchorage, KYApr 20, 1980 · N1744J · Substantial damageNTSB IAD80FA040Accident · 4 fatalClosedPiper PA-28 · Falmouth, KYApr 20, 1980 · N8907J · DestroyedNTSB IAD80FLQ16Accident · Minor injuriesClosedBellanca 7ECA · Lexington, KYApr 2, 1980 · N11857 · Substantial damageNTSB IAD80FLQ15Accident · Minor injuriesClosedBell 206L · Pikeville, KYMar 11, 1980 · N2780Y · DestroyedNTSB IAD80FLQ14Accident · Serious injuriesClosedPiper PA-24 · Lexington, KYFeb 29, 1980 · N8574P · Substantial damageNTSB IAD80FA028Accident · No injuriesClosedCessna 404 · Lexington, KYFeb 25, 1980 · N406EX · Substantial damageNTSB IAD80FA027Accident · 1 fatalClosedCessna 150 · Reidland, KYFeb 24, 1980 · N1678Q · DestroyedNTSB IAD80DLQ13Accident · Serious injuriesClosedCessna 177 · Albany, KYFeb 23, 1980 · N3491T · DestroyedNTSB IAD80FLQ12Accident · No injuriesClosedCessna 150 · Louisville, KYFeb 17, 1980 · N63416 · Substantial damageNTSB IAD80DLQ11Accident · No injuriesClosedMooney M20F · Albany, KYJan 26, 1980 · N6960V · Substantial damageNTSB IAD80FLQ10Accident · Serious injuriesClosedHughes 500D · Dione, KYJan 11, 1980 · N9163F · DestroyedNTSB IAD80FLQ08Accident · Minor injuriesClosedBell 206B · Shelbyville, KYJan 4, 1980 · N77HB · Substantial damageNTSB IAD80DLQ09Accident · Minor injuriesClosedCessna 172M · Gilbertsville, KYJan 4, 1980 · N4493R · Substantial damage