NTSB investigations, CO
275 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 20 |
| 1984 | 11 |
| 1985 | 12 |
| 1986 | 10 |
| 1987 | 21 |
| 1988 | 13 |
| 1989 | 19 |
| 1990 | 12 |
| 1991 | 10 |
| 1992 | 11 |
| 1993 | 11 |
| 1994 | 10 |
| 1995 | 7 |
| 1996 | 9 |
| 1997 | 7 |
| 1998 | 10 |
| 1999 | 11 |
| 2000 | 7 |
| 2001 | 13 |
| 2002 | 7 |
| 2003 | 10 |
| 2004 | 5 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 10 |
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\" = 260)
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" = 260) 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 DEN08LA031Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar Plus · Erie, COThe student pilot's failure to maintain directional control during landing. Contributing factors were the delayed remedial action and inadequate supervision by the flight instructor, and the ditch.NTSB DEN08CA002Accident · Minor injuriesData collectionFinal reportCessna 172N · Calhan, COThe student pilot's failure to maintain directional control during the takeoff roll.NTSB DEN07LA132Accident · Minor injuriesLimited investigationFinal reportBell 206B · Broomfield, COThe pilot's failure to maintain control of the helicopter, resulting in an inadvertent dynamic rollover.NTSB DEN07CA126Accident · No injuriesData collectionFinal reportFound Aircraft Canada FBA-2C2 · Crested Butte, COThe pilot's failure to maintain directional control during the landing roll.NTSB DEN07CA111Accident · No injuriesData collectionFinal reportCessna 180A · Loveland, COThe pilot's failure to maintain directional control of the airplane during landing.NTSB DEN07CA099Accident · No injuriesData collectionFinal reportAeronca 7AC · Erie, COThe student pilot's failure to maintain direction control during the landing roll.NTSB DEN07CA094Accident · Minor injuriesData collectionFinal reportCessna 180H · Grand Junction, COThe pilot's failure to maintain directional control during the take-off roll. A factor contributing to the accident was the crosswind.NTSB DEN07CA080Accident · No injuriesData collectionFinal reportAviat A-1B · Englwood, COThe pilot's failure to maintain directional control during landing resulting in a ground loop.NTSB DEN07LA051Accident · No injuriesLimited investigationFinal reportPiaggio Industrie P180 · Eagle, COThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB DEN07CA047Accident · No injuriesData collectionFinal reportCessna 182G · Lamar, COthe pilot's inability to maintain directional control resulting in an impact with a snow bank. Contributing factors include the obscured runway lights, inoperative landing lights, and the pilot's improper decision to operate an airplane with known systems…NTSB DEN07LA030Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Steamboat Springs, COThe inadequate design of the engine mount, which caused an uncommanded left turn, loss of directional control, and impact with snow-covered terrain. Contributing to the accident was the low nose gear tire pressure.NTSB DEN06CA071Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Rangely, COthe pilot's inadvertent application of the brake during the landing roll. A contributing factor was the pilot's failure to maintain directional control and the flight instructor's inadequate supervision during the landing.NTSB DEN06CA066Incident · No injuriesData collectionFinal reportCessna 170A · Buena Vista, COThe pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the crosswinds and the wind gusts.NTSB DEN06CA033Accident · No injuriesData collectionFinal reportCessna 172M · Denver, COthe pilot's failure to align the airplane's nose into the direction of the wind while performing the pre-takeoff checklist. A contributing factor was the gusty wind conditions.NTSB DEN06CA030Accident · No injuriesData collectionFinal reportAppel Mustang II · Erie, COthe pilot's inadequate preflight decision to depart in gusty winds, and the pilot's failure to maintain direction control during the departure roll. The high gusty crosswind contributed to the accident.NTSB DEN06CA012Accident · No injuriesData collectionFinal reportKucklick Hiperbipe · Watkins, COthe pilot's failure to maintain aircraft control during the landing resulting in a impact with a runway light and ground loop.NTSB DEN05CA120Accident · No injuriesData collectionFinal reportCessna 172RG · Fort Collins, COthe pilot's failure to maintain directional control. Contributing factors were the crosswind, the pilot's failure to compensate for the wind conditions --- allowing the airplane to touch down without being properly aligned with the runway --- and the flight…NTSB DEN05IA083Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe reason for the occurrence was not determined.NTSB DEN05LA115Accident · No injuriesLimited investigationFinal reportHepperlen RV-8 · Durango, COthe pilot's failure to maintain directional control during the ground roll.NTSB DEN05LA069Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Englewood, COThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control during landing. Contributing factors were crosswind weather conditions and a lack of familiarity with the aircraft.NTSB DEN05LA031Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COThe student pilot's failure to maintain directional control during landing.NTSB DEN05LA037Accident · No injuriesLimited investigationFinal reportCessna 172P · Loveland, COthe student pilot's failure to maintain directional control during landing and the student pilot's inadequate in-flight planning and decision making. Contributing factors include the quartering tail wind, the high airspeed, and the airport sign.NTSB DEN04FA134Accident · 1 fatalField investigationFinal reportMooney M20D · Pagosa Springs, COthe pilot's inadequate preflight planning and his failure to maintain directional control. Contributing factors were the pilot's failure to abort the takeoff, and the rough and uneven runway surface.NTSB DEN04CA066Accident · No injuriesData collectionFinal reportCessna 182K · Durango, COthe pilot's inadequate in-flight planning and decision making. Contributing factors include the crosswind and the crosswind component exceeded.NTSB DEN04LA037Accident · No injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Crawford, COthe pilot's failure to maintain directional control and his failure to maintain clearance from the snow bank during the landing. A factor contributing to the accident was the snow bank.NTSB DEN04LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Hudson, COthe pilot's failure to maintain directional control due to an excessive crosswind component, resulting in an uncontrolled groundloop/swerve. Contributing factors were the crosswind gust and the soft, sandy terrain.NTSB DEN04LA029Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Elbert, COthe pilot's failure to maintain directional control of the airplane. A contributing factor was his inexperience in aircraft type.NTSB DEN04LA021Accident · No injuriesLimited investigationFinal reportCessna T210N · Johnstown, COThe pilot's failure to maintain directional control during the landing roll. Factors contributing to the accident were the gusting crosswinds.NTSB DEN04LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Watkins, COThe pilot's failure to maintain aircraft control resulting in the ground loop. Factors contributing to the accident were the crosswind and the gusts.NTSB DEN03LA117Accident · No injuriesLimited investigationFinal reportMooney M20C · Englewood, COthe pilot's failure to maintain aircraft control during landing. Factors contributing to the accident were the gusting crosswinds and the high density altitude.NTSB DEN03FA070Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas MD-88 · Denver, COthe flight crew's failure to maintain aircraft control, which resulted in engine start with the throttles advanced and the subsequent impact with the tug. Contributing factors include, the flight crew's improper procedures/directives and failure to…NTSB DEN03LA080Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Watkins, COthe pilot's failure to maintain directional control of the aircraft during the landing roll out. Contributing factors were the unlocked tailwheel.NTSB DEN03LA052Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control during aborted landing. Contributing factors include the crosswind component, and the snow covered muddy terrain.NTSB DEN03LA058Accident · No injuriesLimited investigationFinal reportAviat A-1B · Englewood, COthe pilot's failure to maintain directional control of the airplane, resulting in an inadvertent ground loop. A contributing factor was the gusty winds.NTSB DEN03LA036Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Elbert, COthe pilot's inability to maintain aircraft control resulting in the ground loop. Factors relating to the accident were the crosswinds and the wind gusts.NTSB DEN03LA013Accident · No injuriesLimited investigationFinal reportMooney M20E · Broomfield, COthe pilot's failure to maintain directional control after landing due to a sheared steering horn attach bolt that should have been replaced by maintenance personnel in compliance with an outstanding service bulletin. Contributing factors included the pilot's…NTSB DEN03LA005Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Watkins, COthe pilot's inability [not possible] to control the airplane during landing roll due to the failure of the left brake, and the subsequent inadvertent ground loop.NTSB DEN02LA091Accident · No injuriesLimited investigationFinal reportBoeing D75N1 · Watkins, COthe pilot's improper recovery from a bounced landing, resulting in an inadvertent ground loop. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN02LA062Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falcon, COthe pilot's failure to maintain aircraft control during the takeoff roll and subsequent abort. Factors relating to the accident were the gusting crosswinds and the unsuitable terrain encountered when the airplane departed the runway.NTSB DEN02LA041Accident · No injuriesLimited investigationFinal reportCessna A185E · Greeley, COthe inadvertent ground loop during landing roll. A contributing factor was the partial brake system failure.NTSB SEA02LA047Accident · No injuriesLimited investigationFinal reportCessna 172N · Longmont, COThe student pilot's failure to maintain directional control during landing. Factors included the student pilot's lack of experience, an icy runway, and a mound of snow adjacent to the runway.NTSB DEN02LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the crosswind and the pilot's fatigue from lack of sleep.NTSB DEN02LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Crested Butte, COa wet brake that later froze resulting in a loss of directional control on landing. A contributing factor was the snow bank.NTSB DEN02LA014Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COthe pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the crosswind.NTSB DEN01LA155Accident · No injuriesLimited investigationFinal reportVans RV-6A · Pagosa Springs, COThe pilot's inadequate airplane preflight inspection which led to the subsequent lateral control of the airplane on the ground not being possible. A contributing factor was the unavailability of rudder control due to a headset blocking the rudder control…NTSB DEN01LA120Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COthe pilot's failure to properly recover from a bounced landing. A contributing factor were the adverse wind conditions.NTSB DEN01LA115Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Longmont, COthe pilot's failure to maintain directional control during landing. A contributing factor was the tailwind.NTSB DEN01LA112Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Akron, COthe pilot's failure to adequately compensate for wind conditions, resulting in a loss of directional control during landing roll. A contributing factor was the crosswind.NTSB DEN01LA081Accident · No injuriesLimited investigationFinal reportCessna 172P · Rangely, COthe pilot's improper use of aileron and his failure to maintain directional control during landing. A contributing factor was the direct gusty crosswind.NTSB DEN01LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Junction, COFailure by the pilot to maintain directional control during takeoff roll. A factor was a crosswind.