# NTSB investigations: Beech B23, IN

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 CHI89FA036](https://openairdocs.org/ntsb/CHI89FA036.md): Beech B23 · Jeffersonville, IN · Accident · 4 fatal · Field investigation · Final report · Dec 26, 1988 · N6100N · Destroyed
  > Pilot-in-command's poor inflight decision in attempting to return to the airport after a partial engine failure, and his encountering a stall/spin at low altitude from which he was unable to recover.
- [NTSB CHI87LA007](https://openairdocs.org/ntsb/CHI87LA007.md): Beech BE-23 · Lake Village, IN · Accident · No injuries · Limited investigation · Final report · Oct 21, 1986 · N6997Q · Substantial damage
  > The plt stated that the acft would not start so he applied the acft hand brake and proceeded to hand prop the acft with no one aboard. While hand propping the acft, the engine fired and the hand brake did not hold. As the plt walked around the right wing, the…
- [NTSB CHI70F0027](https://openairdocs.org/ntsb/CHI70F0027.md): Beech B23 · Indianapolis, IN · Accident · No injuries · Closed · May 28, 1969 · N6989Q · 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" = 'IN' 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 ('1151240'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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