NTSB investigations: Piper PA-24-250
11 cases on aircraft the registry lists as Piper PA-24-250, where the sequence of events included Fuel exhaustion. 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
| 2008 | 1 |
|---|---|
| 2013 | 1 |
| 2014 | 2 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 2 |
| 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.\"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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '192' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('7102404')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '192' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA25LA006Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Moore Haven, FLThe pilot’s failure to initiate the cross country flight with an adequate fuel supply, resulting in a loss of engine power and forced landing due to fuel exhaustion.NTSB CEN22LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Kearney, NEThe pilot’s inadequate in-flight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB CEN22FA298Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · St. Jacob, ILThe inadequate maintenance of the airplane fuel system that resulted in fuel exhaustion and a loss of engine power.NTSB CEN20LA370Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA24 · Bryan, TXA total loss of engine power on takeoff due to fuel starvation.NTSB GAA19CA382Accident · No injuriesData collectionFinal reportPiper PA24 · Brunswick, GAThe pilot's failure to properly lean the fuel mixture in flight, which resulted in fuel exhaustion, a subsequent total loss of engine power, and a forced landing with the landing gear retracted.NTSB GAA19CA053Accident · Minor injuriesData collectionFinal reportPiper PA24 · Texico, NMThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a total loss of engine power.NTSB GAA16CA277Accident · Minor injuriesData collectionFinal reportPiper PA 24 · Loda, ILThe pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing, runway excursion, and impact with a…NTSB CEN15LA064Accident · Serious injuriesLimited investigationFinal reportPiper PA 24-250 · Berrien Springs, MIThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN14CA227Accident · No injuriesData collectionFinal reportPiper PA 24-250 · New Braunfels, TXThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight planning and inflight decision making.NTSB ERA13LA408Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Woodstock, CTThe pilot’s improper preflight inspection, which resulted in fuel exhaustion and a total loss of engine power.NTSB SEA08CA152Accident · Minor injuriesData collectionFinal reportPiper PA-24-250 · Vernal, UTThe pilot's failure to verify the airplane's fuel quantity during his preflight, resulting in fuel exhaustion. Contributing to the accident was the presence of a vehicle on the road where the pilot executed his forced landing.