NTSB investigations: Aero Commander CALLAIR A-9B
4 cases on aircraft the registry lists as Aero Commander CALLAIR A-9B, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 1 |
|---|---|
| 1986 | 1 |
| 1992 | 1 |
| 1997 | 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\" = 353))
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" = 353))
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 FTW97LA232Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Indio, TXthe pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…NTSB CHI92DTG02Accident · Minor injuriesFinal reportCallair A9B · Bisbee, NDThe loss of engine power due to fuel starvation resulting from the pilot's inadequate preflight inspection.NTSB ATL86LA216Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · Ridgeland, SCThe pilot was performing a test flight to test a new spray pump which was recently installed on the aircraft. Following a low pass over the runway the pilot heard a grinding noise from the left side of the aircraft. Shortly thereafter the aircraft lost total…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.…