NTSB investigations: Piper PA-32-301, CA
7 cases on aircraft the registry lists as Piper PA-32-301. 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
| 1984 | 2 |
|---|---|
| 1985 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 2013 | 1 |
| 2022 | 1 |
Where
Open the mapLatest 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 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 ('7103207'))
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 ('7103207'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR22LA271Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-301 · San Jose, CAThe pilot’s inadequate preflight inspection and fuel management, which resulted in fuel starvation, a total loss of engine power, and an impact with terrain.NTSB WPR14LA071Accident · No injuriesLimited investigationFinal reportPiper PA 32-301 · Los Angeles, CAThe total loss of engine power during takeoff due to fuel starvation, which resulted from the pilot’s failure to adequately manage the fuel supply.NTSB LAX94LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-301 · Truckee, CAThe pilot's failure to maintain directional control, delay in his remedial action, and failure to raise the flaps. The snow covered runway was a factor in this accident.NTSB LAX92FA201Accident · 3 fatalField investigationFinal reportPiper PA-32-301 · Camarillo, CAThe pilot's failure to follow the published instrument missed approach procedure, and his failure to initiate a timely climb after being given a low altitude alert. Factors contributing to the accident were: the controller's failure to take positive action…NTSB LAX86LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · San Jose, CAAfter completing a personal flight the plt landed the acft. Upon touchdown on the 8899 ft-long by 150 ft-wide rwy the plt failed to maintain directional control of the acft. There was a 70 deg, 8 kt. Right x-wind. The acft overran the runway's edge, entered a…NTSB LAX85LA039Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Sanger, CAUpon touchdown, the left main landing gear contacted a pothole in the rwy aprx 175 ft from the threshold. Skid marks from the left main tire were seen on the rwy beginning at that point along with metal scrappings from the gear. Shortly thereafter, skid marks…NTSB LAX84LA306Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · San Jose, CAThe acft nose gear collapsed during landing. Witnesses described the bounced landing as a 'porpoise'.