# NTSB investigations: Beech C24R, NH

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 NYC84LA246](https://openairdocs.org/ntsb/NYC84LA246.md): Beech C24R · Newmarket, NH · Accident · No injuries · Limited investigation · Final report · Jul 16, 1984 · N1857G · Substantial damage
  > Plt reported loss of power in flight and executed a forced landing in a wooded area. Reason for the power loss was not determined.
- [NTSB NYC82DA043](https://openairdocs.org/ntsb/NYC82DA043.md): Beech C-24R · Manchester, NH · Accident · No injuries · Final report · Mar 5, 1982 · N6135S · Substantial damage
  > The tower controller advised the flight while on base leg that the winds were from 300 degrees at 15 knots. This information was given at 1045 EST and was the last wind information given to the pilot before landing. According to the pilot moderate turbulence…

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

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