# NTSB investigations: Beech A23-24, FL

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 ERA11LA112](https://openairdocs.org/ntsb/ERA11LA112.md): Beech A23-24 · Venice, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 12, 2011 · N3670Q · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB MIA89FA078](https://openairdocs.org/ntsb/MIA89FA078.md): Beech A23-24 · Clearwater, FL · Accident · Serious injuries · Field investigation · Final report · Feb 4, 1989 · N3697Q · Destroyed
  > Fuel starvation due to the CFI depleting the fuel supply from one of two tanks and failing to select the fullest tank for landing. Contributing to the accident was the cfi's improper decision to turn back to the airport when insufficient altitude was…
- [NTSB MIA78FA024](https://openairdocs.org/ntsb/MIA78FA024.md): Beech A24 · Alachua, FL · Accident · 4 fatal · Closed · Dec 27, 1977 · N6962Q · Destroyed
- [NTSB MIA76DLA36](https://openairdocs.org/ntsb/MIA76DLA36.md): Beech A23-24 · Chipley, FL · Accident · No injuries · Closed · Feb 17, 1976 · N3685Q · Substantial damage
- [NTSB MIA76DLD26](https://openairdocs.org/ntsb/MIA76DLD26.md): Beech A23-24 · Vero Beach, FL · Accident · No injuries · Closed · Oct 21, 1975 · N6953Q · Substantial damage
- [NTSB MIA75AM075](https://openairdocs.org/ntsb/MIA75AM075.md): Beech A23-24 · Sarasota, FL · Accident · 2 fatal · Closed · Apr 25, 1975 · N5776V · Destroyed
- [NTSB MIA73FKT09](https://openairdocs.org/ntsb/MIA73FKT09.md): Beech A23-24 · Sanibel, FL · Accident · No injuries · Closed · Jul 30, 1972 · N4739J · Substantial damage
- [NTSB MIA70F0260](https://openairdocs.org/ntsb/MIA70F0260.md): Beech A23 · Opa Locka, FL · Accident · No injuries · Closed · Dec 27, 1969 · N3647Q · 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" = 'FL' 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 ('1151226'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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