NTSB investigations: Continental O-470 series
6,203 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 ERA23LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · North Myrtle Beach, SCThe pilot’s failure to properly secure the left wing fuel cap, which resulted in a loss of engine power due to fuel exhaustion.NTSB ANC23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Chaka Creek, AKA partial loss of engine power as a result of carburetor ice. Contributing to the outcome was the pilot’s failure to effectively use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB WPR23LA360Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Aurora, ORThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB GAA23WA232Accident · No injuriesClass 5 · ForeignCessna 180H · Lolland, DenmarkNTSB ERA23LA304Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · Stow, MAThe pilot’s delayed decision to abort the landing, which resulted in a collision with trees.NTSB CEN23LA318Accident · Minor injuriesClass 3 · LimitedFinal reportBeech H35 · Georgetown, TXA loss of engine power for reasons that could not be determined.NTSB ERA23LA299Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Richmond, VAThe pilot’s delay in performing a go-around after a likely encounter with low-level wind shear, resulting in a hard landing. Contributing to the accident were the pilot’s failure to recognize the severity of the actual and forecasted weather near the airport…NTSB WPR23FA256Accident · 1 fatalClass 3 · FieldFinal reportCessna 182N · St Maries, IDThe total loss of engine power due to the failure of the No. 3 exhaust valve for reasons that could not be determined. Contributing to the accident was the pilot’s failure to maintain control of the airplane after the loss of engine power.NTSB CEN23LA275Accident · No injuriesClass 4 · LimitedFinal reportCessna 180A · Grand Prairie, TXThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the unexpected sudden wind shift.NTSB CEN23LA263Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182G · Gunnison, COThe pilot’s improper decision to fly into an area of unsuitable terrain which the airplane was unable to exit, resulting in an aerodynamic stall and subsequent impact with terrain.NTSB WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.NTSB CEN23LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Osceola, IAThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing.NTSB CEN23LA252Accident · No injuriesClass 4 · LimitedFinal reportStarduster II · Norwich, NYThe pilot’s loss of directional control during landing rollout due to interference from the pilot’s foot/shoe with the airplane structure that resulted in a runway excursion and impact with terrain.NTSB ANC23LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Talkeetna, AKA loss of directional control, while landing, due to a flat main landing gear tire.NTSB WPR23LA229Accident · No injuriesClass 3 · LimitedFinal reportCessna 305C (0-1E) · Big Bear City, CAThe pilot’s failure to maintain directional control of the airplane during takeoff.NTSB ANC23FA042Accident · 2 fatalClass 3 · FieldFinal reportCessna 180 · Shaktoolik, AKThe pilot’s encounter with gusting tailwind conditions during takeoff, which resulted in impact with a tree, a loss of control, and subsequent impact with terrain.NTSB CEN23LA236Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Stevens Point, WIThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with the runway.NTSB ERA23FA252Accident · 1 fatalClass 3 · FieldFinal reportCessna 180 · Harrisburg, PAThe pilot’s inadequate preflight fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent collision with terrain and objects.NTSB ERA23FA249Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Plymouth, NYA total loss of engine power for reasons that could not be determined.NTSB WPR23LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Minden, NVThe pilot’s failure to maintain directional control during the landing roll with a quartering headwind.NTSB WPR23LA207Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Kingman, AZThe failure of the passenger to adequately maintain a safe distance from the airplane’s propeller and the determination to let the passenger exit the airplane with the engine running.NTSB ERA23FA219Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Reliance, TNThe pilot’s decision to continue an instrument flight into an area of forecast weather with severe to extreme turbulence associated with a line of thunderstorms, which resulted in an in-flight breakup. Contributing was the pilot’s operation of the airplane in…NTSB CEN23LA168Accident · No injuriesClass 3 · LimitedFinal reportCessna 182D · Batesville, MSThe pilot’s failure to maintain airplane control while landing with a left gusting crosswind. Contributing to the accident was the partial loss of engine power during the go-around.NTSB CEN23LA149Accident · No injuriesClass 3 · LimitedFinal reportCessna 182Q · Gardner, KSA total loss of engine power due to failure of the No. 6 connecting rod as a result of detonation.NTSB ERA23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Cincinnati, OHThe pilot’s failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a parked airplane. Contributing was the marshaller’s improper marshalling techniques.NTSB ANC23LA027Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Minto, AKA total loss of engine power for reasons that could not be determined.NTSB CEN23LA082Accident · No injuriesClass 3 · LimitedFinal reportCessna 182R · Las Animas, COThe student pilot’s loss of control during approach for landing and the flight instructor’s inadequate supervision of the approach and delay in ensuring a go-around was performed at the onset of a stall warning.NTSB WPR23LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Agua Caliente Springs, CAThe pilot’s failure to maintain aircraft control during an aborted approach, which resulted in a collision with terrain.NTSB CEN23LA076Accident · No injuriesClass 3 · LimitedFinal reportCessna 182M · Council Bluffs, IAThe partial loss of engine power for reasons that could not be determined.NTSB CEN23LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Denton, TXThe pilot’s failure to maintain clearance from another airplane while taxing in the run-up area.NTSB ERA23LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Alabaster, ALFailure of the tailwheel locking mechanism, which resulted in a loss of control during landing and a runway excursion.NTSB WPR23LA042Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Kahlotus, WAThe pilot’s failure to check the fuel selector position before takeoff and his improper fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal was the pilot’s loss of airplane control which resulted in an aerodynamic…NTSB ERA23LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Athens, GAThe operator’s and the pilot’s continued operation of the airplane with a known electrical problem, resulting in a loss of electrical power and a gear-up landing.NTSB CEN23LA011Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Navasota, TXThe pilot’s loss of control while landing resulting in a runway excursion and ground loop.NTSB WPR23LA003Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182C · Boulder City, NVA total loss of engine power due to oil starvation resulting from the failure of an engine oil filter adapter fiber gasket.NTSB WPR22LA367Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Hermiston, ORThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB CEN22LA439Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop.NTSB ANC22LA080Accident · 1 fatalClass 3 · LimitedFinal reportCessna 180A · Skwentna, AKThe failure of the landing gear float due to inadequate maintenance of the floats and corrosion.NTSB ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.NTSB CEN22FA406Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Cleveland, TNThe pilot’s loss of airplane control while operating in instrument meteorological conditions.NTSB ERA22LA409Accident · No injuriesClass 4 · LimitedFinal reportCessna 182N · Blairstown, NJThe pilot’s decision to cross the taxiway at an unsuitable location.NTSB ANC22LA075Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180H · McCarty, AKThe pilot’s failure to initiate a go around maneuver when the airplane past the intended touch down point.NTSB WPR22LA337Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Seeley Lake, MTThe loss of engine power due to fuel starvation as a result of unporting of the fuel.NTSB ERA22LA396Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion · Newburyport, MAThe pilot’s excessive application of brakes while landing, which resulted in a nose gear collapse.NTSB WPR22LA323Accident · No injuriesClass 3 · LimitedFinal reportCessna 182K · Tooele, UTLoss of brake pressure to both sets of brakes during taxi due to failed brake caliper O-ring seals, which resulted in a loss of directional control.NTSB WPR22LA326Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Egegik, AKThe pilot's failure to maintain directional control during takeoff from a lake.NTSB WPR22LA315Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Donnelly, IDThe pilot’s improper decision to takeoff from a wet grass runway which did not allow for adequate braking traction when the pilot aborted the takeoff, which resulted in a runway excursion.NTSB ERA22LA381Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Orlando, FLThe pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Moriarty, NMThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.NTSB ANC22LA068Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180 · Sutton-Alpine, AKA total loss of engine power due to fuel exhaustion.