NTSB investigations: Aero Commander CALLAIR A-9B, CA
24 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.
Cases per year
| 1968 | 2 |
|---|---|
| 1969 | 6 |
| 1970 | 3 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 1 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 2 |
| 1986 | 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.\"eventStateOrRegion\" = 'CA' 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" = 'CA' 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" 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 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 LAX79FVG70Accident · 1 fatalClosedAero Comndr A-9B · Burney, CANTSB LAX79DUG20Accident · Serious injuriesClosedAero Comdr A-9B · Hemet, CANTSB OAK78FVD52Accident · No injuriesClosedRockwell A-9B · Stockton, CANTSB LAX78QUM05Accident · Minor injuriesClosedCallair A9 · Calexico, CANTSB OAK77FVD43Accident · 1 fatalClosedCallair A-9B · Stockton, CANTSB LAX76FUM31Accident · 1 fatalClosedAero Comdr A-9B · Imperial, CANTSB LAX74FUM22Accident · No injuriesClosedCallair A-9B · Calexico, CANTSB LAX73DUG35Accident · No injuriesClosedAero Comdr A-9B · Sunnymead, CANTSB OAK73FVG08Accident · Minor injuriesClosedAero Comdr A-9B · Colusa, CANTSB OAK73FVA01Accident · Serious injuriesClosedAero Comdr A-9B · Five Points, CANTSB OAK72FVG28Accident · No injuriesClosedAero Comdr A-9B · Elmira, CANTSB OAK71DVA65Accident · No injuriesClosedAero Comdr A-9B · Lanare, CANTSB OAK71DVA34Accident · Minor injuriesClosedAero Comdr A-9B · Dos Palos, CANTSB OAK71DVA21Accident · No injuriesClosedCallair A-9 · Kettleman Cty, CANTSB LAX70FUQ19Accident · Minor injuriesClosedAero Comdr A-9B · Filmore, CANTSB OAK70D0082Accident · No injuriesClosedCallair A-9B · Dixon, CANTSB OAK70D0052Accident · No injuriesClosedAerocomdr A-9B · Tranquility, CANTSB OAK69D0305Accident · No injuriesClosedCallair A-9B · Pleasnt Grove, CANTSB LAX69D0334Accident · No injuriesClosedAero Comdr A-9B · Buttonwillow, CANTSB OAK69D0240Accident · Minor injuriesClosedAero Comdr A-9B · Selma, CANTSB OAK69D0257Accident · No injuriesClosedAero Comdr A-9B · Dixon, CANTSB OAK69D0117Accident · No injuriesClosedAero Comdr A-9B · Patterson, CANTSB OAK69D0072Accident · No injuriesClosedCallair A-9 · Coalinga, CA