# NTSB investigations: Beech A23A, 1982

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 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 CHI82FA032](https://openairdocs.org/ntsb/CHI82FA032.md): Beech A23A · London, OH · Accident · 1 fatal · Field investigation · Final report · Jan 24, 1982 · N6940Q · Destroyed
  > The pilot received two weather briefings for a flight from columbus to springfield, Ohio. VFR flight was not recommended. The pilot took off after the tower closed at 2300 EST. At about 2341 a witness near the crash site heard the loud sound of an aircraft…

## 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") = 1982
  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&year=1982

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