NTSB investigations, 1994, NM
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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\") = 1994
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") = 1994 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 FTW95LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during a touch-and-go landing.NTSB FTW95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Eagle Nest, NMThe pilot's flight into rising terrain without sufficient altitude and climb performance available to clear the trees and terrain. A factor was the pilot becoming lost and disoriented.NTSB FTW95LA088Accident · No injuriesLimited investigationFinal reportBeech 1900D · Farmington, NMGround personnel failed to properly secure the cargo door.NTSB FTW95LA060Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Las Cruces, NMThe inadequate maintenance by unknown maintenance personnel. A factor was the collapsed landing gear.NTSB FTW95LA054Accident · Serious injuriesLimited investigationFinal reportGlaser-Dirks DG-600 · Alamogordo, NMThe inadvertent stall.NTSB FTW95FA050Accident · 2 fatalField investigationFinal reportCessna 172P · Deming, NMThe pilot's failure to maintain sufficient altitude and clearance in moutainous terrain. Factors were rising terrain and gusty, high wind conditions.NTSB FTW95LA046Accident · Serious injuriesLimited investigationFinal reportRaven S100A · Las Vegas, NMThe pilot's improper in-flight planning/decision. A factor related to the accident was: the high wind condition.NTSB FTW95LA038Accident · No injuriesLimited investigationFinal reportCessna 150M · Radium Springs, NMFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW95LA025Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Tres Piedras, NMThe pilot's inadequate inflight planning which led to maneuvering at slow airspeed to avoid terrain which resulted in further loss of airspeed and an aerodynamic stall.NTSB FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.NTSB FTW95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Albuquerque, NMImproper planning/decision by the pilot, while attempting flight into known adverse weather (wind), and his inadequate compensation for wind conditions. The gusty crosswind conditions and turbulence were related factors.NTSB FTW95LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmington, NMThe pilot's inadequate compensation for wind conditions. Factors were wind shear, crosswinds, and gusts.NTSB FTW95LA006Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Alamogordo, NMThe encountered turbulence. A factor was the lack of suitable terrain available for the forced landing.NTSB FTW94T#A04Accident · No injuriesFinal reportChristen Industries A-1 · Tinnie, NMNTSB FTW94LA255Accident · No injuriesLimited investigationFinal reportCessna 150J · Silver City, NMThe pilot's failure to refuel and the resultant loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA240Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Moriarity, NMThe pilot's inadequate compensation for wind conditions and the high density altitude. Factors were gusty wind conditions, downdrafts and the degraded engine performance due to pervious detonation damage.NTSB FTW94GA232Accident · 3 fatalFinal reportBell 206L-3 · Mimbres, NMThe pilot's improper decision to attempt to hover out of ground effect under adverse conditions while exceeding the maximum allowable weight for that maneuver. Factors in the accident were: high density altitude and the tailwind.NTSB FTW94LA213Accident · Serious injuriesLimited investigationFinal reportDerr TRI-Q-100 · Albuquerque, NMThe pilot's improper recovery from a bounced landing and his inability to maintain directional control. A factor was the high density altitude.NTSB FTW94LA199Accident · No injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMA power loss due to engine driven fuel pump failure. A factor was the lack of suitable terrain for a forced landing.NTSB FTW94T#A03Accident · No injuriesClass 3Final reportBell 204B · Alamogordo, NMNTSB FTW94LA179Accident · No injuriesLimited investigationFinal reportBoeing B-75 · Deming, NMA loss of control on the ground due to the pilot's improper compensation for the crosswind. A factor was the crosswind.NTSB FTW94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Roswell, NMThe loss of control due to clear air turbulence.NTSB FTW94LA110Accident · No injuriesLimited investigationFinal reportBell 206B · Belen, NMThe hard landing due to a delayed flare and improper touchdown. A factor was the loss of engine power.NTSB FTW94LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Albuquerque, NMThe CFI rated second pilot's failure to maintain the ILS glideslope. A factor was the dark night and lack of supervision.NTSB FTW94FA101Accident · 4 fatalField investigationFinal reportCessna 172RG · Dulce, NMFailure by the pilot in command to properly plan the flight and calculate performance data.NTSB FTW94LA089Accident · No injuriesLimited investigationFinal reportMooney M20J · Gallup, NMThe loss of engine power due to the failure of the number 3 exhaust valve. A factor was the lack of suitable terrain available to execute the forced landing.NTSB FTW94LA062Accident · No injuriesLimited investigationFinal reportCessna 140 · Espanola, NMWas the dual student pilot's failure to maintain directional control. A factor was the certificated flight instructor's inadequate supervision.