# NTSB investigations: Aero Commander 200D, CA

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 WPR24FA290](https://openairdocs.org/ntsb/WPR24FA290.md): Aero Commander 200D · Novato, CA · Accident · 1 fatal · Class 3 · Field · Final report · Aug 31, 2024 · N2912T · Substantial damage
  > The pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.
- [NTSB LAX98LA040](https://openairdocs.org/ntsb/LAX98LA040.md): Aero Commander 200D · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · Nov 18, 1997 · N2910T · Substantial damage
  > The pilot's failure to verify that there was an adequate supply of fuel in the selected fuel tank prior to takeoff.
- [NTSB LAX95LA070](https://openairdocs.org/ntsb/LAX95LA070.md): Aero Commander 200D · Lancaster, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 2, 1995 · N200AW · Substantial damage
  > fuel starvation due to the pilot's failure to select a tank containing fuel.
- [NTSB LAX88LA090](https://openairdocs.org/ntsb/LAX88LA090.md): Aero Commander 200D · Chico, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 1988 · N2977T · Substantial damage
  > At the end of a cross country flt, while in the pattern turning from base to final, the plt stated that the arpt environment was lost. At the same time, the instrument white lights, under the glareshield began to flicker which drowned out the normal…
- [NTSB OAK69D0078](https://openairdocs.org/ntsb/OAK69D0078.md): Aero Comdr 200D · Butte Meadows, CA · Accident · No injuries · Closed · Jul 21, 1968 · N2914T · Substantial damage
- [NTSB OAK68A0020](https://openairdocs.org/ntsb/OAK68A0020.md): Aero Comdr 200 · Davis, CA · Accident · No injuries · Closed · Aug 23, 1967 · N2981T · 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" = 'CA' 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 ('0140312'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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