NTSB investigations, 1992, NM
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 1992
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") = 1992 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 FTW93LA037Accident · Serious injuriesLimited investigationFinal reportColgate, Henry A. FS21000 · Albuquerque, NMThe loss of engine power for undetermined reasons. Factors were the low altitude and unsuitable terrain.NTSB DEN93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB FTW93LA021Accident · No injuriesLimited investigationFinal reportCessna 177B · Las Cruces, NMThe pilot's delayed landing flare and the improper bounced landing recovery. A factor was the dark night.NTSB FTW93LA013Accident · Minor injuriesLimited investigationFinal reportBeech V35E · Laguna, NMFailure of the pilot to select the proper fuel tank and resultant fuel starvation power loss. A factor was the unsuitable terrain.NTSB FTW93LA010Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe pilot's failure to maintain visual lookout.NTSB FTW92LA235Accident · No injuriesLimited investigationFinal reportErcoupe 415-G · Gallup, NMThe instructor pilot's lack of familiarity with the performance capability of the aircraft. Factors were the rising terrain and high density altitude.NTSB FTW92LA234Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Roswell, NMThe pilot failed to maintain the correct airspeed on final approach and allowed the aircraft to stall.NTSB FTW92LA233Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Santa Fe, NMPilot's failure to compensate for the crosswind. A factor was the crosswind.NTSB FTW92LA221Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Angel Fire, NMThe pilot's inadequate evaluation of the environmental conditions which resulted in exceeding the climb capability of the aircraft. The inadvertent stall was also a cause. Factors were the downdraft and high density altitude.NTSB DEN92LA087Accident · No injuriesLimited investigationFinal reportCessna 172F · Folsom, NMCarburetor heat not used and improper use of throttle and mixture control. A factor was: the lack of suitable terrain for a forced landing.NTSB FTW92LA217Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Farmington, NMTotal loss of engine power due to carburetor ice and the pilot's delayed use of carburetor heat. A factor was unsuitable terrain.NTSB DEN92FA078Accident · 2 fatalField investigationFinal reportCessna 337A · Ruidoso, NMThe pilot experiencing spatial disorientation and the resultant excessive descent rate. Factors were: the dark night conditions.NTSB FTW92LA190Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Clovis, NMEngine failure due to improper oil filter installation and subsequent improper aircraft control by the PIC which resulted in a stall. A factor was maintenance inspection not performed after the oil filter installation.NTSB DEN92LA069Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Pecos, NMAn encounter with high winds.NTSB DEN92FA064Accident · 6 fatalField investigationFinal reportMitsubishi MU-2B-30 · Alamagordo, NMThe failure of the pilot to exercise adequate VFR departure terrain avoidance procedures, and the failure of the controller to issue a safety alert to the pilot. Factors which contributed to the accident were: the pilot's lack of familiarity with the…NTSB FTW92LA164Accident · No injuriesLimited investigationFinal reportCessna 320D · Aztec, NMFailure of the right propeller to feather and inoperative gear retraction system. Factors were the high density altitude and the power loss due to connecting rod failure.NTSB FTW92GA157Accident · 1 fatalFinal reportHughes OH-6A · Sunland Park, NMThe pilot's failure to see and avoid the wires.NTSB FTW92DQA02Accident · Serious injuriesFinal reportFantasy Sky Promotions AX-7 · Rio Rancho, NMThe pilot's improper inspection of the balloon following removal of two of the fuel tanks which resulted in vented fuel due to a fuel line being left loose and a fuel valve locked open.NTSB FTW92LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Truth Or Cons, NMThe pilot's inability to stop due to worn brakes and low brake fluid.NTSB FTW92GA111Accident · 1 fatalFinal reportPiper PA-32R-301T · Albuquerque, NMFuel line failure due to vibratory fatigue. Factors were improper maintenance, manufacturer information for fuel line not available, and the pilots' failure to follow emergency procedures.NTSB FTW92FA099Accident · 1 fatalField investigationFinal reportRockwell 690A · Taos, NMThe pilot in command's failure to maintain the climb after departing the runway environment. Factors were the weather conditions and the dark night.NTSB FTW92LA087Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Santa Fe, NMThe pilot's failure to maintain directional control during the takeoff roll phase of a touch and go.NTSB DEN92LA038Accident · No injuriesLimited investigationFinal reportThorpe T-18 · Albuquerque, NMA failure of the rudder control system when the pilot attempted to correct for an inadvertent ground loop during landing roll.NTSB FTW92DQA01Accident · 1 fatalFinal reportAir Trans. White Lightning · Aztec, NMThe inadvertent stall and the pilot's lack of experience in the accident aircraft.NTSB FTW92LA060Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe pilot in command failed to properly monitor the fuel consumption rate of the airplane when he perceived that it might be higher than normal. The engine failure was a result of fuel exhaustion, aggravated by possible fuel siphoning from the tanks.NTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.