NTSB investigations, 2015, NM
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 2015
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") = 2015 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 GAA16CA090Accident · No injuriesData collectionFinal reportStinson 108 · Portales, NMThe pilot receiving instruction's improper brake application during the flight instructor's aborted landing, which resulted in a loss of directional control and a runway excursion. Contributing to the accident was the flight instructor's decision to perform…NTSB CEN16FA042Accident · 3 fatalField investigationFinal reportCessna 182G · Sandia Park, NMThe pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB GAA16CA017Accident · No injuriesData collectionFinal reportCessna 195A · Aztec, NMThe pilot's failure to maintain directional control during landing, which resulted in runway excursion and collision with terrain.NTSB CEN16LA030Accident · Serious injuriesLimited investigationFinal reportAerostar RX8 · Albuquerque, NMThe pilot's delay in deflating the balloon envelope completely after landing, which resulted in a loss of control due to a wind gust.NTSB GAA16CA014Accident · Serious injuriesData collectionFinal reportKubicek BB · Albuquerque, NMA hard landing which resulted in serious injury to a passenger.NTSB CEN15LA434Accident · Serious injuriesLimited investigationFinal reportLindstrand LBL69A · Albuquerque, NMThe pilot’s failure to maintain a proper descent rate on approach, which resulted in a hard landing and the pilot sustaining a serious injury. Contributing to the accident was the pilot’s lack of recent experience flying a standard-shaped balloon.NTSB CEN15LA436Accident · No injuriesLimited investigationFinal reportBeech C35 · Belen, NMThe total loss of engine power due to contamination in the fuel system.NTSB GAA15CA300Accident · No injuriesData collectionFinal reportCessna 177RG · Aztec, NMThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and an impact with shrubs.NTSB GAA15CA260Accident · No injuriesData collectionFinal reportRocci Martignoni JA30 Superstol · Santa Rosa, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and a ground loop.NTSB CEN15LA360Accident · 1 fatalLimited investigationFinal reportNorth American T 28A · Las Cruces, NMFailure of the No. 6 cylinder connecting rod, due to improper rotation of the propeller during a previous hydraulic lock.NTSB CEN15LA354Accident · Serious injuriesLimited investigationFinal reportCessna C421B · Clovis, NMThe pilot's improper management of fuel to the left engine during approach for landing, which resulted in a total loss of left engine power due to fuel starvation, and his subsequent failure to maintain control during the final landing approach, which…NTSB CEN15LA359Accident · Serious injuriesLimited investigationFinal reportAeros Aeros 2 · Albuquerque, NMThe ultralight airplane’s encounter with a downdraft in mountainous terrain, which resulted in a descent into trees.NTSB CEN15CA340Accident · Serious injuriesData collectionFinal reportThunder & Colt AX8 105S2 · Albuquerque, NMThe pilot did not properly brace herself during the landing, which resulted in a broken ankle and leg.NTSB GAA15CA199Accident · Minor injuriesData collectionFinal reportNorton Claude C Tailwind W8 · Portales, NMThe pilot's failure to maintain adequate airspeed, which resulted in the airplane exceeding its critical angle of attack while maneuvering and a subsequent aerodynamic stall.NTSB CEN15FA325Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Truth or Consequences, NMThe student pilot's improper decision to conduct a flight in dark night conditions without a solo night flight endorsement and his subsequent loss of airplane control.NTSB GAA15CA171Accident · No injuriesData collectionFinal reportWeatherly 620B · Hatch, NMThe pilot failed to maintain obstacle clearance, and the airplane struck a transmission line wire during aerial application operations.NTSB GAA15CA133Accident · No injuriesData collectionFinal reportSchempp-Hirth Ventus 2C · Hobbs, NMThe pilot's improper compensation for gusty wind conditions which resulted in impact with terrain short of the runway.NTSB CEN15FA277Accident · 1 fatalField investigationFinal reportNorthwing Design Apache Sport · Taos, NMThe powered-lift aircraft's departure from controlled flight for reasons that could not be determined from the available information.NTSB CEN15FA255Accident · 2 fatalField investigationFinal reportCub Crafters CC18-180 · Raton, NMThe pilot's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB CEN15LA253Accident · 1 fatalLimited investigationFinal reportSchleicher ASW27 - 18E · Lamy, NMA loss of glider control for reasons that could not be determined based on the available evidence and the glider’s severe fragmentation.NTSB GAA15CA080Accident · No injuriesData collectionFinal reportPilatus PC12 - 45 · Crownpoint, NMThe pilot's failure to extend the landing gear before landing.NTSB CEN15CA218Accident · Minor injuriesData collectionFinal reportSchmidt Donald L GS1 Glastar · Moriarty, NMThe inadvertent encounter with a microburst while maneuvering near mountainous terrain, which resulted in a off airport landing and impact with terrain.NTSB DCA15CA117Accident · No injuriesData collectionFinal reportTitan Aerospace Holdings Solara 50 · Otto, NMstructural failure of the left wing due to an overspeed condition.NTSB GAA15CA039Accident · Serious injuriesData collectionFinal reportCameron Z90 - NO Series · Bernalillo, NMThe pilot's failure to maintain the descent rate, resulting in abnormal runway/ground contact.NTSB CEN15LA109Accident · No injuriesLimited investigationFinal reportCessna 182R · Santa Fe, NMThe pilot’s failure to remove ice from the airplane’s surfaces before departure, which resulted in the airplane’s inability to attain sufficient airspeed shortly after takeoff, the subsequent exceedance of the airplane’s critical angle-of-attack, and an…