NTSB investigations: Rockwell International 112TCA, CA
5 cases on aircraft the registry lists as Rockwell International 112TCA. 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
| 1991 | 1 |
|---|---|
| 1996 | 1 |
| 2003 | 1 |
| 2004 | 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 ('7630307'))
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 ('7630307'))
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 LAX06FA133Accident · 1 fatalField investigationFinal reportRockwell 112 TCA · La Canada, CAThe pilot's failure to maintain aircraft control and an adequate airspeed during climb to cruise that led to a stall/spin. Contributing to the accident were the clouds and the pilot's physiological state.NTSB LAX04LA308Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · San Rafael, CAA total loss of engine power during initial climb due to fuel starvation, which was caused by the pilot's failure to turn on the electric boost pump and an undetermined failure of the engine driven pump to supply sufficient fuel to the carburetor.NTSB LAX03FA187Accident · 1 fatalField investigationFinal reportRockwell International Aero-Commander 112TC · Santa Nella, CAThe pilot's inadequate in-flight planning/decision by conducting VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were low clouds, fog, and mountainous terrain.NTSB LAX96LA166Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · Independence, CAthe pilot's inadequate compensation for the wind conditions. The wind was a factor.NTSB LAX91LA161Accident · Minor injuriesLimited investigationFinal reportRockwell 112TCA · Burbank, CAThat the pilot failed to properly preflight the airplane and miscalculated the airplane's fuel consumption. Contributing to this accident was fuel exhaustion.