NTSB investigations: Continental GTSIO-520-C, CA
40 cases on aircraft whose registry engine model is Continental GTSIO-520-C. 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
| 1967 | 1 |
|---|---|
| 1969 | 1 |
| 1970 | 2 |
| 1973 | 1 |
| 1974 | 3 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 3 |
| 1978 | 3 |
| 1980 | 2 |
| 1983 | 1 |
| 1985 | 3 |
| 1988 | 1 |
| 1991 | 1 |
| 1995 | 2 |
| 1999 | 2 |
| 2002 | 1 |
| 2003 | 3 |
| 2004 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2012 | 1 |
| 2017 | 1 |
Where
Latest 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.engine_model_code IN ('17035'))
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.engine_model_code IN ('17035'))
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 WPR17LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna 421B · Carlsbad, CAThe right main landing gear collapse for undetermined reasons.NTSB WPR13FA037Accident · 2 fatalField investigationFinal reportCessna 421C · Shaver Lake, CAThe pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…NTSB WPR10LA002Accident · No injuriesLimited investigationFinal reportCessna 421B · San Simeon, CAThe pilot's failure to follow the manufacturer’s checklist and set the parking brake.NTSB LAX08LA251Accident · No injuriesLimited investigationFinal reportCessna TU206E · Murrieta, CAA malfunction of the flight control system and loss of engine power for undetermined reasons.NTSB SEA07CA224Accident · No injuriesData collectionFinal reportCessna 421B · Oceanside, CAThe collapse of the right main landing gear during the landing roll for undetermined reason, which resulted in a loss of directional control and collision with a fence.NTSB LAX07FA035Accident · 3 fatalField investigationFinal reportCessna 421B · Big Bear Lake, CAFailure of the turbine wheel shaft in the left turbocharger during the takeoff initial climb for undetermined reasons, and the pilot's failure to attain and maintain safe single engine airspeed that led to a loss of control.NTSB LAX05FA041Accident · 2 fatalField investigationFinal reportCessna 411 · Corona, CAA loss of engine(s) power for undetermined reasons. Also causal was the pilot's failure to maintain the airplane's minimum controllable airspeed (Vmc) during the initial climb following a loss of power in one engine, which resulted in a loss of aircraft…NTSB LAX04LA284Accident · No injuriesLimited investigationFinal reportCessna 206 · Truckee, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control of the airplane.NTSB LAX04FA031Accident · 5 fatalField investigationFinal reportCessna 421B · Kelso, CAThe pilot's continued VFR flight into instrument conditions between cloud layers and with reduced visibility due to smoke that resulted in an in-flight loss of control from spatial disorientation, and the structural overload of the airframe during the…NTSB LAX03FA147Accident · 1 fatalField investigationFinal reportCessna 411 · Corona, CAThe failure of the pilot to properly configure the airplane for a one engine inoperative condition (including his failure to feather the propeller of the affected engine, retract the landing gear, and maintain minimum single engine speed). Factors related to…NTSB LAX03LA106Accident · No injuriesLimited investigationFinal reportCessna 421C · Crescent City, CAThe separation of the upper and lower right main landing gear scissor links due to improper maintenance, which resulted in a ground loop, and the collapse of the right main landing gear during the landing roll.NTSB LAX02LA238Accident · No injuriesLimited investigationFinal reportCessna T210F · Willits, CAthe student pilot's misjudged, distance, and speed, and failure to attain the proper touchdown point.NTSB LAX00LA004Accident · No injuriesLimited investigationFinal reportCessna 421B · Montague, CAThe collapse of the left main landing gear during the landing rollout for undetermined reasons, which resulted in the pilot's loss of directional control.NTSB LAX99FA225Accident · Minor injuriesField investigationFinal reportCessna 402A · Van Nuys, CAThe pilot's inadequate fuel management that resulted in fuel exhaustion and the subsequent collision with vehicles during a forced landing on a city street.NTSB LAX95FA297Accident · 2 fatalField investigationFinal reportBeech D55 · Kingsburg, CAthe failure of the pilot to maintain sufficient airspeed during a simulated engine failure to avoid an inadvertent stall/spin, and inadequate supervision by the designated pilot examiner. A factor in the accident was the decision of the examiner to use an…NTSB LAX95LA232Accident · No injuriesLimited investigationFinal reportCessna 401A · Van Nuys, CAthe failure of the wing rib web due to undetected cracking in an area of known crack development around the landing gear side brace fitting. The operator's failure to accomplish a Service Letter addressing the problem is a factor in the accident.NTSB LAX91LA142Accident · No injuriesLimited investigationFinal reportCessna 421 · El Monte, CAThe pilot retracting the landing gear during the landing roll.NTSB LAX88LA291Accident · No injuriesLimited investigationFinal reportCessna T210K · Huntington Bch, CADuring the landing roll, the pilot heard a loud bang on the right side of the airplane. When the pilot applied brakes and the speed dissipated, directional control was lost. The airplane veered of the runway and collided with a runway light. During an…NTSB LAX85LA381Accident · No injuriesLimited investigationFinal reportCessna 402A · San Jose, CAThe aircraft landed gear up. The pilot reported no malfunction and said he forget to lower the landing gear.NTSB LAX85LA306Accident · No injuriesLimited investigationFinal reportCessna 421A · San Diego, CADuring landing roll out the right main gear collapsed in an outward direction. Exam of the rt gear revealed that the bolt which is associated with the upper & lower gear torque links was missing. An exam of the left gear assembly revealed that the required…NTSB LAX85FA238Accident · No injuriesField investigationFinal reportBeech V35A · Santa Monica, CAAfter deptg & climbing to 4500', the plt & his plt rated pax noted a fuel odor & returned to the arpt to land. Bfr lndg,the plt called the tower (twr), but didn't advise twr psnl of the fuel odor or of a psbl prblm. As the acft was turning off the rwy, fire &…NTSB LAX83IA345Incident · No injuriesIncident investigationFinal reportCessna 411 · Huntington Bch., CAPilot inadvertantly landed with gear up due to the distraction of making a short field landing.NTSB LAX80FUG58Accident · No injuriesClosedCessna 421 · Palm Springs, CANTSB LAX80FUQ22Accident · No injuriesClosedCessna 421A · Lancaster, CANTSB LAX79FUA04Accident · Minor injuriesClosedCessna 210J · Lomita, CANTSB OAK78DXQ38Accident · No injuriesClosedCessna 320 · Mammoth Lakes, CANTSB OAK78FA020Accident · 4 fatalClosedCessna 411 · Chilcoot, CANTSB LAX78DUM04Accident · Minor injuriesClosedCessna T207 · Calexico, CANTSB OAK77FVA27Accident · No injuriesClosedCessna 411 · Fresno, CANTSB LAX77DVA19Accident · No injuriesClosedCessna 411 · Porterville, CANTSB LAX76IL049Incident · No injuriesClosedCessna 411 · Riverside, CANTSB LAX75DUM28Accident · No injuriesClosedCessna 206B · Imperial, CANTSB OAK75DVA33Accident · Minor injuriesClosedCessna 210 · Sanger, CANTSB LAX74DVM31Accident · No injuriesClosedCessna 195 · Paso Robles, CANTSB OAK74FVG39Accident · No injuriesClosedCessna 320F · Redding, CANTSB LAX74FUG29Accident · No injuriesClosedCessna 206 · 29 Palms, CANTSB LAX71FUA02Accident · No injuriesClosedCessna 210 · Santa Ana, CANTSB OAK70AP038Accident · No injuriesClosedCessna 150F · Sonora, CANTSB LAX70D0101Accident · No injuriesClosedCessna T210H · Upland, CANTSB LAX67D0433Accident · No injuriesClosedCessna 210 · Inyokern, CA