Skip to content

NTSB investigations: Cessna 172N, NM

35 cases on aircraft the registry lists as Cessna 172N. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434')) 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072434'))
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 WPR23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Socorro, NMThe pilot’s improper landing flare, which resulted in a hard bounced landing and loss of control in gusting wind.Dec 10, 2022 · N422B · Substantial damage 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.Jan 26, 2018 · N1046F · Substantial damage NTSB CEN18FA024Accident · 4 fatalField investigationFinal reportCessna 172N · Hatch, NMThe pilot's failure to maintain airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.Nov 4, 2017 · N251CH · Substantial damage NTSB CEN14CA353Accident · No injuriesData collectionFinal reportCessna 172N · Edgewood, NMThe pilot's in-flight loss of control resulting from a crosswind gust encountered immediately after takeoff.Jul 10, 2014 · N4842G · Substantial damage NTSB CEN11CA409Accident · No injuriesData collectionFinal reportCessna 172N · Santa Teresa, NMThe pilot's inadequate compensation for the wind condition, resulting in a runway excursion.Jun 19, 2011 · N739ZN · Substantial damage NTSB FTW02LA079Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMthe loss of engine power as result of the failure of the dual magneto. A contributing factor was the lack of suitable terrain for the precautionary landing.Feb 8, 2002 · N75616 · Substantial damage NTSB DEN01LA129Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMthe pilot's failure to maintain clearance from the powerline while descending for an emergency landing. A contributing factor was the loss of engine power for an undetermined reason.Jul 27, 2001 · N181SP · Destroyed NTSB DEN00LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Abuquerque, NMThe pilot's improper flare and his inadequate recovery from a bounced landing.Jun 19, 2000 · N738WE · Substantial damage NTSB DEN99LA067Accident · No injuriesLimited investigationFinal reportCessna 172I · Las Cruces, NMThe pilot of N46204's failure to maintain visual lookout and to identify the other aircraft visually during landing.Apr 28, 1999 · N46204 · 2 aircraft · Substantial damage NTSB FTW98LA417Accident · No injuriesLimited investigationFinal reportCessna 172N · Gallup, NMThe pilot's inadequate landing flare. Factors were his misjudgement of altitude and his excessive airspeed.Sep 29, 1998 · N739JT · Substantial damage NTSB FTW97LA180Accident · No injuriesLimited investigationFinal reportCessna 172N · Las Cruces, NMThe improper installation of the throttle arm castellated nut, which resulted in a partial loss of power. A factor was the lack of suitable terrain for the forced landing.May 7, 1997 · N733WJ · Substantial damage NTSB FTW96LA246Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMfailure of the pilot to maintain directional control during a touch-and-go landing, which resulted in a ground swerve and subsequent collision with a parked airplane.Jun 12, 1996 · N3535E · Substantial damage NTSB FTW95LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's delayed landing flare and the improper bounced landing recovery.Feb 23, 1995 · N737TC · Substantial damage NTSB FTW95LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during a touch-and-go landing.Dec 29, 1994 · N737ZJ · Substantial damage NTSB FTW94LA037Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's improper flare.Nov 27, 1993 · N4759G · Substantial damage NTSB FTW93LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's failure to maintain directional control. A factor was the snow conditionsJan 12, 1993 · N734GD · Substantial damage NTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.Jan 14, 1992 · N4885G · Substantial damage 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.Sep 15, 1991 · N4868F · Destroyed NTSB DEN85LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Grant, NMThe acft crashed during takeoff from a dirt strip near Grant, NM, while on a pleasure flt. VMC conditions prevailed and no flt plan was filed. The plt & his 3 occupants were not injured. The plt reported that a dust devil caught the acft at an alt of 35-50 ft…Apr 10, 1985 · N738LR · Substantial damage NTSB FTW83LA098Accident · No injuriesLimited investigationFinal reportCessna 172N · Carlsbad, NMThe plt landed in a short, level area near a drilling rig site at an elevation of aprx 3300 ft. he stated that he previously stepped off the 960 ft takeoff area. He stated that he lifted off at about 58 KTS, but the plane seemed to hit turbulence and the…Jan 26, 1983 · N75707 · Substantial damage NTSB FTW82DA380Accident · No injuriesFinal reportCessna 172N · Hobbs, NMPilot collided with power line while on pipeline patrol. A sucessful landing was made at hobb, NM airport after accident.Sep 15, 1982 · N6553E · Substantial damage NTSB FTW82FQA22Accident · 4 fatalFinal reportCessna 172N · Santa Fe, NMThe acft struck the ground at a 40-45 deg angle & left wing down 1/2 mi from the departure end of rwy 20. No discrepancies were noted in aircraft systems. An eng disassembly revealed no malfunction. It was known the four occupants had a total weight of 857…Jul 18, 1982 · N6215D · Destroyed NTSB FTW81DQD29Accident · Minor injuriesClosedCessna 172 · Silver City, NMJul 17, 1981 · N6368G · Substantial damage NTSB FTW81FQA26Accident · No injuriesClosedCessna 172 · Santa Rosa, NMApr 27, 1981 · N733YM · Substantial damage NTSB DEN80FQA15Accident · Serious injuriesClosedCessna 172N · Tucumcari, NMApr 2, 1980 · N8281E · Substantial damage NTSB DEN80FQA17Accident · No injuriesClosedCessna 172N · Albuquerque, NMFeb 10, 1980 · N739JT · Substantial damage NTSB DEN79FQD15Accident · Minor injuriesClosedCessna 172 · Cloudcroft, NMAug 13, 1979 · N739WT · Destroyed NTSB DEN79FA049Accident · 1 fatalClosedCessna 172 · Albuquerque, NMJul 14, 1979 · N1695E · 2 aircraft · Substantial damage NTSB DEN79FQA35Accident · Minor injuriesClosedCessna 172 · Santa Rosa, NMJul 5, 1979 · N3244E · Substantial damage NTSB DEN79FQA32Accident · No injuriesClosedBeech C23 · Albuquerque, NMJun 18, 1979 · N23986 · 2 aircraft · Substantial damage NTSB DEN79FQA29Accident · Minor injuriesClosedCessna 172 · Albuquerque, NMMay 22, 1979 · N5878E · Substantial damage NTSB DEN79DQA02Accident · No injuriesClosedCessna 172 · Albuquerque, NMOct 12, 1978 · N737EM · Substantial damage NTSB DEN78FQA61Accident · No injuriesClosedCessna 172 · Los Lunas, NMSep 4, 1978 · N734FG · Substantial damage NTSB DEN78DQA20Accident · No injuriesClosedCessna 172 · Glenwood, NMApr 18, 1978 · N734PT · Substantial damage NTSB DEN66D0138Accident · No injuriesClosedCessna 337 · Albuquerque, NMOct 29, 1965 · N6231F · Substantial damage