# NTSB investigations: Beech B23: In flight encounter with weather

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 NYC84LA031](https://openairdocs.org/ntsb/NYC84LA031.md): Beech B23 · West Dover, VT · Accident · No injuries · Limited investigation · Final report · Nov 18, 1983 · N7605R · Substantial damage
  > The plt reported that during descent, below 4000 ft, he encounter severe turbulence. He reported that the destination wind was from the northwest, but he could not recall the wind velocity. During arrival, final apch to rwy 01 was flown at 80 mph while still…
- [NTSB SEA82DYE06](https://openairdocs.org/ntsb/SEA82DYE06.md): Beech 23 · Greenwater, WA · Accident · 1 fatal · Final report · Apr 25, 1982 · N6079N · Destroyed
  > At about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle…

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

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

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