# NTSB investigations: Piper PA-28-161: Fuel related

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB GAA19CA534](https://openairdocs.org/ntsb/GAA19CA534.md): Piper PA28 · Sawyer, MI · Accident · No injuries · Data collection · Final report · Sep 3, 2019 · N2909U · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation, a total loss of engine power, and an off-airport landing and impact with vegetation and a ditch. Contributing to the accident was the pilot's failure to follow the Emergency Power Loss…
- [NTSB ERA19LA162](https://openairdocs.org/ntsb/ERA19LA162.md): Piper PA28 · Melbourne, FL · Accident · No injuries · Class 3 · Limited · Final report · Apr 29, 2019 · N3031W · Substantial damage
  > A partial loss of engine power due to carburetor icing, and the flight instructor’s failure to effectively use carburetor heat while operating at an idle engine power setting in conditions conducive to carburetor icing.
- [NTSB WPR19LA003](https://openairdocs.org/ntsb/WPR19LA003.md): Piper PA28 · Grass Valley, CA · Accident · No injuries · Class 3 · Limited · Final report · Oct 8, 2018 · N2250S · Substantial damage
  > A loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.
- [NTSB CEN09CA532](https://openairdocs.org/ntsb/CEN09CA532.md): Piper PA-28-161 · Washington, IA · Accident · Serious injuries · Data collection · Final report · Aug 16, 2009 · N47539 · Substantial damage
  > A loss of engine power due to carburetor icing as a result of the pilot's failure to use carburetor heat in conditions that were conducive to carburetor icing.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 ('7102803', '7102834')
    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" = '190' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/190/sequence?model=7102803

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.