NTSB investigations, 2012, NM
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2012
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") = 2012 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 CEN13LA110Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 (T42A) · Las Cruces, NMThe pilot's failure to properly manage the airplane's fuel, which resulted in engine failure due to fuel starvation.NTSB CEN13CA019Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Portales, NMThe pilot’s failure to maintain clearance from power lines during an aerial application flight.NTSB CEN13LA032Accident · Minor injuriesLimited investigationFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to attain the desired touchdown point because of wind conditions and surrounding obstructions, which resulted in the balloon impacting a fence during the approach to landing.NTSB CEN13CA035Accident · Serious injuriesData collectionFinal reportLindstrand Balloons 90A · Albuquerque, NMThe balloon pilot's encounter with higher-than-expected wind velocity, which resulted in a hard landing and passenger injury.NTSB CEN13CA018Accident · Serious injuriesData collectionFinal reportArbc Inc DBA Lindstrand 90A · Albuquerque, NMThe passenger’s inadequate brace position for the balloon landing, which resulted in a serious injury.NTSB CEN12CA673Accident · Minor injuriesData collectionFinal reportDavis Mark Davis KR-1 · Albuquerque, NMThe loss of control during landing/flare resulting from the pilot's decision to land in high wind conditions. Contributing to the accident was the gusting wind and sudden wind shift during a critical phase of landing.NTSB CEN12LA659Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 210S · Albuquerque, NMThe failure of the balloon envelope parachute vent to properly seat, which resulted in the uncontrolled descent of the balloon. The reason the vent did not properly seat during the accident flight could not be determined because the vent operated properly…NTSB CEN12CA496Accident · No injuriesData collectionFinal reportBlack Donald Cozy III · Los Lunas, NMA loose oil line, which allowed oil to leak onto the hot engine turbocharger and resulted in a fire.NTSB CEN12CA429Accident · Minor injuriesData collectionFinal reportCessna 190 · Anthony, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN12LA427Accident · Serious injuriesLimited investigationFinal reportMurray Richard F Aircam BY Lockwood · Taos, NMThe pilot's decision to fly in gusty wind conditions at low altitude over mountainous terrain contrary to guidance in the airplane flight manual and subsequent loss of airplane control due to wind and turbulence.NTSB CEN12LA387Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Teresa, NMThe pilot’s failure to ensure that the landing gear was down and locked before landing.NTSB CEN12LA359Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Teresa, NMThe sudden decrease in headwind during takeoff in a gusty wind and near a passing train, which resulted in a loss of lift and main rotor rpm. Contributing to the accident was the pilot's decision to operate the helicopter near its maximum performance…NTSB CEN12FA291Accident · 1 fatalField investigationFinal reportBeech V35B · Las Vegas, NMThe pilot’s loss of airplane control for reasons that could not be determined because postaccident examination revealed no evidence of preimpact anomalies that would have precluded normal operation.NTSB CEN12LA289Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Grants, NMThe loss of engine power due to an excessively rich fuel mixture that occurred during operations at idle power settings at a high density altitude. Contributing to the accident was the flight instructor’s poor decision-making in choosing to practice an…NTSB CEN12LA265Accident · Minor injuriesLimited investigationFinal reportJonker Sailplanes CC JS 1B · Clines Corner, NMThe fatigue failure of the rudder cable due to the inadequate design of the rudder pedal system.NTSB CEN12LA261Accident · No injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe partial loss of engine power due to an intake valve that was stuck in the open position.NTSB CEN12FA174Accident · 2 fatalField investigationFinal reportHemp Timothy Legacy 2000 · Belen, NMThe pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…NTSB CEN12CA140Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Angle Fire, NMThe pilot did not maintain control of the airplane during the takeoff in gusting crosswind conditions.NTSB CEN12CA121Accident · No injuriesData collectionFinal reportButler John R SX 300 · Truth or Consequences, NMThe pilot did not maintain airplane control during takeoff due to his distraction with the improperly secured canopy, which he forgot to latch.