# NTSB investigations: Weatherly 201B: In flight collision with terrain/water

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 CHI06CA162](https://openairdocs.org/ntsb/CHI06CA162.md): Weatherly 201B · Bowbells, ND · Accident · Minor injuries · Data collection · Final report · Jun 22, 2006 · N1263W · Substantial damage
  > The pilot's failure to maintain clearance to the rising terrain while maneuvering during the agricultural application flight. Contirbuting factors were the low altitude operation and the rising terrain.
- [NTSB MKC83LA188](https://openairdocs.org/ntsb/MKC83LA188.md): Weatherly 201B · Agency, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 1983 · N1259W · Destroyed
  > The plt was engaged in aerial application over a small 9 acre bean field that was surrounded on 3 sides by hedge rows. He reported that as he descended on the leeward side of a hedge row to begin a swath run, the acft encountered turbulence & mushed into the…
- [NTSB DEN83LA166](https://openairdocs.org/ntsb/DEN83LA166.md): Weatherly 201B · Thompson, ND · Accident · No injuries · Limited investigation · Final report · Jul 15, 1983 · N1279W · Substantial damage
  > The acft crashed during descent for the first swath run. Investigation revealed that the pilot applied back pressure to the control stick to flare from the descent. The acft did not respond and continued to descend. The impact was hard enough to tear the left…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9630408')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=9630408&occurrence=230

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