# NTSB investigations: Cessna R172E, 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 WPR23LA365](https://openairdocs.org/ntsb/WPR23LA365.md): Cessna R172E · Alamogordo, NM · Accident · No injuries · Class 4 · Limited · Final report · Jun 28, 2023 · N7881N · Substantial damage
  > Failure of the pilot to maintain control of the airplane during the landing.
- [NTSB CEN10CA267](https://openairdocs.org/ntsb/CEN10CA267.md): Cessna R172E · Alamogordo, NM · Accident · No injuries · Data collection · Final report · Mar 22, 2010 · N7871N · Substantial damage
  > An unknown event that resulted in damage to the airplane's firewall.
- [NTSB DEN06CA077](https://openairdocs.org/ntsb/DEN06CA077.md): Cessna R172E (T-41C) · Albuquerque, NM · Accident · No injuries · Data collection · Final report · May 17, 2006 · N7898N · Substantial damage
  > the pilot's failure to maintain aircraft control. A contributing factor was the wind gust.
- [NTSB DEN03TA103](https://openairdocs.org/ntsb/DEN03TA103.md): Cessna R172E · Albuquerque, NM · Accident · No injuries · Final report · Jun 12, 2003 · N7867N · Substantial damage
  > the student pilot's inadvertent encounter with the jet blast and the subsequent inability to maintain aircraft control.
- [NTSB DEN84FA251](https://openairdocs.org/ntsb/DEN84FA251.md): Cessna R172E · Farmington, NM · Accident · 2 fatal · Field investigation · Final report · Aug 6, 1984 · N601SP · Destroyed
  > After being airborne 1 hour and 10 minutes the traffic surviellance flt was cancelled. The plt transmitted to the policeunits on the ground that he would 'buzz' them as he left the area. During this pass the acft struck a high voltage transmission line 88.9…

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

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