# NTSB investigations: Beech C18S, FL

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 MIA86LA046](https://openairdocs.org/ntsb/MIA86LA046.md): Beech C-18S · Deland, FL · Accident · No injuries · Limited investigation · Final report · Dec 19, 1985 · N64463 · Substantial damage
  > The pilot in the right seat was making his first landing in that make and model of aircraft. During the landing roll he tried to raise the wing flaps lever. Instead, he raised the landing gear lever causing the landing gear to retract.
- [NTSB MIA70D0141](https://openairdocs.org/ntsb/MIA70D0141.md): Beech C-18S · Naples, FL · Accident · No injuries · Closed · Sep 4, 1969 · N6806C · Substantial damage
- [NTSB MIA69D0070](https://openairdocs.org/ntsb/MIA69D0070.md): Beech C-18S · Naples, FL · Accident · No injuries · Closed · Jul 10, 1968 · N6777C · Substantial damage
- [NTSB MIA67F0566](https://openairdocs.org/ntsb/MIA67F0566.md): Beech C-18S · Ft Lauderdale, FL · Accident · No injuries · Closed · May 9, 1967 · N21925 · Substantial damage
- [NTSB MIA66F0084](https://openairdocs.org/ntsb/MIA66F0084.md): Beech C-18S · Marathon, FL · Accident · Minor injuries · Closed · Jul 10, 1965 · N7871B · Destroyed
- [NTSB UNK65X0385](https://openairdocs.org/ntsb/UNK65X0385.md): Beechcraft C185 · Miami, FL · Accident · No injuries · Closed · Oct 23, 1964 · N6688C · Substantial damage
- [NTSB UNK65X0176](https://openairdocs.org/ntsb/UNK65X0176.md): Beechcraft C18S · Marathon, FL · Accident · No injuries · Closed · Oct 7, 1964 · N7871B · Substantial damage
- [NTSB UNK64X0865](https://openairdocs.org/ntsb/UNK64X0865.md): Beechcraft C18S · Key West, FL · Accident · No injuries · Closed · Mar 9, 1964 · N37R · 2 aircraft · Minor damage
- [NTSB UNK64X0243](https://openairdocs.org/ntsb/UNK64X0243.md): Beechcraft C18S · Lakeland, FL · Accident · No injuries · Closed · Jan 14, 1964 · N133BF · 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" = 'FL' 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 ('1150902'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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