NTSB investigations: Piper PA-24
12 cases on aircraft the registry lists as Piper PA-24, 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 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 1 |
| 1996 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102402')
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 ('7102402')
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 DFW07CA202Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Taylor, TXThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate in-flight planning/decision. Contributing factors were the lack of suitable terrain for the forced landing and the dark night.NTSB IAD96FA138Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Whitefield, NHthe pilot's failure to adequately preflight the aircraft which led to the loss of engine power due to fuel exhaustion, and the pilot's attempt to return to the airport by executing a steep left turn which led to a stall and subsequent loss of control of the…NTSB BFO92FA011Accident · Serious injuriesField investigationFinal reportPiper PA-24-180 · Sandston, VAThe loss of engine power due to fuel exhaustion and the pilots selection of unsuitable terrain for the force landing. A factor was the pilot's improper inflight decision.NTSB ATL90LA106Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cartersville, GAThe pilot's improper use of the engine fuel mixture control which resulted in fuel exhaustion.NTSB ATL90FA031Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Helen, GAThe pilot's failure to properly preflight and plan en route refueling stops. The airplane collided with trees during the emergency descent.NTSB MIA89LA244Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Titusville, FLFailure of the private pilot (dual student) to assure the fuel selector was positioned to the proper tank, which resulted in fuel starvation; and inadequate supervision by the instructor pilot (CFI). The trees were a related factor.NTSB CHI89FA117Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Delphi, INImproper planning/decision of the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel, and his failure to maintain flying speed during a forced landing, which resulted in a stall and subsequent impact with the ground.NTSB DEN89FA061Accident · 1 fatalField investigationFinal reportPiper PA-24-180 · Albuquerque, NMEngine stoppage from fuel starvation which resulted from the pilot's failure to select the fullest tank for takeoff. In addition the pilot attempted to return to the airport during the forced landing and inadvertently stalled the aircraft during the…NTSB MIA87LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Gainesville, FLThe non instument rated private pilot filed an instrument flight plan for a 5 hour flight. The flight lasted 5 hours and 26 minutes when the pilot radioed controllers that he had run out of fuel and the engine failed. The aircraft crashed at the destination…NTSB DEN86LA221Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Albuquerque, NMThe plt rprtd the acft was refueled to capacity at longmont, CO. Full capacity should have provided at least 3.6 hrs of flying time at normal consumption. After refueling, the acft was flown 1.3 hrs to fowler, CO, where it remained parked for a week. The plt…NTSB LAX85FA137Accident · Serious injuriesField investigationFinal reportPiper PA-24-250 · Corona, CAAfter refueling, the acft took off & lost pwr at 150 ft to 200 ft AGL. The acft struck trees while in a steepening left bank & crashed in an open field adjacent to the arpt. No contaminants or water were found either in the acft's fuel system or in the fuel…NTSB ATL83FA117Accident · 3 fatalField investigationFinal reportPiper PA-24-180 · Hendersonville, NCAfter reporting level at 7,000 ft in rain, the plt reported that altitude could not be maintained due to a power loss. He stated that '...we're down to about fourteen inches and we just broke out and I got the lights.' At 1849, after a discussion with ATC…