NTSB investigations, 2011, CO

9 cases where the sequence of events included Other weather encounter.

Cases per year

20082026
NTSB investigations, 2011, CO per year, 2008–2026: 70 cases
20085
20093
20102
20119
20125
20131
20141
20153
20165
20174
20184
20193
20206
20212
20221
20238
20242
20254
20262

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\" = '400' 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 CEN11CA517Accident · Serious injuriesData collectionFinal reportKubicek BB85 · Hartsel, COThe pilot's encounter with high wind which resulted in a hard landing and passenger injury.Jul 27, 2011 · N1545T · No damageNTSB CEN11CA520Accident · Serious injuriesData collectionFinal reportCameron Balloons US AX10 · Clark, COThe pilot's encounter with high wind which resulted in a hard landing and passenger injury.Jul 22, 2011 · N2012J · No damageNTSB CEN11CA492Accident · No injuriesData collectionFinal reportCessna 182S · Meeker, COThe pilot's inadvertent flight into a downdraft, which resulted in an in-flight collision with trees.Jul 19, 2011 · N314FR · 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 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 CEN11CA261Accident · No injuriesData collectionFinal reportCessna 172N · Colorado Springs, COThe pilot loss of directional control during landing in gusty crosswind conditions.Apr 3, 2011 · N3484E · 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 CEN11CA268Accident · Minor injuriesData collectionFinal reportCub Crafters CC11-160 · Kiowa, COThe pilot's failure to maintain directional control following a hard landing.Mar 23, 2011 · N144LP · 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