# NTSB investigations: Aero Commander CALLAIR A-9, 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 LAX85FA232](https://openairdocs.org/ntsb/LAX85FA232.md): Aero Commander Callair A-9A · Fremont, CA · Accident · Serious injuries · Field investigation · Final report · Apr 30, 1985 · N7713V · Destroyed
  > The purpose of the local flight was to tow a glider aloft to a launch point. The pilot said he had no memory of the accident flight. Witnesses saw the aircraft make a go around form short final as a pedestrian walked across the runway approach end, and then…
- [NTSB LAX84FA227](https://openairdocs.org/ntsb/LAX84FA227.md): Aero Commander A-98 · Woodbridge, CA · Accident · Serious injuries · Field investigation · Final report · Mar 23, 1984 · N7643V · Destroyed
  > The plt said the acft stalled as he was performing a left climbing turn during aerial application. The acft spun down hitting some oak tree limbs on its way to the ground. The plt had applied all but 200 lbs of his 1450 pounds of ammoniumsulfate.
- [NTSB OAK74DVD41](https://openairdocs.org/ntsb/OAK74DVD41.md): Callair A-9 · Lockeford, CA · Accident · No injuries · Closed · May 9, 1974 · N3617G · Destroyed
- [NTSB OAK71DVA55](https://openairdocs.org/ntsb/OAK71DVA55.md): Aero Comdr A-9 · Red Top, CA · Accident · Minor injuries · Closed · Feb 8, 1971 · N7760V · Destroyed
- [NTSB OAK70I0093](https://openairdocs.org/ntsb/OAK70I0093.md): Aero Comdr A-9 · Dos Palos, CA · Incident · No injuries · Closed · Aug 23, 1969 · N7643V · Minor 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 ('0144202'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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