# NTSB investigations: Beech C23: Controlled flight into terr/obj (CFIT)

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 ERA24FA053](https://openairdocs.org/ntsb/ERA24FA053.md): Beech C23 · Midland, VA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 3, 2023 · N76SB · Destroyed
  > The pilot’s decision to descend below the minimum decision altitude of the instrument approach without having the appropriate runway visual references distinctively identified and with the visibility and ceiling below the minimum that was prescribed for the…
- [NTSB ERA21FA148](https://openairdocs.org/ntsb/ERA21FA148.md): Beech C23 · Purcellville, VA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 4, 2021 · N67013 · Substantial damage
  > The pilot's improper decision to depart from the short turf runway with a tailwind.
- [NTSB GAA15CA128](https://openairdocs.org/ntsb/GAA15CA128.md): Beech C23 · Long Beach, CA · Accident · No injuries · Data collection · Final report · Jun 19, 2015 · N24022 · Substantial damage
  > The pilot failed to maintain clearance from trees while maneuvering to land at night, which resulted in a collision with terrain/objects. A factor contributing to the accident was the lack of oversight by ATC; failing to insure that the fully operational VASI…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151242')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '120' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/120/sequence?model=1151242

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