NTSB investigations, NM
13 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 2 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1997 | 3 |
| 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\" = 'NM' 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" = 'NM' 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 DEN07LA156Accident · No injuriesLimited investigationFinal reportCessna 402B · Hobbs, NMThe failure of the left main landing gear down lock due to overload causing the main landing gear to collapse.NTSB FTW97LA334Accident · No injuriesLimited investigationFinal reportBeech E90 · Albuquerque, NMFatigue failure of the right main landing gear retraction/extension torque tube.NTSB FTW97FA255Accident · Minor injuriesField investigationFinal reportBoeing 727-247 · Albuquerque, NMThe inadequate inspection of the right main landing gear forward trunnion bearing support fitting. Factors were the failure of the right main landing gear forward trunnion bearing support fitting and the subsequent right main landing gear failure.NTSB FTW97LA076Accident · No injuriesLimited investigationFinal reportCessna 140A · Albuquerque, NMThe fracture of the right main landing gear for an undetermined reason.NTSB FTW92LA027Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Fe, NMThe right main gear collapsed for undetermined reasons, which resulted in the pilot's loss of directional control during the landing roll.NTSB DEN89LA138Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Las Cruces, NMFailure of the left main landing gear trunnion. A contributing factor was: inadequate inspection procedure in Piper service bulletin #787A.NTSB DEN88LA039Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Las Cruces, NMWhile practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.…NTSB DEN87IA031Incident · No injuriesIncident investigationFinal reportBeech C-99 · Albuquerque, NMMesa airline flt 114 was on a scheduled flt from Albuquerque to clovis, NM. Upon touchdown at clovis, the left landing gear began to collapse and a go-around was successful. The crew elected to return to Albuquerque where emerg equipment could stand by. After…NTSB DEN85LA157Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Albuquerque, NMThe plt reported that during a normal landing, the right main gear folded back, followed by collapse of the left main gear. An exam revealed evidence of fatigue failure of a clevis bolt in the threaded area.NTSB DEN84LA190Accident · No injuriesLimited investigationFinal reportCessna 180 · Gallup, NMDuring the landing roll, the right gear collapsed & the acft veered off the rwy. An exam revealed that the right wheel ass'y had separated from the gear leg. There was evidence that the 2 lower bolts had been stripped prior to the wheel failure, either by…NTSB DEN84LA128Accident · No injuriesLimited investigationFinal reportCessna 421C · Farmington, NMWhile taxiing after landing, the acft was in a left turn when the right main gear collapsed. The plt reported that all 3 gear indicated down & lock, both before & after the mishap. An exam of the right main gear actuator, pn 9910136-4, revealed that…NTSB FTW82DA243Accident · No injuriesFinal reportPiper PA-32-300 · Grants, NMThe pilot stated that he was very tired and fell asleep while descending to 7500 ft MSL in the vicinity of Grants, NM. Reportedly, the next thing he remembered was the aircraft contacting the ground, bouncing, and then coming to a stop. An examination of the…NTSB FTW82DA056Accident · No injuriesFinal reportCessna 177RG · Artesia, NMWhile taxiing, the aircraft was lifted up on its right main gear by a gust of wind. When the aircraft settled back down, the left main inboard castering bolt sheared and the left main gear collapsed. The wind was gustng to 20 knots.