NTSB investigations: Piper PA-32-301, FL
7 cases on aircraft the registry lists as Piper PA-32-301. 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.
Cases per year
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1996 | 1 |
| 2005 | 1 |
| 2009 | 1 |
| 2021 | 2 |
Where
Open the mapLatest cases
Query with SQL
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 ('7103207'))
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 ('7103207'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ERA22LA077Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301 · Orlando, FLThe pilot’s inadequate compensation for winds during the landing roll.NTSB ERA21LA123Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-301 · Homestead, FLA total loss of power for reasons that could not be determined, as the airplane was not recovered from the water following the ditching.NTSB ERA10CA054Accident · No injuriesData collectionFinal reportPiper PA32 · Jacksonvile, FLThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.NTSB MIA05CA099Accident · No injuriesData collectionFinal reportPiper PA32-301 · Brooksville, FLThe pilot-in-command failure to maintain directional control during takeoff after landing, which resulted in the airplane exiting the runway.NTSB MIA96LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Jacksonville, FLThe pilot's failure to maintain airspeed (VSO) while maneuvering during a go-around, resulting in an inadvertent stall and subsequent in-flight collision with terrain. Contributing to the accident was the pilot's failure to achieve the proper touchdown point…NTSB MIA88LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Captiva, FLThe pilot allowed the aircraft to descend below the normal approach angle and failed to correct the situation timely. The aircraft struck a seawall severing first the nose gear and then the main gear. The aircraft slid to a stop.NTSB MIA84LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Marco, FLThe flt departed fort myers, FL at 0550 & arrived at key west, FL at 0655. The flt then departed key west at 0710 for the return flt. At 0722, the plt reported to ARTCC that he was experiencing eng failure & could get no fuel pressure. The acft was ditched 29…