# NTSB investigations: Beech G18S: Airframe/component/system failure/malfunction

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 MIA97LA036](https://openairdocs.org/ntsb/MIA97LA036.md): Beech 18G · Roosevelt Roads, PR · Accident · 1 fatal · Limited investigation · Final report · Dec 11, 1996 · N353T · Destroyed
  > The pilot's improper planning/decision concerning separation of the left engine cowling. Factors relating to the accident were: the pilot's failure to perform weight and balance calculations, and/or to ensure the airplane was loaded in accordance with company…
- [NTSB ATL83IA034](https://openairdocs.org/ntsb/ATL83IA034.md): Beech G18S · Huntsville, AL · Incident · No injuries · Incident investigation · Final report · Nov 16, 1982 · N5BA · Minor damage
  > The left cargo door separated from the acft. The door was a hamilton cargo door installed under an STC which required 3 hinges on top & 3 pins on bottom with an overcenter locking mechanism on the handle for the pins. This door had 2 hinges installed. Only 2…
- [NTSB CHI82DA355](https://openairdocs.org/ntsb/CHI82DA355.md): Beech G18S · Indianapolis, IN · Accident · No injuries · Final report · Sep 18, 1982 · N730M · Substantial damage
  > The pilot stated that the aircraft veered to the left just after rotation. He pushed the propeller, power and mixture controls forward. The left wing and left main gear struck the ground. The aircraft then began to spin while in ground contact. The left…

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

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

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