NTSB investigations: Cessna 172P, NM
17 cases on aircraft the registry lists as Cessna 172P. 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.
Cases per year
| 1982 | 3 |
|---|---|
| 1984 | 1 |
| 1985 | 3 |
| 1986 | 3 |
| 1993 | 1 |
| 1994 | 1 |
| 1999 | 2 |
| 2004 | 1 |
| 2010 | 1 |
| 2023 | 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072436'))
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 ('2072436'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR24LA058Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Las Cruces, NMAn encounter with a downdraft during an approach to land, which resulted in a hard landing.NTSB CEN10LA449Accident · No injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMA total loss of engine power following a loss of oil pressure for undetermined reasons.NTSB DEN04TA088Accident · Serious injuriesFinal reportCessna C172P · Las Cruces, NMthe pilot's failure to maintain clearance from terrain and the improper go-around procedure. Contributing factors include the pilot's diverted attention, improper in-flight planning and decision making, pilot fatigue, the night conditions and the mesquite…NTSB DEN99FA142Accident · 1 fatalField investigationFinal reportCessna 172P · Grants, NMThe pilot's failure to fly the aircraft at an altitude sufficient to clear surrounding terrain. Factors were: The pilot's in-flight planning and decision making in proceeding into known adverse weather. Low ceiling, rain, lack of total pilot experience, and…NTSB DEN99LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dulce, NMThe pilot-in-command becoming disoriented during cruise flight, and his intentional flight into instrument meteorological conditions without proper certification. Factors were the existing weather conditions that included snow, fog, obscuration and icing, the…NTSB FTW95FA050Accident · 2 fatalField investigationFinal reportCessna 172P · Deming, NMThe pilot's failure to maintain sufficient altitude and clearance in moutainous terrain. Factors were rising terrain and gusty, high wind conditions.NTSB DEN93LA105Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMImproper planning and decision making by the pilot in command in descending into a valley at an altitude providing no escape route in mountainous terrain.NTSB DEN87FA011Accident · Serious injuriesField investigationFinal reportCessna 172P · Gallup, NMWhile flying at a low level spotting deer in mountainous terrain the plt attempted to fly over a ridgeline with terrain that rose faster than the acft climb capability. At low airspeed and altitude he initiated a turn to reverse course toward lower terrain.…NTSB DEN86LA218Accident · No injuriesLimited investigationFinal reportCessna 172P · Albuquerque, NMAccording to the instructor (CFI), the student was making a practice landing when a sudden windshift occurred. He rprtd that when they were on the downwind for their 5th landing, the wind was from the wsw, but just before the landing, it changed to a…NTSB DEN86LA161Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Santa Fe, NMThe plt stated that shortly after takeoff the engine began running rough and she was cleared by the tower to land on any rwy. The plt chose rwy 10. She added one notch of flaps over the rwy threshold and the acft continued to float, touching down with 1/3 of…NTSB DEN85LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Rio Rancho, NMDuring a pleasure flt, with his parents as pax, the plt decided to demonstrate a glide down to aprx 500 ft AGL. When he added power for recovery, he stalled the acft. Before complete recovery was possible, the acft struck the ground.NTSB DEN85LA171Accident · No injuriesLimited investigationFinal reportCessna 172 · Gallup, NMOn June 23, 1985, a student plt flying a C-172 departed the side of the rwy whole landing at Gallup, NM. He said that the landing was made at too high an airspeed. Upon departing the rwy the acft proceeded into a ditch causing substantial damage.NTSB DEN85FA118Accident · 2 fatalField investigationFinal reportCessna 172 P · Santa Fe, NMTwo persons, neither rated as plts, took the acft without the knowledge or consent of the operator or arpt officials. They took off at night, & after a short time, returned to the arpt to land. During an attempted landing, the acft touched down hard, bounced…NTSB DEN84LA243Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Santa Fe, NMThe acft bounced several times on landing following an excessively high fast approach. The plt added power to recover by aborting the landing. The plt stated the failure to use right rudder resulted in the acft veering to the left and the failure to retract…NTSB FTW82DA348Accident · No injuriesFinal reportCessna 172P · Albuquerque, NMThe student pilot lost control of the aircraft after a bounced landing. The aircraft ran off the side of the runway, encountered sandy terrain, and was damaged. The density altitude was about 7000 ft.NTSB FTW82DA184Accident · No injuriesFinal reportCessna 172P · Las Cruces, NMThe student pilot reported that during landing, the airspeed was too high. Reportedly, the aircraft touched down hard on all three gear, propoised, and subsequently, the plane was damaged. The wind was reported as light and variable.NTSB FTW82DA121Accident · Minor injuriesFinal reportCessna 172P · Albuquerque, NMThe aircraft with a full load at a high density altitude (7800 feet) failed to climb. Upon turning downwind at low altitude the aircraft appeared to stall and collide with the ground.