# Fatal NTSB investigations: Piper PA 46-350P, Outside the U.S.

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 GAA24WA072](https://openairdocs.org/ntsb/GAA24WA072.md): Piper PA 46-350P · Ramos Arizpe, Coahuila,, Mexico · Accident · 4 fatal · Class 5 · Foreign · Jan 5, 2024 · N6074A · Destroyed
- [NTSB GAA23WA042](https://openairdocs.org/ntsb/GAA23WA042.md): Piper PA 46-350P · Happy Valley-Goose Bay, Canada · Accident · 1 fatal · Class 5 · Foreign · Dec 14, 2022 · N5EQ · Destroyed
- [NTSB GAA19WA248](https://openairdocs.org/ntsb/GAA19WA248.md): Piper PA46 · Rigolet, NL, Canada · Accident · 1 fatal · Foreign investigation · May 1, 2019 · N757NY · Destroyed
- [NTSB CEN16WA045](https://openairdocs.org/ntsb/CEN16WA045.md): Piper PA 46 350P · Taunton, United Kingdom · Accident · 4 fatal · Foreign investigation · Nov 14, 2015 · N186CB · Destroyed
- [NTSB CEN15WA133](https://openairdocs.org/ntsb/CEN15WA133.md): Piper PA 46 350P · Meyrin, Switzerland · Accident · 1 fatal · Foreign investigation · Jan 30, 2015 · N246PR · Destroyed
- [NTSB CEN09WA091](https://openairdocs.org/ntsb/CEN09WA091.md): Piper PA46 · Baden, Austria · Accident · 2 fatal · Class 5 · Foreign · Dec 14, 2008 · N403HP · Destroyed
- [NTSB DEN08WA094](https://openairdocs.org/ntsb/DEN08WA094.md): Piper PA-46-350P · Léguillac-de-l'Auche, France · Accident · 2 fatal · Foreign investigation · May 25, 2008 · N9245D · Destroyed
- [NTSB FTW04WA048](https://openairdocs.org/ntsb/FTW04WA048.md): Piper PA-46 · Guaymas, Mexico · Accident · 2 fatal · Foreign investigation · Dec 13, 2003 · N9223X · Destroyed
- [NTSB NYC00WA015](https://openairdocs.org/ntsb/NYC00WA015.md): Piper PA-46-350P · Cranbrook, Canada · Accident · 1 fatal · Foreign investigation · Oct 18, 1999 · N90D · Destroyed

## 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."eventCountry" <> 'USA'
  AND c."highestInjuryLevel" = 'Fatal'
  AND 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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=7104620&state=OF

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
