NTSB investigations, CO
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 CEN19LA162Accident · Minor injuriesClass 3 · LimitedFinal reportRobinson R44 · Last Chance, COThe pilot's failure to maintain adequate main rotor rpm while descending with a tailwind during an aerial application maneuver, which resulted in an uncontrolled descent into terrain.NTSB GAA19CA306Accident · No injuriesData collectionFinal reportCirrus SR22 · Denver, COThe pilot's improper control inputs on approach, which resulted in a hard landing near the runway edge, a runway excursion, and impact with runway lighting. Contributing to the accident was the flight instructor's delayed remedial action.NTSB GAA19CA302Accident · No injuriesData collectionFinal reportDale Berkbigler CCX-2000 · Gunnison, COThe pilot's excessive brake application during the landing roll, which resulted in a noseover.NTSB GAA19CA295Accident · No injuriesData collectionFinal reportPipistrel Alpha Trainer · Salida, COThe pilot's failure to replace the fuel cap after fueling, which resulted in a loss of engine power due to fuel exhaustion and a subsequent forced landing to a field and subsequent collision with a fence.NTSB CEN19FA143Accident · 1 fatalField investigationFinal reportBeech 60 · Loveland, COA loss of control due to an inflight right engine fire due to the loose fuel hose between the engine-driven fuel pump and the flow transducer.NTSB CEN19LA169Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 162 · Las Animas, COThe pilot's decision to land on soft, muddy terrain, which resulted in a nose over.NTSB GAA19CA262Accident · No injuriesData collectionFinal reportCub Crafters Carbon CUB EX · Grand Junction, COThe pilot's failure to maintain clearance from power lines during low-level maneuvering through a canyon.NTSB GAA19CA257Accident · Minor injuriesData collectionFinal reportCessna 182 · Glades Park, COThe pilot's failure to maintain adequate airspeed and climb rate during takeoff in high-density altitude conditions, which resulted in his failure to clear power lines.NTSB GAA19CA211Accident · No injuriesData collectionFinal reportTubbs S/Performance Air PA-18-225 · Denver, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA19CA208Accident · Serious injuriesData collectionFinal reportAirframes Unlimited Outlaw · Elizabeth, COThe pilot's failure to maintain adequate airspeed and his subsequent decision to initiate a turn, which resulted in the powered parachute’s descent and impact with a fence.NTSB 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.NTSB GAA19CA165Accident · No injuriesData collectionFinal reportCirrus SR20 · Akron, COThe student pilot's failure to maintain directional control during landing, which resulted in a runway excursion and collision with a drainage culvert.NTSB CEN19LA085Accident · Serious injuriesClass 3 · LimitedFinal reportTecnam P92 · Englewood, COThe loss of engine power for undetermined reasons, because the airplane wreckage was sold and relocated before the engine could be examined.NTSB DCA19CA079Accident · No injuriesClass 4 · Data collectionFinal reportAirbus A320 · Denver, COloss of control of the tug by the driver during pushback operations as a result of the contaminated ramp, angle of the towbar, and the airplane engines being at idle thrust.NTSB GAA19CA117Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Longmont, COThe pilot's failure to maintain directional control during landing.NTSB CEN19LA048Accident · No injuriesClass 3 · LimitedFinal reportVans RV 6 · Watkins, COThe pilot’s failure to apply adequate torque to a fuel line during recent maintenance, which allowed the line to loosen in flight and fuel to enter the hot engine compartment and resulted in an in-flight fire that consumed the airplane.NTSB CEN19LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Norwood, COThe partial loss of engine power for undetermined reasons.NTSB WPR19TA034Accident · Minor injuriesClass 3Final reportCessna 172 · Colorado Springs, COThe pilot's decision to perform a touch-and-go landing at a high-density altitude airport, with a tailwind, and on an upsloping runway, which resulted in decreased airplane performance and the airplane’s inability to become airborne within the available…NTSB CEN19FA022Accident · 2 fatalField investigationFinal reportMustang II · Broomfield, COThe pilot's inability to maintain airplane control following an encounter with mountain wave turbulence.NTSB GAA19CA045Accident · No injuriesData collectionFinal reportPiper PA18 · Denver, COThe pilot's failure to maintain directional control of the airplane during landing in gusting wind conditions.NTSB ERA19LA027Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Parker, COA partial loss of engine power during initial climb due to carburetor icing, and the pilot's failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB GAA19CA026Accident · No injuriesData collectionFinal reportCessna 140 · Denver, COThe pilot’s inadvertent brake application, which resulted in a loss of directional control and a subsequent nose-over.NTSB GAA19CA023Accident · No injuriesData collectionFinal reportSkystar Kitfox SER 5 Safari · Monte Vista, COThe pilot's improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing and his subsequent failure to maintain directional control.NTSB CEN19LA006Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Hudson, COThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB DCA19CA010Accident · Serious injuriesClass 4 · Data collectionFinal reportAirbus A319 · Denver, COinadvertent encounter with clear air turbulence resulting in a flight attendant receiving serious injuries.NTSB CEN18LA381Accident · No injuriesLimited investigationFinal reportPiper PA28 · Pagosa Springs, COThe student pilot's mismanagement of the fuel selector valve during the simulated forced landing demonstration and the flight instructor's inadequate supervision to ensure the fuel selector was properly set, which resulted in a loss of engine power and…NTSB GAA18CA544Accident · No injuriesData collectionFinal reportHalladay Roy Lockheed · Denver, COThe pilot's failure to verify that the emergency canopy release was in the correct position when opening the canopy during landing, which resulted in the canopy separating from the airplane and subsequently impacting the empennage.NTSB CEN18LA348Accident · No injuriesLimited investigationFinal reportPiper PA32R · Falcon, COThe pilot's decision to depart with an inoperative left magneto, which resulted in degraded climb performance in high-density altitude conditions and a subsequent emergency landing.NTSB CEN18LA335Accident · No injuriesLimited investigationFinal reportCessna R172E · Colorado Springs, COThe airplane’s failure to maintain a climb after takeoff, which resulted in a forced landing on unsuitable terrain; the reason for the airplane’s failure to climb could not be determined based on the available evidence.NTSB GAA18CA486Accident · No injuriesData collectionFinal reportBushby Mustang II · Akron, COThe pilot’s improper preflight planning that did not identify the unserviceable runway; his subsequent decision to attempt to takeoff from the rough, grassy runway; and his selection of an abort point with insufficient runway remaining, which resulted in a…NTSB 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…NTSB CEN18LA316Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Wiley, COThe pilot's failure to maintain proper clearance from the sprinkler guy-wire, which resulted in the airplane’s collision with the wire during a visual approach to landing.NTSB GAA18CA473Accident · Serious injuriesData collectionFinal reportVans RV6 · Greeley, COThe pilot’s exceedance of the airplane’s critical angle of attack during approach, which resulted in an aerodynamic stall.NTSB CEN18LA309Accident · 1 fatalLimited investigationFinal reportCameron A 250 · Hartsel, COThe passengers’ fall from the basket after landing when the basket tipped over.NTSB 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.NTSB GAA18CA433Accident · No injuriesData collectionFinal reportCessna 172 · Colorado Springs, COThe student pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB GAA18CA389Accident · No injuriesData collectionFinal reportSchweizer SGS 1 34 · Boulder, COThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard landing.NTSB CEN18LA180Accident · Minor injuriesLimited investigationFinal reportRoger G White Glasair · Broomfield, COThe failure of the right brake line, which resulted in a loss of directional control and runway excursion.NTSB 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.NTSB CEN18LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Broomfield, COThe overstress fracture of the upper link of the nose landing gear torque link assembly, which resulted in the pilot’s inability to maintain directional control during landing.NTSB CEN18LA142Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Colorado Springs, COThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB 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.…NTSB GAA18CA135Accident · No injuriesData collectionFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB CEN18LA102Accident · Serious injuriesLimited investigationFinal reportScheineman-Van Buren T 18 · Longmont, COThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a groundloop and nose over.NTSB CEN18LA087Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Loveland, COThe airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s…NTSB 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.NTSB CEN18LA076Accident · Serious injuriesLimited investigationFinal reportBeech K35 · Longmont, COA total loss of engine power for reasons that could not be determined because a postaccident examination of the airplane revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18LA068Accident · No injuriesLimited investigationFinal reportBarnes Steven D Steve Barnes RV 4 · Montrose, COThe total loss of engine power for reasons that could not be determined because a postaccident examination of the engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18LA059Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Longmont, COThe failure of the landing gear through bolt primarily due to fatigue during a hard landing, which resulted in a landing gear collapse and runway excursion. Contributing to the accident was noncompliance with the manufacturer service letter.NTSB 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.