NTSB investigations, CO

183 cases where the sequence of events included Loss of control in flight.

Cases, newest first

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '240' 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 GAA19CA490Accident · No injuriesData collectionFinal reportDiamond DA20 · Pueblo, COThe student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.Aug 7, 2019 · N979DA · Substantial damageNTSB GAA19CA409Accident · No injuriesData collectionFinal reportDiamond DA 40 · Denver, COThe pilot receiving instruction's failure to maintain the runway heading and bank control during landing in crosswind conditions, which resulted in a go-around and subsequent collision with a runway light.Jul 13, 2019 · N388JP · Substantial damageNTSB CEN19LA107Accident · Serious injuriesLimited investigationFinal reportCessna R172E · Loveland, COAn inflight loss of control on landing approach due to encountering a down-draft, and the pilot's failure to take timely action to abandon the approach and perform a go-around.Mar 23, 2019 · N7879N · Substantial damageNTSB CEN19FA022Accident · 2 fatalField investigationFinal reportMustang II · Broomfield, COThe pilot's inability to maintain airplane control following an encounter with mountain wave turbulence.Nov 2, 2018 · N287BM · Substantial damageNTSB CEN18CA323Accident · No injuriesData collectionFinal reportCessna 172 · Greeley, COThe pilot’s and safety pilot's conflicting control inputs during landing, which resulted in their failure to maintain a proper airspeed and resulted in an aerodynamic stall. Contributing to the accident was the lack of communication between the pilot and…Aug 9, 2018 · N20JA · Substantial damageNTSB CEN18LA303Accident · Minor injuriesLimited investigationFinal reportBuchanan Kitfox IV · Loma, COThe pilot's improper decision to conduct a low-altitude flight over a river and his inadequate monitoring of the environment, which resulted in a collision with a cableway.Jul 31, 2018 · N125TY · Substantial damageNTSB CEN18FA168Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Lone Tree, COThe pilot's loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to fly the airplane at night in marginal weather conditions.May 12, 2018 · N507TX · DestroyedNTSB CEN18FA266Accident · 1 fatalField investigationFinal reportCessna 210 · Alma, COThe noncertificated pilot's poor decision to depart on a flight over mountainous terrain in an improperly maintained airplane, and the subsequent encounter with mountain wave turbulence, which resulted in the loss of airplane control and impact with terrain.…Apr 2, 2018 · N68640 · Substantial damageNTSB CEN18LA080Accident · Minor injuriesLimited investigationFinal reportTomlinson Tracy L Tukan · Erie, COThe student pilot’s inadvertent shutting off of the fuel valve while on approach, which resulted in a loss of engine power due to fuel starvation and impact with terrain.Jan 18, 2018 · N907T · Substantial damageNTSB CEN17FA354Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Glenwood Springs, COThe non-instrument-rated pilot's inadequate preflight weather planning, his decision to depart into forecast instrument meteorological conditions along the route of flight, and his continued visual flight into instrument meteorological conditions, which…Sep 16, 2017 · N462SR · DestroyedNTSB GAA17CA528Accident · No injuriesData collectionFinal reportCessna 152 · Broomfield, COThe student pilot’s failure to maintain directional control while landing in gusting crosswind conditions.Sep 9, 2017 · N89732 · Substantial damageNTSB CEN17LA327Accident · Minor injuriesLimited investigationFinal reportGreene R/Greene S Rans S 17 · Erie, COThe pilot's failure to maintain control following a rejected takeoff for a perceived loss of engine power. Contributing to the accident was the pilot's lack of training and experience in the airplane.Aug 22, 2017 · N117BE · Substantial damageNTSB CEN17LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA 28R-200 · Centennial, COThe loss of airplane control during takeoff for reasons that could not be determined based on the available information, which resulted in an aerodynamic stall and impact with terrain.Feb 18, 2017 · N2702R · Substantial damageNTSB GAA17CA131Accident · Minor injuriesData collectionFinal reportCessna T210 · Loveland, COThe pilot's exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.Feb 5, 2017 · N4853U · Substantial damageNTSB CEN16FA328Accident · 1 fatalField investigationFinal reportAero Commander S2R · Center, COThe pilot's failure to maintain airplane control during a low-level maneuver, which resulted in an aerodynamic stall.Aug 19, 2016 · N8870Q · DestroyedNTSB CEN16FA241Accident · 1 fatalField investigationFinal reportBoeve Earl Seawind · Buena Vista, COThe pilot's failure to maintain control of the airplane during a forced landing following a partial loss of engine power, which resulted in a hard landing and nose over. The reason for the loss of engine power could not be determined due to the severity of…Jul 4, 2016 · N46EB · DestroyedNTSB GAA16CA336Accident · No injuriesData collectionFinal reportCessna 152 · Delta, COThe pilot exceeded the critical angle of attack during the initial climb in tailwind conditions, which resulted in an aerodynamic stall.Jun 25, 2016 · N152L · Substantial damageNTSB CEN16FA224Accident · 3 fatalField investigationFinal reportCessna 320E · Creede, COThe pilot's loss of airplane control during descent following a loss of engine power for reasons that could not be determined because postaccident examinations and engine test-runs of both engines revealed no evidence of any mechanical malfunctions or…Jun 15, 2016 · N777GY · DestroyedNTSB CEN16FA188Accident · 1 fatalField investigationFinal reportCessna P210N · Sheridan Lake, COThe pilot's severe impairment from the combined effects of high levels of ingested alcohol as well as three impairing medications (zolpidem, lorazepam, and diphenhydramine), which resulted in his decision to attempt an aerobatic maneuver that the airplane was…May 18, 2016 · N6609P · Substantial damageNTSB GAA16CA146Accident · Minor injuriesData collectionFinal reportBeech D17 · Brighton, COThe pilot's failure to maintain the runway course during takeoff, resulting in the airplane drifting to the left and impacting a fence. A contributing factor to the accident was the pilot's diverted attention during the takeoff.Mar 11, 2016 · N9290H · Substantial damageNTSB CEN16FA116Accident · 2 fatalField investigationFinal reportCurtiss Wright Travel AIR 4000 · Palmer Lake, COThe pilot's failure to maintain sufficient airspeed while maneuvering at low altitude in strong gusting winds, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's…Mar 2, 2016 · N6464 · DestroyedNTSB GAA16CA150Accident · No injuriesData collectionFinal reportCessna 172 · La Junta, COThe pilot's decision to take off with a tailwind, and exceed the critical angle of attack, which resulted in an aerodynamic stall and impact with the ground.Jan 31, 2016 · N2567U · Substantial damageNTSB CEN16FA086Accident · 1 fatalField investigationFinal reportBeech C35 · Meeker, COThe non-instrument-rated pilot's decision to fly the airplane in instrument meteorological conditions at high altitude for greater than 30 minutes without the use of supplemental oxygen which resulted in hypoxia, and a subsequent loss of control. Contributing…Jan 14, 2016 · N2025D · DestroyedNTSB GAA16CA060Accident · No injuriesData collectionFinal reportBeech 56 · Hudson, COThe pilot's failure to maintain directional control during the landing. Contributing to the accident was the distraction of the open cabin door.Nov 22, 2015 · N12WB · Substantial damageNTSB CEN16FA034Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Colorado Springs, COThe pilot's loss of airplane control during the turn back to the airport after takeoff in high density altitude conditions, which resulted in an inadvertent aerodynamic stall and subsequent spin. Contributing to the accident was the pilot's impaired…Nov 9, 2015 · N752C · DestroyedNTSB CEN16FA011Accident · 2 fatalField investigationFinal reportBeech G35 · Eaton, COThe pilot's loss of airplane control in gusting wind conditions and low-level wind shear, following a loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to properly monitor the fuel level inflight because of his…Oct 13, 2015 · N394CW · Substantial damageNTSB GAA15CA292Accident · No injuriesData collectionFinal reportCubcrafters CC11-160 · Lake City, COThe pilot's failure during takeoff to attain sufficient airspeed for conditions, and to maintain yaw control and a positive rate of climb, resulting in a loss of directional control, an uncontrolled descent, and collision with trees and terrain.Sep 29, 2015 · N4HW · Substantial damageNTSB GAA15CA294Accident · No injuriesData collectionFinal reportHoward DGA 15P · Englewood, COThe separation of the elevator control system linkage at a push/pull tube and cable joint, for an unknown reason, because the bolt and associated hardware securing the joint was not found for examination.Sep 25, 2015 · N1785H · Substantial damageNTSB CEN15MA290Accident · 1 fatalClass 1 · MajorFinal reportAirbus Helicopters AS350B3E · Frisco, COAirbus Helicopters' dual-hydraulic AS350 B3e helicopter's (1) preflight hydraulic check, which depleted hydraulic pressure in the tail rotor hydraulic circuit, and (2) lack of salient alerting to the pilot that hydraulic pressure was not restored before…Jul 3, 2015 · N390LG · DestroyedNTSB CEN15FA257Accident · 1 fatalField investigationFinal reportMorse Frank L Rebel · Eagle, CO, COThe pilot’s failure to maintain control of the airplane while landing in gusty, crosswind conditions that likely exceeded the recommended limitation of the airplane.Jun 5, 2015 · N914FM · Substantial damageNTSB CEN15LA295Accident · Serious injuriesLimited investigationFinal reportWaco UPF 7 · Montrose, COThe pilot's failure to attain suitable altitude while flying over high mountainous terrain in downdraft conditions.Jun 3, 2015 · N29943 · Substantial damageNTSB GAA15CA053Accident · Minor injuriesData collectionFinal reportAero SP Z O O AT 4 LSA · Colorado Springs, COThe pilot's decision to perform aerobatic maneuvers in an airplane not certified for aerobatic flight, which resulted in a loss of control and collision with terrain.Apr 30, 2015 · N344UA · Substantial damageNTSB CEN15FA211Accident · 1 fatalField investigationFinal reportHoffman Zenith 701 · Trinidad, COThe noncertificated pilot's failure to maintain airspeed following a loss of engine power while maneuvering at a low altitude, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. The reason for the…Apr 30, 2015 · N95MH · 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 CEN15CA128Accident · Serious injuriesData collectionFinal reportBurton Calidus · Grand Junction, COThe pilot's failure to maintain clearance with terrain that was along the planned route of flight.Jan 6, 2015 · N50NE · Substantial damageNTSB CEN15LA069Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Collins, COThe student pilot’s failure to comprehend the significance of the wake turbulence that a preceding helicopter would generate during departure, which resulted in a loss of airplane control during landing. Contributing to the accident was the lack of Federal…Dec 5, 2014 · N407ND · 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 CEN14CA469Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Granby, COThe pilot did not maintain control of the airplane during the go-around.Aug 29, 2014 · N224BR · Substantial damageNTSB CEN14CA460Accident · No injuriesData collectionFinal reportAviat Husky · Steamboat Springs, COThe student rated pilot's inadvertent flight control input resulting in a ground loop and substantial damage to the right wing.Aug 1, 2014 · N776BC · Substantial damageNTSB CEN14CA364Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's failure to maintain control during landing.Jul 14, 2014 · N562BG · Substantial damageNTSB CEN14CA360Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Englewood, COThe pilot did not maintain control of the helicopter during the takeoff resulting in low rotor rpm and impact of the fuel trailer during the running landing.Jul 11, 2014 · N69MP · Substantial damageNTSB CEN14FA339Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51D · Durango, COThe pilot's failure to compensate for the high-performance airplane's tendency to enter a torque roll during the initial climb, which resulted in the airplane entering a torque roll and the subsequent loss of control at too low of an altitude to recover.…Jul 4, 2014 · N1451D · Substantial damageNTSB CEN14FA328Accident · 3 fatalField investigationFinal reportPiper PA 28-235 · Georgetown, COThe pilot’s inability to maintain a climb while maneuvering the airplane in high-density altitude conditions that degraded the airplane’s climb performance and his exceedance of the airplane’s critical angle-of-attack, which led to an aerodynamic stall and…Jun 30, 2014 · N8814W · DestroyedNTSB CEN14LA277Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Durango, COThe student pilot’s decision to fly solo into an unfamiliar, mountain airport during high-wind conditions. Contributing to the accident was a partial loss of engine power during the attempted go-around, which was caused by an over-rich mixture setting.Jun 1, 2014 · N583KM · Substantial damageNTSB CEN14FA230Accident · No injuriesField investigationFinal reportPiper PA 25-235 · Northglenn, COThe pilot's decision to operate the banner-tow flight below the minimum safe altitude specified by federal regulation, which likely limited his ability to recover from a potential loss of airspeed due to a gusting wind condition. Also causal was the pilot’s…May 5, 2014 · N4519Y · DestroyedNTSB CEN14FA167Accident · 5 fatalField investigationFinal reportSocata TBM 700 · Ridgway, COThe pilot's loss of airplane control during an instrument approach procedure, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall and spin.Mar 22, 2014 · N702H · Substantial damageNTSB CEN14FA163Accident · 1 fatalField investigationFinal reportSmith Aerostar 601P · Aurora, COThe pilot's operation of the airplane while intoxicated, which resulted in a loss of airplane control.Mar 19, 2014 · N90464 · DestroyedNTSB CEN14CA440Accident · Serious injuriesData collectionFinal reportMooney M20J · Lamar, COThe pilot allowed the airplane to liftoff without sufficient airspeed which resulted in a stall and subsequent impact with the terrain.Mar 19, 2014 · N201VA · Substantial damageNTSB CEN14TA126Accident · Minor injuriesFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe flight instructor's loss of control after takeoff following a wake turbulence encounter from a preceding helicopter. Contributing to the accident were the flight instructor's misidentification of the helicopter type and a lack of Federal Aviation…Jan 29, 2014 · N959DA · Substantial damageNTSB CEN14FA099Accident · 1 fatalField investigationFinal reportCanadair CL 600 2B16 · Aspen, COThe flight crew's failure to maintain airplane control during landing following an unstabilized approach. Contributing to the accident were the flight crew's decision to land with a tailwind above the airplane's operating limitations and their failure not to…Jan 5, 2014 · N115WF · Destroyed