NTSB investigations: Continental IO-520 series, CO
5 cases on aircraft whose registry engine model is Continental IO-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
| 1984 | 1 |
|---|---|
| 1988 | 1 |
| 1990 | 1 |
| 1999 | 1 |
| 2002 | 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 ('17032')
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 ('17032')
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 DEN02GA102Accident · 1 fatalFinal reportCessna A185F · Howard, COthe pilot's failure to maintain clearance of the terrain. Contributing factors were the clear air turbulent weather condition, and the high density altitude condition.NTSB DEN99FA093Accident · 1 fatalField investigationFinal reportBeech V35A · Nederland, COThe pilot's intentional and continued flight into instrument meteorological conditions. Factors were his failure to obtain a weather briefing, the existing weather conditions that included snow, hail, obscuration and lightning, and the mountainous terrain.NTSB DEN90FA089Accident · 1 fatalField investigationFinal reportCessna 210E · Elbert, COThe pilot's initiation of flight into known adverse weather, the rapid ice accumulation on the airframe, and an inadvertent stall-mush, resulting in an uncontrolled descent into terrain.NTSB DEN89FA036Accident · 5 fatalField investigationFinal reportCessna T210F · Cortez, COThe plt obtained a wx briefing from las vegas fss and was told that flt under VFR was not recommended for the proposed flt to durango (dro). The plt filed a VFR flt plan and departed las vegas. Over page, AZ, he filed a PIREP and was again told VFR flt not…NTSB DEN84LA178Accident · No injuriesLimited investigationFinal reportBeech V35A · Dove Creek, COWhile en route, the plt encountered hazy wx after crossing the Continental divide. Near montrose, CO, he deviated about 50 mi north to avoid adverse wx. He was unable to get thru, so he proceeded back to montrose to skirt the southern edge of the wx. He…