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 LAX08CA250Accident · No injuriesData collectionFinal reportCessna 182N · Big Creek, IDThe airplane encountered a downdraft during the landing flare. Contributing to the accident was the high density altitude.NTSB SEA08CA166Accident · No injuriesData collectionFinal reportCessna 180 · Lewistown, MTThe pilot's inadequate compensation for the variable and gusting winds, and his failure to maintain directional control. Contributing to the accident were variable winds that were gusting to 25 knots.NTSB LAX08CA225Accident · No injuriesData collectionFinal reportCessna 182J · Metaline Falls, WAThe pilot's misjudged altitude and distance, which resulted in the airplane's failure to attain the proper touchdown point and a landing overrun. Contributing to the accident were trees and the short runway.NTSB LAX08CA218Accident · No injuriesData collectionFinal reportCessna 180G · Heber, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was the crosswind weather conditions.NTSB LAX08CA238Accident · No injuriesData collectionFinal reportCessna 182J · Yellow Pine, IDThe pilot's non-stabilized approach that resulted in an improper flare and porpoise down the runway.NTSB LAX08CA245Accident · No injuriesData collectionFinal reportCessna 180 · Atlanta, IDThe pilot's misjudged speed and distance during the intentional touchdown in the last half of the runway, which resulted in a landing overrun. Contributing to the accident was the muddy runway condition.NTSB LAX08CA174Accident · Minor injuriesData collectionFinal reportCessna 182 · Cottage Grove, ORThe pilot's misjudged landing flare.NTSB LAX08CA167Accident · No injuriesData collectionFinal reportCessna 182 · Moab, UTThe pilot's inadequate compensation for the tailwind condition, and improper use of additional power while taxiing. Contributing to the accident was soft ground and a gusting tailwind.NTSB CHI08CA155Accident · No injuriesData collectionFinal reportCessna 180 · Eveleth, MNThe pilot elected to land on a grass airstrip that was unsuitable for landing due to the wet, soft runway conditions. The wet, soft runway were factors.NTSB SEA08LA139Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Chehalis, WAA loss of engine power due to fuel exhaustion caused by a missing fuel tank cap that allowed the fuel to be siphoned out. Also causal was the pilot's inadequate preflight inspection at the last airport.NTSB LAX08LA140Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Maria, CAThe pilot's impairment from alcohol and his improper flare, which resulted in a bounced landing. Contributing to the accident was the FAA's failure to obtain additional information about the pilot's alcohol use history to verify that he met the requirements…NTSB DFW08FA131Accident · 1 fatalField investigationFinal reportCessna 182 · Black Hawk, COThe loss of engine power due to induction icing. A contributing factor was the pilot's decision to continue flight in conditions favorable for structural and induction-system icing.NTSB MIA08LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Louisville, KYA total fatigue failure of the No. 5 piston during climb.NTSB LAX08LA127Accident · No injuriesLimited investigationFinal reportCessna 182H · Prescott, AZA loss of engine power from fuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.NTSB CHI08CA117Accident · No injuriesData collectionFinal reportCessna 182D · Madison, INThe inadequate preflight inspection of the landing gear tires by the pilot, which did not identify a worn tire and resulted in a flat tire during landing touchdown. An additional cause was the directional control not possible during the landing rollout, and…NTSB SEA08LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Blanding, UTThe fatigue failure of the right main landing gear leg during the landing roll.NTSB CHI08LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Romeo, MIThe misjudged landing flare by the pilot, and the inadequate landing gear inspection/repair procedure used by other maintenance personnel, resulting in the failure of the main landing gear strut during landing.NTSB ANC08LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Kodiak, AKA loss of control during the landing roll due to a failure or malfunction of the brake system, resulting in a loss of control, and structural damage to the airplane.NTSB MIA08CA151Accident · No injuriesData collectionFinal reportCessna 182P · Salisbury, NCThe student pilot's improper flare during landing.NTSB DEN08CA075Accident · No injuriesData collectionFinal reportCessna 182N · Amarillo, TXThe pilot's failure to maintain aircraft control during the landing. Contributing to the accident were the crosswind, gusty wind conditions and the pilot's inadequate compensation for the wind conditions.NTSB DFW08CA096Accident · No injuriesData collectionFinal reportCessna C-182 · Porter, TXThe pilot's loss of directional control due to the partial failure of the left brake.NTSB CHI08CA094Accident · No injuriesData collectionFinal reportCessna 182 · Traverse City, MIThe unstabalized approach performed by the student pilot and the go-around not performed by the student pilot. Additional causes were the inadequate recovery from a bounced landing and the directional control not obtained by the student pilot. Contributing…NTSB ANC08CA044Accident · No injuriesData collectionFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control and inadequate compensation for wind conditions during a go-around. Contributing to the accident were wind gusts and a crosswind.NTSB LAX08CA079Accident · No injuriesData collectionFinal reportCessna 180H · Moab, UTThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. A contributing factor was the unexpected dust devil.NTSB DEN08LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Glenwood Spring, COThe pilot's failure to maintain directional control of the airplane during landing. Contributing to the accident was the strong left quartering tailwind and gust.NTSB ANC08LA042Accident · Minor injuriesLimited investigationFinal reportCessna 180 · White Mountain, AKThe pilot’s inadvertent flight into flat light/whiteout conditions over snow-covered terrain.NTSB SEA08LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Moab, UTThe pilot's failure to maintain directional control of the tail wheel-equipped airplane during the flare/touchdown phase of a three-point landing.NTSB NYC08CA101Accident · No injuriesData collectionFinal reportCessna 182K · Greenville, METhe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the snow covered runway and sun glare light conditions.NTSB LAX08LA060Accident · No injuriesLimited investigationFinal reportCessna 305-A · Mokuleia, HIThe failure of the left main landing gear strut due to fatigue. Contributing to the failure was the side load placed on the landing gear while making a crosswind landing.NTSB DEN08LA057Accident · No injuriesLimited investigationFinal reportBeech A45 · Englewood, COThe pilot's improper decision to fly the airplane with a discharged battery, which resulted in a total electrical failure during takeoff climb. Contributing factors were the pilot's inability to verify the landing gear position, and the impact with the runway…NTSB NYC08LA070Accident · No injuriesLimited investigationFinal reportCessna 182R · Pittstown, NJA loss of engine power for undetermined reasons.NTSB DFW08CA049Accident · No injuriesData collectionFinal reportCessna 182 · Austin, TXThe pilot's failure to maintain directional control while landing. A contributing factor was the gusting winds.NTSB DFW08LA134Accident · 2 fatalLimited investigationFinal reportCessna 310 · Glenwood, NMA loss of control for undetermined reasons. Contributing to the accident was the marginal weather conditions in the area at the time of the accident.NTSB NYC08FA056Accident · 1 fatalField investigationFinal reportBeech H35 · Warrenton, VAThe pilot's failure to follow the published instrument approach procedure and his failure to maintain the minimum descent altitude which resulted in collision with trees and terrain. Contributing to the accident were the night, instrument meteorological…NTSB SEA08CA044Accident · No injuriesData collectionFinal reportCessna 182 · Spokane, WAThe loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the fence.NTSB DEN08FA036Accident · 1 fatalField investigationFinal reportCessna 182Q · Farmerville, LAThe pilot's failure to maintain aircraft control due to the effects of impairment from alcohol consumption resulting in the collision with the trees.. A contributing factor was the Federal Aviation Administration's failure to identify existing evidence of…NTSB SEA08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tacoma, WAThe failure of both pilots to maintain an adequate visual lookout during cruise flight.NTSB NYC08CA035Accident · Minor injuriesData collectionFinal reportCessna 180 · Orlando, FLThe pilot's loss of control on the water after landing, which resulted in the bow of the right float submerging , and a nose-over event.NTSB CHI08CA042Accident · Minor injuriesData collectionFinal reportCessna 180 · Becker, MNThe pilot maintained excessive airspeed during the landing approach and failed to achieve a proper touchdown point. A factor associated with the accident was the fence that the airplane contacted.NTSB NYC08CA016Accident · No injuriesData collectionFinal reportCessna 182 · Hendersonville, NCThe pilot's failure to calculate weight and balance prior to departure, which resulted in departure above the maximum allowable gross weight, and the airplane's inability to climb. Contributing to the accident was the high density altitude.NTSB LAX08CA017Accident · No injuriesData collectionFinal reportCessna 182P · Troutdale, ORThe pilot's inadequate compensation for the tailwind condition and failure to maintain an adequate airspeed.NTSB LAX07CA286Accident · No injuriesData collectionFinal reportCessna 182F · Bakersfield, CAThe pilot's inadequate preflight inspection and pretakeoff checks during which he failed to remove the gust lock.NTSB ANC07FA102Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe failure of the pilot's seat to engage, or remain engaged, and the pilot's inadvertent stall/mush during takeoff-initial climb. Contributing to the accident was the failure of maintenance personnel to comply with an FAA AD regarding the pilot's seat rails.NTSB DEN07CA162Accident · Minor injuriesData collectionFinal reportCessna 182Q · Glenwood Spring, COThe pilot's failure to go around when it became apparent that he could not land and stop the airplane on the remaining runway. Factors contributing to the accident were the tailwind and the gusts.NTSB DEN07CA161Accident · No injuriesData collectionFinal reportCessna 182P · Santa Rosa, NMThe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB DEN07FA157Accident · Serious injuriesField investigationFinal reportCessna 180 · Englewood, COThe pilot's failure to maintain control of the airplane during the force landing attempt resulting in a stall-spin and the subsequent impact with the ground. A factor contributing to the accident was the engine failure for undetermined reasons.NTSB SEA07LA255Accident · No injuriesLimited investigationFinal reportCessna 182G · Fairfield, IDThe loss of engine power as a result of fuel exhaustion due to the pilot's inadequate preflight inspection. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX07CA265Accident · No injuriesData collectionFinal reportCessna 182P · Fall City, WAThe pilot's failure to maintain directional control.NTSB CHI07CA284Accident · No injuriesData collectionFinal reportCessna 182P · Eau Claire, WIThe pilot's failure to maintain directional control of the airplane during the landing roll. A factor associated with the accident was the ditch.NTSB SEA07CA236Accident · No injuriesData collectionFinal reportCessna 182R · Redding, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun and collision with a fence.