Skip to content

NTSB investigations: Piper PA-32R-300, FL

20 cases on aircraft the registry lists as Piper PA-32R-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

19772026

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 ('7103213')) 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 ('7103213'))
  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 ('7103213'))
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 ERA25LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32R · Miami, FLAn inflight loss of hydraulic fluid from the landing gear system through a cracked fitting, which resulted in a landing gear collapse upon touchdown.Aug 20, 2025 · N990DM · Substantial damage NTSB ERA23FA181Accident · 4 fatalClass 3 · FieldFinal reportPiper PA32R · Venice, FLThe pilot’s decision to initiate a visual flight rules flight into dark night conditions, which resulted in spatial disorientation during the initial climb and subsequent steep banking descent into water.Apr 6, 2023 · N635BD · Destroyed NTSB ERA18LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA32R · Marathon, FLThe pilot's failure to maintain directional control during takeoff.Jan 25, 2018 · N47863 · Substantial damage NTSB ERA17LA311Accident · No injuriesLimited investigationFinal reportPiper PA32R · Merritt Island, FLThe pilot's inadequate preflight planning and improper takeoff technique, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.Sep 3, 2017 · N544DG · Substantial damage NTSB ERA10CA368Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · St. Petersburg, FLThe pilot's loss of directional control while taking off with a crosswind.Jul 15, 2010 · N38448 · Substantial damage NTSB ERA10FA180Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Williston, FLThe pilots of both airplanes did not maintain an adequate visual lookout to see and avoid each other.Mar 20, 2010 · N823AG · 2 aircraft · Substantial damage NTSB NYC08CA084Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Brooksville, FLA deer darting into the path of the airplane during the landing roll.Jan 5, 2008 · N9896 · Substantial damage NTSB MIA05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fort Myers, FLInadequate maintenance and repair of the engine top cowling by company maintenance personnel, resulting in failure and separation of the cowling in flight.May 31, 2005 · N333TG · Substantial damage NTSB MIA89LA089Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Fort Lauderdale, FLFaulty installation of avionics equipment which caused wiring in the landing gear system to be improperly reinstalled.Feb 18, 1989 · N4303X · Substantial damage NTSB MIA88FA083Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Pembroke Park, FLThe non-instrument rated private pilot obtained a weather briefing that indicated the weather would be deteriorating to IMC, but he attempted a flight anyway. During the flight, he became disoriented and penetrated 2 control zones and then struck an antenna…Jan 5, 1988 · N5327F · Destroyed NTSB MIA87LA206Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hastings, FLThe plt stated that he had just lifted from the 2300 ft wet grass strip, where he estimated the grass to be about 6 in to 1 ft high, when he sustained a partial power loss. The acft struck an embankment at the end of the rwy & sheared the gear. Air temp in…Jul 14, 1987 · N4647F · Substantial damage NTSB MIA85FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Homestead, FLWhile cruising northerly at a low altitude during a dark night, the acft struck a row of trees appx 50 ft tall about 8 ft from the tops, it then hit a large tree at about 6 ft AGL, 670 ft from the initial impact point, & came to rest in a dirt road. An exam…Dec 27, 1984 · N8920C · Destroyed NTSB MIA83IA239Incident · No injuriesIncident investigationFinal reportPiper PA-32R-300 · Orlando, FLAcft made an intentional gear up landing after both normal & emergency procedures failed to lower the gear. It was determined that the hydraulic pump motor had failed. Normal & emergency systems were interdependent. The emergency gear diaphragm was blocked by…Sep 25, 1983 · N301WA · Minor damage NTSB MIA83FA180Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Islamorada, FLThe acft was ditched in the Florida bay after the engine malfunctioned. According to the plt, the eng started to run rough and he ditched the acft at about 0600 EDT. However, the acft clock was stopped at 0345 and a commercial fisherman said he saw a low…Jul 11, 1983 · N6207J · Destroyed NTSB MIA83LA084Accident · 1 fatalLimited investigationFinal reportPiper PA-32R · Cross City, FLThe acft collided with trees during a night landing on a lonely stretch of country road. The landing was an attempt to unload 662 pounds of marijuana in an illegal drug operation.a passenger was fatally injured and the injured pilot was found later in the…Mar 1, 1983 · N3898F · Destroyed NTSB MIA81FA094Accident · 3 fatalClosedPiper PA-32R · Naples, FLJul 11, 1981 · N6074H · Destroyed NTSB MIA81DLD46Accident · Minor injuriesClosedPiper PA-32R · Groveland, FLMay 22, 1981 · N1887H · Substantial damage NTSB MIA81FA004Accident · 1 fatalClosedPiper PA-32R · Weeki Wachee, FLOct 19, 1980 · N1714H · Destroyed NTSB MIA80FA042Accident · 5 fatalClosedPiper PA-32R · Ocala, FLMar 6, 1980 · N2543Q · Destroyed NTSB MIA77DLA18Accident · No injuriesClosedPiper PA-32 · Crestview, FLMar 4, 1977 · N76AP · Substantial damage