NTSB investigations, 1981, OH

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1981, OH per year, 1962–2026: 4,363 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
202622

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\") = 1981
    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 CHI82FEK04Accident · Minor injuriesClosedCessna 172 · Norwich, OHDec 30, 1981 · N7999U · Substantial damageNTSB CHI82FEK03Accident · No injuriesClosedPiper PA-28 · Columbus, OHDec 16, 1981 · N28906 · Substantial damageNTSB CHI82FEI02Accident · No injuriesClosedCessna 150J · Willowick, OHNov 15, 1981 · N50510 · Substantial damageNTSB CHI82FA011Accident · Serious injuriesClosedPiper PA-23 · Niles, OHNov 5, 1981 · N2457M · DestroyedNTSB CHI82FEK02Accident · No injuriesClosedCessna 210L · Columbus, OHOct 30, 1981 · N1697X · Substantial damageNTSB CHI82FEI01Accident · No injuriesClosedBeech D18S · Concord, OHOct 30, 1981 · N8962A · Substantial damageNTSB CHI82FEG01Accident · Serious injuriesClosedMonocoupe 113 · New Carlisle, OHOct 28, 1981 · N8948 · Substantial damageNTSB CHI82FA005Accident · 1 fatalClosedBLN Works FF-7 · Delaware, OHOct 17, 1981 · N1247F · Substantial damageNTSB CHI82FEK01Accident · No injuriesClosedCessna 152 · New Albany, OHOct 3, 1981 · N757EX · Substantial damageNTSB CHI81FEK31Accident · No injuriesClosedBLN Works FF-7B · Johnstown, OHSep 27, 1981 · N1517P · Substantial damageNTSB CHI81FEG17Accident · No injuriesClosedBeech B24R · Winchester, OHSep 27, 1981 · N6570R · Substantial damageNTSB CHI81FEK30Accident · Minor injuriesClosedBellanca 17-30A · Newark, OHSep 20, 1981 · N14744 · Substantial damageNTSB CHI81FEI31Accident · No injuriesClosedCessna 172N · Elyria, OHSep 20, 1981 · N739CJ · Substantial damageNTSB CHI81FEG16Accident · Minor injuriesClosedBellanca 7ECA · Cedarville, OHSep 19, 1981 · N7515F · Substantial damageNTSB CHI81FEI30Accident · No injuriesClosedCessna TU206F · Rock Creek, OHSep 16, 1981 · N59294 · Substantial damageNTSB CHI81FEI29Accident · No injuriesClosedPiper PA-25 · Kansas, OHSep 13, 1981 · N4769Y · Substantial damageNTSB CHI81FA100Accident · 1 fatalClosedSchweizer SGS232 · Waynesville, OHSep 12, 1981 · N232P · Substantial damageNTSB CHI81FEK29Accident · Serious injuriesClosedGlobe GC-1 · Mt Vernon, OHAug 30, 1981 · N78243 · Substantial damageNTSB CHI81FA094Accident · 1 fatalClosedCessna 421C · Rutland, OHAug 30, 1981 · N6867R · DestroyedNTSB CHI81FEI28Accident · No injuriesClosedCessna 310R · Cleveland, OHAug 25, 1981 · N87457 · Substantial damageNTSB CHI81FEI27Accident · 1 fatalClosedAmeagle Mnbt · Painesville, OHAug 23, 1981 · N110AC · DestroyedNTSB CHI81FEI26Accident · Minor injuriesClosedStinson 108-1 · Chardon, OHAug 21, 1981 · N97907 · Substantial damageNTSB CHI81FA087Accident · No injuriesClosedCessna 210D · Zanesville, OHAug 13, 1981 · N3970Y · 2 aircraft · Substantial damageNTSB CHI81FEI21Accident · No injuriesClosedPiper PA-22 · North Canton, OHAug 7, 1981 · N7599D · Substantial damageNTSB CHI81FEG15Accident · No injuriesClosedRobinson R22 · Cincinnati, OHAug 6, 1981 · N9015R · Substantial damageNTSB CHI81FA084Accident · 1 fatalClosedPiper PA-28 · Millbury, OHAug 4, 1981 · N8145N · DestroyedNTSB CHI81FA083Accident · 2 fatalClosedMooney M20C · Plymouth, OHAug 3, 1981 · N6698U · DestroyedNTSB CHI81FEK28Accident · 1 fatalClosedMonerai S · Montpelier, OHJul 30, 1981 · N36JS · Substantial damageNTSB CHI81FEK27Accident · No injuriesClosedPiper PA-38 · Columbus, OHJul 25, 1981 · N2333B · Substantial damageNTSB CHI81FEK26Accident · Serious injuriesClosedHughes 269A · Newark, OHJul 25, 1981 · N8737F · Substantial damageNTSB CHI81FA079Accident · 3 fatalClosedAero Comdr 100 · Columbia Stat, OHJul 21, 1981 · N3732X · DestroyedNTSB CHI81FA077Accident · 2 fatalClosedCessna 152 · E Liverpool, OHJul 18, 1981 · N761FF · DestroyedNTSB CHI81FEK24Accident · No injuriesClosedBeech B35 · Columbus, OHJul 17, 1981 · N5138C · Substantial damageNTSB CHI81IA080Incident · No injuriesClosedCessna 152 · Springfield, OHJul 13, 1981 · N6129Q · Minor damageNTSB CHI81FEK23Accident · No injuriesClosedVarga 2150A · Delaware, OHJul 12, 1981 · N8421J · Substantial damageNTSB CHI81DEG14Accident · No injuriesClosedBellanca 7ECA · Harrison, OHJul 12, 1981 · N53969 · Substantial damageNTSB CHI81FEI25Accident · No injuriesClosedCessna 150L · Wadsworth, OHJul 4, 1981 · N16168 · Substantial damageNTSB CHI81FEI24Accident · No injuriesClosedBeech A23 · Wooster, OHJun 29, 1981 · N3554R · Substantial damageNTSB CHI81FEI23Accident · Minor injuriesClosedLuscombe 8A · Northfield, OHJun 29, 1981 · N2029A · Substantial damageNTSB CHI81FEK25Accident · Minor injuriesClosedBoeing B75N1 · Richwood, OHJun 28, 1981 · N65544 · Substantial damageNTSB CHI81FEG13Accident · Serious injuriesClosedWaco YKS7 · Hamilton, OHJun 27, 1981 · N17457 · DestroyedNTSB CHI81FEK22Accident · No injuriesClosedPiper PA-28 · Columbus, OHJun 26, 1981 · N56241 · Substantial damageNTSB CHI81FEI22Accident · Minor injuriesClosedCessna 172 · Swanton, OHJun 26, 1981 · N8584V · Substantial damageNTSB CHI81FEK21Accident · No injuriesClosedPiper PA-30 · Newark, OHJun 24, 1981 · N7741Y · Substantial damageNTSB CHI81DEK20Accident · No injuriesClosedSchweizer 1-36 · Montpelier, OHJun 18, 1981 · N36183 · Substantial damageNTSB CHI81FEK19Accident · No injuriesClosedHiller UH-12D · Junction City, OHJun 15, 1981 · N96173 · DestroyedNTSB CHI81IA065Incident · No injuriesClosedMitsubishi MU-2B · Middletown, OHJun 13, 1981 · N854MA · Minor damageNTSB CHI81FEG12Accident · No injuriesClosedCessna 177B · Cincinnati, OHJun 10, 1981 · N20277 · Substantial damageNTSB CHI81IA088Accident · Serious injuriesClosedBoeing 727 · Columbus, OHJun 5, 1981 · N7255U · No damageNTSB CHI81FEI20Accident · Serious injuriesClosedCessna 172 · Akron, OHJun 4, 1981 · N6938A · Substantial damage