NTSB investigations: Piper PA-30, Outside the U.S.
13 cases on aircraft the registry lists as Piper PA-30. 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
| 1966 | 1 |
|---|---|
| 1967 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1975 | 1 |
| 1987 | 1 |
| 1996 | 1 |
| 2009 | 1 |
| 2014 | 1 |
| 2021 | 2 |
| 2022 | 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 ('7103002'))
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 ('7103002'))
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 GAA22WA121Accident · No injuriesClass 5 · ForeignPiper PA-30 · Sandown, United KingdomNTSB GAA21WA263Accident · No injuriesClass 5 · ForeignPiper PA-30 · Saint-Honorat, FranceNTSB GAA21WA137Accident · No injuriesClass 4 · ForeignPiper PA-30 · Courcelles-sur-Viosnes, FranceNTSB ERA14WA187Accident · 1 fatalForeign investigationPiper PA-30 · Collagna, ItalyOn April 4, 2014, at 0920 Coordinated Universal Time (UTC), a Piper PA-30, N678AL, was destroyed when it impacted terrain during cruise flight near Collagna, Italy. The pilot, the sole occupant, was fatally injured. The flight was operated by a private…NTSB ERA09WA291Accident · 2 fatalForeign investigationPiper PA-30 · Port Sudan, SudanOn May 10, 2009, at 0530 universal coordinated time (0830 local time), a Piper PA-30, N502TC, was destroyed when it impacted mountainous terrain about 26 nautical miles northwest of Port Sudan, Sudan. The two Yemani pilots onboard were fatally injured. The…NTSB NYC96WA175Accident · 2 fatalForeign investigationPiper PA-30 · North Italy, ItalyNTSB LAX87WA216Accident · Minor injuriesForeign investigationPiper PA-30 · Mexicali, MexicoNTSB NYC76ON004Accident · 2 fatalClosedPiper PA-30 · S Coast, Canary IslandsNTSB UNK73X0104Accident · 4 fatalClosedPiper PA-30 · Mrn Diablotin, DRNTSB MIA72RM007Accident · 1 fatalClosedPiper PA-30 · T.Cay, Burkina FasoNTSB CAN72AP905Accident · 2 fatalClosedPiper PA-30 · Prince George, CanadaNTSB MIA68D0318Accident · No injuriesClosedPiper PA-30 · Hawks Nest, Burkina FasoNTSB UNK66X0165Accident · 4 fatalClosedPiper PA-30 · Uruapan, Mexico