NTSB investigations, CO
296 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 12 |
| 1984 | 11 |
| 1985 | 17 |
| 1986 | 8 |
| 1987 | 14 |
| 1988 | 10 |
| 1989 | 11 |
| 1990 | 13 |
| 1991 | 11 |
| 1992 | 19 |
| 1993 | 14 |
| 1994 | 13 |
| 1995 | 5 |
| 1996 | 11 |
| 1997 | 10 |
| 1998 | 4 |
| 1999 | 10 |
| 2000 | 12 |
| 2001 | 7 |
| 2002 | 15 |
| 2003 | 11 |
| 2004 | 10 |
| 2005 | 15 |
| 2006 | 13 |
| 2007 | 11 |
Where
Open the mapLatest cases
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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 DEN08CA045Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Gunnison, COThe pilot's failure to maintain directional control of the airplane during takeoff resulting in the airplane hitting a snowbank and subsequently, the ground.NTSB DEN08LA017Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Salida, COThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain.NTSB DEN07FA158Accident · 2 fatalField investigationFinal reportEvektor-Aerotechnik a.s. SportStar · Erie, COThe flight instructor's failure to maintain sufficient airspeed during takeoff-initial climb to avoid a stall/spin. Contributing to the accident was the flight instructor's inadequate preflight planning, his failure to calculate the airplane's weight and…NTSB DEN07LA155Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Avondale, COThe pilot's failure to attain translational lift and his improper flare. A contributing factor in this accident was the sudden wind shift.NTSB DEN07CA131Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Erie, COThe student pilot's failure to maintain rotor rpm resulting in a loss of aircraft control during a simulated 180 degree auto-rotation. Contributing to the accident was the inadequate flight status supervision by the flight instructor and the student pilot's…NTSB DEN07CA128Accident · No injuriesData collectionFinal reportCessna 182T · Grand Junction, COThe pilot's failure to maintain aircraft control during the landing.NTSB DEN07CA123Accident · No injuriesData collectionFinal reportHorton Aviat ChristEagle II · Salida, COThe pilot's failure to maintain aircraft control during the landing, causing the airplane to depart the runway and impact the VASIs.NTSB DEN07CA112Accident · Minor injuriesData collectionFinal reportGrumman-Schweizer G-164B · Joes, COthe pilot's improper takeoff planning and subsequent failure to maintain aircraft control during the takeoff. Contributing factors were the high density altitude and tailwind.NTSB DEN07LA108Accident · 2 fatalLimited investigationFinal reportSchwarz RV-6A · Greeley, COthe pilot's failure to maintain airspeed resulting in an inadvertent stall and impact with terrain.NTSB DEN07CA104Accident · No injuriesData collectionFinal reportBeech B36TC · Hudson, COThe pilot's improper in-flight decision, and his failure to maintain proper aircraft control during takeoff resulting in an inadvertent stall and the subsequent impact with the runway and terrain.NTSB DEN07CA072Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Broomfield, COThe instructor's failure to maintain aircraft control. A contributing factor was the windshear.NTSB DEN07IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Denver, COThe inadvertent activation of the priority pushbutton on the sidestick by the first officer resulting in a nose down pitch and loss of aircraft control during the landing flare.NTSB DEN07CA015Accident · No injuriesData collectionFinal reportCessna T210G · Delta, COthe pilot's failure to maintain aircraft control and a proper descent rate during the landing.NTSB DEN06CA134Accident · No injuriesData collectionFinal reportCessna 152 · Bennett, COThe pilot's failure to maintain control of the airplane during the aborted takeoff. Factors contributing to the accident were the low airspeed and the pilot's improper in-flight planning.NTSB DEN06CA127Accident · No injuriesData collectionFinal reportPiper PA-46T-350P · Colo. Springs, COThe pilot's failure to maintain control of the airplane, resulting in an inadvertent stall. Contributing factors in this accident were the jet blast encounter, and the pilot's failure to initiate a go-around when he felt an unsafe condition existed.NTSB DEN06FA115Accident · 2 fatalField investigationFinal reportStallings VariEze · Loveland, COthe pilot's intentional aerobatics performed at low altitude, and his failure to maintain clearance from terrain. A contributing factor was the pilot's poor judgment.NTSB DEN06FA107Accident · 2 fatalField investigationFinal reportAmerican Champion 7KCAB · Winter Park, COThe pilot's failure to maintain adequate airspeed to avoid a stall while maneuvering at a low altitude in mountainous terrain. Factors associated with the accident are the pilot's performance of a low altitude flight maneuver, an inadvertent stall/spin, and…NTSB DEN06LA099Accident · Serious injuriesLimited investigationFinal reportAeronca 7AC · Parker, COthe flight instructor's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and subsequent impact with terrain. Contributing factors were the high density altitude, rising terrain, and improper in-flight planning.NTSB DEN06LA090Accident · Serious injuriesLimited investigationFinal reportExcel Jet Sport Jet · Colorado Sprngs, COA loss of control for an undetermined reason during takeoff-initial climb that resulted in an in-flight collision with terrain.NTSB DEN06CA084Accident · No injuriesData collectionFinal reportMalott Mustang II · Peyton, COthe pilot's failure to maintain control of the airplane. A contributing factor was the wind gust.NTSB DEN06CA075Accident · Minor injuriesData collectionFinal reportAviat A-1 · Alamosa, COthe pilot's failure to maintain aircraft control during the departure, resulting in an inadvertent stall.NTSB DEN06LA055Accident · Serious injuriesLimited investigationFinal reportMcLaughlin Rans S-7 · Hudson, COthe pilot's failure to maintain control of the airplane during an attempted landing. Contributing factors include the pilot's improper in-flight planning and decision making, the pilot's lack of experience in tailwheel airplanes, the pilot's lack of a…NTSB DEN06CA049Accident · No injuriesData collectionFinal reportStinson 108-1 · Limon, COthe pilot's failure to maintain aircraft control during the aborted landing resulting in an impact with a ditch. Contributing factors were the gusty wind conditions and the pilot's improper compensation for the wind conditions during landing.NTSB DEN06CA048Accident · No injuriesData collectionFinal reportEnstrom 280F · Peetz, COThe pilot's failure to maintain aircraft control while maneuvering resulting in an impact with terrain. Contributing factors were the gusty winds, downdrafts, and box canyon.NTSB DEN06LA026Accident · 2 fatalLimited investigationFinal reportSyracuse Kitfox · Niwot, COThe pilot's improper in-flight decision to perform aerobatics at a low altitude resulting in a loss of control and impact with terrain. A contributing factor was the pilot's lack of aerobatic experience.NTSB DEN06FA018Accident · 1 fatalField investigationFinal reportAmerican Champion 8KCAB · Calhan, COthe pilot's failure to maintain aircraft control. Factors contributing to the accident were the low altitude, and the resultant stall/spin.NTSB DEN06LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Cortez, COthe pilot's failure to maintain directional control of the airplane, resulting in a ground loop. Contributing factors were the excessive descent rate, the obstacle (horse), the high density altitude, and the tailwind.NTSB DEN05LA141Accident · 2 fatalLimited investigationFinal reportDenight 100D2 · Hudson, COthe pilot's failure to maintain adequate airspeed resulting in an inadvertent stall/spin.NTSB DEN05CA136Accident · Minor injuriesData collectionFinal reportCessna T207A · Telluride, COthe pilot's improper in-flight planning/decision and failure to maintain aircraft control. Contributing factors were the pilot's failure to maintain airspeed which resulted in an inadvertent stall, and the rising terrain and encounter with downdrafts.NTSB DEN05LA130Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Falcon, COthe pilot's failure to maintain control of the helicopter while conducting a hovering maneuver.NTSB DEN05TA113Accident · Minor injuriesFinal reportHughes 369FF · Loveland, COThe pilot's failure to maintain aircraft control due to delayed remedial action during the encounter with the loss of tail rotor effectiveness. Contributing factors were the pilot's inadequate preflight performance planning, and the inadequate supervision by…NTSB DEN05CA094Accident · No injuriesData collectionFinal reportSchweizer 269C · Broomfield, COthe pilot's failure to maintain adequate rotor rpm which resulted in a loss of control and an uncontrolled descent.NTSB DEN05CA096Accident · No injuriesData collectionFinal reportAviat A-1B · Dove Creek, COthe pilot's failure to maintain airspeed during initial climb which resulted in an inadvertant stall and impact with terrain.NTSB DEN05LA089Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cascade, COThe pilot's failure to maintain aircraft control during the attempted landing on mountainous terrain. A contributing factor was strong wind gusts during the attempted landing.NTSB DEN05LA139Accident · No injuriesLimited investigationFinal reportMooney M20K · Englewood, COthe pilot's failure to maintain control of the airplane and the pilot's improper use of unusual attitude recovery procedure. Contributing factors were the failure of the HSI and the clouds.NTSB DEN05CA079Accident · No injuriesData collectionFinal reportSchweizer 269C · Pueblo, COthe student pilot's failure to maintain control of the helicopter during the landing. Contributing to the accident was the flight instructor's inadequate supervision of the student pilot.NTSB DEN05FA066Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Broomfield, COthe pilot's failure to maintain aircraft control during landing. Contributing factor's included the quartering tailwind, and the pilot's inadequate in-flight decision making.NTSB DCA05MA037Accident · 8 fatalClass 1 · MajorFinal reportCessna 560 · Pueblo, COthe flight crew's failure to effectively monitor and maintain airspeed and comply with procedures for deice boot activation on the approach, which caused an aerodynamic stall from which they did not recover. Contributing to the accident was the Federal…NTSB DEN05CA052Accident · No injuriesData collectionFinal reportHughes 269C · Englewood, COthe student pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight. Contributing factors were low rotor rpm, low airspeed, and the instructor's delay in taking remedial action.NTSB DEN05LA035Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Monte Vista, COthe pilot's failure to maintain adequate airspeed which resulted in a stall during low level flight.NTSB DEN05CA007Accident · No injuriesData collectionFinal reportMooney M20E · Broomfield, COthe pilot's improper flare and recovery from a bounced landing during a touch and go maneuver. Contributing factors were the excessive airspeed and descent rate during the approach.NTSB DEN04LA133Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Hayden, COthe pilot's failure to maintain aircraft control during landing. Contributing factors include the excessive crosswind component, and the gusty wind conditions.NTSB DEN04CA120Accident · Minor injuriesData collectionFinal reportMooney M20J · Durango, COthe pilot's inadequate compensation for wind conditions and his failure to maintain adequate airspeed resulting in a stall. Factors contributing to the accident were the wind gusts, the downdraft, and the road.NTSB DEN04FA119Accident · 2 fatalField investigationFinal reportCessna 172P · Monarch Crest, COthe pilot's failure to maintain airspeed which resulted in a stall, and his decision to conduct flight beyond the performance capability of the aircraft. A contributing factor was the high density altitude, and an inadvertent stall.NTSB DEN04CA097Accident · No injuriesData collectionFinal reportCessna 172E · La Junta, COthe student pilot's failure to maintain aircraft control and adequate airspeed during the go-around resulting in an inadvertent stall. Contributing to the accident was the low airspeed and altitude.NTSB DEN04LA089Accident · 1 fatalLimited investigationFinal reportHispano Aviacion HA-200 · Pueblo, COThe pilot's failure to maintain adequate airspeed resulting in an accelerated stall at an altitude too low for recovery. A factor was the pilot's lack of experience in the aircraft make and model.NTSB DEN04LA081Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Peyton, COthe pilot's inadequate in-flight planning and decision making and his failure to maintain aircraft control during the landing flare which resulted in impact with terrain. Contributing factors include the pilot's failure to perform a go-around and the wind…NTSB DEN04CA076Accident · No injuriesData collectionFinal reportWilford J. Tolman Kitfox 6 · Montrose, COthe pilot's failure to maintain aircraft control during takeoff initial climb. A contributing factor was the gusting left tailwind weather condition.NTSB DEN04FA035Accident · 1 fatalField investigationFinal reportRockwell 690A · Cortez, COthe pilot's inadequate planned approach and his failure to maintain airspeed which resulted in a stall. Contributing factors were low altitude flight maneuvering in an attempt to lose excessive altitude and realign the airplane for landing, and his failure to…NTSB DEN04LA030Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Broomfield, COthe flight instructor's failure to maintain aircraft control. Contributing to the accident was the wind gust.