# NTSB investigations: Piper PA-31-310: 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 MIA91LA071](https://openairdocs.org/ntsb/MIA91LA071.md): Piper PA-31-B-310 · Fernandina Bch, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1991 · N31HL · Substantial damage
  > Delay by the pilot to perform a missed approach and failure to correct the descent before impact with terrain.
- [NTSB MIA88LA040](https://openairdocs.org/ntsb/MIA88LA040.md): Piper PA-31-310 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 1987 · N112AG · Substantial damage
  > The plt stated that while enroute to West Palm Beach, she encountered severe turbulence. The aft cabin door popped open but remained attached and the flt was continued and lndd w/o further incident. As the plt attempted to restart the engs for the return trip…
- [NTSB FTW84LA138](https://openairdocs.org/ntsb/FTW84LA138.md): Piper PA-31 · Brownsville, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1984 · N7415L · Substantial damage
  > The plt was maneuvering for an ILS approach when he collided with the ground. He said he was distracted by the swinging CDI and was below the glide slope. He said he started to add power for a missed approach and the acft impacted the ground. A passenger said…

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