NTSB investigations, 1980, OH

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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

19622026
NTSB investigations, 1980, OH per year, 1962–2026: 4,364 cases
19621
19631
1964199
1965184
1966193
1967189
1968187
1969129
1970142
1971147
1972121
1973124
1974142
1975101
1976103
1977112
197899
1979115
1980109
198181
198281
198381
198484
198573
198659
198769
198859
198974
199052
199152
199256
199346
199452
199554
199644
199743
199829
199938
200046
200133
200239
200346
200434
200537
200623
200741
200843
200932
201037
201143
201230
201322
201429
201517
201634
201733
201833
201927
202022
202127
202230
202319
202416
202523
202623

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\" = 'OH' 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 CHI81IA015Incident · No injuriesClosedCessna 210M · Toledo, OHDec 31, 1980 · N732RJ · Minor damageNTSB CHI81FEK09Accident · No injuriesClosedPiper PA32RT · Columbus, OHDec 31, 1980 · N36126 · DestroyedNTSB CHI81FEG04Accident · No injuriesClosedCessna 337P · Miamisburg, OHDec 31, 1980 · N8BC · Substantial damageNTSB CHI81FEK07Accident · 1 fatalClosedSorrel SNS-2 · Columbus Grove, OHDec 23, 1980 · N55959 · DestroyedNTSB CHI81FEI08Accident · No injuriesClosedCessna 182 · Ravenna, OHDec 22, 1980 · N4688K · Substantial damageNTSB CHI81FEK08Accident · No injuriesClosedRaven RX-7 · Dublin, OHDec 21, 1980 · N5711K · Substantial damageNTSB CHI81FEK11Accident · No injuriesClosedCessna 414A · Paulding, OHDec 20, 1980 · N21CL · Substantial damageNTSB CHI81FEG03Accident · Minor injuriesClosedMitsubishi MU-2B · Cambellstown, OHDec 15, 1980 · N93UM · Substantial damageNTSB CHI81FEK06Accident · Minor injuriesClosedAeronca 7AC · Hilliard, OHDec 13, 1980 · N2932E · DestroyedNTSB CHI81FEG02Accident · No injuriesClosedCessna 172 · Springfield, OHNov 30, 1980 · N6049R · Substantial damageNTSB CHI81FEK05Accident · No injuriesClosedCessna 152 · Cambridge, OHNov 13, 1980 · N64833 · Substantial damageNTSB CHI81FEI07Accident · Serious injuriesClosedPiper PA-38 · Strongsville, OHNov 12, 1980 · N2580N · DestroyedNTSB CHI81FEI06Accident · Serious injuriesClosedCessna 152 · Youngstown, OHNov 8, 1980 · N49805 · Substantial damageNTSB CHI81FEK03Accident · No injuriesClosedCessna 152 · Lima, OHNov 2, 1980 · N48876 · Substantial damageNTSB CHI81FEI04Accident · No injuriesClosedCessna T310R · Ravenna, OHNov 1, 1980 · N310FM · Substantial damageNTSB CHI81FEK04Accident · No injuriesClosedCessna 172N · Circleville, OHOct 31, 1980 · N5318E · Substantial damageNTSB CHI81FEI05Accident · No injuriesClosedCessna 152 · Port Clinton, OHOct 31, 1980 · N47316 · Substantial damageNTSB CHI81FEK02Accident · No injuriesClosedCessna 140 · Sunbury, OHOct 20, 1980 · N76731 · Substantial damageNTSB CHI80FEI02Accident · No injuriesClosedRobinson R-22 · Marlboro, OHOct 20, 1980 · N9023Z · Substantial damageNTSB CHI81FEI01Accident · Minor injuriesClosedPiper PA-28 · Elyria, OHOct 19, 1980 · N8620E · Substantial damageNTSB CHI81DEG01Accident · No injuriesClosedTaylorcraft BC12D · Cincinnati, OHOct 16, 1980 · N96457 · Substantial damageNTSB CHI81FEI03Accident · No injuriesClosedCessna 150 · N Philadelphia, OHOct 13, 1980 · N8405J · Substantial damageNTSB CHI81FEK01Accident · No injuriesClosedCessna 182 · Columbus, OHOct 5, 1980 · N39PS · Substantial damageNTSB CHI80FEG25Accident · No injuriesClosedBellanca 8KCAB · Miamisburg, OHSep 30, 1980 · N90RB · Substantial damageNTSB CHI80FEG24Accident · Minor injuriesClosedPiper PA-28 · Xenia, OHSep 28, 1980 · N6501C · Substantial damageNTSB CHI81FEK27Accident · No injuriesClosedSchleicher K7 · Montpelier, OHSep 24, 1980 · N1002Z · Substantial damageNTSB CHI80FEI45Accident · Minor injuriesClosedCessna 172M · Strongsville, OHSep 24, 1980 · N9135H · DestroyedNTSB CHI80FEI44Accident · Minor injuriesClosedEL Tomcat MK-5A · Nevada, OHSep 24, 1980 · N818JH · DestroyedNTSB CHI80FEC39Accident · No injuriesClosedAero Comdr 690A · Toledo, OHSep 23, 1980 · N57154 · Substantial damageNTSB CHI80FEI43Accident · 2 fatalClosedBreezy RLU-1 · Green Spgs, OHSep 21, 1980 · N1RJ · DestroyedNTSB CHI80FEG23Accident · Serious injuriesClosedAdams LD-S · Blue Ash, OHSep 20, 1980 · N1061Z · Substantial damageNTSB CHI80FEI42Accident · No injuriesClosedPiper PA-24 · Sandusky, OHSep 10, 1980 · N9411P · Substantial damageNTSB CHI80FEG22Accident · No injuriesClosedPiper PA-28 · Germantown, OHSep 7, 1980 · N7524W · Minor damageNTSB CHI80FEG21Accident · No injuriesClosedBeech C23 · Cincinnati, OHSep 7, 1980 · N280AC · Substantial damageNTSB CHI80FEI41Accident · No injuriesClosedPiper PA-38 · Mansfield, OHSep 3, 1980 · N9951T · DestroyedNTSB CHI80FEK26Accident · No injuriesClosedCessna U206F · Rockford, OHAug 28, 1980 · N51241 · Substantial damageNTSB CHI80FEI39Accident · Serious injuriesClosedAvian BLN Falcon · Wadsworth, OHAug 27, 1980 · N45AV · No damageNTSB CHI80FEI40Accident · No injuriesClosedCessna 310Q · Elyria, OHAug 25, 1980 · N5092Q · Substantial damageNTSB CHI80FEI37Accident · Serious injuriesClosedPiper PA-22 · Shelby, OHAug 25, 1980 · N2825P · DestroyedNTSB CHI80FEI38Accident · No injuriesClosedBell 47 · Norwalk, OHAug 22, 1980 · N5235N · Substantial damageNTSB CHI80FA064Accident · 1 fatalClosedSchweizer I-26E · Chardon, OHAug 19, 1980 · N2557H · DestroyedNTSB CHI80FEI36Accident · 1 fatalClosedDehavilland DHC-1B · Salem, OHAug 15, 1980 · N69WG · DestroyedNTSB CHI80FEK24Accident · Minor injuriesClosedPiper PA-28 · Bellefonatine, OHAug 13, 1980 · N8766W · Substantial damageNTSB CHI80FEK25Accident · No injuriesClosedSchweizer 2-33A · Marion, OHAug 10, 1980 · N7701S · Substantial damageNTSB CHI80FEI34Accident · No injuriesClosedCessna 172 · Strongsville, OHAug 10, 1980 · N80686 · Substantial damageNTSB CHI81FEI35Accident · Serious injuriesClosedSpeziosport DAL-1 · Tiffin, OHAug 9, 1980 · N6049 · DestroyedNTSB CHI80FEI33Accident · No injuriesClosedPiper PA-22 · Painesville, OHAug 8, 1980 · N5545Z · Substantial damageNTSB CHI80FEK23Accident · No injuriesClosedPiper PA-32 · Marietta, OHAug 3, 1980 · N23MM · Substantial damageNTSB CHI80FEI31Accident · Minor injuriesClosedCessna 172H · Willoughby, OHAug 3, 1980 · N3936R · DestroyedNTSB CHI80FEI32Accident · Minor injuriesClosedQuickie 1 · Wadsworth, OHAug 2, 1980 · N336RM · Substantial damage