# NTSB investigations: Subaru ALL MDLS A/B: Not determined, general

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 CEN24FA298](https://openairdocs.org/ntsb/CEN24FA298.md): DeGraw DeBird · Napoleon, MI · Accident · 1 fatal · Class 3 · Field · Final report · Aug 4, 2024 · N140DG · Substantial damage
  > Separation of the gyroplane’s tail due to main rotor blade contact for reasons that could not be determined.
- [NTSB ERA21LA277](https://openairdocs.org/ntsb/ERA21LA277.md): Vans RV7 · Pottstown, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 4, 2021 · N654C · Destroyed
  > A total loss of power for reasons that could not be determined based on the available information.
- [NTSB WPR19LA023](https://openairdocs.org/ntsb/WPR19LA023.md): Vans RV7A · Ramona, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 10, 2018 · N5433T · Destroyed
  > The partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA18LA039](https://openairdocs.org/ntsb/ERA18LA039.md): Kevin Leue Sparrow Hawk · Hernando, MS · Accident · 2 fatal · Limited investigation · Final report · Dec 2, 2017 · N481ZK · Destroyed
  > Impact with trees and terrain for reasons that could not be determined based on available evidence.
- [NTSB CEN16LA031](https://openairdocs.org/ntsb/CEN16LA031.md): American Autogyro Sparrowhawk · Wakeman, OH · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 2015 · N80825 · Substantial damage
  > A loss of engine power/performance for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA11CA373](https://openairdocs.org/ntsb/ERA11CA373.md): Leatherman Karl L Zodiac CH 601 HDS · Gray Court, SC · Accident · No injuries · Data collection · Final report · Jun 30, 2011 · N67KL · Substantial damage
  > The total loss of engine power due to the failure of the radiator coolant supply fitting.
- [NTSB WPR09LA264](https://openairdocs.org/ntsb/WPR09LA264.md): Polit Kitfox Ser 5 Outback · Apple Valley, CA · Accident · 1 fatal · Limited investigation · Final report · May 23, 2009 · N781VP · Substantial damage
  > The pilot's loss of aircraft control for undetermined reasons while maneuvering at low altitude.
- [NTSB WPR09LA215](https://openairdocs.org/ntsb/WPR09LA215.md): Stanton Glastar · Redding, CA · Accident · No injuries · Limited investigation · Final report · Apr 25, 2009 · N518PV · Substantial damage
  > A loss of engine power during cruise for undetermined reasons.

## 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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '05000000')))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/05000000/cases?engine=59050

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
