NTSB investigations: Continental O-470 series
346 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of control - on ground/water”. 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\" = 260))
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" = 260))
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 IAD04CA012Accident · No injuriesData collectionFinal reportCessna 182P · Titusville, PAThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the snow bank.NTSB ATL04LA063Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Taylorsville, NCThe pilot's failure to follow the checklist, resulting in a loss of directional control on the takeoff roll when the seat moved rearward, and on ground collision with an embankment.NTSB DEN04LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Hudson, COthe pilot's failure to maintain directional control due to an excessive crosswind component, resulting in an uncontrolled groundloop/swerve. Contributing factors were the crosswind gust and the soft, sandy terrain.NTSB DEN04LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Watkins, COThe pilot's failure to maintain aircraft control resulting in the ground loop. Factors contributing to the accident were the crosswind and the gusts.NTSB ATL04LA004Accident · No injuriesLimited investigationFinal reportCessna 180K · Starkville, MSThe pilot's failure to compensate for a crosswind condition that resulted in the loss of directional control during a landing. A factor was the crosswind condition.NTSB CHI03LA321Accident · No injuriesLimited investigationFinal reportCessna 305A · New Richmond, WIThe pilot's inadequate compensation for wind and his failure to maintain directional control. The pilot's in-flight selection of the wrong runway and excessive application of brake pressure are contributing factors.NTSB CHI03LA312Accident · Minor injuriesLimited investigationFinal reportCessna 182P · St. Louis, MOThe pilot's failure to maintain directional control during the landing rollout.NTSB LAX03CA249Accident · No injuriesData collectionFinal reportCessna 180 · St. Johns, AZThe pilot's inadequate compensation for a crosswind condition that resulted in a loss of directional control and ground loop. The crosswind was a contributing factor.NTSB DEN03LA106Accident · No injuriesLimited investigationFinal reportCessna 180 · Ogden, UTthe pilot's inadequate compensation for wind conditions and his failure to maintain directional control.NTSB SEA03LA083Accident · No injuriesLimited investigationFinal reportCessna 182J · Payette, IDThe pilot-in-command's failure to maintain directional control during the landing roll resulting in the aircraft departing the runway environment, collapsing the nose gear and nosing over. Contributing factors were the pilot-in-command's failure to execute a…NTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…NTSB LAX03LA140Accident · No injuriesLimited investigationFinal reportCessna 180J · Angwin, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control of the airplane during the landing roll.NTSB CHI03LA081Accident · No injuriesLimited investigationFinal reportCessna 180K · St Charles, MOThe pilot's inadequate compensation for wind and his failure to maintain directional control resulting in a ground loop. A factor was the crosswind.NTSB LAX03LA086Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Oceano, CAthe pilot's failure to maintain directional control of the airplane.NTSB NYC02LA150Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Ravenna, OHThe pilot's loss of directional control for undetermined reasons.NTSB CHI02LA207Accident · No injuriesLimited investigationFinal reportCessna C180A · Ogallala, NEThe pilot's failure to maintain directional control of the aircraft. The open window diverting the pilot's attention was a contributing factor.NTSB SEA02LA118Accident · No injuriesLimited investigationFinal reportCessna 182 E · Sweetgrass, MTThe pilot's failure to adequately compensate for wind conditions after encountering a crosswind gust during the landing roll. Factors include gusty crosswinds, and a fence in the vicinity of the runway.NTSB ATL02LA157Accident · No injuriesLimited investigationFinal reportCessna 182M · Brunswick, GAThe pilot's failure to maintain directional control during landing roll, which resulted in an on-ground collision with a runway sign. A factor was the pilot's inadvertent application of the right brake.NTSB SEA02LA105Accident · No injuriesLimited investigationFinal reportCessna 180K · Idaho Falls, IDThe pilot's inadequate compensation for wind conditions during the landing roll. A crosswind was a factor.NTSB ATL02LA126Accident · No injuriesLimited investigationFinal reportCessna 180 · Jacksonville, FLThe pilot's failure to maintain directional control on landing rollout resulting in an inadvertent ground loop. A factor related to the accident was the certified flight instructors inadequate supervision of the training flight.NTSB SEA02LA104Accident · No injuriesLimited investigationFinal reportCessna 180K · Helena, MTBinding brakes for undetermined reasons and the pilot's failure to maintain directional control during an aborted takeoff.NTSB LAX02LA193Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbia, CAThe pilot encountered a crosswind gust during the landing roll, resulting in a ground loop and nose over.NTSB ANC02LA072Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the left wing striking the ground. A factor contributing to the accident was the grass-covered runway surface.NTSB CHI02LA130Accident · No injuriesLimited investigationFinal reportCessna 180 · Hyannis, NEThe pilot did not maintain directional control and executed improper use of the brakes. A factor associated with the accident was the soft terrain.NTSB NYC02LA091Accident · No injuriesLimited investigationFinal reportCessna 182A · Moneta, VAA slow leak of brake fluid from the right brake cylinder, which eventually resulted in a loss of right brake effectiveness.NTSB LAX02LA127Accident · No injuriesLimited investigationFinal reportCessna 180J · Saline Valley, CAThe pilot's loss of directional control during landing rollout after encountering a water erosion rut in the runway's uneven surface.NTSB LAX02LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Jean, NVThe pilot's failure to maintain directional control.NTSB SEA01LA136Accident · No injuriesLimited investigationFinal reportCessna 180K · Quincy, WAThe pilot's failure to maintain directional control during the landing roll. Factors include an encounter with a dust devil/whirlwind.NTSB LAX01LA224Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZThe pilot's improper use of the rudder control to correct for torque and P-factor effects, which resulted in a loss of directional control and an inadvertent ground loop/swerve.NTSB SEA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182P · Salmon, IDLoss of aircraft control while landing. Factors include soft/muddy terrain.NTSB LAX01LA155Accident · No injuriesLimited investigationFinal reportCessna 180K · Glendale, AZThe pilot's loss of directional control during the landing roll resulting in a ground loop/swerve and collision with a runway marker sign.NTSB ANC01LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · Soldotna, AKThe private pilot/student's inadequate compensation for crosswind conditions and subsequent loss of directional control of the airplane during a touch and go, and the instructor pilot's inadequate supervision of the flight. Factors in the accident were a…NTSB MIA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melbourne, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll of the touch-and-go landing resulting in the on ground collision with a ditch and subsequent separation of the nose gear wheel and fork assembly and…NTSB DEN01LA049Accident · No injuriesLimited investigationFinal reportCessna 180K · Clovis, NMThe pilot's failure to maintain directional control, which resulted in the subsequent swerve of the airplane. Contributing factors were the pilot's lack of experience in make and model and his diverted attention while attempting to adjust the trim.NTSB LAX01LA046Accident · No injuriesLimited investigationFinal reportCessna 305A · Mokuleia, HIThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control and subsequent ground loop.NTSB NYC01LA034Accident · No injuriesLimited investigationFinal reportCessna 180H · Long Lake, NYThe pilot's improper recovery from a bounced landing.NTSB SEA00LA171Accident · No injuriesLimited investigationFinal reportCessna 180H · Roche Harbor, WAThe pilot's failure to adequately compensate for wind conditions during landing.NTSB DEN00LA156Accident · No injuriesLimited investigationFinal reportCessna 180K · Douglas, WYThe pilot's failure to maintain control of the aircraft during landing roll. Factors were high winds and crosswinds.NTSB SEA00LA153Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Challis, IDThe pilot's inadequate compensation for wind conditions. Factors include variable winds during landing.NTSB SEA00LA139Accident · No injuriesLimited investigationFinal reportCessna 180H · Hailey, IDFailure to adequately compensate for wind conditions.NTSB CHI00LA190Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Cloud, MNdirectional control not being maintained by the pilot during landing rollout.NTSB NYC00LA166Accident · No injuriesLimited investigationFinal reportCessna 182 · Freedom, PAThe pilot's failure to maintain aircraft control. Factors were the soft runway, and that the pilot exceeded the aircraft's weight and balance.NTSB ANC00LA057Accident · No injuriesLimited investigationFinal reportCessna 180K · Anchorage, AKThe pilot's inadvertent ground loop/swerve during landing.NTSB LAX00LA177Accident · No injuriesLimited investigationFinal reportCessna 180 · N. Las Vegas, NVThe pilot's inadequate compensation for the existing crosswind condition, and his improper positioning of the flight controls.NTSB LAX00LA142Accident · No injuriesLimited investigationFinal reportCessna 305A · Jackson, CAfailure of the pilot to adequately compensate for a crosswind condition, resulting in a loss of directional control and collision with a rock.NTSB SEA00LA060Accident · No injuriesLimited investigationFinal reportCessna 180K · Silverdale, WAThe pilot's inadequate compensation for winds. Factors include gusty, shifting winds, crosswinds, and an earthen berm near the edge of the runway.NTSB SEA00LA055Accident · No injuriesLimited investigationFinal reportCessna 180K · Roundup, MTThe pilot's failure to adequately compensate for wind conditions and subsequent loss of control.NTSB CHI00LA019Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Benton, KSthe pilot's failure to maintain aircraft control, and the physiological impairment of the pilot due to a brain anomaly. The pilots improper decision to operate the airplane with a known medical deficiency, and the ditch were contributing factors.NTSB DEN00LA004Accident · No injuriesLimited investigationFinal reportCessna 180D · Denver, COThe excessive taxi speed used by the pilot exiting the runway via a high-speed taxiway resulting in a loss of control. A factor was the crosswind.NTSB CHI00LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Pleasant Hills, MOThe pilot's loss of directional control during an aborted takeoff.