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 DEN87LA208Accident · No injuriesLimited investigationFinal reportCessna 180 · Broomfield, COPlt was conducting test flt following maint on tailwheel due to shimmy. On final landing acft control was lost at apx 20 KTS due to tailwheel jam. Acft departed side of rwy and left main gear collapsed causing substantial damage to airframe. Tailwheel jam was…NTSB NYC87FA215Accident · 4 fatalField investigationFinal reportCessna 182Q · Sparta, NJThe acft was observed to fly near power lines, then roll inverted, crash & burn in a wooded area. The 4 occupants rcvd multiple impact injuries which were fatal. The acft was destroyed by the impact & post crash fire. Svrl witnesses rprtd the eng power was…NTSB SEA87LA153Accident · No injuriesLimited investigationFinal reportCessna 182A · Sunnyside, WAThe plt rprtd that when he was lndg on rwy 25, the sun was just above the horizon & shining directly down the rwy. He said he misjudged the distance to the ground & lndd hard on the nose gear. Subsequently, the nose gear collapsed, the acft veered off the…NTSB CHI87LA181Accident · No injuriesLimited investigationFinal reportCessna 182J · Lansing, ILWhile landing on runway 27, the pilot overshot the runway and rolled into a shallow ditch.NTSB ANC87LA111Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Nikolai Creek, AKThis pilot stated he did not fully understand crosswind operating procedures. When he encountered a crosswind during takeoff he allowed the aircraft to drift to the left off the runway and groundlooped.NTSB ANC87FA110Accident · Minor injuriesField investigationFinal reportCessna 182P · Anchorage, AKThere was hvy traffic when the plt of N1946M contacted Anchorage (anc) intl twr for lndg instrns at the lake hood strip. Anc twr ctld traffic at the nrby lake hood strip & lake hood seaplane base, as well as at the anc intl arpt. The wnd at lake hood had been…NTSB LAX87LA278Accident · No injuriesLimited investigationFinal reportCessna 182A · Strathmore, CADuring a cross country flight, upon landing, the aircraft touched-down approx 500 ft from the approach end of the rwy. The plt lost directional control of the acft when he stated that the brakes failed to respond. The runway on which the acft landed is approx…NTSB ATL87LA217Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAPIC dpted, intending to fly 0.5 hours on tach. Acft had 11 gals of fuel, 5 in left tank & 6 in right tank. PIC made left climbing spiral to 9000 feet and maneuvered in left turn around airport. On a long staight in, final appch eng quit at about 500 feet AGL.…NTSB CHI87LA170Accident · No injuriesLimited investigationFinal reportCessna 182C · Clio, MIThe plt stated he departed with 55 gals of fuel. After 3.5 hrs of level flt at 7500 ft MSL he declared fuel exhaustion to the FAA flint twr. He was 3-4 miles frm a suitable arpt but was too low on final to reach the rwy. He landed on a road and struck a pole…NTSB CHI87FA162Accident · 5 fatalField investigationFinal reportCessna 180 · New Brighton, MNWitnesses observed the floatplane start a climbing left turn shortly after becoming airborne from a water takeoff. The aircraft's right wing dropped and the aircraft dove into the water where it struck the surface right wing first, flipped inverted and sank.…NTSB LAX87LA263Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Keams Canyon, AZDuring a business flight to a private dirt strip, while on final approach the plt was distracted for a few seconds. When his attention was back on the acft, it had drifted east of the strip. The plt applied pwr, however, he stated that the engine did not…NTSB SEA87LA134Accident · No injuriesLimited investigationFinal reportCessna 182 · Sprague River, ORA hard, flat, bounced landing occurred collapsing the nose gear and damaging the firewall.NTSB ANC87LA087Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Chistochina, AKDuring a telephone interview the pilot stated the aircraft did not produce full power and believed the reason was the propeller setting was not set to high RPM before landing. The aircraft stalled on final approach to the airport and the aircraft impacted the…NTSB MIA87LA194Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Opa Locka, FLThe plt stated that he was on a long final apch for Opa Locka airport & he lost all power. During a forced landing in an open field he struck a pile of logs, collapsing the nose gear. Post crash run of the eng revealed no evidence that would suggest a failure…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 MKC87LA129Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Bull Shoals, ARThe pilot stated the winds were four to five mph from the sw as he departed and he could see thunderstorms four or five miles to the west. He overflew his destination when he saw large waves on the water. He landed in a smooth-water cove and was taxiing…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 NYC87FA192Accident · 4 fatalField investigationFinal reportCessna 182P · Ellenville, NYThe acft collided with rising terrain in a mountainous area of minnewaska state park while climbing to cruise on a VFR flight. The crash site was about 1,430 feet higher in elevation than the departure airport. The weather at the departure airport was 1000…NTSB FTW87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Alice, TXThe pilot stated that during landing roll the right brake locked, the aircraft exited the runway, crossed a grassy area and collided with an airport light pole. Inspection of the brakes, rudder and nose wheel steering revealed no preimpact mechanical…NTSB CHI87FA151Accident · 2 fatalField investigationFinal reportCessna 182D · Marine City, MIA witness rprtd that drg takeoff, the acft rotated to a steep (nose up) attitude, & immediately after lift-off, the plt made a steep left turn & entered a downwind for lndg on the same rwy. He described the downwind as being a little tighter than normal & a…NTSB ANC87LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe private pilot elected to land at an abandoned arpt on an unmaintained dirt taxiway adjoining the gravel rwy inorder to reduce the crosswind component. The acft hit a soft spot during the landing roll and nosed over. The U.S. Dept of commerce's Alaska…NTSB NYC87LA153Accident · No injuriesLimited investigationFinal reportCessna 182 · Ellington, CTThe pilot stated that while making a standard left traffic pattern, the wind at the north end of the airport shifted from the southeast to the northwest. The acft touched down with excessive ground speed, ran off the end of the rwy and came to rest on a…NTSB NYC87LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Honeoye Falls, NYThe acft was landed on a 1695 ft turf runway with dew covered grass that was aprx 3 inches tall. After touchdown, the plt applied brakes, but the acft skidded about 1000 ft, went off the dep end of the rwy & collided with a trailer. The trailer was moved…NTSB ANC87LA071Accident · No injuriesLimited investigationFinal reportCessna 182A · Talkeetna, AKThe pilot was tardy when deciding to abort the takeoff attempt from a rough short strip. The airplane ran into soft over-run and nosed over.NTSB SEA87LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Orvado, NVDuring landing roll the aircraft's left main gear struck a hole on the gravel runway. The aircraft when veered to the left of the runway onto soft terrain. The nose gear broke off with the aircraft nosing over inverted.NTSB ANC87LA068Accident · No injuriesLimited investigationFinal reportCessna 305 · Port Heiden, AKThe pilot attempted a landing on the beach. After the landing roll the aircraft struck a sand bar causing the aircraft to nose over on its back.NTSB LAX87LA193Accident · No injuriesLimited investigationFinal reportCessna 180 · Fullerton, CAThe pilot reported that a gust of wind turned the aircraft left just prior to touchdown on runway 24. He was unable to maintain directional control during the landing roll and the aircraft ran off the left side of the runway. The reported surface winds were…NTSB DEN87LA108Accident · No injuriesLimited investigationFinal reportCessna 182C · Conde, SDThe private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on…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 LAX87LA166Accident · No injuriesLimited investigationFinal reportCessna 310 · Agua Dulce, CAThe non-multiengine rated pilot attempted to land his multiengine airplane on a 4600 foot runway. The aircraft touched down approximately half way down the runway and slid off the departure end. The aircraft impacted trees after departing the runway.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 MIA87LA112Accident · No injuriesLimited investigationFinal reportCessna 182C · Branford, FLThe plt was unable to locate his postion, & with wx conditions deteriorating & darkness approaching, elected to land in a field. Upon touchdown, the nose gear broke off, the acft nosed over & came to rest inverted.NTSB MKC87LA061Accident · No injuriesLimited investigationFinal reportCessna 182J · Archie, MOThe plt stated that, after refueling with auto gas at the pvt airstrip, water was found in the fuel being drained fm the sumps. After rocking the acft several times and noting no further water accumulation in the fuel samples, the plt further stated, a…NTSB ANC87LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot stated that after touchdown and about 150 feet of the roll, the pilot lost directional control causing the aircraft to exit the gravel runway and striking two parked aircraft.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 ANC87LA041Accident · No injuriesLimited investigationFinal reportCessna 180B · Palmer, AKThe pilot lost directional control while landing his tail wheel airplane in a crosswind. The pilot stated that a gust of wind lifted the right wing and he was unable to prevent the left wing from contacting the runway. The airplane eventually came to rest on…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 CHI87LA089Accident · No injuriesLimited investigationFinal reportCessna 182F · Pontiac, MIWhile the acft was being taxied to a hangar after landing, the left main gear collapsed. An investigation revealed the left main landing gear spring strut, pn 0741601-1, had failed where it was clamped to the fuselage. A metallurgical exam of the fracture…NTSB LAX87LA123Accident · No injuriesLimited investigationFinal reportCessna 182G · Vallecito, CAA Cessna 182G collided with the rwy surface after the nose gear collapsed at a private airstrip. The pilot indicated that the nose gear turned 90 degrees during the landing roll then collapsed. Pilot examined the nose gear after the accident and discovered…NTSB NYC87LA088Accident · Minor injuriesLimited investigationFinal reportCessna 180H · New Paltz, NYThe Cessna 180/H was departing the runway at night with two passengers on board. The pilot lost control of the aircraft as the tail came up and veered left into a snow bank. After striking the left snow bank, the aircraft veered right and struck the right…NTSB ATL87LA072Accident · No injuriesLimited investigationFinal reportCessna 182R · Mobile, ALThe student plt was making a second attempt to land after a hard ldg, bounce, and subsequent go-around. On the first attempt, the acft touched down hard on all three wheels and swerved to the rt. The student plt reportedly pulled the nose up and the acft…NTSB CHI87LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Utica, MIThe pilot experienced a loss of power to 900 RPM shortly after takeoff. The plt had climbed to 2000 ft and reduced power. When the RPM dropped to 900 RPM he applied carb heat to no avail. The acft was landed in a field 6 miles north of the departure arpt.…NTSB MKC87LA047Accident · No injuriesLimited investigationFinal reportCessna 182C · Rolla, MOThe engine started running rough enroute and pilot was able to get it running smoothly but he continued to his destination. Airplane was too high on approach so pilot went around. On downwind, engine started running rough again and pilot was unable to correct…NTSB ANC87LA034Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Paxson, AKThe pvt plt took off at night and flew into instrument conditions. He had failed to unlock the direction gyro until the acft entered the clouds. The acft crashed 32 miles from the departure point due to fuel exhaustion. Automotive fuel was being used in the…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 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 ANC87LA026Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKAfter takeoff and during the initial climbout, the pilot lost directional control of the aircraft causing the aircraft to stall. The aircraft struck a row of trees at the departure end of the runway. The plts flt time was not reported or available.NTSB LAX87FA077Accident · 1 fatalField investigationFinal reportCessna 182Q · Essex, CAUpon reaching his destination the pilot descended to make a message drop. He selected a flight path that was perpendicular to a 55 foot tall, unmarked, electrical power line. During the low pass for the drop the aircraft collided with the electrical wires.…NTSB ATL87DEI01Accident · Serious injuriesFinal reportCessna 180 · Wadsworth, OHThe airplane reportedly completed an NDB appch to rwy 02. The plt reported that he circled the rwy twice after arriving at the arpt to check the rwy condition. He subsequently landed on rwy 20 where he 'impacted something on runway or hit air pocket, did not…NTSB NYC87LA053Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Goffstown, NHThe Cessna 180 made a touch and go on a 2100 ft long runway. The touchdown was described as past the first third of the runway. There were two rated pilots and a passenger in the aircraft. The co-pilot thought the aircraft would be unable to clear powerlines…