NTSB investigations, 1990, NM
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1990
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") = 1990 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 DEN91LA025Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Roswell, NMLow cylinder compression and fouled spark plug.NTSB DEN91FA020Accident · Serious injuriesField investigationFinal reportCessna T210L · Clovis, NMAn inadvertent descent into the ground while conducting a non-precision instrument approach, as a result of the pilot failing to stop his descent at mda. A factor is low visibility due to fog.NTSB DEN91DQA01Accident · 1 fatalFinal reportYoung 2/3 Scale · Alamogordo, NMPartial loss of engine power for an undetermined reason, improper planning/decision by the pilot, and the pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB DEN91LA015Accident · No injuriesLimited investigationFinal reportCessna 182C · Silver City, NMThe pilot's improper planning which resulted in fuel starvation.NTSB DEN91FA013Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Belen, NMThe pilot misjudged the aircraft's altitude (ground clearance) above the desert terrain.NTSB DEN91LA007Accident · Minor injuriesLimited investigationFinal reportBalloon Works AX9 · Cedar Crest, NMPilot's delayed precautionary landing and the subseuqent fuel exhaustion. A factor was the encounter with high winds in flight.NTSB DEN91LA003Accident · 2 fatalLimited investigationFinal reportRaven S-55A · Bernalillo, NMThe pilot to maintain adequate visual lookout, resulting in an inflight collision with power lines.NTSB FTW90FA186Accident · 2 fatalField investigationFinal reportMooney M20A · San Ysidro, NMFailure of the pilot to maintain adequate terrain clearance during a night VFR flight. Darkness and mountainous terrain were related factors.NTSB DEN90FA184Accident · 2 fatalField investigationFinal reportMorane-Saulnier MS760 · Albuquerque, NMFailure of the pilot to maintain a climb after takeoff, due to spatial disorientation. Factors related to the accident were: darkness, pilot fatigue, and the pilot's lack of recent experience in night flying operation.NTSB DEN90FA182Accident · 3 fatalField investigationFinal reportStinson 108-1 · Gallup, NMThe pilot inadvertently stalling his aircraft at an insufficient altitude to effect a recovery. A factor was high density attitude.NTSB DEN90LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Las Vegas, NMThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.NTSB DEN90FA176Accident · 1 fatalField investigationFinal reportCameron O-84 · Taos, NMThe pilot's improper decision to attempt a go-around. A factor was the unfavorable wind encountered late in the attempted landing.NTSB DEN90LA175Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-19 · Alamogordo, NMThe pilot's failure to maintain control of the glider, which resulted in the pilot induced oscillations.NTSB DEN90LA173Accident · No injuriesLimited investigationFinal reportCessna T-210-L · Edgewood, NMEngine failure due to a broken connecting rod. A factor was the rough uneven terrain available for the forced landing.NTSB DEN90LA171Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Silver City, NMThe pilot's improper planning which resulted in a flight in conditions which exceeded the performance capability of the aircraft. The high density altitude was a factor.NTSB DEN90FA170Accident · 2 fatalField investigationFinal reportBeech J35 · Santa Fe, NMFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB DEN90LA169Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Bingham, NMThe fuel exhaustion induced power loss. Factors were the pilot's failure to refuel and the unsuitable terrain in which the forced landing was performed.NTSB DEN90LA167Accident · No injuriesLimited investigationFinal reportMooney M20C · Roswell, NMThe intentional wheels up landing in soft terrain. Contributing to the accident was the fuel starvation induced power loss, failure of the pilot to switch fuel tanks, improper positioning of the fuel selector during attempted restarts, and the soft terrain.NTSB DEN90DQA02Accident · No injuriesFinal reportGrumman G-164A · Deming, NMFailure of the pilot to maintain control during landing roll due to the condition of the runway. Contributing to the accident was the poor maintenance of the runway surface.NTSB DEN90FA166Accident · No injuriesField investigationFinal reportCessna 208A · Ruidoso, NMEngine failure due to failure of the gas producer and power turbine assemblies. A factor in the accident was the lack of suitable terrain for the forced landing.NTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.NTSB DEN90LA152Accident · No injuriesLimited investigationFinal reportStinson 108 · Clovis, NMImproper installation of the right main wheel assembly.NTSB DEN90LA138Accident · No injuriesLimited investigationFinal reportBuchanan S1-S · Albuquerque, NMThe failure of the pilot in command to adequately compensate for the wind conditions and to maintain directional control during landing roll. A contributing factor was the failure of the tailwheel locking assembly.NTSB DEN90LA137Accident · Minor injuriesLimited investigationFinal reportErcoupe 415C · Truth/Consequen, NMThe pilot's failure to maintain proper airspeed and obtain a proper climb rate after takeoff.NTSB DEN90LA129Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Las Cruces, NMThe fuel exhaustion induced power loss. Factors were the failure of the pilot to refuel and the high vegetation in which the forced landing was performed.NTSB DEN90LA121Accident · Serious injuriesLimited investigationFinal reportHughes 369HS · Las Cruces, NMA loss of power for an unknown cause. A factor in the accident was the unsuitable terrain.NTSB DEN90LA116Accident · No injuriesLimited investigationFinal reportCessna 172RG · Albuquerque, NMThe cfi's improper procedures during takeoff. Factors were premature liftoff and inadvertent stall/mush.NTSB DEN90DQA01Accident · 1 fatalFinal reportMichael C. Quigley Velocity · Santa Teresa, NMFailure of the pilot in command to maintain airspeed on final approach resulting in an inadvertent stall and uncontrolled descent into the ground.NTSB DEN90FA104Accident · 2 fatalField investigationFinal reportCanadair CT-133 · Roswell, NMThe pilot-in-command's performance of aerobatic maneuvers that exceeded the design stress limits of the aircraft, resulting in catastrophic failure of the wing.NTSB DEN90LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Albuquerque, NMThe fuel exhaustion induced power loss.NTSB DEN90LA071Accident · No injuriesLimited investigationFinal reportCessna 402B · Alamogordo, NMThe collapse of the right main landing gear as a result of the malfunction of the down lock assembly and failure of the torque tube bracket assembly.NTSB DEN90LA069Accident · No injuriesLimited investigationFinal reportErco 415C · Tierra Amarilla, NMInduction icing induced power loss. Factors include continuation of flight into IMC conditions, and unsuitable mountainous terrain for a forced landing.NTSB DEN90LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gallup, NMImproper operation of the engine during preflight preparation, which resulted in overheating of the engine and damage to internal components.