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 CEN23LA134Accident · No injuriesClass 4 · LimitedFinal reportHonda HA-420 · Buena Vista, COThe pilot’s inability to maintain directional control during landing with a gusting left crosswind resulting in the runway excursion.NTSB CEN23LA123Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CCX-2000 · Erie, COThe pilot’s loss of directional control during landing.NTSB CEN23LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Limon, COThe pilot’s failure to maintain directional control during the takeoff roll.NTSB CEN23LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Brush, COThe pilot’s failure to maintain directional control during the landing roll with strong gusty surface winds.NTSB CEN23LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Las Animas, COThe student pilot’s loss of control during approach for landing and the flight instructor’s inadequate supervision of the approach and delay in ensuring a go-around was performed at the onset of a stall warning.NTSB DCA23LA086Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COThe flight’s encounter with mechanical turbulence.NTSB CEN23LA049Accident · No injuriesClass 3 · LimitedFinal reportCessna 182A · Durango, COA complete loss of engine power for reasons that could not be determined from the available evidence.NTSB CEN23LA048Accident · No injuriesClass 4 · LimitedFinal reportHughes 369HS · Oxford, COThe designated pilot examiner’s failure to maintain a proper descent during a practice 180° autorotation which resulted in a hard landing.NTSB CEN23LA032Accident · No injuriesClass 4 · LimitedFinal reportMulholland Robert A Vans RV-7 · Englewood, COAn encounter with windshear during the initial climb after takeoff, which resulted in a loss of control. Contributing to the accident was the pilot’s improper decision to takeoff with a tailwind.NTSB CEN23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Aguilar, COFailure of the engine cylinder assembly, which resulted in a loss of engine power during cruise flight and an impact with a fence during the forced landing.NTSB CEN23LA017Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Loveland, COThe pilot’s loss of control after encountering windshear while landing in a strong, gusting crosswind. Contributing was pilot’s decision to continue the landing with a 90-degree crosswind at 30 knots.NTSB CEN23LA013Accident · Serious injuriesClass 4 · LimitedFinal reportPober Pixie · Sterling, COThe pilot’s failure to maintain control during the takeoff with strong gusty surface wind.NTSB DCA23LA008Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Denver, COAn encounter with clear air turbulence during cruise flight.NTSB CEN22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportHibbard Norman E Thorp T-18 · Del Norte, COThe pilot’s loss of airplane control during landing due to a wind gust.NTSB CEN22FA424Accident · 3 fatalClass 3 · FieldFinal reportCessna 172S · Longmont, COThe pilots’ inability to see and avoid each other, resulting in a midair collision.NTSB CEN22LA421Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-180 · Broomfield, COA partial loss of engine power due to a collapsed induction hose that blocked engine intake airflow.NTSB CEN22LA414Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Fort Collins, COThe pilot’s failure to maintain clearance from rising terrain while intentionally maneuvering the airplane at low altitudes, which resulted in substantial damage to the fuselage and both wings.NTSB DCA22LA196Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-824 · Denver, COAn encounter with clear air turbulence, which resulted in a serious injury as a flight attendant was lowering her jumpseat.NTSB CEN22LA390Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100-180 · Pueblo, COThe flight instructor’s failure to maintain adequate airspeed during the demonstrated soft-field takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN22FA376Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Centennial, COThe loss of engine power during a departure climb for undetermined reasons and the aerodynamic stall, which resulted in an uncontrolled descent and impact with terrain.NTSB CEN22LA362Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Longmont, COThe flight instructor’s failure to properly supervise the student pilot, which resulted in a continued unstablized approach for landing, and the instructor’s delayed recovery that resulted in a loss of control and impact with terrain.NTSB WPR22FA256Accident · 4 fatalClass 3 · FieldFinal reportCessna T337G · Gold Hill, COThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering with one engine inoperative, which resulted in an aerodynamic stall/spin and impact with terrain.NTSB CEN22LA319Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-19B · Elbert, COThe pilot’s misidentification of the runway during the visual approach which resulted in an off runway landing and impact with a trailer.NTSB CEN22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Aurora, COA total loss of engine power due to foreign object debris blockage of engine air intake. The source of the debris could not be determined based on the available information.NTSB CEN22LA297Accident · Minor injuriesClass 3 · LimitedFinal reportCub Crafters CC18-180 · Air Force Academy, COThe pilot’s failure to maintain airplane control during the go-around, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment from the effects of alcohol consumption.NTSB CEN22FA240Accident · 1 fatalClass 3 · FieldFinal reportHPH Spol Sro Glasflugel 304 MS · Rifle, COThe glider’s encounter with gusting tailwind and downdraft conditions that the pilot was unable to overcome.NTSB CEN22FA208Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Broomfield, COThe pilot’s failure to abort the takeoff due to degraded engine performance. Contributing to the accident was the reduced performance of the engine, the reason for which could not be determined.NTSB CEN22LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Denver, COThe main landing gear collapsed during landing for reasons that could not be determined.NTSB CEN22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Broomfield, COThe pilot’s failure to maintain control of the airplane for reasons that could not be determined.NTSB CEN22LA195Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA226-T(B) · Denver, COThe captain’s failure to ensure that the parking brake was correctly released before takeoff, which resulted in seized brakes during landing and a subsequent loss of directional control and runway excursion.NTSB CEN22LA179Accident · No injuriesClass 3 · LimitedFinal reportCessna 172N · Englewood, COThe flight instructor’s inadequate supervision of the student pilot and the student pilot’s loss of directional control during landing, which resulted in a runway excursion.NTSB CEN22LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Twin Lakes, COThe failure of the left turbocharger at FL230, which resulted in a rapid loss of manifold pressure and subsequent complete loss of engine power due to an overly rich fuel-air mixture setting. Contributing was the smoke in the cabin in IMC, which caused the…NTSB CEN22LA171Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Peyton, COThe pilot’s decision to not activate the runway lighting and misjudged the runway location, which resulted in a collision with a windsock.NTSB CEN22LA165Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Calhan, COThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB CEN22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Englewood, COA total loss of engine power on short final for reasons that could not be determined based on the available evidence.NTSB CEN22LA130Accident · No injuriesClass 3 · LimitedFinal reportRaytheon Hawker 800XP · Aspen, COThe flight crew’s decision to takeoff in tailwind conditions that were consistently above the airplane’s tailwind limitation, which resulted in a runway overrun following an aborted takeoff. Contributing was the flight crew’s use of the instantaneous wind…NTSB CEN22LA110Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Fort Carson, COThe windshear encounter on short final approach, which resulted in an excessive decent rate and ground impact.NTSB DCA22LA069Accident · No injuriesClass 4 · LimitedFinal reportAirbus A320-232 · Hayden, COThe captain’s rotation of the airplane pitch before the rotation speed on takeoff due to his surprise about encountering head on landing traffic, which resulted in an exceedance of the airplane’s pitch limit and a subsequent tail strike. Contributing to the…NTSB CEN22LA093Accident · No injuriesClass 3 · LimitedFinal reportZenith CH750 · Montrose, COA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN22FA069Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Steamboat Springs, COThe pilot’s failure to adhere to the published instrument approach procedure, which resulted in controlled flight into terrain.NTSB CEN22LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Delta, COFuel starvation resulting in a loss of engine power.NTSB CEN22FA064Accident · 1 fatalClass 3 · FieldFinal reportVans RV-4 · Walsenburg, COThe pilot’s failure to maintain clearance from terrain while intentionally maneuvering in a canyon at low altitude. Contributing to the accident was the pilot’s decision to enter a canyon environment at a low altitude, and the sudden change in wind conditions…NTSB CEN22FA035Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802A · Estes Park, COThe airplane’s encounter with severe to extreme turbulence associated with mountain wave rotor cloud activity, which resulted in loss of airplane control.NTSB CEN22LA028Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Greeley, COThe pilot’s loss of directional control during the landing roll.NTSB CEN22FA011Accident · 1 fatalClass 3 · FieldFinal reportBeech 58TC · Mesa, COThe maintenance personnel’s failure to properly tighten the turbocharger oil line and the right engine propeller governor, which resulted in a loss of engine power. Contributing to the accident was the loss of airplane control following the loss of engine…NTSB CEN22LA010Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-24 · Loveland, COThe pilot’s failure to recognize the degraded engine power and abort the takeoff in a timely manner.NTSB CEN22LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 195 · Watkins, COThe separation of the left main landing gear spring during landing roll due to a preexisting fatigue crack.NTSB CEN21FA424Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75 · Delta, COThe pilot’s loss of control during an aerobatic maneuver, resulting in the airplane impacting terrain.NTSB CEN21LA425Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Mark III · Steamboat Springs, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN21LA414Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · LaSalle, COA loss of engine power for undetermined reasons.