NTSB investigations: Piper PA-28-181

8 cases on aircraft the registry lists as Piper PA-28-181, where the sequence of events included Fuel starvation. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20102026

NTSB investigations: Piper PA-28-181 per year, 2010–2026: 8 cases
2010	1
2019	1
2021	1
2023	2
2024	3

Where

Open the map

Latest cases

Query with SQL

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 ('7102807', '7102832') 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" = '191' 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

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 ('7102807', '7102832')
      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\" = '191' 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 ('7102807', '7102832')
    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" = '191' 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

Run 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 ERA25LA003Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Tampa Bay, FLA total loss of engine power in flight due to fuel starvation. Contributing to the accident was the inadequate preflight fuel planning by the student pilot and flight instructor, and the improper inflight fuel management by the student pilot.Oct 3, 2024 · N8575F · Substantial damage NTSB ERA24LA369Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Somerville, NJA total loss of engine power due to an undetermined fuel delivery issue.Sep 4, 2024 · N512AF · Substantial damage NTSB CEN24LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Arcola, TXLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl following an annual inspection.Jul 16, 2024 · N1941V · Substantial damage NTSB CEN24LA050Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Minneapolis, MNLoss of engine power due to fuel starvation that was the result of a leaking fuel drain.Nov 28, 2023 · N8274H · Substantial damage NTSB WPR23LA203Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · West Jordan, UTLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl.May 29, 2023 · N456Y · Substantial damage NTSB CEN21LA383Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Gypsum, COA loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.Aug 24, 2021 · N46MD · Substantial damage NTSB GAA20CA017Accident · No injuriesData collectionFinal reportPiper PA28 · Dayton, OHThe pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing, during which the airplane struck a vehicle.Oct 10, 2019 · N8078X · Substantial damage NTSB WPR10CA267Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Palo Alto, CAA total loss of engine power on final approach due to fuel starvation as a result of the pilot's inadequate fuel management.May 29, 2010 · N2865M · Substantial damage