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 GAA19CA365Accident · No injuriesData collectionFinal reportCessna 182 · Burley, IDThe pilot's improper landing flare during landing in a gusting, right quartering tailwind, which resulted in the airplane wheel barrowing and a subsequent runway overrun, impact with terrain, and noseover.NTSB WPR19LA174Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182M · Upland, CAThe total loss of engine power due to detonation within the No. 2 cylinder as a result of a lean fuel flow setting.NTSB ERA19FA193Accident · 2 fatalField investigationFinal reportCessna 182 · Maitland, FLThe pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA19CA336Accident · Minor injuriesData collectionFinal reportCessna 180 · Ontario, ORThe pilot's improper preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA19CA321Accident · Minor injuriesData collectionFinal reportCessna 180 · Moses Lake, WAThe pilot's improper landing flare and his delayed decision to go-around, which resulted in impact with rocks on a shoreline.NTSB GAA19CA355Accident · No injuriesData collectionFinal reportCessna 180 · Santa Fe, NMThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a wing strike.NTSB ERA19TA185Accident · Minor injuriesClass 3Final reportCessna 182 · Robertsdale, ALThe pilot's failure to obtain the proper touchdown point while landing on a wet turf runway, which resulted in a runway overrun.NTSB GAA19CA307Accident · No injuriesClass 4 · Data collectionFinal reportDavid S Meek SUN Devil · Junction City, KSThe pilot rated passenger's failure to maintain directional control during landing. Contributing to the accident was the improperly maintained main landing gear brake pads.NTSB GAA19CA296Accident · No injuriesData collectionFinal reportCessna 182 · Orangeburg, SCThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA19CA259Accident · No injuriesData collectionFinal reportCessna 182 · Crossett, ARThe pilot's failure to maintain the runway centerline and his subsequent failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose-over.NTSB GAA19CA257Accident · Minor injuriesData collectionFinal reportCessna 182 · Glades Park, COThe pilot's failure to maintain adequate airspeed and climb rate during takeoff in high-density altitude conditions, which resulted in his failure to clear power lines.NTSB GAA19CA246Accident · Minor injuriesData collectionFinal reportCessna 182 · Marion, INThe pilot's improper trim setting and his exceedance of the airplane's critical angle of attack during a go-around, which resulted in an aerodynamic stall.NTSB WPR19FA126Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Mill Creek, CAA total loss of engine power due to oil starvation as a result of the failure of a gasket on the oil filter adapter and the pilot’s inability to clear power lines during the emergency landing.NTSB GAA19CA219Accident · No injuriesData collectionFinal reportCessna 180 · Morgan, UTThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and an attempted aborted landing and impact with bushes and terrain.NTSB GAA19CA214Accident · No injuriesData collectionFinal reportCessna 180 · Limington, METhe pilot's failure to maintain directional control during touchdown, which resulted in runway excursion onto snow.NTSB CEN19LA130Accident · No injuriesClass 3 · LimitedFinal reportCessna L19 · Milton, LAA loss of engine power for reasons that could not be determined based on the available information.NTSB ERA19LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Brevard, NCThe mechanic's failure to notice that the left front seat left front roller housing disengaged from the seat rail during recent maintenance, and the pilot's failure to detect the disengaged roller housing during the preflight inspection, which resulted in the…NTSB GAA19CA146Accident · No injuriesData collectionFinal reportCessna 182 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll with a gusting tailwind, which resulted in a runway excursion and collision with runway lights and taxiway signage.NTSB GAA19CA136Accident · No injuriesData collectionFinal reportCessna 182 · Arlington, WAThe pilot's distraction during the engine warm-up, which resulted in the airplane's collision with a hangar. Contributing to the accident was the pilot's failure to set the brakes.NTSB GAA19CA115Accident · No injuriesData collectionFinal reportNavion Navion · Patterson, LAThe pilot's failure to maintain clearance from power lines while making an evasive maneuver to avoid birds.NTSB WPR19LA055Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Townsend, MTThe pilot’s failure to maintain clearance from power lines while maneuvering at low level, which resulted in a wire strike and subsequent impact with terrain.NTSB GAA19CA111Accident · Minor injuriesData collectionFinal reportCessna 180 · Bend, ORThe pilot's failure to maintain directional control in gusting crosswind conditions.NTSB CEN19LA061Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Norwood, COThe partial loss of engine power for undetermined reasons.NTSB GAA19CA086Accident · No injuriesData collectionFinal reportCessna 182 · Reno, NVThe airplane’s collision with a bird during a practice instrument approach.NTSB WPR19FA025Accident · 2 fatalClass 2 · FieldFinal reportCessna 182 · Redding, CAThe pilot's spatial disorientation and subsequent loss of control after takeoff in dark night instrument meteorological conditions.NTSB GAA19CA064Accident · No injuriesData collectionFinal reportCessna 182 · Charlotte, NCThe pilot's improper landing flare, which resulted in a hard landing.NTSB WPR19LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Cottonwood, CAA partial loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat during a reduced-power approach descent.NTSB ERA19LA031Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Elba, ALA leak in the pitot-static system for reasons that could not be determined based on the available information, which resulted in an airspeed indication error, an aborted takeoff, and a subsequent runway overrun.NTSB WPR19LA020Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Burns, ORThe failure of the left main landing gear due to fatigue cracking of a bolt that initiated at a corrosion pit, which formed in the absence of a required protective cadmium coating.NTSB ERA19LA017Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Opelika, ALThe improper torque application and ongoing inspection of an oil filter adaptor by maintenance personnel, which resulted in a loss of lubrication and a catastrophic engine failure.NTSB CEN19FA008Accident · 2 fatalClass 3 · FieldFinal reportCessna 182 · Canoncito, NMThe partial loss of engine power due to induction system icing. Contributing to the accident was the fractured carburetor heat control cable, which rendered the carburetor heat inoperative.NTSB GAA19CA008Accident · Minor injuriesData collectionFinal reportCessna 188 · Rolla, MOThe pilot's failure to maintain directional control during takeoff in a left quartering tailwind.NTSB GAA19CA005Accident · No injuriesData collectionFinal reportCessna 180 · Hailey, IDThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB ANC18LA072Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Anchorage, AKThe pilot's failure to avoid wake turbulence from a crossing heavy airplane.NTSB GAA18CA552Accident · No injuriesData collectionFinal reportCessna 182 · Page, AZThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA18CA572Accident · No injuriesData collectionFinal reportCessna 180 · Yakutat, AKThe pilot’s failure to maintain lateral control of the airplane during a step-turn takeoff.NTSB ERA18FA231Accident · 4 fatalField investigationFinal reportCessna 182 · Swainsboro, GAThe total loss of engine power for reasons that could not be determined based on available information.NTSB WPR18LA227Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 182 · Salmon, IDThe pilot’s inadvertent encounter with downdraft conditions, which resulted in a loss of altitude, and the pilot’s subsequent decision to conduct a precautionary landing into a stand of trees.NTSB GAA18CA492Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the left wing and horizontal stabilizer striking the ground.NTSB CEN18LA311Accident · No injuriesLimited investigationFinal reportCessna 188 · Watkins, MNA partial loss of engine power for reasons that could not be determined because a postaccident examination revealed no evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA18LA199Accident · 1 fatalLimited investigationFinal reportCessna 182 · Cleveland, TNThe undetected wear of the ignition switch and key, which allowed removal of the key from an intermediate position and subsequently led to an unintended engine start-up. Contributing to the undetected wear of the 42-year-old ignition switch was the lack of…NTSB GAA18CA421Accident · No injuriesData collectionFinal reportCessna 182 · Lincoln, ILThe pilot’s improper preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.NTSB GAA18CA404Accident · No injuriesData collectionFinal reportCessna 180 · Cut Bank, MTThe pilot's failure to maintain directional control during the landing roll.NTSB GAA18CA396Accident · No injuriesData collectionFinal reportCessna 182 · San Luis Obispo, CAThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN18LA250Accident · No injuriesLimited investigationFinal reportCessna 180 · Lago Vista, TXThe separation of the left main landing gear spring during landing due to a preexisting fatigue crack.NTSB ANC18CA052Accident · No injuriesData collectionFinal reportCessna 182 · Chugiak, AKThe pilot's mismanagement of the engine controls due to distraction in the traffic pattern, which resulted in a hard landing short of the runway.NTSB WPR18LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLA total loss of engine power for reasons that could not be determined due to insufficient evidence.NTSB ANC18LA048Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe failure of the brake line tube due to an improper flare.NTSB GAA18CA373Accident · No injuriesData collectionFinal reportCessna 180 · Kent, WAThe pilot’s use of excessive braking during the landing roll, which resulted in the airplane coming to rest nose down.NTSB ANC18LA046Accident · Serious injuriesLimited investigationFinal reportCessna 180K · Ambler, AKThe pilot's selection of an unsuitable takeoff area with unfavorable wind conditions, which resulted in the airplane’s inability to maintain a climb.