NTSB investigations: Piper PA-34-200T
10 cases on aircraft the registry lists as Piper PA-34-200T, 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
| 1982 | 2 |
|---|---|
| 1986 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103406')
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 ('7103406')
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 CHI01LA322Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Petoskey, MIThe pilot's inadequate preflight planning, the pilot's improper in-flight decisions, and the unsuitable terrain for landing. A factor relating to this accident was fuel exhaustion.NTSB CHI98LA054Accident · Serious injuriesLimited investigationFinal reportPiper PA-34-200T · Lee'S Summit, MOthe pilot's inadequate remedial action concerning the loss of engine power, after inadvertently switching off the magnetos. Factors relating to the accident were: the broken springs for magneto cover guard; excessive drag from the extended landing gear and…NTSB ATL96LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Gulfport, MSinadequate preflight planning/preparation by the pilot, and inadequate supply of fuel in the airplane, which resulted in fuel exhaustion and subsequent ditching at sea.NTSB NYC91LA128Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Arcadia, RIInadequate preflight by the pilot, and fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the lack of a suitable area for a forced landing.NTSB MIA88LA227Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · St. Petersburg, FLThe 27 yr old plt purchased the acft about 2 weeks before the accident & had received his multi-eng rating about 3 weeks before. His total multi eng time was about 35 hrs. Nearing his destination, 1 eng quit. A few moments later, the other quit & the plt…NTSB LAX87LA292Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · El Monte, CAAn instructor (CFI) was giving an airline transport plt (ATP) a check-out in the PA-34. The ATP checked the fuel quantity & questioned the CFI about the lvl in the left tank. The CFI acknowledged that the fuel tank was not full. The ATP stated the fuel gauges…NTSB ATL87LA049Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Mobile, ALThe plt had suspected a hydraulic problem prior to departure when hydraulic fluid was found on the hangar floor. The acft was flown to a nearby arpt for repairs. The acft then departed and aprx 1 hr into the flt a heater problem was experienced. The plt…NTSB LAX86LA236Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Long Beach, CAThe airplane crashed on final approach to runway 16L at Long Beach airport (lgb), Long Beach, California. The pilot reported that both engines sustained a total loss of power. The airplane's altitude was insufficient to land on the airport. The left fuel tank…NTSB LAX82FUG15Accident · No injuriesFinal reportPiper PA-34-200T · Fontana, CAApproximately 5 hrs after takeoff the plt contacted ontario tower & requested radar vectors to the arpt because he had an eng out. After switching to approach control the plt began receiving vectors to the arpt. At 0209 the plt advised a/c that he ran out of…NTSB SEA82FA122Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · 10 Nm E. Of Ken, IDThe plt declared an emergency & reported out of fuel. While approaching a field the plt observed a power/telephone line in his flt path & instinctively pulled the nose up. On-scene examination revealed no evidence of fuel.