NTSB investigations: Aero Commander CALLAIR A-9B, 1969
18 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
| 1967 | 3 |
|---|---|
| 1968 | 10 |
| 1969 | 18 |
| 1970 | 20 |
| 1971 | 22 |
| 1972 | 19 |
| 1973 | 16 |
| 1974 | 17 |
| 1975 | 7 |
| 1976 | 6 |
| 1977 | 9 |
| 1978 | 7 |
| 1979 | 5 |
| 1980 | 5 |
| 1981 | 4 |
| 1982 | 3 |
| 1983 | 3 |
| 1984 | 2 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1992 | 2 |
| 1994 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2024 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1969
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 year(c."eventDate") = 1969
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 MIA70D0302Accident · No injuriesClosedAero Comdr A-9B · Colquitt, GANTSB MIA70F0223Accident · No injuriesClosedAero Comdr A-9B · Waynesboro, GANTSB OAK70D0082Accident · No injuriesClosedCallair A-9B · Dixon, CANTSB MIA70D0299Accident · Minor injuriesClosedAero Comdr A-9B · Gough, GANTSB MKC70F0160Accident · No injuriesClosedCallair A-9B · Phillips, NENTSB MIA70F0271Accident · No injuriesClosedAero Comdr A9-B · Smithville, GANTSB OAK70D0052Accident · No injuriesClosedAerocomdr A-9B · Tranquility, CANTSB MKC70F0071Accident · Minor injuriesClosedAero Comdr A-9B · Colome, SDNTSB MIA70F0213Accident · Minor injuriesClosedAero Comdr A-9B · Smithville, GANTSB MIA70D0178Accident · No injuriesClosedAero Comdr A-9 · Americus, GANTSB MKC70F0106Accident · No injuriesClosedAero Comdr A-9B · Mtn Lake, MNNTSB MKC69F0469Accident · Serious injuriesClosedCallair A-9B · Miller, SDNTSB MIA70F0092Accident · No injuriesClosedAero Comdr A-9B · Smithville, GANTSB MIA69F0492Accident · No injuriesClosedAero Comdr A-9B · Holly Bluff, MSNTSB 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, CA