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 ERA20LA258Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Pottstown, PAThe pilot's failure to ensure that sufficient fuel was onboard for nonlevel flight, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Cambridge, MNThe pilot's loss of directional control while landing a tailwheel airplane with a slight left quartering a tailwind. Contributing to the accident was the flight instructor's delayed remedial action.NTSB WPR20CA233Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Bear Valley, AKThe pilot's over application of brakes during taxi, which resulted in a nose over.NTSB CEN20CA289Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Glenwood Springs, COThe pilot's failure to maintain airplane control during landing resulting in a nose over.NTSB ANC20LA065Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Anchorage, AKThe failure of the left float bottom due to corrosion, which resulted in a loss of control during the water landing.NTSB WPR20LA194Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Imnaha, ORThe pilot’s excessively high pitch attitude and failure to maintain adequate airspeed during takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and impact with terrain. Contributing to the accident was the pilot’s fatigue and…NTSB CEN20LA245Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Winfield, TXThe total loss of engine power due to the pilot’s improper fuel management, which led to fuel starvation. Contributing to the accident was the low altitude at which the loss of engine power occurred.NTSB ERA20CA224Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Burlington, VTThe pilot’s failure to maintain directional control during landing roll in crosswind conditions.NTSB WPR20LA187Accident · No injuriesClass 3 · LimitedFinal reportCessna 310 · Coeur D Alene, IDImproper maintenance of the landing gear system which resulted in a partial gear collapse during landing.NTSB ANC20LA060Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Fairbanks, AKThe pilot’s failure to utilize carburetor heat while flying in conditions conducive carburetor to icing, which resulted in a total loss of engine power.NTSB WPR20CA164Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Sandia, TXThe pilot's failure to maintain airplane control during takeoff from a soft airstrip that resulted in a collision with objects.NTSB CEN20CA223Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182J · Olive Branch, MSThe student pilot's improper landing flare and the flight instructor's inadequate supervision, which resulted in a hard landing.NTSB ANC20CA055Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Anchorage, AKThe pilot’s failure to maintain a proper descent rate during landing in gusting wind conditions, which resulted in a hard landing.NTSB CEN20CA193Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Ionia, MIThe pilot's failure to maintain directional control during landing. Contributing was the pilot getting his shoe caught in the rudder pedal.NTSB WPR20CA146Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Perris, CAThe pilot's diverted attention while taxing which resulted in his failure to maintain clearance from the skip loader during taxi.NTSB WPR20CA139Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Hanksville, UTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and ground-loop.NTSB CEN20LA123Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Baxterville, MSThe failure of the No. 1 cylinder intake valve due to inadequate valve seating.NTSB WPR20LA099Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182 · Moab, UTThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and the airplane’s subsequent noseover.NTSB ANC20FA024Accident · 2 fatalClass 3 · FieldFinal reportCessna 305 · Mokuleia, HIA separation of the left rudder cable due to inadequate maintenance, which resulted in an in-flight loss of control and impact with terrain.NTSB WPR20CA085Accident · No injuriesData collectionFinal reportCessna 180 · Eloy, AZThe pilot's failure to maintain directional control while landing in crosswind conditions, which resulted in a ground-loop.NTSB CEN20CA047Accident · No injuriesData collectionFinal reportCessna 182 · Robstown, TXThe pilot's failure to set the friction lock on the throttle before hand propping the engine, which allowed the airplane to move forward and impact a credit card machine. Contributing to the accident was the malfunction of the parking brake for reasons that…NTSB WPR20FA049Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Goodyear, AZThe pilot’s failure to maintain clearance from power lines due to his impairment from cannabis.NTSB WPR20LA042Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Carlsbad, CAThe fatigue failure of the crankshaft. Contributing to the accident was the undocumented installation of the supercharger, which resulted in increased stress on the crankshaft.NTSB WPR20CA041Accident · No injuriesData collectionFinal reportCessna 182 · Camas, WAThe student pilot's improper landing flare, which resulted in a bounced landing, and the flight instructor’s delayed remedial action and the student’s failure to relinquish control, which resulted in a runway overrun and impact with a fence.NTSB GAA20CA071Accident · No injuriesData collectionFinal reportCessna 182 · San Luis, COThe pilot's improper pitch attitude during landing on rising terrain in flat light conditions, which resulted in a hard landing.NTSB WPR20LA028Accident · 1 fatalClass 3 · LimitedFinal reportCessna 182 · Metaline, WAImpact with a lake for reasons that could not be determined.NTSB GAA20CA069Accident · No injuriesData collectionFinal reportCessna 180 · Tyler, TXThe pilot's improper wind correction while taking off with a tailwind, which resulted in a runway excursion and subsequent nose-over.NTSB GAA20CA075Accident · No injuriesData collectionFinal reportCessna 182 · Broomfield, COThe pilot’s inadvertent flight into icing conditions, which resulted in the accumulation of structural icing and an aerodynamic stall.NTSB GAA20CA046Accident · No injuriesData collectionFinal reportCessna L19 · New Braunfels, TXThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and ground-loop.NTSB GAA20CA029Accident · No injuriesData collectionFinal reportCessna 180 · Flannigan, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a wing strike.NTSB GAA20CA024Accident · No injuriesData collectionFinal reportCessna 180 · Greenville, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and ground-loop.NTSB WPR19FA263Accident · 2 fatalField investigationFinal reportCessna 182 · Nixon, NVA loss of airplane control while maneuvering due to spatial disorientation after inadvertently entering instrument meteorological conditions (IMC). Contributing to the accident was the pilot's inexperience in IMC conditions.NTSB GAA19CA525Accident · Minor injuriesData collectionFinal reportCessna 182 · Charleston, WVThe pilot's improper approach path at night and his misjudgment of the landing point, which resulted in landing short of the runway and impact with the runway's engineered materials arrestor system.NTSB GAA19CA548Accident · No injuriesData collectionFinal reportCessna 180 · Lancaster, TXThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA19CA517Accident · Minor injuriesData collectionFinal reportCessna 180 · Arlington, WAThe pilot's failure to properly secure the seat before takeoff, which resulted in it sliding back during takeoff and rendering him unable to reach the rudder pedals and throttle lever, a subsequent runway excursion, ground loop, and impact with a berm.NTSB WPR19LA223Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 35 · Ruidoso, NMThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance as a result of high-density altitude conditions at the time of takeoff. Contributing to the accident were the pilot’s inadequate…NTSB ANC19TA044Accident · Minor injuriesClass 3Final reportCessna 180 · Anchorage, AKThe pilot’s failure to maintain takeoff heading due to sun glare, which resulted in his inability to see an island adjacent to the water lane and subequent impact with the island.NTSB GAA19CA489Accident · No injuriesData collectionFinal reportCessna 180 · Two Harbors, MNThe pilot's abrupt maneuver to try and avoid a deer during landing on a grass strip runway, which resulted in a ground loop.NTSB WPR19FA209Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Wolf Point, MTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an accelerated aerodynamic stall and subsequent loss of control.NTSB GAA19CA504Accident · No injuriesData collectionFinal reportCessna 182 · Oakland, CAThe pilot's premature full retraction of the flaps during a go-around and his subsequent improper decision to turn with a minimal climb gradient, which resulted in an off-airport landing and a landing gear collapse.NTSB ANC19LA040Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Farewell, AKA reported partial loss of engine power during takeoff for reasons that could not be determined.NTSB CEN19LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305A · Houston, MOA total loss of engine power during initial climb due to carburetor icing, which resulted in a forced landing and impact with trees and terrain.NTSB GAA19CA423Accident · No injuriesData collectionFinal reportCessna 182 · Salmon, IDThe pilot's delayed decision to abort the landing on a wet grass runway and the flight instructor's delayed remedial action. Contributing to the accident was the wet runway which degraded braking.NTSB GAA19CA406Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, MOThe pilot's exceedance of the airplane's critical angle of attack during landing, which resulted in an aerodynamic stall and a subsequent hard landing.NTSB GAA19CA402Accident · No injuriesData collectionFinal reportCessna 180 · Talkeetna, AKThe pilot's improper soft-field landing technique, which resulted in a nose-over.NTSB ERA19TA216Accident · No injuriesClass 3Final reportCessna 180 · Pickens, SCMaintenance personnel’s improper installation of the right main landing gear brake assembly, which resulted in the loss of control during landing.NTSB GAA19CA378Accident · No injuriesData collectionFinal reportCessna 180 · Wasilla, AKThe pilot's failure to maintain directional control during the takeoff roll, which resulted in the left wing striking bushes. Contributing to the accident was the pilot’s distorted visual perception due to his flying with one seat cushion rather than the two…NTSB GAA19WA386Accident · 2 fatalForeign investigationCessna 182 · Chimaltenango, GuatemalaNTSB GAA19CA371Accident · No injuriesData collectionFinal reportCessna 182 · Presidio, TXThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a runway excursion and impact with vegetation.NTSB GAA19CA415Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.