NTSB investigations, 2011, CO

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

Cases per year

20082026
NTSB investigations, 2011, CO per year, 2008–2026: 183 cases
200820
200911
20108
201116
201215
201313
201415
201512
20169
20175
20186
20195
202011
202110
20228
20234
20244
20256
20265

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\" = 'CO' 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 CEN12CA041Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Pueblo, COThe certified flight instructor’s delayed remedial action. Contributing to the accident was the student pilot's failure to maintain control prior to the landing.Oct 24, 2011 · N942DA · Substantial damageNTSB CEN11CA620Accident · No injuriesData collectionFinal reportCessna T210M · Kremmling, COThe pilot's failure to maintain aircraft control during the landing.Aug 26, 2011 · N761NX · Substantial damageNTSB CEN11FA572Accident · Serious injuriesField investigationFinal reportFerguson Fergy 1 · Falcon, COA loss of control for undetermined reasons.Aug 6, 2011 · N2515E · Substantial damageNTSB CEN11CA550Accident · Serious injuriesData collectionFinal reportAttaway Robert H RV6A · Colorado Springs, COThe pilot's failure to maintain control while landing.Aug 5, 2011 · N675RE · Substantial damageNTSB CEN11CA511Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Broomfield, COA loss of control due to the pilot's diverted attention as a result of an open door.Jul 23, 2011 · N915BW · Substantial damageNTSB CEN11FA479Accident · 2 fatalField investigationFinal reportCessna 150L · Silverton, COThe pilot's failure to maintain control of the airplane while operating it at low levels above mountainous terrain and in excess of its maximum allowable gross weight, which resulted in an aerodynamic stall. The pilot's failure to maintain control resulted…Jul 14, 2011 · N1539Q · Substantial damageNTSB CEN11FA465Accident · 1 fatalField investigationFinal reportPipistrel Taurus · Durango, COThe pilot’s loss of control during the off-airport landing in strong winds, which resulted in a hard landing.Jul 8, 2011 · N261T · Substantial damageNTSB CEN11FA428Accident · 1 fatalField investigationFinal reportCessna R182 · Thornton, COThe pilot's inadvertent encounter with a microburst while operating at a low altitude, which resulted in a loss of control from which the pilot could not recover. Contributing to the accident was the pilot’s inadequate preflight planning for the forecasted…Jun 29, 2011 · N2344C · Substantial damageNTSB CEN11CA392Accident · No injuriesData collectionFinal reportCessna 172S · Cortez, COThe pilot's failure to maintain aircraft control while landing in gusty crosswind conditions.Jun 14, 2011 · N6017J · Substantial damageNTSB CEN11FA346Accident · 1 fatalField investigationFinal reportHansen IB C Cassutt III M · Erie, COThe pilot's incapacitation due to a cardiac event.May 22, 2011 · N420FH · Substantial damageNTSB CEN11CA360Accident · Serious injuriesData collectionFinal reportLammers Sjef J Apache · Colorado Springs, COThe pilot's failure to maintain control of the aircraft during take-off in a cross wind, which resulted in an inadvertent stall.May 20, 2011 · N566RL · Substantial damageNTSB CEN11CA284Accident · No injuriesData collectionFinal reportPiper PA38 · Peyton, COThe pilot's loss of directional control during landing.Apr 13, 2011 · N107WC · Substantial damageNTSB CEN11LA266Accident · No injuriesLimited investigationFinal reportCessna 172RG · Wellington, COThe certified flight instructor's failure to maintain directional control during the go-around.Apr 2, 2011 · N4914V · Substantial damageNTSB CEN11FA259Accident · 1 fatalField investigationFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Boulder, COThe pilot's incapacitation for undetermined reasons, which resulted in a loss of control.Apr 1, 2011 · N633BG · Substantial damageNTSB CEN11LA164Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Bennett, COThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.Jan 30, 2011 · N787CB · Substantial damageNTSB CEN11FA150Accident · 2 fatalField investigationFinal reportPiper PA 46-350P · Westcliffe, COThe pilot's loss of control following an encounter with moderate to severe weather.Jan 9, 2011 · N727MC · Substantial damage