# NTSB investigations: Piper PA 46-350P: 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 FTW99FA104](https://openairdocs.org/ntsb/FTW99FA104.md): Piper PA-46-350P · Waldron, AR · Accident · 1 fatal · Field investigation · Final report · Apr 4, 1999 · N497CA · Destroyed
  > The pilot's encounter with adverse weather and loss of aircraft control, which resulted in exceeding the aircraft's design stress limits. Factors were the pilot's lack of total experience in the make and model of airplane, and the icing and thunderstorm…
- [NTSB DEN99LA026](https://openairdocs.org/ntsb/DEN99LA026.md): Piper PA-46-350P · Granby, CO · Accident · No injuries · Limited investigation · Final report · Dec 15, 1998 · N9255B · Substantial damage
  > The in-flight encounter with clear air turbulence during descent.
- [NTSB IAD98FA106](https://openairdocs.org/ntsb/IAD98FA106.md): Piper PA-46-350P · Centerville, NY · Accident · 5 fatal · Field investigation · Final report · Sep 7, 1998 · N9150X · Destroyed
  > The pilot's inadvertent flight into adverse weather conditions. Factors related to the accident were the pilot's failure to use weather detection equipment and use of airspeeds in excess of limitations.
- [NTSB DEN90FA027](https://openairdocs.org/ntsb/DEN90FA027.md): Piper PA-46P-350 · Des Moines, IA · Accident · Serious injuries · Field investigation · Final report · Nov 27, 1989 · N919S · Destroyed
  > Loss of engine power for undetermined reason(s). The light conditions (dusk) and trees in in the emergency landing area were considered to be contributing factors.

## 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 ('7104620', '7104619', '7104627', '7104618')
    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=7104620&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.