# NTSB investigations: Cessna 172K, 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 DEN90LA163](https://openairdocs.org/ntsb/DEN90LA163.md): Cessna 172 · Grants, NM · Accident · No injuries · Limited investigation · Final report · Jul 16, 1990 · N46593 · Substantial damage
  > The pilot's failure to maintain directional control.
- [NTSB DEN87LA180](https://openairdocs.org/ntsb/DEN87LA180.md): Cessna 172K · Tierra Amrilla, NM · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1987 · N84704 · Substantial damage
  > No witnesses were found who had seen the accident. The man believed to be the plt gave the investigating police officer an assumed name. The wreckage dissappeared soon after the crash and has not been found to date. The acft attempted a takeoff with four…
- [NTSB DEN72FQA16](https://openairdocs.org/ntsb/DEN72FQA16.md): Cessna 172K · Santa Fe, NM · Accident · Minor injuries · Closed · Sep 4, 1971 · N7065G · Destroyed

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

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