# NTSB investigations: Piper PA-34-220T: 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 FTW88FA161](https://openairdocs.org/ntsb/FTW88FA161.md): Piper PA-34-220T · Carthage, TX · Accident · 5 fatal · Field investigation · Final report · Sep 4, 1988 · N83874 · Destroyed
  > Drg a night arrival, the plt rprtd he could make a visual apch. At 2341:37 CDT, the ARTCC controller informed him the destn arpt was straight ahead at 12 mi & requested that he rprt when the arpt was in sight. At 2343:30, he rprtd the rwyin sight & the…
- [NTSB FTW85FA104](https://openairdocs.org/ntsb/FTW85FA104.md): Piper PA-34-220T · Victoria, TX · Accident · 1 fatal · Field investigation · Final report · Jan 30, 1985 · N8204A · Destroyed
  > The plt had rented the acft on January 28, 1985, with route of flt unknown. No reported contact was made with the acft. The acft impacted the surface during hours of darkness in instrument meteorological conditions and was demolished. The plt was fatally…
- [NTSB NYC84FA247](https://openairdocs.org/ntsb/NYC84FA247.md): Piper PA-34-220T · Newcomb, NY · Accident · 2 fatal · Field investigation · Final report · Jul 17, 1984 · N8345A · Destroyed
  > The flight was operating in accordance with f.a.r. part 135.the plt filed a VFR flt plan and was cruising at an altitude of 5,500 ft when clouds were encountered. The plt attempted to descend to 3,500 but collided with the santanonimountain at an elevation of…
- [NTSB FTW83FA298](https://openairdocs.org/ntsb/FTW83FA298.md): Piper PA-34-200T · Canjilon, NM · Accident · 4 fatal · Field investigation · Final report · Nov 3, 1982 · N8096D · Destroyed
  > Prior to departing helena, mt at 1209, the plt received a wx briefing from the great falls fss. The dfw 021240Z area forecast, valid until 0700Z on 11/3/82, was not available. The fss briefer made this deficiency known to the plt & recommended that he receive…

## 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 ('7103420', '7103223')
    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=7103420&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.