NTSB investigations: Piper PA-34-200

6 cases on aircraft the registry lists as Piper PA-34-200, where the first occurrence was “Hard landing”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19842026

NTSB investigations: Piper PA-34-200 per year, 1984–2026: 6 cases
1984	1
1997	2
1998	2
2000	1

Where

Open the map

Latest cases

Query with SQL

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" = 200)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 200))
  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" = 200))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 LAX00LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Big Bear City, CAThe pilot's selection of a final approach airspeed in variance with the manufacturer's recommendations, which was too slow for the gusty and variable crosswind conditions, which resulted in a stall/mush and a hard landing.Feb 27, 2000 · N15202 · Substantial damage NTSB NYC99LA016Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Oneonta, NYThe pilot's improper flare which resulted in a hard landing. A factor in the accident was the crosswind condition.Oct 25, 1998 · N55697 · Substantial damage NTSB LAX98LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA34-200 · Van Nuys, CAThe pilot's misjudged landing flare which led to an uncontrolled porpoise and eventual collapse of the landing gear.Mar 16, 1998 · N4442T · Substantial damage NTSB MIA97LA238Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Kissimmee, FLa hard landing resulting in a wing contacting the runway. A factor in this accident was the nose landing gear would not extend due to the steering ball being off its track.Aug 21, 1997 · N55322 · Substantial damage NTSB CHI97LA206Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Mackinac Island, MIthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing. Turbulence on short final was a related factor.Jul 5, 1997 · N56676 · Substantial damage NTSB NYC84LA213Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Monongahela, PAThe certified flt instructor (CFI) stated that he was giving multiengine instruction. All basic single and multi- engine maneuvers had been completed. The CFI reduced the pwr on one engine to simulate a single engine landing. The CFI stated that a normal…Jun 18, 1984 · N55697 · Substantial damage