Final NTSB investigations: Continental GTSIO-520-C, 2007
4 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 | 8 |
| 1989 | 5 |
| 1990 | 5 |
| 1991 | 7 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 5 |
| 1995 | 7 |
| 1996 | 1 |
| 1998 | 5 |
| 1999 | 7 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 8 |
| 2005 | 4 |
| 2006 | 8 |
| 2007 | 4 |
| 2008 | 3 |
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 3 |
| 2021 | 3 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 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 year(c.\"eventDate\") = 2007
AND c.\"completionStatus\" = 'Completed'
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") = 2007
AND c."completionStatus" = 'Completed'
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 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 CHI07LA154Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Chesterfield, MOMaintenance personnel failed to comply with an Airworthiness Directive which resulted in the total failure of the starter adapter gear teeth and the crankshaft gear teeth and the pilot failed to follow the published emergency procedures. Contributing to the…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 CHI07FA060Accident · Minor injuriesField investigationFinal reportBeechcraft BE99 · Milwaukee, WIThe failure of both pilots to adequately scan for and avoid other aircraft traffic during taxi operations, and the failure of Air Traffic Control to issue a traffic advisory to both of the pilots. A contributing factor to the accident was the night time light…