NTSB investigations, NM
79 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 11 |
|---|---|
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 6 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 5 |
| 2002 | 2 |
| 2003 | 5 |
| 2004 | 3 |
| 2005 | 2 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'NM' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
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 c."eventStateOrRegion" = 'NM' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) 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 DEN07FA071Accident · 1 fatalField investigationFinal reportBeech A23A · Holman, NMThe pilot's failure to maintain a safe altitude and clearance, and his improper inflight planning/decision to postpone initiating a climbing turn to avoid obstructions.NTSB DEN06LA002Accident · No injuriesLimited investigationFinal reportAerostar S57-A · Albuquerque, NMthe pilot's improper in flight planning decision to takeoff and land (splash and dash) in close proximity to trees. Contributing factors are the trees and the water.NTSB DEN05LA099Accident · No injuriesLimited investigationFinal reportCampbell Long EZ · Santa Fe, NMthe inflight collision with a bird(s).NTSB DEN05TA033Accident · No injuriesFinal reportPiper PA-18-150 · Jal, NMthe pilot's failure to maintain clearance from the power lines. Contributing factors include the power lines, the sun glare, the pilot's reduced visual lookout, the pilot’s improper in-flight planning and decision making and the pilot's failure to perform a…NTSB DEN05CA006Accident · No injuriesData collectionFinal reportAerostar SP-1 · Albuquerque, NMthe pilot's failure to maintain clearance with the radio tower. Contributing factors were the pilot's improper compensation for the variable wind conditions.NTSB DEN04LA065Accident · No injuriesLimited investigationFinal reportMooney M20C · Clovis, NMthe pilot's improper in-flight planning and decision making during an instrument approach resulting in the pilot's intentional descent below approach minimums, and the pilot's failure to maintain obstacle clearance resulting in the in-flight collision with an…NTSB DEN04LA033Accident · No injuriesLimited investigationFinal reportAerospatiale AS 365 N-2 · Santa Fe, NMthe pilot's failure to maintain lateral clearance from the hangar. A contributing factor was the gusty crosswind.NTSB DEN03LA109Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Las Vegas, NMthe pilot's failure to maintain obstacle clearance and visual lookout. Contributing factors were his attention being diverted and the trees.NTSB DEN03FA087Accident · 2 fatalField investigationFinal reportErcoupe 415D · Los Lunas, NMthe pilot's failure to maintain clearance from the transmission wire. Contributing factors were the high wind, the pilot's decision to make a low-altitude turn onto the crosswind leg, and the power line.NTSB DEN03FA045Accident · 3 fatalField investigationFinal reportPiper PA-46-500TP · Albuquerque, NMThe pilot's unstabilized approach and his failure to maintain obstacle clearance. Contributing factors were the dark night light condition, and the static wires.NTSB DEN03LA039Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Logan, NMthe pilot's improper in-flight planning/decision, his failure to accomplish appropriate checklist items during the go-around, and his failure to maintain clearance from the trees and the lamp post. Factors contributing to the accident were the low altitude,…NTSB DEN02FA065Accident · 2 fatalField investigationFinal reportBell 206BIII · Raton, NMThe pilot's failure to maintain clearance of the static wire. Factors were the static wire, and the glaring sunlight condition.NTSB FTW02FA162Accident · 1 fatalField investigationFinal reportCirrus Design SR-20 · Angel Fire, NMThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,NTSB FTW02LA026Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta II · Redrock, NMThe pilot's failure to maintain clearance with terrain. Contributing factors were the mountainous terrain and high density altitude.NTSB FTW02LA016Accident · No injuriesLimited investigationFinal reportThunder and Colt AX8-90 · Albuquerque, NMthe pilot's failure to maintain clearance with the obstacles during landing. A contributing factor was the gusty winds.NTSB DEN01LA150Accident · No injuriesLimited investigationFinal reportHughes 269C · Tucumcari, NMfailure of the pilot-in-command to maintain adequate terrain clearance. Contributing factors were the unsuccessful low altitude flight maneuver, and the high density altitude weather conditions.NTSB DEN01FA105Accident · 2 fatalField investigationFinal reportSchempp-Hirth Nimbus-3DM · Alamogordo, NMThe flight crew's inadequate in-flight planning to fly over the mesa with insufficient altitude. A contributing factor was the downdraft weather conditionNTSB DEN01LA092Accident · Minor injuriesLimited investigationFinal reportRaven S55A · Albuquerque, NMthe pilot's failure to maintain a visual lookout during approach. A contributing factor was the power lines.NTSB DEN00FA119Accident · 2 fatalField investigationFinal reportCessna 172H · Angel Fire, NMThe pilot's improper inflight decision to prematurely attempt a climb towards rising terrain before sufficient altitude had been attained that would assure adequate obstacle clearance. Factors were high density altitude and trees.NTSB DEN00FA082Accident · 2 fatalField investigationFinal reportMcDonnell Douglas 369E · Bloomfield, NMThe pilot's intentional buzzing (low level flying), and his failure to maintain clearance with the static wire. A factor was his physical impairment by a contraindicated drug controlled substance.NTSB DEN00LA071Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly F-15 · Anthony, NMFailure by the pilot to keep the burner operating until the balloon was secured. A factor was the passengers disregarding the instructions they had been given by the pilot.NTSB DEN99LA163Accident · No injuriesLimited investigationFinal reportRobinson R22A · Tucumcari, NMThe pilot's inadequate visual lookout. A factor was a reduced visual detection due to background vegetation and terrain.NTSB DEN99LA102Accident · No injuriesLimited investigationFinal reportSchweizer SGU-2-22E · Hobbs, NMPilot incapacitation (loss of consciousness) due to dehydration and hyperventilation. Factors were the turbulence and excessive workload (task overload) that induced anxiety/apprehension, and striking the sign and the pole.NTSB DEN99FA024Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta II · Deming, NMThe pilot's failure to maintain clearance of the transmission wire. Factors were the transmission wire, and the glaring sunlight condition.NTSB FTW98LA383Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502B · Portales, NMThe pilot's failure to maintain adequate altitude/clearance during an aerial application. Also causal was the inadvertent ground loop/swerve during the landing.NTSB FTW98GA286Accident · 2 fatalFinal reportLockheed SP-2H · Reserve, NMFailure of the copilot to maintain both lateral and vertical clearance from the trees, and failure of the captain to provide adequate supervision of the flight.NTSB FTW98FA287Accident · 1 fatalField investigationFinal reportCessna 175 · Clovis, NMThe pilot's failure to maintain adequate obstacle clearance and the proper landing glide path. Also causal was his loss of aircraft control during an attempted go-around. Factors were the dark night light conditions, the pilot's recent lack of sleep, and the…NTSB FTW98LA143Accident · No injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMthe pilot's failure to maintain control of the balloon.NTSB FTW97LA167Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Hatch, NMThe pilot's failure to maintain clearance from the wires. A factor was the sunglare.NTSB FTW97TA046Accident · No injuriesFinal reportAerospatiale AS-355-F1 · Taos, NMThe pilot's failure to maintain directional control. A factor was terrain induced turbulence.NTSB FTW96LA361Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Rio Rancho, NMthe pilot's failure to maintain clearance from the power lines. The variable wind condition was a related factor.NTSB FTW96LA274Accident · No injuriesLimited investigationFinal reportHughes 369HE · Las Cruces, NMthe pilot's failure to maintain clearance between the tail rotor and a fence while hovering.NTSB FTW95FA238Accident · 1 fatalField investigationFinal reportSmith LONG-EZ · Cloudcroft, NMThe pilot's failure to maintain clearance from trees. Factors were the pilot exceeded the allowable maximum gross weight of the airplane, the rising terrain, and high density altitude.NTSB FTW95LA098Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Placitas, NMThe pilot operated beyond the climb capability of the helicopter, resulting in inadequate altitude and terrain clearance over mountainous rising terrain. A factor was turbulence.NTSB FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.NTSB FTW94LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Albuquerque, NMThe CFI rated second pilot's failure to maintain the ILS glideslope. A factor was the dark night and lack of supervision.NTSB FTW92GA157Accident · 1 fatalFinal reportHughes OH-6A · Sunland Park, NMThe pilot's failure to see and avoid the wires.NTSB DEN91FA132Accident · 2 fatalField investigationFinal reportCessna 172N · Tererro, NMA failure of the pilot to maintain adequate obstacle clearance in mountainous terrain. Factors were: lack of familiarity with the aircraft, and insufficient standards by the operator.NTSB DEN91LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Timberon, NMThe pilot's inadequate preflight planning and selection of the wrong runway. Related factors were: the rising terrain, trees, and the pilot's lack of experience.NTSB DEN91LA003Accident · 2 fatalLimited investigationFinal reportRaven S-55A · Bernalillo, NMThe pilot to maintain adequate visual lookout, resulting in an inflight collision with power lines.NTSB DEN90FA176Accident · 1 fatalField investigationFinal reportCameron O-84 · Taos, NMThe pilot's improper decision to attempt a go-around. A factor was the unfavorable wind encountered late in the attempted landing.NTSB DEN90FA013Accident · 2 fatalField investigationFinal reportCessna T210L · Penasco, NMImproper inflight planning/decision by the pilot, and his failure to maintain sufficient altitude over mountainous terrain. Factors related to the accident were: failure of the pilot to obtain (and/or understand) wind aloft information, his lack of…NTSB DEN90LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Albuquerque, NMImproper planning/decision by the pilot. Factors related to the accident were: the pilot's lack of familiarity with the aircraft, his failure to use the recommended flap extension, his failure to maintain an airspeed above the automatic gear extension speed…NTSB DEN90LA005Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Albuquerque, NMThe pilot's selection of an unsuitable area (terrain) for landing. The static cable & power line were considered to be related factors.NTSB DEN90LA003Accident · No injuriesLimited investigationFinal reportAdams A55 · Albuquerque, NMThe pilot's failure to adequately compensate for the existing wind conditions. Contributing factor(s) was: trees and power lines in the landing area.NTSB DEN89LA161Accident · Minor injuriesLimited investigationFinal reportRaven RX-7 · Albuquerque, NMInadequate visual lookout by the pilot. Contributing to the accident were the power lines.NTSB DEN89FA152Accident · 1 fatalField investigationFinal reportBeech E33 · Angel Fire, NMImproper planning/decision by the pilot, his premature rotation for takeoff and subsequent failure to obtain or maintain sufficient speed to climb, and his failure to abort the takeoff (while there was sufficient rwy remaining). Contributing factors were: the…NTSB DEN89LA005Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe commercial Balloon plt and one pax were participating in a Balloon fiesta. The acft took off from Albuquerque, on a local flight in light winds. At altitude, the Balloon encountered easterly winds that carried the Balloon southwest of Albuquerque, where a…NTSB DEN89LA003Accident · Minor injuriesLimited investigationFinal reportPiccard AX-6 · Albuquerque, NMThe commercial plt was competing in a balloon fiesta, with 2 pax. The plt selected a landing field with power lines and a street running east and west across it. The balloon was drifting south and the plt selected the south end of the field for landing,…NTSB DEN88FA084Accident · 1 fatalField investigationFinal reportPiper PA-22 · Angel Fire, NMAfter takeoff, the acft could not outclimb rapidly rising terrain off the end of the rwy and collided with trees/terrain. Exam of wreckage disclosed fouled plugs from rich mixture and low cyl compression. Exam of airport info did not describe topography…