# NTSB investigations: Beech C24R: In flight encounter with weather

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 NYC02FA142](https://openairdocs.org/ntsb/NYC02FA142.md): Beech C24R · Grindstone, PA · Accident · 2 fatal · Field investigation · Final report · Jul 18, 2002 · N18860 · Destroyed
  > The pilot's inadequate in-flight planning/decision resulting in flight into adverse weather, and his failure to maintain aircraft control resulting in overstress of aircraft. A factor was the thunderstorm activity.
- [NTSB NYC96LA071](https://openairdocs.org/ntsb/NYC96LA071.md): Beech C24R · Philadelphia, PA · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 1996 · N6625P · Destroyed
  > the pilot's improper planning/decision, and his resultant flight into known icing conditions, which resulted in ice accumulation, loss of engine power, a forced landing, and subsequent collision with a residence and a vehicle. A factor relating to the…
- [NTSB CHI90FA055](https://openairdocs.org/ntsb/CHI90FA055.md): Beech A24R · Merrill, WI · Accident · 3 fatal · Field investigation · Final report · Dec 28, 1989 · N37329 · Destroyed
  > Flight into known adverse weather by the pilot, and structural/wing ice. Factors related to the accident were: the icing conditions and trees in the area of the accident.
- [NTSB LAX85LA057](https://openairdocs.org/ntsb/LAX85LA057.md): Beech C24R · Rialto, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 3, 1984 · N60102 · Destroyed
  > At about 0730 PST, witnesses near the lytle creek ranger station, located northwest of Rialto, CA, heard an acft circling low in the area, then heard the sound of impact nearby. The wx at the time was described as overcast with zero visibility in fog & light…

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

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

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