NTSB investigations, 2006, 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
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\") = 2006
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") = 2006 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 DEN07CA026Accident · Serious injuriesData collectionFinal reportLiberty Aerospace Liberty XL-2 · Albuquerque, NMthe student pilot's improper flare and subsequent improper recovery from a bounced landing resulting in an inadvertent loss of control.NTSB DEN07LA024Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Melrose, NMthe in-flight failure and separation of both tail rotor blades. Contributing factors in this accident were the check pilot interferring with the controls and his failure to relinquish control to the pilot-in-command.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 DEN07LA020Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502A · Deming, NMThe pilot's failure to maintain aircraft control while maneuvering resulting in an inadvertent stall and impact with terrain. A contributing factor was the low airspeed.NTSB DEN07IA021Incident · No injuriesIncident investigationFinal reportBeech P35 · Los Alamos, NMthe failure of both pilots to maintain adequate visual lookout during the visual approach. A contributing factor was the failure of N5368E's pilot to communicate his intentions on the Common Traffic Advisory Frequency.NTSB DEN07CA014Accident · No injuriesData collectionFinal reportChampion 7GCB · Farmington, NMthe pilot's failure to maintain directional control during the landing.NTSB DEN07CA011Accident · Minor injuriesData collectionFinal reportAdams A55S · Albuquerque, NMthe pilot's improper in-flight planning/decision. A contributing factor was the unfavorable wind.NTSB DEN07CA009Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Hope, NMthe pilot's failure to maintain aircraft control. Contributing factors in this accident included the sudden wind shift and high density altitude, resulting in the helicopter settling with power, and the high vegetation.NTSB DEN07FA003Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Tucumcari, NMThe pilot's failure to maintain aircraft control during aerobatic flight, resulting in an inadvertent accelerated stall. Contributing factors include the low altitude for recovery from the loop and the high density altitude.NTSB DEN06LA113Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Santa Fe, NMthe pilot's improper decision to continue the attempted takeoff when Vx airspeed was not obtained, and failure to abort the takeoff during ground roll which resulted in an impact on the remaining runway with the landing gear retracted. A contributing factor…NTSB DEN06CA108Accident · Serious injuriesData collectionFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMfuel exhaustion, resulting in the pilot's inability to relight one of two burners, and resulting in a hard landing.NTSB DEN06LA103Accident · 1 fatalLimited investigationFinal reportAyres S2R-G10 · Dexter, NMThe pilot's failure to remain clear of the airplane's propeller resulting in the propeller contacting the pilot and causing fatal injuries to the pilot.NTSB DEN06LA096Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Taos, NMthe loss of tail rotor effectiveness during landing, and the pilot's delayed remedial action to counteract a right yaw, which resulted in a loss of directional control and collision with terrain. A contributing factor was the pilot's failure to perform…NTSB DEN06CA082Accident · No injuriesData collectionFinal reportCessna 182R · Albuquerque, NMthe pilot's failure to maintain directional control of the airplane after landing.NTSB DEN06CA079Accident · Serious injuriesData collectionFinal reportCessna T210N · Santa Fe, NMthe loss of engine power due to fuel exhaustion. Contributing factors were the pilot's inadequate preflight planning and failure to refuel the airplane.NTSB DEN06CA077Accident · No injuriesData collectionFinal reportCessna R172E (T-41C) · Albuquerque, NMthe pilot's failure to maintain aircraft control. A contributing factor was the wind gust.NTSB DFW06TA127Accident · Serious injuriesFinal reportAerospatiale AS350-B3 · Santa Teresa, NMThe flight instructor's improper supervision of the flight which resulted in a hard landing.NTSB DEN06CA069Accident · Serious injuriesData collectionFinal reportAerostar International RX 8 · Albuquerque, NMthe pilot's inability to maintain a proper descent rate due to the high winds, resulting in a hard landing. A contributing factor was the high wind conditions.NTSB DEN06CA064Accident · No injuriesData collectionFinal reportRobinson R-22 · Santa Fe, NMthe pilot's improper preflight planning and his failure to maintain control of the helicopter during takeoff. Factors contributing to the accident were the helicopter exceeding its maximum gross weight for takeoff and the high density altitude.NTSB DEN06LA062Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Hope, NMA loss of engine power due to failed bearings in the turbocharger and the subsequent oil seal failure leading to oil exhaustion. Factors contributing to the accident were the fractured oil seal and the road sign.NTSB DEN06LA058Accident · No injuriesLimited investigationFinal reportEldredge NXT · Glenwood, NMthe loss of engine power due to the partial failure of the crankcase nose seal for undetermined reasons. A contributing factor was the pilot's diminished visibility during the forced landing due to oil on the windscreen, resulting in a runway excursion and…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 DEN06LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Torreon, NMThe jammed magneto drive gear and the fractured camshaft gear, which resulted in the total engine failure. A factor contributing to the accident was the unsuitable dirt road on which the pilot had to force land the airplane.NTSB DEN06LA035Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMthe student pilot's improper flare, resulting in a hard landing. Contributing factors were the flight instructor's inadequate supervision of the pilot, and the dark night light conditions.NTSB DEN06CA031Accident · Minor injuriesData collectionFinal reportCulver Cadet LCA · Alamogordo, NMthe pilot's failure to maintain aircraft control during the departure climb. Contributing factors included the gusty winds and the downdraft.