# NTSB investigations: Piper PA-18, 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 CEN18CA176](https://openairdocs.org/ntsb/CEN18CA176.md): Piper PA 18 · Albuquerque, NM · Accident · Minor injuries · Data collection · Final report · May 18, 2018 · N7265K · Substantial damage
  > The pilot's loss of directional control following an encounter with gusty crosswind during landing.
- [NTSB DFW08CA113](https://openairdocs.org/ntsb/DFW08CA113.md): Piper PA-18 · Santa Teresa, NM · Accident · No injuries · Data collection · Final report · Apr 23, 2008 · N1588P · Substantial damage
  > The pilot's failure to maintain aircraft control. Contributing to the accident was the strong gusty crosswinds.
- [NTSB DEN85LA248](https://openairdocs.org/ntsb/DEN85LA248.md): Piper PA-18 · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 1985 · N7467D · Substantial damage
  > While practicing touch and go landings the plt added pwr for takeoff and the eng quit. The plt veered the acft to the left to avoid hitting farm machinery and collided with a tree stump. Post accident exam of the eng revealed the eng mostlikely failed as a…
- [NTSB DEN84FA278](https://openairdocs.org/ntsb/DEN84FA278.md): Piper PA-18 · Meadow Lake, NM · Accident · 2 fatal · Field investigation · Final report · Sep 16, 1984 · N5895D · Destroyed
  > According to witnesses, the plt make a x-wind apch for a landing from west to east in winds that were from the south at 10 to 12 mph. Reportedly the acft touched down with the right wing high, then the plt applied power & initiated a go-around at about…
- [NTSB DEN75AD014](https://openairdocs.org/ntsb/DEN75AD014.md): Piper PA-18 · Corona, NM · Accident · 1 fatal · Closed · Sep 16, 1974 · N1585P · Destroyed
- [NTSB DEN73DQA48](https://openairdocs.org/ntsb/DEN73DQA48.md): Piper PA-18 · Corona, NM · Accident · No injuries · Closed · Jun 19, 1973 · N1585P · Substantial damage
- [NTSB DEN71DQA06](https://openairdocs.org/ntsb/DEN71DQA06.md): Piper PA-18 · Roswell, NM · Accident · No injuries · Closed · Aug 6, 1970 · N1122A · Substantial damage
- [NTSB DEN70D0004](https://openairdocs.org/ntsb/DEN70D0004.md): Piper PA-18 · Carrizozo, NM · Accident · No injuries · Closed · Jun 19, 1969 · N1701A · Substantial damage
- [NTSB DEN68D0225](https://openairdocs.org/ntsb/DEN68D0225.md): Piper PA-18 · Cimarron, NM · Accident · No injuries · Closed · Mar 14, 1968 · N1662P · 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 ('7101802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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