NTSB investigations, NM
53 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 2 |
| 1984 | 5 |
| 1985 | 4 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 3 |
| 1991 | 2 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 3 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 3 |
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 c.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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 c."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 DEN08LA021Accident · No injuriesLimited investigationFinal reportCessna T210K · Los Alamos, NMThe binding of the nose landing gear doors for undetermined reasons, resulting in the pilot having to make a nose gear up landing.NTSB DEN07CA118Accident · Minor injuriesData collectionFinal reportJohnson F11C-2PJ · Deming, NMTotal failure of the top engine mount bolts and subsequent engine separation from the airframe.NTSB DEN07FA068Accident · Minor injuriesField investigationFinal reportFlight Design USA CT-SW · Albuquerque, NMThe total failure of the left main landing gear strut due to overload during the landing resulting in the loss of control and subsequent nose over. A factor contributing to the accident was the chief pilot 's inability to maintain directional control of the…NTSB DEN07LA024Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Melrose, NMthe in-flight failure and separation of both tail rotor blades. Contributing factors in this accident were the check pilot interferring with the controls and his failure to relinquish control to the pilot-in-command.NTSB DEN05LA123Accident · No injuriesLimited investigationFinal reportForbes Rutan Long EZE · Albuquerque, NMa total electrical failure due to a short in the master relay, causing the main fuse to open. Contributing factors included an inadequate electrical design by the airplane's builder, a low-output alternator, a cement wall, and unsuitable terrain on which to…NTSB DEN05TA119Accident · Serious injuriesFinal reportHughes 369HS · Albuquerque, NMthe bullet(s), which severed the helicopter's left tail rotor pedal. Contributing factors were the severed anti-torque pedal and the unsuitable terrain for landing.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 FTW02LA242Accident · No injuriesLimited investigationFinal reportWhittman Tailwind W-8 · Albuquerque, NMThe structural failure and separation of a propeller blade for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot to execute a forced landing.NTSB FTW02LA189Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Farmington, NMThe failure of the nose landing gear plunger assembly due to fatigue.NTSB FTW02LA074Accident · No injuriesLimited investigationFinal reportBeech 58 · Farmington, NMThe failure of the nose gear actuator retract arm due to fatigue.NTSB FTW02FA017Accident · 2 fatalField investigationFinal reportAerospatiale AS350B2 · Roswell, NMThe seizing of the cyclic control for an undetermined reason. A contributing factor was the lack of altitude for the pilot to regain control of the helicopter.NTSB DEN00LA132Accident · Minor injuriesLimited investigationFinal reportSpencer Long EZE · Farmington, NMFailure of the coolant recovery system, resulting in overheating of the engine. A factor was the soft ground on which the forced landing was made.NTSB DEN00LA048Accident · Serious injuriesLimited investigationFinal reportBeech M35 · Albuquerque, NMThe pilot inadvertently allowing the airplane to stall. Factors were the missing alternator belt and the resultant total electrical system failure, and the pilot's attention being diverted.NTSB DEN99FA034Accident · 3 fatalField investigationFinal reportCessna P210N · Albuquerque, NMTotal failure of the vacuum system, and failure of the pilot to maintain aircraft control, resulting in wing spar failure. Factors were the pilot's spatial disorientation, and his exceeding the design stress limits of the airplane.NTSB DEN99IA033Incident · No injuriesIncident investigationFinal reportBeech E90 · Clovis, NMTotal failure of the elevator control cable due to a short circuit from chafing against an adjoining electrical cable, and failure of maintenance personnel to detect the problem during an AAIP phase inspection.NTSB FTW98LA148Accident · No injuriesLimited investigationFinal reportBeech 58 · Taos, NMThe total failure of the landing gear retraction/extension assembly for reasons undetermined.NTSB FTW98FA089Accident · Serious injuriesField investigationFinal reportCameron R-420 · Yeso, NMThe rupture of the gas cell bottom (diaphragm) due to inadequate manufacturer's design and inadequate manufacturing quality control. A factor was the flight crew's performance of an emergency bailout which allowed the balloon to drift unattended for…NTSB FTW96LA284Accident · No injuriesLimited investigationFinal reportBeech B35 · Portales, NMfailure by maintenance personnel to perform proper maintenance on the aircraft during an annual inspection, and failure to comply with an airworthiness directive.NTSB FTW96TA195Accident · No injuriesFinal reportRockwell NA-265-80 · Albuquerque, NMoverdeflection of the left outboard main landing gear tire, probably due to underinflation and inadequate inspection, which resulted in fatigue failure of the left outboard tire and subsequent failure of the left inboard tire.NTSB FTW96LA106Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Belen, NMprevious damage, looseness of the main landing gear, and inadequate maintenance.NTSB FTW96LA011Accident · No injuriesLimited investigationFinal reportCessna 195A · Taos, NMseparation of the left main gear wheel as a result of improper maintenance.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 FTW93LA261Accident · Minor injuriesLimited investigationFinal reportCulver V · Carlsbad, NMAn inadvertent stall when the pilot lowered the landing gear. A factor was a leaking o-ring in the propeller governor.NTSB FTW93LA262Accident · No injuriesLimited investigationFinal reportZbacnick Challenger II · Alamogordo, NMThe seizure of the propeller shaft bearing and the resultant propeller blade separation. Factors were the unfavorable winds and the lack of suitable terrain available for the forced landing.NTSB FTW93LA124Accident · No injuriesLimited investigationFinal reportViolet Dragonfly · Carlsbad, NMThe improper installation of the control stick assembly and the subsequent separation of the flight control stick assembly from the mountNTSB FTW93FA105Accident · 2 fatalField investigationFinal reportPiper PA-28R-201T · Radium Springs, NMA total failure of the airplane's vacuum system. Factors which contributed to the accident were: the dark night, snow, the pilot's loss of aircraft control, and the pilot's lack of experience in flying in actual intrument meteorological conditions.NTSB DEN91LA102Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Albuquerque, NMThe failure of the right main landing gear tire.NTSB DEN91LA092Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Albuquerque, NMThe pilot's improper maintenance of the aircraft. Factors were: a loose oil filter and loss of engine oil.NTSB DEN90LA152Accident · No injuriesLimited investigationFinal reportStinson 108 · Clovis, NMImproper installation of the right main wheel assembly.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 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 DEN90LA008Accident · No injuriesLimited investigationFinal reportThunder and Colt Clown · Albuquerque, NMStructural failure of the balloon envelope as a result of the manufacturer's quality control oversight.NTSB DEN89LA144Accident · No injuriesLimited investigationFinal reportBeauchesne/Wells Glasair TD · Moriarity, NMImproper installation of the propeller which resulted in severe vibration and failure of the propeller mounting bolts, & the separation of the propeller from the aircraft. Rough/uneven desert terrain contributed to the accident.NTSB DEN88GA088Accident · No injuriesFinal reportBell 47G-3B1 · Gobernador, NMThe commerical plt was hovering out of ground effect at 40 feet AGL. During a maneuver he reported hearing a loud bang and the rotor RPM began to decay. The plt made a hovering autorotation resulting in a hard landing. The main rotor struck the tail boom and…NTSB DEN88DQA03Accident · 2 fatalFinal reportSurline Sidewinder · Moriarty, NMWitnesses heard the acft eng sound increase dramatically as the acft passed over a gen aviation airport. The acft was seen by another witness at low atl, estimated to be about 200 ft, as the nose pitched up. The acft then entered a spin and impacted the…NTSB DEN88DQA02Accident · Minor injuriesFinal reportShiner Pitts S-1S · Los Lunas, NMThe plt reported that the tailwheel steering chain broke during the landing rollout. When the acft slowed to about 30 KTS the rudder was no longer effective and the plt was unable to control direction by use of the brakes. The acft turned to the lt and ran…NTSB DEN87LA175Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Nimbus II · Hobbs, NMThe pvt plt was flying in a national soaring contest. The glider was towed to 2000 feet AGL and released. The plt reported making a climbing right turn after release, however he noticed that the control stick was more aft than normal. As the flight…NTSB DEN87LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lordsburg, NMWhile en route on a x-country flt, a severe eng vibration began. The plt reduced power & slowed the airspeed to reduce the severity of the vibration. Subsequently, he elected to make a wheels-up landing on rocky desert terrain. After landing, he discovered…NTSB DEN86LA105Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Aztec, NMPlt and one pax departed eston, saskatchewan at 0600, en route to guaymas, Mexico for a vacation. Acft was refueled in billings, mt at 0900 and at grand junction, CO. Plt checked wx, filed VFR flight plan and departed grand junction at 1430, en route to…NTSB DEN86FA023Accident · Serious injuriesField investigationFinal reportBeech A45 · Albuquerque, NMWhile maneuvering to enter traffic at alameda arpt, the plt experienced severe acft vibrations. He attempted but was not able to reach the arpt due to rapid loss of airspeed andaltitude. The acft crashed 1/2 mile from the landing rwy. The one pax and a…NTSB DEN85LA173Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Deming, NMThe plt told FAA he was spraying a cotton field and was turning around from a swath run when the propeller feathered. The plt told NTSB that the acft 'pitched upward and lost power.' Acft type certificate shows that a hamilton standard propeller m/n…NTSB LAX85IA206Incident · No injuriesIncident investigationFinal reportBoeing 727-227 · Las Cruces, NMWhile cruising at flt level 350 in clear smooth air, a loud noise was heard, accompanied by a severe jolt on the right side of the cabin, as the number 3 end separated from its mounts. Subsequent investigation disclosed that the forward lavatory was leaking…NTSB MKC85LA075Accident · No injuriesLimited investigationFinal reportBeech V35B · Anton Chico, NMPilot stated that he was on a VFR no-flight-plan-flight from meade, KS, to alburquerque, NM, when he saw a cloud bank ahead. While diverting around, he flew into haze that became clouds. Recovery from strong down and up drafts did substantial damage to wings,…NTSB DEN85FA008Accident · 3 fatalField investigationFinal reportCessna 195A · Santa Fe, NMWhile en route, the transponder was inop & the plt lost radio contact with ARTCC 2 times. As he apchd the destn (Santa Fe), instructions were relayed via another acft. When asked what type apch he wanted, the plt responded, 'well if they can get me lower,…NTSB DEN84IA157Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Albuquerque, NMWhen gear was lowered for landing rt main gear would not extend although persons on the ground stated the gear doors appeared open. Remedial action by the flt crew did not rectify the situation and a gear up landing was performed. When acft was raised from…NTSB DEN84LA124Accident · No injuriesLimited investigationFinal reportBell 206B · Farmington, NMWhile climbing, there was a heavy smell of fuel. At aprx 150 ft AGL on a precautionary landing, the eng quit. The helicopter impacted hard, collapsing the skids, & the main rotor blades sheared of the tail boom. During an investigation, the fuel hose b-nut…NTSB DEN84LA080Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Santa Fe, NMThe plt noticed the throttle sticking on takeoff and tried to abort the takeoff but the throttle was binding. The acft tookoff at a below normal speed and had to be landed. Subsequently, the acft impacted the ground & several trees. An engineer said the…NTSB FTW84LA113Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Albuquerque, NMThe pilot made an emergency landing after a total power loss. Prior to the total loss there had been approximately four drops in manifold pressure. The gear collapsed on landing, bending the engine mounts & both wing spars. The subsequent investigation…NTSB FTW83LA156Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Ramon, NMThe flt departed Oklahoma city, ok with en route stops planned at amarillo, TX tucumcari, NM. At tucumcari, the occupants found themselves 'staggering a little' & concluded this was from exposure to hi alt (en route 6500 ft, tucumcari, 4065 ft). After…NTSB FTW83LA122Accident · No injuriesLimited investigationFinal reportMonnett Sonerai II · Las Cruces, NMThe new home built acft had only 2.5 hrs total flt time. After a test flt, the plt was on the landing roll when he lost control at aprx 35 mph. Subsequently, the acft ground looped & nosed over on its top. The plt reported that loss of control occurred after…