# NTSB investigations: Beech B23, NM

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 DEN88FA170](https://openairdocs.org/ntsb/DEN88FA170.md): Beech B23 · Cimarron, NM · Accident · 1 fatal · Field investigation · Final report · Aug 2, 1988 · N4006T · Destroyed
  > The pilot to properly preflight his aircraft in accordance with the procedures provided in the operators handbook thus causing the engine to lose power following takeoff due to fuel contamination caused by water.
- [NTSB DEN84FA144](https://openairdocs.org/ntsb/DEN84FA144.md): Beech B23 · Ruidoso, NM · Accident · 1 fatal · Field investigation · Final report · May 4, 1984 · N9137T · Destroyed
  > The pilot stated that upon landing a gust of wind blew the aircraft off the runway center and he initiated a go-around. Witnesses stated the aircraft climbed to approximately 200 to 300 ft and started a left turn. Engine power appeared to be minimal. As the…
- [NTSB FTW81FQA38](https://openairdocs.org/ntsb/FTW81FQA38.md): Beech B23 · Taos, NM · Accident · No injuries · Closed · Jul 22, 1981 · N7658R · 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" = 'NM' 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=NM

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