NTSB investigations, OH

5 cases where NTSB found Development.

Cases per year

20082026
NTSB investigations, OH per year, 2008–2026: 5 cases
20081
20101
20122
20151

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 c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0401'))
  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 CEN13IA024Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Elyria, OHThe manufacturing defects in the main landing gear leg, which resulted in its eventual failure.Oct 17, 2012 · N21ZA · Minor damageNTSB CEN12LA676Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Elyria, OHThe pilot’s misjudged landing flare, which resulted in a hard landing.Jul 20, 2012 · N21ZA · Substantial damageNTSB CEN11IA087Incident · No injuriesIncident investigationFinal reportCessna 560XL · Toledo, OHThe manufacturer's inadequate initial design and subsequent modifications of the tailcone, which allowed moisture to collect and freeze around rudder cables during flight levels above the freezing level and resulted in a loss of rudder authority. Contributing…Dec 1, 2010 · N607QS · No damageNTSB CHI08FA156Accident · 6 fatalField investigationFinal reportCessna U206C · Fremont, OHThe pilot’s failure to maintain airplane control for an undetermined reason, which resulted in an inadvertent stall. Contributing to the accident was the pilot's poor judgment in continuing to fly with his severe visual deficiency. Also contributing to the…Jun 8, 2008 · N29122 · Substantial damage