# NTSB investigations: Subaru ALL MDLS A/B: Airframe/component/system failure/malfunction

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 SEA05CA195](https://openairdocs.org/ntsb/SEA05CA195.md): Eiland RAF-200 Gyro · Bend, OR · Accident · Minor injuries · Data collection · Final report · Sep 18, 2005 · N4416N · Substantial damage
  > The malfunction of the flight controls for an undetermined reason, which resulted in a loss of control and in-flight collision with terrain.
- [NTSB CHI03LA152](https://openairdocs.org/ntsb/CHI03LA152.md): Zimmerman Glastar · Pierce, NE · Accident · No injuries · Limited investigation · Final report · Jun 7, 2003 · N109BZ · Substantial damage
  > The pilot's operation of the airplane with known deficiencies in equipment and his selection of unsuitable terrain for landing. Factors contributing to this accident were the overtemperature of the engine cooling system, the long grass, and the collapse of…
- [NTSB MIA01LA213](https://openairdocs.org/ntsb/MIA01LA213.md): Avid Mk-4 · Salisbury, NC · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2001 · N567SM · Substantial damage
  > , An aileron control system failure during climb due to an improper welded installation by the aircraft homebuilder, resulting in an inflight loss of lateral control, and an inflight collision with the terrain during an uncontrolled descent and landing.
- [NTSB BFO93LA106](https://openairdocs.org/ntsb/BFO93LA106.md): Wernega Benson KB-2 · Mount Holly, NJ · Accident · 1 fatal · Limited investigation · Final report · Jul 4, 1993 · N6606B · Destroyed
  > The pilot's improper use of the gyroplane's flight controls.

## 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" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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