# NTSB investigations: Piper PA-28RT-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 IAD01FA096](https://openairdocs.org/ntsb/IAD01FA096.md): Piper PA-28RT-201 · Rohrersville, MD · Accident · 3 fatal · Field investigation · Final report · Aug 11, 2001 · N2869F · Destroyed
  > The pilot's continued VFR flight into obscured, mountanous terrain. Factors included the rising terrain and weather obscuration.
- [NTSB BFO93FA093](https://openairdocs.org/ntsb/BFO93FA093.md): Piper PA-28RT-201 · Hancock, MD · Accident · 1 fatal · Field investigation · Final report · May 17, 1993 · N8247G · Destroyed
  > Improper planning/decision by the pilot, his initiation of VFR flt into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were fog, rain, the pilot's self induced…
- [NTSB SEA84FA068](https://openairdocs.org/ntsb/SEA84FA068.md): Piper PA-28RT-201 · Hood River, OR · Accident · 6 fatal · Field investigation · Final report · Mar 12, 1984 · N8301T · Destroyed
  > After crossing the dalles at 12,500 ft MSL, the plt reported to ARTCC he was entering solid clouds. He subsequently reported level at 3,000 ft MSL followed by 'if ah we can't stay VFR we'll go ahead and climb up to about five and file IFR.' The acft was…
- [NTSB NYC82DA057](https://openairdocs.org/ntsb/NYC82DA057.md): Piper PA-28RT-201 · Avoca, PA · Accident · No injuries · Final report · Mar 17, 1982 · N2962W · Substantial damage
  > The pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of…

## 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 ('7102818')
    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=7102818&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.