# NTSB investigations: Piper PA-24-180, 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 FTW96LA187](https://openairdocs.org/ntsb/FTW96LA187.md): Piper PA-24-180 · Carlsbad, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1996 · N7256P · Substantial damage
  > The pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the sudden windshift and/or windshear.
- [NTSB FTW83LA196](https://openairdocs.org/ntsb/FTW83LA196.md): Piper PA 24-180 · Socorro, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1983 · N5064P · Destroyed
  > The acft was returning from a cross-country flt and crash landed about 1 mile from the arpt when the engine quit. The pilot said he added power to reach the rwy but the engine would not respond. The acft impacted the ground and slid to a stop. An FAA…
- [NTSB DEN78FA023](https://openairdocs.org/ntsb/DEN78FA023.md): Piper PA-24 · Pojoaque, NM · Accident · 1 fatal · Closed · Feb 10, 1978 · N6000D · Substantial damage
- [NTSB DEN78DQD01](https://openairdocs.org/ntsb/DEN78DQD01.md): Piper PA-24 · Las Cruces, NM · Accident · No injuries · Closed · Oct 13, 1977 · N510GQ · Substantial damage
- [NTSB DEN74AD006](https://openairdocs.org/ntsb/DEN74AD006.md): Piper PA-24 · Weed, NM · Accident · 1 fatal · Closed · Aug 5, 1973 · N5879P · Destroyed
- [NTSB DEN73FQA11](https://openairdocs.org/ntsb/DEN73FQA11.md): Piper PA-24 · Reserve, NM · Accident · No injuries · Closed · Aug 17, 1972 · N6755P · Substantial damage
- [NTSB DEN73FQA08](https://openairdocs.org/ntsb/DEN73FQA08.md): Piper PA-24 · Las Vegas, NM · Accident · Serious injuries · Closed · Aug 2, 1972 · N5183P · Destroyed
- [NTSB DEN70FQA01](https://openairdocs.org/ntsb/DEN70FQA01.md): Piper PA-24 · Albuquerque, NM · Accident · No injuries · Closed · Jan 5, 1970 · N5666P · Substantial damage
- [NTSB DEN66A0035](https://openairdocs.org/ntsb/DEN66A0035.md): Piper PA-24 · Santa Fe, NM · Accident · 1 fatal · Closed · Nov 22, 1965 · N5542P · 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 ('7102403'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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