NTSB investigations: Continental GTSIO-520-C
8 cases on aircraft whose registry engine model is Continental GTSIO-520-C, where the first occurrence was “Loss of engine power(partial) - mech failure/malf”. 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
| 1983 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1998 | 1 |
| 2004 | 1 |
| 2006 | 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.\"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\" = 352))
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" = 352))
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 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 DEN04CA096Accident · Minor injuriesData collectionFinal reportCessna T210J · Cheyenne, WYthe detachment of the nut and bolt that attaches the throttle control cable to the fuel induction due to improper maintenance. Contributing factors were the fiber optics wire, fence, and ditch, and the unavailability of suitable terrain on which to make a…NTSB ANC98FA019Accident · 1 fatalField investigationFinal reportCessna 207 · Homer, AKA fatigue failure, and partial separation of the number 6 engine cylinder head assembly, the operator's inadequate progressive inspection performed by company maintenance personnel, and the pilot's inadvertent stall during a maneuvering turn toward an…NTSB LAX91LA129Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Tucson, AZThe fatigue failure of the right engine turbo exhaust clamp, and, the failure of the flying pilot to complete the single engine emergency procedures in a timely manner. A factor in the accident was the failure of the pilot in command to adequately supervise…NTSB LAX90FA311Accident · 1 fatalField investigationFinal reportCessna 411 · Fallon, NVFailure of the pilot to perform emergency procedures for loss of engine power (including his failure to feather the propeller of the affected engine). Factors related to the accident were: inadequate maintenance, contamination in the fuel system, and overheat…NTSB LAX89LA217Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Picacho, AZFailure of the number three exhaust valve on the left engine. A major factor was the high density altitude where the airplane would not operate on single engine.NTSB LAX87FA151Accident · Serious injuriesField investigationFinal reportCessna T210K · Prescott, AZAfter overloading the aircraft with 5 pax and baggage, the pilot departed on a personal cross country flight to phoenix, AZ. He climbed the acft to and maintained an altitude of 14,500 feet MSL until reaching salt lake city, UT. The aircraft was then…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…