NTSB investigations: Piper PA-31-310, CA
7 cases on aircraft the registry lists as Piper PA-31-310. 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
| 1979 | 1 |
|---|---|
| 1981 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2006 | 1 |
| 2011 | 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 ('7103102'))
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 ('7103102'))
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 WPR11LA401Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Cabazon, CAA total loss of left engine power due to the failure of the aft crankshaft counterweight retaining washer for reasons that could not be determined during postaccident examinations.NTSB LAX06CA140Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Victorville, CAan in-flight collision with a bird.NTSB LAX99LA181Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · La Verne, CAThe in-flight separation of the right engine cowling due to the operator's inadequate maintenance quality control procedures and the pilot's inadequate preflight inspection.NTSB LAX97FA217Accident · 3 fatalField investigationFinal reportPiper PA 31-310 · San Diego, CAThe loss of power in the left engine for undetermined reasons and the pilot's subsequent failure to maintain minimum single-engine control airspeed. A contributing factor was the pilot's decision to fly with known deficiencies in the equipment.NTSB LAX91LA343Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Byron, CAThe pilot's failure to refuel the airplane and his misjudging the distance to the runway.NTSB LAX81FA039Accident · 1 fatalClosedPiper PA-31 · Mt Shasta, CANTSB LAX79DUG12Accident · Minor injuriesClosedPiper PA-31 · Hart Mine, CA