# NTSB investigations: Beech C24R, GA

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 ERA16FA075](https://openairdocs.org/ntsb/ERA16FA075.md): Beech C24R · Winder, GA · Accident · 1 fatal · Field investigation · Final report · Dec 20, 2015 · N2074P · Destroyed
  > A total loss of engine power for reasons that could not be determined because the examination of the wreckage did not reveal any mechanical anomalies that would have precluded normal operation.
- [NTSB ATL83LA143](https://openairdocs.org/ntsb/ATL83LA143.md): Beech C24R · Waycross, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 1983 · N6009A · Destroyed
  > During flt, the plt encountered strong headwinds & decided to divert to Waycross, GA. While using fuel from the right tank, the engine quit due to fuel starvation. The plt stated that this surprised him since the right fuel gauge needle was only slightly…
- [NTSB MIA77FA050](https://openairdocs.org/ntsb/MIA77FA050.md): Beech C24R · Monroe, GA · Accident · 2 fatal · Closed · Apr 3, 1977 · N23969 · Destroyed

## 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" = 'GA' 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 ('1151254'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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