# NTSB investigations: Cessna 310R, 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 NYC99FA047](https://openairdocs.org/ntsb/NYC99FA047.md): Cessna 310R · Kearny, NJ · Accident · 1 fatal · Field investigation · Final report · Jan 11, 1999 · N87365 · Destroyed
  > a loss of elevator control for undetermined reasons.
- [NTSB NYC84LA276](https://openairdocs.org/ntsb/NYC84LA276.md): Cessna 310II · Newark, NJ · Incident · No injuries · Limited investigation · Final report · Aug 15, 1984 · N5338C · No damage
  > An unemployed person was trying to help load an acft. In noticing that a bill of laden had been left off the cargo he ran toward the acft which had, by this time, started engines. The plt said he saw the running man and shoved the mixtures to cut off the…
- [NTSB NYC67F0256](https://openairdocs.org/ntsb/NYC67F0256.md): Cessna 310I · Neptune, NJ · Accident · No injuries · Closed · Aug 19, 1966 · N8016M · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=2074245&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.
