NTSB investigations: Piper PA-31-350, Outside the U.S.
14 cases on aircraft the registry lists as Piper PA-31-350. 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
| 1981 | 1 |
|---|---|
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2010 | 1 |
| 2021 | 2 |
| 2023 | 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 ('7103110', '7103125'))
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 ('7103110', '7103125'))
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 GAA26WA092Accident · No injuriesClass 5 · ForeignPiper PA31 · Las Cayes, HaitiNTSB GAA23WA240IncidentClass 4 · ForeignPiper PA-31-350 · North Eleuthera, BahamasNTSB GAA21WA076Accident · 1 fatalClass 4 · ForeignPiper PA-31-350 · South Bimini, BahamasNTSB GAA21WA051Accident · No injuriesClass 5 · ForeignPiper PA-31-350 · Buitron, MexicoNTSB ERA10WA489Accident · No injuriesForeign investigationPiper PA-31-350 · South Bimini, BahamasOn September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…NTSB FTW03WA032Accident · 1 fatalForeign investigationPiper PA-31-350 · Cambita, Dominican RepublicNTSB LAX98WA073Accident · No injuriesForeign investigationPiper PA-31 · PhilippinesNTSB MIA98WA041Accident · Minor injuriesForeign investigationPiper PA-31-350 · Walker Cay, BahamasNTSB NYC97RA006Accident · 8 fatalForeign investigationPiper PA-31-350 · Eel River Cross, CanadaNTSB MIA94WA145Accident · No injuriesForeign investigationPiper PA-31-350 · Herrera, Dominican RepublicNTSB MIA93WA043Accident · No injuriesForeign investigationPiper PA-31-350 · Bimini, BahamasNTSB MIA92WA060Accident · No injuriesForeign investigationPiper PA-31-350 · Nagua, Dominican RepublicNTSB MIA91WA056Accident · Minor injuriesForeign investigationPiper PA-31-350 · Rock Sound, BahamasNTSB MIA81DA077Accident · No injuriesClosedPiper PA-31 · Grand Cayman, Burkina Faso