NTSB investigations, NM

79 cases where the sequence of events included Loss of control on ground.

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'
    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.

NTSB CEN15CA058Accident · Serious injuriesData collectionFinal reportMccrary Bobby C JR RV 4 · Los Lunas, NMThe pilot inadvertently applied the left brake during the landing roll which resulted in a loss of directional control and subsequent impact with terrain.Nov 21, 2014 · N639JH · Substantial damageNTSB 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.Dec 7, 2013 · N220JE · Substantial damageNTSB 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.Sep 7, 2013 · N561AT · Substantial damageNTSB CEN13LA243Accident · Minor injuriesLimited investigationFinal reportCessna 195B · Albuquerque, NMThe pilot’s failure to maintain directional control during the landing roll.Apr 28, 2013 · N4420C · Substantial damageNTSB 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.Apr 20, 2013 · N6955E · Substantial damageNTSB 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.Mar 29, 2013 · N7714A · Substantial damageNTSB CEN12CA429Accident · Minor injuriesData collectionFinal reportCessna 190 · Anthony, NMThe pilot’s failure to maintain directional control during the landing roll.Jul 9, 2012 · N190W · Substantial damageNTSB CEN12CA024Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Moriarty, NMThe pilot's failure to maintain control of the airplane during the landing roll.Oct 16, 2011 · N415WW · Substantial damageNTSB CEN11CA423Accident · No injuriesData collectionFinal reportHendricks George David JR RV8 · Angel Fire, NMThe pilot's loss of directional control during landing.Jun 24, 2011 · N678VR · Substantial damageNTSB CEN11CA408Accident · No injuriesData collectionFinal reportCessna TU206G · Truth or Consequences, NMThe pilot's inability to control the airplane on take off.Jun 18, 2011 · N735JY · Substantial damageNTSB CEN11CA395Accident · No injuriesData collectionFinal reportNelson Dan H LONG-EZ · Moriarity, NMThe pilot's failure to maintain directional control during the landing.Jun 14, 2011 · N81DN · Substantial damageNTSB CEN11CA354Accident · No injuriesData collectionFinal reportHenry Slosing Lanceair · Albuqurque, NMThe pilot’s loss of directional control while landing in gusty conditions.May 21, 2011 · N79BC · Substantial damageNTSB CEN11CA233Accident · No injuriesData collectionFinal reportMaule M-4-220C · Albuquerque, NMThe pilot's failure to maintain control of the airplane during landing, which resulted in a runway excursion.Mar 17, 2011 · N4550R · Substantial damageNTSB CEN11CA137Accident · No injuriesData collectionFinal reportBellanca 1419 · Clovis, NMThe pilot's failure to maintain directional control of the airplane during landing.Jan 2, 2011 · N8516R · Substantial damageNTSB CEN11CA026Accident · No injuriesData collectionFinal reportCessna 180 · Farmington, NMThe failure of the pilot and the flight instructor to maintain directional control of the airplane during a training maneuver.Oct 10, 2010 · N9277C · Substantial damageNTSB CEN10LA475Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Silver City, NMThe pilot's loss of directional control during takeoff and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.Aug 11, 2010 · N4546E · Substantial damageNTSB CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.Aug 11, 2010 · N4492 · Substantial damageNTSB CEN10CA407Accident · No injuriesData collectionFinal reportAeronca 7AC · Santa Fe, NMThe pilot's failure to maintain directional control of the airplane while landing with gusting winds.Jul 10, 2010 · N84723 · Substantial damageNTSB CEN10CA375Accident · No injuriesData collectionFinal reportPiper PA32 · Albuquerque, NMThe pilot's failure to maintain directional control of the airplane during takeoff.Jul 6, 2010 · N106C · Substantial damageNTSB CEN09CA433Accident · No injuriesData collectionFinal reportAero Commander 680-F · Angel Fire, NMThe pilot's failure to maintain directional control during the initial takeoff.Jul 11, 2009 · N70QT · Substantial damageNTSB CEN09CA362Accident · No injuriesData collectionFinal reportAirborne Windsports PTY XT-912 · Alamogordo, NMThe failure of the pilot to maintain directional control while landing with gusting winds.Jun 15, 2009 · N594VZ · Substantial damageNTSB CEN09CA301Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Las Cruces, NMThe pilot's failure to maintain directional control while landing in a crosswind. Contributing to the accident was the pilot's decision to land on a runway with a prevailing crosswind.May 17, 2009 · N8042D · Substantial damageNTSB CEN09CA293Accident · No injuriesData collectionFinal reportCessna 170B · Roswell, NMThe pilot's failure to maintain directional control while landing.May 13, 2009 · N3210A · Substantial damageNTSB CEN09CA235Accident · No injuriesData collectionFinal reportCessna 210 · Angel Fire, NMThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot's decision to take off on an icy runway with high crosswinds.Mar 23, 2009 · N59287 · Substantial damageNTSB CEN09CA101Accident · No injuriesData collectionFinal reportCessna T210L · Santa Fe, NMThe pilot's decision to land in gusty crosswinds, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.Dec 24, 2008 · N732DK · Substantial damageNTSB CEN09CA018Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-105 · Albuquerque, NMThe pilot's failure to maintain control of the balloon during landing. Contributing to the accident were the wind gusts.Oct 7, 2008 · N808SP · No damageNTSB DEN08CA136Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Dexter, NMThe pilot's failure to maintain directional control of the airplane.Aug 9, 2008 · N4555Y · Substantial damageNTSB DFW08CA113Accident · No injuriesData collectionFinal reportPiper PA-18 · Santa Teresa, NMThe pilot's failure to maintain aircraft control. Contributing to the accident was the strong gusty crosswinds.Apr 23, 2008 · N1588P · Substantial damageNTSB DEN08CA051Accident · No injuriesData collectionFinal reportPiper PA-32-301XTC · Taos, NMThe pilot's excessive airspeed during the approach and loss of control during the landing. Contributing factors were the mountain turbulence and the snowbank.Jan 17, 2008 · N819C · Substantial damage