NTSB investigations: Piper PA-32R-301T, FL
10 cases on aircraft the registry lists as Piper PA-32R-301T. 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 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2012 | 1 |
| 2014 | 1 |
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 ('7103220', '7103221'))
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 ('7103220', '7103221'))
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 ERA14FA343Accident · 1 fatalField investigationFinal reportPiper PA-32R-301T · North Captiva Island, FLThe pilot’s failure to secure the cargo in the cargo compartment, which resulted in a weight shift that led to the center of gravity exceeding its aft limit during a go-around attempt and a subsequent aerodynamic stall. Also causal to the accident were the…NTSB ERA12LA524Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Riverview, FLDamage to the propeller governor gasket during installation by unknown persons, which resulted in a total loss of engine oil in flight and a subsequent forced landing.NTSB ERA09FA526Accident · 4 fatalField investigationFinal reportPiper PA-32R-301T · Fort Lauderdale, FLFatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…NTSB NYC08IA069Incident · No injuriesIncident investigationFinal reportPiper PA-32R · Destin, FLAn in-flight fire due to a fractured fuel injector line as a result of an unauthorized repair to the line.NTSB MIA02FA173Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Yeehaw Junction, FLthe pilot's continued flight into known severe weather, resulting in an in-flight separation of the right wing, vertical stabilizer and the stabilator. Factors in this accident were heavy thunderstorm, and failure of the FAA controllers to provide the pilot…NTSB MIA94LA046Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301 · Live Oak, FLThe improper use of the fuel selector by the pilot-in-command by switching to an empty fuel tank. Contributing to the accident was the pilot's failure to switch back to a tank with fuel.NTSB MIA88LA193Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lake Wales, FLDuring takeoff from the grass strip, the left main landing gear and wingtip collided with runway lights & a fencepost. The acft was slow to climb. After clearing trees at the departure end of the rwy, the acft descended below treetop level, then continued to…NTSB MIA87LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Cedar Key, FLThe plt stated that he was not able to see the lighted wind sock from 1000 ft as he was unfamiliar with its location. The acft landed downwind on the rwy & was unable to stop before running off the end. A 15 to 20 kt tailwind was present at the time. The plt…NTSB MIA85LA111Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · W. Palm Beach, FLWhile en route, the plt contacted Palm Beach apch control & obtain flt following. He reported that he was 20 mi north & wished to proceed southbound along the coast. The controller acknowledged the request & advised the plt to remain VFR. The controller did…NTSB MIA85FA040Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Freeport, FLPreflt wx brief included advisory for scattered showers/thunderstorms along route of flt. Departed in VFR conditions but encountered deteriorating wx enroute, received inflt wx advisory to expect low clngs and reduced visibility ahead. Plt stated he 'would…