NTSB investigations, 1976, OH

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1976, 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\") = 1976
    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 CHI77FEI08Accident · Minor injuriesClosedPiper PA-28 · Avon Lake, OHDec 31, 1976 · N5320W · Substantial damageNTSB CHI77FA017Accident · 1 fatalClosedPiper PA-23 · North Royalton, OHDec 23, 1976 · N2264P · DestroyedNTSB CHI77FEI07Accident · No injuriesClosedPiper PA-30 · North Benton, OHDec 22, 1976 · N8084Y · Substantial damageNTSB CHI77FEI06Accident · Serious injuriesClosedPiper PA-22 · Painesville, OHDec 11, 1976 · N5722Z · DestroyedNTSB CHI77FA012Accident · 1 fatalClosedCessna 177 · Harrison, OHDec 11, 1976 · N29380 · DestroyedNTSB CHI77FEK08Accident · Serious injuriesClosedPiper PA-23 · Mt Sterling, OHDec 6, 1976 · N5046Y · DestroyedNTSB CHI77FEI05Accident · No injuriesClosedCessna 150 · Vienna, OHDec 3, 1976 · N8632U · Substantial damageNTSB CHI77FA009Accident · Serious injuriesClosedSikorsky S-58B · Hartford Twp, OHNov 30, 1976 · N8561 · DestroyedNTSB NYC77FA013Accident · Serious injuriesClosedDouglas DC-9 · Appleton, OHNov 17, 1976 · N1070T · No damageNTSB CHI77FEK07Accident · No injuriesClosedCessna 421B · Findlay, OHNov 17, 1976 · N14DB · Substantial damageNTSB CHI77FEK05Accident · Minor injuriesClosedEnstrom F-28A · Columbus, OHNov 16, 1976 · N282Q · Substantial damageNTSB CHI77DEG05Accident · No injuriesClosedCessna 180 · Lebanon, OHNov 13, 1976 · N4585B · Substantial damageNTSB CHI77FEK06Accident · No injuriesClosedPiper PA-28 · Columbus, OHNov 12, 1976 · N8603E · Substantial damageNTSB CHI77FEG04Accident · No injuriesClosedPiper PA-28 · Blue Ash, OHNov 7, 1976 · N98228 · Substantial damageNTSB CHI77FEI04Accident · Minor injuriesClosedGrum Amer AA-5B · Millbury, OHOct 31, 1976 · N1598R · Substantial damageNTSB CHI77FEK04Accident · Serious injuriesClosedGrum Amer AA1-B · Columbus, OHOct 29, 1976 · N8857L · Substantial damageNTSB CHI77FEI03Accident · No injuriesClosedPiper PA-24 · Akron, OHOct 26, 1976 · N8846P · Substantial damageNTSB CHI77DEG02Accident · No injuriesClosedBellanca 7ECA · Moraine, OHOct 19, 1976 · N8718V · Substantial damageNTSB CHI77DEG03Accident · Minor injuriesClosedBellanca 7ECA · Moraine, OHOct 18, 1976 · N53969 · Substantial damageNTSB CHI77FEK03Accident · Minor injuriesClosedPiper PA-28 · Celina, OHOct 17, 1976 · N8850J · Substantial damageNTSB CHI77FEI02Accident · No injuriesClosedCessna 172L · Stronsville, OHOct 11, 1976 · N7972G · Substantial damageNTSB CHI77FEK02Accident · 2 fatalClosedBel-Spezio BEL · Rockbridge, OHOct 10, 1976 · N3554 · DestroyedNTSB CHI77FEG01Accident · No injuriesClosedCessna 172 · Hamilton, OHOct 5, 1976 · N46246 · Substantial damageNTSB CHI77FEI01Accident · No injuriesClosedPiper PA-30 · Mansfield, OHOct 4, 1976 · N7554Y · Substantial damageNTSB CHI77FEK01Accident · No injuriesClosedBell 47D1 · Johnstown, OHOct 1, 1976 · N9115R · Substantial damageNTSB CHI76FEI50Accident · Minor injuriesClosedUniversal GC-1B · Richmond Hts, OHSep 29, 1976 · N808GB · DestroyedNTSB CHI76FEK32Accident · No injuriesClosedCessna 150 · Columbus, OHSep 28, 1976 · N51258 · Substantial damageNTSB CHI76FEK31Accident · No injuriesClosedMooney M20E · Urbana, OHSep 26, 1976 · N1991Y · Substantial damageNTSB CHI76FEK29Accident · No injuriesClosedPiper PA-34 · Columbus, OHSep 23, 1976 · N15076 · Substantial damageNTSB CHI76FEK30Accident · No injuriesClosedTransworld 47G-2 · Leipsic, OHSep 22, 1976 · N2874F · Substantial damageNTSB CHI76AC092Accident · 1 fatalClosedCessna 210B · Hamilton, OHSep 19, 1976 · N9656X · Substantial damageNTSB CHI76FEI49Accident · Minor injuriesClosedCessna 150L · Millbury, OHSep 12, 1976 · N7306G · Substantial damageNTSB CHI76DEG23Accident · No injuriesClosedPiper PA-28 · Wilmington, OHSep 11, 1976 · N4283J · Substantial damageNTSB CHI76FEI48Accident · No injuriesClosedBeech B19 · Strongsville, OHSep 6, 1976 · N1957W · Substantial damageNTSB CHI76FEK28Accident · Minor injuriesClosedCessna 182 · Johnston, OHAug 27, 1976 · N71377 · Substantial damageNTSB CHI76FEI47Accident · Minor injuriesClosedPiper PA-32 · Baltic, OHAug 25, 1976 · N43087 · Substantial damageNTSB CHI76FEK27Accident · No injuriesClosedCessna 172G · London, OHAug 20, 1976 · N5786R · Substantial damageNTSB CHI76FEI46Accident · No injuriesClosedPiper PA-28 · Salem, OHAug 17, 1976 · N95022 · Substantial damageNTSB CHI76FEI44Accident · No injuriesClosedCessna 182 · Chagrin Falls, OHAug 17, 1976 · N42594 · Substantial damageNTSB CHI76FEI43Accident · No injuriesClosedEL Tomcat Mark V · Mantua, OHAug 17, 1976 · N818HJ · Substantial damageNTSB CHI76DEG22Accident · No injuriesClosedRuby RR-1 · Martinsville, OHAug 17, 1976 · N447RR · Substantial damageNTSB CHI76FEI45Accident · No injuriesClosedPiper PA-24 · Bowling Green, OHAug 14, 1976 · N8995P · Substantial damageNTSB CHI76FEK26Accident · Minor injuriesClosedPiper PA-32 · Walhonding, OHAug 13, 1976 · N5591J · Substantial damageNTSB CHI76FEG21Accident · No injuriesClosedCessna 177 · Kettering, OHAug 12, 1976 · N30139 · DestroyedNTSB CHI76AC084Accident · 2 fatalClosedEnstrom F-28A · Enon, OHAug 9, 1976 · N88BD · DestroyedNTSB CHI76FEI41Accident · 1 fatalClosedRockwell 112A · Perrysville, OHAug 8, 1976 · N1166J · DestroyedNTSB CHI76FEK25Accident · No injuriesClosedCessna 310 · Columbus, OHAug 7, 1976 · N1773H · Substantial damageNTSB CHI76FEG20Accident · Minor injuriesClosedTaylorcraft BC-12D · Dayton, OHAug 7, 1976 · N95941 · DestroyedNTSB CHI76FEI42Accident · Minor injuriesClosedPiper PA-28 · Avon, OHAug 4, 1976 · N411SF · Substantial damageNTSB CHI76FEK23Accident · No injuriesClosedPiper PA-22 · Baltimore, OHAug 3, 1976 · N4995Z · Substantial damage