# NTSB investigations: Piper PA-12, WY

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 SEA93FA151](https://openairdocs.org/ntsb/SEA93FA151.md): Piper PA-12 · Laramie, WY · Accident · 1 fatal · Field investigation · Final report · Jul 8, 1993 · N3108M · Substantial damage
  > Poor inflight planning and an inadvertent stall.
- [NTSB SEA92LA196](https://openairdocs.org/ntsb/SEA92LA196.md): Piper PA-12 · Cokeville, WY · Accident · No injuries · Limited investigation · Final report · Sep 6, 1992 · N78599 · Substantial damage
  > Fatigue failure of the crankshaft. Factors include non suitable terrain for a forced landing and an improper propeller.
- [NTSB DEN84LA132](https://openairdocs.org/ntsb/DEN84LA132.md): Piper PA-12 · Jackson, WY · Accident · No injuries · Limited investigation · Final report · Apr 20, 1984 · N2577M · Substantial damage
  > The acft crashed during takeoff from Jackson airport. Investigation revealed that the plt and CFI were in the process of ferrying the acft to Washington state. The plt stated that during taxi the airport UNICOM reported the wind to be from the northeast at 18…
- [NTSB DEN84LA111](https://openairdocs.org/ntsb/DEN84LA111.md): Piper PA-12-115 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Mar 19, 1984 · N4378M · Substantial damage
  > The plt stated that a convair 580 had landed before him. The plt flew a normal glide slope & planned to land on the approach end of the rwy. On short final at 50 ft AGL, the acft suddenly banked 'over 90 degrees' to the left out of control. The acft then hit…
- [NTSB DEN81DTC23](https://openairdocs.org/ntsb/DEN81DTC23.md): Piper PA-12 · Cody, WY · Accident · No injuries · Closed · Aug 19, 1981 · N3622M · Substantial damage
- [NTSB DEN77DTC04](https://openairdocs.org/ntsb/DEN77DTC04.md): Piper PA-12 · Rock Springs, WY · Accident · No injuries · Closed · Dec 17, 1976 · N3277M · 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" = 'WY' 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 ('7101202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7101202&state=WY

---
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.
