# NTSB investigations: Beech D18S, WV

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 ATL85FA283](https://openairdocs.org/ntsb/ATL85FA283.md): Beech D18S · Huntington, WV · Accident · 1 fatal · Field investigation · Final report · Sep 25, 1985 · N25Q · Destroyed
  > The acft contacted the terrain with the left wing tip, cartwheeled and came to rest inverted during an ILS rwy 12 apch at Huntington (hts). Minimum apch visibility for the ILS is 3/4 of a mile. While en route the plt was informed the hts visibility was 1/8 of…
- [NTSB ATL83LA300](https://openairdocs.org/ntsb/ATL83LA300.md): Beech D18S · Revenswood, WV · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 1983 · N483B · Substantial damage
  > After returning from a sport parachuting flt, the plt landed on rwy 3 with a 5-KT, right x-wind. He stated that the touchdown was normal, but when the tailwheel came down at aprx 40 KTS, the acft started to turn to the left. He corrected with right rudder &…
- [NTSB IAD79FA050](https://openairdocs.org/ntsb/IAD79FA050.md): Beech D-18 · Charleston, WV · Accident · 1 fatal · Closed · May 25, 1979 · N1812D · Destroyed
- [NTSB IAD70A0014](https://openairdocs.org/ntsb/IAD70A0014.md): Beech D18S · Martinsburg, WV · Accident · No injuries · Closed · Aug 15, 1969 · N273C · Substantial damage
- [NTSB DIA69A0029](https://openairdocs.org/ntsb/DIA69A0029.md): Beech D18S · Kenna, WV · Accident · No injuries · Closed · Jan 6, 1969 · N2913B · Substantial damage
- [NTSB NYC67A0066](https://openairdocs.org/ntsb/NYC67A0066.md): Beech D18S · Parkersburg, WV · Accident · No injuries · Closed · Oct 21, 1966 · N9111 · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=1151004&state=WV

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