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

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 NYC04LA035](https://openairdocs.org/ntsb/NYC04LA035.md): Northam RAF 2000 · Nelsonia, VA · Accident · 1 fatal · Limited investigation · Final report · Nov 16, 2003 · N999GC · Destroyed
  > A loss of control for undetermined reason(s).
- [NTSB NYC04LA015](https://openairdocs.org/ntsb/NYC04LA015.md): Harris BRC 540C · Leesburg, VA · Accident · No injuries · Limited investigation · Final report · Oct 20, 2003 · N540CX · Substantial damage
  > The pilot in command's failure to maintain directional control and his inadvertent activation of the right rudder pedal.
- [NTSB LAX04CA014](https://openairdocs.org/ntsb/LAX04CA014.md): Mayfield RAF 2000 · Buckeye, AZ · Accident · Minor injuries · Data collection · Final report · Oct 16, 2003 · N4132R · Substantial damage
  > the pilot misjudged the landing flare.
- [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 SEA03LA191](https://openairdocs.org/ntsb/SEA03LA191.md): Levick RAF 2000 GTX-SE · Bonners Ferry, ID · Accident · No injuries · Limited investigation · Final report · Sep 19, 2003 · N24DN · Substantial damage
  > The pilot's inadequate compensation for gusty wind conditions and his failure to maintain directional control, which resulted in the gyrocraft departing the runway and the main rotor impacting the ground. A contributing factor was wind gusts.
- [NTSB IAD03CA062](https://openairdocs.org/ntsb/IAD03CA062.md): William Stevens RAF2000 · Stoutsville, OH · Accident · No injuries · Data collection · Final report · Jun 22, 2003 · N186S · Substantial damage
  > Separation of the engine computer wire and connector, which resulted in a partial loss of engine power.
- [NTSB MIA03LA123](https://openairdocs.org/ntsb/MIA03LA123.md): Zenith 601HDS · Immokalee, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 2003 · N601G · Substantial damage
  > Excessive rotor distributor shaft clearance that resulted in damage to the distributor rotor, a loss of ignition, the engine ceasing to operate. This resulted in a forced landing to unsuitable terrain and the airplane nosing over.
- [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 MIA03CA107](https://openairdocs.org/ntsb/MIA03CA107.md): Michael Allen Brown RAF 2000 GTX · Punta Gorda, FL · Accident · No injuries · Data collection · Final report · May 10, 2003 · N9DQ · Substantial damage
  > The pilot's failure to maintain rotor speed during the takeoff which resulted in the gyrocopter descending and the main rotor impacting the ground, incurring damage.
- [NTSB FTW03LA091](https://openairdocs.org/ntsb/FTW03LA091.md): Gilbertson Zodiac CH601HDS · Grandfield, OK · Accident · No injuries · Limited investigation · Final report · Feb 1, 2003 · N474BG · Substantial damage
  > The loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the unfavorable wind.

## 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 year(c."eventDate") = 2003
  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&year=2003

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