NTSB investigations, 2003, NM
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 82 |
|---|---|
| 1965 | 88 |
| 1966 | 99 |
| 1967 | 113 |
| 1968 | 99 |
| 1969 | 85 |
| 1970 | 86 |
| 1971 | 79 |
| 1972 | 69 |
| 1973 | 73 |
| 1974 | 74 |
| 1975 | 85 |
| 1976 | 64 |
| 1977 | 89 |
| 1978 | 98 |
| 1979 | 94 |
| 1980 | 68 |
| 1981 | 78 |
| 1982 | 72 |
| 1983 | 46 |
| 1984 | 56 |
| 1985 | 63 |
| 1986 | 41 |
| 1987 | 44 |
| 1988 | 48 |
| 1989 | 36 |
| 1990 | 33 |
| 1991 | 34 |
| 1992 | 26 |
| 1993 | 28 |
| 1994 | 27 |
| 1995 | 41 |
| 1996 | 41 |
| 1997 | 42 |
| 1998 | 43 |
| 1999 | 39 |
| 2000 | 42 |
| 2001 | 36 |
| 2002 | 33 |
| 2003 | 36 |
| 2004 | 29 |
| 2005 | 21 |
| 2006 | 26 |
| 2007 | 36 |
| 2008 | 31 |
| 2009 | 27 |
| 2010 | 27 |
| 2011 | 23 |
| 2012 | 19 |
| 2013 | 23 |
| 2014 | 28 |
| 2015 | 25 |
| 2016 | 18 |
| 2017 | 24 |
| 2018 | 27 |
| 2019 | 20 |
| 2020 | 8 |
| 2021 | 17 |
| 2022 | 16 |
| 2023 | 15 |
| 2024 | 24 |
| 2025 | 16 |
| 2026 | 16 |
Where
Latest 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 year(c.\"eventDate\") = 2003
AND c.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2003 AND c."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA' 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 DEN04LA033Accident · No injuriesLimited investigationFinal reportAerospatiale AS 365 N-2 · Santa Fe, NMthe pilot's failure to maintain lateral clearance from the hangar. A contributing factor was the gusty crosswind.NTSB DEN04LA032Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Edgewood, NMthe pilot's inadequate in-flight planning and decision making. Factors contributing to the accident include the resulting fuel exhaustion, the snow covered field and the fence.NTSB DEN04LA025Accident · No injuriesLimited investigationFinal reportCessna T210K · Deming, NMThe pilot's improper in-flight planning and decision. Factors contributing to the accident were fuel exhaustion and the fence.NTSB DEN04LA022Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Truth or Conseq, NMthe pilot's inadequate flare and his failure to maintain directional control. A contributing factor was the night light conditions.NTSB DEN04LA017Accident · Serious injuriesLimited investigationFinal reportCessna 172R · Cloudcroft, NMthe dual student's failure to maintain clearance from the terrain. Also causal was the flight instructor's inadequate supervision. Low altitude flight and rising terrain are contributing factors.NTSB DEN04LA018Accident · No injuriesLimited investigationFinal reportCessna 182A · Albuquerque, NMthe pilot's delayed use of carburetor heat and his inadequate flare resulting in a loss of engine power and a hard landing. Also causal was the inadequate supervision of the flight. Carburetor icing conditions was a contributing factor.NTSB DEN04LA011Accident · No injuriesLimited investigationFinal reportCessna 177 · Nageezi, NMthe pilot's inadequate preflight planning, inadequate fuel consumption calculations, and improper fuel management. Contributing factors include fuel exhaustion resulting in the loss of power, the lack of suitable terrain for a forced landing and the tree.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 DEN04LA007Accident · No injuriesLimited investigationFinal reportAviat Pitts S2B · Santa Teresa, NMthe instructor's improper in-flight planning/decision making and fuel mismanagement which resulted in fuel starvation/exhaustion, the loss of engine power and the subsequent forced landing. Contributing factors include the instructor's inadequate preflight…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 DEN03LA151Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Taos, NMthe pilot's failure to maintain directional control during landing roll which resulted in the subsequent ground loop/swerve and impact with the ditch.NTSB DEN03LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Farmington, NMthe pilot's improper procedures/directives, and the delayed activation of carburetor heat which resulted in the loss of engine power and subsequent impact with terrain. Contributing factors include the carburetor icing conditions, and the rough/uneven and…NTSB DEN03LA140Accident · No injuriesLimited investigationFinal reportCessna 337F · Las Cruces, NMLack of adequate power from the rear engine for undetermined reasons and the pilot's failure to maintain aircraft control during take-off. A contributing factor to the accident was the low altitude.NTSB DEN03LA135Accident · No injuriesLimited investigationFinal reportCessna A185F · Angel Fire, NMthe instructor's inadequate supervision which resulted in the pilot's loss of directional control and the subsequent impact with the ditch. Contributing factors include the instructor's inadequate remedial action and the inadvertent ground loop/swerve.NTSB DEN03LA124Accident · No injuriesLimited investigationFinal reportPZL Wilga 104-80 · Santa Fe, NMthe pilot's failure to maintain airspeed which resulted in a stall.NTSB DEN03LA119Accident · Serious injuriesLimited investigationFinal reportEagle Balloons C-7 · Rio Rancho, NMa hard landing for undetermined reasons. Factors relating to the accident were the unfavorable winds and landing on hilly terrain.NTSB DEN03LA109Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Las Vegas, NMthe pilot's failure to maintain obstacle clearance and visual lookout. Contributing factors were his attention being diverted and the trees.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 DEN03LA152Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Santa Fe, NMthe inadvertent encounter with turbulence associated with thunderstorms. A contributing factor was the icing conditions.NTSB DEN03TA103Accident · No injuriesFinal reportCessna R172E · Albuquerque, NMthe student pilot's inadvertent encounter with the jet blast and the subsequent inability to maintain aircraft control.NTSB DEN03TA102Accident · Minor injuriesFinal reportCessna 182R · Hobbs, NMThe pilot's failure to maintain airspeed, which resulted in a stall.NTSB DEN03LA100Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 Standard III · Moriarty, NMthe pilot's improper flare, and his failure to recover from the subsequent bounced landing. Contributing factors include the sudden wind shift and the tail wind.NTSB DEN03FA087Accident · 2 fatalField investigationFinal reportErcoupe 415D · Los Lunas, NMthe pilot's failure to maintain clearance from the transmission wire. Contributing factors were the high wind, the pilot's decision to make a low-altitude turn onto the crosswind leg, and the power line.NTSB DEN03LA084Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Albuquerque, NMthe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors include, the pressures induced on the pilot by the landing conditions and the asphalt walkway on the side of the runway.NTSB DEN03LA081Accident · Serious injuriesLimited investigationFinal reportAerostar International S66A-3060 · Albuquerque, NMthe pilot's failure to maintain aircraft control during a high wind landing, which resulted in a hard landing. Contributing factors include the high wind and the berm.NTSB DEN03LA077Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Sedan, NMthe nonmechanical partial loss of engine power due to water contamination of the fuel. Contributing factors include the lack of suitable terrain for a forced landing (due to his low altitude), and the irrigation system (object) that was impacted.NTSB DEN03LA064Accident · No injuriesLimited investigationFinal reportCessna 182G · Truth or Conseq, NMthe pilot's failure to maintain directional control during landing roll which resulted in impact with terrain. Contributing factors include, the pilot's improper in-flight planning/decision making, the crosswind and gusty wind conditions, the ditch, and the…NTSB DEN03LA060Accident · No injuriesLimited investigationFinal reportCessna 170A · Hobbs, NMthe pilot's failure to maintain aircraft directional control during takeoff roll. A factor was the runway light's cement foundation.NTSB DEN03LA057Accident · No injuriesLimited investigationFinal reportCessna 170A · Santa Rosa, NMthe pilot's failure to maintain directional control while taxiing for takeoff. A contributing factor was the wind gust.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 DEN03LA055Accident · No injuriesLimited investigationFinal reportMohr Starduster Too · Espanola, NMthe pilot's improper inflight planning in that he failed to consult the airplane flight manual, his use of incorrect fuel consumption figures, and fuel exhaustion. Contributing factors were the loss of the en route chart, the unavailability of a nav/comm…NTSB DEN03LA049Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Belen, NMthe pilot's improper preflight/in-flight decision making which resulted in the loss of engine power due to fuel starvation. Contributing factors include, the partial fuel selector valve failure, the pilot's intentional operation with known deficiencies in…NTSB DEN03FA045Accident · 3 fatalField investigationFinal reportPiper PA-46-500TP · Albuquerque, NMThe pilot's unstabilized approach and his failure to maintain obstacle clearance. Contributing factors were the dark night light condition, and the static wires.NTSB DEN03LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Logan, NMthe pilot's improper in-flight planning/decision, his failure to accomplish appropriate checklist items during the go-around, and his failure to maintain clearance from the trees and the lamp post. Factors contributing to the accident were the low altitude,…