# NTSB investigations: Piper PA-28R-201: In flight encounter with weather

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 DEN02LA049](https://openairdocs.org/ntsb/DEN02LA049.md): Piper PA-28R-201 · Beaver, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 2002 · N171M · Substantial damage
  > the pilot's selection of unsuitable terrain on which to make a forced landing. Contributing factors were mountain waves (wind shear) and crosswind.
- [NTSB LAX91FA045](https://openairdocs.org/ntsb/LAX91FA045.md): Piper PA-28R-201 · Show Low, AZ · Accident · 1 fatal · Field investigation · Final report · Nov 26, 1990 · N31638 · Destroyed
  > The pilot's improper in-flight planning/decision, which resulted in loss of engine power, due to induction system icing. Factors related to the accident were: the adverse weather condition and lack of a suitable area for a forced landing.
- [NTSB ATL87FA104](https://openairdocs.org/ntsb/ATL87FA104.md): Piper PA-28R-201 · Rhine, GA · Accident · 1 fatal · Field investigation · Final report · Apr 3, 1987 · N47887 · Destroyed
  > The non-instrumented rated plt continued into an area of known wx conditions. The left wing separated in flight. Failure of it was typical of overload fractures. The wreckage was scattered over an area about 3500 feet long and 200 feet wide.
- [NTSB NYC86LA170](https://openairdocs.org/ntsb/NYC86LA170.md): Piper PA-28R-201 · West Dover, VT · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1986 · N43792 · Substantial damage
  > Shortly after liftoff, the aircraft encountered a tailwind and downdraft forcing the aircraft downward and subsequently impacted trees and collided with the ground.
- [NTSB NYC85LA094](https://openairdocs.org/ntsb/NYC85LA094.md): Piper PA-28R-201 · Red Hook, NY · Accident · No injuries · Limited investigation · Final report · Mar 31, 1985 · N2263Q · 2 aircraft · Substantial damage
  > During flt, a Piper PA-32R-201, N2263Q, & a bainbridge jodel F-12, N5700, encountered structural icing conditions. The windshields of both acft became covered with ice which restricted the forward visibility of the occupants in both acft. N5700 landed 1st.…
- [NTSB NYC84FA129](https://openairdocs.org/ntsb/NYC84FA129.md): Piper PA-28R-201 · Burlington, CT · Accident · 1 fatal · Field investigation · Final report · Apr 14, 1984 · N9487C · Destroyed
  > The acft crashed in a steep right descending turn shortly after takeoff. The student plt flying the acft had been scheduled to fly that day but the instructor canceled the flt on account of weather. The acft was seen taxiing out ABOUT1230. After takeoff the…
- [NTSB ATL82FA278](https://openairdocs.org/ntsb/ATL82FA278.md): Piper PA-28R-201 · Alma, GA · Accident · 2 fatal · Field investigation · Final report · Sep 10, 1982 · N39685 · Destroyed
  > During his wx briefing at 0731 the plt was advised that VFR flt was not recommended. The acft crashed in a cornfield after an inflight separation of the stabilators & wings. Local residents recalled that the rain showers were rather heavy at times on the day…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102816', '7102833')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102816&occurrence=240

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