NTSB investigations, CO
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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.
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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN21LA403Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Gunnison, COThe pilot’s failure to maintain directional control of the airplane after landing with a quartering tailwind.NTSB CEN21LA404Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Delta, COA total loss of engine power that resulted in a forced landing and subsequent noseover. The reason for the total loss of engine power could not be determined based on the available evidence.NTSB CEN21LA449Accident · No injuriesClass 4 · LimitedFinal reportColumbia Aircraft Mfg LC41-550FG · Granby, COThe pilot’s loss of control during landing in high density altitude conditions.NTSB CEN21LA383Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Gypsum, COA loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.NTSB CEN21LA325Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35-C33 · Longmont, COThe airplane’s lack of climb performance after takeoff in high density altitude conditions for reasons that could not be determined based on the available evidence.NTSB CEN21LA315Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Longmont, COThe loss of performance for reasons that could not be determined.NTSB CEN21FA305Accident · 2 fatalClass 3 · FieldFinal reportHawker Beechcraft G36 · Aspen, COThe pilot’s failure to navigate through mountainous terrain, which resulted in controlled flight into terrain.NTSB CEN21LA292Accident · Minor injuriesClass 4 · LimitedFinal reportCurnutt Elton E SKY Ranger B · Ellicott, COThe pilot’s loss of control while maneuvering at low altitude.NTSB CEN21LA291Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Loveland, COThe flight instructor’s failure to maintain aircraft control during the landing flare and subsequent attempted go-around with a strong quartering crosswind.NTSB CEN21LA289Accident · No injuriesClass 4 · LimitedFinal reportBeech H35 · Watkins, COThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and a subsequent impact with an obstacle.NTSB CEN21LA281Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-35 · Wellington, COThe glider pilot’s loss of visual references during the landing approach resulting in an off-airport landing on rough sloping terrain.NTSB CEN21FA272Accident · 2 fatalClass 3 · FieldFinal reportAntenor Velazco Lancair Evolution · Parker, COThe pilot’s diversion of attention following an asymmetric flap deployment, which resulted in a descent and collision with powerlines. Contributing to the accident was maintenance personnel’s failure to properly secure the flap control rod attachment bolts,…NTSB CEN21LA271Accident · Minor injuriesClass 3 · LimitedFinal reportCessna T210L · Buena Vista, COThe partial loss of engine power due to a vane failure in the engine-driven fuel pump.NTSB CEN21LA261Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Lafayette, COThe flight crew’s improper fuel management that resulted in fuel starvation and the loss of engine power.NTSB CEN21LA251Accident · Minor injuriesClass 4 · LimitedFinal reportKevin Lippert Zenith CH 750 · Montrose, COThe loss of engine power due to fuel vapor lock.NTSB CEN21LA259Accident · No injuriesClass 3 · LimitedFinal reportCessna 560XL · Aspen, COThe malfunction of the landing gear handle for reasons that could not be determined, which caused the right main landing gear to collapse during the landing roll.NTSB CEN21LA248Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · Denver, COThe pilot’s failure to properly configure the airplane for landing, which resulted in a gear-up landing.NTSB CEN21LA241Accident · Serious injuriesClass 3 · LimitedFinal reportPipistrel Alpha Trainer · Fort Collins, COA partial loss of engine power due to the failure of the throttle control cable, which resulted in the loss of control of the dual carburetor system. The cable failure was a result of improper soldering at the throttle cable input terminal on the splitter…NTSB CEN21LA236Accident · No injuriesClass 4 · LimitedFinal reportBerry TX-11C · Longmont, COThe pilot’s loss of directional control when his foot became stuck on a protruding bolt in the airplane’s floorboard.NTSB CEN21LA227Accident · No injuriesClass 4 · LimitedFinal reportVarner David L Vans RV-8 · Watkins, COThe pilot’s failure to maintain control of the airplane during landing.NTSB CEN21FA215Accident · No injuriesClass 3 · FieldFinal reportSwearingen SA226TC · Englewood, COThe Cirrus pilot’s failure to maintain the final approach course for the assigned runway, which resulted in a collision with the Swearingen which was on final approach to the parallel runway. Contributing to the accident was the failure of the controller to…NTSB CEN21LA202Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75 · Denver, COThe pilot’s failure to maintain directional control during the landing roll with variable and gusty wind conditions.NTSB CEN21LA196Accident · No injuriesClass 4 · LimitedFinal reportMobi-light CCX-2300 · Loveland, COThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop, and the failure of both pilots to establish who was in control of the airplane.NTSB CEN21LA210Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons 2010 Firefly 12B-010 · Pagosa Springs, COThe pilot’s failure to properly control the balloon during a steep approach that resulted in a hard landing and a serious passenger injury.NTSB CEN21LA190Accident · No injuriesClass 3 · LimitedFinal reportGates Learjet 35A · Colorado Springs, COThe flight crew’s improper decision to continue the unstabilized approach, which resulted in an aerodynamic stall and impact with the runway during landing.NTSB DCA21LA120Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7 · Boulder, COa bird strike.NTSB CEN21FA177Accident · 1 fatalClass 3 · FieldFinal reportMagnus Fusion 212 · Conifer, COThe pilot’s decision to fly at low altitude toward a mountainous canyon, and his exceedance of the airplane’s critical angle of attack while maneuvering to avoid rising terrain, which resulted in an aerodynamic stall and loss of airplane control.NTSB CEN21LA182Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Denver, COThe pilot’s loss of situational awareness, and his unintended landing on a soft unimproved dirt road, which resulted in a loss of directional control into soft ground and the airplane to subsequently nose over.NTSB CEN21LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Watkins, COThe pilot’s failure to maintain directional control during takeoff and the instructor pilot’s inadequate supervision of the pilot’s takeoff.NTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.NTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.NTSB CEN21LA149Accident · No injuriesClass 4 · LimitedFinal reportAeropro CZ S R O A220 · Loveland, COThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with terrain.NTSB CEN21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Aspen, COThe pilot’s failure to maintain directional control on landing.NTSB 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…NTSB CEN21LA119Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Silt, COThe pilot’s failure to avoid powerlines while flying at low altitude.NTSB CEN21LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 150K · Peyton, COThe student pilot did not maintain directional control of the airplane while landing. Contributing to the accident was the pilot’s diverted attention to the incorrect flap setting.NTSB CEN21LA086Accident · No injuriesClass 4 · LimitedFinal reportEclipse EA 500 · Leadville, COThe pilot’s failure to maintain proper control of the airplane, which led to an unstabilized approach and a long landing on a runway contaminated with ice and patchy packed snow resulting in a runway excursion.NTSB CEN21LA067Accident · 2 fatalClass 3 · LimitedFinal reportVans RV4 · Telluride, COThe pilot’s failure to maintain adequate airspeed during the turn from the base leg to final approach, which resulted in the airplane exceeding its critical angle of attack and entering an inadvertent aerodynamic stall/spin at a low altitude over mountainous…NTSB CEN21LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32R · Canon City, COThe failure of the alternator drive belt, which resulted in insufficient electrical power to extend the landing gear and a subsequent gear-up landing. .NTSB CEN21LA051Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Denver, COThe student pilot’s failure to maintain control of the airplane during landing with a gusting crosswind and his failure to go around and relinquish control of the airplane when directed by the instructor pilot.NTSB CEN21LA027Accident · Serious injuriesClass 4 · LimitedFinal reportCcx-2000-0081 CCX-2000 · Longmont, COThe pilot failed to maintain control of the airplane during landing.NTSB CEN21LA006Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7AC · Salida, COThe student pilot’s loss of directional control during takeoff and the flight instructor’s delayed remedial action which resulted in a runway excursion and impact with a steel object.NTSB CEN21FA007Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Telluride, COThe pilot’s loss of control during the climb to cruise flight resulting in the airplane’s impact with terrain. Contributing to the accident was the pilot’s decision to not climb to a higher altitude before proceeding over high terrain.NTSB CEN21LA023Accident · No injuriesClass 4 · LimitedFinal reportEvolution Revolt · Durango, COThe pilot’s loss of directional control during landing following a hard landing and failure of the right main tire.NTSB CEN21LA001Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 210 · Cedaredge, COA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN21LA002Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Byers, COA partial loss of engine power for undetermined reasons.NTSB CEN21LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Denver, COFailure of the landing gear motor that prevented the gear from extending fully to the down and locked position, which resulted in a gear collapse on landing and a subsequent loss of directional control.NTSB CEN20LA424Accident · Serious injuriesClass 3 · LimitedFinal reportKitfox Speedster · Leadville, COA partial loss of engine power due to fuel starvation as a result of the pilot’s improper maintenance.NTSB CEN20CA404Accident · No injuriesClass 4 · Data collectionFinal reportCubcrafters CC11 · Larkspur, COThe pilot’s failure to maintain control of the airplane while taking off in gusting quartering tailwind conditions.