# NTSB investigations: Cessna 210E, MD

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 NYC84FA178](https://openairdocs.org/ntsb/NYC84FA178.md): Cessna 210E · Glen Burnie, MD · Accident · 1 fatal · Field investigation · Final report · May 21, 1984 · N432MD · Destroyed
  > Before the flt, the plt was observed performing maintenance in the eng compartment. He was known to do some of his own maintenance which included stopping an oil gasket leak by using a sealer. While climbing after takeoff, he turned back to the departure…
- [NTSB NYC67F0315](https://openairdocs.org/ntsb/NYC67F0315.md): Cessna 210E · Newburg, MD · Accident · No injuries · Closed · Oct 16, 1966 · N4974U · 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" = 'MD' 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 ('2073416'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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