NTSB investigations: Aero Commander CALLAIR A-9B, ID
10 cases on aircraft the registry lists as Aero Commander CALLAIR A-9B. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1970 | 1 |
|---|---|
| 1971 | 1 |
| 1974 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1997 | 1 |
| 2003 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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\" = 'ID' 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 ('0144206'))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" = 'ID' 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 ('0144206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA03FA179Accident · No injuriesField investigationFinal reportAero Commander Callair A-9B · Driggs, IDA loss of engine power due to the improper installation of a counterweight roller pin retaining washer circlip, leading to the circlip coming out of its groove and the counterweight roller pin coming in contact with two of the engines connecting rods.…NTSB SEA97LA137Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Saint Anthony, IDthe pilot's improper planning/decision and failure to dump the load of chemicals. Related factors were: the high density altitude, and a dirt embankment that was encountered during the landing roll.NTSB SEA88LA081Accident · 1 fatalLimited investigationFinal reportRockwell A-9B · Grace, IDPlt/owner not certificated for aerial application. No record found of prior experience in aerial application. Replaced certificated plt for undet reason. Witnesses observed acft enter stall/spin during first aerial application turnaround maneuver in strong…NTSB SEA83LA105Accident · No injuriesLimited investigationFinal reportCallair A-9B · Winear, IDThe acft collided with a fence during an off airport forced landing. The pilot was completing an aerial application pass & when the low fuel warning light came on the pilot switched tanks & turned on fuel booster. The engine quit at about 200 feet AGL.…NTSB SEA78DYA13Accident · Minor injuriesClosedAero Comdr A-9B · Rigby, IDNTSB SEA77DYA30Accident · No injuriesClosedCallair A9B · Rigby, IDNTSB SEA74FYA39Accident · No injuriesClosedAero Comdr A-9B · Newdale, IDNTSB SEA74DYA42Accident · No injuriesClosedCallair A-9B · Idaho Falls, IDNTSB SEA71DYA37Accident · No injuriesClosedCallair A-9B · Albion, IDNTSB SEA70DXM15Accident · No injuriesClosedAero Comdr A-9B · Rupert, ID