Fatal NTSB investigations: Rockwell International 112TCA
6 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
| 1980 | 1 |
|---|---|
| 1984 | 1 |
| 2003 | 1 |
| 2006 | 1 |
| 2015 | 1 |
| 2024 | 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.\"highestInjuryLevel\" = 'Fatal'
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."highestInjuryLevel" = 'Fatal'
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 GAA25WA049Accident · 1 fatalClass 5 · ForeignRockwell International 112TCA · Fife, United KingdomNTSB CEN15WA299Accident · 1 fatalForeign investigationRockwell International 112TCA · Kempten (Allgäu), GermanyNTSB 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 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 DEN84FA307Accident · 4 fatalField investigationFinal reportRockwell 112TCA · Missoula, MTThe pilot had filed an IFR clearance. While taxiing to takeoff, he requested and received a clearance to climb VFR on course, via victor airway 2, with instructions to report when reaching 10,000' MSL. This was the last communication received from the pilot.…NTSB FTW80FA088Accident · 2 fatalClosedRockwell 112TCA · Aspermont, TX