NTSB investigations, 2016, 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\") = 2016
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") = 2016 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 GAA17CA095Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Separ, NMThe pilot’s abrupt maneuver to avoid electrical wires during the approach, which resulted in a hard landing.NTSB CEN17LA030Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Bloomfield, NMMaintenance personnel’s failure to fully torque the fuel port cap, which allowed the cap to back off in flight and interrupted fuel flow to the engine, which resulted in a total loss of engine power.NTSB GAA17CA044Accident · No injuriesData collectionFinal reportBeech D18S · Deming, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB CEN17CA013Accident · Minor injuriesData collectionFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's improperly planned landing, which resulted in a strike with power lines.NTSB CEN16LA375Accident · No injuriesLimited investigationFinal reportPiper PA 32R-300 · Grants, NMA loss of engine power for reasons that could not be determined based on the available information.NTSB GAA16CA505Accident · No injuriesData collectionFinal reportPiper PA46R · Reserve, NMThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB CEN16LA349Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Cuba, NMA partial loss of engine power for reasons that could not be determined based on available information.NTSB GAA16CA412Accident · No injuriesData collectionFinal reportCessna 120 · Belen, NMThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a ground loop.NTSB GAA16CA333Accident · Minor injuriesData collectionFinal reportCessna 172 · Anthony, NMThe pilot's failure to maintain clearance from a cable while maneuvering at a low altitude over water, which resulted in a collision with a cable and impact with water.NTSB CEN16LA234Accident · No injuriesLimited investigationFinal reportNorth American Navion · Alamogordo, NMThe failure of the No. 5 exhaust valve key spring, which resulted in a total loss of engine power.NTSB GAA16CA320Accident · No injuriesData collectionFinal reportBeech 77 · Santa Fe, NMThe pilot's decision to takeoff over the maximum takeoff weight in high density altitude conditions, which resulted in an inability to climb above terrain, a forced landing, and a collision with a road sign. Contributing to the accident was the pilot's…NTSB CEN16LA228Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Deming, NMThe pilots’ failure to maintain adequate control of the airplane during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude. Contributing to the accident was the…NTSB CEN16LA202Accident · No injuriesLimited investigationFinal reportHarry Oas Pitts S1C · Carlsbad, NMThe pilot's failure to maintain directional control while landing in crosswind conditions.NTSB GAA16CA267Accident · Minor injuriesData collectionFinal reportCessna 150 · Albuquerque, NMThe student pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, loss of engine power, and impact with terrain.NTSB CEN16LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180D · Shiprock, NMThe pilot's failure to maintain directional control after encountering a sudden change in wind direction during the landing roll.NTSB CEN16FA122Accident · 2 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Española, NMThe pilot's failure to maintain adequate airspeed while operating in the airport traffic pattern, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall at a low altitude.NTSB DCA16CA113Accident · No injuriesData collectionFinal reportBoeing 767 34AF · Albuquerque, NMthe pilot flying's failure to maintain airspeed and correct pitch attitude. Contributing to the accident was the pilot's failure to maintain appropriate thrust after disconnecting the autothrottles. Also contributing was the first officer's failure to monitor…NTSB CEN16LA112Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · Laguna Pueblo, NMA total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate oversight of the airplane's refueling and her subsequent failure to verify and monitor the fuel quantity before and during the flight.