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 LAX94LA003Accident · 1 fatalLimited investigationFinal reportCessna 182H · Clear Lake Res, CAFailure of the pilot to maintain altitude, while performing a low-altitude maneuver (turn) over water. Factors related to the accident were: sun glare, haze, glassy condition of the water, and the lack of visual cues (visual perception) for the pilot to judge…NTSB BFO93LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Batavia, OHThe pilot's improper flare.NTSB LAX93LA366Accident · 1 fatalLimited investigationFinal reportCessna 182H · Flagstaff, AZthe pilot's sudden incapacation due to a fatal heart attack.NTSB ANC93IA183Incident · No injuriesIncident investigationFinal reportCessna 180C · Anchorage, AKA frayed fuel hose.NTSB ANC93LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Pumice Creek, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors were the pilot misjudged the wind information, and the unfavorable wind.NTSB SEA93FA206Accident · 1 fatalField investigationFinal reportCessna 180B · Mullan, IDThe pilot's poor in flight decision, and his inadvertent continuation of a VFR flight into instrument meteorological conditions. Factors include low ceilings, snow, fog, rain, and mountainous/hilly terrain.NTSB ANC93LA187Accident · No injuriesLimited investigationFinal reportCessna 180A · Charlie Lake, AKThe pilot delayed his decision to abort the takeoff, and did not follow the standard procedures/directives for the aborted takeoff. Factors were the pilot's improper preflight planning/decision, and the rough/uneven terrain.NTSB SEA93LA204Accident · No injuriesLimited investigationFinal reportCessna 182E · Quilcene, WAThe pilot's failure to maintain the proper airspeed and glidepath.NTSB BFO93LA181Accident · No injuriesLimited investigationFinal reportCessna 180H · New Philadelphi, OHThe pilot's failure to maintain directional control of the airplane during landing rollout, subsequently causing the airplane to veer off the runway and groundloop.NTSB LAX93LA350Accident · No injuriesLimited investigationFinal reportCessna 182E · Minden, NVthe pilot's inadequate preflight planning and failure to use all available runway. A factor in the accident was the high density altitude condition.NTSB FTW93LA258Accident · No injuriesLimited investigationFinal reportCessna 180 · Watkins, COThe pilot's improper compensation for shifting winds.NTSB SEA93LA201Accident · No injuriesLimited investigationFinal reportCessna 182H · Salt Lake City, UTThe pilot's improper flare. Inadequate recovery from a bounced landing was factor.NTSB LAX93LA376Accident · No injuriesLimited investigationFinal reportCessna 182G · Carson City, NV1) the pilot's failure to maintain an appropriate airspeed during an attempted go around, 2) his failure to retract the landing flaps, and 3) the resulting inadvertent entry into a stall/mush condition.NTSB SEA93FAMS1Accident · 2 fatalMissing aircraftFinal reportCessna 182L · Missing, WAUndetermined.NTSB LAX93LA322Accident · Serious injuriesLimited investigationFinal reportCessna 182C · Tinian (Pacific Ocean)the pilot's failure to retract the flaps during the initial climb, and, his failure to maintain an adequate airspeed, which led to an inadvertent stall.NTSB NYC93FA154Accident · 1 fatalField investigationFinal reportCessna 182A · East Moriches, NYEngine failure due to a fatigue failure of the no.3 piston. The fatigue failure was a result of inadequate manufacturing. In addition, the pilot made an improper decision during the forced landing in attempting to stretch his approach in order to reach the…NTSB SEA93LA171Accident · No injuriesLimited investigationFinal reportCessna 188 · Marion, MTThe premature liftoff for takeoff by the pilot and the inadvertant stall/mush. A factor relating to the accident was the high density altitude.NTSB ANC93LA138Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe inadvertent raising of the flaps.NTSB CHI93LA298Accident · No injuriesLimited investigationFinal reportCessna 182P · Buffalo, SDThe pilot-in-command's premature lift-off and subsequent stall/mush into rough/uneven terrain.NTSB FTW93LA232Accident · No injuriesLimited investigationFinal reportCessna 182A · Killeen, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswinds.NTSB ANC93LA132Accident · No injuriesLimited investigationFinal reportCessna 180 · Sparrevohn, AKThe pilot's failure to maintain directional control of the airplane. A factor was the animal on the runway.NTSB LAX93LA309Accident · 1 fatalLimited investigationFinal reportCessna 182P · Dayton, NVThe pilot's failure to maintain an altitude sufficient to clear terrain due to alcohol and drug impairment.NTSB ANC93LA149Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's failure to maintain directional control of the airpalne. A factor in the accident was the ditch along the side of the runway.NTSB CHI93LA317Accident · No injuriesLimited investigationFinal reportCessna 182M · Ironwood, MIThe pilot's improper flare for landing.NTSB DEN93LA082Accident · No injuriesLimited investigationFinal reportCessna 305A · Belen, NMFailure of the pilot in command to maintain directional control. A factor was: a quartering tailwind.NTSB CHI93LA255Accident · No injuriesLimited investigationFinal reportCessna 182 · Prairie City, IAthe pilot's premature liftoff. Factors in the accident are the soft and wet sod runway.NTSB SEA93LA162Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Kanab, UTAn inadvertent wheel up landing. A factor to the accident was turbulence.NTSB ANC93LA110Accident · No injuriesLimited investigationFinal reportCessna 180J · Delta Junction, AKThe pilot in command's delay in aborting the takeoff. The trees were a factor in the accident.NTSB SEA93LA144Accident · No injuriesLimited investigationFinal reportCessna 182RG · Price, UTThe pilot's poor inflight decision. Factors include high density altitude, and control interference.NTSB CHI93LA227Accident · No injuriesLimited investigationFinal reportCessna 182L · Aurora, ILThe disconnected nose gear upper torque link (landing gear steering). Directional control not possible was a factor.NTSB ANC93LA100Accident · No injuriesLimited investigationFinal reportCessna 180 · Merrill Pass, AKThe pilot-in-command's inadequate fuel calculations.NTSB SEA93LA130Accident · No injuriesLimited investigationFinal reportBeech H35 · Douglas, WYThe improper maintenance/replacement of a fuel hose and the blocked fuel vapor return system. A factor relating to the accident was the cattle guard fence posts beside the road.NTSB ANC93LA080Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe pilot's failure to maintain direction control of the airplane during landing. The tailwind was a factor.NTSB ATL93LA096Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hartselle, ALThe pilot's misjudgement of distance and speed during the approach and landing.NTSB ANC93LA066Accident · No injuriesLimited investigationFinal reportCessna 180H · Ketchikan, AKThe pilot in commands improper compensation for the wind condition. A factor in the accident was the unfavorable wind.NTSB LAX93LA219Accident · No injuriesLimited investigationFinal reportCessna 182Q · Concord, CAThe passenger/dual student's improper recovery from a bounced landing, and the pilot's inadequate supervision of the flight.NTSB BFO93LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Bath, NYThe pilot did not attain the proper touchdown point and did not go around while there was still sufficient speed to do so. The wet runway grass was a related factor.NTSB ANC93LA062Accident · No injuriesLimited investigationFinal reportCessna 182 · Blair Lakes, AKThe pilots selection of unsuitable terrain on which to land. A factor was the soft, wet, rough area on the strip.NTSB ATL93LA086Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Macon, GAThe pilot's failure to attain the proper touchdown point. A factor was the pilot's failure to select another airport for landing and the intermittant runway and VASI lighting system.NTSB LAX93LA192Accident · No injuriesLimited investigationFinal reportCessna 182C · Tucson, AZThe excessive approach speed and failure of the first pilot to flare the airplane properly. A factor was the failure of the second pilot to properly supervise the flight.NTSB SEA93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Hamilton, MTThe pilot's improper use of carburetor heat. A factor which contributed to the accident was the carburetor icing conditions.NTSB FTW93LA111Accident · No injuriesLimited investigationFinal reportCessna 182 · Washington, OKLoss of engine power for undetermined reason(s).NTSB LAX93LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lake Havasu, AZThe improper welding of the inboard boss by an unknown person resulting in a fatigue failure on the inboard boss. A factor related to the accident was the vehicle that was struck during the forced landing.NTSB ANC93LA042Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKThe failure of the private certificated/dual student pilot to maintain directional control. A factor in the accident was the failure of the flight instructor/pilot in command to take timely remedial action.NTSB SEA93LA099Accident · No injuriesLimited investigationFinal reportCessna 172K · Ogden, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were soft terrain, excessive airspeed, and crosswinds.NTSB FTW93LA099Accident · No injuriesLimited investigationFinal reportCessna 180J · Albuquerque, NMAircraft control not maintained by the pilot. A factor was vibration in the tailwheel for undetermined reasons.NTSB ANC93LA041Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Port Alsworth, AKThe non instrument rated pilot in command entering instrument meteorological conditions. A factor in the accident was the snow/whiteout condition.NTSB BFO93LA037Accident · No injuriesLimited investigationFinal reportCessna 182Q · Gettysburg, PAThe pilot's inadequate in-flight decision to land on the snow covered runway that was not currently maintained. Contributing to the pilot's decision was the inadequate report of the runway's condition.NTSB LAX93LA129Accident · No injuriesLimited investigationFinal reportCessna 182R · Warner Springs, CAThe pilots decision to attempt flight into known adverse weather conditions.NTSB LAX93LA122Accident · No injuriesLimited investigationFinal reportCessna 182E · Corning, CAThe pilot's poor preflight inspection. Factors relating to this accident were the not properly secured oil cap and the oil covered windshield.