NTSB investigations, NM
79 cases where the sequence of events included Loss of control on ground.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 5 |
| 2010 | 5 |
| 2011 | 7 |
| 2012 | 1 |
| 2013 | 5 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 5 |
| 2017 | 9 |
| 2018 | 8 |
| 2019 | 5 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 6 |
| 2026 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '230' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 WPR26LA292Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-24-260 · Albuquerque, NMNTSB WPR26LA238Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Angel Fire, NMThe pilot’s loss of directional control during landing with a crosswind.NTSB WPR26LA168Accident · No injuriesClass 4 · LimitedFinal reportCessna 150H · Española, NMThe pilot’s loss of of directional control during landing roll following an encounter with a dust devil.NTSB WPR25LA076Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Los Alamos, NMThe pilot’s failure to maintain airplane control while landing in gusty crosswind conditions.NTSB WPR24LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Grady, NMThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.NTSB WPR24LA175Accident · Minor injuriesClass 4 · LimitedFinal reportDennis T Kirby/Michael B Kirby Murphy Rebel · Edgewood, NMThe pilot’s improper installation of the aileron and flap control systems, which resulted in a loss of directional control during the takeoff roll and subsequent runway excursion.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 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 WPR23LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Santa Teresa, NMThe pilot’s loss of control after encountering a dust devil during landing.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 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 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 WPR22LA095Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Carrizozo, NMThe pilot's failure to maintain directional control during the landing roll.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 WPR21LA355Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Tucumcari, NMThe pilot’s improper landing flare which resulted in a hard and bounced landing.NTSB GAA20CA082Accident · No injuriesData collectionFinal reportCessna 170 · Albuquerque, NMThe pilot receiving instruction's failure to maintain directional control and his inadvertent left brake pedal application during the landing roll, which resulted in a runway excursion and ground-loop.NTSB GAA19CA496Accident · No injuriesData collectionFinal reportCessna TU206 · Regina, NMThe pilot's improper preflight performance planning for a high-density altitude takeoff from a short, dirt airstrip, which resulted in impact with terrain.NTSB GAA19CA355Accident · No injuriesData collectionFinal reportCessna 180 · Santa Fe, NMThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a wing strike.NTSB WPR19LA153Accident · No injuriesClass 3 · LimitedFinal reportCessna 195 · Socorro, NMThe pilot's failure to maintain airplane control while landing with a quartering tailwind.NTSB GAA19CA116Accident · No injuriesData collectionFinal reportBeech 24 · Edgewood, NMThe pilot's improper landing flare, which resulted in hard, bounced landing, loss of directional control, runway excursion, and impact with a fence and terrain during an attempted go-around.NTSB GAA18CA493Accident · Minor injuriesData collectionFinal reportCessna 172 · Silver City, NMThe pilot’s failure to maintain directional control while landing with a quartering tailwind.NTSB GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.NTSB GAA18CA530Accident · No injuriesData collectionFinal reportPiper PA 12 · Edgewood, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA436Accident · Serious injuriesData collectionFinal reportAirborne Windsports PTY Edge XT-912-L · Albuquerque, NMThe pilot’s failure to maintain directional control during landing.NTSB CEN18LA222Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 D · Santa Teresa, NMThe pilot's loss of directional control during landing in gusting crosswind conditions for reasons that could not be determined based on the available information.NTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.NTSB GAA18CA266Accident · Minor injuriesData collectionFinal reportDiven Robert Nieuport 17 · Las Cruces, NMThe pilot’s failure to attain a positive climb rate after takeoff in high-density altitude conditions, which resulted in a collision with terrain.NTSB GAA18CA206Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Edgewood, NMThe pilot’s failure to maintain directional control of the airplane during landing.NTSB GAA17CA580Accident · No injuriesData collectionFinal reportMooney M20K · Los Lunas, NMThe pilot’s improper glidepath during a night approach, which resulted in impact with terrain short of the runway.NTSB GAA18CA036Accident · No injuriesData collectionFinal reportSocata TBM 850 · Las Vegas, NMThe pilot’s inadequate compensation for gusting crosswind conditions during the go-around.NTSB GAA17CA547Accident · No injuriesData collectionFinal reportCessna 180 · Albuquerque, NMThe pilot’s failure to maintain directional control during the takeoff roll in gusting crosswind conditions.NTSB GAA17CA414Accident · No injuriesData collectionFinal reportCessna TU206 · Albuquerque, NMThe pilot’s improper landing flare in gusting wind conditions, which resulted in a porpoised landing.NTSB GAA17CA407Accident · No injuriesData collectionFinal reportGerald Donovan Rans S-16 · Los Lunas, NMThe pilot's failure to maintain directional control during takeoff.NTSB GAA17CA382Accident · No injuriesData collectionFinal reportCessna 170 · Alamogordo, NMThe pilot receiving instruction’s failure to maintain directional control during the landing roll and the flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB GAA17CA357Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Edgewood, NMThe pilot's decision to take off with a gusting tailwind, which resulted in a loss of pitch control during the initial climb and a subsequent hard landing and loss of directional control.NTSB GAA17CA313Accident · No injuriesData collectionFinal reportCessna A185 · Clovis, NMThe pilot’s failure to maintain directional control during the landing roll in gusting crosswind conditions.NTSB GAA17CA284Accident · No injuriesData collectionFinal reportCessna 170 · Taos, NMThe pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA16CA505Accident · No injuriesData collectionFinal reportPiper PA46R · Reserve, NMThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB GAA16CA412Accident · No injuriesData collectionFinal reportCessna 120 · Belen, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a ground loop.NTSB CEN16LA202Accident · No injuriesLimited investigationFinal reportHarry Oas Pitts S1C · Carlsbad, NMThe pilot's failure to maintain directional control while landing in crosswind conditions.NTSB CEN16LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180D · Shiprock, NMThe pilot's failure to maintain directional control after encountering a sudden change in wind direction during the landing roll.NTSB GAA16CA090Accident · No injuriesData collectionFinal reportStinson 108 · Portales, NMThe pilot receiving instruction's improper brake application during the flight instructor's aborted landing, which resulted in a loss of directional control and a runway excursion. Contributing to the accident was the flight instructor's decision to perform…NTSB GAA16CA017Accident · No injuriesData collectionFinal reportCessna 195A · Aztec, NMThe pilot's failure to maintain directional control during landing, which resulted in runway excursion and collision with terrain.NTSB CEN16LA030Accident · Serious injuriesLimited investigationFinal reportAerostar RX8 · Albuquerque, NMThe pilot's delay in deflating the balloon envelope completely after landing, which resulted in a loss of control due to a wind gust.NTSB GAA15CA300Accident · No injuriesData collectionFinal reportCessna 177RG · Aztec, NMThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and an impact with shrubs.NTSB GAA15CA260Accident · No injuriesData collectionFinal reportRocci Martignoni JA30 Superstol · Santa Rosa, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and a ground loop.