# NTSB investigations: Beech A24R, MS

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 ATL01LA013](https://openairdocs.org/ntsb/ATL01LA013.md): Beech BE-23-A24R · Jackson, MS · Accident · No injuries · Limited investigation · Final report · Nov 23, 2000 · N8060R · Substantial damage
  > Deer on the runway, which forced the pilot to make an evasive maneuver forcing him to the side of the runway and striking the marker lights.
- [NTSB MIA99LA083](https://openairdocs.org/ntsb/MIA99LA083.md): Beech A24R · Philadelphia, MS · Accident · No injuries · Limited investigation · Final report · Feb 13, 1999 · N24624 · Substantial damage
  > The failure of the pilot to ensure the aircraft tie down ropes were free from the aircraft prior to taxiing. This resulted in the aircraft turning uncontrolled when taxi was initiated due to a partially tied left wing, the pilot loosing control of the…
- [NTSB MIA89LA168](https://openairdocs.org/ntsb/MIA89LA168.md): Beech A24R · Gulfport, MS · Accident · No injuries · Limited investigation · Final report · Jun 4, 1989 · N9700Q · Substantial damage
  > Failure of a #2 connecting rod assembly, which resulted in separation of the #2 cylinder and subsequent loss of engine power. Contributing factors were: inadequate maintenance, the transmission (power) line, and trees.

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

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

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