# NTSB investigations: Beech A23A, WI

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 CHI08CA173](https://openairdocs.org/ntsb/CHI08CA173.md): Beech A23A · Sheboygan, WI · Accident · Minor injuries · Data collection · Final report · Jun 29, 2008 · N701DW · Substantial damage
  > The pilot's improper fuel management that led to fuel starvation and the loss of engine power. Contributing to the accident was the drainage ditch.
- [NTSB CHI82DA287](https://openairdocs.org/ntsb/CHI82DA287.md): Beech A23A · Grantsburg, WI · Accident · No injuries · Final report · Jul 31, 1982 · N3683Q · Substantial damage
  > The pilot could not start the aircraft with the mixture in the normal (rich) position. The mixture was set to lean and the engine started. During takeoff, the engine lost power and the pilot landed off the end of the runway. This was the first flight since an…
- [NTSB CHI77FEP38](https://openairdocs.org/ntsb/CHI77FEP38.md): Beech A23 · Portage, WI · Accident · Minor injuries · Closed · Jun 19, 1977 · N1479L · Substantial damage
- [NTSB CHI70D0094](https://openairdocs.org/ntsb/CHI70D0094.md): Beech A23A · Waukesha, WI · Accident · No injuries · Closed · Jul 6, 1969 · N7996L · Substantial damage
- [NTSB CHI66F0745](https://openairdocs.org/ntsb/CHI66F0745.md): Beech A23A · Cable, WI · Accident · No injuries · Closed · May 24, 1966 · N2360W · 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" = 'WI' 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 ('1151208'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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