NTSB investigations, 2015, OH

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

19622026
NTSB investigations, 2015, 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\") = 2015
    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 CEN16MA036Accident · 9 fatalClass 1 · MajorFinal reportBritish Aerospace HS 125 700A · Akron, OHThe flight crew's mismanagement of the approach and multiple deviations from company standard operating procedures, which placed the airplane in an unsafe situation and led to an unstabilized approach, a descent below minimum descent altitude without visual…Nov 10, 2015 · N237WR · DestroyedNTSB CEN16LA031Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Wakeman, OHA loss of engine power/performance for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Nov 4, 2015 · N80825 · Substantial damageNTSB GAA15CA299Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Wellington, OHThe pilot's failure to level the wings during the landing flare, which resulted in the left wing striking the runway.Sep 17, 2015 · N3872G · Substantial damageNTSB CEN15LA391Accident · Minor injuriesLimited investigationFinal reportFerence John W Thatcher CX4A · Hebron, OHThe loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Aug 31, 2015 · N443JF · Substantial damageNTSB GAA15CA237Accident · No injuriesData collectionFinal reportCessna 172 · Springfield, OHThe pilot's improper pitch control during landing, which resulted in a hard landing.Aug 23, 2015 · N691SP · Substantial damageNTSB CEN15IA365Incident · No injuriesIncident investigationFinal reportBeech V35 · Mount Vernon, OHThe loosening of the flyweight due to the installation of an improperly hardened flyweight carrier, which resulted in the overspeed of the propeller and engine and the subsequent in-flight separation of the propeller.Aug 16, 2015 · N2059W · No damageNTSB CEN15LA318Accident · 1 fatalLimited investigationFinal reportPiper PA38 - 112 · Millbury, OHA loss of engine power due to three of the engine valve adjustment mechanisms backing out, which resulted from improper maintenance.Jul 25, 2015 · C-GTAO · Substantial damageNTSB CEN15LA303Accident · No injuriesLimited investigationFinal reportAviat A-1C-180 · Cincinnati, OHThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.Jul 5, 2015 · N354BM · Substantial damageNTSB CEN15FA281Accident · 1 fatalField investigationFinal reportStuhlmiller Robert Europa · Beloit, OHThe pilot’s incapacitation in flight due to a cardiovascular event.Jun 26, 2015 · N149RS · Substantial damageNTSB GAA15CA141Accident · No injuriesData collectionFinal reportSchweizer SGS 2 32 · Middlefield, OHThe student pilot's incorrect pitch and roll rate control inputs which resulted in an aerodynamic stall and incipient spin at a low altitude.Jun 25, 2015 · N275P · Substantial damageNTSB GAA15CA130Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Swanton, OHThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion, and a collision with a sign.Jun 9, 2015 · N6919W · Substantial damageNTSB GAA15CA094Accident · No injuriesData collectionFinal reportCessna 182E · Galion, OHThe pilot's failure to maintain adequate airspeed on final approach, which resulted in an in-flight loss of control and hard landing.May 25, 2015 · N25AW · Substantial damageNTSB GAA15CA093Accident · No injuriesData collectionFinal reportRogers Homer/Rogers Sheila RV 6A · Lorain/Elyria, OHThe pilot's failure to maintain airplane attitude control during the landing flare, which resulted in an aerodynamic stall, hard landing, and runway excursion.May 23, 2015 · N3086Q · Substantial damageNTSB CEN15CA196Accident · No injuriesData collectionFinal reportAeronca 7AC · Cambridge, OHThe pilot's failure to maintain control of the airplane while encountering a wind gust after landing.Apr 11, 2015 · N85664 · Substantial damageNTSB GAA15LA027Accident · Serious injuriesLimited investigationFinal reportCub Crafters CC18 180 · Westfield Township, OHThe pilot’s failure to maintain clearance from trees during a base-to-final turn while landing toward the sun.Mar 28, 2015 · N550BS · Substantial damageNTSB GAA15CA016Accident · No injuriesData collectionFinal reportFlight Design Ctls · Mount Vernon, OHThe pilot's improper recovery from a bounced landing, which resulted in a loss of control.Mar 18, 2015 · N566FD · Substantial damageNTSB CEN15CA188Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Akron, OHThe pilot's failure to maintain directional control during a crosswind landing in gusting crosswind conditions.Feb 12, 2015 · N427AB · Substantial damage