Skip to content

NTSB investigations: Continental GTSIO-520-C, CO

19 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

Where

Latest cases

Query with SQL

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" = 'CO' 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

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\" = 'CO' 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" = 'CO' 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

Run 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 CEN24FA212Accident · 1 fatalClass 3 · FieldFinal reportBeech V35A · Arvada, COA total loss of engine power due to oil starvation as a result of loose turbocharger oil line fittings.Jun 7, 2024 · N150WR · Destroyed NTSB CEN21LA341Accident · No injuriesClass 4 · LimitedFinal reportCessna T210F · Peyton, COThe pilot’s fuel mismanagement that resulted in a complete loss of engine power during climb and subsequent impact with terrain during a forced landing.Jul 27, 2021 · N6162R · Substantial damage NTSB DEN06FA114Accident · Serious injuriesField investigationFinal reportCirrus Design SR20 · Kremmling, COThe pilot's failure to properly execute the published missed approach procedure resulting in an impact with mountainous terrain. Contributing factors were the pilot's attempted flight into known adverse weather conditions, failure to obtain the UNICOM…Aug 16, 2006 · N8127J · Destroyed NTSB DEN05FA074Accident · 4 fatalField investigationFinal reportCessna T210G · Ouray, COthe pilot's inadvertent flight into adverse weather conditions, loss of control, and resulting exceedence of the design stress limits of the aircraft. which led to an in-flight structural failure. Factors in the accident included the pilot's inadequate…May 11, 2005 · N6807R · Destroyed NTSB DEN05FA038Accident · 3 fatalField investigationFinal reportCessna 421 · Englewood, COloss of engine power due to fuel starvation, and the instructor's failure to maintain aircraft control. Contributing factors were a partially blocked fuel line resulting in restricted fuel flow, the instructor's failure to perform critical emergency…Dec 17, 2004 · N421FR · Destroyed NTSB DEN99LA138Accident · No injuriesLimited investigationFinal reportCessna TU206A · Durango, COA worn landing nose gear steering system that diminished the ability to steer the airplane. Factors were improper maintenance by unknown persons, and loose gravel.Aug 8, 1999 · N4835F · Substantial damage NTSB FTW98FA319Accident · Minor injuriesField investigationFinal reportCessna T-310P · Colorado Sprngs, COThe separation of a portion of the right engine exhaust stack, and the ensuing fuel fire in the right engine nacelle.Jul 19, 1998 · N5833M · Destroyed NTSB DEN91LA136Accident · No injuriesLimited investigationFinal reportCessna 421B · Pagosa Springs, COInadequate preflight of the aircraft by the pilot in command. A factor was: failure of the pilot in command to properly latch the cargo door.Aug 16, 1991 · N80RS · Substantial damage NTSB DEN91LA101Accident · No injuriesLimited investigationFinal reportCessna 421B · Colorado Spring, COA fractured fuel line and an improperly performed annual inspection.Jul 17, 1991 · N768RA · Substantial damage NTSB DEN90LA078Accident · Minor injuriesLimited investigationFinal reportCessna T210J · Englewood, COThe pilot's loss of directional control during an aborted takeoff.Mar 25, 1990 · N2KD · Substantial damage NTSB DEN89LA199Accident · Serious injuriesLimited investigationFinal reportCessna T210F · Englewood, COA failure in the hyrdraulic power unit, which prevented operation of either the normal or emergency gear extension systems. The raised runway lip contributed to aircraft damage and pilot injury.Aug 24, 1989 · N6121R · Substantial damage NTSB DEN86FA033Accident · Serious injuriesField investigationFinal reportCessna 421B · Franktown, COThe acft departed nashville, TN, for a flt to aspen, CO. The plts made one refueling stop at chanute, KS. The plts were unable to land at aspen or a nearby alternate arpt (eagle, CO) and elected to return back to the denver area. The plts indicated to an…Dec 2, 1985 · N249JM · Substantial damage NTSB DEN84FA004Accident · No injuriesField investigationFinal reportCessna 421C · Center, COThe acft collided with a dirt bank after a left engine overspeed and loss of directional control during takeoff. The plthad already aborted one takeoff due to overboost and a sticking wastegate. The problem seemed corrected after work and lubrication by a…Oct 9, 1983 · N770JW · Substantial damage NTSB DEN83LA081Accident · No injuriesLimited investigationFinal reportCessna 421C · Gunnison, COThe plt began taking off on rwy 06 with a wind from 190 deg at 8 KTS. He stated that max power & RPM were obtained. He noted that he obtained 39 inches of manifold pressure & 2235 RPM at 100 KTS IAS. Reportedly, the acft rotated properly, but began to vibrate…Mar 18, 1983 · N67943 · Substantial damage NTSB DEN78FTE69Accident · No injuriesClosedCessna TU206A · Crested Butte, COJun 21, 1978 · N4895F · Substantial damage NTSB DEN74DTE89Accident · No injuriesClosedCessna 411 · Salida, COJun 16, 1974 · N4954T · Substantial damage NTSB DEN69A0037Accident · No injuriesClosedDehavilland DH114 · Aspen, COMar 24, 1969 · N1420Z · 2 aircraft · Minor damage NTSB DEN69D0075Accident · No injuriesClosedCessna 320E · Grand Jnct, COJul 27, 1968 · N3410Q · Substantial damage NTSB DEN68F0158Accident · No injuriesClosedCessna T-210 · Denver, CONov 1, 1967 · N6702R · Substantial damage