Skip to content

NTSB investigations: Piper PA-28-235, FL

20 cases on aircraft the registry lists as Piper PA-28-235. 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 ('7102810')) 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 ('7102810'))
  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 ('7102810'))
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 ANC26LA053Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-235 · Key West, FLOn June 14, 2026, at 1035 eastern standard time, a Piper PA-28-235 airplane, N15564, was substantially damaged when it was involved in an accident near Key West, Florida. The pilot was not injured and the passenger sustained minor injuries. The airplane was…Jun 14, 2026 · N15564 · Substantial damage NTSB ERA24LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Zephyrhills, FLA partial loss of engine power during initial climb due to fuel contamination that resulted from corrosion and loose corrosion debris in the carburetor, which restricted fuel flow to the engine.Jun 8, 2024 · N15363 · Substantial damage NTSB ERA24LA031Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Ocklawaha, FLThe pilot’s failure to attain a proper touchdown point which resulted in a runway overrun and subsequent impact with a fence.Oct 29, 2023 · N9159W · Substantial damage NTSB ERA23LA290Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Clearwater, FLThe pilot’s improper preflight inspection which resulted in a loss of engine power due to fuel contamination (water).Jul 5, 2023 · N8579W · Substantial damage NTSB CEN19LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Jacksonville, FLThe pilot's failure to select a fuel tank with adequate fuel, which resulted in fuel starvation and a total loss of engine power.Aug 3, 2019 · N951TS · Substantial damage NTSB ERA14LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Brooksville, FLThe pilot’s loss of directional control while landing at night, which resulted in a runway excursion and collision with airport signage. Contributing to the accident was the total loss of electrical power, which necessitated the pilot having to land without…May 9, 2014 · N8683W · Substantial damage NTSB MIA97FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Okeechobee, FLthe noninstrument-rated pilot's decision to conduct a VFR flight into instrument meteorological flight conditions. The weather was a factor.Jan 16, 1997 · N712DB · Destroyed NTSB MIA94LA091Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sebring, FLThe failure of the muffler in flight for unknown reasons, allowing hot exhaust gasses to impinge on the carburetor igniting the fuel and the subsequent fire.Mar 12, 1994 · N8938W · Substantial damage NTSB MIA84LA114Accident · 4 fatalLimited investigationFinal reportPiper PA-28-235 · Sanibel Island, FLThe acft failed to arrive at its destination. A satellite photo of the area showed wx & cloud cover between the departure & destination arpts. Radar data showed that an acft had left key west, FL, at about 1700, went northbound at 4500 until it encounter bad…Mar 12, 1984 · N39677 · Destroyed NTSB MIA79DKT74Accident · Minor injuriesClosedPiper PA-28 · Miami, FLJun 21, 1979 · N57347 · Substantial damage NTSB MIA78FA035Accident · 3 fatalClosedPiper PA-28 · New Prt Richey, FLJan 25, 1978 · N9386W · Destroyed NTSB MIA75FKT72Accident · No injuriesClosedPiper PA-28 · Belle Glade, FLMar 27, 1975 · N9074W · Substantial damage NTSB MIA74FKD06Accident · No injuriesClosedPiper PA-28 · Crystal River, FLJul 18, 1973 · N8741W · Substantial damage NTSB MIA73DKT24Accident · No injuriesClosedPiper PA-28 · Clewiston, FLNov 12, 1972 · N9303W · Substantial damage NTSB MIA71FLD32Accident · No injuriesClosedPiper PA-28 · Daytona Beach, FLNov 3, 1970 · N8951W · Substantial damage NTSB MIA69F0038Accident · Serious injuriesClosedPiper PA-28 · Vero Beach, FLMay 19, 1968 · N9301W · Substantial damage NTSB MIA67D0448Accident · No injuriesClosedPiper PA-28 · Ft. Myers, FLMar 19, 1967 · N8683W · Substantial damage NTSB MIA67F0305Accident · Serious injuriesClosedPiper PA-28 · Gainesville, FLSep 29, 1966 · N9087W · Substantial damage NTSB MIA65F0098Accident · Minor injuriesClosedPiper PA-28 · Jacksonville, FLMar 6, 1965 · N8907W · Substantial damage NTSB UNK64X0825Accident · 2 fatalClosedPiper PA28 · Arcadia, FLMar 7, 1964 · N8707W · Destroyed