# NTSB investigations: Cessna 210J, FL

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 ERA13LA398](https://openairdocs.org/ntsb/ERA13LA398.md): Cessna 210J · Fort Myers, FL · Accident · No injuries · Limited investigation · Final report · Sep 5, 2013 · N210WS · Substantial damage
  > The failure of the landing gear hydraulic power pack system to provide sufficient pressure to lock the main landing gear in the down position. Contributing to the accident was the improper maintenance and inspection of the landing gear system, the pilot’s…
- [NTSB MIA99FA075](https://openairdocs.org/ntsb/MIA99FA075.md): Cessna 210J · Naples, FL · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1999 · N6174F · Destroyed
  > In-flight collision with water while on base turn to final at night for undetermined reasons.
- [NTSB MIA86LA092](https://openairdocs.org/ntsb/MIA86LA092.md): Cessna 210J · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Mar 7, 1986 · N77WG · Substantial damage
  > The plt stated that while taxiing to the ramp, after landing, he taxied through construction barricades & ran off the taxiway. While attempting to get back on the taxiway, the nose gear got caught in a hole & collapsed.

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

This list as a web page: https://openairdocs.org/ntsb?model=2073439&state=FL

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