NTSB investigations: Continental GTSIO-520-C
8 cases on aircraft whose registry engine model is Continental GTSIO-520-C, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17035')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
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 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 SEA07LA055Accident · No injuriesLimited investigationFinal reportCessna 421 · Pocatello, IDThe separation of the bolt that attaches the elevator trim tab actuator rod to the elevator trim tab horn, resulting in violent flutter of the elevator, and eventually to the separation of the inboard half of the right elevator.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 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.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.NTSB MKC88LA036Accident · No injuriesLimited investigationFinal reportCessna 414 · Fayetteville, ARDuring an instructional flt, the CFI and student plt heard a loud pop while attempting to lower the gear in preparation for landing. Several flybys past the control tower were made to confirm an unsafe nose gear configuration. They flew the aircraft an…NTSB ATL88LA031Accident · No injuriesLimited investigationFinal reportCessna 401A · Mobile, ALThe plt related that he was climbing through 4,300 ft when he lost the left turbocharger. He then noted sparks and then fire from the engine. He shut off the fuel, waited for the fire to go out and feathered the propeller. The flt was continued to montgomery,…NTSB MIA85LA169Accident · No injuriesLimited investigationFinal reportCessna 421B · Lakeland, FLDuring takeoff at Lakeland, FL, the left main wheel assembly separated from the acft & struck the leading edge of the horizontal stabilizer, causing substantial damage. The plt did not know the wheel had come off until he was notified by ATC. He then diverted…