NTSB investigations, CO
32 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 2 |
| 1985 | 2 |
| 1986 | 4 |
| 1987 | 1 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 3 |
| 2002 | 1 |
| 2004 | 3 |
| 2006 | 2 |
| 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\" = 320)
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" = 320) 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 DEN07CA057Accident · No injuriesData collectionFinal reportSmith, Ted Aerostar 601P · Craig, COThe pilot's improper in-flight planning and unsuitable area selected for landing. A contributing factor was the snow covered terrain and runway.NTSB DEN07CA007Accident · Minor injuriesData collectionFinal reportHuff Acro Sport I · Delta, COthe pilot's failure to select a touchdown point a safe distance from the construction crew, and his failure to maintain directional control of the airplane. Contributing factors in this accident included the pilot's limited forward visibility when the…NTSB DEN06IA051Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-82 · Denver, COthe captain's failure to follow existing company procedures for stabilized approach. **This report was modified on May 23, 2007.**NTSB DEN05LA022Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Pueblo, COThe pilot’s inadequate compensation for wind and his failure to maintain aircraft control which resulted in a gear collapse due to an on-ground collision with terrain. Contributing factors were the wind shear, gusty wind conditions, and rough terrain. This…NTSB DEN04CA100Accident · No injuriesData collectionFinal reportAeronca 7AC · Limon, COthe pilot's inadequate preflight planning/preparation. A contributing factor was the soft terrain in the takeoff area.NTSB DEN04LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glade Park, COthe pilot's inadequate in-flight planning/decision. Contributing factors include the pilot's selection of unsuitable terrain for landing and the snow covered terrain.NTSB DEN02LA099Accident · No injuriesLimited investigationFinal reportHildebrandt Rutan/Defiant · Erie, COfailure of the normal braking system, resulting in the airplane departing the end of the runway. A contributing factor was the airplane's slow acceleration during the takeoff roll.NTSB DEN99LA027Accident · No injuriesLimited investigationFinal reportBoeing 727-233 · Denver, COSnow removal not done by other person.NTSB FTW98LA360Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Boulder, COThe pilot's intentional ground loop and his inadequate compensation for the wind condition. A contributng factor was crosswinds.NTSB FTW98LA222Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Watkins, COThe pilot's failure to maintain visual contact with the taxiway. Factors were the pilot's disabling the electrical system by turning off the master switch, a dark night, and excessive taxi speed.NTSB FTW96LA084Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe pilot's improper in-flight decision to continue with the landing when the runway had not been positively identified. Factors were the snow-covered runway and landing area, sun glare, and the inadequate snow removal by airport personnel.NTSB FTW95LA389Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Salida, COFailure by the pilot to adequately plan the flight and the aircraft altitude capability. Factors are: high altitude, high density altitude, inadequate training in mountain flying, and lack of familiarity with the geographic area.NTSB FTW95LA378Accident · No injuriesLimited investigationFinal reportMaule M5-210C · Westcliffe, COFailure by the pilot to maintain directional control of the aircraft during taxi. A factor was lack of experience in make and model aircraft.NTSB FTW95LA024Accident · No injuriesLimited investigationFinal reportMooney M20C · Greeley, COInadvertent landing gear retraction by the pilot flying the aircraft. A factor was inadequate supervision by the flight instructor.NTSB DEN93LA022Accident · No injuriesLimited investigationFinal reportCessna T210L · Monte Vista, COA loss of control during landing when the aircraft struck a snowbank which was left on the runway as a result of inadequate plowing.NTSB DEN92LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Craig, COThe pilot's failure to maintain directional control.NTSB DEN91LA109Accident · No injuriesLimited investigationFinal reportBeech V35 · Byers, COThe pilot's selection of an unsuitable landing site. Factors were: weather conditions and the ditch.NTSB DEN91LA009Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Watkins, COThe pilot's inadvertent retraction of the landing gear. A factor was the pilot's lack of familiarity with the airplane.NTSB DEN90LA150Accident · No injuriesLimited investigationFinal reportCessna T 188C · Wray, COThe failure of the pilot to maintain proper alignment proper alignment during landing.NTSB DEN89LA133Accident · No injuriesLimited investigationFinal reportCessna 182RG · Englewood, COFailure of the pilot to follow warnings provided by a NOTAM & flags on the taxiway. Factors related to the accident were: darkness and the ditch.NTSB DEN89LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Longmont, COFailure of the student pilot to maintain proper runway alignment during the landing roll. Factors related to the accident were: snow on the edges of the runway, the student's lack of total experience, and the snowbank.NTSB DEN88LA019Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe recently certificated private plt was taxiing his acft to rwy 9 for a night takeoff. Another acft began its takeoff roll on rwy 9. As a courtesy, the taxiing plt switched off his taxi light so as not to blind the other plt. The taxiing plt used the glow…NTSB DEN87LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, CODuring landing, directional control was not maintained. The acft veered left, the landing gear entered a snowbank, and the acft nosed over.NTSB DEN86LA220Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Center, COThe plt reported that he was landing on a 50 ft wide dirt strip and allowed the acft to drift to the left during the landing roll. The left wing collided with wheat growing along the left side of the strip and the acft swerved further to the left. During the…NTSB DEN86LA185Accident · Minor injuriesLimited investigationFinal reportCessna 182P · New Castle, COPlt attempted to abort landing while on short final with 40 degrees of flaps. Plt decided that he would not clear trees at the FAR end of meadow so he executed a precautionary landing during which the acft struck a ditch and nosed over. The density altitude…NTSB DEN86FA080Accident · No injuriesField investigationFinal reportBoeing 737-300 · Denver, COF/o was on the 3rd initial operating experience flt with a check airman. Capt and f/o had discussed rapid rate of rotation on previous flts and again on accident flt. The f/o performed the takeoff from Denver and exceeded rotation rate of 3 degrees per sec.…NTSB DEN86LA051Accident · No injuriesLimited investigationFinal reportCessna 172N · Longmont, COAccording to the student plt he made a normal apch to landing. The runway had not been cleared of snow to its full width. The acft's left wheel touched the snow pulling the acft off the rwy and the acft flipped over.NTSB DEN86LA027Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ft. Collins, COThe acft collided with large chunks of snow on the rwy during takeoff roll. The plt stated that during the roll about mid-way down the rwy he spotted the snow and decided to abort but was unable to avoid the snow. The left gear contacted the snow and the acft…NTSB DEN84LA056Accident · No injuriesLimited investigationFinal reportCessna 180 · Florissant, COThe acft collided with a snowbank during landing. The rwy had only been plowed to a width of about 16 ft according to the plt. This was a privately owned strip and the plt/owner said he instructed his maintenance man/ranch mgr to plow therwy to minimum width.…NTSB DEN83LA085Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, COThe aircraft collided with a snowbank during landing. The pilot stated that he had contacted flt service and asked aboutthe runway conditions. Nothing was reported and no NOTAMS were posted. Upon arrival the pilot tried to contact UNICOM atcolumbine. Someone…NTSB DEN82DA188Accident · Serious injuriesFinal reportPiper PA-24-180 · Pueblo, COThe aircraft landed at rueblo, CO for fuel on a return flight to Texas. After landing, the pilot asked a female attendant if there were any liquor stores open. The pilot returned to the airport about 1/2 hour later and observed the pilot carrying a brown…NTSB DEN82DA137Accident · No injuriesFinal reportPiper PA-28R · Near Almosa, COThe pilot stated that during flight, his oil temperature began to rise and he elected to land on an abandoned air strip. During the landing, the aircraft encountered rough, uneven terrain, and subsequently, the landing gear and right wing were damaged. An…