# NTSB investigations: Subaru ALL MDLS A/B, MO

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 CEN23LA411](https://openairdocs.org/ntsb/CEN23LA411.md): Rans S6 · LIberty, MO · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 15, 2023 · N853HT · Destroyed
  > The inflight fire and impact with terrain for reasons that could not be determined due to extensive fire damage.
- [NTSB CEN17LA066](https://openairdocs.org/ntsb/CEN17LA066.md): Gosselin Charles Glastar · Lee's Summit, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 2016 · N120CG · Substantial damage
  > Partial failure of the electric system due to a battery short, which resulted in a total loss of engine power.
- [NTSB CEN11LA281](https://openairdocs.org/ntsb/CEN11LA281.md): Reeves Avid Mark IV · Brookfield, MO · Accident · No injuries · Limited investigation · Final report · Apr 2, 2011 · N6313T · Substantial damage
  > The pilot’s failure to maintain directional control during landing, which resulted in the airplane departing the runway.
- [NTSB CHI04LA011](https://openairdocs.org/ntsb/CHI04LA011.md): Domeier RV-7A · Augusta, MO · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2003 · N707DD · Substantial damage
  > The failure of the supercharger and alternator drive belts which resulted in foreign object damage to the valve timing system and subsequent loss of engine power, and the unsuitable terrain encountered by the pilot during the forced landing. A factor was the…
- [NTSB CHI00LA104](https://openairdocs.org/ntsb/CHI00LA104.md): Wilson RAF 2000 GTX SE · Monroe City, MO · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 2000 · N1964 · Substantial damage
  > the pilot not obtaining clearance from the trees. Factors were the trees and the ravine terrain condition.
- [NTSB CHI99LA309](https://openairdocs.org/ntsb/CHI99LA309.md): Pinick Horizon 2 · Grain Valley, MO · Accident · 1 fatal · Limited investigation · Final report · Aug 25, 1999 · N787TP · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in this type of airplane.

## 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."eventStateOrRegion" = 'MO' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('59050'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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