# NTSB investigations: Beech C23, 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 DFW08CA109](https://openairdocs.org/ntsb/DFW08CA109.md): Beech C23 · Santa Fe, NM · Accident · No injuries · Data collection · Final report · Apr 20, 2008 · N23845 · Substantial damage
  > The pilot's improper recovery from a bounced landing.
- [NTSB DEN88LA122](https://openairdocs.org/ntsb/DEN88LA122.md): Beech C23 · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N9311S · Substantial damage
  > The private plt was taking off with three passengers for a personal transportation flight. The airplane left the runway and only gained about 50 feet AGL according to a witness. The plt reported that the aircraft reached 200 feet AGL. The airplane stalled and…
- [NTSB FTW83LA312](https://openairdocs.org/ntsb/FTW83LA312.md): Beech C-23 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1983 · N1932L · Destroyed
  > The aircraft impacted 2.2 miles off the departure end of runway 35 at coronada airport. Witnesses stated the aircraft used almost all of the 4020 ft runway before becoming airborne and the aircraft achieved an altitude of only 20 feet. Investigation revealed…
- [NTSB DEN79FQA32](https://openairdocs.org/ntsb/DEN79FQA32.md): Beech C23 · Albuquerque, NM · Accident · No injuries · Closed · Jun 18, 1979 · N23986 · 2 aircraft · Substantial damage
- [NTSB DEN79DQG03](https://openairdocs.org/ntsb/DEN79DQG03.md): Beech C-23 · Clovis, NM · Accident · No injuries · Closed · May 23, 1979 · N2142W · Substantial damage
- [NTSB DEN78FQA48](https://openairdocs.org/ntsb/DEN78FQA48.md): Beech C23 · Grants, NM · Accident · No injuries · Closed · Aug 9, 1978 · N23986 · Substantial damage
- [NTSB DEN77FA055](https://openairdocs.org/ntsb/DEN77FA055.md): Beech C-23 · Miami, NM · Accident · 2 fatal · Closed · Aug 28, 1977 · N9756L · Destroyed
- [NTSB DEN76FQA61](https://openairdocs.org/ntsb/DEN76FQA61.md): Beech 23 · Albuquerque, NM · Accident · No injuries · Closed · Aug 16, 1976 · N9150S · 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 ('1151242'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1151242&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.