Skip to content

NTSB investigations: Piper PA-23, FL

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

Where

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."eventStateOrRegion" = 'FL' AND 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 ('7102302')) 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.\"eventStateOrRegion\" = 'FL' AND 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 ('7102302'))
  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."eventStateOrRegion" = 'FL' AND 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 ('7102302'))
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 ERA25LA217Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-23 · Palm Bay, FLA loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.Jun 4, 2025 · N2109P · Substantial damage NTSB ERA15FA109Accident · 2 fatalField investigationFinal reportPiper PA-23 · Lakeland, FLAn in-flight loss of control for reasons that could not be determined during postaccident investigation; the loss of control likely occurred during a simulated loss of power in the right engine during an instructional flight.Jan 22, 2015 · N465JA · Destroyed NTSB MIA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Spring Hill, FLThe pilot's failure to maintain airspeed (VMC) on initial takeoff climb resulting in an in-flight loss of control, and subsequent in-flight collision with the ground and a building. Contributing to the accident was a partial loss of engine power on the left…Oct 6, 1995 · N183JD · Substantial damage NTSB MIA93LA048Accident · Minor injuriesLimited investigationFinal reportPiper PA-23 · Tampa, FLPoor in-flight planning/decision by the CFI resulting in the total loss of engine power from both engines due to fuel exhaustion.Jan 6, 1993 · N1439P · Substantial damage NTSB DCA87MA010Accident · 1 fatalClass 1 · MajorFinal reportPiper PA-23-150 · Tampa, FLAt aprx 0612 EST, an eastern airline capt (owner of Piper PA-23, N2185P) departed a rwy near his home in VFR conds to commute to work at Tampa, FL. Shortly after takeoff, he contacted a fss & updated the wx info he had obtained on the previous evening. At…Nov 6, 1986 · N2185P · 2 aircraft · Destroyed NTSB MIA85FA097Accident · 3 fatalField investigationFinal reportPiper PA-23 · Everglades City, FLThe acft departed the airport for a short flight to drop off one passenger. Shortly after takeoff witnesses stated that the acft started a shallow turn to the left in a nose high attitude. The acft continued to lose speed and rolled rapidly to the left at…Feb 14, 1985 · N3163P · Destroyed NTSB MIA80FLA09Accident · No injuriesClosedPiper PA-23 · Jacksonville, FLDec 30, 1979 · N1063P · Substantial damage NTSB MIA77FLD36Accident · No injuriesClosedPiper PA-23 · Winter Park, FLMar 18, 1977 · N3112P · Substantial damage NTSB MIA77FLA17Accident · Serious injuriesClosedPiper PA-23 · Lake City, FLFeb 23, 1977 · N1370P · Substantial damage NTSB MIA74DKT70Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLApr 16, 1974 · N2075P · Substantial damage NTSB MIA74DLD07Accident · No injuriesClosedPiper PA-23 · Ocala, FLJul 22, 1973 · N3075P · Substantial damage NTSB MIA73DLD80Accident · No injuriesClosedPiper PA-23 · Venice, FLMay 14, 1973 · N1434P · Substantial damage NTSB MIA73DLD20Accident · No injuriesClosedPiper PA-23 · Bartow, FLOct 21, 1972 · N1476P · Substantial damage NTSB MIA73DLA04Accident · No injuriesClosedPiper PA-23 · St. Augustine, FLJul 2, 1972 · N1183P · Substantial damage NTSB MIA72AM066Accident · 2 fatalClosedPiper PA-23 · Ocoee, FLJan 8, 1972 · N2220P · Destroyed NTSB MIA72FKT33Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLNov 30, 1971 · N2279P · Substantial damage NTSB MIA72FLD12Accident · No injuriesClosedPiper PA-23 · Lakeland, FLSep 19, 1971 · N1431P · Substantial damage NTSB MIA71AM064Accident · 2 fatalClosedPiper PA-23 · Daytona Beach, FLJan 31, 1971 · N2251P · Destroyed NTSB MIA71FLA21Accident · No injuriesClosedPiper PA-23 · Milton, FLNov 22, 1970 · N2297P · Substantial damage NTSB MIA71FKT10Accident · No injuriesClosedPiper PA-23 · Hollywood Bch, FLOct 9, 1970 · N3294P · Substantial damage NTSB MIA70F0011Accident · No injuriesClosedPiper PA-23 · Dania, FLJun 13, 1969 · N421C · Substantial damage NTSB MIA69D0176Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLSep 18, 1968 · N2251P · Substantial damage NTSB MIA67A0083Accident · 1 fatalClosedPiper PA-23 · Flagler Beach, FLFeb 4, 1967 · N2227P · Destroyed NTSB MIA66F0102Accident · No injuriesClosedPiper PA-23 · Opa Locka, FLJul 2, 1965 · N2036P · Substantial damage NTSB UNK64X3586Accident · No injuriesClosedPiper PA23 · St Petersburg, FLAug 25, 1964 · N1201P · Substantial damage