NTSB investigations: Piper PA-32-300, Outside the U.S.

18 cases on aircraft the registry lists as Piper PA-32-300. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

NTSB investigations: Piper PA-32-300, Outside the U.S. per year, 1967–2026: 18 cases
1967	1
1974	2
1975	1
1976	2
1977	1
1988	1
1992	1
1996	1
1997	1
1999	1
2000	1
2003	1
2006	1
2010	1
2018	1
2022	1

Latest cases

Query with 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103212')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7103212'))
  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 ('7103212'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 GAA22WA306Accident · Minor injuriesClass 5 · ForeignPiper PA32 · Nassau, BahamasJan 31, 2022 · N1215H · Destroyed NTSB CEN18WA379Accident · No injuriesForeign investigationPiper PA32 · Belize City, BelizeOn August 29, about 1804 local time (LCL), a Piper PA32 300 airplane, N3073W, operated by Wings of Hope, had a hard landing at the Sir Barry Bowen Municipal Airport, in Belize City, Belize. The airplane originated from the San Pedro Airport.This investigation…Aug 29, 2018 · N3073W · Substantial damage NTSB ERA10WA116Accident · 3 fatalForeign investigationPiper PA-32-300 · Bimini, Bahamas, BahamasOn January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…Jan 17, 2010 · N4219R · Destroyed NTSB LAX06FA258Accident · Serious injuriesField investigationFinal reportPiper PA-32-300 · Saipan, SarkA loss of engine power during the initial climb due to fuel starvation resulting from the pilot's improper fuel selector valve position selection and his failure to select a tank containing an adequate fuel supply. Contributing to the accident was the high…Aug 11, 2006 · N4509T · Destroyed NTSB MIA04FAMS1Accident · 1 fatalMissing aircraftFinal reportPiper PA-32-300 · Missing, BahamasUndetermined.Nov 13, 2003 · N8224C · Destroyed NTSB MIA00WA209Accident · Serious injuriesForeign investigationPiper PA32-300 · Staniel Cay, BahamasJul 8, 2000 · N7638F · Substantial damage NTSB SEA99WA117Accident · 2 fatalForeign investigationPiper PA-32-300 · Clinton, CanadaJul 15, 1999 · N2947K · Destroyed NTSB LAX98LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Saipan, MaliThe loss of engine power for undetermined reasons that resulted in the pilot ditching the aircraft into the ocean.Nov 26, 1997 · N1256H · Destroyed NTSB MIA97WA017Accident · 2 fatalForeign investigationPiper PA-32-300 · St. Vincent, WNOct 31, 1996 · N970CA · Destroyed NTSB MIA92WA119Accident · 1 fatalForeign investigationPiper PA-32-300 · San Michele, HaitiApr 29, 1992 · N4026W · Destroyed NTSB LAX88WA165Accident · 1 fatalForeign investigationPiper PA28 · Mulege, MexicoApr 15, 1988 · N4134W · Destroyed NTSB MIA77FA069Accident · 2 fatalClosedPiper PA-32 · Andros Is, Burkina FasoJul 16, 1977 · N4434F · Destroyed NTSB LAX770A001Accident · No injuriesClosedPiper PA-34 · Santa Clara, MexicoOct 23, 1976 · N9AZ · Substantial damage NTSB LAX76O0018Accident · No injuriesClosedPiper PA-32 · Cabo Sn Lucas, MexicoMay 22, 1976 · N55571 · Substantial damage NTSB MIA76OKT26Accident · No injuriesClosedPiper PA-32 · West End, Burkina FasoSep 28, 1975 · N8901N · Destroyed NTSB MIA75OKT29Accident · Serious injuriesClosedPiper PA-32 · Cay Verde, Burkina FasoNov 15, 1974 · N56481 · Substantial damage NTSB LAX75OL010Accident · No injuriesClosedPiper PA-32 · San Quinton, MexicoJul 4, 1974 · N4254R · Substantial damage NTSB MIA67D0424Accident · Minor injuriesClosedPiper PA-32 · Mayaguana Is. Bwi, Burkina FasoMar 5, 1967 · N4101W · Destroyed