NTSB investigations, 2011, CO

7 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026
NTSB investigations, 2011, CO per year, 2008–2026: 87 cases
20088
20092
20106
20117
20126
20134
20145
20153
20162
20178
20187
20193
20204
20216
20224
20234
20245
20252
20261

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\" = '440' 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 CEN11FA559Accident · Minor injuriesField investigationFinal reportCessna 182C · Boulder, COThe malfunction of the throttle linkage to the induction air box, which resulted in a loss of engine power and subsequent forced landing.Aug 9, 2011 · N8717T · Substantial damageNTSB CEN11LA487Accident · No injuriesLimited investigationFinal reportAyres S2R · Burlington, COA loss of engine power for undetermined reasons.Jul 18, 2011 · N70216 · 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 CEN11CA410Accident · No injuriesData collectionFinal reportTaft, Malcolm J SR Glastar · Canon City, COA loss of engine power due to an overheated engine as a result of a malfunction of the modified engine cooling system, necessitating a forced landing on unsuitable terrain.Jun 6, 2011 · N238W · 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 CEN11CA166Accident · No injuriesData collectionFinal reportMcholland C L Solitare · Wellington, COThe glider pilot’s misjudgment while approaching to land, which resulted in an off-airport landing.Jan 29, 2011 · N15XP · Substantial damage