# NTSB investigations: Weatherly 201B, 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 DFW06LA087](https://openairdocs.org/ntsb/DFW06LA087.md): Weatherly 201B · Hondo, TX · Accident · 1 fatal · Limited investigation · Final report · Mar 21, 2006 · N1257W · Substantial damage
  > A loss of aircraft control for undetermined reasons.
- [NTSB DFW05CA132](https://openairdocs.org/ntsb/DFW05CA132.md): Weatherly 201B · Tornillo, TX · Accident · Minor injuries · Data collection · Final report · May 24, 2005 · N1284W · Substantial damage
  > The loss of engine power as result of the failure of a cylinder.
- [NTSB FTW89DQG03](https://openairdocs.org/ntsb/FTW89DQG03.md): Weatherly 201B · Miami, TX · Accident · Minor injuries · Final report · May 20, 1989 · N1271W · Substantial damage
  > The pilot's failure to maintain adequate clearance from a known obstacle during agricultural spray flight operations,
- [NTSB FTW85LA281](https://openairdocs.org/ntsb/FTW85LA281.md): Weatherly 201B · Rosharon, TX · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N2938W · Substantial damage
  > The plt stated he failed to switch fuel selector to the left tank prior to takeoff (right tank empty). The engine quit abruptly at low altitude. Plt switched to left tank but could not regain engine power prior to hard landing in cotton field.

## 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.aircraft_model_code IN ('9630408'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=9630408&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.