NTSB investigations: Continental O-470 series, OR
148 cases on aircraft whose registry engine model is Continental O-470 series. 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, newest first
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\" = 'OR' 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'))
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" = 'OR' 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'))
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 SEA02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Pacific City, ORThe pilot's inadequate compensation for local wind conditions during the landing roll. Factors include unfavorable winds, and a swampy area adjacent to the runway.NTSB SEA01LA170Accident · 1 fatalLimited investigationFinal reportCessna 182J · Gold Beach, ORThe pilot's failure to attain proper alignment while on final approach and clearance from trees. The pilot's lack of total experience in this type of mountain flying operation was a factor.NTSB SEA01LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Enterprise, ORInadvertent collision with a deer while landing. A contributing factor was night conditions.NTSB SEA00TA138Accident · No injuriesFinal reportCessna 182R · John Day, ORThe pilot's improper flare on touchdown resulting in a hard landing. A factor was the pilot's entrance into an inadvertent porpoise condition.NTSB SEA00LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Hillsboro, ORThe pilot's inability to maintain the correct approach airspeed (Vref) on final due to incorrect airspeed indications resulting from a partial blockage of the pitot line. Factors include a quartering tailwind, a wet runway, and the pilot's decision not to…NTSB SEA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182 · Redmond, ORThe pilot's improper flare.NTSB SEA99LA068Accident · No injuriesLimited investigationFinal reportCessna 182N · Granite, ORClearance was not maintained. A sign and the selection of unsuitable terrain for landing were factors.NTSB SEA97LA007Accident · No injuriesLimited investigationFinal reportCessna 182Q · Manzanita, ORfailure of pilot to adequately compensate for wind conditions on final approach and attain a proper touchdown point for landing. A factor relating to the accident was: the unfavorable wind condition.NTSB SEA95LA081Accident · No injuriesLimited investigationFinal reportCessna 180D · Nyssa, ORFuel exhaustion due to the pilot's failure to refuel en route.NTSB SEA94LA226Accident · No injuriesLimited investigationFinal reportCessna 182P · Yamhill, ORThe pilot's failure to maintain directional control. A factor to the accident was: an inadequate recovery from a bounced landing.NTSB SEA94LA204Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Bend, ORImproper use of the carburetor heat by the pilot, which resulted in a loss of engine performance. A factor related to the accident was: rough terrain in the emergency landing area.NTSB SEA92LA131Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Corbett, ORThe failure of the float attach fitting, and the separation of the floats from the aircraft.NTSB SEA91LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boring, ORFuel exhaustion and improper inflight decision by the pilot in command followed by rough terrain during the forced landing. Factors contributing to the accident were a fuel system leak and the pilot's failure to refuel en route.NTSB SEA91FA038Accident · 2 fatalField investigationFinal reportCessna 182B · Estacada, ORA power loss due to carburetor ice, and missing muffler cones as a result of inadequate maintenance inspection. In addition, the pilot failed to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB SEA91LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Burns, ORThe formation of carburetor ice when the pilot delayed the use of carburetor heat.NTSB SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.NTSB SEA90LA096Accident · No injuriesLimited investigationFinal reportCessna 310B · Albany, ORThe pilot's failure to extend the landing gear before landing, when he became distracted by a change in his normal routine.NTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.NTSB SEA90LA046Accident · No injuriesLimited investigationFinal reportCessna 182K · Sheridan, ORThe loss of engine power due to the inadequate preflight inspection of the aircraft by the pilot in command.NTSB SEA90LA015Accident · No injuriesLimited investigationFinal reportCessna 182P · Hillsboro, ORFailure of the pilot to attain the proper touchdown point or go around while there was still sufficient runway and speed remaining. The tailwind was a related factor.NTSB SEA89FA183Accident · 3 fatalField investigationFinal reportCessna 182F · Diamond Lake, ORImproper inflight planning and decision by the pilot in command who continued VFR flight into IMC conditions while attempting to fly through a mountain pass. Contributing factors were the low ceiling and rain weather conditions and the mountainous, hilly…NTSB SEA89LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Arlington, ORThe student pilot touched down too FAR down the runway to allow him to stop before running into a trailer.NTSB SEA88FA034Accident · 3 fatalField investigationFinal reportCessna 182J · Molalla, ORThe recently certificated, non-instrument rated, pvt plt flew into the an area of low ceilings, low vis, rain & snw w/o filing a flt plan. No record of a wx briefing was fnd. A surviving pax rprtd that drg flt, the plt flew into clds that were initially…NTSB SEA88FA011Accident · 3 fatalField investigationFinal reportCessna 180K · Walton, ORWitnesses observed the aircraft flying westbound toward a pass at a low altitude above the ground near the base of low stratus clouds. The aircraft struck a tree at the top of a ridgeline in mount/hilly terrain on a northeasterly heading, traveled 1/2 mile…NTSB SEA87LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Sprague River, ORA hard, flat, bounced landing occurred collapsing the nose gear and damaging the firewall.NTSB SEA87LA126Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Dallas, ORThe pilot inadvertently landed with a quartering gusting tailwind. On landing rollout the aircraft nosed over inverted.NTSB SEA87FA060Accident · 2 fatalField investigationFinal reportCessna 182 · North Bend, ORPlt was inbound to VORTAC in clouds for localizer approach to rwy 4. Wx at arpt reporting 1500 ft bkn. Plt expected to make missed approach to continue VFR to another arpt. Plt reported inbound in and out of clouds at 1300 ft. acft crashed 4 NM beyond arpt,…NTSB SEA85LA200Accident · No injuriesLimited investigationFinal reportCessna 180A · Buxton, ORThe pilot misjudged his touchdown point on the 1,000 foot airstrip and had an excess of airspeed. And overrun occurred and the aircraft went down an embankment. At the time of touchdown, there was only about 4 KTS of headwind available.NTSB SEA85FA012Accident · 4 fatalField investigationFinal reportCessna 182B · Tiller, ORThe acft collided with rising terrain about 1800 ft below the crest of a ridge while on a personal flt in wx which had multiple cloud layers obsuring the mountains. A cap acft on a search mission in the same area at the aprx time reported multiple cloud…NTSB SEA84LA214Accident · No injuriesLimited investigationFinal reportCessna 180A · Scappoose, ORThe pilot stated that during the takeoff ground run, just prior to rotation, he 'took a sharp gust of wind from the left and ground looped the aircraft.'NTSB SEA84LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Redmond, ORDuring a precautionary landing the aircraft encountered a 180 degree windshift during rollout. The aircraft nosed over as a result of the resulting tailwind.NTSB SEA83LA166Accident · No injuriesLimited investigationFinal reportCessna 182E · Agness, ORThe pilot said that he overflew the rwy twice to look for cattle. On the third approach during short final cattle began crossing the rwy in use. The pilot maneuvered to use the other rwy and stalled at about 25 ft AGL. Due to the acft's low alt & high…NTSB SEA83LA161Accident · No injuriesLimited investigationFinal reportCessna 182A · Sheridan, ORThe acft lost power on final approach to land and made contact with a fence short of the rwy and nosed over. During preflt the pilot had omitted checking the fuel with a fuel strainer because he did not have one. During inspection the carburetor was found to…NTSB SEA83LA104Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORAccording to the plt, he encountered a gust while landing on rwy 14 with a quartering tail wind, then lost directional control. Subsequently, the acft departed the left side of the rwy & the left gear collapsed. The tower control reported that the wind was…NTSB SEA83LA050Accident · No injuriesLimited investigationFinal reportCessna 182N · Chiloquin, ORDuring a long straight in approach from about 3 miles out the aircraft lost power. The pilot figured he could not make the runway so he tried for a highway. In diving to avoid wires he drove the nose gear onto the ground. The nose gear was sheared off and the…NTSB SEA83LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Newport, ORThe engine lost power when the pilot was on an extended base leg for landing. From that position, he could not glide to the runway, so he elected to land on a nearby beach. The location of people walking on the beach prevented an upwind landing, so the pilot…NTSB SEA83LA010Accident · No injuriesLimited investigationFinal reportCessna 182B · Redmond, ORThe pilot stated that during landing, the aircraft was hit with a 40 knot crosswind, which forced the aircraft into the runway. The nose gear collapsed causing structural damage T0 the aircraft.NTSB SEA82DA076Accident · Serious injuriesFinal reportCessna 182F · Medford, ORAfter takeoff, engine oil began to accumulate on the windshield and restrict forward visibility. The pilot returned to land, bounced during landing, and elected to go-around. During climbout the aircraft struck trees on rising terrain and crashed. The owner…NTSB SEA82DA073Accident · No injuriesFinal reportCessna 182QII · Cove, ORThe pilot stated that he landed heavy and was not quite straight. When the aircraft bounced the pilot attempted a go-around but the nose gear contacted a fence and the aircraft nosed over.NTSB SEA82DA035Accident · No injuriesFinal reportCessna 182P · Creswell, ORDuring preflight the pilot found water in the fuel system. After fuel drainings and sample checks were completed the pilot started the engine and initiated taxi for takeoff. During taxi and engine runup the engine stopped several times. After repeated fuel…NTSB SEA82DYK06Accident · No injuriesClosedCessna 182 · Redmond, ORNTSB SEA81DYM40Accident · No injuriesClosedCessna 182Q · Enterprise, ORNTSB SEA81DYK14Accident · No injuriesClosedCessna 182 · Bend, ORNTSB SEA81DYK12Accident · No injuriesClosedCessna 180 · Florence, ORNTSB SEA80FYM63Accident · No injuriesClosedCessna 182A · Harrisburg, ORNTSB SEA79DYM66Accident · Minor injuriesClosedCessna 182P · Condon, ORNTSB SEA79FYM41Accident · No injuriesClosedCessna 182 · Wilsonville, ORNTSB SEA79DYM03Accident · No injuriesClosedCessna 180 · Sumpter, ORNTSB SEA78FYK21Accident · No injuriesClosedCessna 182B · Azalea, ORNTSB SEA78DYM30Accident · No injuriesClosedCessna 182 · Enterprise, OR