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

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 DFW08LA052](https://openairdocs.org/ntsb/DFW08LA052.md): Althouse RAF 2000 GTX · Crowley, TX · Accident · 2 fatal · Limited investigation · Final report · Dec 29, 2007 · N136DG · Destroyed
  > The pilot's failure to maintain rotor rpm while maneuvering, which resulted in a loss of rotor blade rigidity.
- [NTSB CHI08LA052](https://openairdocs.org/ntsb/CHI08LA052.md): Levick RAF-2000-GTX-SE · Salem, IN · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 2007 · N24DN · Destroyed
  > The pilot's failure to maintain control of the gyroplane during climbout after takeoff.
- [NTSB CHI08CA034](https://openairdocs.org/ntsb/CHI08CA034.md): Gluff, Alan Zenair 200 · Greenwood, IN · Accident · Minor injuries · Data collection · Final report · Nov 4, 2007 · N601AG · Substantial damage
  > The total loss of engine power due to a lubricating system leak for undetermined reasons which resulted in engine seizure, and the unsuitable terrain encountered during the forced landing. Contributing factors were the plowed field and the nose gear failure…
- [NTSB NYC08LA005](https://openairdocs.org/ntsb/NYC08LA005.md): Pelt Mad Max II Special · Blacksburg, VA · Accident · 1 fatal · Limited investigation · Final report · Oct 6, 2007 · N26VT · Substantial damage
  > A loss of engine power for undetermined reasons. Contributing to the accident was a lack of suitable terrain for a forced landing.
- [NTSB DFW08CA006](https://openairdocs.org/ntsb/DFW08CA006.md): Vans RV6 · Halifax, VA · Accident · No injuries · Data collection · Final report · Oct 2, 2007 · N6RP · Substantial damage
  > The pilot's inadvertent stall during a forced landing. A contributing factor was the pilot's failure to place the electronic prop controller in the manual mode prior to aborting the landing which resulted in a loss of engine power.
- [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 MIA07CA108](https://openairdocs.org/ntsb/MIA07CA108.md): James L. Stringfellow Glastar · Williston, FL · Accident · Minor injuries · Data collection · Final report · Jun 9, 2007 · N33CP · Substantial damage
  > The pilot's misjudgment of distance/altitude and his improper touchdown point which resulted in an undershoot, nose over and damage to the airplane.
- [NTSB SEA07CA136](https://openairdocs.org/ntsb/SEA07CA136.md): Lidgard 4-1200 · Spartanburg, SC · Accident · Minor injuries · Data collection · Final report · May 26, 2007 · N613KF · Substantial damage
  > The pilot lost directional control of the airplane during takeoff. A contributing factor was the pilot's lack of experience in the accident airplane make/model.
- [NTSB LAX07LA147](https://openairdocs.org/ntsb/LAX07LA147.md): Ceridono Vegas Sport Flyer · Mountain Pass, CA · Accident · 1 fatal · Limited investigation · Final report · May 1, 2007 · N169BC · Destroyed
  > The loss of airplane control while maneuvering after takeoff for an undetermined reason.
- [NTSB LAX07LA142](https://openairdocs.org/ntsb/LAX07LA142.md): McDonald J4B-2 · Marysville, CA · Accident · 1 fatal · Limited investigation · Final report · Apr 29, 2007 · N445SM · Destroyed
  > An in-flight loss of control for undetermined reasons. Contributing to the accident was the impairment of the pilot by the drug substances identified in the toxicological testing.
- [NTSB CHI07CA081](https://openairdocs.org/ntsb/CHI07CA081.md): Rotary Air Force Marketing RAF 2000 · Neenah, WI · Accident · No injuries · Data collection · Final report · Feb 23, 2007 · N5077F · Substantial damage
  > The pilot's failure to maintain directional control during landing, which resulted in a runway excursion. Contributing factors were a bent rudder trim tab, the narrow runway, and the uneven terrain at the edge of the runway pavement.

## 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") = 2007
  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=2007

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