NTSB investigations, 1997, NM
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1997
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") = 1997 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 FTW98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Grants, NMThe pilot's failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was the pilot's inadequate preflight inspection, which failed to secure the right engine oil cap, resulting in oil exhaustion and the loss of engine…NTSB FTW98LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Related factors were: the gusty crosswind condition, icy runway, and proximity of the snowbank.NTSB FTW98TA072Accident · Serious injuriesFinal reportBell 206B-III · Reserve, NMThe pilot's inadvertent loss of tail rotor effectiveness. A factor was the high density altitude weather condition.NTSB FTW98LA064Accident · 1 fatalLimited investigationFinal reportAdams A55S · Gallup, NMfailure of the ground crewman to follow proper procedures. A factor relating to the accident was: the passenger failed to follow the pilot's verbal instructions.NTSB FTW98LA054Accident · No injuriesLimited investigationFinal reportCessna 150M · Tajique, NMThe loss of engine power due to carburetor ice. Factors included unsuitable terrain, and dark night conditions.NTSB FTW98LA036Accident · No injuriesLimited investigationFinal reportCessna 172F · Hurley, NMthe student pilot's failure to adequately compensate for the wind conditions. Factors included the gusty crosswind conditions and inadequate supervision of the student pilot's solo flight by his flight instructor.NTSB FTW98LA033Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Counselor, NMthe pilot inadvertently allowing the helicopter to settle with power.NTSB FTW98LA029Accident · No injuriesLimited investigationFinal reportCessna 185C · Farmington, NMthe pilot's improper preflight of the airplane, by failing to properly set the elevator trim for takeoff, and his improper use use of the elevator flight controls. A related factor was: the pilot's lack of recent experience in the make and model of airplane.NTSB FTW98FA024Accident · 1 fatalField investigationFinal reportCessna 150M · Deming, NMThe loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.NTSB FTW98LA020Accident · No injuriesLimited investigationFinal reportCessna 180J · Chama, NMthe pilot's failure to maintain directional control of the airplane during its landing roll. Encounter with an embankment (dirt bank) was a related factor.NTSB FTW98LA010Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMThe passenger failing to follow the pilot's instructions as to the proper brace position to assume for landing.NTSB FTW98LA009Accident · No injuriesLimited investigationFinal reportCameron N-90 · Albuquerque, NMThe failure of the pilot of the Aerostar RX 8, N71415, to follow procedures/directives.NTSB FTW98LA143Accident · No injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMthe pilot's failure to maintain control of the balloon.NTSB FTW98LA013Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Folsum, NMthe pilot's failure to maintain aircraft control during takeoff, which resulted in a stall/mush. A related factor was the crosswind condition.NTSB FTW98LA008Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Albuquerque, NMthe passenger's failure to follow procedures/directives for the landing.NTSB FTW98LA021Accident · No injuriesLimited investigationFinal reportCessna 210L · Albuquerque, NMthe pilot's failure to extend the landing gear. A related factor was his attention being diverted.NTSB FTW97LA371Accident · Minor injuriesLimited investigationFinal reportSiai-Marchetti F.260 · Santa Rosa, NMimproper planning/decision by the pilot, which led to fuel exhaustion, loss of engine power, and a forced landing. A related factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA370Accident · No injuriesLimited investigationFinal reportCessna 210L · Albuquerque, NMThe fracture of the right main hydraulic landing gear actuator housing assembly due to overload.NTSB FTW97LA367Accident · Serious injuriesLimited investigationFinal reportBeech 58 · Mora, NMloss of power in the right engine for undetermined reason(s). Related factors were: that the power loss occurred above the airplane's single engine service ceiling (at high density altitude), and the lack of suitable terrain for a forced landing.NTSB FTW97LA351Accident · Serious injuriesLimited investigationFinal reportBrashears MONERAI-S · Artesia, NMthe pilot's improper handling of the aircraft during takeoff, which resulted in an inadvertent stall and collision with the terrain. A factor relating to the accident was: the pilot's lack of recent flight experience in the make and model of aircraft.NTSB FTW97LA334Accident · No injuriesLimited investigationFinal reportBeech E90 · Albuquerque, NMFatigue failure of the right main landing gear retraction/extension torque tube.NTSB FTW97LA322Accident · Serious injuriesLimited investigationFinal reportRockwell S-2R · Columbus, NMa loss of engine power due to failure of an exhaust side rocker box and valve mechanism, and pilot incapacitation due to loss of consciousness after being struck in the head by parts separating from the engine.NTSB FTW97LA315Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gila, NMthe pilot's impairment of judgment and performance due to alcohol, and his failure to maintain directional control of the airplane, which resulted in a ground swerve, and collision with vegetation (cactus) and a fence. Related factors were: the soft runway…NTSB FTW97LA303Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Los Alamos, NMThe fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97FA286Accident · 1 fatalField investigationFinal reportDurbin Glasair R · Chama, NMflight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the low ceiling, rain, fog, and high/mountainous terrain.NTSB FTW97FA255Accident · Minor injuriesField investigationFinal reportBoeing 727-247 · Albuquerque, NMThe inadequate inspection of the right main landing gear forward trunnion bearing support fitting. Factors were the failure of the right main landing gear forward trunnion bearing support fitting and the subsequent right main landing gear failure.NTSB FTW97FA249Accident · 1 fatalField investigationFinal reportSchempp-Hirth VENTUS-2B · Hobbs, NMThe pilot's failure to select an off-field landing site with sufficient time/altitude to perform the landing which led to his failure to maintain airspeed. A factor was the unfavorable wind.NTSB FTW97LA241Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clovis, NMThe pilot's failure to maintain aircraft control. A factor was an unexpected gust of wind during landing touch down.NTSB FTW97LA215Accident · Serious injuriesLimited investigationFinal reportBoeing 737-291A · Albuquerque, NMthe sudden encounter with clear air turbulence.NTSB FTW97LA214Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Santa Teresa, NMthe pilot-in-command's (PIC's) inadequate supervision of the flight by allowing the pilot-rated passenger to attempt a go-around (aborted landing) without maitaining minimum control speed (VMC), which resulted in loss of aircraft control. Factors relating to…NTSB FTW97LA201Accident · No injuriesLimited investigationFinal reportCentrair 101C · Santa Fe, NMthe pilot's improper planning/decison. Factors relating to the accident were: lack of thermal lift, which resulted in an off-airport landing, and the lack of suitable terrain for the landing.NTSB FTW97LA185Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Torreon, NMfailure of the forward number four piston pin plug, and the subsequent obstruction of internal oil passages of the lubricating system, which resulted in partial loss of engine power. Factors relating to the accident were: the crosswind condition and lack of…NTSB FTW97LA180Accident · No injuriesLimited investigationFinal reportCessna 172N · Las Cruces, NMThe improper installation of the throttle arm castellated nut, which resulted in a partial loss of power. A factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA179Accident · Serious injuriesLimited investigationFinal reportCallair A2A · Grants, NMInadvertent stall. Factors were the ground depression, the high density altitude, and a lack of recent experience in the make and model of aircraft.NTSB FTW97LA167Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hatch, NMThe pilot's failure to maintain clearance from the wires. A factor was the sunglare.NTSB FTW97TA154Accident · No injuriesFinal reportBell TH-13T · Capitan, NMloss of engine power for undetermined reason(s).NTSB FTW97LA155Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Silver City, NMThe high wind and the pilot's inadequate compensation for the crosswind conditions. Factors were the crosswind and wind gusts.NTSB FTW97FA103Accident · 5 fatalField investigationFinal reportPiper PA-24-250 · Farmington, NMloss of aircraft control for undetermined reason(s).NTSB FTW97LA102Accident · Serious injuriesLimited investigationFinal reportCessna 210-5 · Hobbs, NMThe loss of engine power due to fuel starvation for undetermined reasons. A factor was the pilot's continued flight after a fuel consumption anomaly was encountered.NTSB FTW97FA099Accident · 2 fatalField investigationFinal reportAeronca 65-TC · Moriarty, NMThe pilot's failure to maitain airspeed resulting in an inadvertent stall/spin. Factors were gusty winds, turbulence, a high density altitude, and the pilot's lack of total experience in the make and model of aircraft.NTSB FTW97FA092Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Mayhill, NMThe pilot's failure to maintain clearance with trees and terrain. Factors were the mountainous terrain, the snow obscuring the visibility, the dark night illumination, and the pilot's fatigue.NTSB FTW97LA076Accident · No injuriesLimited investigationFinal reportCessna 140A · Albuquerque, NMThe fracture of the right main landing gear for an undetermined reason.