NTSB investigations: Continental GTSIO-520-C, 1985
7 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
| 1966 | 2 |
|---|---|
| 1967 | 9 |
| 1968 | 5 |
| 1969 | 11 |
| 1970 | 10 |
| 1971 | 9 |
| 1972 | 11 |
| 1973 | 5 |
| 1974 | 10 |
| 1975 | 9 |
| 1976 | 8 |
| 1977 | 7 |
| 1978 | 12 |
| 1979 | 11 |
| 1980 | 10 |
| 1981 | 13 |
| 1982 | 12 |
| 1983 | 9 |
| 1984 | 1 |
| 1985 | 7 |
| 1986 | 5 |
| 1987 | 9 |
| 1988 | 9 |
| 1989 | 5 |
| 1990 | 6 |
| 1991 | 7 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 5 |
| 1995 | 7 |
| 1996 | 2 |
| 1998 | 6 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 8 |
| 2005 | 4 |
| 2006 | 8 |
| 2007 | 4 |
| 2008 | 4 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 2 |
| 2019 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 3 |
| 2025 | 1 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 1985
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 year(c."eventDate") = 1985
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 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…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 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…NTSB FTW85LA218Accident · No injuriesLimited investigationFinal reportCessna 421 · Mckinney, TXAfter landing while taxiing on the rwy, the acft's nose wheel started bogging down in soft asphalt on the rwy. The soft asphalt was pushed along in front of the wheel until it caused enough resistance to overstress the nose gear causing it to collapse. The…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 MIA85LA095Accident · No injuriesLimited investigationFinal reportCessna 411A · Merritt Island, FLAccording to the CFI on board, rotation was accomplished at 110 KTS. Shortly after takeoff the nose of the acft began drifting to the right and the acft began settling to the rwy. The CFI called for gear up and the acft settled to the rwy on its belly in the…