NTSB investigations, CO

13 cases where NTSB found Light condition.

Cases per year

20082026
NTSB investigations, CO per year, 2008–2026: 13 cases
20081
20091
20101
20111
20131
20144
20151
20172
20191

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\", '030360'))
  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 GAA20CA071Accident · No injuriesData collectionFinal reportCessna 182 · San Luis, COThe pilot's improper pitch attitude during landing on rising terrain in flat light conditions, which resulted in a hard landing.Nov 12, 2019 · N91846 · Substantial damageNTSB GAA18CA075Accident · Minor injuriesData collectionFinal reportJones Kent C Vans RV-10 · Limon, COThe pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing.Dec 8, 2017 · N9738J · Substantial damageNTSB CEN17LA350Accident · No injuriesLimited investigationFinal reportEmbraer EMB 120ER · Greeley, COThe bus driver's failure to maintain clearance from the standing airplane during dark night conditions. Contributing to the accident was the airport's lack of an escort for the bus.Sep 13, 2017 · N121CZ · Substantial damageNTSB CEN15LA144Accident · No injuriesLimited investigationFinal reportBeech 58 · Denver, COThe pilot’s failure to maintain airplane control during a rejected takeoff from a slush-covered runway at night.Feb 16, 2015 · N297AT · Substantial damageNTSB CEN15FA030Accident · 1 fatalField investigationFinal reportMooney M20 · Boulder, COThe loss of airplane control for reasons that could not be determined by the postaccident examination, which was limited due to impact damage and postcrash fire.Oct 27, 2014 · N3539X · Substantial damageNTSB CEN14LA361Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Monte Vista, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a go-around following impact with a barley crop, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s…Jul 12, 2014 · N91106 · Substantial damageNTSB CEN14FA265Accident · 2 fatalField investigationFinal reportCessna 150 · Watkins, COThe pilot’s loss of control and subsequent aerodynamic stall due to spatial disorientation in night instrument meteorological conditions. Contributing to the accident was the pilot’s distraction due to his cell phone use while maneuvering at low-altitude.May 31, 2014 · N6275G · Substantial damageNTSB CEN14FA122Accident · 3 fatalField investigationFinal reportBell 206L 3 · Silt, COThe pilot’s inadequate preflight planning for a low-level aerial surveillance flight of power transmission lines, which led to his being unaware of the crossing power line while flying toward the sun and his subsequent failure to maintain sufficient clearance…Jan 27, 2014 · N207DS · DestroyedNTSB CEN14FA064Accident · 1 fatalField investigationFinal reportCessna T210 · Cedaredge, COThe pilot's spatial disorientation while operating in dark night conditions in snow showers and his subsequent failure to maintain airplane control, which resulted in overstress of the airplane and an in-flight breakup. Contributing to the loss of control was…Nov 20, 2013 · N6832B · DestroyedNTSB CEN11LA164Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Bennett, COThe pilot's failure to maintain control of the airplane during an instrument approach due to spatial disorientation.Jan 30, 2011 · N787CB · Substantial damageNTSB CEN10FA299Accident · 1 fatalField investigationFinal reportBeech G35 · Marble, COThe pilot’s miscalculation of the airplane's turn radius and climb capabilities at high altitude, resulting in controlled flight into terrain. Contributing to the accident was the pilot's lack of mountain flying experience and restricted visibility due to the…Jun 6, 2010 · N887M · Substantial damageNTSB CEN10LA047Accident · No injuriesLimited investigationFinal reportCessna T182T · Loveland, COThe pilot's failure to attain the proper touchdown point during dusk light conditions, and his failure to execute a go-around.Nov 1, 2009 · N652CP · Substantial damageNTSB CEN09LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Whitewater, COBoth pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.Oct 22, 2008 · N3389D · 2 aircraft · Substantial damage