NTSB investigations: Piper PA-32RT-300, CA

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

NTSB investigations: Piper PA-32RT-300, CA per year, 1978–2026: 12 cases
1978	3
1980	2
1984	1
1987	1
1991	2
1992	1
1993	1
2005	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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103215')) 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103215'))
  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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103215'))
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 LAX06FA054Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Kingsburg, CAThe pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.Dec 10, 2005 · N3039B · Destroyed NTSB LAX93FA141Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Big Bear City, CAA partial loss of takeoff power due to inadequate maintenance and inspection which failed to detect magneto and spark plug deficiencies. In addition, the pilot failed to abort the takeoff after two unsuccessful attempts to get airborne. Factors which…Mar 7, 1993 · N2221G · Destroyed NTSB LAX92LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300 · Vallejo, CAWas the failure of the fuel servo diaphragm stem which resulted in a fuel interruption to the engine. High obstructions and utility pole in the forced landing area were factors contributing to the accident.Apr 26, 1992 · N31557 · Substantial damage NTSB LAX92LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA32RT-300 · Big Bear City, CAThe failure of the pilot to maintain directional control and improper use of the rudder. Contributing to the accident was the improper installation by the company of a hand control mechanism that required the pilot to operate the airplane controls with one…Dec 31, 1991 · N39459 · Substantial damage NTSB LAX91FA366Accident · Serious injuriesField investigationFinal reportPiper PA-32RT-300 · Van Nuys, CA(1) The pilot's improper preflight preparation; (2) the pilot's failure to follow the airplane manufacturer's performance data by his selection of an improper flap position for takeoff; and (3) the pilot's choice of a runway too short for a safe takeoff.…Aug 24, 1991 · N9507C · Destroyed NTSB DCA87MA023Accident · 3 fatalClass 1 · MajorFinal reportCessna 172N · Oakland, CAAt 0954:54, plt of Piper PA-32RT, N39614, rprtd 9 mi north for lndg. Twr controller (north ctlr) told him to pln for a rgt entry to rwy 27R. At 0955:32, a student plt & instructor (CFI) in Cessna 172N, N75584, were clrd for tkof on rwy 33 with a 'right turn…Mar 31, 1987 · N75584 · 2 aircraft · Destroyed NTSB LAX84LA303Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Avalon, CAThe plt flew to catalina island, then flew northwest along the north side of the island. He stated that he then made a climbing left turn over the island from about 500 ft MSL, but encountered a downdraft at 1000 ft MSL, which slowed the acft below the…May 20, 1984 · N30298 · Substantial damage NTSB LAX81DXQ05CaseClosedPiper PA-32 · So.Lake Tahoe, CADec 8, 1980 · N31872 NTSB LAX80FUD04Accident · No injuriesClosedPiper PA-32 · Los Angeles, CAFeb 6, 1980 · N36199 · Substantial damage NTSB LAX79FA006Accident · 1 fatalClosedPiper PA32RT · Green Vly Lk, CAOct 20, 1978 · N36792 · Destroyed NTSB LAX78FA071Accident · 4 fatalClosedPiper PA-32 · Laverne, CAAug 29, 1978 · N3708M · Destroyed NTSB OAK78DXQ41Accident · No injuriesClosedPiper PA-28 · Lake Tahoe, CAAug 24, 1978 · N36185 · Substantial damage