NTSB investigations: Continental O-470 series
115 cases on aircraft whose registry engine model is Continental O-470 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, 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.\"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\" = 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."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" = 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 CHI91LA189Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Wausa, NEThe pilot's delayed decision to turn around after encountering IFR flight conditions. Factors were restricted forward visibility and power lines.NTSB LAX91LA192Accident · No injuriesLimited investigationFinal reportCessna 180 · Truckee, CAThat the pilot improperly used the flight controls and brakes to arrest the runway excursion. Contributing to this accident was encountering unfavorable winds, crosswind conditions, and lack of experience in this type of airplane.NTSB MIA91LA063Accident · Serious injuriesLimited investigationFinal reportCessna 182N · La Belle, FLThe pilot's failure to maintain altitude. A factor was the pilot's failure to obtain a weather forecast.NTSB CHI91FA026Accident · 1 fatalField investigationFinal reportCessna 182D · Walker, MIVFR flight into IMC conditions. Factors related to the accident are failure to obtain a preflight weather briefing, becoming lost/disoriented, induction air filter icing, excessive workload, and lack of total experience in type of operation.NTSB DEN90FA041Accident · 3 fatalField investigationFinal reportCessna 182P · Tom'S Place, CAContinued flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude above the ground. Factors related to the accident were: dark night, adverse weather conditions, self induced pressure, and spatial…NTSB FTW90FA033Accident · 2 fatalField investigationFinal reportCessna 182P · Slidell, LAThe pilot's initiation of the flight into known adverse weather conditions which resulted in spatial disorientation and his failure to maintain sufficient altitude over the water. Factors were: darkness and the adverse weather conditions that prevailed.NTSB ATL90FA022Accident · 1 fatalField investigationFinal reportCessna 182P · Darlington, SCThe pilot's continued VFR flight into IMC and his attempt to land the airplane under the adverse weather conditions.NTSB DEN90FA002Accident · 1 fatalField investigationFinal reportCessna 182A · Nixon, NVContinued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Inadequate preflight preflight planning/preparation by the pilot, and the…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 ATL89LA217Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mt Pleasant, SCFailure of the pilot to slow the aircraft to the proper landing speed at the proper touchdown point or go around. The weather conditions, tailwind, lack of airport facilities (UNICOM not operating and windsock damaged), wet runway/hydroplaning conditions, and…NTSB MIA89LA236Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Milton, FLFlight in known adverse weather by the pilot. Turbulence from the nearby thunderstorm was a related factor.NTSB DEN89FA149Accident · 1 fatalField investigationFinal reportCessna 182P · Steamboat Sprg., COThe plt's failure to discontinue the VFR flight when he encountered IMC; and the plt's failure to maintain adequate altitude to clear the mountainous terrain.NTSB ATL89LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Russells Point, OHThe pilot's inaccurate evaluation of weather condition, and his failure to use available weather briefing resources. As a result, the pilot encountered structural icing which covered the windscreen, blocking forward visibility.NTSB ATL89FA061Accident · 2 fatalField investigationFinal reportCessna 210B · Mt Airy, NCThe pilot attempted to locate the destination airport in instrument meteorological conditions, and his failure to maintain a sufficient altitude to avoid the terrain in the area. Factors contributing to the accident were the pilot' overconfidence in his…NTSB DEN88LA172Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Guffey, CONTSB DEN88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Logan, UTThe plt reported that he was on a flight from Colorado springs to portland, Oregon. He said he planned to refuel in the Logan/malad city, Idaho area. After crossing a ridgeline in the mountainous terrain east of Logan, the flt encountered low ceilings and…NTSB ATL88LA100Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Norwalk, OHThe plt rptd that he was cruising at 9,000 ft when he observed the EGT gauge indication dropping. The engine began to run rough and he noticed a fuel odor in the cabin. The carb air temp gauge was indicating 'well out of' the icing range. He selected carb…NTSB DEN88LA073Accident · No injuriesLimited investigationFinal reportCessna 182R · Pueblo, COThe instrument rated pvt plt was completing a personal IFR flight from telluride, Colorado, to Colorado springs, Colorado, with three pax. The destination wx went below IFR minimums prior to the flight's arrival and the aircraft diverted to Pueblo, Colorado,…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 SEA88FA024Accident · 2 fatalField investigationFinal reportCessna 180G · Cambridge, IDDuring a fuel stop at elko, NV the pilot requested a weather briefing for VFR flight to lander, WY or to couer d'alene, ID. The FAA fss briefed him on adverse weather to both destinations, with flight advisories for mountain obscurations, occasional severe…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 DEN87LA163Accident · No injuriesLimited investigationFinal reportCessna 182M · Livingston, MTThe plt and an observer were conducting a search and rescue flt near the face of crazy mountain. The plt reported encountering a downdraft and the acft inadvertently stalled. The acft hit trees near the ridge line.NTSB LAX87LA180Accident · No injuriesLimited investigationFinal reportCessna 182M · Mammoth Lakes, CAAt the end of a pleasure cross country flt, while on long final to the rwy, the plt had to add pwr to compensate for a crosswind. Prior to reaching short final the plt had reduced pwr again. Upon reaching the threshold, the acft was aprx 300 ft AGL. The plt…NTSB LAX87LA152Accident · No injuriesLimited investigationFinal reportCessna 182Q · Palm Springs, CADuring a pleasure cross country flt, the aircraft encountered approximately 50 knot headwinds. The plt had diverted once to refuel and had expected to fly direct to the final destination. However, while enroute on the final leg of the flight, the aircraft was…NTSB LAX87LA131Accident · No injuriesLimited investigationFinal reportCessna 180 · Oatman, AZAt the end of a cross-country flight, the pilot reported that while on final approach, the aircraft encountered moderate turbulence. The pilot set up for a full stall to land in a three point attitude. During the flare, a gust of wind from the right rear blew…NTSB SEA87LA052Accident · No injuriesLimited investigationFinal reportCessna 182R II · Spokane, WAPlt attempted instrument approach in conditions conducive to structural icing; I.e., fog, light snow, temp 32F. Acft not equipped for deice. Structural ice accretion during approach and climb-out following missed approach degraded acft performance so that…NTSB DEN86FA249Accident · 1 fatalField investigationFinal reportCessna 182G · Brighton, COAt approximately 0415 hours when it was still night time, the non instrument rated private plt took off on an extended cross country flt to Kentucky. About 15 minutes later he was observed flying in a left turn, at an attitude of 50 to 75 feet in heavy fog…NTSB MKC86FA139Accident · 4 fatalField investigationFinal reportCessna 182J · Hartford, ARWhen the acft did not arrive at its destn, a search was initiated. The wreckage was located 4 days later where the acft crashed in mountainous terrain. An investigation revealed there was severe thunderstorm activity in the area at the time of the accident.…NTSB DEN86FA071Accident · 1 fatalField investigationFinal reportCessna 180 · Kalispell, MTThe plt received a wx briefing and filed an IFR flt plan to Boeing field, seattle, WA. He departed Kalispell, MT, at 1135 MST. When the plt arrived in the spokane area, he obtained wx reports for seattle and decided to turn around and return to Kalispell. Wx…NTSB LAX86LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Lake Havasucity, AZOn January 25, 1986 a Cessna 182 collided with the runway surface after the nose wheel collapsed on runway 5 at lake havasu city airport, Arizona. VMC prevailed at the time with the UNICOM reported winds from 270 degrees at 17 knots and gusting. The…NTSB DEN86FA038Accident · 2 fatalField investigationFinal reportCessna C-182 · Gallup, NMThe plt departed las cruces, NM, on a VFR flt to Gallup,NM. Approx 23 miles from destination, in mountainous terrain, the non-instrument rated plt encountered unforecast snow storm conditons at night. While the plt was maneuvering toward the destination at a…NTSB NYC86LA036Accident · No injuriesLimited investigationFinal reportCessna C182 · Gardiner, NYThe acft contacted power lines on final apch and descended uncontrolled to ground impact. The plt reported that turbulence was encountered when he entered the traffic pattern. He then proceeded onto final apch at a 'normal altitude'and full flaps were added.…NTSB ATL86FA025Accident · 2 fatalField investigationFinal reportCessna 182Q · Edenton, NCThe aircraft crashed into the abermarle sound and sank in 18 ft of water. The pilot was reportedly on an NDB approach and descended below mda. Witnesses stated that the aircraft circled over head about 15 minutes prior to the accident. Witnesses also stated…NTSB FTW86FA011Accident · 2 fatalField investigationFinal reportCessna 180 · Cisco, TXNon-instrument rated pvt pilot proceeded into instrument weather conditions. Control was lost and the aircraft impacted steep nose down in city limits. No record of a wx briefing being received by the pilot was found. No evidence of pre- impact failure or…NTSB DEN86FA009Accident · 4 fatalField investigationFinal reportCessna 180 · Eagle, COThe plt departed Eagle arpt with 3 pax to fly them to the white owl lake area for the reported purpose of looking for a possible camping site for hunting activities. The plt encountered IMC and lost control of the acft. He was not instrument rated. All…NTSB DEN85FA203Accident · 2 fatalField investigationFinal reportCessna C-182 · La Salle, COThe plt and his girlfriend t/o from a pvt airfield north of denver co in a C182 in heavy fog conditions. The pilot was not inst rated. Shortly after t/o the aircraft hit the ground and was destroyed. Both occupants rec'd fatal injuries.NTSB FTW85MA297Accident · 3 fatalMajor investigationFinal reportBeech H35 · El Reno, OKThe acft took off at 1054 CDT in VMC with no flt plan. At that time, there was a rprtd ceiling of 1800 ft. at 1112 CDT, the plt rprtd he was at 10,000 ft, 'just reaching the tops.' At 1137 CDT, he stated 'we're about 60 west of oke city, westbound to sayre…NTSB ATL85FA113Accident · 2 fatalField investigationFinal reportCessna 182 · Le Banon, VAThe acft impacted trees and came to rest 400 ft downslope from the top of clinch mountain. The non-instrument rated plt departed sprinfield, MO, with a ceiling of aprx 300-400 ft AGL. The plt then landed at cookeville, TN, where he received a wx briefing and…NTSB FTW85LA098Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Abilene, TXDeteriorating wx was encountered & the plt elected to land short of the original destn. He was provided vectors for an ILS apch to rwy 35R at abiline, TX. During the night apch, he encountered strong gusty winds, severe turbulence & restricted visibility. The…NTSB MKC85LA043Accident · No injuriesLimited investigationFinal reportCessna 182P · Ellisonore, MOPlt obtained wx briefing for route from moline, IL, st. louis, MO, memphis, TX, to new orleans, LA. Plt was informed vfrwas not recommended in eastern Iowa but st. louis was VFR and forecast to be 1000 to 2000 ft broken to scattered all morning. VFR was also…NTSB LAX85FA093Accident · 5 fatalField investigationFinal reportCessna 182P · Big Bear City, CAThe acft crashed in a mountainous area while on a VFR personal flt to long beach, CA. The non-instrument rated private plt & 4 minor children aboard the acft were killed. By low clouds & there were extensive snow showers in the arearea the plt's log book…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 MKC85FA008Accident · 2 fatalField investigationFinal reportCessna 182F · Hiattville, KSThe acft crashed during a night x-country flt. Ground witnesses who saw the flash from the ground impact stated that there was a thunderstorm in the area at the time of the accident. They also stated that they had difficulty in locating the wreckage due to…NTSB DEN84FA155Accident · 1 fatalField investigationFinal reportCessna 180H · Broadus, MTDuring the initial takeoff climb in a westerly direction a severe wind gust from the south occurred at an alt of aprx 150 AGL. The plt turned the acft to the south and a rapid increase in alt of aprx 60-70 ft occurred. The wind stopped suddenly and the acft…NTSB ANC84LA057Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe plt encountered IMC wx conditions & elected to make a water landing. Also, he stated that he encountered a white-out condition just prior to landing. Shortly after touching down, the acft struck a sand bar & nosed over.NTSB ATL84FA141Accident · 2 fatalField investigationFinal reportCessna 182Q · Nw.Of Abingdon, VAThe acft crashed into a mountain at the 4000 ft level about 100 ft below the crest en route to chattanooga, TN. The plt had received a pre-flt telephonic briefing that was considered current and appropriate for the flt without any special remarks. At…NTSB LAX84FA189Accident · 1 fatalField investigationFinal reportCessna 182P · Livermore, CAWhile on a night x-country flt, the acft collided with the ground near the top of hilly terrain at an elevation of about 1840 ft. the time of the accident was not known, but the acft had departed groveland, CA at sometime between 1900 & 1930 PST. Witnesses in…NTSB LAX84FA152Accident · 1 fatalField investigationFinal reportCessna 182Q · Soledad, CAThe acft crashed into the side of a hill at about 1500 ft MSL in a 50 degree nose down attitude. The plt had encounteredweather on a night VFR flt. He was attempted to return the acft for a scheduled club flt the next morning. He had previously planned an…NTSB ATL84LA081Accident · Serious injuriesLimited investigationFinal reportCessna 182M · Dalton, GAPlt received a wx briefing aprx 1 hr prior to flt during which '...a chance of light icing' was forecast. Aprx 30 mins after takeoff at 6000 ft MSL light rain was encountered. The plt stated that a small amount of ice began to form on the strut and he…NTSB DEN84LA069Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Alamosa, COThe plt reported the wx deteriorated en route & he decided to land at a small arpt due to the fog & poor visibility. The arpt beacon was operating, but the rwy lights were not illuminated. During a 2nd apch, he encountered fog & started to go-around. The acft…