Skip to content

NTSB investigations, NM

26 cases where the first occurrence was “On ground/water collision with object”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

Where

Latest cases

Query with SQL

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" = 310) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 310)
  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" = 310)
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 DEN07LA090Incident · No injuriesLimited investigationFinal reportBeech 200 · Angel Fire, NMThe pilot's inability to maintain clearance from the snow bank. Contributing factors were the pilot's failure to perform a go-around/missed approach procedure after observing snow removal equipment on the runway, the pilot's improper in-flight planning and…Mar 24, 2007 · N771HC · Minor damage NTSB DEN07CA011Accident · Minor injuriesData collectionFinal reportAdams A55S · Albuquerque, NMthe pilot's improper in-flight planning/decision. A contributing factor was the unfavorable wind.Oct 15, 2006 · N9019A · Substantial damage NTSB DEN06CA082Accident · No injuriesData collectionFinal reportCessna 182R · Albuquerque, NMthe pilot's failure to maintain directional control of the airplane after landing.Jun 4, 2006 · N6220N · Substantial damage NTSB DEN03LA057Accident · No injuriesLimited investigationFinal reportCessna 170A · Santa Rosa, NMthe pilot's failure to maintain directional control while taxiing for takeoff. A contributing factor was the wind gust.Mar 26, 2003 · N1228D · Substantial damage NTSB FTW02LA166Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Nageezi, NMthe pilot's failure to select a suitable landing site, which resulted in a collision with a fence.May 30, 2002 · N9051D · Substantial damage NTSB FTW02LA094Accident · No injuriesLimited investigationFinal reportCessna 402C · Albuquerque, NMThe failure of the tug driver to stop at the stop sign resulting in a collision with a taxiing airplane. A contributing factor was the dark night light conditions.Mar 14, 2002 · N596DM · Substantial damage NTSB FTW02LA012Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Albuquerque, NMthe pilot's failure to maintain clearance with a power line during landing. A contributing factor was the high wind during the landing.Oct 13, 2001 · N5260E · Substantial damage NTSB FTW02LA013Accident · Serious injuriesLimited investigationFinal reportAerostar International S81A · Albuquerque, NMthe selection of an unsuitable landing area by the pilot. A contributing factor was the high wind during the landing.Oct 10, 2001 · N52760 · Minor damage NTSB DEN01LA047Accident · No injuriesLimited investigationFinal reportBeech V-35A · Albuquerque, NMthe pilot's inattention during night taxiing, which resulted in his airplane impacting a parked airplane.Feb 4, 2001 · N9447S · Substantial damage NTSB DEN00LA174Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Las Cruces, NMThe pilot's failure to maintain lateral clearance with terrain. Factors were the confined area used for takeoff, and the high vegetation alongside the road.Sep 17, 2000 · N14774 · Substantial damage NTSB DEN99LA011Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX8-90 S 2 · Albuquerque, NMThe pilot's improper planning for his landing site approach which resulted in the balloon landing in close proximity to electrical transmission lines.Oct 9, 1998 · N790TC · Substantial damage NTSB FTW95LA325Accident · No injuriesLimited investigationFinal reportRolladen-Schneider LS-3-17 · Sandia Park, NMThe pilot's improper evaluation of the developing thunderstorm activity. Factors were the weather and the lack of suitable terrain for the precautionary landing.Jul 31, 1995 · N48EH · Substantial damage NTSB FTW93GA269Accident · No injuriesFinal reportBell 206B · Wht Sands Mr, NMThe pilot's failure to land an adequate distance away from the unsecured parachute.Sep 29, 1993 · N39049 · Substantial damage NTSB DEN91LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31T-620 · Santa Fe, NMInadvertent deactivation of aircraft brakes by unqualified person.Sep 22, 1991 · N2FJ · Substantial damage NTSB DEN91LA074Accident · No injuriesLimited investigationFinal reportPitts S-2B · Albuquerque, NMFailure of the pilot of the other airplane to maintain visual lookout.May 16, 1991 · N603SB · 2 aircraft · Minor damage NTSB DEN88LA200Accident · Minor injuriesLimited investigationFinal reportThunder and Colt AX8-90 · Las Cruces, NMThe commercial balloon plt was participating in a balloon rally. During landing, the plt noticed the balloon was drifting toward power lines. He elected to open the deflation valve at 30 ft AGL, to attempt to land short of the lines. The balloon touched down…Sep 4, 1988 · N90EH · Substantial damage NTSB DEN88LA196Accident · No injuriesLimited investigationFinal reportCessna 182RG · Antelope Wells, NMThe commercial plt was flying three passengers to buy cattle. During takeoff from a 5,000 x 75 ft, wet gravel airstrip, the plt elected to use only the left side of the rwy to avoid mud. He used a soft field takeoff, with a nose high attitude, which limited…Sep 1, 1988 · N3184C · Substantial damage NTSB DEN88LA045Accident · No injuriesLimited investigationFinal reportRaven Rally RX7 · Dona Ana, NMThe commerical plt was conducting a sightseeing flight in his balloon. After a one and one half hour flight, he landed beside a paved road. The envelope collapsed over a power line. The ground crewman somehow contacted the balloon and was electrically…Dec 30, 1987 · N40364 · Substantial damage NTSB DEN87LA212Accident · No injuriesLimited investigationFinal reportCessna 414 · Cuba, NMThe acft was dispatched to the Cuba, NM area to pick up a critically ill patient. The state police blocked off a section of highway for the acft to land on. The plt landed on the highway, but drg the landing roll, the underside of the rgt wing struck a road…Jul 28, 1987 · N1648T · Substantial damage NTSB DEN86LA136Accident · No injuriesLimited investigationFinal reportCessna 421C · Albuquerque, NMAcft was landing on rwy 17. Plt said he struck a rabbit with left main landing gear and lost all braking action on left side. Plt used right brake to decelerate but overran rwy end and struck dirt bank.May 15, 1986 · N21WL · Substantial damage NTSB DEN86LA055Accident · No injuriesLimited investigationFinal reportCessna 172RG · Las Vegas, NMAccording to the plt, he was attempting to depart from a pvt grass strip, which is located on a plateau at an elev of aprx 6,400 MSL. The grass strip, which is aprx 3,000 ft in length, has an upslope of about 10% for the first half and a downslope at about…Dec 28, 1985 · N4849V · Substantial damage NTSB DEN85LA092Accident · No injuriesLimited investigationFinal reportCessna 180 · Arroyo Seco, NMThe acft collided with trees off the end of the 1000 ft long grass airstrip during an aborted takeoff attempt. Calculations show it would have taken aprx 1171 ft for the plt to successfully perform the aborted takeoff.Mar 10, 1985 · N2242C · Destroyed NTSB FTW84LA087Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Albuquerque, NMThe plt reported that during flt, unfavorable winds were encountered. An apch was made to a golf course, but the plt aborted dur to high winds. A short time later, an apch was made to a park area. According to the plt, the wind switched as the Balloon touched…Dec 3, 1983 · N4061P · Substantial damage NTSB FTW83LA322Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Los Lunas, NMThe tow plane collided with a van on the rwy during takeoff. The van had been parked there on purpose by the arpt owner to close the rwy. He stated that he had notified the FAA of the closing but no NOTAM had been issued on 7/7/83. A NOTAM was issued for…Jul 7, 1983 · N8999 · Substantial damage NTSB FTW82FQA18Accident · 1 fatalFinal reportBlanik L-13 · Los Lunas, NMDuring landing the left wing struck a bystander who wandered onto the edge of the asphalt overrun taking photographs of the landing. There is a caution sign posted on the north access road of the runway.May 8, 1982 · N48032 · Substantial damage NTSB FTW82DA154Accident · No injuriesFinal reportPiper PA-44-180 · Albuquerque, NMThe purpose of the flight was for the pilot-in-command to take his multi-engine airplane check ride. During the takeoff sequence, the examiner reduced power on one engine. The pilot decided there was insufficient runway remaining and aborted the takeoff. The…Apr 26, 1982 · N39669 · Substantial damage