NTSB investigations: Aero Commander CALLAIR A-9B, FL

12 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19702026

NTSB investigations: Aero Commander CALLAIR A-9B, FL per year, 1970–2026: 12 cases
1970	3
1971	2
1972	3
1973	1
1974	1
1980	1
1988	1

Where

Open the map

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."eventStateOrRegion" = 'FL' 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

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\" = 'FL' 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" = 'FL' 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

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 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…May 25, 1988 · N7787V · Substantial damage NTSB MIA80FLD74Accident · No injuriesClosedAero Comndr A-9B · Minneola, FLJun 18, 1980 · N7785V · Destroyed NTSB MIA75FLD25Accident · 1 fatalClosedAero Cmdr A-9B · Bartow, FLOct 26, 1974 · N8026V · Destroyed NTSB MIA73DLA36Accident · No injuriesClosedAero Comdr A-9B · Greensboro, FLMay 9, 1973 · N7919V · Substantial damage NTSB MIA73FLD08Accident · Serious injuriesClosedAero Comdr A-9B · Minneola, FLAug 20, 1972 · N7708V · Substantial damage NTSB MIA72FLD73Accident · Serious injuriesClosedCallair A-9B · Sebring, FLJun 16, 1972 · N7743V · Substantial damage NTSB MIA72DKT57Accident · Minor injuriesClosedAero Comdr A-9B · Labelle, FLFeb 23, 1972 · N7920V · Substantial damage NTSB MIA71FLD50Accident · No injuriesClosedAerocomdr A-9B · Sun City, FLMar 15, 1971 · N7616V · Substantial damage NTSB MIA71FKT50Accident · 1 fatalClosedAero Cmdr A-9B · Belle Glade, FLMar 5, 1971 · N7699V · Destroyed NTSB MIA71FLD14Accident · Minor injuriesClosedAero Comdr A-9B · Ruskin, FLSep 4, 1970 · N7751V · Destroyed NTSB MIA70DLA27Accident · No injuriesClosedAero Comdr A-9B · Altha, FLJun 27, 1970 · N8023V · Substantial damage NTSB MIA70FKT20Accident · No injuriesClosedAero Comdr A9B · Labelle, FLMay 19, 1970 · N7743V · Substantial damage