NTSB investigations, NM
24 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 3 |
| 2011 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 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\" = 'NM' 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\" = '094' 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" = 'NM' 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" = '094' 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 WPR26LA343Accident · No injuriesClass 4 · LimitedFinal reportAerovodochody L-29 Delfin · Roswell, NMThe malfunction of a diode in the airplanes electrical system that resulted in low batter power and subsequent landing gear collapse.NTSB WPR26LA334Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 200 · Roswell, NMOn September 8, 2026, about 0044 mountain daylight time, N393JW, a Beech 200, was substantially damaged when it was involved in an accident near Roswell, New Mexico. The two pilots and two of the medical crew members were not injured, a third medical crew…NTSB WPR24LA128Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4-Place · Buckhorn, NMThe pilot’s inflight loss of control during landing following an encounter with a wind gust which resulted in a hard landing.NTSB WPR23LA230Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6A · Mimbres, NMThe pilot’s inflight loss of control while landing with wind gusts that resulted in a hard landing and subsequent nose over.NTSB WPR21LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Albuquerque, NMThe failure of the nose gear hydraulic flex line, which resulted in a loss of hydraulic fluid which prevented the main landing gear from fully extending and locking into place during landing.NTSB WPR20CA185Accident · No injuriesClass 4 · Data collectionFinal reportVans RV 6 · Clovis, NMThe pilot's improper landing flare which resulted in a hard, bounced landing, and subsequent runway excursion. Contributing to the accident was the airplane’s aft center of gravity at the time of the accident.NTSB GAA19CA496Accident · No injuriesData collectionFinal reportCessna TU206 · Regina, NMThe pilot's improper preflight performance planning for a high-density altitude takeoff from a short, dirt airstrip, which resulted in impact with terrain.NTSB WPR19LA153Accident · No injuriesClass 3 · LimitedFinal reportCessna 195 · Socorro, NMThe pilot's failure to maintain airplane control while landing with a quartering tailwind.NTSB GAA18CA493Accident · Minor injuriesData collectionFinal reportCessna 172 · Silver City, NMThe pilot’s failure to maintain directional control while landing with a quartering tailwind.NTSB GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA16CA412Accident · No injuriesData collectionFinal reportCessna 120 · Belen, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a ground loop.NTSB CEN16LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180D · Shiprock, NMThe pilot's failure to maintain directional control after encountering a sudden change in wind direction during the landing roll.NTSB GAA16CA017Accident · No injuriesData collectionFinal reportCessna 195A · Aztec, NMThe pilot's failure to maintain directional control during landing, which resulted in runway excursion and collision with terrain.NTSB CEN14CA386Accident · No injuriesData collectionFinal reportBlack Christopher Sparrow Sport Spec · Moriarty, NMThe pilot's loss of directional control while landing in gusty crosswind conditions. Contributing to the accident was the pilot's operation of the engine above its normal temperature limit on takeoff.NTSB CEN14LA107Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Silver City, NMThe collapse of the landing gear during landing for reasons that could not be determined during postaccident examinations.NTSB CEN11LA173Accident · No injuriesLimited investigationFinal reportCessna 402 · Albuquerque, NMThe failure of the landing gear system for undetermined reasons.NTSB CEN11CA137Accident · No injuriesData collectionFinal reportBellanca 1419 · Clovis, NMThe pilot's failure to maintain directional control of the airplane during landing.NTSB CEN09LA417Accident · No injuriesLimited investigationFinal reportCessna T210L · Santa Teresa, NMThe failure of the landing gear accumulator seal for undetermined reasons. Contributing to the accident was the pilot’s failure to confirm the status of the landing gear.NTSB CEN09CA301Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Las Cruces, NMThe pilot's failure to maintain directional control while landing in a crosswind. Contributing to the accident was the pilot's decision to land on a runway with a prevailing crosswind.NTSB CEN09LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMCollapse of the landing gear during landing due to the incorrect installation of the landing gear actuator. Contributing to the accident was the pilot's failure to initiate the abnormal procedures checklist prior to landing.NTSB DEN08CA136Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Dexter, NMThe pilot's failure to maintain directional control of the airplane.NTSB DFW08CA160Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Amistad, NMFuel starvation while in cruise flight. Contributing to the accident were incorrect maintenance, the fuel selector movement was impeded and a plowed field.NTSB DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.NTSB DFW08CA099Accident · No injuriesData collectionFinal reportCessna 310Q · Roswell, NMThe airframe and powerplant mechanic's incorrect reassembly of the landing gear.