NTSB investigations, NM
146 cases where the first occurrence was “Loss of control - in flight”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 7 |
| 1984 | 3 |
| 1985 | 12 |
| 1986 | 7 |
| 1987 | 7 |
| 1988 | 7 |
| 1989 | 4 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 6 |
| 1994 | 6 |
| 1995 | 4 |
| 1996 | 4 |
| 1997 | 7 |
| 1998 | 4 |
| 1999 | 7 |
| 2000 | 10 |
| 2001 | 3 |
| 2002 | 3 |
| 2003 | 8 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 9 |
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\" = 250)
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" = 250) 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 DEN08CA043Accident · No injuriesData collectionFinal reportChampion 7GCAA · Gallup, NMThe pilot's premature landing flare and an inadvertent stall/mush. A contributing factor is pilot's lack of recent night experience.NTSB DEN08LA040Accident · 1 fatalLimited investigationFinal reportGarniss Stol 701 · Mesilla, NMThe pilot's failure to maintain aircraft control during an intentional low altitude maneuver due to impairment, resulting in the in-flight collision with terrain.NTSB DEN07LA167Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Silver City, NMThe student pilot's failure to maintain control of the helicopter resulting in his settling with power and subsequent impact with terrain. A factor contributing to the accident was the trees.NTSB DEN07FA165Accident · 1 fatalField investigationFinal reportCessna T210M · Moriarty, NMthe 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 DEN07LA145Accident · 1 fatalLimited investigationFinal reportAdams Airborne Australia O · Taos, NMThe pilot's intentional low altitude flight in a confined area and an inadvertent stall/spin. Contributing factors in this accident were the blind/box canyon and the aircraft's low airspeed.NTSB DEN07FA136Accident · 2 fatalField investigationFinal reportZlin Aviation s.r.o. Savage · Mosquero, NMThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall. Contributing to the accident was the conflicting airspeed information provided by the manufacturer, the incorrect airspeed indicator markings, and the high density…NTSB DEN07CA115Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Albuquerque, NMThe pilot's failure to maintain aircraft control during an encounter with the loss of tail rotor effectiveness. Contributing factors were the high density altitude and the power lines.NTSB DFW07LA160Accident · 1 fatalLimited investigationFinal reportIngraham RV-6 · Carlsbad, NMThe pilot's loss of control for undetermined reasons.NTSB DEN07LA049Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMThe 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 DEN07LA020Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502A · Deming, NMThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain. A contributing factor was the low airspeed.NTSB DEN07CA009Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Hope, NMthe pilot's failure to maintain aircraft control. Contributing factors in this accident included the sudden wind shift and high density altitude, resulting in the helicopter settling with power, and the high vegetation.NTSB DEN07FA003Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Tucumcari, NMThe pilot's failure to maintain aircraft control during aerobatic flight, resulting in an inadvertent accelerated stall. Contributing factors include the low altitude for recovery from the loop and the high density altitude.NTSB DEN06LA096Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Taos, NMthe loss of tail rotor effectiveness during landing, and the pilot's delayed remedial action to counteract a right yaw, which resulted in a loss of directional control and collision with terrain. A contributing factor was the pilot's failure to perform…NTSB DEN06CA064Accident · No injuriesData collectionFinal reportRobinson R-22 · Santa Fe, NMthe pilot's improper preflight planning and his failure to maintain control of the helicopter during takeoff. Factors contributing to the accident were the helicopter exceeding its maximum gross weight for takeoff and the high density altitude.NTSB DEN06FA023Accident · 1 fatalField investigationFinal reportCessna 172S · Pinon, NMthe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB DEN06FA013Accident · 1 fatalField investigationFinal reportBeech A36 · Datil, NMthe pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.NTSB DEN05CA062Accident · No injuriesData collectionFinal reportBeech A36 · Farmington, NMthe student pilot's failure to maintain airspeed which resulted in a stall and loss of control. Contributing factors were wind gusts, instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB DEN05LA053Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 B3 · Pilar, NMthe pilot's failure to maintain control of the helicopter, and his improper use of night vision goggles (NVG). Contributing factors were the pilot's spatial disorientation, his self-induced pressure to return the helicopter to its home base, his lack of…NTSB DEN05FA044Accident · 1 fatalField investigationFinal reportCessna 172S · Roswell, NMthe pilot not maintaining control of the aircraft resulting in an uncontrolled descent and collision on a highway. Factors contributing to the accident were the dark night and the pilot experiencing spatial disorientation.NTSB DEN05FA002Accident · 1 fatalField investigationFinal reportSukhoi SU-29 · Santa Fe, NMthe pilot's failure to maintain aircraft control resulting in the inverted spin, spiral, and subsequent impact with terrain. Factors contributing to the accident were the inadvertent stall spin, the spiral, low altitude, and the pilot's delayed attempt to…NTSB DEN04CA102Accident · Minor injuriesData collectionFinal reportMooney M20S · Farmington, NMthe pilot's failure to maintain airspeed resulting in a stall. A contributing factor was the pilot's diverted attention.NTSB DEN04LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Las Cruces, NMthe CFI's failure to maintain aircraft control during a go-around resulting in an inadvertent stall/mush and impact with terrain. Contributing factors include the CFI's inadequate supervision, the private pilot's delayed relinquishing of control, and the…NTSB DEN04LA006Accident · Serious injuriesLimited investigationFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high-wind landing, resulting in a hard landing, the subsequent tipping of the balloon's basket, a post impact flash fire, and the ejection of two passengers. Contributing factors include the high wind…NTSB DEN04LA005Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons LBL · Albuquerque, NMthe inadequate in-flight planning/decision by the pilot. Contributing factors include the inadvertent activation of the deflation line by the pilot and the retaining wall.NTSB DEN03FA157Accident · 1 fatalField investigationFinal reportBeech 35 · Belen, NMThe pilot's failure to maintain aircraft control immediately after takeoff due to spatial disorientation. A factor was the dark night light conditions.NTSB DEN03LA124Accident · No injuriesLimited investigationFinal reportPZL Wilga 104-80 · Santa Fe, NMthe pilot's failure to maintain airspeed which resulted in a stall.NTSB DEN03LA105Accident · Serious injuriesLimited investigationFinal reportAdams Balloon A55 · Albuquerque, NMthe pilot's improper planned approach for a landing and obstacle clearance not maintained. A contributing factor was the power lines.NTSB DEN03TA102Accident · Minor injuriesFinal reportCessna 182R · Hobbs, NMThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB DEN03LA056Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's premature liftoff resulting in his failure to attain airspeed and achieve takeoff climb. Contributing factors were the runway light and taxiway sign.NTSB FTW03FA036Accident · 2 fatalField investigationFinal reportIsrael Aircraft Industries 1124A · Taos, NMThe pilot's inadvertent flight into mountain wave weather conditions while IMC, resulting in a loss of aircraft control.NTSB FTW03FA024Accident · 1 fatalField investigationFinal reportPiper PA-31T · Hobbs, NMThe pilot's loss of control while in instrument meteorological conditions during initial takeoff climb. Contributing factors were the prevailing clouds and fog.NTSB DEN02LA079Accident · No injuriesLimited investigationFinal reportCessna 150F · Grants, NMthe pilot's inadequate preflight preparation, and his failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the high density altitude conditions, the terrain barrier (berm).NTSB FTW02LA031Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Crownpoint, NMThe safety pilot's failure to maintain directional control during the landing. Contributing factors were the safety pilot's lack of experience flying from the right seat and the improper retraction of the flaps during the attempted go-around.NTSB DEN01FA113Accident · 2 fatalField investigationFinal reportMitsubishi MU-2B-20 · Cerrillos, NMthe pilot's loss of aircraft control inflight for reasons undetermined. Contributing factors were the pilot's inadequate transition/upgrade training and his total lack of experience in aircraft make/model.NTSB DEN01FA098Accident · 1 fatalField investigationFinal reportBeech King Air B90 · San Jon, NMthe pilot's failure to maintain aircraft control due to his incapacitation for an undetermined reason. A contributing factor was the subsequent inadvertent stall/spin to the ground.NTSB DEN01LA037Accident · No injuriesLimited investigationFinal reportCessna 177 · Las Cruces, NMAn inadvertent stall. Factors were excessive airspeed, excessive flare, and improper recovery from a bounced landing.NTSB DEN01FA033Accident · 2 fatalField investigationFinal reportBeech V35B · Albuquerque, NMthe pilot's failure to maintain aircraft control and the inadvertent stall. Factors contributing to the accident were the pilot's improper in-flight planning, his lack of recent flying experience, and the abrupt maneuver to correct to the proper runway.NTSB DEN00LA183Accident · 2 fatalLimited investigationFinal reportErcoupe 415-C · Tucumcari, NMloss of control during initial climb following takeoff by an unqualified person.NTSB DEN00LA152Accident · No injuriesLimited investigationFinal reportRosenbarger Lancair IV · Artesia, NMFailure by the pilot in command to maintain control of the aircraft during initial climb following takeoff.NTSB DEN00LA107Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Santa Fe, NMThe pilot's failure to maintain control of the aircraft. A factor was gusty wind conditions.NTSB FTW00LA143Accident · Serious injuriesLimited investigationFinal reportLewis Spitfire/Raven · Albuquerque, NMThe pilot's inadvertent stall of the aircraft.NTSB DEN00LA073Accident · No injuriesLimited investigationFinal reportHelio H-295 · Albuquerque, NMThe flight instructor's failure to maintain aircraft control during takeoff initial climb.NTSB DEN00FA067Accident · 1 fatalField investigationFinal reportCessna 152 · Roswell, NMThe pilot's failure to maintain aircraft control and the subsequent inadvertent stall/spin. A factor was the pilot's diverted attention to over flying her residence.NTSB DEN00LA051Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Reserve, NMThe pilot's failure to adequately compensate for wind conditions. A factor was the wind gust.NTSB DEN00TA042Accident · Serious injuriesFinal reportBell OH-58C · Lindrith, NMLoss of tail rotor effectiveness while maneuvering. A factor was the high density altitude.NTSB DEN00FA025Accident · 1 fatalField investigationFinal reportCessna T210L · Elida, NMThe pilot's failure to maintain aircraft control for reasons undetermined. Factors were icing conditions and instrument failure, as reported by the pilot.NTSB DEN99LA169Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Animas, NMA inadvertent stall during initial climb following takeoff. Factor were: high gross weight, high density altitude, inadequate preflight planning and preparation, and soft terrain.NTSB DEN99FA137Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMThe pilot's failure to maintain sufficient airspeed during final approach to landing, resulting in an inadvertent stall. A factor was the high density altitude.NTSB DEN99LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Edgewood, NMThe pilot's excessive rotation during takeoff, resulting in an inadvertent stall/mush. Factors were the pilot's lack of recent flight experience, and the high density altitude..NTSB DEN99LA117Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Hobbs, NMThe pilot's inadequate in-flight planning. Factors were the loss of thermal lift, the subsequent stall/spin, and the fence post that he impacted.