Skip to content

NTSB investigations: Cessna 172M, NM

20 cases on aircraft the registry lists as Cessna 172M. 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

19742026

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 ('2072418')) 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 ('2072418'))
  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 ('2072418'))
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 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,…Jan 29, 2003 · N64312 · Substantial damage NTSB DEN99LA019Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Belen, NMThe pilot's inadequate preflight planning, resulting in fuel supply exhaustion.Nov 8, 1998 · N8883V · Substantial damage NTSB FTW98LA219Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albuquerque, NMThe flight instructor's failure to maintain directional control of the aircraft. Factors were crosswind, high wind conditions, insufficient demonstrated crosswind component information provided by the manufacturer, and insufficient aircraft…May 17, 1998 · N64015 · Destroyed NTSB FTW95LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmington, NMThe pilot's inadequate compensation for wind conditions. Factors were wind shear, crosswinds, and gusts.Oct 13, 1994 · N20384 · Substantial damage NTSB DEN93FA097Accident · 1 fatalField investigationFinal reportCessna 172M · Clines Corners, NMThe pilot's failure to maintain a safe and proper altitude. Factors were the pilot's failure to obtain a preflight weather briefing, dark night condition, and weather conditions that included obscuration, fog, and drizzle.Aug 3, 1993 · N23459 · Destroyed NTSB FTW92LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Springer, NMThe pilot's poor judgement in attempting flight into forcasted adverse weather, his disregard for the hazardous weather advisory received which resulted in partial loss of engine power as a result of a blocked induction system due to ice and snow, and the…Nov 2, 1991 · N61539 · Substantial damage NTSB DEN89FA184Accident · 1 fatalField investigationFinal reportCessna 172M · Albuquerque, NMThe pilot deliberately flew his aircraft into the face of a mountain. A contributing factor was: the psychological condition of the pilot.Aug 6, 1989 · N64263 · Destroyed NTSB DEN89LA187Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Ruidoso, NMThe pilot's improper use of the mixture control and carburetor heat during a takeoff in high density altitude conditions. Contributing to the accident was the high density altitude.Aug 5, 1989 · N9183H · Destroyed NTSB DEN86LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Quemado, NMThe plt said the wind was variable and gusty. When the takeoff was started there was a quartering headwind but as takeoff speed was reached the wind switched to a tailwind. The acft lifted off but immediately settled back to the rwy. The plt then added flaps…Feb 26, 1986 · N8935V · Substantial damage NTSB FTW83LA068Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Portales, NMAcft collided with power lines short of the rwy. Winds were gusty 27K.Dec 27, 1982 · N20EB · Substantial damage NTSB FTW80FQA31Accident · Minor injuriesClosedCessna 172M · Capitan, NMJun 4, 1980 · N9644V · Destroyed NTSB DEN80FQA16Accident · Minor injuriesClosedCessna C172 · Ocate, NMJan 24, 1980 · N9878V · Substantial damage NTSB DEN79FQD09Accident · Minor injuriesClosedCessna 172M · Silver City, NMMay 30, 1979 · N12540 · Substantial damage NTSB DEN79FQA20Accident · No injuriesClosedCessna 172M · Albuqueque, NMMar 10, 1979 · N23459 · Substantial damage NTSB DEN78FQA53Accident · No injuriesClosedCessna 172 · Albuquerque, NMSep 7, 1978 · N20583 · Substantial damage NTSB DEN78FQA45Accident · Serious injuriesClosedCessna 172 · Rio Rancho, NMJul 29, 1978 · N12748 · Substantial damage NTSB DEN78FQA13Accident · No injuriesClosedCessna 172C · Farmington, NMJan 17, 1978 · N1369U · Substantial damage NTSB DEN78FQA01Accident · No injuriesClosedCessna 172M · Albuquerque, NMOct 25, 1977 · N4412R · Substantial damage NTSB DEN77FQA28Accident · No injuriesClosedCessna 172 · Santa Rosa, NMApr 5, 1977 · N80950 · Substantial damage NTSB DEN74DQD17Accident · No injuriesClosedCessna 172 · Carlsbad, NMApr 15, 1974 · N20202 · Substantial damage