NTSB investigations: Piper PA-32-301

8 cases on aircraft the registry lists as Piper PA-32-301, where the first occurrence was “Loss of control - in flight”. 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

19822026

NTSB investigations: Piper PA-32-301 per year, 1982–2026: 8 cases
1982	1
1987	1
1990	2
1992	2
1997	1
2006	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 ('7103207') 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" = 250)) 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 ('7103207')
      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\" = 250))
  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 ('7103207')
    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" = 250))
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 ANC07FA007Accident · 2 fatalField investigationFinal reportPiper PA-32-301 · Port Heiden, AKThe pilot's failure to maintain control of the airplane during cruise flight, which resulted in an uncontrolled descent, and an in-flight collision with snow-covered terrain. Contributing to the accident were the pilot's spatial disorientation, and dark night…Dec 14, 2006 · N8361Q · Destroyed NTSB CHI98FA070Accident · 4 fatalField investigationFinal reportPiper PA-32-301 · Hampshire, ILthe pilot's intentional flight into known icing conditions, and the accumulation of ice on the leading edges of the airplane's empennage and wings leading to the inadvertent stall/mush. A factor contributing to this accident was the icing conditions.Dec 23, 1997 · N2586Y · Destroyed NTSB ANC92LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Sleetmute, AKThe airplane stalled when the pilot failed to maintain flying speed.Mar 24, 1992 · N84547 · Substantial damage NTSB NYC92FA059Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Heath, OHAn inadvertent stall with insufficient altitude for recovery. An additional cause was the pilot's self induced pressure to complete the fight in known adverse weather, and to deviate from the published instrument approach procedure. Factors related to the…Feb 14, 1992 · N4380T · Destroyed NTSB ANC91LA015Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kongikank, AKThe pilot in command's failure to maintain airspeed during approach resulting in an inadverrtent stall annd uncontrolled descent into the ground.Dec 11, 1990 · N8225J · Substantial damage NTSB ANC90FA039Accident · 1 fatalField investigationFinal reportPiper PA-32-301 · Almautlak, AKThe pilot's loss of control of the airplane because of spatial disorientation. The weather conditions prevailing at the time were factors relating to the accident.Mar 16, 1990 · N8290T · Destroyed NTSB ATL88FA044Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Commercial Pt, OHThe acft crashed on a wheat field during a night instrument training flt. The plt had declared a vacuum system failure about 40 minutes after take-off but he declined ATC assistance for a no-gyro approach to columbus. Two minutes after the radio call radar…Nov 24, 1987 · N8046X · Destroyed NTSB FTW82DA366Accident · No injuriesFinal reportPiper PA32-301 · Raton, NMThe pilot stated that the airport regulations were such that he had to make a downwind takeoff on runway 17. The wind was from 350 degrees at 10 knots. He stated that just after liftoff, the aircraft stalled. Forward elevator was applied to break the stall…Sep 6, 1982 · N8200M · Substantial damage