# NTSB investigations: Callair A-6

A list on [Callair A-6](https://openairdocs.org/model/callair-a-6.md).

Matched to the registry by N-number and event date, newest first.

- [NTSB DEN77FTM29](https://openairdocs.org/ntsb/DEN77FTM29.md): Callair A-6 · Cedar City, UT · Accident · Serious injuries · Closed · Sep 12, 1977 · N2958G · Destroyed
- [NTSB FTW74DPG77](https://openairdocs.org/ntsb/FTW74DPG77.md): Callair A-6 · Sparkman, AR · Accident · Minor injuries · Closed · Jun 27, 1974 · N2933G · Substantial damage
- [NTSB OAK74FVA56](https://openairdocs.org/ntsb/OAK74FVA56.md): Callair A-6 · Kerman, CA · Accident · No injuries · Closed · Apr 7, 1974 · N2927G · Substantial damage
- [NTSB FTW72FPA08](https://openairdocs.org/ntsb/FTW72FPA08.md): Callair A-6 · Donie, TX · Accident · 1 fatal · Closed · Oct 24, 1971 · N2915G · Destroyed
- [NTSB SEA71DYG59](https://openairdocs.org/ntsb/SEA71DYG59.md): Callair A-6 · Waterville, WA · Accident · No injuries · Closed · Jun 16, 1971 · N2934G · Substantial damage
- [NTSB MKC71DCG62](https://openairdocs.org/ntsb/MKC71DCG62.md): Callair A-6 · Tonganoxie, KS · Accident · No injuries · Closed · May 3, 1971 · N2910G · Substantial damage
- [NTSB MKC70D0124](https://openairdocs.org/ntsb/MKC70D0124.md): Callair A-9 · Plains, KS · Accident · No injuries · Closed · Aug 7, 1969 · N2916G · Substantial damage
- [NTSB MKC70D0007](https://openairdocs.org/ntsb/MKC70D0007.md): Callair A-6 · Bassett, NE · Accident · No injuries · Closed · May 27, 1969 · N2909G · Substantial damage
- [NTSB FTW69F0489](https://openairdocs.org/ntsb/FTW69F0489.md): Callair A-6 · Hope, AR · Accident · 1 fatal · Closed · Apr 25, 1969 · N7597C · Destroyed
- [NTSB MKC69F0101](https://openairdocs.org/ntsb/MKC69F0101.md): Callair A-6 · Weston, NE · Accident · Minor injuries · Closed · Aug 1, 1968 · N2910G · Substantial damage
- [NTSB SEA67D0347](https://openairdocs.org/ntsb/SEA67D0347.md): Callair A-6 · Outlook, WA · Accident · Minor injuries · Closed · May 18, 1967 · N2918G · Destroyed
- [NTSB MIA67F0083](https://openairdocs.org/ntsb/MIA67F0083.md): Callair A-6 · Baconton, GA · Accident · No injuries · Closed · Jul 23, 1966 · N2930G · Destroyed
- [NTSB CHI66F0131](https://openairdocs.org/ntsb/CHI66F0131.md): Callair A-6 · Amboy, IL · Accident · No injuries · Closed · Jul 22, 1965 · N9989C · Substantial damage
- [NTSB MKC66F0053](https://openairdocs.org/ntsb/MKC66F0053.md): Callair A-6 · Humbolt, NE · Accident · No injuries · Closed · Jun 14, 1965 · N2926G · Substantial damage
- [NTSB SEA66F0062](https://openairdocs.org/ntsb/SEA66F0062.md): Callair A-6 · Lakeview, OR · Accident · No injuries · Closed · Jun 13, 1965 · N2907G · Substantial damage
- [NTSB UNK64X2080](https://openairdocs.org/ntsb/UNK64X2080.md): Callair A6 · Waterville, WA · Accident · No injuries · Closed · Jun 3, 1964 · N2934G · Destroyed

## 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('1850114')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/model/callair-a-6/ntsb

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