NTSB investigations, 2004, 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
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 year(c.\"eventDate\") = 2004
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") = 2004 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 DEN05FA045Accident · 1 fatalField investigationFinal reportPiper PA-31P · Gallup, NMthe pilot's failure to maintain minimum controllable airspeed which resulted in the loss of control, and impact with wires, a tree and terrain.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 DEN05CA040Accident · No injuriesData collectionFinal reportDaniels Vans RV-8 · Albuquerque, NMthe pilot's failure to maintain directional control resulting in a ground loop.NTSB DEN05TA033Accident · No injuriesFinal reportPiper PA-18-150 · Jal, NMthe pilot's failure to maintain clearance from the power lines. Contributing factors include the power lines, the sun glare, the pilot's reduced visual lookout, the pilot’s improper in-flight planning and decision making and the pilot's failure to perform a…NTSB DEN05LA028Accident · No injuriesLimited investigationFinal reportFarrell Lancair LC3 · Las Cruces, NMthe pilot's failure to maintain directional control during takeoff.NTSB DEN05CA021Accident · No injuriesData collectionFinal reportTemco GC-1B · Angel Fire, NMthe pilot's failure to maintain directional control and his inadequate compensation for wind. Contributing to the accident was the crosswind.NTSB DEN05CA020Accident · No injuriesData collectionFinal reportMooney M20E · Santa Rosa, NMInadequate maintenance inspection which failed to detect the separation of the right P-lead, resulting in a loss of engine power.NTSB DEN05CA016Accident · No injuriesData collectionFinal reportCessna 152 · Santa Teresa, NMthe student pilot' failure to maintain directional control during the takeoff roll. Contributing to the accident was the student pilot's failure to abort the takeoff.NTSB DEN05CA010Accident · Serious injuriesData collectionFinal reportAerostar International S-60S · Albuquerque, NMthe passenger striking the pilot's leg during the landing, resulting in a fractured leg.NTSB DEN05CA006Accident · No injuriesData collectionFinal reportAerostar SP-1 · Albuquerque, NMthe pilot's failure to maintain clearance with the radio tower. Contributing factors were the pilot's improper compensation for the variable wind conditions.NTSB DEN05CA009Accident · Serious injuriesData collectionFinal reportThunder and Colt 180A · Albuquerque, NMthe balloon pilot's improper in-flight planning and failure to maintain aircraft control during descent into high winds resulting in a hard landing and subsequent serious injury to a passenger. Factors contributing to the accident were the high winds and…NTSB DEN05LA004Accident · Serious injuriesLimited investigationFinal reportWorner Balloon Works NL-1000 · Chama, NMthe lightning strike and subsequent failure of the balloon's envelope, resulting in an uncontrolled descent and impact with terrain.NTSB DEN05FA003Accident · 1 fatalField investigationFinal reportCessna A185E · Luna, NMthe pilot's improper use of the mixture control, his failure to maintain clearance from the trees, and his improper preflight planning resulting in his taking off into a canyon and subsequently impacting the trees and terrain. Factors contributing to the…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 DEN05CA001Accident · No injuriesData collectionFinal reportCessna 185F · Santa Fe, NMthe pilot's failure to maintain aircraft control during the landing roll resulting in a ground loop. Contributing to the accident was the crosswind.NTSB DEN04LA149Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS-350-B3 · Las Cruces, NMThe pilot's failure to maintain aircraft control during takeoff resulting in the helicopter's skid striking the helipad and the helicopter's subsequent rollover. Factors contributing to the accident were the pilot's improper preflight planning/decision, his…NTSB DEN04LA146Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601P · Lordsberg, NMaircraft control not maintained by the pilot. Contributing to the accident was the dirt devil/whirlwind.NTSB DEN04CA132Accident · Serious injuriesData collectionFinal reportCameron Balloons A-210 · Albuquerque, NMthe passenger losing her balance during the landing. Contributing to the accident was the increased wind velocity.NTSB DEN04LA127Accident · No injuriesLimited investigationFinal reportCessna 172S · Carlsbad, NMthe student pilot's inadequate flare resulting in a hard landing. A contributing factor was the tailwind conditions.NTSB DEN04LA106Accident · No injuriesLimited investigationFinal reportCessna 182J · Farmington, NMthe pilot's inadequate compensation for wind and his improper flare. Contributing factors include the wind shift, and gusty wind conditions.NTSB DEN04CA103Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 120A · Albuquerque, NMthe pilot's failure to maintain/obtain the proper descent rate.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 DEN04TA088Accident · Serious injuriesFinal reportCessna C172P · Las Cruces, NMthe pilot's failure to maintain clearance from terrain and the improper go-around procedure. Contributing factors include the pilot's diverted attention, improper in-flight planning and decision making, pilot fatigue, the night conditions and the mesquite…NTSB DEN04LA077Accident · No injuriesLimited investigationFinal reportCessna 182E · Santa Teresa, NMthe pilot's inadequate in-flight planning and decision-making, which resulted in the loss of engine power due to fuel exhaustion. Contributing factors to the accident were the fuel exhaustion and the lack of suitable terrain for a forced landing.NTSB DEN04CA062Accident · No injuriesData collectionFinal reportCessna 180A · Las Vegas, NMthe pilot's decision to takeoff in wind conditions that consisted of a quarterly tailwind and a crosswind in excess of the maximum demonstrated crosswind component, and his failure to maintain directional control.NTSB DEN04LA055Accident · 1 fatalLimited investigationFinal reportMikoyan MiG Mig-17 · Truth or Conseq, NMthe loss of aircraft control for undetermined reasons resulting in impact with desert terrain.NTSB DEN04LA065Accident · No injuriesLimited investigationFinal reportMooney M20C · Clovis, NMthe pilot's improper in-flight planning and decision making during an instrument approach resulting in the pilot's intentional descent below approach minimums, and the pilot's failure to maintain obstacle clearance resulting in the in-flight collision with an…NTSB DEN04LA040Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe pilot's improper in-flight planning/decision making and his failure to maintain adequate airspeed which resulted in fuel starvation/exhaustion and a stall spin.NTSB DEN04TA036Accident · Minor injuriesFinal reportAyres S2T-T65 · Magdalena, NMloss of engine power for reasons undetermined. A contributing factor was the lack of suitable terrain for a forced landing.