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

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 MIA01LA047](https://openairdocs.org/ntsb/MIA01LA047.md): Larry Groover Eagle · Auburndale, FL · Accident · No injuries · Limited investigation · Final report · Dec 22, 2000 · N8132L · Substantial damage
  > the pilot's failure to maintain adequate clearance during takeoff, which resulted in an inflight collision with a fence and substantial damage to the aircraft.
- [NTSB DEN01LA015](https://openairdocs.org/ntsb/DEN01LA015.md): Murdock RAF 2000 GTX · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Nov 18, 2000 · N6382T · Substantial damage
  > The pilot's improper touchdown which resulted in a hard landing. Factors were lack of familiarity with the aircraft and lack of total experience.
- [NTSB SEA00LA169](https://openairdocs.org/ntsb/SEA00LA169.md): Clearwaters RAF 2000 · Leahy, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 2000 · N61376 · Destroyed
  > A loss of control for undetermined reasons.
- [NTSB MIA00LA204](https://openairdocs.org/ntsb/MIA00LA204.md): Spurgeon Avid Bandit · Columbus, MS · Accident · No injuries · Limited investigation · Final report · Jul 1, 2000 · N60698 · Substantial damage
  > the owner/builder's improper installation that resulted in the fuel line being snagged, resulting in fuel starvation and an inflight loss of engine power and subsequent damage to the airplane during the forced landing.
- [NTSB DEN00LA079](https://openairdocs.org/ntsb/DEN00LA079.md): Green GTX-SE-FI · Gillette, WY · Accident · 1 fatal · Limited investigation · Final report · Apr 30, 2000 · N2411V · Destroyed
  > The pilot's abruptly pulling the nose up at an excessive airspeed, resulting in the rotor blades striking the vertical stabilizer and a subsequent loss of aircraft control.
- [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.

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

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