NTSB investigations: Continental TSIO-520 series, WY
5 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 2000 | 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\" = 'WY' 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 ('17040')
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\" = 353))
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" = 'WY' 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 ('17040')
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" = 353))
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 DEN00LA055Accident · No injuriesLimited investigationFinal reportCessna P210N · Gillette, WYThe pilot's failure to land sooner to refuel, resulting in a power loss due to fuel exhaustion. A factor was a lack of suitable terrain on which to make a forced landing.NTSB SEA91LA009Accident · No injuriesLimited investigationFinal reportCessna T210N · Laramie, WYThe pilot did not properly set the mixture control.NTSB DEN87LA009Accident · No injuriesLimited investigationFinal reportCessna TU206G · Greybull, WYThe plt departed aurora, co at 1000 en route to great falls, mt at 8000 ft MSL. At 1237 the plt advised worland fss that the eng had lost power and he was going down. The plt said that on final apch he had to pull up to avoid power lines. The acft stalled and…NTSB DEN85LA249Accident · Serious injuriesLimited investigationFinal reportCessna TU206G · Evanston, WYThe plt said the eng quit as he was turning from base leg to final apch for rwy 24 at Evanston (WY) arpt. The acft crashed as the plt maneuvered for an emerg landing. Disassembly and examination of the eng disclosed no reason on why the engine failed. The…NTSB DEN84FA071Accident · No injuriesField investigationFinal reportCessna 310Q · Casper, WYThe plt stated he was told, the r aux fuel pump was inop & to prime/start the r eng, he had to position the r fuel selector (sel) to x-feed. On the 1st 2 legs of the flt, he used this procedure, but noted the r fuel sel was hard to move. While starting for…