# NTSB investigations: Beech C24R, NJ

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 NYC97LA133](https://openairdocs.org/ntsb/NYC97LA133.md): Beech C24R · Old Bridge, NJ · Accident · No injuries · Limited investigation · Final report · Jul 1, 1997 · N5156M · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB NYC82FA199](https://openairdocs.org/ntsb/NYC82FA199.md): Beech C24R · Trenton, NJ · Accident · 3 fatal · Field investigation · Final report · Aug 15, 1982 · N18958 · Destroyed
  > During an approach to the mercer county airport at Trenton, n.j., the aircraft lost power and landed off airport in trees. The fuel selector was found positioned between left tank and off. The pilot attempted to fly to the runway, but unable. The aircraft…

## 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" = 'NJ' 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=NJ

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