NTSB investigations: Aero Commander CALLAIR A-9B, MO

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19712026

NTSB investigations: Aero Commander CALLAIR A-9B, MO per year, 1971–2026: 9 cases
1971	2
1975	1
1979	1
1980	2
1987	1
1994	1
2026	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."eventStateOrRegion" = 'MO' 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

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\" = 'MO' 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" = 'MO' 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

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 CEN26LA269Accident · No injuriesClass 3 · LimitedPreliminary reportAero Commander Callair A-9B · Livonia, MOOn July 27, 2026, about 0819 central daylight time, an Aero Commander Callair A-9B airplane, N7799V, was substantially damaged when it was involved in an accident near Livonia, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code…Jul 27, 2026 · N7799V · Substantial damage NTSB CHI94DCG02Accident · 1 fatalFinal reportAero Commander Calair A-9B · Excelsior Sprgs, MOThe pilot's failure to maintain altitude clearance above the powerlines during his maintenance test application run.Jul 5, 1994 · N7965V · Destroyed NTSB MKC87LA152Accident · No injuriesLimited investigationFinal reportAero Commander Callair A9-B · Osgood, MODuring an aerial application operation, pilot experienced partial power loss and vibration, followed by a loud explosive sound and total loss of power. An emergency ldg was made followed by a nose over. Postaccident inspection revealed the entire propeller…Jul 31, 1987 · N7726V · Substantial damage NTSB MKC80FCG31Accident · Minor injuriesClosedAero Comdr A-9B · Cameron, MOJun 28, 1980 · N8025V · Substantial damage NTSB MKC80DCG21Accident · No injuriesClosedAero Comndr A9B · Savannah, MOApr 25, 1980 · N7746V · Substantial damage NTSB MKC79DCG32Accident · No injuriesClosedCallair A9-B · Deerfield, MOFeb 27, 1979 · N671W · Substantial damage NTSB MKC75FCG40Accident · Minor injuriesClosedAero Comdr A-9B · Brunswick, MOApr 29, 1975 · N7658V · Destroyed NTSB MKC72FCA10Accident · No injuriesClosedAero Comdr A-9B · Clarkton, MOOct 2, 1971 · N7761V · Substantial damage NTSB MKC72DCA03Accident · No injuriesClosedAero Comdr A9B · Fulton, MOAug 7, 1971 · N7706V · Substantial damage