NTSB investigations, 2011, OH

10 cases where the sequence of events included Loss of control in flight.

Cases per year

20082026
NTSB investigations, 2011, OH per year, 2008–2026: 111 cases
200810
200910
20104
201110
20124
20134
201410
20153
20167
20177
20182
201912
20203
20218
20226
20232
20242
20254
20263

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\") = 2011
    AND c.\"eventStateOrRegion\" = 'OH' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN12LA112Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marysville, OHThe pilot’s failure to maintain sufficient altitude from the terrain while performing low-level aerobatics.Dec 22, 2011 · N161PC · Substantial damageNTSB CEN12FA082Accident · 1 fatalField investigationFinal reportBeech 23 · West Milton, OHThe non-instrument-rated pilot's decision to attempt a flight into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and subsequent loss of control of the airplane.Nov 24, 2011 · N8700M · Substantial damageNTSB CEN11FA629Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · West Liberty, OHThe pilot’s improper decision to fly aerobatic maneuvers at low altitude, which resulted in a loss of control and impact with terrain. Contributing to the accident was the pilot’s impairment due to his recent use of multiple impairing drugs.Sep 8, 2011 · N159JW · Substantial damageNTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.Aug 25, 2011 · N777BN · DestroyedNTSB CEN11FA528Accident · 2 fatalField investigationFinal reportWright B Flyer Wright B Flyer · Springfield, OHThe flight crew’s failure to maintain airplane control following a partial loss of engine thrust during cruise flight. Contributing to the accident was the failed weld as a result of incomplete welding on the left propeller shaft, which led to the partial…Jul 30, 2011 · N453WB · Substantial damageNTSB CEN11LA527Accident · No injuriesLimited investigationFinal reportSnow Quickie 2 · Ashtabula, OHThe incorrect propeller pitch and lower-than-expected engine speed that did not allow the airplane to attain a proper climb rate during takeoff, and the subsequent hard landing that occurred when the pilot reduced power.Jul 22, 2011 · N240JS · Substantial damageNTSB CEN11LA455Accident · No injuriesLimited investigationFinal reportCouvillion S-17 · Toledo, OHThe loss of control during initial climb for undetermined reasons, which resulted in a hard landing.Jul 1, 2011 · N433GC · Substantial damageNTSB CEN11FA401Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Columbus, OHThe pilot's spatial disorientation during the takeoff into instrument meteorological conditions, which resulted in his failure to maintain control of the airplane.Jun 19, 2011 · N526PG · DestroyedNTSB CEN11LA372Accident · Minor injuriesLimited investigationFinal reportMooney M20J · North Canton, OHThe pilot’s improper landing flare and recovery from a bounced landing, which resulted in a loss of control.Jun 5, 2011 · N1146B · Substantial damageNTSB CEN11LA364Accident · Minor injuriesLimited investigationFinal reportPiper PA30 · Phillipsburg, OHThe pilot’s failure to maintain directional control during takeoff following a loss of left engine power for undetermined reasons.May 21, 2011 · N7248Y · Substantial damage