NTSB investigations: Piper PA-25-260, CA
16 cases on aircraft the registry lists as Piper PA-25-260. 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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 2 |
| 1993 | 1 |
| 2000 | 1 |
| 2009 | 1 |
| 2015 | 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 ('7102508'))
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 ('7102508'))
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 WPR15FA250Accident · 1 fatalField investigationFinal reportPiper PA 25 · Llano, CAThe pilot's loss of airplane control during the landing approach due to an incapacitating medical event.NTSB WPR10CA067Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Llano, CAThe pilot's inadequate compensation for the gusting crosswind conditions and failure to maintain lateral and directional control.NTSB LAX00LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Coleville, CAthe tow plane pilot's inadequate airplane performance calculations.NTSB LAX93LA204Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260 · Pixley, CAthe pilot's failure to maintain flying speed during the turn. The inadvertent stall was a factor in this accident.NTSB OAK79DVG33Accident · No injuriesClosedPiper PA-25 · Gerber, CANTSB OAK79DVG25Accident · Minor injuriesClosedPiper PA-25 · Redding, CANTSB LAX79DUM04Accident · Serious injuriesClosedPiper PA-25 · Westmoreland, CANTSB LAX77DUM28Accident · No injuriesClosedPiper PA-25 · Holtville, CANTSB OAK77DVD25Accident · No injuriesClosedPiper PA-25 · Healdsburg, CANTSB OAK74DVD36Accident · No injuriesClosedPiper PA-25 · Healdsburg, CANTSB OAK74FVG12Accident · No injuriesClosedPiper PA-25 · Dixon, CANTSB OAK73DVA65Accident · No injuriesClosedPiper PA-25 · Merced, CANTSB OAK72FVA27Accident · Serious injuriesClosedPiper PA-25 · Chowchilla, CANTSB LAX71DUM24Accident · No injuriesClosedPiper PA-25 · Imperial, CANTSB OAK70D0069Accident · No injuriesClosedPiper PA-25 · Tulelake, CANTSB OAK69D0060Accident · No injuriesClosedPiper PA-25 · Lindsay, CA