# NTSB investigations: Cessna 172F, NM

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB FTW01LA075](https://openairdocs.org/ntsb/FTW01LA075.md): Cessna 172F · Clovis, NM · Accident · No injuries · Limited investigation · Final report · Mar 6, 2001 · N5175F · Substantial damage
  > the pilot's failure to maintain directional control during take off roll resulting in a ground loop. A contributing factor was the crosswind.
- [NTSB FTW98LA036](https://openairdocs.org/ntsb/FTW98LA036.md): Cessna 172F · Hurley, NM · Accident · No injuries · Limited investigation · Final report · Oct 29, 1997 · N8714U · Substantial damage
  > the student pilot's failure to adequately compensate for the wind conditions. Factors included the gusty crosswind conditions and inadequate supervision of the student pilot's solo flight by his flight instructor.
- [NTSB DEN92LA087](https://openairdocs.org/ntsb/DEN92LA087.md): Cessna 172F · Folsom, NM · Accident · No injuries · Limited investigation · Final report · Aug 25, 1992 · N5101F · Substantial damage
  > Carburetor heat not used and improper use of throttle and mixture control. A factor was: the lack of suitable terrain for a forced landing.
- [NTSB FTW82DA122](https://openairdocs.org/ntsb/FTW82DA122.md): Cessna 172 · Gallup, NM · Accident · No injuries · Final report · Apr 11, 1982 · N8408U · Substantial damage
  > On the second landing of the flight the aircraft veered to the left and departed the runway. The aircraft nosed over after hitting soft dirt and a drainage ditch. The pilot stated that the aircraft swerved on the first landing and he felt that the passenger…
- [NTSB DEN79FQA38](https://openairdocs.org/ntsb/DEN79FQA38.md): Cessna 172 · Albuquerque, NM · Accident · Serious injuries · Closed · Jul 7, 1979 · N5117F · Substantial damage
- [NTSB DEN79DQA30](https://openairdocs.org/ntsb/DEN79DQA30.md): Cessna 172 · Las Vegas, NM · Accident · No injuries · Closed · Jun 3, 1979 · N5133F · Substantial damage
- [NTSB DEN73FQA07](https://openairdocs.org/ntsb/DEN73FQA07.md): Cessna 172 · Grants, NM · Accident · No injuries · Closed · Jul 9, 1972 · N5500R · Destroyed
- [NTSB DEN72AD014](https://openairdocs.org/ntsb/DEN72AD014.md): Cessna 172F · Capitan, NM · Accident · 2 fatal · Closed · Sep 18, 1971 · N5552R · Destroyed
- [NTSB DEN70DQA02](https://openairdocs.org/ntsb/DEN70DQA02.md): Cessna 172 · Los Alamos, NM · Accident · No injuries · Closed · Jan 15, 1970 · N5347R · Substantial damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 ('2072414'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072414&state=NM

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.