NTSB investigations, 2008, NM
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2008
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") = 2008 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 CEN09LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Santo Domingo Pueblo, NMA loss of engine power due a loss of oil pressure resulting in heat distress and mechanical failure of the engine. The reason for the loss of oil pressure was not determined.NTSB CEN09CA104Accident · No injuriesData collectionFinal reportMooney M20C · Edgewood, NMA total loss of engine power while at cruise altitude for undetermined reasons.NTSB CEN09CA101Accident · No injuriesData collectionFinal reportCessna T210L · Santa Fe, NMThe pilot's decision to land in gusty crosswinds, leading to his inability to maintain directional control. Contributing to the accident were the crosswinds.NTSB CEN09CA118Accident · No injuriesData collectionFinal reportSocata TBM 700 · Clovis, NMThe pilot's failure to complete the before-landing checklist, which led to his failure to lower the gear before landing.NTSB CEN09CA046Accident · No injuriesData collectionFinal reportHemp Timothy Legacy 200 · Socorro, NMFailure of the pilot to land with sufficient runway to stop the airplane on the runway. Contributing to the accident was the airplane's speed on final approach.NTSB CEN09FA043Accident · 1 fatalField investigationFinal reportCessna 175 · Mt. Dora, NMThe pilot's failure to maintain clearance from rising terrain for undetermined reasons.NTSB CEN09CA011Accident · No injuriesData collectionFinal reportCessna 170 · Santa Fe, NMThe flight instructor's delay in taking timely control of the airplane. Contributing to the accident was the crosswind.NTSB CEN09FA010Accident · 2 fatalField investigationFinal reportMaule MXT-7-180A · Santa Teresa, NMThe pilot's decision to takeoff and fly into a thunderstorm.NTSB CEN09LA009Accident · 1 fatalLimited investigationFinal reportSproul 72K-TET · Rio Rancho, NMThe pilot's failure to maintain clearance from the power lines and the failure of either pilot to take any corrective action to avoid the collision.NTSB CEN09CA018Accident · Serious injuriesData collectionFinal reportCameron Balloons US A-105 · Albuquerque, NMThe pilot's failure to maintain control of the balloon during landing. Contributing to the accident were the wind gusts.NTSB DEN08FA162Accident · 1 fatalField investigationFinal reportPilatus PC-12/47E · Santa Fe, NMThe pilot's incapacitation due to fatigue resulting in an in-flight collision with terrain.NTSB DEN08CA164Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Double Eagle Airport, NMThe pilot flared high and failed to maintain directional control. Contributing to the accident were the pilot's unfamiliarity with the airplane and the crosswind.NTSB DFW08CA227Accident · No injuriesData collectionFinal reportCessna 172RG · Almogordo, NMThe pilot's failure to extend the airplane's landing gear before landing.NTSB DEN08LA145Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Angle Fire, NMControlled flight into terrain for unknown reasons.NTSB DFW08CA222Accident · No injuriesData collectionFinal reportFairchild SW3 · Carlsbad, NMFailure of the door to remain secure for undetermined reasons.NTSB DFW08LA217AccidentLimited investigationFinal reportCessna 172A · Albuquerque, NMThe pilot's failure to maintain proper glide angle during the landing approach which resulted in a collision with a pole. Contributing to the accident were the pilot's lack of qualification, experience and the high density altitude.NTSB DEN08CA136Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Dexter, NMThe pilot's failure to maintain directional control of the airplane.NTSB DFW08LA187Accident · Serious injuriesLimited investigationFinal reportAMS Flight Carat A · Edgewood, NMThe pilot's failure to maintain adequate airspeed while maneuvering at low altitude resulting in an inadvertent aerodynamic stall and impact with terrain.NTSB DFW08FA170Accident · 5 fatalField investigationFinal reportCessna U206F · Santa Rosa, NMThe pilot's failure to maintain safe flying airspeed for undetermined reasons resulting in an inadvertent stall.NTSB DFW08CA160Accident · Minor injuriesData collectionFinal reportPiper PA-28-235 · Amistad, NMFuel starvation while in cruise flight. Contributing to the accident were incorrect maintenance, the fuel selector movement was impeded and a plowed field.NTSB DFW08CA150Accident · Minor injuriesData collectionFinal reportCortesy, John E Airborne Edge-X · San Juan Pueblo, NMThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing to the accident was the loss of engine power for undetermined reasons.NTSB DFW08CA116Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Carlsbad, NMThe pilot's improper decision to takeoff uphill with full fuel and fuel chemical load. A factor was the pilot's failure to calculate performance data.NTSB DFW08CA113Accident · No injuriesData collectionFinal reportPiper PA-18 · Santa Teresa, NMThe pilot's failure to maintain aircraft control. Contributing to the accident was the strong gusty crosswinds.NTSB DFW08CA109Accident · No injuriesData collectionFinal reportBeech C23 · Santa Fe, NMThe pilot's improper recovery from a bounced landing.NTSB DEN08LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Reserve, NMThe pilot's loss of aircraft control, resulting in an inadvertent stall. Contributing factors in this accident were the sudden windshift to a gusting tailwind, an uphill runway, high density altitude, the pilot's failure to use all available runwayt, and his…NTSB DFW08CA099Accident · No injuriesData collectionFinal reportCessna 310Q · Roswell, NMThe airframe and powerplant mechanic's incorrect reassembly of the landing gear.NTSB DFW08LA088Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 9 · Questa, NMThe balloon's encounter with a wind gust/downdraft during landing, which resulted in a hard landing.NTSB DEN08LA066Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Las Vegas, NMAn inadvertent settling with power, and the instructor's failure to maintain control of the helicopter, resulting in a hard landing. Contributing to the accident was the downdraft.NTSB DEN08LA064Accident · No injuriesLimited investigationFinal reportSpartan 7W · Santa Fe, NMFatigue failure of the right main landing gear, rendering directional control impossible and causing an overload failure of the left main landing gear.NTSB DEN08CA056Accident · No injuriesData collectionFinal reportBurkhart Grob G-103A Twin II Acro · Alamogordo, NMThe unsuitable terrain for landing. Contributing to the accident were the pilot's encounter with turbulence and the loss of visual contact with the tow plane.NTSB DEN08CA051Accident · No injuriesData collectionFinal reportPiper PA-32-301XTC · Taos, NMThe pilot's excessive airspeed during the approach and loss of control during the landing. Contributing factors were the mountain turbulence and the snowbank.