NTSB investigations, NM
53 cases where the sequence of events included Other weather encounter.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 6 |
| 2014 | 6 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 3 |
| 2025 | 2 |
| 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\" = '400' 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" = '400' 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 WPR26LA238Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Angel Fire, NMThe pilot’s loss of directional control during landing with a crosswind.NTSB WPR26LA168Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Española, NMThe pilot’s loss of of directional control during landing roll following an encounter with a dust devil.NTSB WPR26LA052Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-225 · Albuquerque, NMThe balloon landing in increased wind, and the pilot’s inability to maintain the proper descent rate, which resulted in a hard landing.NTSB WPR26LA039Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 77A · Rio Rancho, NMAn inadvertent hard landing in high wind conditions resulting in serious injury of one of the pilots.NTSB WPR24LA264Accident · No injuriesClass 4 · LimitedFinal reportMooney M20F · Carrizozo, NMThe airplane’s encounter with a downdraft after takeoff, which resulted in a forced landing.NTSB WPR24LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Grady, NMThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.NTSB WPR24LA120Accident · No injuriesClass 4 · LimitedFinal reportBeecraft Bonanza · Angel Fire, NMThe pilot's failure to maintain directional control of the airplane during takeoff with a gusting crosswind..NTSB WPR23LA209Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Doo Ajdovscina Virus SW · Santa Fe, NMAn encounter with a downdraft during landing that resulted in a hard landing and the pilot’s loss of control.NTSB WPR23LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Santa Teresa, NMThe pilot’s loss of control after encountering a dust devil during landing.NTSB WPR22LA179Accident · No injuriesClass 4 · LimitedFinal reportSparks Ralph A RV8 · Deming, NMThe pilot’s loss of airplane control during takeoff following an encounter with a gust of wind.NTSB WPR21LA027Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Eurocopter AS350B3 · Silver City, NMThe pilot’s failure to maintain sufficient altitude above terrain while operating in reduced visibility due to snow showers.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 GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.NTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.NTSB GAA18CA262Accident · No injuriesData collectionFinal reportCessna 182 · Albuquerque, NMThe pilot’s decision to continue flight in mountainous terrain with downdraft conditions, which necessitated a precautionary landing on unsuitable terrain.NTSB GAA18CA112Accident · No injuriesData collectionFinal reportCessna 172 · Silver City, NMThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing.NTSB GAA18CA036Accident · No injuriesData collectionFinal reportSocata TBM 850 · Las Vegas, NMThe pilot’s inadequate compensation for gusting crosswind conditions during the go-around.NTSB GAA17CA547Accident · No injuriesData collectionFinal reportCessna 180 · Albuquerque, NMThe pilot’s failure to maintain directional control during the takeoff roll in gusting crosswind conditions.NTSB CEN17LA359Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22T · Raton, NMThe 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 GAA17CA360Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Portales, NMThe pilot's decision to fly the airplane under transmission lines while maneuvering at low altitude in high-density altitude conditions, which resulted in subsequent collision with terrain.NTSB GAA17CA357Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Edgewood, NMThe pilot's decision to take off with a gusting tailwind, which resulted in a loss of pitch control during the initial climb and a subsequent hard landing and loss of directional control.NTSB GAA17CA284Accident · No injuriesData collectionFinal reportCessna 170 · Taos, NMThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB GAA16CA505Accident · No injuriesData collectionFinal reportPiper PA46R · Reserve, NMThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB CEN16LA349Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Cuba, NMA partial loss of engine power for reasons that could not be determined based on available information.NTSB GAA16CA320Accident · No injuriesData collectionFinal reportBeech 77 · Santa Fe, NMThe pilot's decision to takeoff over the maximum takeoff weight in high density altitude conditions, which resulted in an inability to climb above terrain, a forced landing, and a collision with a road sign. Contributing to the accident was the pilot's…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 GAA15CA300Accident · No injuriesData collectionFinal reportCessna 177RG · Aztec, NMThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and an impact with shrubs.NTSB CEN15LA359Accident · Serious injuriesLimited investigationFinal reportAeros Aeros 2 · Albuquerque, NMThe ultralight airplane’s encounter with a downdraft in mountainous terrain, which resulted in a descent into trees.NTSB GAA15CA199Accident · Minor injuriesData collectionFinal reportNorton Claude C Tailwind W8 · Portales, NMThe pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack while maneuvering and a subsequent aerodynamic stall.NTSB GAA15CA133Accident · No injuriesData collectionFinal reportSchempp-Hirth Ventus 2C · Hobbs, NMThe pilot's improper compensation for gusty wind conditions which resulted in impact with terrain short of the runway.NTSB GAA15CA039Accident · Serious injuriesData collectionFinal reportCameron Z90 - NO Series · Bernalillo, NMThe pilot's failure to maintain the descent rate, resulting in abnormal runway/ground contact.NTSB CEN15LA091Accident · No injuriesLimited investigationFinal reportCessna 208B · Roswell, NMThe 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 CEN15FA044Accident · 1 fatalField investigationFinal reportMooney M20K · Clines Corners, NMThe noninstrument-rated pilot's decision to initiate the flight into known deteriorating weather conditions and his continued visual flight into instrument meteorological conditions, which ultimately resulted in a loss of airplane control. Contributing to the…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 CEN14CA353Accident · No injuriesData collectionFinal reportCessna 172N · Edgewood, NMThe pilot's in-flight loss of control resulting from a crosswind gust encountered immediately after takeoff.NTSB CEN14LA326Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS350B · Mayhill, NMThe 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 CEN14CA246Accident · No injuriesData collectionFinal reportNorth American SNJ 6 · Santa Fe, NMThe pilot's loss of directional control during landing and subsequent go around attempt.NTSB CEN14FA077Accident · 2 fatalField investigationFinal reportAviat A-1C-200 · Los Alamos, NMThe pilot’s loss of airplane control while maneuvering after takeoff in gusty wind conditions.NTSB CEN13LA507Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Clayton, NMThe pilot's loss of vertical control after the helicopter encountered a gusty tailwind while maneuvering at a low altitude and near the helicopter's maximum gross weight.NTSB CEN13CA494Accident · No injuriesData collectionFinal reportGlobe GC-1B · Santa Teresa, NMThe pilot's loss of directional control during the final approach due to an inadvertent encounter with a dust devilNTSB CEN13LA409Accident · 1 fatalLimited investigationFinal reportFlight Design Ctsw · Taos, NMThe airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.NTSB CEN13CA234Accident · No injuriesData collectionFinal reportCessna 175A · Albuquerque, NMThe pilot’s inability to maintain airplane control during taxi due to an inadvertent encounter with a dust devil.NTSB CEN13FA183Accident · 4 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot's loss of control while flying in a turbulent mountain-wave environment. Contributing to the accident was the pilot's overconfidence in his ability to safely pilot the airplane in gusting wind conditions and his lack of experience operating in…NTSB CEN13LA032Accident · Minor injuriesLimited investigationFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to attain the desired touchdown point because of wind conditions and surrounding obstructions, which resulted in the balloon impacting a fence during the approach to landing.NTSB CEN13CA035Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 90A · Albuquerque, NMThe balloon pilot's encounter with higher-than-expected wind velocity, which resulted in a hard landing and passenger injury.NTSB CEN11CA408Accident · No injuriesData collectionFinal reportCessna TU206G · Truth or Consequences, NMThe pilot's inability to control the airplane on take off.NTSB CEN09CA362Accident · No injuriesData collectionFinal reportAirborne Windsports PTY XT-912 · Alamogordo, NMThe failure of the pilot to maintain directional control while landing with gusting winds.NTSB CEN09CA101Accident · No injuriesData collectionFinal reportCessna T210L · Santa Fe, NMThe pilot's decision to land in gusty crosswinds, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.NTSB DEN08CA164Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Double Eagle Airport, NMThe pilot flared high and failed to maintain directional control. Contributing to the accident were the pilot's unfamiliarity with the airplane and the crosswind.