# NTSB investigations: Piper PA-28-140, 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 WPR09CA193](https://openairdocs.org/ntsb/WPR09CA193.md): Piper PA-28-140 · Dubois, WY · Accident · Minor injuries · Data collection · Final report · Apr 13, 2009 · N945RH · Substantial damage
  > The pilot's encounter with a windshear/downdraft that exceeded the climb performance capabilities of the airplane.
- [NTSB SEA97LA093](https://openairdocs.org/ntsb/SEA97LA093.md): Piper PA-28-140 · Rawlins, WY · Accident · No injuries · Limited investigation · Final report · Apr 26, 1997 · N6121J · Substantial damage
  > The pilot's inadequate preflight planning. Factors include high density altitude, downdrafts, and rough/uneven terrain in the area where the pilot attempted the emergency landing.
- [NTSB DEN88LA195](https://openairdocs.org/ntsb/DEN88LA195.md): Piper PA-28-140 · Rawlins, WY · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1988 · N5873U · Substantial damage
  > Plt and pax were on a flight from milwaukee, WI, to las vegas, NV. The plt made an unscheduled stop at Rawlins due to poor vis and low fuel. The airplane was loaded with suit cases, camping gear, coolers and full fuel. The pilot and pax combined weight was…
- [NTSB DEN87FA036](https://openairdocs.org/ntsb/DEN87FA036.md): Piper PA-28-140 · Rawlins, WY · Accident · 2 fatal · Field investigation · Final report · Dec 29, 1986 · N4388X · Destroyed
  > The plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway.
- [NTSB DEN81FTC20](https://openairdocs.org/ntsb/DEN81FTC20.md): Piper PA-28 · Sundance, WY · Accident · Minor injuries · Closed · Jul 11, 1981 · N33533 · Substantial damage
- [NTSB DEN78FTC30](https://openairdocs.org/ntsb/DEN78FTC30.md): Piper PA-28 · Casper, WY · Accident · No injuries · Closed · Jun 25, 1978 · N4151J · Substantial damage
- [NTSB DEN74DTC09](https://openairdocs.org/ntsb/DEN74DTC09.md): Piper PA-28 · Laramie, WY · Accident · No injuries · Closed · Aug 16, 1973 · N95477 · Substantial damage
- [NTSB DEN73FTC18](https://openairdocs.org/ntsb/DEN73FTC18.md): Piper PA-28 · Cheyenne, WY · Accident · Minor injuries · Closed · Jan 28, 1973 · N7240F · Substantial damage
- [NTSB DEN73DTC15](https://openairdocs.org/ntsb/DEN73DTC15.md): Piper PA-28 · Lamont, WY · Accident · No injuries · Closed · Dec 23, 1972 · N8185N · Substantial damage
- [NTSB DEN73DTC14](https://openairdocs.org/ntsb/DEN73DTC14.md): Piper PA-28 · Cheyenne, WY · Accident · No injuries · Closed · Dec 17, 1972 · N470FL · Substantial damage
- [NTSB DEN71DXA08](https://openairdocs.org/ntsb/DEN71DXA08.md): Piper PA-28 · Fort Laramie, WY · Accident · No injuries · Closed · Aug 29, 1970 · N6113W · Substantial damage
- [NTSB DEN68D0099](https://openairdocs.org/ntsb/DEN68D0099.md): Piper PA-28 · Cheyenne, WY · Accident · No injuries · Closed · Sep 20, 1967 · N4288J · Substantial damage
- [NTSB DEN67D0056](https://openairdocs.org/ntsb/DEN67D0056.md): Piper PA-28 · Pine Bluffs, WY · Accident · Minor injuries · Closed · Jul 7, 1966 · N8814J · 2 aircraft · 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 ('7102802'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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