NTSB investigations, 2011, CO

22 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2011, CO per year, 2008–2026: 266 cases
200828
200913
20109
201122
201218
201316
201422
201515
201612
201715
201817
201914
202015
202110
20229
20235
202410
20259
20267

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\" = '470' 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 CEN12FA058Accident · 1 fatalField investigationFinal reportCessna 337G · Alamosa, COThe loss of power to the rear engine due to fuel starvation during takeoff, which resulted from the fuel selector valve being inadvertently moved to the “off” position, and resulted in the airplane’s inability to climb.Nov 10, 2011 · N337LC · DestroyedNTSB CEN12CA011Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Englewood, COThe student pilot's improper flare, which resulted in a bounced landing from which he was unable to recover.Oct 11, 2011 · N777XG · Substantial damageNTSB CEN12CA005Accident · No injuriesData collectionFinal reportCampbell John Mustang II · Brush, COThe pilot’s failure to maintain directional control during taxi, which resulted in a runway excursion.Oct 2, 2011 · N287BM · Substantial damageNTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.Aug 26, 2011 · N75BA · 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 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 CEN11CA485Accident · No injuriesData collectionFinal reportBellanca 8KCAB · Greeley, COThe pilot's loss of directional control during landing, resulting in a runway excursion.Jul 16, 2011 · N731JD · 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 CEN11LA490Accident · No injuriesLimited investigationFinal reportDarrow Stephen AL-6 · Peyton, COThe loss of engine power during the descent for reasons that could not be determined because a thorough examination of the engine could not be completed due to the remote accident site.Jul 13, 2011 · N61262 · Substantial damageNTSB CEN11FA444Accident · 1 fatalField investigationFinal reportBoeing B75N1 · Wetmore, COThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.Jul 3, 2011 · N4473N · 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 CEN11CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Golden, COThe pilot’s decision to operate the helicopter at a high density altitude near terrain, which resulted in a settling with power condition.May 8, 2011 · N921JM · Substantial damageNTSB CEN11FA304Accident · 2 fatalField investigationFinal reportCubcrafters CC11-160 · Parker, COThe pilot’s excessive and unsafe maneuvering during gusty wind conditions, which resulted in an inadvertent stall-spin.Apr 23, 2011 · N143FJ · Substantial damageNTSB CEN11CA284Accident · No injuriesData collectionFinal reportPiper PA38 · Peyton, COThe pilot's loss of directional control during landing.Apr 13, 2011 · N107WC · Substantial damageNTSB CEN11CA289Accident · Minor injuriesData collectionFinal reportRans S12 · Fort Collins, COThe pilot's inadvertent application of full right rudder during landing, which resulted in an aerodynamic stall and impact with terrain.Apr 9, 2011 · N3581S · 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 CEN11LA239Accident · 1 fatalLimited investigationFinal reportGlasflugel Standard Libelle · Wellington, COThe pilot's loss of glider control due to impairment or incapacitation caused by an episode of ventricular tachycardia.Mar 20, 2011 · N99AE · 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 CEN11CA170Accident · No injuriesData collectionFinal reportCessna 182 · Meeker, COThe pilot’s loss of directional control while taxiing due to his improper seat position.Jan 29, 2011 · N7199E · 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