NTSB investigations, 2018, 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\") = 2018
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") = 2018 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 GAA19CA097Accident · No injuriesData collectionFinal reportCessna 180 · Moriarty, NMThe pilot's failure to see and avoid a parked glider while taxiing from the runway.NTSB CEN19FA032Accident · 1 fatalField investigationFinal reportMooney M20C · Santa Fe, NMCollision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot's poor preflight planning and poor decision to depart on the accident flight.NTSB GAA19CA053Accident · Minor injuriesData collectionFinal reportPiper PA24 · Texico, NMThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN19CA017Accident · No injuriesData collectionFinal reportPiper PA28R · Hobbs, NMThe pilot's incorrect altimeter setting during the night visual approach, which resulted in a controlled flight into terrain.NTSB CEN19FA008Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Canoncito, NMThe partial loss of engine power due to induction system icing. Contributing to the accident was the fractured carburetor heat control cable, which rendered the carburetor heat inoperative.NTSB WPR19TA005Accident · Serious injuriesFinal reportBalloon Works Firefly 7 · Placitas, NMThe pilot’s failure to properly estimate the height of terrain while descending the balloon, which resulted in the balloon impacting a hill and passengers sustaining serious injuries.NTSB GAA19CA030Accident · Serious injuriesData collectionFinal reportUltramagic N 250 · Rio Rancho, NMThe balloon tipping over during deflation, which resulted in a passenger injury.NTSB GAA18CA571Accident · No injuriesData collectionFinal reportEurocopter AS350 · Ruidoso, NMThe pilot's failure to maintain the proper descent rate during landing. Contributing to the accident were the pilot’s failure to conduct preflight performance calculations, which resulted in his operating the helicopter in high-density altitude conditions,…NTSB CEN18LA383Accident · No injuriesLimited investigationFinal reportPiper PA46 · Santa Teresa, NMThe pilot's decision to attempt to take off in an overweight airplane in high density altitude conditions, which resulted in the airplane’s inability to climb, an aborted takeoff, and a subsequent runway excursion.NTSB GAA18CA493Accident · Minor injuriesData collectionFinal reportCessna 172 · Silver City, NMThe pilot’s failure to maintain directional control while landing with a quartering tailwind.NTSB GAA18CA480Accident · No injuriesData collectionFinal reportPiper PA18 · Raton, NMThe pilot's loss of directional control during the landing roll.NTSB GAA18CA530Accident · No injuriesData collectionFinal reportPiper PA 12 · Edgewood, NMThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA436Accident · Serious injuriesData collectionFinal reportAirborne Windsports PTY Edge XT-912-L · Albuquerque, NMThe pilot’s failure to maintain directional control during landing.NTSB CEN18FA262Accident · 1 fatalField investigationFinal reportSchempp-Hirth Flugzeugbau Ventus 3F · Moriarty, NMThe pilot's exceedance of the glider's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall and subsequent impact with terrain.NTSB CEN18LA226Accident · Serious injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Arrey, NMThe pilot's failure to maintain clearance from a hillside during an agricultural application flight while facing the sun.NTSB CEN18LA222Accident · No injuriesClass 3 · LimitedFinal reportTaylorcraft BC12 D · Santa Teresa, NMThe pilot's loss of directional control during landing in gusting crosswind conditions for reasons that could not be determined based on the available information.NTSB CEN18LA218Accident · Minor injuriesLimited investigationFinal reportAerovodochody L 29 Delfin · Moriarty, NMThe pilot’s failure to maintain a proper glidepath during a visual approach and the flight instructor’s delayed remedial action, which resulted in ground impact before the runway.NTSB CEN18LA207Accident · No injuriesLimited investigationFinal reportCessna T210 · Clovis, NMThe total loss of engine power for reasons that could not be determined because examination of the engine revealed no evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN18FA192Accident · 1 fatalField investigationFinal reportBeech D17S · Santa Fe, NMThe pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available information.NTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.NTSB GAA18CA266Accident · Minor injuriesData collectionFinal reportDiven Robert Nieuport 17 · Las Cruces, NMThe pilot’s failure to attain a positive climb rate after takeoff in high-density altitude conditions, which resulted in a collision with terrain.NTSB GAA18CA262Accident · No injuriesData collectionFinal reportCessna 182 · Albuquerque, NMThe pilot’s decision to continue flight in mountainous terrain with downdraft conditions, which necessitated a precautionary landing on unsuitable terrain.NTSB GAA18CA206Accident · No injuriesData collectionFinal reportBice David E Bearhawk · Edgewood, NMThe pilot’s failure to maintain directional control of the airplane during landing.NTSB CEN18LA117Accident · No injuriesLimited investigationFinal reportBlack Donald Cozy III · Los Lunas, NMThe seizure of the propeller gearbox for reasons that could not be determined based on the available information, which resulted in a forced landing.NTSB GAA18CA112Accident · No injuriesData collectionFinal reportCessna 172 · Silver City, NMThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a hard, bounced landing.NTSB CEN18FA078Accident · 5 fatalField investigationFinal reportBell UH-1H · Raton, NMThe pilot's failure to maintain adequate altitude above mountainous terrain during cruise flight in dark night conditions, which resulted in controlled flight into terrain.NTSB CEN18LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBryk Steven L Velocity XL RG · Santa Fe, NMThe airplane’s inadvertent encounter with unforecasted icing conditions during cruise flight, which resulted in the accumulation of airframe icing, the airplane’s inability to maintain altitude, and a subsequent forced landing on rough terrain.