# NTSB investigations: Cessna 210D, LA

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 FTW89FA172](https://openairdocs.org/ntsb/FTW89FA172.md): Cessna 210D · Covington, LA · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1989 · N3962Y · Destroyed
  > The pilot in command's disregard of the weather information provided during two briefings and his decision to continue VFR flight into IMC condtions. Factors contributing to the accident were the pilot's lack of night and instrument experience.
- [NTSB FTW88LA111](https://openairdocs.org/ntsb/FTW88LA111.md): Cessna 210D · New Roads, LA · Accident · No injuries · Limited investigation · Final report · May 29, 1988 · N3799Y · Destroyed
  > The airplane had not had an annual inspection and had not been flown for over a year. The pilot stated he found no contamination during the draining of the fuel sumps. Shortly after takeoff, the engine started sputtering and eventually stopped. During the…
- [NTSB FTW69D0425](https://openairdocs.org/ntsb/FTW69D0425.md): Cessna 210D · Patterson, LA · Accident · Minor injuries · Closed · Mar 21, 1969 · N3808Y · Destroyed
- [NTSB FTW68D0274](https://openairdocs.org/ntsb/FTW68D0274.md): Cessna 210 · Kenner, LA · Accident · No injuries · Closed · Sep 18, 1967 · N3808Y · Substantial damage
- [NTSB FTW66F0379](https://openairdocs.org/ntsb/FTW66F0379.md): Cessna 210D · New Orleans, LA · Accident · No injuries · Closed · Nov 13, 1965 · N3926Y · 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" = 'LA' 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=LA

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