NTSB investigations: Continental O-470 series, CO
9 cases on aircraft whose registry engine model is Continental O-470 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 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 ('17026')
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" = '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 ('17026')
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 DEN01LA138Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Pueblo, COthe loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector position. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Rifle, COLoss of engine power for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.NTSB FTW98LA115Accident · No injuriesLimited investigationFinal reportCessna 182E · Steamboat Sprng, COThe total nonmechanical power loss due to the formation of carburetor ice. A factor was the deep snow covered field on which the forced landing was made.NTSB DEN89LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Weston, COWater in the fuel and inadequate preflight by the pilot. A contributing factor was the ditch.NTSB DEN87LA047Accident · Minor injuriesLimited investigationFinal reportCessna 182L · La Junta, COThe engine quit during cruise flt at 8,500 feet MSL. During the emergency landing to unsuitable terrain, the acft nosed over. The plt had flown 5 hours on this flt. The long range fuel tanks had been installed with the filler ports inboard, limiting the total…NTSB DEN85LA145Accident · No injuriesLimited investigationFinal reportCessna 182 · Byers, COPlt stated that he was 'in a rush to get home' after his extended trip. He continued to state 'I wanted to get home thatafternoon without another stop and I wanted the performance figures to show me that I could.' The plt executed an emerg landing after the…NTSB DEN83FA091Accident · Serious injuriesField investigationFinal reportCessna 182H · Hayden, COThe acft collided with a powerline and crashed after the engine lost power on takeoff. According to witnesses the acft made a normal takeoff but during climbout the engine backfired and dark smoke came out. The acft turned left then steeply right before…NTSB DEN82DA052Accident · Minor injuriesFinal reportCessna 180K · Montrose, CODuring flight over mountainous terrain, the pilot encountered "horizontal snow squalls." He reported that he flew through the snow squall for about 25 miles while maintaining ground contact. He approached a cloud layer, but was able to fly over it at 16,500…NTSB DEN82FTE15Accident · No injuriesFinal reportCessna 182A · Steamboat Sprin, COAfter the pilot entered the traffic pattern for landing, he extended his downwind leg to accomodate the departure of another aircraft. The pilot reported that he pushed the throttle forward as he turned base, but the engine failed to respond. During a forced…