NTSB investigations, 1991, NM
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
Latest 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\") = 1991
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") = 1991 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 DEN92LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Glenwood, NMPartial failure of the spark plugs. Factors were inadequate annual inspection and unsuitable mountainous terrain.NTSB DEN92FA016Accident · 1 fatalField investigationFinal reportCessna 210M · Albuquerque, NMInsufficient terrain clearance altitude selected by the pilot in command.NTSB FTW92FA048Accident · 1 fatalField investigationFinal reportCessna 182 · Santa Teresa, NMThe pilot's failure to maintain control. Factors were the dark night, pilot's apprehension, pilot's lack of instrument experience, spatial disorientation, poor instrument location, visual perception and inadequate cockpit lighting.NTSB FTW92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Las Cruces, NMThe pilot's misjudgment of the airplane's performance which led to a situation where it could not climb above the rising terrain. A factor was the high density altitude which existed in the mountains at the time of the accident.NTSB FTW92LA028Accident · No injuriesLimited investigationFinal reportCessna 120 · Las Cruces, NMThe pilot's failure to maintain directional control. A factor was the tailwind.NTSB FTW92LA027Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Fe, NMThe right main gear collapsed for undetermined reasons, which resulted in the pilot's loss of directional control during the landing roll.NTSB FTW92GA036Accident · No injuriesFinal reportBeech C-12C · Belen, NMThe pilot's failure to land at the proper touchdown point.NTSB FTW92LA021Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Teresa, NMThe pilot's failure to initiate corrective action in a timely fashion.NTSB FTW92LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Springer, NMThe pilot's poor judgement in attempting flight into forcasted adverse weather, his disregard for the hazardous weather advisory received which resulted in partial loss of engine power as a result of a blocked induction system due to ice and snow, and the…NTSB FTW92LA019Accident · No injuriesLimited investigationFinal reportCessna 150J · Hatch, NMFuel exhaustion as a result of the pilot's failure to refuel and his poor preflight and inflight planning. Factors were the unsuitable mountainous terrain at the pilot's disposal and the unfavorable winds aloft.NTSB FTW92GA011Accident · No injuriesFinal reportCessna T21OR · Lordsburg, NMThe pilot's improper recovery from a bounced landing. Factors were the pilot's excessive airspeed and improper flare technique.NTSB DEN91LA134Accident · Serious injuriesLimited investigationFinal reportAbernathy LONG-EZ · Raton, NMPhysical impairment of the pilot. Factors were: rough terrain.NTSB DEN91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Santa Fe, NMInadvertent deactivation of aircraft brakes by unqualified person.NTSB DEN91FA130Accident · 3 fatalField investigationFinal reportCessna 182G · Elida, NMThe pilot's improper preflight planning/preparation for the flight and his subsequent flight into instrument meteorological conditions. A factor was: heavy fog and low ceiling.NTSB DEN91FA132Accident · 2 fatalField investigationFinal reportCessna 172N · Tererro, NMA failure of the pilot to maintain adequate obstacle clearance in mountainous terrain. Factors were: lack of familiarity with the aircraft, and insufficient standards by the operator.NTSB DEN91FA127Accident · 2 fatalField investigationFinal reportButler Aerostar 600 · Ruidoso, NMLoss of control in flight after to the cabin door opened inadvertently during takeoff run.NTSB DEN91LA124Accident · No injuriesLimited investigationFinal reportBoeing A 75N1 · Lordsburg, NMUnexpected encounter with adverse wind (downdraft).NTSB DEN91LA123Accident · No injuriesLimited investigationFinal reportCessna A185F · Conchas Dam, NMLanding gear locking mechanism loose, landing gear wheel deployed inadvertently, and maintenance alignment not performed. Factors were: propeller governor underspeed, maintenance adjustment not corrected, and lowering of flaps not performed.NTSB DEN91LA114Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clovis, NMFailure of the pilot to maintain clearance from rising/uneven terrain. Factors related to the accident were: the light conditions at dusk, and the lack of visual cues for the pilot.NTSB DEN91LA105Accident · Minor injuriesLimited investigationFinal reportFink, Charles H. FIN-1 · Albuquerque, NMA failure of the throttle system which prevented the pilot from achieving sufficient power to maintain flight. A factor was: the rough terrain.NTSB DEN91LA102Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Albuquerque, NMThe failure of the right main landing gear tire.NTSB DEN91LA088Accident · No injuriesLimited investigationFinal reportPiper PA-25C-235 · Las Cruces, NMPower loss due to fuel contamination. A factor was: pilot's inadequate airplane preflight.NTSB DEN91LA092Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Albuquerque, NMThe pilot's improper maintenance of the aircraft. Factors were: a loose oil filter and loss of engine oil.NTSB DEN91LA086Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Deming, NMThe pilot's failure to maintain directional control. Factors were: a crosswind condition and a soft shoulder alongside the runway.NTSB DEN91LA081Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Fe, NMThe pilot misjudged the flare during landing.NTSB DEN91LA080Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Santa Fe, NMA forward aft pilot seat adjustment locking mechanism failure.NTSB DEN91LA074Accident · No injuriesLimited investigationFinal reportPitts S-2B · Albuquerque, NMFailure of the pilot of the other airplane to maintain visual lookout.NTSB DEN91LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA18-50 · Lordsburg, NMPilot factor in that he allowed the aircraft to enter an inadvertent stall mush at an altitude insufficient to recover.NTSB DEN91LA062Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Santa Rosa, NMThe pilot of the other aircraft failed to maintain clearance between the aircraft.NTSB DEN91FA051Accident · 2 fatalField investigationFinal reportBeech 58 · Whites City, NMThe pilot's inflight decision to fly at low altitude. Factors were: turbulence and downdrafts.NTSB DEN91FA048Accident · 1 fatalField investigationFinal reportCessna T210M · Taos, NMThe pilot's decision to initiate flight into freezing rain which resulted in structural icing that exceeded the ability of the aircraft to maintain flight. A factor was: improper deicing.NTSB DEN91LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Timberon, NMThe pilot's inadequate preflight planning and selection of the wrong runway. Related factors were: the rising terrain, trees, and the pilot's lack of experience.NTSB DEN91LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Deming, NMPilot failure to maintain airspeed during takeoff climb resulting in a stall and subsequent loss of control of the aircraft. A factor was: the failure of the CFI to adequately supervise the student pilot.NTSB DEN91LA030Accident · No injuriesLimited investigationFinal reportCessna 206A · Carlsbad, NMA loss of control by the pilot during landing roll due to his failure to maintain directional control.