NTSB investigations: Continental O-470 series, ID
176 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.\"eventStateOrRegion\" = 'ID' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
AND 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 WPR12LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · McCall, IDThe flight instructor’s selection of the wrong route while flying in mountainous terrain at a high-density altitude, which resulted in the airplane impacting terrain when the increase in elevation exceeded the airplane’s climb performance.NTSB WPR12CA308Accident · No injuriesData collectionFinal reportCessna 180A · Cascade, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR12CA170Accident · No injuriesData collectionFinal reportCessna 180F · McCall, IDThe pilot did not maintain directional control during the landing roll.NTSB WPR12CA137Accident · No injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe pilot did not properly secure the airplane before starting the engine by manually rotating the propeller, which resulted in the inadvertent movement of the airplane.NTSB WPR12CA086Accident · No injuriesData collectionFinal reportCessna 180 · Cascade, IDThe pilot's inadequate compensation for a wind gust during landing, which resulted in a runway excursion. Contributing to the accident was a windsock partially sheltered by trees that provided inaccurate wind information.NTSB WPR12CA060Accident · No injuriesData collectionFinal reportCessna 182C · Lowman, IDThe pilot's misjudgment of the runway surface firmness, which resulted in a nose-over during the landing roll.NTSB WPR11FA448Accident · 2 fatalField investigationFinal reportCessna 182H · Stanley, IDThe pilot's failure to maintain airplane control due to spatial disorientation while executing a turn to reverse his course in dark night and low-visibility conditions. Contributing to the accident was the pilot's decision to initiate the flight into an area…NTSB WPR11LA359Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Emmett, IDA total loss of engine power due to carburetor icing because the pilot did not use carburetor heat.NTSB WPR10CA301Accident · No injuriesData collectionFinal reportCessna 180 · Big Creek, IDThe pilot’s failure to maintain directional control while taxiing at an unfamiliar airstrip.NTSB WPR10LA241Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Caldwell, IDA loss of directional control and runway excursion for undetermined reasons.NTSB WPR10CA011Accident · No injuriesData collectionFinal reportCessna 180 · Pistol Creek, IDThe separation of one of the airplane's main landing gear legs during landing in variable gusting wind conditions, due to the nut being stripped from the attachment bolt.NTSB WPR09CA332Accident · Minor injuriesData collectionFinal reportCessna 182M · Wilson Bar, IDThe pilot’s misjudged approach that led to a long landing and his failure to execute a go-around when he realized that he overshot his intended point of landing.NTSB WPR09FA282Accident · 1 fatalField investigationFinal reportCessna 182M · Atlanta, IDThe pilot's failure to maintain terrain clearance during cruise flight.NTSB WPR09CA121Accident · Minor injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat before reducing power and his failure to clear the engine during a prolonged glide.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 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 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 SEA07LA234Accident · No injuriesLimited investigationFinal reportCessna 182P · Nampa, IDThe total loss of engine power due to the carburetor throat becoming obstructed with paint that had pealed off of the induction air inlet channel in an area where paint should not have been applied. Factors include an earthen berm running across the field…NTSB SEA07CA198Accident · No injuriesData collectionFinal reportCessna 182B · Leadore, IDThe pilot's inadequate compensation for the gusty wind conditions and his failure to maintain aircraft control, which resulted in a loss of control and collision with terrain during the takeoff initial climb. A contributing factor was the gusty wind condition.NTSB SEA07CA164Accident · Minor injuriesData collectionFinal reportCessna 180H · Nampa, IDThe pilot's failure to stop for additional fuel, which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA07LA004Accident · No injuriesLimited investigationFinal reportCessna 182M · Boise, IDThe pilot's failure to maintain adequate clearance while taxiing. A contributing factor was the temporary construction fence next to the taxiway.NTSB SEA06CA156Accident · No injuriesData collectionFinal reportCessna 180 · Elk City, IDThe pilot's failure to maintain directional control, which resulted in a ground loop during the landing roll.NTSB SEA06CA151Accident · No injuriesData collectionFinal reportCessna 180H · Hailey, IDThe pilot's failure to maintain directional control of the airplane during taxi, which resulted in a nose over. A factor was the wind gust condition.NTSB SEA06CA150Accident · No injuriesData collectionFinal reportCessna 180J · Hailey, IDThe pilot's failure to adequately compensate for wind conditions.NTSB SEA06LA140Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDThe pilot's failure to maintain directional control of the aircraft during takeoff and initial climb out.NTSB SEA06CA066Accident · No injuriesData collectionFinal reportCessna 182D · Sandpoint, IDThe pilot's failure to maintain clearance from an object (snow blowing equipment) while taxiing. The snow blowing equipment, and the pilot's failure to adequately maneuver the aircraft around snow berms were factors.NTSB SEA05LA194Accident · No injuriesLimited investigationFinal reportCessna 182P · Yellow Pine, IDThe pilot's improper preflight planning/preparation during takeoff. A factor was the windshear.NTSB SEA05CA152Accident · No injuriesData collectionFinal reportCessna 180 · McCall, IDThe pilot's inadequate compensation for wind and his failure to maintain directional control. A factor was the crosswind.NTSB SEA05LA127Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Star, IDA loss of engine power for undetermined reasons. A factor contributing to the accident were the transmission wires.NTSB SEA04CA185Accident · Minor injuriesData collectionFinal reportCessna 180H · McCall, IDThe pilot's failure to attain proper touchdown point for landing on the backcountry airstrip. Contributing factors were downdraft weather conditions and the pilot's excessive speed for landing.NTSB SEA03CA195Accident · No injuriesData collectionFinal reportCessna 180 H · Council, IDAircraft control not maintained during the landing roll. Factors include soft, water soaked terrain.NTSB SEA03LA190Accident · 2 fatalLimited investigationFinal reportCessna 182 · Challis, IDThe pilot's failure to maintain clearance from trees while maneuvering. Factors include mountainous terrain and trees.NTSB SEA03LA129Accident · No injuriesLimited investigationFinal reportCessna 182J · Athol, IDThe failure of one of the number five connecting rod cap bolts during cruise flight due to the associated number five rod cap bolt nut being insufficiently torqued at the last major overhaul. Factors include a culvert alongside the road where the pilot found…NTSB SEA03FA092Accident · 1 fatalField investigationFinal reportCessna 180H · Yellow Pine, IDThe pilot's failure to maintain clearance while maneuvering. Trees, a box canyon and rising terrain were factors.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 SEA03LA074Accident · Serious injuriesLimited investigationFinal reportCessna 182 · McCall, IDThe pilot's inadvertent entry into instrument meteorological conditions while maneuvering in the area of rapidly growing cumulus clouds. Factors include the pilot's improper decision to try to out-climb the rising clouds, mountainous terrain, falling snow,…NTSB SEA03LA070Accident · No injuriesLimited investigationFinal reportCessna 182C · Stanley, IDThe pilot's inadequate in-flight planning that resulted in fuel exhaustion and the subsequent loss of engine power during descent. A factor contributing to the accident was the lack of suitable terrain for the forced landing.NTSB SEA02LA177Accident · No injuriesLimited investigationFinal reportCessna 182L · McCall, IDThe pilot's failure to maintain adequate airspeed and an acceptable rate of descent while on short final for landing, and his failure to maintain directional control after the resultant hard landing. Factors include a ditch near the temporary runway (taxiway)…NTSB SEA02FA145Accident · 2 fatalField investigationFinal reportCessna 182A · Emmett, IDThe pilot's failure to maintain clearance from power transmission lines while maneuvering.NTSB SEA02LA148Accident · No injuriesLimited investigationFinal reportCessna 180 · Cascade, IDThe pilot's failure to maintain directional control during the takeoff ground run. Wind gusts and a tree were a factor.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 SEA02LA006Accident · No injuriesLimited investigationFinal reportCessna 182P · Sulfur Creek, IDThe pilot's failure to maintain directional control during the aborted takeoff. Factors include the pilot's excessive rotation attitude, and soft/wet terrain conditions.NTSB SEA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182P · Salmon, IDLoss of aircraft control while landing. Factors include soft/muddy terrain.NTSB SEA01LA069Accident · No injuriesLimited investigationFinal reportCessna 180H · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control during the aborted takeoff. A factor was gusty 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 SEA99LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Yellow Pine, IDMisjudged approach resulting in landing long. Factors include an intentional ground-loop, excessive airspeed and an embankment.NTSB SEA98LA194Accident · No injuriesLimited investigationFinal reportCessna 182B · Big Creek, IDAn animal (cow elk) that had wandered onto the airport.NTSB SEA98LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Yellowpine, IDRight main landing gear spring strut fatigue, improper maintenance, and subsequent separation of the strut end.