NTSB investigations: Continental GTSIO-520-C
9 cases on aircraft whose registry engine model is Continental GTSIO-520-C, where the first occurrence was “In flight collision with terrain/water”. 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 | 2 |
|---|---|
| 1985 | 1 |
| 1988 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 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\" = 230))
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" = 230))
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 IAD03FA032Accident · 3 fatalField investigationFinal reportCessna 421 · Ferguson, KYThe pilot's failure to follow the instrument approach procedure, which resulted in an early descent into trees and terrain. Factors included the low ceiling and the night lighting conditions.NTSB ATL01FA109Accident · 1 fatalField investigationFinal reportCessna T-210F · Hendersonville, NCThe pilot's failure to follow the air traffic controllers verbal instructions pertaining to heading and minimum safe vectoring altitude while being vectored for an ILS approach to his destination airport. This resulted in an in-flight collision with trees and…NTSB FTW01FA033Accident · 2 fatalField investigationFinal reportCessna 421B · Norman, OKthe pilot's failure to follow the instrument approach procedure and his continued descent below the prescribed minimum descent altitude (MDA). Contributory factors were the pilot's physical impairment from drugs, the low ceiling, fog, and dark night light…NTSB SEA99FA041Accident · 2 fatalField investigationFinal reportCessna 421B · North Bend, ORA delayed aborted takeoff for an undetermined reason.NTSB DEN89FA034Accident · 2 fatalField investigationFinal reportCessna 421 · Tooele, UTNTSB MKC88LA111Accident · No injuriesLimited investigationFinal reportAero Commander 685 · Scranton, ARShortly after takeoff from a 2400 foot sod strip, the PIC said the acft began to settle, although both engines were delivering takeoff power and RPM, and liftoff speeds were proper. The acft settled back to the runway and careened off on to the overrun…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…NTSB LAX84LA069Accident · No injuriesLimited investigationFinal reportCessna TU206E · Red Rock, AZThe acft taxied into a ditch after landing on a road at night. After the acft came to rest it was apparently intentionally burned. Sob & injuries are presumed. The landing site was marked by the placement of white cloths along the edges of the road. The acft…NTSB LAX83IA345Incident · No injuriesIncident investigationFinal reportCessna 411 · Huntington Bch., CAPilot inadvertantly landed with gear up due to the distraction of making a short field landing.