NTSB investigations: Piper PA-34-200T
14 cases on aircraft the registry lists as Piper PA-34-200T, where the first occurrence was “In flight collision with terrain/water”. 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 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 2 |
| 1997 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 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 ('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\" = 230))
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" = 230))
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 DEN05FA087Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Telluride, COthe pilot's failure to maintain clearance from terrain. Contributing to the accident were the high, rising terrain and fatigue.NTSB LAX04FA077Accident · 5 fatalField investigationFinal reportPiper PA-34-200T · Avalon, CAThe failure of both pilots to properly execute the published missed approach procedure.NTSB FTW02FA130Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Alpine, UTThe pilot's failure to maintain clearance with terrain and continued flight into known adverse weather conditions. Contributing factors were the fog and rain weather conditions.NTSB IAD01LA028Accident · No injuriesLimited investigationFinal reportPiper 34-200T · Bluefield, WVThe pilot's failure to enter the correct altimeter setting, which resulted in continued flight below the decision height and a subsequent collision with trees.NTSB DEN01LA007Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fort Collins, COFailure by the pilot to follow instrument approach procedures and execute a missed approach when the runway environment was not in sight at decision height. A factor was low ceiling.NTSB ANC97LA019Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Dillingham, AKthe pilot's failure to maintain sufficient altitude or clearance from terrain during a go-around. A factor related to the accident was: the dark, night condition.NTSB LAX92LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Pine Valley, CAThe pilot's failure to monitor the proper altitude over obserable rising terrain. A contributing factor was the pilot's encounter with a strong downdraft.NTSB LAX91LA067Accident · No injuriesLimited investigationFinal reportPiper PA 34-200T · Red Bluff, CAThe failure of the pilot in command to detect a descent below the minimum descent altitude for the approach in use.NTSB NYC88FA093Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Stratford, CTThe pilot and pilot-rated pax received vectors for multiple ILS approaches in deteriorating conditions. On the first attempt the aircraft passed over witnesses but was off course and not in a position to land. The second attempt was aborted before reaching…NTSB MIA87FA086Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Oxford, MSThe acft struck an embankment about 5 feet below the crest & just short of the rwy while attempting to land at dusk & in reduced lighting conditions. The acft exploded & bounced out of the impact crater & came to rest about on the extended rwy centerline. An…NTSB MKC85FA060Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Mena, ARThe pilot had been cleared for an instrument approach to themena, Arkansas intermountain regional airport. The airplane impacted a mountain side 8 1/2 miles off course.NTSB NYC84FA135Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Johnstown, PAThe acft took off with a center of gravity bet 95.45 & 95.71 inches aft of the datum & aprx 98 lbs below the max allowable gross weight. The max aft CG limit for all weights was 94.6 inches. Wx at the aprx time of the accident was 400 ft ceiling, light…NTSB NYC84FA042Accident · Serious injuriesField investigationFinal reportPiper PA-34-200T · Bennington, VTThe acft crashed into mountainous terrain at about the 1,800 ft level approximately 2 mi south of the arpt. The acft had been cleared for the vor-a approach. The missed approach point is the 6 DME point from the cambridge VOR on the 159 deg radial. Mda is…NTSB LAX82FA038Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Near Las Vegas, NVThe aircraft, a Piper PA-34, was on a VFR flight to transport bank checks on a part 135 operation. Another company pilot in a Cessna 207 stated that he encountered instrument conditions at 9500 ft while he was flying from tonopah to las Vegas, NV. The Cessna…