NTSB investigations: Continental O-470 series
6,205 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 CHI01LA193Accident · No injuriesLimited investigationFinal reportCessna 182 · Taylorville, ILThe pilot's improper procedure and the unsuitable terrain encountered during the forced landing. Additional factors included the carburetor icing and the corn crop.NTSB MIA01LA178Accident · Serious injuriesLimited investigationFinal reportCessna 188B · Leesburg, FLThe pilot's failure to maintain a visual lookout while deploying the grappling hook in preparation for a banner pick up resulting in the cable wrapping around the stabilizer, subsequent loss of control during the banner drop (due to the cable moving forward…NTSB ANC01LA079Accident · No injuriesLimited investigationFinal reportCessna 180 · Willow, AKA fire of undetermined origin, following a precautionary landing.NTSB ANC01LA080Accident · No injuriesLimited investigationFinal reportBeech H35 · Chitina, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are variable winds, and a downdraft.NTSB LAX01LA224Accident · No injuriesLimited investigationFinal reportCessna 182P · Mesa, AZThe pilot's improper use of the rudder control to correct for torque and P-factor effects, which resulted in a loss of directional control and an inadvertent ground loop/swerve.NTSB FTW01LA206Accident · No injuriesLimited investigationFinal reportCessna 182 · Gladewater, TXthe pilot's inadvertent visual flight into instrument meteorological conditions while maneuvering, which resulted in her spatial disorientation and subsequent loss of control of the airplane.NTSB NYC01LA148Accident · 1 fatalLimited investigationFinal reportCessna 182P · Oswego, NYThe pilot's inadequate altitude clearance above water while conducting low level flight maneuvers. A factor related to the accident was the pilot's impairment of judgment due to alcohol consumption.NTSB FTW01LA144Accident · No injuriesLimited investigationFinal reportCessna 182A · Baytown, TXThe unqualified person's failure to maintain clearance with the power lines while maneuvering. A factor was the dark night light conditions.NTSB ANC01LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to refuel the airplane, his inadequate preflight planning/decision making, and subsequent fuel exhaustion during cruise flight.NTSB FTW01LA134Accident · No injuriesLimited investigationFinal reportCessna 182K · Victoria, TXthe pilot's inadequate preflight inspection which resulted in an unsecured seat which slipped aft on takeoff.NTSB FTW01LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Hondo, TXthe pilot's inadequate preflight of the airplane, which resulted in a loss of engine power in cruise flight due to water in the fuel. A contributing factor was the soft terrain encountered during the forced landing.NTSB LAX01LA182Accident · No injuriesLimited investigationFinal reportCessna 182E · Fallon, NVThe pilot's failure to maintain clearance with a road sign during an emergency landing to a road. Contributing factors were the smoke created from a bird nest in the engine compartment, and the pilot's diverted attention due to an approaching car on the road.NTSB LAX01FA178Accident · 2 fatalField investigationFinal reportBeech D45 · Julian, CAThe pilot's selection of an insufficient altitude over rising mountainous terrain and his failure to maintain adequate terrain clearance.NTSB SEA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182P · Salmon, IDLoss of aircraft control while landing. Factors include soft/muddy terrain.NTSB SEA01LA096Accident · No injuriesLimited investigationFinal reportCessna 180A · Mercer Island, WAthe pilot's inadequate visual lookout during an approach and landing in open water. Factors include a large wave/swell at the location where the pilot elected to land his float-equipped airplane.NTSB ATL01LA051Accident · No injuriesLimited investigationFinal reportCessna 182Q · Ball Ground, GAThe student pilot's failure to maintain directional control during landing roll. A factor is the ditch.NTSB ATL01LA050Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Lake Wales, FLThe pilot's improper use of flight controls during a bounced landing, and subsequent collision with the ground. A factor of the collision is the rough and uneven terrain.NTSB NYC01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Paintsville, KYThe pilot's inadequate preflight inspection of the aircraft, which resulted in fuel exhaustion during cruise flight.NTSB LAX01LA155Accident · No injuriesLimited investigationFinal reportCessna 180K · Glendale, AZThe pilot's loss of directional control during the landing roll resulting in a ground loop/swerve and collision with a runway marker sign.NTSB IAD01LA045Accident · No injuriesLimited investigationFinal reportCessna 182N · Cedarville, NJThe pilot's failure to maintain directional control during the landing flare. A factor was the wind gusts.NTSB SEA01FA070Accident · 2 fatalField investigationFinal reportCessna 182P · Fairfield, WAThe pilot's failure to maintain altitude and/or clearance over trees, resulting in a collision with trees, separation of a wing and uncontrolled collision with terrain. Factors included the pilot's inadequate preflight planning and preparation, dark night…NTSB MIA01FA119Accident · 1 fatalField investigationFinal reportBeech A-45/T-34A · Claxton, GAThe pilot in command's failure to maintain airspeed while performing an emergency landing after having just taken off with an unsecured fuel cap, which resulted in an inadvertent stall mush, an uncontrolled descent, and an impact with trees.NTSB MIA01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lakeland, FLThe pilot's failure to flare on landing resulting in a hard landing.NTSB LAX01LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZthe pilot's failure to attain and maintain a sufficient airspeed, which resulted in an inadvertent stall/mush.NTSB ATL01LA045Accident · Serious injuriesLimited investigationFinal reportCessna 182 P · Kennesaw, GAThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.NTSB ANC01LA052Accident · No injuriesLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot's selection of an unsuitable landing area. A factor associated with the accident was uneven 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 DEN01LA076Accident · No injuriesLimited investigationFinal reportBeech 95-B55B (T42A) · Watkins, COAn inadvertent landing gear retracted landing by the CFI during an instructional flight conducting a touch-and-go landing.NTSB NYC01FA089Accident · 1 fatalField investigationFinal reportCessna 182Q · Dixon, KYThe pilot's failure to maintain adequate clearance while maneuvering, which resulted in an in-flight collision with trees.NTSB ANC01LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · Soldotna, AKThe private pilot/student's inadequate compensation for crosswind conditions and subsequent loss of directional control of the airplane during a touch and go, and the instructor pilot's inadequate supervision of the flight. Factors in the accident were a…NTSB LAX01LA126Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boulder City, NVThe loss of engine power during landing descent for undetermined reasons.NTSB ATL01LA039Accident · No injuriesLimited investigationFinal reportCessna 182B · Boynton Beach, FLThe failure of a propeller actuator pin that resulted in an engine vibration and the loss of thrust. The airplane nosed over during the emergency landing roll. A factor was rough/uneven terrain.NTSB ATL01LA037Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Durham, NCThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.NTSB SEA01LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Enterprise, ORInadvertent collision with a deer while landing. A contributing factor was night conditions.NTSB ANC01LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Ophir, AKThe pilot's selection of unsuitable terrain for takeoff, and his inadequate preflight planning/preparation resulting in a collision with trees during the initial climb. Factors in the accident were soft, snow-covered terrain, and trees in the area of…NTSB MIA01LA090Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melbourne, FLThe failure of the pilot-in-command to maintain directional control of the airplane during the landing roll of the touch-and-go landing resulting in the on ground collision with a ditch and subsequent separation of the nose gear wheel and fork assembly and…NTSB FTW01LA074Accident · No injuriesLimited investigationFinal reportCessna 182P · Tuttle, OKfuel exhaustion due to a loose fuel cap as a result of the pilot's inadequate preflight. A contributory factor was the lack of suitable terrain for the forced landing.NTSB MIA01LA081Accident · No injuriesLimited investigationFinal reportCessna 182H · Weaver, ALDamage to the No. 4 cylinder intake valve push rod tube at an undetermined time which resulted in the push rod rubbing on the push rod tube and failing due to wear, resulting in loss of engine power and damage to the airplane during a forced landing in a…NTSB DEN01LA048Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Canon City, COThe loss of engine power during takeoff initial climb resulting from an excessively rich fuel/air mixture, which fouled the spark plugs. A factor was rough, unsuitable terrain for a forced landing.NTSB DEN01LA049Accident · No injuriesLimited investigationFinal reportCessna 180K · Clovis, NMThe pilot's failure to maintain directional control, which resulted in the subsequent swerve of the airplane. Contributing factors were the pilot's lack of experience in make and model and his diverted attention while attempting to adjust the trim.NTSB MIA01LA059Accident · No injuriesLimited investigationFinal reportCessna 182A · Parkton, NCThe loss of engine power during a normal descent due to fuel starvation for undetermined reasons.NTSB MIA01LA052Accident · No injuriesLimited investigationFinal reportCessna 305A · Morganton, NCThe failure of the pilot to maintain aircraft control about the aircraft's lateral axis during landing rollout, and the resultant nose over.NTSB NYC01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mitchellville, MDA loss of engine power for undetermined reasons.NTSB ANC01LA023Accident · No injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe failure of a mechanic to ensure the throttle linkage was secure. A factor in the accident was the pilot's failure to take remedial action during an emergency landing and overrun.NTSB ATL01LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Plant City, FLThe loss of engine power due to fuel starvation resulting from the separation of the mixture control cable from the carburetor. Factors were cows, rough and uneven terrain.NTSB CHI01LA045Accident · No injuriesLimited investigationFinal reportLarson Aero COMP-6 · Brainerd, MNThe pilot's inadequate preflight of the airplane which resulted in fuel exhaustion. Factors associated with the accident were the loose fuel cap and the snow covered terrain.NTSB SEA01WA028Accident · 1 fatalForeign investigationCessna 182N · Tofino, CanadaNTSB NYC01LA049Accident · No injuriesLimited investigationFinal reportCessna 182J · College Park, MDThe pilot's inadequate flare, which resulted in a hard landing. A factor related to the accident was the downdraft wind conditions.NTSB LAX01LA046Accident · No injuriesLimited investigationFinal reportCessna 305A · Mokuleia, HIThe pilot's inadequate compensation for the existing crosswind condition, which resulted in a loss of directional control and subsequent ground loop.NTSB ANC01LA021Accident · No injuriesLimited investigationFinal reportCessna 180H · Wasilla, AKThe pilot's selection of an unsuitable landing/taxi area. A factor associated with the accident was weak ice.