NTSB investigations, CO
127 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 8 |
| 1984 | 7 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 7 |
| 1988 | 7 |
| 1990 | 3 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 6 |
| 1996 | 7 |
| 1997 | 4 |
| 1998 | 4 |
| 1999 | 6 |
| 2000 | 8 |
| 2001 | 3 |
| 2002 | 6 |
| 2003 | 1 |
| 2004 | 7 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 5 |
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\" = 200)
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" = 200) 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 DEN08CA046Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Pueblo, COthe pilot's failure to maintain aircraft control resulting in a hard landing.NTSB DEN08CA020Accident · No injuriesData collectionFinal reportCessna 172N · Grand Junction, COthe pilot's improper flare resulting in a hard landing.NTSB DEN07CA163Accident · Serious injuriesData collectionFinal reportAerostar S81A · Hartsel, COthe pilot's inability to maintain the proper descent rate. A factor contributing to the accident was the unfavorable wind conditions.NTSB DEN07CA121Accident · No injuriesData collectionFinal reportCessna 180 · Marble, COThe pilot misjudging his altitude and his failure to maintain control of the airplane, resulting in a hard landing. Factors contributing to the accident were the excessive descent rate, and the pilot's improper recovery from a bounced landing.NTSB DEN07CA120Accident · No injuriesData collectionFinal reportFlight Design Ctsw · Peyton, COThe pilot's improper flare and failure to maintain control and subsequent hard landing. Contributing factors in this accident were the gusty winds, hot temperature, and high density altitude.NTSB DEN07LA042Accident · Serious injuriesLimited investigationFinal reportMino Kitfox 3 · Canon City, COThe certificated flight instructor's failure to adequately supervise the dual student during the landing flare-touchdown, which resulted in a hard landing and a nose over. A factor associated with the accident is the dual student's improper recovery from a…NTSB DEN06CA104Accident · Serious injuriesData collectionFinal reportTop Dog 582 · Pleasanat View, COthe pilot's improper flare resulting in a hard landing.NTSB DEN06LA076Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Del Norte, COthe pilot's failure to maintain airspeed, resulting in an inadvertent stall and impact with terrain during a power-on landing. Contributing factors were the pilot's improper recovery from a bounced landing, and windshear.NTSB DEN05LA111Accident · Serious injuriesLimited investigationFinal reportGates Learjet 35A · Eagle, COthe pilot's improper flare resulting in the hard landing and the fractured nose gear attachment, and the subsequent loss of control. Factors contributing to the accident were the high airspeed on approach, the pilot's improper in-flight planning/decision, and…NTSB DEN05CA095Accident · No injuriesData collectionFinal reportVans RV-6A · Trinidad, COthe pilot's inadequate compensation for wind and his inadequate recovery from a bounced landing.NTSB DEN05LA055Accident · No injuriesLimited investigationFinal reportCessna 172N · Loveland, COThe dual student's improper flare and the flight instructor's inadequate supervision.. A contributing factor was the inadequate communication between the flight instructor and the dual student,NTSB DEN04LA150Accident · No injuriesLimited investigationFinal reportCessna 172S · Broomfield, COthe pilot's improper flare, and the flight instructor's inadequate supervision of the pilot.NTSB DEN04LA148Accident · No injuriesLimited investigationFinal reportSmith, Ted Aerostar 601P · Broomfield, COthe pilot's improper in-flight planning/decision to accept a short traffic pattern and the improper flare resulting in a hard landing.NTSB DEN04CA137Accident · No injuriesData collectionFinal reportCessna 172S · Erie, COthe pilot's failure to maintain aircraft control resulting in a hard landing. Factors contributing to the accident were the pilot induced oscillation and the high approach airspeed.NTSB DEN04LA116Accident · No injuriesLimited investigationFinal reportMooney M20R · Aspen, COthe pilot's failure to maintain control of the airplane. Contributing factors was the pilot flaring the airplane too high, his misunderstanding of the instructor's attempt to take control of the airplane. and the instructor's inadequate supervision of the…NTSB DEN04CA092Accident · No injuriesData collectionFinal reportSchweizer 269C · Englewood, COthe settling with power situation encountered by the pilot. Contributing to the accident was the high density altitude.NTSB DEN04LA051Accident · No injuriesLimited investigationFinal reportShook Rans S-12 · Berthoud, COthe pilot's improper flare and his inadequate compensation for wind. The wind gust was a contributing factor.NTSB DEN04LA047Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Kremmling, COthe pilot's failure to attain landing flare and maintain adequate rotor rpm.NTSB DEN04LA010Accident · No injuriesLimited investigationFinal reportMooney M20K · Grand Junction, COthe pilot's improper flare and his failure to maintain airspeed resulting in a stall and hard landing.NTSB DEN02LA093Accident · No injuriesLimited investigationFinal reportCessna 310N · Grand Junction, COThe dual student's inadequate aircraft control resulting in a hard landing. Contributing factors include, the dual student's inadequate airspeed and high flare, the inadequate supervision by the instructor, the in-flight separation of the right main landing…NTSB DEN02LA088Accident · No injuriesLimited investigationFinal reportCessna 172S · Englewood, COthe instructor's inadequate supervision of the flight and his premature raising of the flaps, resulting in a hard landing.NTSB DEN02TA078Accident · No injuriesFinal reportCessna 182R · Englewood, COthe pilot-in-command's improper flare resulting in a hard landing. Contributing factors were the pilot's improper remedial action, and the second pilot's inadequate monitoring of the flight.NTSB DEN02LA060Accident · No injuriesLimited investigationFinal reportCessna 172M · Telluride, COthe pilot not maintaining proper aircraft control resulting in a hard landing. Factors contributing to this accident were the high airspeed, the porpoise encountered during the landing, and the pilot's delayed remedial action resulting in the damage to the…NTSB DEN02LA054Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glenwood Sprngs, COthe pilot's failure to maintain clearance from a tree while conducting an aborted landing. Contributing factors were the pilot’s low approach airspeed, and his failure to maintain directional control during landing roll.NTSB DEN02LA026Accident · No injuriesLimited investigationFinal reportBeech B36TC · Englewood, COThe pilot flaring the airplane prematurely, which resulted in a hard landing.NTSB DEN02LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Colo Springs, COthe pilot's inadequate landing flare, which resulted in a hard landing. A contributing factor was the pilot's excessive airspeed on final approach.NTSB DEN01LA158Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Colo. Springs, COthe passenger's failure to follow instructions given to brace for a high wind landing, and the pilot's failure to adequately monitor the passenger's actions. A contributing factor was the thermal lift.NTSB DEN01LA099Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Sterling, COfailure by the pilot to control descent rate during approach to land. A factor was a temperature inversion.NTSB DEN01LA032Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Aspen, COA hard landing which exceeded the design stress limits of the aircraft.NTSB DEN01LA031Accident · No injuriesLimited investigationFinal reportCessna R182 · Broomfield, COthe flight instructor's inadequate supervision of the dual student, which resulted in a hard landing. Contributing factors were the dual student flaring the airplane prematurely, resulting in an inadvertent stall/mush.NTSB DEN01LA023Accident · No injuriesLimited investigationFinal reportCessna 310N · Montrose, COthe pilot's inadequate airspeed on final approach which resulted in a hard landing. A contributing factor was wind shear.NTSB DEN00LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Erie, COInadequate supervision by the certified flight instructor. Factors were loss of control by the student pilot, the flight instructor's failure to properly monitor the student pilot's rate of descent on final approach, and the flight instructor's lack of recent…NTSB DEN00LA177Accident · No injuriesLimited investigationFinal reportCessna 340 · Broomfield, COThe pilot landing the aircraft hard exceeding the design stress limits. Factors were: Low ceiling, freezing rain, dark night, excessive descent rate, and improper glide path.NTSB DEN00LA172Accident · No injuriesLimited investigationFinal reportBoeing Stearman D75N1 · Englewood, COthe flight instructor not maintaining supervision. Contributing factors were the student's hard landing due to excessive flare and subsequent inadvertent stall, and the student's failure to maintain directional control during landing roll.NTSB DEN00LA138Accident · No injuriesLimited investigationFinal reportCessna 182P · Broomfield, COThe pilot's inaccurate recovery from a bounced landing. Factors were lack of total pilot experience and lack of pilot experience in aircraft make and model.NTSB DEN00LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COThe pilot prematurely flaring the airplane for landing, resulting in a hard landing, followed by an inadvertent pilot-induced porpoise and loss of directional control. A factor was the fence.NTSB DEN99LA143Accident · No injuriesLimited investigationFinal reportMoore Q-200 · Cortez, COThe pilot's improper recovery from a bounced landing and his failure to maintain directional control. Related factors were the soft wet terrain.NTSB DEN99LA108Accident · No injuriesLimited investigationFinal reportBeech B90 · Creede, COOverload failure of the right main landing gear scissors torque link precipitated by preexisting fatigue fractures. A factor was wind shear.NTSB DEN99LA106Accident · No injuriesLimited investigationFinal reportCessna 172N · Platteville, COThe pilot misjudging the flare altitude, resulting in a hard landing, and his subsequent loss of aircraft control. A factor was overload forces collapsing the nose landing gear assembly.NTSB DEN99LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Junction, COA hard landing when the pilot failed to sufficiently flare the aircraft for touch down. Factors were high-density altitude, and the pilot's lack of total flight experience.NTSB DEN99LA059Accident · Serious injuriesLimited investigationFinal reportCameron V-77 · Elbert, COThe pilot's failure to maintain a proper descent rate during touchdown, resulting in a hard landing. A factor was the passenger's failure to properly position herself for the landing.NTSB DEN99LA058Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Englewood, COThe flight instructor allowed the rotor rpm to decay during an autorotation which resulted in a hard landing.NTSB DEN99LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182RG · Glenwood Spring, COThe pilot's failure to maintain directional control. A contributing factor is his inadequate recovery from a bounced landing.NTSB FTW98LA348Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper remedial action after making a hard landing and porpoising. A factor was his lack of total experience.NTSB FTW98LA314Accident · No injuriesLimited investigationFinal reportCessna 172N · Broomfield, COThe pilot's improper landing flare which resulted in a hard landing.NTSB FTW98LA166Accident · No injuriesLimited investigationFinal reportCessna 172F · Fort Collins, COthe pilot's improper in flight planning/decision in electing to land with a known 30 knot tailwind. Factors were high winds and a tailwind.NTSB FTW97LA357Accident · No injuriesLimited investigationFinal reportMooney M20M · Broomfield, COThe pilot's flaring of the airplane prematurely at a low airspeed that resulted in a hard landing, and an inadvertent stall during the attempted go-around and subsequent loss of control.NTSB FTW97LA319Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Montrose, COfailure of the flight instructor (CFI) to properly supervise the flight and ensure that adequate rotor rpm was maintainted during the autorotation/landing. The high density altitude was a related factor.NTSB FTW97LA188Accident · No injuriesLimited investigationFinal reportAeromot AMT-200 · Longmont, COthe dual student pilot's improper landing flare and the flight instructor's inadequate supervision of the flight.NTSB FTW97LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Telluride, COThe pilot's misjudged landing flare and his improper bounced landing recovery technique. A factor was the snow bank.