OpenAirDocs.org

NTSB investigations, CO

9 cases where the first occurrence was “Gear not extended”.

Cases per year

19872026

Where

Open the map

Latest 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\" = 196)
  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.

NTSB FTW95LA051Accident · No injuriesLimited investigationFinal reportCessna P210N · Alamosa, COFailure by the pilot to properly judge the touch down point. Factors were: failure of the nose landing gear to extend and rough and uneven terrain.Nov 17, 1994 · N731QH · Substantial damageNTSB FTW94LA029Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COFailure by the pilot in command to follow procedures and directives to lower the landing gear prior to landing.Oct 22, 1993 · N9653T · Substantial damageNTSB DEN92LA030Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Monte Vista, COOperation of the aircraft with known deficiencies in equipment by the pilot in command, and jammed landing gear extension mechanisms due to corrosion.Feb 6, 1992 · N1509 · Substantial damageNTSB DEN92LA015Accident · No injuriesLimited investigationFinal reportBeech V35 · Erie, COAn inadvertent gear up landing when the pilot in command and designated examiner failed to use proper procedures. A factor was: failure of the landing gear extension/retraction motor.Dec 10, 1991 · N9449S · Substantial damageNTSB DEN92LA012Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Denver, COA false unsafe landing gear indication due to a frozen down lock switch. Factors were: icing conditions and low ceilings.Nov 29, 1991 · N354AC · Substantial damageNTSB DEN90LA148Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Broomfield, COThe failure of the pilot to extend the landing gear for landing. Contributing factors were the pilot diverting his attention from the task at hand and failure to use a checklist.Jun 29, 1990 · N6391P · Substantial damageNTSB DEN89LA220Accident · No injuriesLimited investigationFinal reportCessna 182RG · Englewood, COThe pilot failed to extend the landing gear. The pilot's anxiety and/or apprehension about a suspected loss of electrical power, and his attention being diverted by other traffic were contributing factors.Sep 17, 1989 · N7346X · Substantial damageNTSB DEN89LA043Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Peyton, COThe student plt was practicing a touch and go landing. During a turn to final, the plt heard an acft report final for a straight in. He said he became distracted and failed to extend the landing gear. The acft landed with the gear up and slid 500 feet, coming…Dec 18, 1988 · N6843P · Substantial damageNTSB DEN88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe private pilot was flying to build time. After an hour of flight, the plt returned to the home airport and attempted to land. Landing gear would not extend properly and manual gear extension did not help. All gear was partially extended and would not…Nov 23, 1987 · N7291P · Substantial damage