Fatal NTSB investigations: Continental GTSIO-520 series
12 cases on aircraft whose registry engine model is Continental GTSIO-520 series. 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
| 1984 | 1 |
|---|---|
| 1986 | 1 |
| 1995 | 2 |
| 2001 | 2 |
| 2002 | 1 |
| 2004 | 1 |
| 2019 | 1 |
| 2021 | 1 |
| 2024 | 2 |
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.engine_model_code IN ('17046', '17039'))
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.engine_model_code IN ('17046', '17039'))
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 WPR24FA289Accident · 3 fatalClass 3 · FieldPreliminary reportCessna 421C · Fairview, OROn August 31, 2024, about 1030 Pacific daylight time, a Cessna 421C, N421GP was destroyed when it was involved in an accident near Fairview, Oregon. The two pilots and one person on the ground were fatally injured. The airplane was operated as a Title 14 Code…NTSB GAA24WA258Accident · 3 fatalClass 5 · ForeignCessna 421C · Tofino, CanadaNTSB WPR21FA270Accident · 2 fatalClass 3 · FieldFinal reportCessna 421C · Monterey, CAThe pilot’s failure to maintain airplane control due to spatial disorientation during an instrument departure procedure in instrument meteorological conditions which resulted in a collision with terrain. Contributing to the accident was the pilot’s lack of…NTSB CEN19FA082Accident · 2 fatalClass 2 · FieldFinal reportCessna 421 · Canadian, TXThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions with icing conditions present, which resulted in an aerodynamic stall and spin into terrain.NTSB FTW04FA243Accident · 2 fatalField investigationFinal reportCessna 421C · Bee Caves, TXThe pilot's improper positioning of the fuel selector valves, which resulted in a loss of power to the left engine due to fuel exhaustion. After the power loss, the pilot failed to follow checklist procedures and did not secure (feather) the left propeller,…NTSB DEN03FA025Accident · 2 fatalField investigationFinal reportCessna 421 · Akron, COThe fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the…NTSB MIA01FA140Accident · 1 fatalField investigationFinal reportCessna 404 · Pena Pobre, PRfailure of the pilot-in-command to maintain altitude/clearance, resulting in an in-flight collision with rising terrain.NTSB ATL01FA036Accident · 5 fatalField investigationFinal reportCessna 421 · Munford, ALThe pilot continued visual flight into instrument weather conditions that resulted in the inflight collision with a river bank. Factors were reduced visibility and dark night.NTSB FTW96FA073Accident · 6 fatalField investigationFinal reportCessna 421C · Cleveland, OKthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane after encountering adverse weather conditions, which resulted in a stall/spin. Factors relating to the accident were: pilot…NTSB LAX95FA319Accident · 8 fatalField investigationFinal reportCessna 421C · Beaver Dam, AZFailure of the pilot to maintain adequate airspeed, while maneuvering on approach, which resulted in an inadvertent stall/spin and uncontrolled collision with terrain. Factors relating to the accident were: the pilot allowed the aircraft weight and balance…NTSB DEN87FA016Accident · 1 fatalField investigationFinal reportCessna 421C · Butte, MTPlt was attempting the vor-b instrument apch to Butte, MT arpt. Plt reported over the coppertown VORTAC inbound on the arpt. The procedure turn inbound course to the VORTAC is 124 degrees. The inbound course to the arpt is 094 degrees. The acft wreckage was…NTSB FTW85FA019Accident · 1 fatalField investigationFinal reportCessna 421C · Addison, TXAprx 7 min after takeoff (at 1441), the plt declared an emergency & said the l eng had lost power. He feathered the eng,diverted back twd the arpt & dscndd to VFR conds below the clds. At 1448, the plt said he had the arpt in sight & turnedonto a left…