NTSB investigations, CO
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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 CEN24LA321Accident · No injuriesClass 4 · LimitedFinal reportCessna A185 · Loveland, COThe pilot’s failure to maintain directional control during the landing, that resulted in a ground loop and a runway excursion. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN24LA302Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 260A · Colorado Springs, COThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing.NTSB CEN24LA328Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft Hawker 900XP · Telluride, COThe flight crew’s failure to properly configure the airplane for takeoff in a high-density altitude environment, which resulted in a loss of control and a subsequent runway excursion. Contributing to the accident was the flight crew’s failure to use…NTSB CEN24LA270Incident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Hillrose, COThe binding of the left flap due to improper maintenance.NTSB CEN24LA329Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Leadville, COA loss of brake fluid for reasons that could not be determined, which resulted in a loss of braking effectiveness during landing.NTSB CEN24LA244Accident · Minor injuriesClass 4 · LimitedFinal reportDesert Fox 1 · Ellicott, COThe pilot's decision to takeoff with a quartering tailwind and high density altitude which resulted in a runway overrun. Contributing to the accident was the failure of the right main axle mount due to the poor weld.NTSB CEN24FA228Accident · 2 fatalClass 3 · FieldFinal reportCessna 421 · Steamboat Springs, COThe pilot’s failure to maintain sufficient airspeed following a loss of engine power, which resulted in an inadvertent aerodynamic stall/spin at low altitude.NTSB CEN24LA226Accident · Serious injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006T · Larkspur, COThe flight instructor’s failure to apply carburetor heat, which resulted in a loss of left engine power due to carburetor icing.NTSB CEN24LA224Accident · No injuriesClass 4 · LimitedFinal reportJonker Sailplanes JS3 RES · Elbert, COThe pilot’s failure to maintain directional control during the landing with a right crosswind.NTSB CEN24LA227Accident · Minor injuriesClass 4 · LimitedFinal reportBeech D55 · Colorado Springs, COThe deflated right main landing gear tire due to a sidewall puncture made by an unknown object, which led to the pilot’s loss of directional control and the landing gear collapse during landing roll.NTSB CEN24FA212Accident · 1 fatalClass 3 · FieldFinal reportBeech V35A · Arvada, COA total loss of engine power due to oil starvation as a result of loose turbocharger oil line fittings.NTSB CEN24LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Gypsum, COThe failure of the flight instructor and the pilot to visually confirm the airplane’s fuel quantity during preflight, which resulted in a loss of engine power due to fuel exhaustion and an off-airport forced landing in rough terrain.NTSB CEN24LA206Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24-250 · Colorado Springs, COThe pilot’s failure to use the carburetor heat during a descent that resulted in the loss of engine power due to carburetor icing.NTSB CEN24LA198Accident · No injuriesClass 4 · LimitedFinal reportBrant T Phillips Super Cub EXP · Franktown, COThe pilot’s failure to maintain aircraft control during final approach and attempted go-around after encountering a sudden windshear.NTSB CEN24LA133Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Falcon, COThe flight instructor’s failure to maintain control during takeoff which resulted in an aerodynamic stall and an impact with terrain.NTSB CEN24LA129Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Fort Morgan, COAn inflight collision with birds while on approach.NTSB CEN24FA083Accident · 2 fatalClass 3 · FieldFinal reportJust Highlander · Dolores, COThe pilot’s collision with a fence while taking off from a snow-covered dirt airstrip.NTSB CEN24LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Alamosa, COThe pilot’s failure to maintain directional control during landing with an excessive touchdown speed that resulted in a loss of control and impact with terrain.NTSB CEN24LA036Accident · No injuriesClass 3 · LimitedFinal reportTextron 172S · Erie, COA partial loss of engine power while maneuvering at a low altitude due to a stuck exhaust valve.NTSB CEN24LA030Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · Lamar, COThe pilot's inadequate fuel planning and improper in-flight decision making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA018Accident · No injuriesClass 3 · LimitedFinal reportCessna 210B · Pueblo, COThe fatigue failure of the right main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position.NTSB CEN24LA015Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Tiger Moth DH 82A · Greeley, COThe pilot’s decision to turn out early during the initial climb and failure to maintain adequate airspeed/angle-of-attack, which resulted in an aerodynamic stall and impact with airport hangars. Contributing to the accident was the variable wind conditions…NTSB CEN24LA007Accident · Minor injuriesClass 4 · LimitedFinal reportFairchild 24 G · Peyton, COThe pilot’s excessive brake application during landing rollout led to the airplane nosing over.NTSB DCA23LA468Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-9 · Denver, COOverheated brakes due to the extended taxi at a higher power setting in an attempt to burn off fuel to achieve the proper takeoff weight that resulted in a wheel fire during takeoff.NTSB CEN23LA416Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Montrose, COThe pilot’s failure to maintain directional control during the landing roll with a gusting quartering headwind.NTSB CEN23LA413Incident · 1 fatalClass 3 · LimitedFinal reportPowrachute Airwolf · Erie, COThe pilot’s inadvertent manipulation of the throttle, which resulted in the aircraft traveling on the ground and the unsecured pilot being ejected from the aircraft and sustaining fatal injuries.NTSB CEN23LA397Accident · Serious injuriesClass 4 · LimitedFinal reportTitanium Auto Gyro Titanium Explorer · Falcon, COThe pilot’s failure to establish a proper airspeed before becoming airborne, which resulted in an inability to climb out of ground effect and subsequent hard landing. Contributing to the accident was high-density altitude.NTSB CEN23LA394Accident · Minor injuriesClass 4 · LimitedFinal reportTextron 172S · Englewood, COAn in-flight collision with multiple geese during initial climb.NTSB CEN23FA391Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Wellington, COThe pilot’s loss of glider control during approach for reasons that could not be determined, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB CEN23LA407Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Greeley, COThe pilot’s failure to extend the landing gear. Contributing to the accident was a malfunction of the landing gear warning horn for undetermined reasons.NTSB CEN23FA349Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Peyton, COThe pilot’s exceedance of the airplane’s critical angle of attack while intentionally maneuvering in a steep bank at low altitude, which resulted in an accelerated aerodynamic stall/spin and subsequent loss of airplane control.NTSB CEN23LA325Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic N-210 · Erie, COA hard landing due to the high wind conditions which resulted in two passengers sustaining serious injuries.NTSB CEN23LA305Accident · Serious injuriesClass 4 · LimitedFinal reportAdams Balloon AB · Lafayette, COAn inadvertent hard landing in high wind conditions resulting in serious injury of two passengers. Contributing to the accident was the increase in prevailing winds prior to the forecast.NTSB CEN23FA285Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-60-601P · Burlington, COThe pilot’s visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control in flight and subsequent impact with terrain.NTSB CEN23LA274Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Durango, COThe pilot’s failure to extend the landing gear before landing.NTSB CEN23LA277Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-50 · Elbert, COThe pilot's loss of directional control during takeoff and subsequent excessive use of brakes which resulted in a nose-over. Contributing to the accident was his decision to takeoff downwind.NTSB CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB CEN23LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Holyoke, COThe pilot's failure to maintain directional control during the landing roll.NTSB CEN23LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Watkins, COThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize the prelanding checklist to ensure the landing gear was extended before landing.NTSB CEN23LA235Accident · No injuriesClass 4 · LimitedFinal reportNorth American T-6G · Colorado Springs, COThe pilot’s failure to maintain directional control during landing.NTSB CEN23LA211Accident · No injuriesClass 3 · LimitedFinal reportW10 Tailwind · Penrose, COThe failure of the right rudder pedal stop due to an inadequate weld, which resulted in a loss of control on the ground.NTSB CEN23LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172B · Divide, COA loss of engine power during cruise flight for reasons that could not be determined.NTSB CEN23LA203Accident · No injuriesClass 4 · LimitedFinal reportNanchang CJ6 · Windsor, COAn inflight collision with a bird while on initial climb.NTSB CEN23LA208Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8E · Cortez, COFailure of the right main landing gear due to prolonged corrosion of the landing gear tube, which weakened the gear.NTSB CEN23LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna A185f · Grand Junction, COThe pilot’s failure to maintain directional control during the landing roll with gusting wind.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.NTSB CEN23FA174Accident · 4 fatalClass 3 · FieldFinal reportPool Cessna R172 · Victor, COThe pilot’s failure to follow established mountain flying guidance, which resulted in a loss of control and impact with trees and mountainous terrain. Contributing to the accident was the airplane’s reduced climb performance at the elevated density altitude…NTSB CEN23LA146Accident · No injuriesClass 4 · LimitedFinal reportBeech 35 · Telluride, COThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB CEN23LA132Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235B · Hotchkiss, COThe pilot’s loss of control during landing rollout on a snow-covered, turf airstrip.NTSB CEN23LA128Accident · Minor injuriesClass 3 · LimitedFinal reportZenith Zodiac 601XL · La Veta, COThe pilot’s decision to fly the airplane in which he had no experience in strong, gusting wind, which resulted his failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.