Skip to content

NTSB investigations: Aero Commander CALLAIR A-9

39 cases on aircraft the registry lists as Aero Commander CALLAIR A-9. 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

19652026

Where

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 ('0144202')) 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 ('0144202'))
  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 ('0144202'))
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 ERA18LA087Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander Callair A 9 · Bunn, NCThe glider instructor's delayed remedial action when the glider became out of position during aerotow, which resulted in excessive side-loading of the release hook and a delay in the glider's release from tow, which resulted in the towplane’s descent and…Feb 24, 2018 · N8401V · Substantial damage NTSB GAA17CA371Accident · No injuriesData collectionFinal reportAero Commander Callair A 9 · Morgan, UTThe pilot’s failure to see and avoid transmission wires.Jun 24, 2017 · N7662V · Substantial damage NTSB MIA98FA172Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Ocean Springs, MSan in-flight collision with a nylon rope (wire), resulting in a loss of engine power, an inadvertent stall, and subsequent impact with the ground.Jun 1, 1998 · N7736V · Destroyed NTSB NYC88DFJ04Accident · Serious injuriesFinal reportCallair A-9 · Churchville, NYThe pilot was engaged in aerial application activities. When he started a turn at low altitude to align himself for another spray run the aircraft stalled and struck the terrain.Sep 29, 1988 · N8402V · Substantial damage NTSB MKC88DCA02Accident · Serious injuriesFinal reportCallair A-9A · Rush Hill, MOAbout 25 minutes after sunset, the airplane struck a powerline and pole during a spray run. The airplane struck the ground inverted.Aug 9, 1988 · N7735V · Substantial damage NTSB LAX85FA232Accident · Serious injuriesField investigationFinal reportAero Commander Callair A-9A · Fremont, CAThe 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…Apr 30, 1985 · N7713V · Destroyed NTSB CHI84FA289Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Pullman, MIThe acft crashed while practicing aerial application maneuvers. The plt of the acft had been interrupted at the refueling pump by an acft which was awaiting a chemical reload. The student crop dusting plt, who was also a loader, left the refueling area to…Jul 13, 1984 · N7714V · Destroyed NTSB LAX84FA227Accident · Serious injuriesField investigationFinal reportAero Commander A-98 · Woodbridge, CAThe 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.Mar 23, 1984 · N7643V · Destroyed NTSB ATL83LA382Accident · Minor injuriesLimited investigationFinal reportAero Commander A-9 · Andalusia, ALAfter spraying 2 fields, the plt was en route to spray a 3rd field when a severe vibration of the acft was encountered. He elected to land in the 1st available field & dumped his chemical load. During the landing, the acft hit a terrace & nosed over. The plt…Sep 26, 1983 · N8031V · Substantial damage NTSB FTW83FRG05Accident · 1 fatalFinal reportAero Commander Callair A-9 · Lytton Springs, TXThe acft crashed during a turn-around maneuver while conducting an aerial application mission. The acft had completed about 3 spraying patterns after reloading and was turning steeply to line up for another pass when the nose dropped and the acft descended in…Jun 29, 1983 · N7717V · No damage NTSB ATL83LA227Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9 · Florala, ALThe plt reported that during takeoff, the eng began to lose power at the edge of the arpt. He noted that fuel pressure was lost & reported that he was unable to regain the pressure with the electric fuel pump. He switched the fuel selector to the fullest…Jun 11, 1983 · N7284V · Substantial damage NTSB MIA79DKG62Accident · Minor injuriesClosedCallair A9A · Mcrae, GAAug 14, 1979 · N8412V · Destroyed NTSB MKC78FCJ28Accident · No injuriesClosedCallair A-9 · Loup City, NEJul 13, 1978 · N7227V · Substantial damage NTSB MIA77DKJ78Accident · No injuriesClosedAero Comdr A9 · Berry, ALAug 21, 1977 · N7291V · Substantial damage NTSB IAD77FA060Accident · 1 fatalClosedAero Comdr A-9 · Petersburg, VAAug 13, 1977 · N7739V · Destroyed NTSB MIA77DKG64Accident · No injuriesClosedAero Comdr A-9 · Sylvania, GAAug 12, 1977 · N8032V · Substantial damage NTSB MIA77FKJ63Accident · No injuriesClosedAero Comdr A9 · Samson, ALAug 4, 1977 · N7284V · Substantial damage NTSB NYC77FFJ40Accident · Serious injuriesClosedCallair A-9 · Canandaigua, NYAug 3, 1977 · N7738V · Destroyed NTSB CHI77FET28Accident · Serious injuriesClosedCallair A-9 · Winamac, INJul 28, 1977 · N7734V · Destroyed NTSB CHI76DET11Accident · No injuriesClosedCallair A9 · Kewanna, INAug 28, 1975 · N7734V · Substantial damage NTSB SEA75DYA51Accident · No injuriesClosedCallair A-9 · Glenns Ferry, IDJun 29, 1975 · N3555G · Destroyed NTSB MKC74FCA12Accident · No injuriesClosedAero Comdr A9B · Caruthersville, MOOct 9, 1974 · N7662V · Substantial damage NTSB MIA74DLG37Accident · No injuriesClosedAero Comdr A-9 · Bishopville, SCJun 28, 1974 · N7754V · Destroyed NTSB MIA74DKG82Accident · No injuriesClosedAero Comdr A-9 · Smithville, GAJun 11, 1974 · N8031V · Substantial damage NTSB OAK74DVD41Accident · No injuriesClosedCallair A-9 · Lockeford, CAMay 9, 1974 · N3617G · Destroyed NTSB FTW73FRJ17Accident · 1 fatalClosedAero Comdr A-9 · Garland City, ARSep 13, 1972 · N8029V · Substantial damage NTSB MIA73FLA10Accident · 1 fatalClosedAero Comdr A-9B · Cottondale, FLJul 28, 1972 · N7679V · Destroyed NTSB FTW72FRG93Accident · 1 fatalClosedAero Comdr A-9B · Weslaco, TXJun 7, 1972 · N7675V · Destroyed NTSB MIA72DKQ32Accident · No injuriesClosedCallair A-9 · Avon, MSMar 18, 1972 · N7601V · Substantial damage NTSB NYC72FLJ07Accident · Minor injuriesClosedAero Comdr A9 · Rocky Mount, NCAug 26, 1971 · N7716V · Substantial damage NTSB CHI71FLQ24Accident · No injuriesClosedAero Comdr A-9 · Morganfield, KYMay 15, 1971 · N7712V · Destroyed NTSB OAK71DVA55Accident · Minor injuriesClosedAero Comdr A-9 · Red Top, CAFeb 8, 1971 · N7760V · Destroyed NTSB CHI71DBQ07Accident · No injuriesClosedAero Comdr A-9 · Harrisburg, ILAug 13, 1970 · N8030V · Substantial damage NTSB MIA71FKG11Accident · 1 fatalClosedCallair A-9 · Camilla, GAJul 20, 1970 · N7218V · Destroyed NTSB OAK70I0093Incident · No injuriesClosedAero Comdr A-9 · Dos Palos, CAAug 23, 1969 · N7643V · Minor damage NTSB DIA70F0025Accident · No injuriesClosedCallair A-9 · Parkton, NCJul 12, 1969 · N7227V · Substantial damage NTSB MKC69F0091Accident · No injuriesClosedCallair A-9A · Chapman, NEAug 2, 1968 · N7298V · Substantial damage NTSB FTW68A0020Accident · 1 fatalClosedCallair A-9 · Knobel, ARAug 16, 1967 · N8242H · Destroyed NTSB FTW66D0082Accident · Minor injuriesClosedCallair A-9 · Bayou Metro, ARMay 25, 1965 · N8295H · Destroyed