# NTSB investigations: Beech E18S, 1986

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 MKC87FA017](https://openairdocs.org/ntsb/MKC87FA017.md): Beech E18S · Texarkana, AR · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1986 · N149AA · Destroyed
  > The airplane was on a positioning flight so it would be in place for an early Monday morning freight run. Pilot called for missed approach and after receiving clearance, declared he was in VFR conditions and thought he would land on rwy 31. During a turn, the…
- [NTSB FTW86FPA13](https://openairdocs.org/ntsb/FTW86FPA13.md): Beech E18S · Terrell, TX · Accident · No injuries · Final report · Jan 2, 1986 · N27Y · Substantial damage
  > The plt reported the acft yawed left on takeoff and despite attempted remedial action the acft would not clear odstaclesalong the flt path. Pwr was reduced and a straight in landing was made in a fld aprx 1/4 mile north of the rwy. A witness reported 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 year(c."eventDate") = 1986
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151006', '1151007'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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