NTSB investigations: Continental GTSIO-520-C, UT
6 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
| 1971 | 1 |
|---|---|
| 1978 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1988 | 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.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA'
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 DEN89FA034Accident · 2 fatalField investigationFinal reportCessna 421 · Tooele, UTNTSB DEN83FA193Accident · 1 fatalField investigationFinal reportCessna 421A · West Jordan, UTInvestigation revealed that the plt aborted two takeoff attempts due to a 'roughness' in one eng. Not able to duplicate the roughness during subsequent ground checks, the plt departed. At an alt of 300 AGL the left eng began to surge and the right eng,…NTSB DEN82DA053Accident · No injuriesFinal reportCessna T210G · Moab, UTThe aircraft was found on an abandoned dirt runway near deadhorse point. Investigation indicated that the aircraft touched down long on runway 21 and collided with an elevated dirt road that crosses the runway. Two impact marks were found on the instrument…NTSB DEN82DA030Accident · No injuriesFinal reportCessna 421B · Spanish Fork, UTThe aircraft tookoff from an airport with slush on the runway, about 10 minutes later, the pilot landed at another airport. The runway at the destination airport was covered with dry snow. During touchdown, the aircraft veered left and hit a snowbank beside…NTSB DEN79FTM04Accident · Minor injuriesClosedCessna 421A · Salt Lake City, UTNTSB DEN72AD030Accident · 5 fatalClosedCessna 411 · Stockton, UT