Skip to content

Fatal NTSB investigations: Piper PA-23-250, Outside the U.S.

17 cases on aircraft the registry lists as Piper PA-23-250. 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

19642026

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."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 ('7102308')) 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.\"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 ('7102308'))
  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."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 ('7102308'))
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 GAA24WA285Accident · 2 fatalClass 4 · ForeignPiper PA-23-250 · Nassau, BahamasSep 12, 2024 · N555MH · Substantial damage NTSB ERA19WA040Accident · 1 fatalForeign investigationPiper PA23 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…Nov 8, 2018 · N8383C · Substantial damage NTSB ERA18WA063Accident · 6 fatalForeign investigationPiper PA-23-250 · Nicholls Town, BahamasThe government of Bahamas has notified the NTSB of an accident involving a PIPER PA 23-250 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…Jan 17, 2018 · N62769 · Destroyed NTSB ERA16WA219Accident · 2 fatalForeign investigationPiper PA 23-250 · South Bimini, BahamasOn June 19, 2016, about 2120 UTC, a Piper PA-23, N63ZZ was destroyed when it impacted terrain during a forced landing following a loss of engine power near South Bimini International Airport, South Bimini, Bahamas. Two occupants were fatally injured during…Jun 19, 2016 · N63ZZ · Destroyed NTSB ERA13WA203Accident · 2 fatalClass 5 · ForeignPiper PA-23-250 · Georgetown, GuyanaOn April 13, 2013, about 1854 coordinated universal time, a Piper PA-23-250, N27FT, was destroyed when it impacted a residence shortly after departing from Ogle International Airport (SYGO), Georgetown, Guyana. The certificated airline transport pilot and one…Apr 13, 2013 · N27FT · Destroyed NTSB ERA10WA281Accident · 2 fatalForeign investigationPiper PA23 · North Bimini, BahamasOn May 25, 2010, at approximately 1830 eastern daylight time, a twin engine, Piper PA-23-250 airplane, N1526T, collided with power lines and crashed into the sea while flying at a low altitude shortly after takeoff from South Bimini Airport, South Bimini,…May 25, 2010 · N1526T · Substantial damage NTSB MIA06WA035Accident · 4 fatalForeign investigationPiper PA-23-250 · South Caicos, Turks & Caicos IslandsDec 26, 2005 · N444DA · Destroyed NTSB MIA03WA031Accident · 2 fatalForeign investigationPiper PA-23-250 · Freeport, BahamasDec 13, 2002 · N6568Y · Destroyed NTSB MIA98WA156Accident · 1 fatalForeign investigationPiper PA-23-250 · Walker'S Cay, BahamasMay 8, 1998 · N5813Y · Substantial damage NTSB MIA97WA181Accident · 1 fatalForeign investigationPiper PA-23-250 · Bimini, BahamasMay 4, 1997 · N570VR · Substantial damage NTSB MIA93WA167Accident · 4 fatalForeign investigationPiper PA-23-250 · Marsh Harbor, BahamasJul 31, 1993 · N2402Z · Destroyed NTSB MIA92WA116Accident · 1 fatalForeign investigationPiper PA-23-250 · Marsh Harbour, BahamasApr 26, 1992 · N5611Y · Substantial damage NTSB MIA89WA009Accident · 1 fatalForeign investigationPiper PA-23-250 · Missing, BahamasOct 14, 1988 · N8JM · Destroyed NTSB MIA88WA252Accident · 2 fatalForeign investigationPiper PA-23-250 · Gr. Harbor Cay, BahamasAug 9, 1988 · N6737Y · Destroyed NTSB MIA73RM108Accident · 1 fatalClosedPiper PA-23 · Staniel Cay, Burkina FasoJun 11, 1973 · N5218Y · Destroyed NTSB MIA73RM030Accident · 5 fatalClosedPiper PA-23 · Georgetown, Burkina FasoSep 11, 1972 · N14265 · Destroyed NTSB UNK64X1887Accident · 7 fatalClosedPiper PA-23 · Ciudad Victor, MexicoMay 22, 1964 · N5211Y · Destroyed