# NTSB investigations: Cessna 210D, 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 GAA18CA115](https://openairdocs.org/ntsb/GAA18CA115.md): Cessna 210 · Sussex, NJ · Accident · No injuries · Data collection · Final report · Jan 21, 2018 · N884KM · Destroyed
  > The pilot’s inadvertent landing gear retraction during approach.
- [NTSB NYC83LA081](https://openairdocs.org/ntsb/NYC83LA081.md): Cessna 210D · Farmingdale, NJ · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1983 · N3727Y · Substantial damage
  > While taxiing to rwy 32 the plt attempted to stop after completion of a turn, but the brakes would not stop the acft. The plt used right rudder to avoid parked acft but was unable to maintain directional control. The acft went down an embankment, nosed over &…
- [NTSB NYC83LA025](https://openairdocs.org/ntsb/NYC83LA025.md): Cessna 210D · Morristown, NJ · Accident · No injuries · Limited investigation · Final report · Nov 11, 1982 · N3974Y · Substantial damage
  > Pilot was flying with a mechanic to check avionics. Tower called to warn of helicopters. Mechanic asked him to change from right to left traffic. Pilot said the corrections disrupted his senses and he forgot to lower the landing gear.

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

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