NTSB investigations: Intermountain CALLAIR A-9, CA

11 cases on aircraft the registry lists as Intermountain CALLAIR A-9. 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

19692026

NTSB investigations: Intermountain CALLAIR A-9, CA per year, 1969–2026: 11 cases
1969	1
1971	2
1973	1
1974	1
1977	1
1978	1
1979	1
1987	1
1994	1
1998	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" = '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 ('4570620')) 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\" = '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 ('4570620'))
  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 ('4570620'))
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 LAX98LA131Accident · No injuriesLimited investigationFinal reportCallair A-9 · Thermal, CAThe failure of the oil pump drive shaft due to the installation of an incorrect oil pump crankshaft gear by maintenance personnel at the last overhaul.Mar 18, 1998 · N7211V · Substantial damage NTSB LAX95LA055Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Hemet, CAThe other aircraft pilot's inadequate bounced landing recovery and his failure to maintain directional control.Dec 20, 1994 · N1217B · 2 aircraft · Substantial damage NTSB LAX87LA079Accident · No injuriesLimited investigationFinal reportIntermountain Mfg. Callair A-9 · Fremont, CADuring a towing operation, just after lift-off the aircraft lost engine power at approximately 75 feet AGL. The glider released and landed without incident. The aircraft continued straight ahead, ran into a fence and came to rest in a plowed field. The fuel…Jan 10, 1987 · N7232V · Substantial damage NTSB LAX79FVA51Accident · 1 fatalClosedCallair A-9 · Shafter, CAJul 19, 1979 · N7224V · Destroyed NTSB OAK78DVD41Accident · No injuriesClosedCallair A-9 · Lodi, CAJun 7, 1978 · N7232V · Substantial damage NTSB OAK77FVD24Accident · Minor injuriesClosedCallair A-9 · Lodi, CAMar 23, 1977 · N7249V · Destroyed NTSB LAX74DVA59Accident · No injuriesClosedCallair A-9 · Earlimart, CAApr 26, 1974 · N7224V · Substantial damage NTSB OAK73FVD35Accident · Minor injuriesClosedCallair A-9 · Clements, CAMay 11, 1973 · N7232V · Destroyed NTSB LAX72DVA03Accident · Minor injuriesClosedCallair A-9 · Shafter, CAJul 17, 1971 · N7215V · Substantial damage NTSB LAX71DUG63Accident · No injuriesClosedCallair A-9 · Moreno, CAMar 10, 1971 · N7249V · Substantial damage NTSB OAK69D0307Accident · No injuriesClosedCallair A-9 · Dixon, CAApr 21, 1969 · N9616Z · Substantial damage