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 DEN06CA082Accident · No injuriesData collectionFinal reportCessna 182R · Albuquerque, NMthe pilot's failure to maintain directional control of the airplane after landing.NTSB ANC06LA067Accident · No injuriesLimited investigationFinal reportCessna 182 · Chenega Bay, AKA loss of engine power for an undetermined reason while maneuvering at low level over a beach, which resulted in an in-flight collision with rough terrain and a nose over. A factor in the accident was the rough/uneven terrain.NTSB ANC06CA062Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's inadequate recovery from a bounced landing during the landing flare/touchdown, which resulted in a loss of control, the right wing striking the runway, and subsequent nose down when the airplane departed the runway.NTSB ANC06CA060Accident · No injuriesData collectionFinal reportCessna 180 · Sterling, AKThe pilot's inadequate compensation for a crosswind during the landing roll, which resulted in an on-ground encounter with the runway surface. Factors contributing to the accident were a crosswind, and an inadvertent ground loop.NTSB DEN06CA074Accident · No injuriesData collectionFinal reportCessna 182Q · Fort Bridger, WYthe pilot's failure to maintain aircraft control during the landing flare and touchdown. Contributing to the accident was the high, gusty crosswinds.NTSB DFW06CA117Accident · Minor injuriesData collectionFinal reportCessna 182L · Covington, LAThe total loss of engine power due to water contamination in the fuel system for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL06LA069Accident · 1 fatalLimited investigationFinal reportCessna 182B · Gainesville, GAThe pilots improper preflight planning and preparation which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA06LA076Accident · No injuriesLimited investigationFinal reportCessna 180 · Klamath Falls, ORThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include gusty crosswinds.NTSB ATL06CA064Accident · Minor injuriesData collectionFinal reportCessna L-19 · Kenly, NCThe pilot's continued operation of the airplane with known deficiencies (tail wheel steering) which resulted in loss of directional control during the takeoff roll, and a ground loop.NTSB CHI06LA101Accident · No injuriesLimited investigationFinal reportCessna 180G · Eveleth, MNThe pilot's failure to maintain directional control during the landing rollout, which resulted in the airplane departing the left side of the runway. Contributing to the accident was the airport fence and the drainage ditch.NTSB NYC06CA084Accident · No injuriesData collectionFinal reportCessna 180F · Greenville, METhe pilot's failure to maintain directional control during landing, resulting in a ground loop. A factor was the rough/uneven runway condition.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 DFW06CA085Accident · No injuriesData collectionFinal reportCessna 182 · Houston, TXThe pilot's failure to maintain directional control while taxiing. A contributing factor was the gusty winds.NTSB MIA06LA062Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Brooksville, FLAn in-flight loss of fuel for undetermined reasons which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.NTSB DFW06CA077Accident · No injuriesData collectionFinal reportCessna 182C · Gilliam, LAThe loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to use carburetor heat and the lack of suitable terrain for the forced landing.NTSB NYC06CA183Accident · No injuriesData collectionFinal reportCessna 180H · Blue Bell, PAThe pilot's failure to maintain control of the airplane during the landing flare, which resulted in the right wing contacting the runway. A factor was the crosswind.NTSB NYC06LA073Accident · 1 fatalLimited investigationFinal reportCessna 182D · Weyers Cave, VAThe pilot's improper decision to maneuver at a low altitude at night, and his failure to maintain adequate altitude/clearance, which resulted in a collision with power lines. A factor in this accident was the night light conditions.NTSB SEA06FA055Accident · 2 fatalField investigationFinal reportCessna 182P · Goldendale, WAThe pilot's failure to maintain terrain clearance during descent. Factors contributing to the accident were the high mountains, mountain obscuration, the dark night condition, and the pilot's improper in-flight planning/decision making.NTSB DEN06FA043Accident · 3 fatalField investigationFinal reportCessna 182E · Austin, COthe pilot's failure to maintain clearance from the transmission wire resulting in the airplane's outboard wing portion to be severed, and the subsequent loss of control and ground impact. Factors contributing to the accident were the pilot's impairment from…NTSB LAX06FA106Accident · 3 fatalField investigationFinal reportCessna 172RG · El Cajon, CAThe pilots of both airplanes failure to maintain an adequate visual lookout due to their relative flight paths, which limited the available visual cues. Factors were the failure of the air traffic controller(s) to issue a conflict alert to the Cessna 172RG…NTSB LAX06CA102Accident · No injuriesData collectionFinal reportCessna 182 · Black Canyon, AZthe pilot's encounter with downdraft at low altitude on short final approach to land.NTSB NYC06CA060Accident · No injuriesData collectionFinal reportCessna 305A · Seboeis, METhe pilot's failure to maintain clearance from power lines, while attempting to land on a frozen lake.NTSB LAX06FA091Accident · 1 fatalField investigationFinal reportCessna 182P · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude during a cruise descent that resulted in controlled flight into terrain (CFIT). Factors in the accident were the rising mountainous terrain, the dark nighttime lighting condition.NTSB ANC06LA015Accident · 1 fatalLimited investigationFinal reportCessna 180 · Seward, AKThe pilot's inadequate weather evaluation, which resulted in an in-flight encounter with low ceilings, turbulence, and downdrafts in cruise flight, and the pilot's failure to maintain altitude/clearance while maneuvering, which resulted in an in-flight…NTSB DEN06FA028Accident · 1 fatalField investigationFinal reportCessna 182D · Heber, AZthe pilot's failure to maintain altitude/clearance from terrain. Contributing factors included the pilot's lack of night flying experience and the dark night.NTSB DEN06CA029Accident · Serious injuriesData collectionFinal reportCessna 182A · Hobbs, NMthe loss of engine power due to fuel exhaustion and the pilot's failure to visually verify the fuel quantity in the fuel tanks prior to departure. Contributing factors include the pilot's inadequate preflight, and the transmission wires.NTSB SEA06CA034Accident · Minor injuriesData collectionFinal reportCessna 182G · Sweet Home, ORThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane exiting the paved runway surface, encountering muddy terrain and nosing over. Contributing factors were the night light condition and the muddy terrain.NTSB NYC06CA047Accident · Minor injuriesData collectionFinal reportCessna 180H · Greenville, NHThe pilot's inadequate pre-flight inspection, which resulted in water-contaminated fuel in the engine and subsequent engine failure.NTSB MIA06CA034Accident · No injuriesData collectionFinal reportCessna 182 · Haines City, FLThe pilot's improper preflight planning/preparation, and operation of equipment with known deficiencies, a right wing fuel cap leak, which resulted in fuel exhaustion and the loss of engine power.NTSB DEN06CA021Accident · Minor injuriesData collectionFinal reportCessna 182E · Lansing, KSthe pilot's inability to maintain aircraft control during the forced landing which resulted in a collision with terrain. A contributing factor was the pilot becoming ill during cruise flight.NTSB CHI06CA039Accident · Serious injuriesData collectionFinal reportLarson Aero Comp-6 · Brainerd, MNThe pilot/builder inadvertently reversed the aileron control systems during installation and failed to maintain control of the airplane during takeoff. A factor associated with the accident was the pilot/builder’s failure to perform an adequate aircraft…NTSB SEA06CA030Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Auburn, WAThe collapse of the left main landing gear after landing for undetermined reasons.NTSB LAX06LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAThe failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.NTSB ANC06CA010Accident · No injuriesData collectionFinal reportCessna 180H · Anchorage, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane encountering a snow berm, and nosing over. A factor associated with the accident was the snow berm.NTSB DEN06LA015Accident · No injuriesLimited investigationFinal reportCessna 182 · Broomfield, COthe nose wheel assembly separation for reasons undetermined.NTSB CHI06CA028Accident · No injuriesData collectionFinal reportCessna 182 · Butler, MOThe damage to the horizontal stabilizer was a result of the inadvertent deployment of the skydiver's reserve parachute.NTSB LAX06CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Torrance, CAthe pilot's excessive taxi speed, and his failure to maintain an adequate clearance from objects.NTSB CHI06CA022Accident · No injuriesData collectionFinal reportCessna 180 · Manitowish Wate, WIThe pilot's inadequate preflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident was the trees the airplane impacted during the forced landing.NTSB DFW06CA014Accident · No injuriesData collectionFinal reportCessna 182J · San Antonio, TXThe pilot's failure to compensate for prevailing wind conditions and his delay in executing a go-around. A contributing factor was the gusty winds.NTSB LAX06CA010Accident · No injuriesData collectionFinal reportCessna 182B · Mokelumne Hill, CAthe pilot's improper flare resulting in a hard landing. A related factor was gusty wind conditions.NTSB SEA06CA002Accident · No injuriesData collectionFinal reportBeech D35 · Creswell, ORThe pilot's failure to attain a proper touchdown point and worn brakes. Inadequate maintenance was a factor.NTSB ANC05CA151Accident · No injuriesData collectionFinal reportCessna 182 · Bethel, AKThe pilot's misjudged distance and speed, which resulted in an overrun and a nose over during the landing roll. A factor associated with the accident was the dusk lighting conditions.NTSB NYC05CA147Accident · No injuriesData collectionFinal reportCessna 182 · Southampton, NYThe pilot's failure to maintain directional control while landing.NTSB SEA05CA197Accident · No injuriesData collectionFinal reportCessna 180H · Yelm, WAThe mixture control linkage separation as a result of a missing retaining nut and washer on the mixture cable attach bolt. Inadequate maintenance inspection and fences 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 ANC05LA143Accident · No injuriesLimited investigationFinal reportCessna 180C · Igiugig, AKThe failure of the airplane's starter to disengage, which resulted in an overheated starter, smoke in the cockpit, and an emergency landing. A factor associated with the accident was soft terrain encountered during the emergency landing.NTSB ANC05CA138Accident · No injuriesData collectionFinal reportCessna 180 · Aniak, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a collision with brush during the landing flare. A factor contributing to the accident was high vegetation.NTSB SEA05LA187Accident · No injuriesLimited investigationFinal reportCessna 182E · Toutle, WAThe loss of engine power as a result of fuel exhaustion due to the pilot's failure to properly secure the fuel caps during his self-servicing and (improperly) preflighting the airplane. A contributing factor was the utility pole.NTSB ANC05CA145Accident · No injuriesData collectionFinal reportCessna 180 · McGrath, AKThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a nose over.NTSB CHI05TA251Accident · No injuriesFinal reportCessna 182R · New Ulm, MNThe loss of engine power for undetermined reasons resulting in a forced landing. A contributing factor was the soft terrain condition.