NTSB investigations: Piper PA-24-250, CA
12 cases on aircraft the registry lists as Piper PA-24-250, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1989 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2005 | 1 |
Where
Latest 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 ('7102404')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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 ('7102404')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 LAX05FA271Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Pomona, CAA loss of engine power during the landing approach due to fuel starvation caused by debris and corrosion in the carburetor assembly. A factor contributing to the accident was the failure of the owner to comply with the manufacturer's service bulletin…NTSB LAX02LA095Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAThe pilot's inadequate planning and improper fuel consumption calculation, which resulted in fuel exhaustion.NTSB LAX99LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Victorville, CAFuel starvation caused by the pilot's failure to select a tank containing fuel.NTSB LAX96FA229Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Big Bear City, CAimproper preflight by the pilot, by failing to ensure that the fuel selector was positioned to an approved fuel tank with adequate fuel before takeoff; his failure to reposition the fuel selector (per emergency procedures) after the loss of engine power; and…NTSB LAX95LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Jose, CAthe pilot's mismanagement of the fuel system and his failure to select a tank containing fuel.NTSB LAX94LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Selma, CAThe pilot's improper use of the fuel supply which allowed the engine to sustain fuel starvation, and his failure to follow the emergency checklist by not using the electrical fuel boost pump. The engine fuel starvation was a factor in this accident.NTSB LAX93LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Red Mountain, CAFuel exhaustion due to the pilot's inadequate preflight planning and his failure to refuel the aircraft. Factors in the accident were the pilot's inability to see the terrain due to the dark night conditions and the flight's encounter with instrument…NTSB LAX92LA015Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Linden, CAThe pilot in command inaccurately calculating the aircraft's fuel consumption, and not re-fueling the aircraft prior to takeoff from his last departure point. This resulted in a power loss due to fuel exhaustion. A factor in this accident was the unsuitable…NTSB LAX91LA400Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · French Gulch, CAThe pilot's failure to refuel before departing on the accident flight. Contributing to this accident was the high vegetation and fuel exhaustion.NTSB LAX89LA214Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · San Diego, CAFuel starvation due to the pilot's inadvertent selection of the off position on the fuel selector.NTSB LAX85LA007Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Essex, CAThe plt reported that he visually checked the quantity of fuel in the acft's fuel tanks prior to departure & that he apparently overestimated the amount in the tanks. Following the accident the plt reported that he opened the fuel caps to both tanks & they…NTSB LAX82FA308Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Los Angeles, CAThe flt departed santa monica at 0830 for a local flt. At 0926 the plt called from downtown Los Angeles for landing at santa monica. At 9028 the plt 3 mi east of a VFR reporting point with eng trouble & that he had to come down. The acft wing struck the roof…