# NTSB investigations: Wright 760A B D E&ET, WA

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 SEA04LA162](https://openairdocs.org/ntsb/SEA04LA162.md): Universal Moulded Pdts. Monocoach · Pullman, WA · Accident · No injuries · Limited investigation · Final report · Aug 17, 2004 · N11872 · Substantial damage
  > The failure of a landing gear oleo retaining nut safety clip (snap ring) at an unknown point in time, leading to the partial separation of the landing gear strut while in flight, and the full collapse of the strut during the subsequent landing. Factors…
- [NTSB SEA02LA136](https://openairdocs.org/ntsb/SEA02LA136.md): Stearman C3-R · Arlington, WA · Accident · No injuries · Limited investigation · Final report · Jul 23, 2002 · N656K · Substantial damage
  > The pilot's inadequate remedial action when responding to the swerve/veer of the tailwheel equipped aircraft, leading to a failure to maintain directional control during the landing roll. Factors include the pilot’s lack of experience in the make and model…
- [NTSB SEA70DWD22](https://openairdocs.org/ntsb/SEA70DWD22.md): Waco CTO · Mt.Vernon, WA · Accident · No injuries · Closed · May 14, 1970 · N845V · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?engine=67009&state=WA

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