# NTSB investigations: Beech A23, MN

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 CHI90FA250](https://openairdocs.org/ntsb/CHI90FA250.md): Beech A23A · St Paul, MN · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1990 · N8871M · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall/spin.
- [NTSB CHI87LA196](https://openairdocs.org/ntsb/CHI87LA196.md): Beech A23 · Longville, MN · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N8799M · Destroyed
  > The student plt rprtd that as he rounded out to land, the acft nosed down & impacted nosewheel first. Subsequently, the nose gear collapsed & the acft skidded to a stop. After coming to rest, a fire erupted, which spread & subsequently destroyed the acft.
- [NTSB CHI81FER09](https://openairdocs.org/ntsb/CHI81FER09.md): Beech A23 · Stanton, MN · Accident · No injuries · Closed · Dec 28, 1980 · N8871M · Substantial damage
- [NTSB MKC77DER21](https://openairdocs.org/ntsb/MKC77DER21.md): Beech A-23 · Goodland, MN · Accident · No injuries · Closed · Feb 20, 1977 · N3580R · Substantial damage
- [NTSB MKC74DER52](https://openairdocs.org/ntsb/MKC74DER52.md): Beech A23 · Sleepy Eye, MN · Accident · No injuries · Closed · Jun 3, 1974 · N3560R · Substantial damage
- [NTSB MKC73FER23](https://openairdocs.org/ntsb/MKC73FER23.md): Beech A23 · Eden Prairie, MN · Accident · Serious injuries · Closed · Apr 8, 1973 · N7212T · Substantial damage
- [NTSB MKC70D0220](https://openairdocs.org/ntsb/MKC70D0220.md): Beech A23 · Mankato, MN · Accident · No injuries · Closed · Aug 26, 1969 · N8891M · Substantial damage
- [NTSB MKC68F0262](https://openairdocs.org/ntsb/MKC68F0262.md): Beech A23 · Mankato, MN · Accident · No injuries · Closed · Sep 16, 1967 · N8891M · Substantial damage
- [NTSB MKC67D0086](https://openairdocs.org/ntsb/MKC67D0086.md): Beech 23 · Mankato, MN · Accident · No injuries · Closed · Jun 28, 1966 · N8868M · Substantial damage
- [NTSB MKC66F0343](https://openairdocs.org/ntsb/MKC66F0343.md): Beechcraft 23 · So St Paul, MN · Accident · No injuries · Closed · Dec 22, 1965 · N8799M · Substantial damage
- [NTSB MKC66F0209](https://openairdocs.org/ntsb/MKC66F0209.md): Beechcraft A23 · Rochester, MN · Accident · No injuries · Closed · Aug 11, 1965 · N8771M · 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" = 'MN' 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 ('1151204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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