# NTSB investigations: Piper PA-46-310P: 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 MIA07LA073](https://openairdocs.org/ntsb/MIA07LA073.md): Piper PA-46-310P · Bird Cay, Bahamas · Accident · 2 fatal · Limited investigation · Final report · Apr 10, 2007 · N444JH · Destroyed
  > The pilot's poor in-flight weather evaluation, which resulted in flight into a level 6 thunderstorm.
- [NTSB ATL04FA077](https://openairdocs.org/ntsb/ATL04FA077.md): Piper PA-46-310P · Arlington, AL · Accident · 2 fatal · Field investigation · Final report · Feb 23, 2004 · N9103Z · Destroyed
  > The pilots inadequate in-flight planning/decision and his failure to maintain aircraft control, resulting in an in-flight encounter with a thunderstorm and exceeding the design limits of the aircraft.
- [NTSB MIA02FA111](https://openairdocs.org/ntsb/MIA02FA111.md): Piper PA-46-310P · Osteen, FL · Accident · 3 fatal · Field investigation · Final report · Jun 15, 2002 · N9143B · Destroyed
  > the pilot's inadequate weather evaluation and his failure to maintain control of the airplane after entering an area of thunderstorms resulting in an in-flight separation of the right wing and right horizontal stabilizer and impact with the ground during an…
- [NTSB CHI89FA101](https://openairdocs.org/ntsb/CHI89FA101.md): Piper PA-46-310P · Bristol, IN · Accident · 3 fatal · Field investigation · Final report · May 31, 1989 · N9114B · Destroyed
  > Continued flight by the pilot into known adverse weather and his exceeding the design stress limits of the aircraft, which resulted in failure of the wing spars and separation of the right wing and empennage (stabilizers). Contributing factors were: continued…
- [NTSB CHI86FA108](https://openairdocs.org/ntsb/CHI86FA108.md): Piper PA-46-310P · Boyne Falls, MI · Accident · 2 fatal · Field investigation · Final report · Mar 23, 1986 · N43769 · Destroyed
  > After the plt was cleared for an rnav-b apch, the acft crashed on hilly trrn aprx 3 mi se of the arpt at an elev of 750'MSL. Impact occurred after the acft had turned to the sse & was dscndg. Min dscnt alt (mda) for the apch was 1680'. No preimpact mechanical…

## 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 ('7104605', '7104611', '7104624')
    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=7104605&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.
