# NTSB investigations: Beech A23-19, OK

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 FTW84LA196](https://openairdocs.org/ntsb/FTW84LA196.md): Beech A23-19 · Guthrie, OK · Accident · No injuries · Limited investigation · Final report · Apr 15, 1984 · N2385W · Substantial damage
  > While on final approach the acft descended below the desired glidepath. When the plt added pwr, the engine did not respond. The acft touched down hard and short of the rwy after which the left wing contacted a tree. The plt stated he did not use carb heat…
- [NTSB FTW71DPJ35](https://openairdocs.org/ntsb/FTW71DPJ35.md): Beech A23-19 · Turpin, OK · Accident · No injuries · Closed · Mar 28, 1971 · N6916Q · Substantial damage
- [NTSB FTW70F0277](https://openairdocs.org/ntsb/FTW70F0277.md): Beech A23-19 · Bethany, OK · Accident · No injuries · Closed · Nov 11, 1969 · N5998S · Substantial damage
- [NTSB FTW70D0250](https://openairdocs.org/ntsb/FTW70D0250.md): Beech 23-19 · Ardmore, OK · Accident · No injuries · Closed · Oct 21, 1969 · N5998S · Substantial damage
- [NTSB FTW69D0133](https://openairdocs.org/ntsb/FTW69D0133.md): Beech A23-19 · Yukon, OK · Accident · No injuries · Closed · Aug 6, 1968 · N3635Q · Substantial damage
- [NTSB FTW68F0577](https://openairdocs.org/ntsb/FTW68F0577.md): Beech A23 · Sasakwa, OK · Accident · Minor injuries · Closed · May 1, 1968 · N4770J · Substantial damage
- [NTSB FTW68F0189](https://openairdocs.org/ntsb/FTW68F0189.md): Beech A23-19 · Temple, OK · Accident · No injuries · Closed · Aug 23, 1967 · N4788J · Substantial damage
- [NTSB FTW67F0619](https://openairdocs.org/ntsb/FTW67F0619.md): Beech A23 · Bethany, OK · Accident · No injuries · Closed · May 19, 1967 · N3635Q · 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" = 'OK' 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 ('1151212'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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