NTSB investigations: Continental O-470 series
6,204 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.\"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."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 DEN88LA104Accident · No injuriesLimited investigationFinal reportBeech H35 · Ruidoso, NMNTSB SEA88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Elko, NVDuring landing roll the pilot lost directional control of the aircraft with a groundloop resulting. The pilot had a total time of 17 hours in this type of aircraft and 152 hours total flight time.NTSB FTW88LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Lamont, OKThe pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was…NTSB DEN88LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Great Falls, MTThe private plt was returning home from a personal transportation flight with one pax, another private plt. Both men reported that while on final for rnwy 25, the sun was in their eyes and hindered their vision. The plt in command stated that he cannot…NTSB ATL88LA157Accident · No injuriesLimited investigationFinal reportCessna 180A · Danville, KYThe plt performed a wheel landing and attempted to hold the tailwheel off the runway surface with nose down elevator. The right wing began to lift and the acft veered to the right. Remedial control inputs were made and the left main landing gear axle…NTSB LAX88LA167Accident · No injuriesLimited investigationFinal reportCessna 182D · Coolidge, AZAt the end of a pleasure cross country flight, while on final approach, the engine quit. Unable to land on the runway, the aircraft was landed in a soft field where during the landing roll the aircraft nosed over. The pilot had selected the right fuel tank…NTSB ATL88LA148Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lowell, OHThe plt rptd that he landed in a 12-14 kt, 90 degree x-wind. The initial portion of the ldg rollout was shielded from the wind by a row of trees bordering part of the upwind side of the rwy. Upon reaching a clearing in the trees, the airplane was exposed to…NTSB CHI88LA100Accident · No injuriesLimited investigationFinal reportCessna 182D · Mt. Vernon, ILAfter electing to go-around on his first approach, the student pilot ballooned the aircraft as he passed over the runway on the second approach. Remedial action was attempted, but the pilot overcontrolled and the aircraft struck the runway slightly nosewheel…NTSB SEA88LA070Accident · No injuriesLimited investigationFinal reportCessna 305-A · Arlington, WAShortly after takeoff, at about 200 feet AGL, a total loss of power occurred. A forced landing was made onto a turf field next to the runway. During landing the aircraft nosed over inverted. The pilot stated to FAA inspectors that the aircraft had set outside…NTSB 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 LAX88LA124Accident · No injuriesLimited investigationFinal reportCessna 180 · Corona, CAThe plt was completing a personal flt. During the landing roll the airplane began to swerve to the left. The plt reptd the rudder was ineffective due to the airplane's slow speed and she applied the brakes. Before the airplane came to a stop the left landing…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 LAX88LA115Accident · No injuriesLimited investigationFinal reportCessna 180A · Prescott, AZDuring the dual primary cross country flight, the student was making the approach and landing at Prescott. The CFI said that the approach and touchdown were normal, however, the aircraft began drifting to the right in a gradual turn as the aircraft slowed.…NTSB MIA88IA112Incident · No injuriesIncident investigationFinal reportCessna 182 · Stuart, FLWhile on final apch to land from a banner towing flt, the eng lost power due to fuel exhaustion. The plt made an emergency landing off the airport, but the nose gear collapsed, which resulted in minor damage.NTSB SEA88LA046Accident · 2 fatalLimited investigationFinal reportCessna 305A (L-19) · Jean, NVWitnesses observed acft enter 45 deg climb attitude on liftoff, climb to about 200 ft AGL, then enter left turn. Acft appeared to stall, wing dropped and nose fell through to impact 100 yds left of runway. Flaps found set at 60 deg vs. max 30 deg setting…NTSB ANC88LA029Accident · No injuriesLimited investigationFinal reportCessna 180 · 70 Nw Anchorage, AKThe pilot stated that during the landing roll on the frozen lake he lost directional control of the aircraft due to the snow on the lake. The aircraft then nosed over on its back.NTSB DEN88LA067Accident · No injuriesLimited investigationFinal reportCessna 180 · Roundup, MTThe private plt rancher was completing a work flt. During the flt, the plt made 5 off arpt landings in snow 5 to 6 inches deep. The landing on which the accident occurred was made at a local arpt on a snow covered rwy. During the landing, the acft sank into…NTSB FTW88LA059Accident · No injuriesLimited investigationFinal reportCessna 182P · Weatherford, TXA used eng had just been installed in the acft and the owner and mech were performing a functional test flt. Shortly after takeoff at about 300 ft AGL, the eng lost power. The plt pumped the throttle and the eng restarted but immediately quit again and would…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 MIA88LA093Accident · No injuriesLimited investigationFinal reportCessna 305A · Chuluota, FLPlt stated electric boost pump was operated longer than normal during power off glide for banner pickup. After banner pickup when full throttle was applied for climb the engine sputtered and lost power. The nose was lowered in preparation for a landing…NTSB MIA88LA087Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Tampa, FLDuring the landing roll the acft veered off the rwy, travelled through a retention pond, nosed over & came to rest. According to a plt who landed shortly after the accident, he had his hands full landing on the same rwy due to a 'stiff crosswind'. The pilot…NTSB FTW88FA051Accident · 1 fatalField investigationFinal reportCessna 310 · Conroe, TXThe newly certificated private pilot, who had 55.2 hours total flight experience, was on his initial solo flight in the Cessna 310 model. His flight logbook had been endorsed for solo flight in the aircraft on November 20, 1987. Witnesses observed a rather…NTSB SEA88LA080Accident · 2 fatalLimited investigationFinal reportCessna 180 · Hailey, IDThis Cessna 180 was on a VFR flight from gooding, Idaho to Hailey, Idaho when it disappeared. The wreckage was later found in a steep canyon about 15 miles from the destination. No mechanical failures were found. Good VFR weather conditions existed at the…NTSB DEN88LA047Accident · No injuriesLimited investigationFinal reportCessna 182G · Aurora, CON3406S was landing on rwy 32, an asphalt rwy 5,000 ft long and 40 ft wide. The rwy was clear and dry, but the terrain surrounding the rwy was covered by 12 to 15 inches of snow. The wind at an arpt 5 mi sw was from 160 deg at 5 KTS. In his rpt of the acdt the…NTSB ATL88LA076Accident · No injuriesLimited investigationFinal reportCessna 182G · Lancaster, OHThe plt rptd that the airplane began to veer left almost immediately after touchdown. The airplane subsequently swerved off of the rwy. Traveled across a snow-covered grassy area, and impacted a taxiway embankment. The nose gear was found to be collapsed…NTSB MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…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 SEA88LA033Accident · 1 fatalLimited investigationFinal reportCessna 182C · Las Vegas, NVThe aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to…NTSB CHI88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlton, MNThe plt rprtd that the left main gear collapsed as he started to taxi from the ramp area on a smooth grass surface. When the gear collapsed, the left wing dropped to the ground & was substantially dmgd. The plt rprtd the left gear leg had broken off 2 inches…NTSB DEN88LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Telluride, CODuring a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and…NTSB LAX88WA068Accident · Minor injuriesForeign investigationCessna 182 · Punta Pescadero, MexicoNTSB 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 LAX88LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Laveen, AZThe pilot stated that he was ferrying his aircraft three miles to a private strip. Shortly after takeoff, the engine began losing power. The pilot did not think he could make it to the private strip so he attempted a precautionary landing on a dirt road. He…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 MKC88LA010Accident · No injuriesLimited investigationFinal reportCessna 182 · Atwood, KSThe PIC said that he did an engine runup and allowed the engine to run about 6 additional minutes before commencing the takeoff. The PIC said that upon reaching 100 feet altitude in the takeoff sequence, he observed a decline in engine revolutions per minute…NTSB CHI88FA008Accident · 4 fatalField investigationFinal reportCessna 310 · Brownton, MNAcft crashed in open farm field during night dark conditions witness heard loud roar of engs then a hard dull thud and then silence. Angle of impact was near vertical. Engs were buried 8FT and dist of wreckage was confined to within the dimensions of acft.…NTSB DEN88LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Monument Valley, UTThe private pilot was landing on a dirt runway and at touchdown a crosswind weathervaned the aircraft to the right. The pilot added full power to try to go around but the aircraft settled back to the ground left of the runway. The aircraft came to rest 300…NTSB SEA88LA004Accident · No injuriesLimited investigationFinal reportCessna 180C · Juneau, AKWhile landing onto a soft, sandy beach area the aircraft nosed over inverted. The plt failed to file an accident report.NTSB MIA88LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Church Hill, MSWhile in cruise flight at 1,000 ft, the eng lost power. The plt performed a forced landing in a soft field and during the landing roll, the acft hit a dirt bank, nosed over, and came to rest inverted. Post crash examination of the fuel system revealed that…NTSB LAX87LA345Accident · No injuriesLimited investigationFinal reportCessna 180K · San Diego, CAA Cessna 180K dragged its' wing tip during landing roll on runway 28R. The pilot indicated that he encountered a wind gust from the left raising the right wing. The pilot stated that he 'over corrected' in that when the gust subsided the aircraft rolled left…NTSB SEA87LA189Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cathlamet, WAThe pilot was making soft field takeoffs with no flaps. He lost control of the aircraft at about 10 feet AGL, the aircraft's right wing struck the ground and the aircraft came to a stop.NTSB SEA87LA183Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Star, IDThe aircraft was to the left of the centerline during takeoff run on the 60 foot wide airstrip. A cross wind was present from the right. The aircraft's left wing struck a person standing close to the runway edge. The pilot stated that he had his eyes on his…NTSB LAX87LA325Accident · 1 fatalLimited investigationFinal reportBeech A45 · Mammoth Lakes, CADuring an airshow performance, the acft collided with the terrain in a near vertical attitude. The maneuver the plt was to perform was a cuban eight. The first half of the maneuver was flown correctly, however, during the second half of it the acft remained…NTSB SEA87LA182Accident · No injuriesLimited investigationFinal reportCessna 180H · Salmon, IDWhile on approach for landing a total loss of power occurred for undetermined reasons.NTSB ANC87LA130Accident · No injuriesLimited investigationFinal reportCessna 180F · Cordova, AKThe wind was blowing from the south at approximately 15 knots gusting 30 knots. As he was turning off the runway, the pilot lost directional control of the aircraft causing the aircraft to ground loop on the taxiway.NTSB DEN87LA228Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grassy Butte, NDN2413C, a Cessna 180, was landing in teddy roosevelt national park where the plt and his passengers intended to hunt deer. A flat, Grassy area on a ridge was selected for landing. The area was checked and marked off by friends of the plt before the landing…NTSB LAX87LA319Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Glendale, AZDuring landing roll, in crosswind conditions, the aircraft left the runway and went into a ditch. During a telephone interview the pilot stated that he lost control of the aircraft. The pilot was landing on runway 01 and winds were reported to be from 090…NTSB ATL87LA242Accident · No injuriesLimited investigationFinal reportCessna 182 · St. Joseph, TNThe plt took off from an arpt that was aprx 27 mi west of his destn. After takeoff, he rcvd an inflt wx briefing & flew north of a line of thunderstorms (tstms). Before lndg at the destn, he noted tstm activity south of the arpt, but contd the apch & lndd.…NTSB DEN87LA227Accident · No injuriesLimited investigationFinal reportCessna 182Q · Albuquerque, NMThe instructor took control of the acft to make the landing due to excessive crosswind. The ip stated that the apch speed was 70 to 75 KTS. The acft was landed on the first third of runway and brakes applied with half runway remaining. Ip reported that brake…NTSB NYC87LA231Accident · No injuriesLimited investigationFinal reportCessna 172 · Islip, NYAfter landing on an instructional flight, Cessna 172, N9425D, experienced brake failure due to a broken hydraulic fluid line. N9425D rolled into another Cessna. Both aircraft received sustantial damage.