NTSB investigations: Continental TSIO-520 series, CO
6 cases on aircraft whose registry engine model is Continental TSIO-520 series, where the first occurrence was “In flight encounter with weather”. 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 | 1 |
|---|---|
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2002 | 1 |
| 2006 | 1 |
Where
Latest 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\" = 'CO' 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\" = 240))
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" = 'CO' 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" = 240))
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 DEN06CA089Accident · No injuriesData collectionFinal reportCessna TU206G · Alamosa, COthe pilot's failure to maintain aircraft control during the landing. Contributing factors include the gusty winds, the crosswind, and the pilot exceeding the maximum demonstrated crosswind component for the airplane.NTSB DEN02TA052Accident · No injuriesFinal reportBeech 58P · Grand Junction, COthe pilot's inadvertent flight into adverse weather conditions. A factor contributing to the accident was the terrain-induced turbulence.NTSB DEN91FA002Accident · 1 fatalField investigationFinal reportCessna T210N · Gypsum, COThe pilot flying into known adverse icing and thunderstorm weather conditions which resulted in the loss of control of the aircraft.NTSB DEN88LA075Accident · No injuriesLimited investigationFinal reportCessna 206G · Loveland, COA commercial plt was flying a group of parachutists for a skydiving club. The aircraft encountered turbulence during a climb to 4,500 feet AGL. As the second jumper was exiting, the aircraft dropped and the parachutist struck the horizontal stabilizer. The…NTSB DEN86FA259Accident · 5 fatalField investigationFinal reportCessna 340A · Crawford, COThe plt took off on a VFR flt with no flt plan filed or wx briefing. He encountered a wx squall line en route with low ceilings, fog, mixed rain and snow. While he was attempting to maneuver VFR through the wx at a low altitude above the ground, the acft…NTSB DEN83FA059Accident · 4 fatalField investigationFinal reportCessna 340A · Aspen, COPrior to departure the flt was given an IFR clearance which began at herls intersection (16 mi nne) & to cross herls at or above 16,000 ft MSL. Departure arpt field elev is 7,793 ft. flts are required to proceed VFR to the initial fix of the IFR clearance.…