NTSB investigations, NM
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, newest first
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' 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' 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 CEN14CA164Accident · No injuriesData collectionFinal reportPiper PA 28R-201 · Ruidoso, NMThe pilot's failure to adjust the engine's fuel-air mixture and decision to takeoff in high density attitude conditions which degraded the airplane's performance.NTSB CEN14CA151Accident · No injuriesData collectionFinal reportBellanca 17 30A · Santa Rosa, NMThe pilot's mismanagement of the available fuel supply which resulted in a loss of engine power and subsequent emergency landing.NTSB CEN14CA182Accident · No injuriesData collectionFinal reportCessna 182J · Belen, NMThe pilot's failure to ensure adequate fuel onboard for the intended flight.NTSB CEN14LA107Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · Silver City, NMThe collapse of the landing gear during landing for reasons that could not be determined during postaccident examinations.NTSB CEN14FA077Accident · 2 fatalField investigationFinal reportAviat A-1C-200 · Los Alamos, NMThe pilot’s loss of airplane control while maneuvering after takeoff in gusty wind conditions.NTSB CEN14LA080Accident · No injuriesLimited investigationFinal reportPiper PA46 500TP · Albuquerque, NMThe pilot’s loss of directional control during landing due to his inadequate compensation for the tailwind.NTSB CEN14LA007Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US V 77 · Rio Rancho, NMThe pilot's failure to maintain adequate clearance from power lines on approach to land, resulting in a collision with the wires, a spark, and a subsequent explosion and on-board fire.NTSB CEN14LA005Accident · Serious injuriesLimited investigationFinal reportCameron N105 - NO Series · Albuquerque, NMThe pilot's decision to land the balloon from a high approach altitude due to high winds, which resulted in a hard landing.NTSB CEN13LA571Accident · No injuriesLimited investigationFinal reportCessna 182J · Santa Teresa, NMA loss of engine power for reasons that could not be determined because no anomalies were found during the postaccident engine examination.NTSB CEN13TA535Accident · Minor injuriesFinal reportBell 206L-3 · Amistad, NMThe pilot's failure to arrest the descent following an abrupt maneuver to avoid birds, which resulted in an impact with terrain.NTSB CEN13LA541Accident · No injuriesLimited investigationFinal reportCessna 180 · Gallup, NMThe pilot's failure to maintain airplane directional control during the landing roll due to his diverted attention.NTSB CEN13FA517Accident · 3 fatalField investigationFinal reportRobinson R44 II · Caballo, NMThe pilot’s failure to see and avoid power lines while maneuvering near the ground because dust stirred up by the rotor wash obscured his visibility.NTSB CEN13LA507Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Clayton, NMThe pilot's loss of vertical control after the helicopter encountered a gusty tailwind while maneuvering at a low altitude and near the helicopter's maximum gross weight.NTSB CEN13CA494Accident · No injuriesData collectionFinal reportGlobe GC-1B · Santa Teresa, NMThe pilot's loss of directional control during the final approach due to an inadvertent encounter with a dust devilNTSB CEN13LA464Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Santa Teresa, NMThe pilot’s failure to maintain clearance from a tree at the completion of an agricultural spray run. Contributing to the accident was the pilot’s decision to accept a high level of risk to spray a small field bordered by multiple obstacles and his fatigue…NTSB CEN13LA409Accident · 1 fatalLimited investigationFinal reportFlight Design Ctsw · Taos, NMThe airplane's unexpected encounter with a dust devil, which resulted in the loss of airplane control.NTSB CEN13CA336Accident · Minor injuriesData collectionFinal reportSchempp-Hirth VENTUS-2B · Corona, NMThe pilot's failure to maintain aircraft control while ridge-soaring in gusty wind conditions.NTSB CEN13LA299Accident · 1 fatalLimited investigationFinal reportPeck Norman O Peck P-1 · Aztec, NMThe pilot’s loss of airplane control during takeoff for reasons that could not be determined because postaccident fire damage precluded a complete examination of the airplane.NTSB CEN13LA273Accident · Serious injuriesLimited investigationFinal reportPhillips Zenith 250 · Taos, NMThe pilot’s improper decision to take off in gusting wind conditions and the airplane’s loss of climb performance following an encounter with turbulence and downdrafts.NTSB CEN13LA243Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Albuquerque, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN13CA234Accident · No injuriesData collectionFinal reportCessna 175A · Albuquerque, NMThe pilot’s inability to maintain airplane control during taxi due to an inadvertent encounter with a dust devil.NTSB CEN13CA223Accident · No injuriesData collectionFinal reportCessna 180 · Roswell, NMThe pilot's failure to maintain directional control on the landing roll after encountering a gust of wind, which resulted in a ground loop.NTSB CEN13LA194Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Eagle Nest, NMA total loss of engine power due to a rapid throttle change during autorotation, which the flight instructor initiated in response to a low rotor rpm warning, which resulted from the separation of one of the magnets used to provide rotor rpm indications from…NTSB CEN13FA183Accident · 4 fatalField investigationFinal reportMooney M20E · Angel Fire, NMThe pilot's loss of control while flying in a turbulent mountain-wave environment. Contributing to the accident was the pilot's overconfidence in his ability to safely pilot the airplane in gusting wind conditions and his lack of experience operating in…NTSB CEN13LA179Accident · 1 fatalLimited investigationFinal reportCessna 150M · Deming, NMThe pilot's physical incapacitation, including loss of vision, which led to a loss of control and the subsequent in-flight breakup of the airplane.NTSB CEN13LA158Accident · No injuriesLimited investigationFinal reportBell 206B III · Ponderosa, NMA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN13CA134Accident · No injuriesData collectionFinal reportMooney M20C · Moriarty, NMThe pilot’s improper fuel management, which resulted in a loss of engine power during cruise flight due to fuel starvation.NTSB CEN13LA110Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 (T42A) · Las Cruces, NMThe pilot's failure to properly manage the airplane's fuel, which resulted in engine failure due to fuel starvation.NTSB CEN13CA019Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Portales, NMThe pilot’s failure to maintain clearance from power lines during an aerial application flight.NTSB CEN13LA032Accident · Minor injuriesLimited investigationFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to attain the desired touchdown point because of wind conditions and surrounding obstructions, which resulted in the balloon impacting a fence during the approach to landing.NTSB CEN13CA035Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 90A · Albuquerque, NMThe balloon pilot's encounter with higher-than-expected wind velocity, which resulted in a hard landing and passenger injury.NTSB CEN13CA018Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 90A · Albuquerque, NMThe passenger’s inadequate brace position for the balloon landing, which resulted in a serious injury.NTSB CEN12CA673Accident · Minor injuriesData collectionFinal reportDavis Mark Davis KR-1 · Albuquerque, NMThe loss of control during landing/flare resulting from the pilot's decision to land in high wind conditions. Contributing to the accident was the gusting wind and sudden wind shift during a critical phase of landing.NTSB CEN12LA659Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 210S · Albuquerque, NMThe failure of the balloon envelope parachute vent to properly seat, which resulted in the uncontrolled descent of the balloon. The reason the vent did not properly seat during the accident flight could not be determined because the vent operated properly…NTSB CEN12CA496Accident · No injuriesData collectionFinal reportBlack Donald Cozy III · Los Lunas, NMA loose oil line, which allowed oil to leak onto the hot engine turbocharger and resulted in a fire.NTSB CEN12CA429Accident · Minor injuriesData collectionFinal reportCessna 190 · Anthony, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN12LA427Accident · Serious injuriesLimited investigationFinal reportMurray Richard F Aircam BY Lockwood · Taos, NMThe pilot's decision to fly in gusty wind conditions at low altitude over mountainous terrain contrary to guidance in the airplane flight manual and subsequent loss of airplane control due to wind and turbulence.NTSB CEN12LA387Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Teresa, NMThe pilot’s failure to ensure that the landing gear was down and locked before landing.NTSB CEN12LA359Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Teresa, NMThe sudden decrease in headwind during takeoff in a gusty wind and near a passing train, which resulted in a loss of lift and main rotor rpm. Contributing to the accident was the pilot's decision to operate the helicopter near its maximum performance…NTSB CEN12FA291Accident · 1 fatalField investigationFinal reportBeech V35B · Las Vegas, NMThe pilot’s loss of airplane control for reasons that could not be determined because postaccident examination revealed no evidence of preimpact anomalies that would have precluded normal operation.NTSB CEN12LA289Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Grants, NMThe loss of engine power due to an excessively rich fuel mixture that occurred during operations at idle power settings at a high density altitude. Contributing to the accident was the flight instructor’s poor decision-making in choosing to practice an…NTSB CEN12LA265Accident · Minor injuriesLimited investigationFinal reportJonker Sailplanes CC JS 1B · Clines Corner, NMThe fatigue failure of the rudder cable due to the inadequate design of the rudder pedal system.NTSB CEN12LA261Accident · No injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe partial loss of engine power due to an intake valve that was stuck in the open position.NTSB CEN12FA174Accident · 2 fatalField investigationFinal reportHemp Timothy Legacy 2000 · Belen, NMThe pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…NTSB CEN12CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Angle Fire, NMThe pilot did not maintain control of the airplane during the takeoff in gusting crosswind conditions.NTSB CEN12CA121Accident · No injuriesData collectionFinal reportButler John R SX 300 · Truth or Consequences, NMThe pilot did not maintain airplane control during takeoff due to his distraction with the improperly secured canopy, which he forgot to latch.NTSB CEN12FA090Accident · 2 fatalField investigationFinal reportCessna 182R · Mescalero, NMThe pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.NTSB CEN12CA024Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Moriarty, NMThe pilot's failure to maintain control of the airplane during the landing roll.NTSB CEN11FA652Accident · 2 fatalField investigationFinal reportConcannon Milton Radial ROC · Socorro, NMThe pilot's failure to maintain adequate airspeed during the visual approach to the runway, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s lack of experience in the airplane make and model and the possible sedating…NTSB CEN11LA648Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Ocate, NMThe pilot’s failure to apply carburetor heat, which resulted in the formation of carburetor ice and a partial loss of engine power.