# NTSB investigations: Beech B50: 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 BFO89FA069](https://openairdocs.org/ntsb/BFO89FA069.md): Beech B50 · Church Creek, MD · Accident · 3 fatal · Field investigation · Final report · Aug 23, 1989 · N3688B · Destroyed
  > VFR flight into IMC and pilot disorientation, which resulted in the loss of aircraft control. Contributing to the accident was the pilot's lack of instrument experience, darkness, and the adverse weather condition.
- [NTSB ATL85FA085](https://openairdocs.org/ntsb/ATL85FA085.md): Beech B-50 · Edgewood, KY · Accident · 3 fatal · Field investigation · Final report · Jan 31, 1985 · N3669B · Destroyed
  > During a VFR flt from london, KY, to detroit, MI, the acft crashed into a single family home while attempting a landing at cvg arpt. The plt reported a right eng pwr loss, from suspected impact ice. The alternate air source did not change the acft…

## 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 ('1152506')
    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=1152506&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.