NTSB investigations: Piper AEROSTAR 601P, CA
9 cases on aircraft the registry lists as Piper AEROSTAR 601P. 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
| 1967 | 1 |
|---|---|
| 1976 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 2002 | 1 |
| 2024 | 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 ('7106012'))
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 ('7106012'))
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 WPR24LA111Accident · Minor injuriesClass 4 · LimitedFinal reportPiper Aerostar 601P · Grass Valley, CAThe pilot’s failure to maintain directional control in a gusting wind condition.NTSB LAX02FA073Accident · 1 fatalField investigationFinal reportPiper Aerostar 601P · Stonyford, CAthe pilot's failure to maintain terrain clearance during cruise flight, which resulted in the in-flight collision with mountainous terrain. Factors in the accident were the mountainous terrain and the dark night light conditions.NTSB LAX92LA075Accident · No injuriesLimited investigationFinal reportPiper PA601P · San Diego, CAThe pilot's poorly planned approach and delay in accomplishing the proper remedial action while executing a night short field landing at an adequately lighted airport. Contributing to the accident was the failure of the pilot to maintain the proper glide…NTSB LAX89FA268Accident · 1 fatalField investigationFinal reportPiper PA-601P · Ramona, CAThe pilot's VFR flight in instrument meteorologial conditions (IMC) and spatial disorientation, which resulted in an inadvertent descent into the ground. Factors related to the accident were: darkness, low ceiling, and the pilot's lack of a preflight weather…NTSB LAX87FA337Accident · Serious injuriesField investigationFinal reportPiper Aerostar 601P · Corona, CAThe airplane was refueled before it dept on the accd flight; the pilot did not supervise the fueling. Shortly after takeoff, the plt advised the ontario dept controller that both engines were experiencing a power loss and that he suspected jet fuel…NTSB LAX80FA045Accident · 2 fatalClosedAerostar 601P · San Jose, CANTSB LAX79AA075Accident · No injuriesClosedAerostar 601P · Santa Ynez, CANTSB LAX77FA014Accident · 5 fatalClosedAerostar 601P · Costa Mesa, CANTSB LAX68F0270Accident · No injuriesClosedAero Comdr 680 · Van Nuys, CA