NTSB investigations, NM
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WPR24LA128Accident · No injuriesClass 4 · LimitedFinal reportBearhawk 4-Place · Buckhorn, NMThe pilot’s inflight loss of control during landing following an encounter with a wind gust which resulted in a hard landing.NTSB WPR24LA125Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 195B · Portales, NMThe pilot’s decision to take off with a quartering tailwind and his subsequent failure to maintain directional control. Contributing to the accident was the pilot’s improper elevator control inputs during takeoff.NTSB WPR24LA120Accident · No injuriesClass 4 · LimitedFinal reportBeecraft Bonanza · Angel Fire, NMThe pilot's failure to maintain directional control of the airplane during takeoff with a gusting crosswind..NTSB WPR24LA100Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46-500TP · Albuquerque, NMThe pilot’s loss of control during landing due to a flat tire. Contributing to the accident was the pilot’s failure to replace the worn tire in a timely manner.NTSB WPR24LA102Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8E · Truth or Consequences, NMThe pilot’s failure to maintain airplane control during approach and landing that resulted in a runway excursion and subsequent impact with a berm.NTSB WPR24LA063Accident · Minor injuriesClass 3 · LimitedFinal reportBender Thomas G RV-6 · Moriarty, NMA loss of engine power for undetermined reasons.NTSB WPR24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Las Cruces, NMAn encounter with a downdraft during an approach to land, which resulted in a hard landing.NTSB WPR24LA019Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons U S A-315 · Albuquerque, NMThe pilot’s inability to maintain control of the balloon during landing due to unforecasted windshear and turbulent air.NTSB WPR24LA011Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US A-105 · Albuquerque, NMA hard landing to a short field, due to windy conditions and a lack of suitable alternate landing areas, which resulted in a passenger sustaining a broken ankle.NTSB WPR23LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 310Q · Santa Fe, NMThe pilot’s improper landing flare following an unstable approach, which resulted in a hard landing.NTSB WPR23LA337Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 195B · Los Lunas, NMThe pilot’s failure to secure the seat’s position in the seat rail, which resulted in a loss of directional control and nose over.NTSB WPR23LA304Accident · Minor injuriesClass 3 · LimitedFinal reportVan Grouw R / Cantrell L White Lightning · Las Vegas, NMA reported partial loss of engine power during cruise flight for undetermined reasons.NTSB WPR23FA275Accident · 1 fatalClass 3 · FieldFinal reportCessna T310R · Santa Fe, NMA total loss of left engine power as a result of improper installation of the aft-facing crankshaft counterweight retaining rings. Also causal was the pilot’s failure to maintain adequate airspeed following the loss of left engine power, which resulted in the…NTSB WPR23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna R172E · Alamogordo, NMFailure of the pilot to maintain control of the airplane during the landing.NTSB WPR23LA230Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6A · Mimbres, NMThe pilot’s inflight loss of control while landing with wind gusts that resulted in a hard landing and subsequent nose over.NTSB WPR23LA209Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Doo Ajdovscina Virus SW · Santa Fe, NMAn encounter with a downdraft during landing that resulted in a hard landing and the pilot’s loss of control.NTSB WPR23LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Santa Teresa, NMThe pilot’s loss of control after encountering a dust devil during landing.NTSB WPR23LA198Accident · Minor injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · Clovis, NMThe airplane’s uncontrollable descent and forced landing for reasons that could not be determined.NTSB WPR23LA178Accident · No injuriesClass 4 · LimitedFinal reportUniversal Globe GC-1A · Belen, NMThe airplane’s encounter with downdraft on takeoff, which resulted in a loss of control.NTSB WPR23LA152Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-44A · Los Alamos, NMThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion and ground collision.NTSB WPR23FA138Accident · 1 fatalClass 3 · FieldFinal reportAerotrike Cobra · Santa Teresa, NMThe pilot’s exceedance of the aircraft’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR23LA100Accident · No injuriesClass 4 · LimitedFinal reportAeronca 65-CA · Deming, NMThe occupant’s improper throttle movement during the start procedure, which resulted in forward movement and loss of airplane control.NTSB WPR23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Socorro, NMThe pilot’s improper landing flare, which resulted in a hard bounced landing and loss of control in gusting wind.NTSB CEN23LA006Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International S53A · Albuquerque, NMThe pilot’s inability to find a suitable landing area in a critical fuel situation and his decision to land on a highway, which resulted in the balloon impacting a bridge railing and terrain.NTSB WPR23LA002Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 46-350P · Clovis, NMThe pilot’s failure to follow the go-around procedures by prematurely retracting the flaps and not establishing a proper go-around climb speed after attempting to land with a quartering tailwind, resulting in the airplane’s inability to climb.NTSB WPR22LA368Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons Firefly 8B-15 · Las Cruces, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB WPR22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Moriarty, NMThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.NTSB WPR22LA290Accident · No injuriesClass 3 · LimitedFinal reportEADS Socata TBM 700 · Carlsbad, NMThe pilot’s failure to extend the landing gear before landing due to a distraction, which resulted in an impact with the runway.NTSB WPR22LA269Accident · Minor injuriesClass 4 · LimitedFinal reportMiller-Thorp T-18 Tiger · Angel Fire, NMThe pilot’s failure to maintain directional control during the landing roll in gusting wind.NTSB CEN22FA317Accident · 4 fatalClass 3 · FieldFinal reportBell UH-1H · Chapelle, NMThe total loss of engine power due to the fatigue failure of the starter-generator input (zerol) gear which failed due to poor maintenance. Contributing to the accident was the unsuccessful autorotation complicated by the setting sun and high density altitude.NTSB WPR22LA179Accident · No injuriesClass 4 · LimitedFinal reportSparks Ralph A RV8 · Deming, NMThe pilot’s loss of airplane control during takeoff following an encounter with a gust of wind.NTSB WPR22LA178Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Estancia, NMThe pilot’s decision to land on an unsuitable surface which resulted in his loss of aircraft control.NTSB WPR22LA168Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Folsom, NMThe pilot’s failure to maintain airspeed and rotor rpm which resulted in a hard landing.NTSB WPR22FA148Accident · 1 fatalClass 3 · FieldFinal reportTaylorcraft BL-65 · Counselor, NMA loss of control while maneuvering at a high-density altitude in gusty wind conditions.NTSB WPR22LA137Accident · Minor injuriesClass 3 · LimitedFinal reportCzech Sport Aircraft A S Sportcruiser · Lanark, NMThe pilot’s loss of control of the airplane after the inadvertent unlocking and opening of the canopy for reasons that could not be determined based on available evidence.NTSB WPR22LA116Accident · No injuriesClass 4 · LimitedFinal reportLiberty Aerospace Liberty XL-2 · Las Cruces, NMThe airplane’s inability to climb during takeoff due to a degradation of engine performance due to high density altitude. Contributing to the accident was the pilot’s decision to continue the takeoff.NTSB WPR22LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Carrizozo, NMThe pilot's failure to maintain directional control during the landing roll.NTSB WPR22LA059Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Hachita, NMThe pilot’s failure to adequately monitor the environment during a low level operation, which resulted in collision with vegetation.NTSB WPR22FA043Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Carlsbad, NMThe pilot's failure to maintain separation from an FM tower guy wire while on an aerial survey flight.NTSB WPR22LA041Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmington, NMThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.NTSB WPR22LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Belen, NMThe pilot’s failure to maintain directional control during takeoff.NTSB WPR22LA027Accident · No injuriesClass 4 · LimitedFinal reportSanta Fe CCX-2300 · Taos, NMThe pilot’s failure to maintain directional control during a landing roll, which resulted in a ground loop and impact with the ground.NTSB WPR22FA011Accident · 1 fatalClass 3 · FieldFinal reportCessna 175 · Reserve, NMThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot’s reduced forward visibility due to the sun.NTSB WPR22LA010Accident · Serious injuriesClass 4 · LimitedFinal reportRichardson Andrew P RICHARDSON-75 · Alburquerque, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to landing, which resulted in a hard landing and serious passenger injury.NTSB WPR21LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Tucumcari, NMThe pilot’s improper landing flare which resulted in a hard and bounced landing.NTSB WPR21LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Albuquerque, NMThe failure of the nose gear hydraulic flex line, which resulted in a loss of hydraulic fluid which prevented the main landing gear from fully extending and locking into place during landing.NTSB WPR21LA316Accident · No injuriesClass 3 · LimitedFinal reportBeech 77 · Stanley, NMA loss of engine performance due to lead fouling of the lower spark plugs, which resulted in an off airport forced landing.NTSB WPR21LA310Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Fort Sumner, NMThe pilot's failure to maintain adequate clearance from a windmill while maneuvering during an aerial application flight.NTSB WPR21FA242Accident · 5 fatalClass 3 · FieldFinal reportCameron Balloons US O-120 · Albuquerque, NMThe failure of the pilot to maintain adequate clearance from power lines while maneuvering for landing. Contributing to the accident was the pilot’s use of impairing, illicit drugs.NTSB WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.