NTSB investigations: Aero Commander CALLAIR A-9B
6 cases on aircraft the registry lists as Aero Commander CALLAIR A-9B, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 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.\"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\" = 351))
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" = 351))
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 MKC89LA080Accident · No injuriesLimited investigationFinal reportCallair A9-B · Fisher, ARFailure of the engine magneto resulting in engine failure.NTSB MIA88FA178Accident · Serious injuriesField investigationFinal reportRockwell A9B · Marianna, FLThe acft sustained a complete & sudden power loss while engaged in ag operations at low alt. The prop, fwd portion of the crankshaft, cyl head & other eng parts separated from the acft. The acft struck a row of 40 ft trees & crashed to the grnd. An exam of…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…NTSB LAX86FVD06Accident · Minor injuriesFinal reportCallair A-9B · Lodi, CAPilot was returning to Lodi airport after aerial application when the engine lost oil pressure. The engine seized, and a forced landing was made in a vineyard.NTSB DEN82FTK04Accident · No injuriesFinal reportCallair A-9B · Sioux Falls, SDThe eng quit & the plt landed in an adjacent field after first hitting a wooded fence. An inspectin of the bendix fuel servo unit, model PSA-10ED-1, revealed that the fuel diaphragm stem, pn 2539806, had failed.