NTSB investigations: Aero Commander CALLAIR A-9B

7 cases on aircraft the registry lists as Aero Commander CALLAIR A-9B, where the first occurrence was “Loss of control - in flight”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Aero Commander CALLAIR A-9B per year, 1982–2026: 7 cases
1982	1
1983	1
1984	1
1988	1
1990	2
2002	1

Where

Open the map

Latest cases

Query with 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0144206') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0144206')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0144206')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 FTW02LA236Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Paso, TXThe pilot's inadequate recovery from a bounced landing, and his failure to maintain directional control. Contributing factors were the cross wind, and the pilot's lack of experience in the make and model of the accident airplane.Aug 10, 2002 · N7718V · Substantial damage NTSB CHI90DCJ02Accident · 1 fatalFinal reportAero Commander Calair A9B · Ord, NEThe pilot's failure to maintain aircraft control during low altitude maneuvering.Sep 8, 1990 · N7691V · Destroyed NTSB DEN90LA102Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Montrose, COInadequate compensation for wind conditions by the pilot. The adverse wind conditions were related factors.Apr 28, 1990 · N7620V · Substantial damage 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…Apr 19, 1988 · N7657V · Destroyed NTSB FTW84LA192Accident · No injuriesLimited investigationFinal reportRockwell A-9B · Lamont, OKThe plt reported that between swath runs, his attention was directed to swath marks on the ground, then he tried to determine how much chemical was remaining in the hopper. At about 100 ft AGL, while in a 50 deg left bank, he heard 'the eng slow down' & felt…Apr 6, 1984 · N7776V · Substantial damage NTSB DEN83LA153Accident · Minor injuriesLimited investigationFinal reportAero Commander Callair A-9B · Rolla, NDDuring a procedure turn-around after the second pass, the acft entered a stall, the left wing dropped & the plane impacted, left wing first, while in a nose down attitude. No preimpact, mechanical malfunction or failure was reported.Jun 25, 1983 · N7642V · Destroyed NTSB DEN82DA108Accident · No injuriesFinal reportCallair A-9B · Rolla, NDThe pilot reported that after loading with chemical, water, and fuel, he went to a field and began spraying. He stated that after he had made his first swath run, he was turning for a second swath when the plane stalled and crashed. The landing gear,…Jun 20, 1982 · N7634V · Substantial damage