# NTSB investigations: Subaru ALL MDLS A/B: Loss of engine power(total) - nonmechanical

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 DEN07CA109](https://openairdocs.org/ntsb/DEN07CA109.md): Becerra Avid Flyer Mark IV · Crowheart, WY · Accident · No injuries · Data collection · Final report · Jun 17, 2007 · N196MB · Substantial damage
  > A partial blockage of the fuel filter, causing fuel starvation. A contributing factor was the rough terrain.
- [NTSB CHI04CA141](https://openairdocs.org/ntsb/CHI04CA141.md): Doerr Raymond R RV-9A · Fort Scott, KS · Accident · Minor injuries · Data collection · Final report · Jun 6, 2004 · N369RV · Substantial damage
  > The vapor lock of the airplane fuel system and the ditch encountered during the emergency landing..
- [NTSB CHI02LA260](https://openairdocs.org/ntsb/CHI02LA260.md): Anderson Kitfox Series 5 · Garden Prairie, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 2002 · N743JT · Substantial damage
  > The pilot's miscalculation of fuel consumption and his operation of the fuel system beyond its limitation, which resulted in fuel exhaustion. Contributing factors were transmission wires and dark night conditions.
- [NTSB MIA00LA204](https://openairdocs.org/ntsb/MIA00LA204.md): Spurgeon Avid Bandit · Columbus, MS · Accident · No injuries · Limited investigation · Final report · Jul 1, 2000 · N60698 · Substantial damage
  > the owner/builder's improper installation that resulted in the fuel line being snagged, resulting in fuel starvation and an inflight loss of engine power and subsequent damage to the airplane during the forced landing.

## 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.engine_model_code IN ('59050')
    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
```

This list as a web page: https://openairdocs.org/ntsb?engine=59050&occurrence=353

---
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.