# NTSB investigations: Beech C24R: In flight collision with object

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 SEA03CA178](https://openairdocs.org/ntsb/SEA03CA178.md): Beech C24R · Bend, OR · Accident · No injuries · Data collection · Final report · Aug 26, 2003 · N6536C · Substantial damage
  > The first pilot's premature liftoff and his failure to abort the takeoff. Factors include a fence and a ditch bank located upwind of the runway.
- [NTSB DEN03LA004](https://openairdocs.org/ntsb/DEN03LA004.md): Beech C24R · Newcastle, UT · Accident · No injuries · Limited investigation · Final report · Oct 9, 2002 · N18917 · Substantial damage
  > the pilot's failure to maintain clearance from the tree during takeoff. A factor was the reduced light conditions.
- [NTSB FTW93FA061](https://openairdocs.org/ntsb/FTW93FA061.md): Beech C24R · Tulsa, OK · Accident · 3 fatal · Field investigation · Final report · Dec 29, 1992 · N3809Q · Destroyed
  > The pilot's disregard of and descent below the published decision height. Factors were his failure to maintain proper glide path and localizer alignment.
- [NTSB BFO87LA036](https://openairdocs.org/ntsb/BFO87LA036.md): Beech C-24R · Chestertown, MD · Accident · No injuries · Limited investigation · Final report · May 12, 1987 · N18880 · Substantial damage
  > The pilot, unfamiliar with the airport, intended to perform a trial takeoff run to determine how the aircraft accelerated on the grass runway. During the trial run when the aircraft was about half way down the runway, the pilot felt the aircraft was ready to…

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

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

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