NTSB investigations, 2016, CO

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

Cases per year

20082026
NTSB investigations, 2016, 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\") = 2016
    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 GAA17CA015Accident · No injuriesData collectionFinal reportStinson 108 · Rifle, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.Oct 6, 2016 · N4210C · Substantial damageNTSB CEN16LA348Accident · No injuriesLimited investigationFinal reportPiper PA 18-180 · Colorado Springs, COThe pilot's failure to maintain directional control after encountering a wind gust during the landing roll, which resulted in a ground loop.Aug 25, 2016 · N66898 · Substantial damageNTSB GAA16CA378Accident · No injuriesData collectionFinal reportPiper PA46R · Denver, COThe pilot's improper nose down pitch attitude during touchdown resulting in a propeller strike, hard bounced landing, and nose landing gear collapse.Jul 14, 2016 · N465BP · Substantial damageNTSB GAA16CA337Accident · No injuriesData collectionFinal reportCessna T210 · Buena Vista, COThe pilot's failure to maintain directional control during the landing roll in gusty wind conditions, which resulted in a runway excursion and substantial damage to the firewall.Jun 9, 2016 · N9915Y · Substantial damageNTSB GAA16CA270Accident · No injuriesData collectionFinal reportRainbow Sky Reach Bushcat · Mack, COThe pilot's failure to maintain directional control during the landing roll, which resulted in runway excursion, impact with a ditch, and nose over.May 29, 2016 · N273BC · Substantial damageNTSB GAA16CA214Accident · No injuriesData collectionFinal reportRockwell International 112TC · Durango, COThe instructed pilot's interference with the flight controls during landing, which resulted in the flight instructor's inability to maintain directional control, resulting in a runway excursion and substantial damage to the firewall and left wing spar.May 4, 2016 · N513CA · Substantial damageNTSB CEN16LA108Accident · No injuriesLimited investigationFinal reportCessna LC41-550FG · Grand Junction, COFailure of the right main tire for reasons that could not be determined because the tire was not available for examination.Feb 24, 2016 · N10580 · Substantial damage