# NTSB investigations: Beech V35, 1983

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 FTW83FA387](https://openairdocs.org/ntsb/FTW83FA387.md): Beech V35 · Conchas, NM · Accident · 4 fatal · Field investigation · Final report · Aug 21, 1983 · N5429U · Destroyed
  > It was reported that the plt had been giving rides to various family members & the acft was observed flying in the area of Conchas lake on several occasions. It was also reported that the acft had 'buzzed' boats on the lake several times during the day. The…
- [NTSB MIA83FA123](https://openairdocs.org/ntsb/MIA83FA123.md): Beech V35TC · Destin, FL · Accident · Serious injuries · Field investigation · Final report · Apr 17, 1983 · N265T · Destroyed
  > The acft collided with a powerline, crashed & burned after the engine lost power on the final approach. The acft was using fuel from a tank that was less than half full. The acft had made a go-around and during the pattern was observed to be oscillating from…

## 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 year(c."eventDate") = 1983
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151538'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1151538&year=1983

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