NTSB investigations, CO
12 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1986 | 1 |
| 1989 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 2 |
| 1999 | 1 |
| 2001 | 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\" = 191)
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" = 191) 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 DEN01LA118Accident · No injuriesLimited investigationFinal reportBeech BE76 · Hudson, COmain landing gear collapse on touchdown for reasons undetermined.NTSB DEN99LA090Accident · No injuriesLimited investigationFinal reportBeech D95A · Englewood, COThe collapse of the right main landing gear during landing due to a fatigue crack, in the strut, which had an undetermined origin.NTSB FTW97LA368Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Englewood, COfailure of the right main landing gear due to multiple fatigue cracks.NTSB FTW97LA239Accident · No injuriesLimited investigationFinal reportCessna 210 · Peyton, COFailure of both pilots to assure the landing gear was down and locked.NTSB FTW94LA322Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Frederick, COA fatigue failure of the left main landing gear axle.NTSB DEN93FA049Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas DC-9-82 · Denver, COA vibration in the right main landing gear, for undetermined reasons, which resulted in collapse of the right main gear. A factor was failure of the pilot in command to ensure deployment of the ground spoilers.NTSB DEN89FA123Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas MD-80 · Denver, COA right main landing gear vibration of unknown origin, which resulted in a failure of the right main landing gear torque link and side brace.NTSB DEN89IA124Incident · No injuriesIncident investigationFinal reportBoeing 727-247 · Denver, COFailure of the left main landing gear forward trunnion bearing support fitting due to a crack initiating at the forward edge of the bore and propagating by intergranular stress corrosion into the bore surface that resulted in an eventual ductile fracture.NTSB DEN86FA256Accident · Serious injuriesField investigationFinal reportCessna 185C · Broomfield, COPlt stated that he made an 'extra smooth landing' on rwy 11L and during the landing roll the right main landing gear collapsed. Examination of landing gear mounting bolt revealed evidence of an overload failure. The engineer that examined the bolt, nut, and…NTSB DEN85LA012Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Creede, COAccording to the plt, just prior to landing, at about 5 ft AGL, the gear warning horn sounded and the right main gear down and locked light flickered. The landing was continued and the right gear collapsed during the rollout. A mechanic who examined the acft…NTSB DEN84LA129Accident · No injuriesLimited investigationFinal reportCessna 140 · Aurora, COAccording to the plt, the acft suddenly ground looped during the landing & departed the rwy. An investigation revealed that the left gear leg had collapsed at some time during the accident sequence. The left gear leg pin, which was found sheared, had a dark…NTSB DEN82DA178Accident · No injuriesFinal reportBeech 35 · Grand Junction, COThe pilot stated that before landing, he lowered the gear and checked the indicators which showed that the gear was extended. During the landing, the aircraft settled on the right wing. Despite the pilot's use of left aileron, left rudder and left brake, the…