NTSB investigations: Piper PA-28-180
16 cases on aircraft the registry lists as Piper PA-28-180, 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
| 2009 | 2 |
|---|---|
| 2010 | 2 |
| 2014 | 2 |
| 2016 | 3 |
| 2018 | 2 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2026 | 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 ('7102808')
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 ('7102808')
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 ERA26LA273Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Linneus, METhe pilot’s inadequate preflight and in-flight monitoring of the fuel quantity, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN24LA345Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Grand Island, NEThe pilot’s inadequate preflight planning/preparation that resulted in fuel exhaustion during cruise flight, a total loss of engine power, and an impact with terrain during a forced landing.NTSB WPR23LA308Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Ritchfield, UTThe pilot’s improper preflight planning that resulted in the loss of engine power due to fuel exhaustion.NTSB ERA22LA276Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Laurinburg, NCThe pilot’s decision to depart with insufficient fuel onboard, which resulted in a total loss of engine power due to fuel exhaustion on final approach for landing.NTSB CEN19FA093Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Summersville, MOThe total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate preflight fuel planning and in-flight fuel monitoring.NTSB CEN19FA005Accident · 1 fatalField investigationFinal reportPiper PA28 · Cartersville, GAThe pilot's inadequate preflight and inflight fuel planning and his decision to continue flight without stopping for fuel, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA18CA264Accident · No injuriesData collectionFinal reportPiper PA28 · Addison, TXThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA17CA089Accident · No injuriesData collectionFinal reportPiper PA 28 · Thomson, GAThe pilot’s improper preflight planning, which resulted in fuel exhaustion and the total loss of engine power.NTSB GAA16CA302Accident · No injuriesData collectionFinal reportPiper PA 28 · Rowesville, SCThe fuel line failure between the fuel transducer and the carburetor, which resulted in a total loss of engine power and subsequent forced off airport landing.NTSB ERA16LA192Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Batavia, NYThe student pilot's failure to maintain directional control during takeoff, which resulted in a collision with runway signs.NTSB ERA14LA440Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-180 · St. Petersburg, FLA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s improper preflight fuel planning and in-flight fuel management.NTSB CEN14CA303Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Port Isabel, TXA loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.NTSB ERA10CA214Accident · Serious injuriesData collectionFinal reportPiper PA28 · Louisville, KYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.NTSB ERA10CA194Accident · Serious injuriesData collectionFinal reportPiper PA-28-180 · Palermo, NYA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB ERA10LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Brooksville, FLA loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB CEN09FA377Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Sanborn, IAA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning and failure to refuel.