NTSB investigations: Aero Commander 112, CA
8 cases on aircraft the registry lists as Aero Commander 112. 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
| 1973 | 1 |
|---|---|
| 1975 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2001 | 1 |
| 2006 | 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 ('0144701'))
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 ('0144701'))
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 LAX07LA020Accident · Serious injuriesLimited investigationFinal reportAero Commander 112 · Chino, CAA loss of engine power during the initial climb after takeoff due to blocked fuel vent lines that resulted in fuel starvation. Contributing to the accident was an inadequate preflight inspection by the pilot-in-command (CFI).NTSB LAX01LA173Accident · No injuriesLimited investigationFinal reportAero Commander 112A · Riverside, CAFailure of the pilot to maintain directional control of the airplane during the landing roll. A factor was the worn nose wheel steering assembly.NTSB LAX94LA105Accident · No injuriesLimited investigationFinal reportRockwell AC-112 · Modesto, CAthe worn/chafed landing gear wire which provided intermittent electrical power to the hydraulic pump.NTSB LAX93LA169Accident · Serious injuriesLimited investigationFinal reportAero Commander 112 · Camarillo, CAThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion. Factors related to the accident were: improper preflight planning/preparation, inadequate fuel supply, refueling stop not performed, and no suitable terrain found in the…NTSB LAX79FVA16Accident · Minor injuriesClosedAero Comdr 112A · Long Beach, CANTSB LAX96LA321Accident · 2 fatalLimited investigationClosedRockwell 112 · Eureka, CAThe pilot's intentional VFR flight into instrument meteorological conditions.NTSB LAX76AVA25Accident · Minor injuriesClosedAero Comdr 112A · Mcfarland, CANTSB OAK73AP040Accident · 2 fatalClosedAero Comdr 112 · S.Lke Tahoe, CA