NTSB investigations, 1966, 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, 1966, 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\") = 1966
    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 CHI67D0451Accident · No injuriesClosedCessna 172 · Chagrin Fall, OHDec 31, 1966 · N3880R · Substantial damageNTSB CHI67D0445Accident · No injuriesClosedPiper PA-22 · Toledo, OHDec 30, 1966 · N5389Z · Substantial damageNTSB CHI67D0384Accident · Minor injuriesClosedBeech A35 · Concord, OHDec 24, 1966 · N717B · Substantial damageNTSB CHI67A0083Accident · No injuriesClosedScheutzow B · Brunswick, OHDec 23, 1966 · N592A · Substantial damageNTSB CHI67D0421Accident · No injuriesClosedBeech B95 · Napoleon, OHDec 21, 1966 · N9646R · Substantial damageNTSB CHI67I0078Incident · Serious injuriesClosedBoeing 720 · Cleveland, OHDec 19, 1966 · N7226U · No damageNTSB CHI67A0081Accident · 4 fatalClosedCessna 172 · Ashtabula, OHDec 19, 1966 · N2347U · DestroyedNTSB CHI67D0427Accident · No injuriesClosedCessna 140 · Cleveland, OHDec 17, 1966 · N2424V · Substantial damageNTSB CHI67D0415Accident · No injuriesClosedPiper PA-22 · Huron, OHDec 17, 1966 · N4795Z · Substantial damageNTSB CHI67F0397Accident · Serious injuriesClosedCessna 210E · Minford, OHDec 15, 1966 · N377Y · DestroyedNTSB CHI67A0073Accident · 1 fatalClosedBeech A23-19 · Toledo, OHDec 12, 1966 · N7921L · DestroyedNTSB CHI67A0072Accident · 1 fatalClosedPiper PA-22 · Pataskala, OHDec 5, 1966 · N1725P · DestroyedNTSB CHI67F0398Accident · No injuriesClosedPiper PA-22 · Elyria, OHDec 4, 1966 · N6859B · Substantial damageNTSB CHI67F0381Accident · Minor injuriesClosedPiper PA-23 · Springboro, OHNov 28, 1966 · N3175P · Substantial damageNTSB CHI67D0399Accident · Minor injuriesClosedPiper PA-22 · Sycamore, OHNov 24, 1966 · N9641D · Substantial damageNTSB CHI67D0380Accident · No injuriesClosedPiper PA-22 · Toledo, OHNov 14, 1966 · N5721Z · Substantial damageNTSB CHI67D0446Accident · No injuriesClosedAero Cmdr 680 · Lorain, OHNov 13, 1966 · N6256D · Substantial damageNTSB CHI67D0407Accident · No injuriesClosedPiper PA-12 · Bowling Grn, OHNov 13, 1966 · N92571 · Substantial damageNTSB CHI67F0336Accident · No injuriesClosedPiper PA-28 · Blue Ash, OHNov 12, 1966 · N5381W · Substantial damageNTSB CHI67F0330Accident · Minor injuriesClosedPiper PA-28 · Hebron, OHNov 6, 1966 · N7983W · Substantial damageNTSB CHI67D0379Accident · No injuriesClosedMooney M20C · Bowling Grn, OHNov 5, 1966 · N6731U · Substantial damageNTSB CHI67F0318Accident · No injuriesClosedBeech A45 · W.Carrollton, OHNov 1, 1966 · N9664H · Substantial damageNTSB CHI67F0304Accident · No injuriesClosedStinson 108-1 · Columbus, OHOct 30, 1966 · N8389K · Substantial damageNTSB CHI67D0367Accident · Minor injuriesClosedCessna 150 · Kent, OHOct 27, 1966 · N8020F · DestroyedNTSB CHI67A0056Accident · Serious injuriesClosedBell 47G · Wickliffe, OHOct 25, 1966 · N477RK · DestroyedNTSB CHI67F0281Accident · Serious injuriesClosedCessna U206 · Columbus, OHOct 24, 1966 · N377LA · DestroyedNTSB CHI67D0366Accident · No injuriesClosedBeechcraft A23 · Medina, OHOct 23, 1966 · N1409L · Substantial damageNTSB CHI67A0053Accident · 2 fatalClosedPiper PA-22 · Stow, OHOct 21, 1966 · N6952D · DestroyedNTSB CHI67F0299Accident · No injuriesClosedPiper PA-28 · Cleveland, OHOct 20, 1966 · N9022W · Substantial damageNTSB CHI67D0369Accident · No injuriesClosedPiper PA-24 · N, OHOct 20, 1966 · N8096P · Substantial damageNTSB CHI67F0329Accident · No injuriesClosedCessna 150 · Strongsville, OHOct 12, 1966 · N3683J · Substantial damageNTSB CHI67F0242Accident · No injuriesClosedErco 415-C · Dayton, OHOct 9, 1966 · N37115 · Substantial damageNTSB CHI67D0276Accident · No injuriesClosedCessna 150 · Grove City, OHOct 9, 1966 · N7872Z · Substantial damageNTSB CHI67D0255Accident · No injuriesClosedPiper PA-28 · Vandalia, OHOct 8, 1966 · N7158R · Substantial damageNTSB CHI67D0345Accident · No injuriesClosedPiper PA-28 · Stow, OHOct 6, 1966 · N6904W · Substantial damageNTSB CHI67F0204Accident · Minor injuriesClosedPiper PA-28 · Columbus, OHOct 4, 1966 · N6314R · Substantial damageNTSB CHI67D0274Accident · No injuriesClosedMooney M21 · Cleveland, OHOct 3, 1966 · N2711W · Substantial damageNTSB CHI67F0275Accident · No injuriesClosedCessna 120 · Oxford, OHOct 2, 1966 · N2904N · Substantial damageNTSB CHI67F0224Accident · Minor injuriesClosedAeronca 7AC · Middletown, OHOct 1, 1966 · N82889 · Substantial damageNTSB CHI67A0014Accident · 1 fatalClosedPiper PA-28 · Whitehall, OHSep 28, 1966 · N8613W · DestroyedNTSB CHI67F0300Accident · Minor injuriesClosedPiper PA-28 · Medina, OHSep 25, 1966 · N8906J · Substantial damageNTSB CHI67D0338Accident · No injuriesClosedPiper PA-28 · Medina, OHSep 25, 1966 · N5320W · Substantial damageNTSB CHI67F0214Accident · No injuriesClosedPiper PA-23 · Cincinnatti, OHSep 22, 1966 · N2123P · Substantial damageNTSB CHI67F0283Accident · Minor injuriesClosedTaylorcraft BC12-D · Elyria, OHSep 17, 1966 · N96533 · Substantial damageNTSB CHI67D0395Accident · No injuriesClosedCessna 180 · Grafton, OHSep 17, 1966 · N2934C · Substantial damageNTSB CHI67D0245Accident · No injuriesClosedCessna 172C · Xenia, OHSep 16, 1966 · N1641Y · Substantial damageNTSB CHI67D0188Accident · No injuriesClosedAeronca 7GCB · Duncan Falls, OHSep 16, 1966 · N9942Y · Substantial damageNTSB CHI67D0186Accident · No injuriesClosedCessna 172 · Greenville, OHSep 11, 1966 · N5935R · Substantial damageNTSB CHI67A0038Accident · 4 fatalClosedCessna 172 · South Russel, OHSep 11, 1966 · N4616L · DestroyedNTSB CHI67D0273Accident · No injuriesClosedCessna 150 · Middle Bass, OHSep 10, 1966 · N4734X · Destroyed