NTSB investigations: Piper PA-34-200
7 cases on aircraft the registry lists as Piper PA-34-200, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 |
| 1994 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
Where
Latest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103405')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103405')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 LAX04CA173Accident · No injuriesData collectionFinal reportPiper PA34-200 · La Verne, CAthe CFI 's failure to correctly reconfigure the right engine fuel selector, resulting in a total loss of power to that engine. Also causal was the CFI's failure to maintain direction control of the airplane and an adequate airspeed, which led to the airplane…NTSB ATL02LA161Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Peachtree City, GAThe certified flight instructors failure to feather the propeller in accordance with operating procedures that resulted in loss of altitude and the in-flight collision with terrain.NTSB MIA01FA102Accident · Serious injuriesField investigationFinal reportPiper PA-34-200 · Palm Coast, FLthe second pilot's failure to maintain Vmc during a single engine approach resulting in a loss of control in flight and subsequent collision with objects and terrain during an uncontrolled descent. Contributing to the accident was the PIC turning the right…NTSB ATL95FA162Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · Double Springs, ALfailure of the pilot to follow emergency procedures for loss of engine power, and his failure to maintain control of the airplane. Factors relating to the accident were: the pilot's inadequate preflight planning/preparation and improper fuel consumption…NTSB FTW94LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Vacherie, LAWas fuel exhaustion engine power loss due to the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.NTSB NYC89LA044Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Laconia, NHAircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot.NTSB ATL84LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200 · Smyrna, TNThe CFI simulated an engine failure on the right engine during takeoff after having simulated a left engine failure during the landing approach. The left engine failure was simulated with the left throttle retarded during the approach and landing. After the…