NTSB investigations, NM
133 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 10 |
|---|---|
| 1983 | 5 |
| 1984 | 6 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 7 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 5 |
| 1992 | 4 |
| 1993 | 5 |
| 1994 | 4 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 5 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 7 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 4 |
| 2007 | 5 |
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\" = 260)
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" = 260) 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 DEN08CA034Accident · No injuriesData collectionFinal reportGodwin, David P Sorrell SNJ-7 · Belen, NMthe pilot's loss of directional control during landing resulting in a ground loop.NTSB DEN07CA161Accident · No injuriesData collectionFinal reportCessna 182P · Santa Rosa, NMThe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB DEN07CA088Accident · No injuriesData collectionFinal reportAcro Sport Acroduster II SA750 · Albuquerque, NMThe pilot's failure to maintain directional control during the landing roll.NTSB DEN07CA084Accident · No injuriesData collectionFinal reportCessna 180C · Santa Fe, NMExceeding the airplane's maximum demonstrated crosswind component during the takeoff roll. A contributing factor was the crosswind.NTSB DEN07CA065Accident · Minor injuriesData collectionFinal reportOgden Aubrey D BD-4 · Moriarty, NMThe pilot's failure to maintain aircraft control during the landing.NTSB DEN07CA023Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Santa Fe, NMthe pilot's failure to maintain directional control during the landing roll, and his failure to maintain airspeed which resulted in a stall and hard landing.NTSB DEN07FA022Accident · 1 fatalField investigationFinal reportCessna 337C · Alamogordo, NMThe pilot's incapacitation due to a heart attack while landing, which resulted in a loss of control and an on ground collision with objects.NTSB DEN07CA014Accident · No injuriesData collectionFinal reportChampion 7GCB · Farmington, NMthe pilot's failure to maintain directional control during the landing.NTSB DEN06CA047Accident · Minor injuriesData collectionFinal reportBoeing D75N1 · Santa Teresa, NMthe pilot's failure to maintain directional control during the landing. Contributing factors include the high airspeed, the improper recovery from a bounced landing, the crosswind, and the soft dirt.NTSB DEN06CA027Accident · No injuriesData collectionFinal reportMaule M-7-235 · Moriarty, NMthe pilot's failure to maintain directional control during the landing. Contributing factors included the pilot's inadequate in-flight decision making and the high velocity, gusty winds.NTSB DEN06CA025Accident · Serious injuriesData collectionFinal reportTaylorcraft BC12-D · Los Lunas, NMthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground loop.NTSB DEN05CA122Accident · No injuriesData collectionFinal reportStinson L-5G · Gallup, NMan on-ground loss of control due to the flight controls becoming jammed because the pilot failed to properly secure his flight bag.NTSB DEN05CA040Accident · No injuriesData collectionFinal reportDaniels Vans RV-8 · Albuquerque, NMthe pilot's failure to maintain directional control resulting in a ground loop.NTSB DEN05LA028Accident · No injuriesLimited investigationFinal reportFarrell Lancair LC3 · Las Cruces, NMthe pilot's failure to maintain directional control during takeoff.NTSB DEN05CA021Accident · No injuriesData collectionFinal reportTemco GC-1B · Angel Fire, NMthe pilot's failure to maintain directional control and his inadequate compensation for wind. Contributing to the accident was the crosswind.NTSB DEN05CA016Accident · No injuriesData collectionFinal reportCessna 152 · Santa Teresa, NMthe student pilot' failure to maintain directional control during the takeoff roll. Contributing to the accident was the student pilot's failure to abort the takeoff.NTSB DEN04CA062Accident · No injuriesData collectionFinal reportCessna 180A · Las Vegas, NMthe pilot's decision to takeoff in wind conditions that consisted of a quarterly tailwind and a crosswind in excess of the maximum demonstrated crosswind component, and his failure to maintain directional control.NTSB DEN04LA022Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Truth or Conseq, NMthe pilot's inadequate flare and his failure to maintain directional control. A contributing factor was the night light conditions.NTSB DEN03LA151Accident · No injuriesLimited investigationFinal reportWaco YMF-5 · Taos, NMthe pilot's failure to maintain directional control during landing roll which resulted in the subsequent ground loop/swerve and impact with the ditch.NTSB DEN03LA135Accident · No injuriesLimited investigationFinal reportCessna A185F · Angel Fire, NMthe instructor's inadequate supervision which resulted in the pilot's loss of directional control and the subsequent impact with the ditch. Contributing factors include the instructor's inadequate remedial action and the inadvertent ground loop/swerve.NTSB DEN03LA084Accident · No injuriesLimited investigationFinal reportNorth American SNJ-6 · Albuquerque, NMthe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors include, the pressures induced on the pilot by the landing conditions and the asphalt walkway on the side of the runway.NTSB DEN03LA064Accident · No injuriesLimited investigationFinal reportCessna 182G · Truth or Conseq, NMthe pilot's failure to maintain directional control during landing roll which resulted in impact with terrain. Contributing factors include, the pilot's improper in-flight planning/decision making, the crosswind and gusty wind conditions, the ditch, and the…NTSB DEN03LA060Accident · No injuriesLimited investigationFinal reportCessna 170A · Hobbs, NMthe pilot's failure to maintain aircraft directional control during takeoff roll. A factor was the runway light's cement foundation.NTSB FTW02LA212Accident · No injuriesLimited investigationFinal reportCessna 190 · Albuquerque, NMThe pilot's failure to maintain aircraft control. A contributing factor was the crosswind.NTSB FTW02LA170Accident · No injuriesLimited investigationFinal reportCessna 172E · Navajo Dam, NMthe pilot's failure maintain directional control of the airplane during a touch and go landing which resulted in a collision with trees. A contributing factor was the gusting wind conditions.NTSB FTW02LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Teresa, NMthe pilot's inadequate compensation for the gusty crosswind conditions resulting in a loss of control of the airplane during the landing. A contributing factor was the gusty crosswind.NTSB FTW02LA115Accident · No injuriesLimited investigationFinal reportCessna 172S · Angel Fire, NMThe pilots failure to maintain directional control during the crosswind landing. A contributing factor was the gusting wind condition.NTSB DEN01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Deming, NMthe pilot's failure to maintain aircraft control during takeoff roll. A contributing factor was the gusting crosswind weather condition.NTSB DEN01LA097Accident · Minor injuriesLimited investigationFinal report1977 Colfer-Chan Steen Skybolt · Gallup, NMthe pilot's failure to maintain directional control during landing roll. Contributing factors were gusting crosswinds and the pilots's lack of experience in aircraft make and model.NTSB DEN01LA086Accident · Minor injuriesLimited investigationFinal reportBellanca 1731A · Hobbs, NMthe pilot's failure to maintain directional control during flare/landing.NTSB DEN01LA080Accident · No injuriesLimited investigationFinal reportFox Pegazair 100 · Angel Fire, NMthe pilot's failure to maintain directional control during takeoff. A contributing factors was the gusty crosswind condition.NTSB DEN01LA079Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Las Vegas, NMthe pilot's failure to maintain directional control during landing roll. Factors were weather evaluation by the pilot and rough terrain off the side of the runway.NTSB FTW01LA075Accident · No injuriesLimited investigationFinal reportCessna 172F · Clovis, NMthe pilot's failure to maintain directional control during take off roll resulting in a ground loop. A contributing factor was the crosswind.NTSB DEN01LA049Accident · No injuriesLimited investigationFinal reportCessna 180K · Clovis, NMThe pilot's failure to maintain directional control, which resulted in the subsequent swerve of the airplane. Contributing factors were the pilot's lack of experience in make and model and his diverted attention while attempting to adjust the trim.NTSB DEN00LA168Accident · No injuriesLimited investigationFinal reportCessna A185F · Ruidoso, NMthe pilot's failure to maintain directional control during landing roll. A contributing factor was the crosswind weather condition.NTSB DEN00LA140Accident · No injuriesLimited investigationFinal reportCessna A188 · Gallup, NMThe pilot's failure to compensate for the wind conditions. Factors were the pilot's selection of the wrong runway, and the tailwind/crosswind weather conditions.NTSB DEN00LA123Accident · No injuriesLimited investigationFinal reportBeech G18S · Taos, NMFailure of the pilot receiving instruction to maintain directional control. Factors were a gusty crosswind, inadequate supervision by the flight instructor, and the runway light.NTSB FTW00LA139Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Socorro, NMThe pilot's failure to maintain directional control during the aborted takeoff, which resulted in an inadvertent groundloop.NTSB DEN00LA068Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Las Cruces, NMThe pilot's failure to maintain directional control, resulting in an inadvertent ground loop/swerve. Factors were a burnt and unseated intake valve, and the tail wind.NTSB DEN00LA012Accident · No injuriesLimited investigationFinal reportBeech B-60 · Angel Fire, NMThe pilot's failure to maintain aircraft control, and the pilot's inadequate decision to attempt the takeoff. Factors were the strong left rear cross wind, and the dirt embankment.NTSB DEN00LA008Accident · No injuriesLimited investigationFinal reportFairchild M62A (PT-19) · Gallup, NMFailure by the pilot in command to maintain control of the aircraft during landing roll. Factors were a lack of experience of either pilot in kind and type of aircraft.NTSB DEN00LA003Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Las Cruces, NMThe pilot's inadvertent ground loop/swerve during landing. A factor was his attention being diverted by a malfunctioning throttle control.NTSB DEN99LA098Accident · No injuriesLimited investigationFinal reportNorth American SNJ-4 · Belen, NMEncounter with soft unsuitable terrain when the aircraft departed the side of the runway during landing roll due to binding in the right main landing gear wheel assembly. A factor was the binding in the main landing gear.NTSB DEN99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMThe pilot's excessive use of rudder while attempting to correct for loss of directional control. Factors were the pilot's loss of directional control, and his lack of experience in the type of airplane.NTSB FTW98LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · Albuquerque, NMThe pilot's failure to maintain control of the aircraft during landing roll. A factor was crosswind.NTSB FTW98LA251Accident · No injuriesLimited investigationFinal reportCessna 170B · Los Alamos, NMThe pilot's inadequate compensation for the wind conditions. Contributing factors were the crosswinds, the fence, and the ditch.NTSB FTW98LA219Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albuquerque, NMThe flight instructor's failure to maintain directional control of the aircraft. Factors were crosswind, high wind conditions, insufficient demonstrated crosswind component information provided by the manufacturer, and insufficient aircraft…NTSB FTW98LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Related factors were: the gusty crosswind condition, icy runway, and proximity of the snowbank.NTSB FTW98LA020Accident · No injuriesLimited investigationFinal reportCessna 180J · Chama, NMthe pilot's failure to maintain directional control of the airplane during its landing roll. Encounter with an embankment (dirt bank) was a related factor.NTSB FTW97LA315Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Gila, NMthe pilot's impairment of judgment and performance due to alcohol, and his failure to maintain directional control of the airplane, which resulted in a ground swerve, and collision with vegetation (cactus) and a fence. Related factors were: the soft runway…