NTSB investigations: Piper PA-46-310P, Outside the U.S.
9 cases on aircraft the registry lists as Piper PA-46-310P. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1987 | 1 |
|---|---|
| 1992 | 1 |
| 1996 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2026 | 1 |
Latest cases
Query with SQL
duckdb -csv -c "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.\"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'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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."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'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA26WA139Accident · No injuriesClass 5 · ForeignPiper PA46 · Mayaguana, BahamasNTSB WPR21WA026AccidentClass 4 · ForeignPiper PA46 · Limpopo Province, South AfricaNTSB CEN19WA057Accident · 2 fatalForeign investigationPiper PA46 · St. Peter Port, United KingdomOn January 21, 2013, about 2012 UTC, a Piper PA-46-301P, N264DB, operated by a private individual, disappeared from radar 15 nm north of Guernsey, Channel Island, United Kingdom. The airplane is believed to have crashed in English Channel and is presumed…NTSB NYC08WA212Accident · No injuriesForeign investigationPiper PA-46-310P · Milano Linate, ItalyNTSB MIA07LA073Accident · 2 fatalLimited investigationFinal reportPiper PA-46-310P · Bird Cay, BahamasThe pilot's poor in-flight weather evaluation, which resulted in flight into a level 6 thunderstorm.NTSB CHI05WA008Accident · 4 fatalForeign investigationPiper PA-46-310P · Dijon Longvic, FranceNTSB NYC96WA070Accident · 5 fatalForeign investigationPiper PA-46 · ZambiaNTSB LAX92WA231Accident · Minor injuriesForeign investigationPiper PA-46-310P · Yokota, JapanNTSB LAX88WA067Accident · No injuriesForeign investigationPiper PA46 · Guaymas, Mexico