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 LAX90LA222Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fresno, CAFuel exhaustion due to the pilot's inadequate pre-flight planning.NTSB ATL90LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Woodstock, GAAn inadequate preflight.NTSB DEN90LA105Accident · No injuriesLimited investigationFinal reportCessna C-180E · Helena, MTThe malfunction of the tail wheel assembly.NTSB ANC90LA064Accident · No injuriesLimited investigationFinal reportCessna 180C · Anchorage, AKThe pilot failed to maintain directional control of the airplane.NTSB LAX90LA159Accident · No injuriesLimited investigationFinal reportCessna 182L · Bullhead City, AZThe pilot's preflight planning/preparation and fuel calculations were poor.NTSB MIA90LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Crystal Springs, MSPilots failure to assure that the fuel cap was in position and secured prior to departure. This resulted in fuel siphoning overboard resulting in the precautionary landing.NTSB ATL90LA103Accident · No injuriesLimited investigationFinal reportCessna 182 · Griffin, GAImproper flare by the pilot.NTSB DEN90LA098Accident · No injuriesLimited investigationFinal reportCessna 310B · Elizabeth, COThe pilot's attempt to takeoff with a known deficiency and the partial failure of the propeller feathering system.NTSB LAX90LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Soledad, CAPilot's failure to maintain directional control during takeoff. Contributing factors were the gusty wind and the crosswind conditions.NTSB SEA90FA064Accident · 3 fatalField investigationFinal reportCessna 182M · North Bend, ORThe pilot did not follow the published IFR procedure.NTSB LAX90LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Concord, CAThe pilot in command to properly judge the timing of the landing flare.NTSB ANC90LA044Accident · No injuriesLimited investigationFinal reportCessna 180J · Lake Nikabuno, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB ANC90LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot failed to maintain directional control during landing. Contributing factors were the rough terrain, and the pilot's lack of total and recent experience in that model airplane.NTSB DEN90LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Delta, COA deteriorated fuel line.NTSB ATL90LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Louisburg, NCThe pilot's failure to maintain directional control of the airplane during the take off roll.NTSB LAX90LA077Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's inadequate visual lookout.NTSB ANC90LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKImproper installation of the gear axle (use of improper bolts & the wrong number of shims), which resulted in a subsequent failure and loss of control during the landing roll.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 LAX90LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Santa Ysabel, CAThe pilot's attempt to conduct visual flight into instrument meteorological conditions. Low ceilings and mountainous terrain were factors.NTSB FTW90LA068Accident · No injuriesLimited investigationFinal reportCessna 180J · Austin, TXThe pilot in command's failure to maintain directional control of the airplane during a downwind landing. Contributing to the accident was the pilot's lack of total experience in this type airplane.NTSB DEN90LA052Accident · No injuriesLimited investigationFinal reportCessna 180C · Haugan, MTThe failure of the pilot to maintain directional control during the takeoff attempt. A factor in the accident was the icy, snow covered condition of the takeoff area.NTSB ANC90FA032Accident · Minor injuriesField investigationFinal reportCessna 182 · Anchorage, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: the obstructions (utility pole, power line & fence) in the emergency landing area.NTSB LAX90LA075Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Palos Verdes, CALoss of engine power for undetermined reasons.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 LAX90FA068Accident · 1 fatalField investigationFinal reportCessna 182P · Napa, CAThe failure of the pilot to properly execute the published approach and missed approach which resulted in a collision with mountainious terrain.NTSB ATL90FA040Accident · 1 fatalField investigationFinal reportCessna 182 · Cincinnati, OHFailure of the Cessna pilot to remain clear of the helicopter after experiencing a partial power loss.NTSB ANC90LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Chakachamna Lk, AKInadequate preflight preparation of the takeoff area by the pilot, and his attempt to take off on unsuitable terrain. The soft/snow covered terrain was considered to be a contributing factor.NTSB ANC90LA016Accident · No injuriesLimited investigationFinal reportCessna 180 · Alexander Lake, AKSelection of unsuitable terrain by the pilot. The snow covered terrain was a related factor.NTSB MKC90LA035Accident · No injuriesLimited investigationFinal reportCessna 180 · St. Louis, MOThe pilot's failure to adequately compensate for the wind. The gusty, crosswind condition is considered a contributing factor to the accident.NTSB ANC90LA013Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadequate preflight preparation and failure to identify suitable terrain for takeoff.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 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 SEA90LA014Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot failed to adequately compensate for tailwind conditions when landing on a short wet runway.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 NYC90LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Lowell, MAThe failure of the pilot to assure that the float wheels were retracted prior to a water landing. A contributing factor was the extension of the left float wheels for an undetermined reason.NTSB FTW90LA019Accident · No injuriesLimited investigationFinal reportCessna 182J · Leesville, LAThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was: the lack of a suitable landing area.NTSB ATL90LA011Accident · No injuriesLimited investigationFinal reportCessna 182Q · Cumming, GAA lack of fluid in the brake system and an inadequate annual inspection.NTSB NYC90LA012Accident · No injuriesLimited investigationFinal reportCessna 180H · Niagara Falls, NYThe pilot's loss of directional control during takeoff roll due to strong wind gusts.NTSB MKC90LA007Accident · No injuriesLimited investigationFinal reportCessna 182 · Hasty, ARThe engine failure due to fuel starvation resulting from the collapse at the fuel cell. The fact that the forced landing was made in dark night conditions was a factor.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 LAX89LA332Accident · No injuriesLimited investigationFinal reportCessna 182 · Eureka, CAImproper flare by the student, and a delay in remedial action by the instructor (CFI).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 ANC89LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Redoubt Bay, AKImproper planning/decision by the pilot. Factors related to the accident were: the unfavorable runway and terrain conditions.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 FTW89DRD15Accident · Serious injuriesFinal reportCessna 188 · Winnsboro, LAThe pilot's inadequate visual lookout and subsequent collision with a tree.NTSB ANC89LA161Accident · No injuriesLimited investigationFinal reportCessna 180 · Yakataga, AKThe pilot failed to maintain directional control and inadvertently allowed the aircraft to ground loop. The tailwind was a contributing factor.NTSB LAX89LA302Accident · No injuriesLimited investigationFinal reportCessna 180 · Santa Ana, CAThe pilot's improper in-flight planning after being advised of possible wake turbulence.NTSB DEN89LA215Accident · No injuriesLimited investigationFinal reportCessna 180K · Englewood, COFailure of the pilot to maintain directional control, which resulted in a ground swerve. The crosswind was a related factor.NTSB ANC89FA155Accident · Minor injuriesField investigationFinal reportCessna 180 · Anchorage, AKOil leak in the oil cooler. Contributing factors were: oil film on the windshield, which obscured the pilot's vision (visual perception) and hampered his ability to attain proper runway alignment, an object (rock), and high vegetation beside the airstrip.NTSB DEN89LA211Accident · No injuriesLimited investigationFinal reportCessna 182L · Moab, UTInadequate compensation for the wind conditions by the pilot, and his failure to attain a flare. The unfavorable (variable & gusty) wind condition was a related factor.