NTSB investigations, 2011, CO

7 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2011, CO per year, 2008–2026: 178 cases
200815
200915
20106
20117
201212
20139
20144
20157
20167
20177
20188
20196
202016
202114
20222
202313
20247
202511
202612

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\" = '230' 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 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 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 CEN11LA361Accident · No injuriesLimited investigationFinal reportFlournoy Martin R Flournoy MR S1S · Colorado Springs, COThe pilot’s loss of directional control during the landing rollout due to failure of the tailwheel assembly for undetermined reasons.May 22, 2011 · N457CF · 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 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 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 damage