# NTSB investigations: Beech A23A, MI

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 CHI96LA131](https://openairdocs.org/ntsb/CHI96LA131.md): Beech A23A · Saginaw, MI · Accident · No injuries · Limited investigation · Final report · Apr 13, 1996 · N3613Q · Substantial damage
  > the student pilot's improper flare and improper recovery from a bounced landing.
- [NTSB CHI90LA255](https://openairdocs.org/ntsb/CHI90LA255.md): Beech A23A · Newaygo, MI · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1990 · N2334W · Substantial damage
  > The student pilot's improper level-off and recovery from a bounced landing which resulted in a loss of control. In addition, an unqualified person was coaching the student from the ground.
- [NTSB CHI86LA072](https://openairdocs.org/ntsb/CHI86LA072.md): Beech A23A · Hastings, MI · Accident · No injuries · Limited investigation · Final report · Jan 18, 1986 · N6900Q · Substantial damage
  > The pilot estimated he had 13 gallons of fuel on board for the estimated fifty minute flight. He estimated his fuel burn at nine gallons per hour giving him an hour and twenty five minute fuel endurance. He ran out of fuel an hour and twenty five minutes…
- [NTSB CHI79FEC22](https://openairdocs.org/ntsb/CHI79FEC22.md): Beech A23A · Fraser, MI · Accident · Minor injuries · Closed · May 6, 1979 · N5955S · Substantial damage
- [NTSB CHI73AEM41](https://openairdocs.org/ntsb/CHI73AEM41.md): Beech A23A · Allegan, MI · Accident · No injuries · Closed · Feb 19, 1973 · N2344W · Substantial damage
- [NTSB CHI69F0154](https://openairdocs.org/ntsb/CHI69F0154.md): Beech A23 · Monroe, MI · Accident · Serious injuries · Closed · Jul 29, 1968 · N7969L · Destroyed
- [NTSB CHI68F0710](https://openairdocs.org/ntsb/CHI68F0710.md): Beech A23 · Monroe, MI · Accident · No injuries · Closed · Apr 21, 1968 · N7969L · 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" = 'MI' 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=MI

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