OpenAirDocs.org

NTSB investigations: Piper PA-31-350, 1987

7 cases on aircraft the registry lists as Piper PA-31-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

19742026

Where

Open the map

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 year(c.\"eventDate\") = 1987
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103110', '7103125'))
  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.

NTSB LAX88FA075Accident · 8 fatalField investigationFinal reportPiper PA-31-350 · Maunaloa, HIThe flight was to be flown across a 22 mile channel between islands on an overcast night with no moon and no ground reference lights. The aircraft disappeared from radar and, after extensive searches, could not be found. A three dimensional flight track was…Dec 24, 1987 · N712AN · DestroyedNTSB DCA88MA011Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kenai, AKThe pilot had just departed the runway when he reported to the flight service station that he had engine problems. The aircraft was observed by witnesses to be about 300 ft on a descending downwind. The pilot stated that he was circling for runway one.…Dec 23, 1987 · N496SC · DestroyedNTSB ATL87FA262Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · Demopolis, ALThe plt of an aircraft carrying an estimated 317 kilos of cocaine was attempting to land at an apt which did not have a published instrument approach procedure in IMC. Witnesses estimated that the visibility was no more than 1/2 mile in fog about 45 min after…Sep 25, 1987 · N117EV · DestroyedNTSB NYC87LA156Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Cooperstown, NYThe pilot stated he departed farmingdale with two plus hours of fuel on board. After approximately 40-50 minutes of flight, the right low fuel pressure light and right fuel pump light flashed steady red. The pilot rechecked his calculations and determined he…May 30, 1987 · N59728 · Substantial damageNTSB DEN87LA067Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Missoula, MTThe plt of the Piper navajo was taxiing to the active rwy for an IFR departure, directed his attention to the departure procedure chart in the cockpit, and collided with the tail of a swearingen acft holding short of the rwy awaiting takeoff clearance.Mar 19, 1987 · N3529W · 2 aircraft · Minor damageNTSB ANC87IA032Incident · No injuriesIncident investigationFinal reportPiper PA-31-350 · Barter Island, AKThe pilot flew into rising terrain during a night VFR flight. After shutting down the right engine and achieving only partial propeller feather he elected to make a gear up landing. The plt was flying at 500 ft AGL when he wandered from over water to on-shore…Feb 4, 1987 · N35232 · Minor damageNTSB DCA87MA020Accident · 6 fatalClass 1 · MajorFinal reportPiper PA-31-350 · Independence, MOThe two acft, a Beech U-21A and a Piper PA-31-350, collided nearly head on at 7000 ft MSL over Independence, MO. In daylight VMC conditions with a visibility of 20 miles. The U-21 was in level cruise and the PA-31 was climbing eastbound to an undisclosed alt…Jan 20, 1987 · N60SE · 2 aircraft · Destroyed