NTSB investigations, CO

7 cases where NTSB found Aircraft handling/service.

Cases per year

20092026
NTSB investigations, CO per year, 2009–2026: 7 cases
20091
20111
20171
20191
20201
20211
20231

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 c.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0101'))
  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 CEN23LA179Accident · No injuriesClass 4 · LimitedFinal reportTextron 172S · Englewood, COThe pilot’s decision to adjust his seat during taxi, which resulted in his seat sliding aft, and subsequent loss of directional control.May 6, 2023 · N34BL · Substantial damageNTSB DCA21FA085Incident · No injuriesClass 3 · FieldFinal reportBoeing 777-222 · Broomfield, COThe fatigue failure of the right engine fan blade. Contributing to the fan blade failure was the inadequate inspection of the blades, which failed to identify low-level indications of cracking, and the insufficient frequency of the manufacturer’s inspection…Feb 20, 2021 · N772UA · Minor damageNTSB CEN20CA139Accident · Serious injuriesData collectionFinal reportRans S-12 Airaile · Hillrose, COThe noncertificated pilot's diverted attention while looking at a fire during low-altitude flying, which resulted in a collision with power lines.Apr 4, 2020 · UNREG · Substantial damageNTSB DCA19CA079Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A320 · Denver, COloss of control of the tug by the driver during pushback operations as a result of the contaminated ramp, angle of the towbar, and the airplane engines being at idle thrust.Jan 28, 2019 · N220FR · Substantial damageNTSB CEN18LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Longmont, COThe failure of the landing gear through bolt primarily due to fatigue during a hard landing, which resulted in a landing gear collapse and runway excursion. Contributing to the accident was noncompliance with the manufacturer service letter.Dec 20, 2017 · N519MA · Substantial damageNTSB CEN11IA341Incident · No injuriesIncident investigationFinal reportBeech 1900D · Denver, COThe fatigue failure of the nose landing gear (NLG) end cap, which resulted in insufficient hydraulic pressure to secure the left main landing gear into the down and locked position. Contributing to the fatigue failure was the NLG end cap’s non-optimum grain…May 17, 2011 · N218YV · Minor damageNTSB CEN09IA153Incident · No injuriesIncident investigationFinal reportNew Piper PA-46-500T · Aspen, COThe pilot's inability to maintain directional control of the airplane during landing for undetermined reasons.Feb 4, 2009 · N535JR · Minor damage