NTSB investigations, 2012, CO

18 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2012, CO per year, 2008–2026: 266 cases
200828
200913
20109
201122
201218
201316
201422
201515
201612
201715
201817
201914
202015
202110
20229
20235
202410
20259
20267

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\") = 2012
    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\" = '470' 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 CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.Dec 2, 2012 · N562BG · Substantial damageNTSB CEN13CA079Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-32 · Boulder, COThe glider pilot's inability to locate an area of thermal lift.Nov 29, 2012 · N9929J · Substantial damageNTSB CEN13CA005Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to maintain airspeed during the landing with known structural icing, which resulted in the airplane’s stall. Contributing to the accident was the pilot’s failure to divert to an area where conditions were not conducive to icing.Oct 5, 2012 · N6661P · Substantial damageNTSB CEN12LA668Accident · No injuriesLimited investigationFinal reportThompson RV-6 · Pagosa Springs, COThe pilot’s failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of landing experience at high density altitudes.Sep 20, 2012 · N140RV · Substantial damageNTSB CEN12LA522Accident · No injuriesLimited investigationFinal reportPiper PA18 · Peyton, COThe pilot's failure to maintain airplane control during taxi in gusting wind conditions.Aug 1, 2012 · N7808Z · Substantial damageNTSB CEN12FA462Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Walsenburg, COThe pilot's failure to maintain airplane control while turning from base to final leg in the traffic pattern.Jul 21, 2012 · N96YK · Substantial damageNTSB CEN12LA485Accident · No injuriesLimited investigationFinal reportMooney M20E · Englewood, COThe pilot's loss of directional control during landing.Jul 19, 2012 · N2609W · Substantial damageNTSB CEN12CA442Accident · Minor injuriesData collectionFinal reportDoppelt Fredric F F. 8L Falco · Durango, COThe pilot's failure to maintain control of the airplane and the instructor's delayed remedial action.Jul 15, 2012 · N532FD · Substantial damageNTSB CEN12CA370Accident · Minor injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot’s improper performance of a soft field takeoff procedure, which resulted in a loss of airplane control, and the flight instructor’s delayed remedial action to correct the situation.Jun 14, 2012 · N617EV · Substantial damageNTSB CEN12LA345Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe first officer’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the final approach in known low-level windshear conditions, which resulted in an aerodynamic stall. Contributing to the accident…Jun 7, 2012 · N500SW · Substantial damageNTSB CEN12FA320Accident · 1 fatalField investigationFinal reportTackabury Air-Cam · Fort Morgan, COThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an aerodynamic stall.May 28, 2012 · N788RJ · Substantial damageNTSB CEN12LA252Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Englewood, COThe pilot’s failure to abort the takeoff after the airplane failed to gain adequate airspeed.Apr 22, 2012 · N8518M · Substantial damageNTSB CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.Mar 23, 2012 · N10468 · 2 aircraft · Substantial damageNTSB CEN12CA264Accident · No injuriesData collectionFinal reportAir Tractor AT-301A · Cheyenne Wells, COThe pilot’s inadequate compensation for the wind conditions during takeoff.Mar 15, 2012 · N7306C · Substantial damageNTSB CEN12CA183Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Fort Collins, COThe pilot did not maintain adequate airspeed and airplane control during the go-around, which resulted in the airplane impacting trees.Mar 8, 2012 · N2986P · Substantial damageNTSB CEN12LA171Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Denver, COThe pilot's improper decision to taxi in wind conditions that exceeded the airplane’s capability.Feb 27, 2012 · N3196F · Substantial damageNTSB CEN12FA161Accident · 2 fatalField investigationFinal reportCessna 414A · Hayden, COThe pilot’s inadvertent stall during a missed approach. Contributing to the accident was the pilot’s operation of the airplane in forecasted icing conditions without using all of its anti-ice systems.Feb 19, 2012 · N4772A · Substantial damageNTSB CEN12LA126Accident · No injuriesLimited investigationFinal reportAviat A1 · Somerset, COThe pilot's inadequate takeoff planning/preparation, which resulted in the airplane impacting a snow drift during the takeoff roll.Jan 6, 2012 · N127AK · Substantial damage