NTSB investigations: Continental GTSIO-520-C
6 cases on aircraft whose registry engine model is Continental GTSIO-520-C, where the defining event was Landing gear collapse. 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
| 2008 | 1 |
|---|---|
| 2014 | 3 |
| 2017 | 1 |
| 2026 | 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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '094'))
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '094'))
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 WPR26LA145Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 421B · Sedona, AZOn March 27, 2026, about 1630 Pacific daylight time, a Cessna 421B, N799TF, was substantially damaged when it was involved in an accident near Sedona, Arizona. The pilot and pilot rated passenger were not injured. The airplane was operated as a Code of…NTSB WPR17LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna 421B · Carlsbad, CAThe right main landing gear collapse for undetermined reasons.NTSB CEN14CA310Accident · No injuriesData collectionFinal reportCessna 421A · Dallas, TXThe improper rigging of the landing gear by maintenance personnel, which resulted in the landing gear collapse.NTSB CEN14LA256Accident · No injuriesLimited investigationFinal reportCessna 421 · Horseshoe Bay, TXThe failure of the drive mechanism for the gearbox motor, which resulted in the gear not extending for the landing.NTSB ERA14LA170Accident · No injuriesLimited investigationFinal reportCessna 421 · Charleston, SCInadequate maintenance, which resulted in the collapse of the right main landing gear during landing.NTSB NYC08LA204Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Greenville, NCThe malfunction and premature retraction of the landing gear for undetermined reasons.