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

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 CEN22LA150](https://openairdocs.org/ntsb/CEN22LA150.md): Sparrow Hawk III · Lubbock, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 23, 2022 · N430HS · Substantial damage
  > The pilot’s failure to maintain control of the gyrocopter during takeoff with strong gusty winds.
- [NTSB CEN14CA059](https://openairdocs.org/ntsb/CEN14CA059.md): Groen Sparrowhawk II · Lubbock, TX · Accident · No injuries · Data collection · Final report · Nov 10, 2013 · N130SW · Substantial damage
  > The pilot's failure to attain a proper glidepath for landing which resulted in a hard landing.
- [NTSB CEN12CA226](https://openairdocs.org/ntsb/CEN12CA226.md): Ruiz E RAF 2000 · Anahuac, TX · Accident · No injuries · Data collection · Final report · Mar 31, 2012 · N9012R · Substantial damage
  > The student pilot's improper nosewheel and cyclic positioning during the taxi, which resulted in the gyroplane's main rotor contacting the runway surface. Contributing to the accident was the flight instructor’s inadequate supervision.
- [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 DFW05CA120](https://openairdocs.org/ntsb/DFW05CA120.md): Mayfield Sparrowhawk · Hondo, TX · Accident · No injuries · Data collection · Final report · May 14, 2005 · N8023Y · Substantial damage
  > The pilot's failure to maintain control of the gyrocraft during takeoff. A contributing factor was the failure of the pre-rotator cable.
- [NTSB DFW05LA016](https://openairdocs.org/ntsb/DFW05LA016.md): Wilson Loenslo YMF-80 · Arcola, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 2004 · N6254A · Destroyed
  > The pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff initial climb.
- [NTSB FTW02LA110](https://openairdocs.org/ntsb/FTW02LA110.md): Thornley Thornley 2000 · Granite Shoals, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2002 · N248JT · Substantial damage
  > the pilot's failure to maintain clearance with a power line while maneuvering. Contributing factors were the pilot's diverted attention and the power lines.
- [NTSB FTW99FA038](https://openairdocs.org/ntsb/FTW99FA038.md): Blanton RAF 2000 · The Colony, TX · Accident · 1 fatal · Field investigation · Final report · Nov 28, 1998 · N14GR · Destroyed
  > The pilot's failure to maintain control of the gyroplane during cruise flight. A factor was the gusty wind condition.
- [NTSB FTW97LA278](https://openairdocs.org/ntsb/FTW97LA278.md): Watts RAF 2000 Gyroplane · Conroe, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 1997 · N6826Z · Substantial damage
  > The pilot's failure to maintain aircraft control. A factor was his premature liftoff at low airspeed.

## 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" = 'TX' 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=TX

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