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 SEA94LA214Accident · No injuriesLimited investigationFinal reportCessna 180K · Hite, UTCompensation for wind conditions and weather evaluation were inadequate. Factors to the accident were: crosswind and gusts.NTSB BFO94LA139Accident · No injuriesLimited investigationFinal reportCessna 182L · Hopkinsville, KYThe pilot's failure to maintain proper alignment and adequate obstacle clearance.NTSB LAX94WA341Accident · 1 fatalForeign investigationCessna 182 · Creel, MexicoNTSB SEA94LA204Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Bend, ORImproper use of the carburetor heat by the pilot, which resulted in a loss of engine performance. A factor related to the accident was: rough terrain in the emergency landing area.NTSB CHI94LA247Accident · No injuriesLimited investigationFinal reportCessna 182 · Greenwood, ILthe pilot-in-command's (CFI) inadequate aircraft preflight inspection and improper aborted takeoff. Related factors are the blocked pitot/static system, and the CFI's inadequate supervision during the preflight and takeoff.NTSB NYC94LA138Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Waynesburg, OHThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush. A factor was a tailwind.NTSB ATL94LA143Accident · No injuriesLimited investigationFinal reportCessna 182F · Raeford, NCAn engine power loss due to water in the fuel system, and the pilot's inadequate preflight of the aircraft. A factor was the presence of trees at the forced landing area.NTSB ANC94LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's failure to maintain directional control.NTSB CHI94LA232Accident · No injuriesLimited investigationFinal reportCessna 180 · Battle Lake, MNloss of engine power due to fuel exhaustion which resulted from inaccurate fuel consumption calculations. A factor related to the accident was the inaccurately placarded fuel tanks.NTSB ATL94LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Chapel Hill, NCThe pilot's failure to attain a proper touchdown point during landing. Factors were the wet, grass runway conditions.NTSB SEA94LA173Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ione, WAThe pilot's failure to maintain directional control. Factors include the pilot's fatigue, and trees near the side of the runway.NTSB ATL94FA131Accident · 2 fatalField investigationFinal reportBeech H-35 · Jackson, ALThe pilot's failure to avoid an area of thunderstorm activity, which resulted in a loss of control and the designed structural limits of the airframe being exceeded. The thunderstorms were a factor in the accident.NTSB CHI94LA220Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Garden City, KSfuel exhaustion for reason or reasons undetermined. A factor was the rough/uneven terrain.NTSB FTW94LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Collbran, COAn inadvertent stall. Factors were a partially blocked pitot tube and a downdraft.NTSB SEA94LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Indian Valley, IDConnecting rod bolt fatigue and no suitable terrain for the forced landing.NTSB CHI94LA197Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Millstadt, ILthe pilot's inadequate aircraft preflight inspection and failure to refuel the airplane prior to fuel exhaustion. Related factors are the loose fuel cap (siphoning) and the uneven terrain encountered during the forced landing.NTSB LAX94LA248Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Wickenburg, AZthe pilot's failure to remove the control lock prior to flight.NTSB LAX94LA245Accident · No injuriesLimited investigationFinal reportCessna 180J · Sedona, AZa loss of directional control due to a locked brake from a leaking hydraulic system.NTSB CHI94LA190Accident · No injuriesLimited investigationFinal reportCessna 182 · Omaha, NEinadvertant VFR flight into IMC conditions and the pilot's failure to maintain directional control of the airplane. Factors related to the accident were the ground fog and rough terrain encountered.NTSB FTW94LA188Accident · No injuriesLimited investigationFinal reportCessna 182H · Telluride, COWas the pilot's improper recovery from a bounced landing. Factors were gusty winds and runway downslope.NTSB SEA94LA144Accident · No injuriesLimited investigationFinal reportCessna 182P · Salt Lake City, UTAn improper flare by the pilot, who was landing the aircraft, at the time it was damaged.NTSB SEA94FA129Accident · 3 fatalField investigationFinal reportCessna 182B · Rock Springs, WYAn excessive descent rate in the turn from base to final. Factors include a dark night, high winds, and the pilot's fatigue from his flight and ground schedule the day of the accident.NTSB NYC94LA091Accident · No injuriesLimited investigationFinal reportCessna 305A · Franklin, VAThe loss of airplane directional control during landing as a result of a tire failure, and the subsequent collision with soft terrain.NTSB FTW94LA207Accident · No injuriesLimited investigationFinal reportCessna 182L · Mineola, TXThe pilot's delayed landing flare and his improper bounced landing technique.NTSB CHI94LA168Accident · No injuriesLimited investigationFinal reportCessna 182B · Glencoe, MNcollision with a fence post during landing roll after an inadvertent landing at the wrong field.NTSB FTW94LA169Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Bryan, TXThe pilot's failure to refuel resulting in a total loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB FTW94LA182Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Boerne, TXThe pilot-in-command's inadequate supervision of his deplaning passenger.NTSB LAX94LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Phoenix, AZthe pilot's failure to ensure that the magneto switch was in the off position prior to rotating the propeller by hand.NTSB ATL94LA087Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellijay, GAThe inadvertent deployment of the parachute because of the jumpmaster's inattention to the static line.NTSB CHI94LA141Accident · No injuriesLimited investigationFinal reportCessna 182P · Kahoka, MOThe pilot's failure to determine the wind conditions before attempting to land in conditions which exceeded the performance capability of the airplane.NTSB ATL94LA085Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Athens, ALThe mechanic's failure to properly install an access plug which resulted in the loss of engine oil pressure.NTSB FTW94LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe loss of engine power for undetermined reasons. Factors were the wire strike and lack of suitable terrain.NTSB ANC94LA040Accident · No injuriesLimited investigationFinal reportCessna 180 · Eureka Lodge, AKThe pilot-in-command's selection of unsuitable terrain for a landing.NTSB SEA94LA066Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Nampa, IDThe pilot in command's failure to refuel the aircraft. Factor(s) contributing to the accident were: fuel exhaustion, lack of total experience in type aircraft, and terrain condition (ditch).NTSB CHI94LA085Accident · No injuriesLimited investigationFinal reportCessna 182P · Glen Ullin, NDThe delayed application of the carburetor heat by the pilot-in-command. The carburetor icing weather condition was a factor.NTSB ANC94LA033Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe failure of the pilot-in-command to maintain directional control of the airplane during the landing rollout. Contributing to the accident was the pilot's lack of recent experience in the airplane.NTSB FTW94LA078Accident · No injuriesLimited investigationFinal reportCessna 182P · Meeker, COFailure by the pilot to maintain directional control of the aircraft during landing roll.NTSB LAX94LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Watsonville, CAThe pilot's inadequate preflight inspection by failing to remove the pitot tube cover and delay in his remedial action by not beginning to stop the airplane until it was about 1,000 feet before the end of the runway. The soft terrain and the collapsed nose…NTSB ATL94LA044Accident · No injuriesLimited investigationFinal reportCessna 310A · Dyersburg, TNThe failure of the pilot to attain a proper touchdown point, which resulted in a long landing and an overrun of the runway. Factors were the weather conditions (sky obscuration, low ceiling, fog and drizzle) at the time of the accident, and the wet runway…NTSB CHI94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Centerville, IAthe pilot's failure to refuel the airplane during the flight. Factors related to the accident were the inaccurate fuel consumption calculations for the airplane and the fence.NTSB FTW94LA051Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Dalhart, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB LAX94LA067Accident · No injuriesLimited investigationFinal reportCessna 182Q · Grand Canyon, AZthe pilot's use of an excessive approach airspeed and an improper bounced landing recovery technique.NTSB LAX94LA035Accident · No injuriesLimited investigationFinal reportCessna 182P · Redding, CAthe pilot's use of an excessive airspeed on final approach, the failure to attain the proper touchdown point on the runway, and, the failure to initiate a go around when it became clear that the aircraft would excessively overshoot the intended touchdown…NTSB CHI94LA029Accident · No injuriesLimited investigationFinal reportCessna 182N · Onaga, KSthe pilot-in-command's poor pre-flight planning and failure to maintain runway alignment. Factors were the dark light conditions and the lack of runway lights.NTSB NYC94LA020Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Griswold, CTThe pilot's inadequate compensation for wind conditions during takeoff, and the subsequent loss of control and collision with trees. A factor related to the accident were the adverse winds.NTSB CHI94LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Belleville, MIwas wind information not used by the pilot-in-command and a resultant exceeding of the airplane's performance capabilities.NTSB SEA94LA017Accident · No injuriesLimited investigationFinal reportCessna 182R · Tooele, UTAirspeed was not maintained.NTSB ANC94LA010Accident · No injuriesLimited investigationFinal reportCessna CE-180 · King Salmon, AKThe pilot-in-command's selection of unsuitable terrain and the berm on the airstrip.NTSB SEA94LA016Accident · No injuriesLimited investigationFinal reportCessna 180K · Garfield, WAConnecting rod bolt fatigue.NTSB SEA94LA003Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Denton, MTThe pilot in command's failure to maintain adequate clearance with terrain. Factors contributing to the accident were unfavorable winds and the pilot in command's inadquate compensation (premature crosswind turn) for the wind conditions.