# NTSB investigations: Beech A24R: Loss of control - on ground/water

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 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 LAX89LA072](https://openairdocs.org/ntsb/LAX89LA072.md): Beech A24R · Grass Valley, CA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1988 · N8018R · Substantial damage
  > At the end of a cross country flight, during the landing roll, the airplane began to slide to the left. The pilot was unable to regain control due to the patchy snow and ice on the runway. The airplane exited the runway and collided with a snow bank. There…

## 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 ('1151252')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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