OpenAirDocs.org

NTSB investigations: Piper PA-32R-300, 1987

7 cases on aircraft the registry lists as Piper PA-32R-300. 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

19652026

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 ('7103213'))
  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 LAX88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Los Angeles, CAWhile taxiing after landing, N911E was instructed to taxi to a position and hold, en route to that position, the acft collided with N75397 that was also holding in the same position. The plt of N911E stated that he did not see the acft due to moisture that…Dec 22, 1987 · N75397 · 2 aircraft · Substantial damageNTSB SEA88FA031Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Lakeport, CAAlthough weather conditions were marginally VFR at his departure point, and the pilot had access to a vehicle which could have been used to drive to his dest, he departed novato, CA, enroute to Lakeport, CA, without obtaining a wx briefing nor filing a flt…Dec 15, 1987 · N400LA · DestroyedNTSB NYC88LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Windham, CTThe flight departed groton, Connecticut enroute to willimantic, Connecticut in unlimited visibility. However at Windham airport, the runway was partially obscured by patchy fog according to the pilot. The pilot landed long due to carrying additional speed in…Oct 30, 1987 · N38334 · Substantial damageNTSB CHI87LA217Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Hillsdale, MITkof and climb to 7000 ft were made on the left fuel tank. Shortly after lvl-off, the plt switched to the rt tank and stayed on it during the initial cruise. The plt then switched back to left tank and abt 10 min later the eng began to lose pwr. Readings were…Sep 22, 1987 · N8799E · DestroyedNTSB MIA87LA206Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hastings, FLThe plt stated that he had just lifted from the 2300 ft wet grass strip, where he estimated the grass to be about 6 in to 1 ft high, when he sustained a partial power loss. The acft struck an embankment at the end of the rwy & sheared the gear. Air temp in…Jul 14, 1987 · N4647F · Substantial damageNTSB LAX87LA245Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZAt the end of a business flt, the plt extended the landing gear and noted that the left main landing gear indicated that it was not down and locked. The plt activated the emergency landing gear extension which still indicated it was not down. While on final…Jun 27, 1987 · N4364X · Substantial damageNTSB NYC87FA188Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Tannersville, NYWhile on a VFR air taxi cargo flight, the aircraft collided with trees on the east side of high peak mountain, elevation 3,655 feet. The accident site elevation was 3080 feet. A witness said it was heavy overcast, not raining and the clouds were not below the…Jun 26, 1987 · N7146C · Destroyed