NTSB investigations, 1999, NM
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 per year
| 1964 | 82 |
|---|---|
| 1965 | 88 |
| 1966 | 99 |
| 1967 | 113 |
| 1968 | 99 |
| 1969 | 85 |
| 1970 | 86 |
| 1971 | 79 |
| 1972 | 69 |
| 1973 | 73 |
| 1974 | 74 |
| 1975 | 85 |
| 1976 | 64 |
| 1977 | 89 |
| 1978 | 98 |
| 1979 | 94 |
| 1980 | 68 |
| 1981 | 78 |
| 1982 | 72 |
| 1983 | 46 |
| 1984 | 56 |
| 1985 | 63 |
| 1986 | 41 |
| 1987 | 44 |
| 1988 | 48 |
| 1989 | 36 |
| 1990 | 33 |
| 1991 | 34 |
| 1992 | 26 |
| 1993 | 28 |
| 1994 | 27 |
| 1995 | 41 |
| 1996 | 41 |
| 1997 | 42 |
| 1998 | 43 |
| 1999 | 39 |
| 2000 | 42 |
| 2001 | 36 |
| 2002 | 33 |
| 2003 | 36 |
| 2004 | 29 |
| 2005 | 21 |
| 2006 | 26 |
| 2007 | 36 |
| 2008 | 31 |
| 2009 | 27 |
| 2010 | 27 |
| 2011 | 23 |
| 2012 | 19 |
| 2013 | 23 |
| 2014 | 28 |
| 2015 | 25 |
| 2016 | 18 |
| 2017 | 24 |
| 2018 | 27 |
| 2019 | 20 |
| 2020 | 8 |
| 2021 | 17 |
| 2022 | 16 |
| 2023 | 15 |
| 2024 | 24 |
| 2025 | 16 |
| 2026 | 16 |
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 year(c.\"eventDate\") = 1999
AND 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 year(c."eventDate") = 1999 AND 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 DEN00LA034Accident · Minor injuriesLimited investigationFinal reportPrice Glasair 1-RG · Ruidoso, NMThe failure of the pilot to perform an adequate preflight, and the subsequent partial power loss as a result of water contamination in the fuel. A factor was the lack of suitable terrain for a forced landing.NTSB DEN00LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-31T1 · Santa Fe, NMThe pilot initiating lift off at an airspeed insufficient to maintain flight and retracting the landing gear prematurely resulting in a stall mush. A factor was the pilot incorrectly setting the elevator trim.NTSB DEN00LA027Accident · No injuriesLimited investigationFinal reportCessna 182R · Farmington, NMThe pilot's inadequate preflight planning, and his improper inflight decision to not land and refuel, which resulted in fuel exhaustion.NTSB DEN00FA025Accident · 1 fatalField investigationFinal reportCessna T210L · Elida, NMThe pilot's failure to maintain aircraft control for reasons undetermined. Factors were icing conditions and instrument failure, as reported by the pilot.NTSB DEN00LA015Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Artesia, NMThe pilot's inadequate compensation for the wind conditions.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 DEN00FA007Accident · 1 fatalField investigationFinal reportGardner Varieze · Quemado, NMThe pilot's selection of an unsuitable landing area on which to make a precautionary landing, and his excessive airspeed during landing touchdown. Factors were the ingestion of the foam air filter into the throat of the injector, and the pilot's failure to…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 DEN00LA001Accident · Serious injuriesLimited investigationFinal reportGray Rotorway Exec · Gallup, NMThe pilot inadvertently allowing main rotor rpm to decay while avoiding obstacles during an emergency autorotation following a loss of power for reasons undetermined. Factors were houses and powerlines.NTSB DEN99LA169Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164A · Animas, NMA inadvertent stall during initial climb following takeoff. Factor were: high gross weight, high density altitude, inadequate preflight planning and preparation, and soft terrain.NTSB DEN99LA163Accident · No injuriesLimited investigationFinal reportRobinson R22A · Tucumcari, NMThe pilot's inadequate visual lookout. A factor was a reduced visual detection due to background vegetation and terrain.NTSB DEN99LA174Accident · No injuriesLimited investigationFinal reportCessna P210N · Santa Fe, NMA non-mechanical total loss of engine power for reasons undetermined. Factors were maneuvering to avoid oncoming vehicles, and the rough and uneven terrain.NTSB DEN99LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbus, NMFuel exhaustion because the pilot issued instructions that the fuel tanks not be filled to capacity. A factor was the unsuitable terrain on which to make a forced landing.NTSB DEN99LA151Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Albuquerque, NMThe pilot's failure to follow published procedures in operating the aircraft. A factor was partial failure of the electrical system.NTSB DEN99LA145Accident · No injuriesLimited investigationFinal reportCessna 337 · Edgewood, NMBreakage of the safety wire that secured the propeller control cable to the support bracket. Factors were the inability of the pilot to feather the propeller or change propeller rpm, and rough, uneven, and unsuitable terrain on which to make a forced landing.NTSB DEN99FA137Accident · 1 fatalField investigationFinal reportCessna T210M · Clovis, NMThe pilot's failure to maintain sufficient airspeed during final approach to landing, resulting in an inadvertent stall. A factor was the high density altitude.NTSB DEN99FA142Accident · 1 fatalField investigationFinal reportCessna 172P · Grants, NMThe pilot's failure to fly the aircraft at an altitude sufficient to clear surrounding terrain. Factors were: The pilot's in-flight planning and decision making in proceeding into known adverse weather. Low ceiling, rain, lack of total pilot experience, and…NTSB DEN99LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Edgewood, NMThe pilot's excessive rotation during takeoff, resulting in an inadvertent stall/mush. Factors were the pilot's lack of recent flight experience, and the high density altitude..NTSB DEN99LA127Accident · No injuriesLimited investigationFinal reportCessna T210F · Albuquerque, NMThe pilot's inadvertent wheels up landing.NTSB DEN99FA123Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Magdalena, NMThe pilot's inadvertent flight into adverse weather and the subsequent in-flight breakup. Factors were the pilot's lack of experience in high altitude flying and the thunderstorm.NTSB DEN99LA117Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Ventus B/16.6 · Hobbs, NMThe pilot's inadequate in-flight planning. Factors were the loss of thermal lift, the subsequent stall/spin, and the fence post that he impacted.NTSB DEN99TA099Accident · No injuriesFinal reportCessna A185F · Farmington, NMThe pilot's inadequate visual lookout and failure to see and avoid a ground obstruction. Factors were the throttle linkage becoming disconnected due to an inadequate annual inspection by maintenance personnel, and a dirt berm.NTSB DEN99LA102Accident · No injuriesLimited investigationFinal reportSchweizer SGU-2-22E · Hobbs, NMPilot incapacitation (loss of consciousness) due to dehydration and hyperventilation. Factors were the turbulence and excessive workload (task overload) that induced anxiety/apprehension, and striking the sign and the pole.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 DEN99FA081Accident · 2 fatalField investigationFinal reportPiper PA-23E-250 · Tucumcari, NMThe pilot's inadvertent stall. A factor was the loss of power of one engine in the twin-engine airplane.NTSB DEN99LA078Accident · No injuriesLimited investigationFinal reportBell/Mason RV-6 · Albuquerque, NMThe loss of aircraft control for undetermined reasons. Factors were the sudden wind shift and wind gusts weather condition.NTSB DEN99LA073Accident · Minor injuriesLimited investigationFinal reportDavis RV-6A · Truth Or Cnsqnc, NMA soft runway surface that caused the airplane to nose over.NTSB DEN99LA070Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe pilot's improper mixture control use and the engine's subsequent power loss due to fuel starvation, and the lack of suitable terrain for the pilot to perform a forced landing. Factors were the pilot's lack of recent experience in type of airplane, the…NTSB DEN99LA067Accident · No injuriesLimited investigationFinal reportCessna 172I · Las Cruces, NMThe pilot of N46204's failure to maintain visual lookout and to identify the other aircraft visually during landing.NTSB DEN99FA066Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar 601P · Ruidoso, NMThe pilot's failure to maintain aircraft control for undetermined reason. A factor was the low ceiling IMC weather condition.NTSB DEN99LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dulce, NMThe pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…NTSB DEN99LA060Accident · Minor injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-A1 · Coyote, NMThe pilot-in-command's inadvertent flight into adverse weather, and his continued flight into instrument meteorological conditions. Factors were his failure to obtain an updated recorded weather briefing, the existing weather conditions which included snow,…NTSB DEN99LA055Accident · No injuriesLimited investigationFinal reportCessna 310L · Angel Fire, NMThe pilot's exceeding the airplane's weight and balance limitations. A factor was the high density altitude weather condition.NTSB DEN99LA050Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Santa Rosa, NMThe unfavorable wind gust which inverted the airplane while taxiing.NTSB DEN99LA035Accident · No injuriesLimited investigationFinal reportMooney M20E · Albuquerque, NMThe pilot's failure to maintain aircraft control during takeoff.NTSB DEN99FA034Accident · 3 fatalField investigationFinal reportCessna P210N · Albuquerque, NMTotal failure of the vacuum system, and failure of the pilot to maintain aircraft control, resulting in wing spar failure. Factors were the pilot's spatial disorientation, and his exceeding the design stress limits of the airplane.NTSB DEN99IA033Incident · No injuriesIncident investigationFinal reportBeech E90 · Clovis, NMTotal failure of the elevator control cable due to a short circuit from chafing against an adjoining electrical cable, and failure of maintenance personnel to detect the problem during an AAIP phase inspection.