NTSB investigations: Piper PA-24-180
9 cases on aircraft the registry lists as Piper PA-24-180, 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 2000 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102403')
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102403')
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 ATL00FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-180 · Cordesville, SCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB SEA94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cheyenne, WYThe pilot's improper use of the carburetor heat. A factor to the accident was carburetor icing conditions.NTSB LAX93LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Malibu, CAthe inadequate annual inspection by other maintenance personnel and the worn fuel selector valve shaft. Contributing to this accident was the loss of power due to fuel starvation.NTSB DEN91LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-180 · Broomfield, COThe pilot's failure to refuel and his misjudged fuel consumption calculations which resulted in fuel exhaustion power loss.NTSB FTW91FA055Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Pasadena, TXPower loss due to fuel exhaustion resultant from the pilot's failure to refuel at an alternate destination and the inadvertent stall. Factors were the dark night and weather conditions.NTSB FTW90LA129Accident · No injuriesLimited investigationFinal reportPiper PA24-180 · Arlington, TXThe loss of engine power due to fuel starvation caused by the pilot in commands failure to select a tank with fuel and the improper lowering of flaps while performing a forced landing resulting in the aircraft landing short and colliding with a fence.NTSB CHI89LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-180 · Alexandria, MNPoor judgement of the plt by flying while physically impaired from consumption of alcohol, his improper inflight planning/decision, and fuel exhaustion from his inadequate supply of fuel. The light conditions at night and uneven terrain (highway median) were…NTSB MIA85LA118Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Zephyrhills, FLThe plt stated that he experienced a complete loss of power & upon making his emerg landing in a pasture, the acft struck fence posts, separating the right main landing gear. Investigation of the fuel system revealed there was no fuel in the left tank &…NTSB FTW83LA196Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-180 · Socorro, NMThe acft was returning from a cross-country flt and crash landed about 1 mile from the arpt when the engine quit. The pilot said he added power to reach the rwy but the engine would not respond. The acft impacted the ground and slid to a stop. An FAA…