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

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

19792026

NTSB investigations: Piper PA-32RT-300T, CA per year, 1979–2026: 11 cases
1979	1
1980	2
1985	1
1986	1
1992	2
1993	1
1994	1
1996	1
2015	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 ('7103216')) 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 ('7103216'))
  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 ('7103216'))
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 WPR16FA041Accident · 5 fatalField investigationFinal reportPiper PA 32RT-300T · Bakersfield, CAThe noninstrument-rated pilot's decision to conduct and continue the flight despite forecast and en route instrument meteorological conditions (IMC), which were not conducive to safe operation under visual flight rules. Also causal to the accident was the…Dec 19, 2015 · N36402 · Destroyed NTSB LAX96LA202Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Kernville, CAthe pilot's inadequate compensation for the downdraft condition and subsequent failure to maintain a proper rate of descent.May 17, 1996 · N21312 · Substantial damage NTSB LAX94LA377Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300T · San Mateo, CAA deteriorated magneto grounding ('P' lead) and failure of maintenance personnel to detect this condition when the engine was reinstalled in the airframe after overhaul. The lack of suitable terrain for the forced landing was a factor.Sep 25, 1994 · N39658 · Destroyed NTSB LAX93LA341Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Willows, CAthe pilot's failure to maintain directional control of the aircraft.Sep 2, 1993 · N39527 · Substantial damage NTSB LAX92LA377Accident · Minor injuriesLimited investigationFinal reportPiper PA-32RT-300T · Baker, CAThe unknown pilots improper use of the throttles which resulted in the overboosting of the engine. Contributing to the accident was the maintenance personnel improper maintenance in adjusting the turbocharger wastegate and the oil leaking from the engine…Sep 8, 1992 · N20926 · Destroyed NTSB LAX92LA239Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Chino, CAThe loss of engine power for undetermined reasons. The pilot's misjuding the flare was a factor.Jun 9, 1992 · N31961 · Substantial damage NTSB LAX86LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · Paso Robles, CAThe plt was informed that he was trailing smoke on climb out. The plt elected to continue the climb due to IMC at the departure arpt and divert to another arpt located 26 NM north. He continued to climb to 4,500 ft MSL to VMC. The oil warning light…Jul 9, 1986 · N39944 · Substantial damage NTSB LAX85FA130Accident · No injuriesField investigationFinal reportPiper PA-32RT-300T · Bishop, CAThe plt rptd that shortly after leveling off at 11500 ft MSL, the engine exploded causing both windscreens to be covered with oil and fire. The fire stopped during the emergency descent. The acft landed on ry 30 at Bishop arpt, Bishop, CA without further…Jan 31, 1985 · N2129G · Substantial damage NTSB LAX80FVA03Accident · 2 fatalClosedPiper PA-32 · Merced, CAOct 2, 1980 · N21307 · Destroyed NTSB LAX80FVM33Accident · Minor injuriesClosedPiper PA-32R · San Carlos, CAJun 24, 1980 · N20817 · Substantial damage NTSB LAX79FUA07Accident · Minor injuriesClosedPiper PA-32 · Fullerton, CAJan 13, 1979 · N39720 · Destroyed