# NTSB investigations: Cessna 172A, 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 DFW08LA217](https://openairdocs.org/ntsb/DFW08LA217.md): Cessna 172A · Albuquerque, NM · Accident · Limited investigation · Final report · Aug 28, 2008 · N6539B · Substantial damage
  > The pilot's failure to maintain proper glide angle during the landing approach which resulted in a collision with a pole. Contributing to the accident were the pilot's lack of qualification, experience and the high density altitude.
- [NTSB FTW02LA084](https://openairdocs.org/ntsb/FTW02LA084.md): Cessna 172A · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Feb 22, 2002 · N6845X · Substantial damage
  > the pilot's delay in executing a go-around while conducting a simulated emergency landing, which resulted in an in flight collision with terrain.
- [NTSB DEN86LA053](https://openairdocs.org/ntsb/DEN86LA053.md): Cessna 172A · Anthony, NM · Accident · No injuries · Limited investigation · Final report · Dec 22, 1985 · N7451T · Substantial damage
  > The plt was practicing emer ldgs on a dirt road. During the last ldg which resulted in an accident, he allowed his attention to be diverted momentarily to inside the cockpit and he lost control of the acft. The acft veered off the roadand sustained…

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

This list as a web page: https://openairdocs.org/ntsb?model=2072404&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.