NTSB investigations, CO
20 cases where the sequence of events included Landing gear not configured.
Cases per year
| 2009 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 3 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 3 |
| 2019 | 2 |
| 2021 | 1 |
| 2023 | 4 |
| 2024 | 1 |
| 2026 | 2 |
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '095' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ANC26LA060Accident · No injuriesClass 4 · LimitedInvestigation openBeech E33 · Steamboat Springs, CONTSB CEN26LA166Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Colorado Springs, COMaintenance personnel's installation of an oversized tire, which prevented the left main landing gear from extending resulting in a precautionary gear up landing.NTSB CEN24LA375Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14 19 · Cortez, COThe pilot’s failure to extend the landing gear before landing.NTSB CEN24LA018Accident · No injuriesClass 3 · LimitedFinal reportCessna 210B · Pueblo, COThe fatigue failure of the right main landing gear hydraulic actuator, which resulted in a loss of hydraulic fluid that prevented the pilot from lowering the landing gear to the fully extended position.NTSB CEN23LA407Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Greeley, COThe pilot’s failure to extend the landing gear. Contributing to the accident was a malfunction of the landing gear warning horn for undetermined reasons.NTSB CEN23LA274Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Durango, COThe pilot’s failure to extend the landing gear before landing.NTSB CEN23LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Watkins, COThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize the prelanding checklist to ensure the landing gear was extended before landing.NTSB CEN21LA248Accident · No injuriesClass 3 · LimitedFinal reportBeech 1900 · Denver, COThe pilot’s failure to properly configure the airplane for landing, which resulted in a gear-up landing.NTSB GAA20CA084Accident · No injuriesData collectionFinal reportBeech 55 · Broomfield, COThe pilot's unintentional retraction of the landing gear during the landing roll.NTSB CEN19LA313Accident · No injuriesClass 3 · LimitedFinal reportJackson Velocity · Mack, COA propeller overspeed due to failure of the electronic ignition timing ring attachment screws, and a runway overrun during the subsequent forced landing.NTSB GAA17CA221Accident · No injuriesData collectionFinal reportCessna P210 · Granby, COThe pilot's failure to extend the landing gear before landing.NTSB GAA17CA197Accident · No injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot’s failure to complete the landing checklist and to extend the landing gear before touchdown.NTSB CEN17LA091Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Delta, COThe failure of the landing gear to extend during landing approach due to the interference between the landing gear motor's sector and worm gears.NTSB CEN15IA014Incident · No injuriesIncident investigationFinal reportRaytheon Hawker · Denver, COThe failure of the main landing gear tire, which resulted in separation of the servo block and subsequent total loss of all hydraulic system pressure and prevented the landing gear from extending before landing.NTSB CEN13LA488Accident · No injuriesLimited investigationFinal reportGriffith E/Boyd W E Lancair 360 · Nucla, COThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB CEN12LA473Accident · No injuriesLimited investigationFinal reportCessna TR182 · Steamboat Springs, COThe pilot's failure to extend the landing gear before landing.NTSB CEN12LA389Accident · No injuriesLimited investigationFinal reportHoyle Fighter Escort Wings · Pueblo, COAn internal failure of one of the electrical system’s two batteries combined with the inadequate electrical system design, which resulted in a total loss of engine power.NTSB CEN12CA157Accident · Minor injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot did not extend the landing gear before landing.NTSB CEN10LA524Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Greeley, COA loss of engine power for undetermined reasons.NTSB CEN09CA343Accident · No injuriesData collectionFinal reportCessna 404 · Englewood, COThe failure of the landing gear to extend due to the failure of a hydraulic line.