Final NTSB investigations: Piper PA 31P 350
6 cases on aircraft the registry lists as Piper PA 31P 350. 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 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 2011 | 1 |
| 2026 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103111'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103111'))
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 CEN26LA170Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA 31P 350 · Ardmore, OKThe pilot’s failure to maintain control of the airplane while landing on a wet runway with a tailwind.NTSB WPR11CA142Accident · No injuriesData collectionFinal reportPiper PA-31P-350 · North Bend, ORThe pilot's failure to lower the landing gear while on approach to landing. Contributing to the accident was the pilot's failure to follow a written checklist during the approach portion of the flight.NTSB BFO95FA064Accident · 3 fatalField investigationFinal reportPiper PA-31P-350 · Cedar Bluff, VAthe pilot's improper planning/decision, and his allowing the airplane to exceed its maximum design/stress limitation. Factors relating to the accident were: the adverse weather conditions, and the pilot's continued flight into adverse weather.NTSB LAX89FA025Accident · 2 fatalField investigationFinal reportPiper PA31P-350 · Redlands, CAThe pilot's inadvertent selection of an inappropriate altitude for the attempted night special VFR circle to land maneuver. Contributing to the accident was the dark night, restricted visibilities and lack of ground reference lights. Also contributing to the…NTSB FTW86FA031Accident · 2 fatalField investigationFinal reportPiper PA-31P-350 · Norco, LAThe plt initiated an ILS apch in below minimum weather conditions shortly after night fall. He was given a low alt alert, but continued the apch. He announced a missed apch, and indicated problems climbing to alt. He then declared an unspecified emergency,…NTSB NYC84LA268Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Seven Springs, PAAfter refueling, the plt took off from a 3000 ft rwy located in a mountainous region. He reported that after a normal rotation & lift-off, he established a positive rate of climb. However, shortly after takeoff, during gear retraction, the acft began to…