NTSB investigations, CO
18 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1990 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 2005 | 1 |
| 2007 | 1 |
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\" = 390)
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" = 390) 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 DEN08CA023Accident · Minor injuriesData collectionFinal reportCessna TP206A · Boulder, COThe pilot's misjudgment of altitude. Contributing factors in this accident were the pilot's intentional low airspeed, his failure to execute a go-around, and the soft terrain.NTSB DEN05LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Rocky Ford, COthe pilot's misjudged distance/altitude. A contributing factor was the inadvertent flap retraction.NTSB FTW98LA323Accident · Serious injuriesLimited investigationFinal reportSchweizer SGU 2-22E · Canon City, COThe pilot's misjudgment of distance/altitude and his premature deployment of the spoilers, resulting in a undershoot and hard landing.NTSB FTW98LA312Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Watkins, COThe pilot misjudged his altitude. Contributing to the accident were unfavorable wind and dark night conditions.NTSB FTW96LA314Accident · No injuriesLimited investigationFinal reportBarton Sylkie 1 · Erie, COThe pilot passenger's failure to maintain clearance from the fence due to his failure to maintain a proper glide path, and the pilot-in-command's failure to take remedial action in a timely fashion.NTSB FTW96LA016Accident · No injuriesLimited investigationFinal reportCessna 182E · Fort Collins, COa fatigue failure of the right main landing gear. Factors were the pilot's failure to attain the proper touchdown point and his inadequate compensation for the crosswind conditions.NTSB FTW94LA313Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Byers, COFailure by the pilot to maintain a proper descent rate during approach to landing. A factor was lack of experience in make, model, and type of aircraft.NTSB DEN90LA194Accident · No injuriesLimited investigationFinal reportCessna 152 · Erie, COThe student pilot's misjudgement of distance and altitude, and the instructor's inadequate supervision.NTSB DEN88LA047Accident · No injuriesLimited investigationFinal reportCessna 182G · Aurora, CON3406S was landing on rwy 32, an asphalt rwy 5,000 ft long and 40 ft wide. The rwy was clear and dry, but the terrain surrounding the rwy was covered by 12 to 15 inches of snow. The wind at an arpt 5 mi sw was from 160 deg at 5 KTS. In his rpt of the acdt the…NTSB DEN86LA251Accident · No injuriesLimited investigationFinal reportCessna 172K · Monte Vista, COThe flt departed winslow, AZ, and was en route to erie, CO, when the accident occurred. The plt said he decided to divert to Monte Vista to 'take a break' and visit with his parents who lived nearby. The plt said the winds were light and variable with some…NTSB DEN86LA226Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Durango, COThe plt was attempting to land his glider. He said that he was unable to reach the airport and elected to land in a nearby pasture. Prior to touchdown he discovered some cattle in the field but was unable to avoid a collision with one of the animals. The…NTSB DEN84LA133Accident · No injuriesLimited investigationFinal reportCessna 150M · Boulder, CODuring final approach the acft encountered a downdraft & impacted the ground about 50 ft short of the rwy. The possibility of downdrafts at the approach end of rwy 26 was well known to local plts including the instructor plt (CFI).the CFI reported the wind…NTSB DEN83LA210Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Durango, COAfter releasing from an aerial tow about 2,000 ft AGL, the plt was unable to find lifting thermals. The glider began to descend about 800 fpm so the plt maneuvered to return to the airstrip. The glider collided with several small trees short of the rwy.NTSB DEN83LA069Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Erie, COThe plt stated he encountered an unexpected downdraft or shear effect & landed approximately 102 ft short of the rwy. The acft then collided with a bar ditch located about 63 ft from the threshold folding back the main gear. The acft then slid down the…NTSB DEN82DA134Accident · No injuriesFinal reportPiper PA-28RT-201 · Englewood, COWhile practicing power off approaches the pilot undershot the runway and landed short. Power was added but not soon enough to prevent an accident. The aircraft contacted the ground, turned 90 degrees, slid 50 yards and stopped.NTSB DEN82DA122Accident · No injuriesFinal reportCessna 340 · Las Animas, COThe aircraft collided with a four foot high irrigation ditch 50 feet from the approach end of runway 8 during short final. The pilot stated that he had planned the touch down point close to the end of the runway because the runway was only 3800 feet long.…NTSB DEN82DA064Accident · No injuriesFinal reportSchweizer SGS-2-33A · Colorado Spring, COThe student pilot reported that he came over the airport at about 1200 ft AGL to enter a downwind for landing. He stated that he encountered a moderate to strong sink and strong southerly winds. He estimated that the wind velocity was 45 to 50 mph at 1000 ft…NTSB DEN82DA042Accident · No injuriesFinal reportBeech A36TC · Boulder, COThe pilot reported that during a normal approach, he encountered a severe downdraft in winds gusting about 40 to 60 knots. He started to abort the landing by raising the gear and applying full power. The pilot stated that he turned right to avoid a hill, but…