# NTSB investigations, NM: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 6 · 297 cases

## Latest cases

- [NTSB WPR27LA004](https://openairdocs.org/ntsb/WPR27LA004.md): Head Balloons AX8-88B · Albuquerque, NM · Accident · No injuries · Class 4 · Limited · Investigation open · Oct 3, 2026 · N4502A · Substantial damage
- [NTSB WPR26LA214](https://openairdocs.org/ntsb/WPR26LA214.md): Mooney M20J · Albuquerque, NM · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 31, 2026 · N555ED · Substantial damage
  > On May 31, 2026, at 1515 mountain daylight time, a Mooney M20J, N555ED, sustained substantial damage when it was involved in an accident near Albuquerque, New Mexico. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR26FA186](https://openairdocs.org/ntsb/WPR26FA186.md): Beech C90 · Lincoln, NM · Accident · 4 fatal · Class 3 · Field · Preliminary report · May 14, 2026 · N249CP · Destroyed
  > On May 14, 2026, at 0015 mountain daylight time, a Beech C90, N249CP, was destroyed when it was involved in an accident near Lincoln, New Mexico. Both pilots and passengers sustained fatal injuries. The airplane was operated by Generation Jets under the…
- [NTSB WPR26FA120](https://openairdocs.org/ntsb/WPR26FA120.md): Columbia Aircraft Mfg LC41-550FG · Albuquerque, NM · Accident · 2 fatal · Class 3 · Field · Preliminary report · Mar 6, 2026 · N2516S · Substantial damage
  > On March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from…
- [NTSB WPR25FA279](https://openairdocs.org/ntsb/WPR25FA279.md): Bellanca 17-30A · Moriarty, NM · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 16, 2025 · N432DM · Substantial damage
  > On September 16, 2025, about 1132 mountain daylight time, a Bellanca 17-30A, N432DM, was substantially damaged when it was involved in an accident near Moriarty, New Mexico. The pilot receiving instruction was fatally injured and the flight instructor…
- [NTSB WPR25LA071](https://openairdocs.org/ntsb/WPR25LA071.md): Cessna T210L · Gallup, NM · Accident · No injuries · Class 3 · Limited · Final report · Dec 28, 2024 · N505SW · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power.
- [NTSB WPR24LA153](https://openairdocs.org/ntsb/WPR24LA153.md): Stemme S10-VT · Moriarty, NM · Accident · No injuries · Class 4 · Limited · Final report · May 15, 2024 · N995J · Substantial damage
  > The pilot’s unstabilized approach, which resulted in a runway excursion and impact with terrain.
- [NTSB WPR23LA002](https://openairdocs.org/ntsb/WPR23LA002.md): Piper PA 46-350P · Clovis, NM · Accident · No injuries · Class 3 · Limited · Final report · Oct 2, 2022 · N987PS · Substantial damage
  > The pilot’s failure to follow the go-around procedures by prematurely retracting the flaps and not establishing a proper go-around climb speed after attempting to land with a quartering tailwind, resulting in the airplane’s inability to climb.
- [NTSB WPR22LA041](https://openairdocs.org/ntsb/WPR22LA041.md): Piper PA-28-180 · Farmington, NM · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 17, 2021 · N9467J · Substantial damage
  > The pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR21FA242](https://openairdocs.org/ntsb/WPR21FA242.md): Cameron Balloons US O-120 · Albuquerque, NM · Accident · 5 fatal · Class 3 · Field · Final report · Jun 26, 2021 · N158NM · Destroyed
  > The failure of the pilot to maintain adequate clearance from power lines while maneuvering for landing. Contributing to the accident was the pilot’s use of impairing, illicit drugs.
- [NTSB WPR21LA027](https://openairdocs.org/ntsb/WPR21LA027.md): American Eurocopter AS350B3 · Silver City, NM · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 27, 2020 · N530H · Substantial damage
  > The pilot’s failure to maintain sufficient altitude above terrain while operating in reduced visibility due to snow showers.
- [NTSB CEN19CA017](https://openairdocs.org/ntsb/CEN19CA017.md): Piper PA28R · Hobbs, NM · Accident · No injuries · Data collection · Final report · Oct 28, 2018 · N6899C · Substantial damage
  > The pilot's incorrect altimeter setting during the night visual approach, which resulted in a controlled flight into terrain.
- [NTSB WPR19TA005](https://openairdocs.org/ntsb/WPR19TA005.md): Balloon Works Firefly 7 · Placitas, NM · Accident · Serious injuries · Final report · Oct 10, 2018 · N7252H · No damage
  > The pilot’s failure to properly estimate the height of terrain while descending the balloon, which resulted in the balloon impacting a hill and passengers sustaining serious injuries.
- [NTSB CEN18LA218](https://openairdocs.org/ntsb/CEN18LA218.md): Aerovodochody L 29 Delfin · Moriarty, NM · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 2018 · N4323N · Substantial damage
  > The pilot’s failure to maintain a proper glidepath during a visual approach and the flight instructor’s delayed remedial action, which resulted in ground impact before the runway.
- [NTSB CEN18LA117](https://openairdocs.org/ntsb/CEN18LA117.md): Black Donald Cozy III · Los Lunas, NM · Accident · No injuries · Limited investigation · Final report · Feb 17, 2018 · N904DB · Substantial damage
  > The seizure of the propeller gearbox for reasons that could not be determined based on the available information, which resulted in a forced landing.
- [NTSB CEN17LA359](https://openairdocs.org/ntsb/CEN17LA359.md): Cirrus Design SR22T · Raton, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 2017 · N702N · Substantial damage
  > The pilot's failure to maintain a proper descent rate, which resulted in a bounced landing, and his subsequent failure to attain a proper airspeed during an attempted go-around in shifting wind conditions, which resulted in an aerodynamic stall.
- [NTSB CEN17LA118](https://openairdocs.org/ntsb/CEN17LA118.md): Thunder & Colt Airborne Amer AX10 180 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Feb 20, 2017 · N709TC · Substantial damage
  > The pilot’s delayed reaction to the balloon’s increased rate of descent during an attempted landing, which resulted in impact with a power line.
- [NTSB GAA17CA095](https://openairdocs.org/ntsb/GAA17CA095.md): Robinson Helicopter R44 · Separ, NM · Accident · No injuries · Data collection · Final report · Dec 15, 2016 · N835AK · Substantial damage
  > The pilot’s abrupt maneuver to avoid electrical wires during the approach, which resulted in a hard landing.
- [NTSB CEN16FA122](https://openairdocs.org/ntsb/CEN16FA122.md): Remos Acft Gmbh Flugzeugbau Remos GX · Española, NM · Accident · 2 fatal · Field investigation · Final report · Mar 11, 2016 · N28GX · Destroyed
  > The pilot's failure to maintain adequate airspeed while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low altitude.
- [NTSB CEN15LA436](https://openairdocs.org/ntsb/CEN15LA436.md): Beech C35 · Belen, NM · Accident · No injuries · Limited investigation · Final report · Sep 26, 2015 · N1990D · Substantial damage
  > The total loss of engine power due to contamination in the fuel system.
- [NTSB CEN15LA354](https://openairdocs.org/ntsb/CEN15LA354.md): Cessna C421B · Clovis, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2015 · N726JB · Substantial damage
  > The pilot's improper management of fuel to the left engine during approach for landing, which resulted in a total loss of left engine power due to fuel starvation, and his subsequent failure to maintain control during the final landing approach, which…
- [NTSB CEN15FA325](https://openairdocs.org/ntsb/CEN15FA325.md): Piper PA-28-151 · Truth or Consequences, NM · Accident · 2 fatal · Field investigation · Final report · Jul 24, 2015 · N32401 · Substantial damage
  > The student pilot's improper decision to conduct a flight in dark night conditions without a solo night flight endorsement and his subsequent loss of airplane control.
- [NTSB GAA15CA133](https://openairdocs.org/ntsb/GAA15CA133.md): Schempp-Hirth Ventus 2C · Hobbs, NM · Accident · No injuries · Data collection · Final report · Jun 23, 2015 · N172VC · Substantial damage
  > The pilot's improper compensation for gusty wind conditions which resulted in impact with terrain short of the runway.
- [NTSB CEN15LA091](https://openairdocs.org/ntsb/CEN15LA091.md): Cessna 208B · Roswell, NM · Accident · No injuries · Limited investigation · Final report · Dec 30, 2014 · N950FE · Substantial damage
  > The pilot's failure to maintain adequate airspeed to compensate for icing on the airplane's wings and control surfaces during a circling approach, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB CEN14LA520](https://openairdocs.org/ntsb/CEN14LA520.md): Robinson Helicopter R22 Beta · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 2014 · N7026J · Substantial damage
  > The pilot's failure to maintain main rotor rpm during a pinnacle approach, which resulted in a loss of helicopter control and collision with terrain. Contributing to the accident was the pilot's decision to attempt the approach given the helicopter's weight…
- [NTSB CEN14LA471](https://openairdocs.org/ntsb/CEN14LA471.md): Boring Robert Burton RV6A · Las Cruces, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2014 · N613LE · Substantial damage
  > The pilot’s failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle-of-attack and experiencing a stall/spin.
- [NTSB CEN14LA397](https://openairdocs.org/ntsb/CEN14LA397.md): Cameron Balloons US A-180 · Questa, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 2014 · N65059 · No damage
  > The hard landing after both burner pilot lights extinguished during the landing approach. Contributing to the accident was the pilot's inability to relight the burner pilot lights.
- [NTSB CEN14LA345](https://openairdocs.org/ntsb/CEN14LA345.md): Cessna 210L · Las Vegas, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 2014 · N1175Q · Substantial damage
  > The pilot's loss of airplane control during an aborted landing. Contributing to the accident was the pilot's inadequate preflight planning, which resulted in his attempt to land on a runway closed by a notice to airmen and the loss of engine power due to fuel…
- [NTSB CEN14LA326](https://openairdocs.org/ntsb/CEN14LA326.md): Aerospatiale AS350B · Mayhill, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2014 · N69PJ · Substantial damage
  > The pilot's failure to maintain helicopter control while performing a go-around in strong, gusting wind conditions. Contributing to the accident was the pilot's decision to initiate the flight in strong, gusting wind conditions.
- [NTSB CEN14LA007](https://openairdocs.org/ntsb/CEN14LA007.md): Cameron Balloons US V 77 · Rio Rancho, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 2013 · N9528A · Substantial damage
  > The pilot's failure to maintain adequate clearance from power lines on approach to land, resulting in a collision with the wires, a spark, and a subsequent explosion and on-board fire.
- [NTSB CEN13LA571](https://openairdocs.org/ntsb/CEN13LA571.md): Cessna 182J · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Sep 29, 2013 · N3078F · Substantial damage
  > A loss of engine power for reasons that could not be determined because no anomalies were found during the postaccident engine examination.
- [NTSB CEN13CA494](https://openairdocs.org/ntsb/CEN13CA494.md): Globe GC-1B · Santa Teresa, NM · Accident · No injuries · Data collection · Final report · Aug 18, 2013 · N7BR · Substantial damage
  > The pilot's loss of directional control during the final approach due to an inadvertent encounter with a dust devil
- [NTSB CEN13LA409](https://openairdocs.org/ntsb/CEN13LA409.md): Flight Design Ctsw · Taos, NM · Accident · 1 fatal · Limited investigation · Final report · Jul 10, 2013 · N424CT · Substantial damage
  > The airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.
- [NTSB CEN10CA507](https://openairdocs.org/ntsb/CEN10CA507.md): Let L-23 Super Blanik · Socorro, NM · Accident · No injuries · Data collection · Final report · Aug 28, 2010 · N361BA · Substantial damage
  > A loss of lift that resulted in an off-airport landing.
- [NTSB CEN10FA324](https://openairdocs.org/ntsb/CEN10FA324.md): Cessna T310R · Ruidoso, NM · Accident · 5 fatal · Field investigation · Final report · Jun 17, 2010 · N310RH · Substantial damage
  > The pilot did not maintain proper airspeed on final approach for landing, which resulted in an aerodynamic stall and impact with terrain. Contributing to the accident was the pilot’s limited experience in the airplane make and model.
- [NTSB CEN10LA166](https://openairdocs.org/ntsb/CEN10LA166.md): Cessna 421B · Artesia, NM · Accident · No injuries · Limited investigation · Final report · Mar 18, 2010 · N3382Q · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.
- [NTSB CEN09CA480](https://openairdocs.org/ntsb/CEN09CA480.md): Boring Robert Burton RV6A · Demming, NM · Accident · No injuries · Data collection · Final report · Jul 31, 2009 · N613LE · Substantial damage
  > The loss of engine power due to fuel starvation as a result of the pilot's failure to manage and monitor fuel usage.
- [NTSB CEN09LA415](https://openairdocs.org/ntsb/CEN09LA415.md): Cessna 441 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Jul 3, 2009 · N988AE · Substantial damage
  > A malfunction of the landing gear selector switch and a loose fitting on the emergency extension system which rendered the landing gear system inoperable.
- [NTSB CEN09LA417](https://openairdocs.org/ntsb/CEN09LA417.md): Cessna T210L · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Jul 1, 2009 · N2118S · Substantial damage
  > The 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 CEN09CA223](https://openairdocs.org/ntsb/CEN09CA223.md): Beech D35 · Taos, NM · Accident · No injuries · Data collection · Final report · Mar 16, 2009 · N342R · Substantial damage
  > The failure of the student pilot to complete the before landing checklist. Contributing to the accident was his failure to lower the landing gear before landing.
- [NTSB CEN09LA137](https://openairdocs.org/ntsb/CEN09LA137.md): Beech A36 · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Jan 18, 2009 · N8074P · Substantial damage
  > Collapse 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 CEN09CA118](https://openairdocs.org/ntsb/CEN09CA118.md): Socata TBM 700 · Clovis, NM · Accident · No injuries · Data collection · Final report · Dec 23, 2008 · N70LR · Substantial damage
  > The pilot's failure to complete the before-landing checklist, which led to his failure to lower the gear before landing.
- [NTSB DEN08FA162](https://openairdocs.org/ntsb/DEN08FA162.md): Pilatus PC-12/47E · Santa Fe, NM · Accident · 1 fatal · Field investigation · Final report · Sep 30, 2008 · N606SL · Destroyed
  > The pilot's incapacitation due to fatigue resulting in an in-flight collision with terrain.
- [NTSB DEN08LA145](https://openairdocs.org/ntsb/DEN08LA145.md): Cessna 340A · Angle Fire, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2008 · N397RA · Destroyed
  > Controlled flight into terrain for unknown reasons.
- [NTSB DFW08LA217](https://openairdocs.org/ntsb/DFW08LA217.md): Cessna 172A · Albuquerque, NM · Accident · Limited investigation · Final report · Aug 28, 2008 · N6539B · Substantial damage
  > The pilot's failure to maintain proper glide angle during the landing approach which resulted in a collision with a pole. Contributing to the accident were the pilot's lack of qualification, experience and the high density altitude.
- [NTSB DEN08LA021](https://openairdocs.org/ntsb/DEN08LA021.md): Cessna T210K · Los Alamos, NM · Accident · No injuries · Limited investigation · Final report · Oct 28, 2007 · N8251M · Substantial damage
  > The binding of the nose landing gear doors for undetermined reasons, resulting in the pilot having to make a nose gear up landing.
- [NTSB DEN07FA165](https://openairdocs.org/ntsb/DEN07FA165.md): Cessna T210M · Moriarty, NM · Accident · 1 fatal · Field investigation · Final report · Sep 24, 2007 · N732XE · Destroyed
  > the instructor pilot's failure to maintain aircraft control during aborted landing and attempted go-around which resulted in an inadvertent elevator trim stall. Contributing to the accident were the instructor pilot's inadequate supervision during the…
- [NTSB DEN07CA092](https://openairdocs.org/ntsb/DEN07CA092.md): Centrair 101C · Alamogordo, NM · Accident · No injuries · Data collection · Final report · May 12, 2007 · N991JB · Substantial damage
  > The pilot's inability to control the glider after encountering the downdraft causing the glider to land short of the dirt strip. Factors contributing to the accident were the downdraft and the runway marker.
- [NTSB DEN07LA049](https://openairdocs.org/ntsb/DEN07LA049.md): Beech A36 · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Jan 12, 2007 · N8183E · Substantial damage
  > The pilot-rated dual student's failure to maintain sufficient airspeed during the landing approach to avoid a stall. Also causal was the flight instructor's failure to provide adequate supervision. Factors associated with the accident are an inadvertent…
- [NTSB DEN06CA029](https://openairdocs.org/ntsb/DEN06CA029.md): Cessna 182A · Hobbs, NM · Accident · Serious injuries · Data collection · Final report · Dec 31, 2005 · N4755D · Substantial damage
  > the loss of engine power due to fuel exhaustion and the pilot's failure to visually verify the fuel quantity in the fuel tanks prior to departure. Contributing factors include the pilot's inadequate preflight, and the transmission wires.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=NM&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=NM

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.