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 ANC96LA034Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's improper use of the brakes during landing. The snow berm along the edge of the runway was a factor.NTSB SEA96LA067Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Darrington, WAa ditching of the airplane for undetermined reason(s).NTSB NYC96LA072Accident · No injuriesLimited investigationFinal reportCessna 182L · Weedsport, NYthe pilot's decision to takeoff on a closed snow-covered runway, and his inadequate compensation for a crosswind. A factor in the accident was the pilot's lack of recent flying experience.NTSB LAX96LA136Accident · No injuriesLimited investigationFinal reportCessna 182Q · Avalon, CAthe pilot's improper flare and improper recovery from a bounced landing. Factors relating to the accident were: a visual illusion due to rising terrain at the approach end of the runway, and the pilot's misjudgment of distance and speed during the approach to…NTSB ANC96LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKthe pilot's failure to maintain directional control during landing.NTSB FTW96LA138Accident · No injuriesLimited investigationFinal reportCessna 182A · Walsenburg, COFailure of the pilot to maintain directional control of the airplane after the left main tire went flat during the landing roll. The flat tire was a related factor.NTSB FTW96LA122Accident · No injuriesLimited investigationFinal reportCessna 182P · New Orleans, LAThe pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.NTSB CHI96LA089Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelbyville, ILthe pilot's misjudged flare and improper recovery from a bounced landing. Factors relating to the accident were: the pilot's improper use of procedure by wearing unapproved correcting lenses, and his resultant decreased depth perception.NTSB FTW96LA099Accident · No injuriesLimited investigationFinal reportCessna 182K · Covington, LAthe pilot's delayed touchdown which resulted in a landing with inadequate runway remaining under the wet runway condition. A factor was the wet grass runway.NTSB SEA96LA042Accident · No injuriesLimited investigationFinal reportCessna 182 · Grantsville, UTthe failure of the #5 exhaust valve rocker boss, and the subsequent sticking of the exhaust valve in the closed position. Factors include wet, soft terrain in the only available landing area.NTSB CHI96LA080Accident · No injuriesLimited investigationFinal reportCessna 182J · Waukon, IAthe pilot's inadequate preflight planning/preparation, and his failure to maintain directional control while taxiing. Factors in the accident were the icy runway and the gusty wind conditions.NTSB MIA96WA056Accident · 3 fatalForeign investigationCessna 182M · Trujillo, HondurasNTSB NYC96LA044Accident · 1 fatalLimited investigationFinal reportCessna 182E · Pymatuning, PAthe pilot's intentional suicide.NTSB LAX96LA079Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fallbrook, CAthe pilot's inadequate preflight planning/preparation (failure to ensuring the flight information publication was current); his selection of the wrong runway for landing; his failure to achieve the proper touchdown point during the landing; and his failure to…NTSB CHI96LA061Accident · No injuriesLimited investigationFinal reportCessna 180C · Patoka, INthe pilot's failure to maintain control of the airplane during takeoff.NTSB FTW96LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Erie, COinadequate preflight by the pilot, by failing to properly remove water and other contamination from the fuel system before the flight. Factors relating to the accident were: deteriorated seals at the fuel filler neck/caps, and the annual inspection was…NTSB ATL96FA018Accident · 2 fatalField investigationFinal reportNavion D · Canton, GAThe pilot's impairment of judgement and performance due to drugs which led to his overconfidence of personal ability and continued flight into known adverse weather conditions. The weather conditions and dark night were factors.NTSB FTW96LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Eads, COFailure of the engine connecting rod bolts and separation of the cylinder from the crankcase. Factors were the lack of suitable terrain for the forced landing, and reduced light conditions (dark night).NTSB ANC96TA016Accident · No injuriesFinal reportCessna 182H · Koyuk, AKThe pilot's delayed application of carburetor heat. Factors in the accident were carburetor icing conditions and lack of suitable terrain for a forced landing.NTSB MIA96LA022Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Snellville, GAThe pilot's failure to attain the proper touchdown point on landing. The sunglare and wet grass were factors.NTSB SEA96LA014Accident · No injuriesLimited investigationFinal reportCessna 180J · Stanley, IDthe pilot's failure to maintain clearance with obstacles at the end of the takeoff area. His failure to attain sufficient altitude to clear the obstacles was a factor.NTSB LAX96LA040Accident · 2 fatalLimited investigationFinal reportCessna 180 · Placerville, CAthe pilot's intentional buzzing, his failure to identify an obstruction (inadequate visual lookout), and his failure to maintain adequate altitude/clearance from the obstruction (utility pole). Factors relating to the accident were: dust generated by farm…NTSB CHI96LA020Accident · No injuriesLimited investigationFinal reportCessna 180A · Goose Lake, IAinadequate maintenance, inadequate preflight by the pilot, and a loose fuel tank cap that allowed siphoning of fuel, buckling of the right fuel bladder, fuel exhaustion, and loss of engine power. Factors relating to the accident were: darkness, and the soft…NTSB LAX96LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Auburn, CAthe pilot's failure to maintain directional control following a hard landing. His physical impairment was a factor.NTSB CHI96LA018Accident · No injuriesLimited investigationFinal reportCessna 180G · Belle Fourche, SDthe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the airplane while landing. A factor in the accident was the crosswind conditions.NTSB FTW96LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Norman, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB CHI96LA009Accident · No injuriesLimited investigationFinal reportCessna 180R · Seattle, WAthe pilot's failure to maintain control of the airplane during the landing roll. A factor in the accident was the gusty wind conditions.NTSB FTW96LA016Accident · No injuriesLimited investigationFinal reportCessna 182E · Fort Collins, COa fatigue failure of the right main landing gear. Factors were the pilot's failure to attain the proper touchdown point and his inadequate compensation for the crosswind conditions.NTSB CHI96FA002Accident · 2 fatalField investigationFinal reportBeech H35 · Ozark, MOthe pilot's improper fuel management which resulted in fuel starvation, and his failure to maintain airspeed during the forced landing.NTSB ANC95LA176Accident · No injuriesLimited investigationFinal reportCessna 180 · Craig, AKThe pilot's selection of an unsuitable taxi/takeoff area.NTSB BFO95LA098Accident · No injuriesLimited investigationFinal reportCessna 182 · Annapolis, MDThe pilot's failure to maintain control of the airplane during the landing roll. Related factors were the sudden thunderstorm, the high gusty winds, and the sudden windshift to a tailwind during the touchdown/landing roll.NTSB ANC95LA170Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKFailure of the main landing gear wheel that had been modified for a tundra tire.NTSB ANC95LA164Accident · No injuriesLimited investigationFinal reportCessna 180A · Glennallen, AKThe pilot's selection of an unsuitable area for takeoff. The water condition with large waves/swells was a related factor.NTSB CHI95LA319Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Yale, MIloss of engine power due to an inadequate fuel supply leading to fuel exhaustion. The inadvertent stall during the forced landing was a factor.NTSB ANC95LA156Accident · No injuriesLimited investigationFinal reportCessna 180 · Igiugig, AKThe pilot's inadequate preflight planning/preparation to assure the airplane would maintain adequate altitude/clearance from the river bank during takeoff.NTSB LAX95LA307Accident · No injuriesLimited investigationFinal reportCessna 182Q · Georgetown, CAthe pilot's inadequate compensation for the gusting crosswind conditions.NTSB ANC95LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Kenai, AKThe pilot's selection of an inadequately prepared landing area.NTSB ANC95LA146Accident · No injuriesLimited investigationFinal reportCessna 180 · Fort Yukon, AKThe pilot's selection of an unsuitable takeoff area.NTSB ANC95LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Nikiski, AKThe pilot's selection of unsuitable terrain for landing. Soft terrain and contamination in the left brake cylinder were related factors.NTSB ANC95LA120Accident · No injuriesLimited investigationFinal reportCessna 182 · Kenai, AKFailure of the pilot to remain clear of the duck shack (building) during the takeoff roll. The crosswind and proximity of the building were related factors.NTSB FTW95LA302Accident · No injuriesLimited investigationFinal reportCessna 182L · Oklahoma City, OKFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for a forced landing.NTSB CHI95LA223Accident · No injuriesLimited investigationFinal reportCessna 182C · Derby, KSthe pilot's improper use of the powerplant controls, which resulted in a rough running engine and partial loss of engine power.NTSB ANC95LA100Accident · No injuriesLimited investigationFinal reportCessna 180K · King Salmon, AKFailure of the pilot to adequately compensate for wind conditions, which resulted in a failure to maintain directional control. The downdraft and crosswind were related factors.NTSB ANC95LA097Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's selection of unsuitable terrain for taxi.NTSB SEA95LA140Accident · No injuriesLimited investigationFinal reportCessna 182R · Copalis Beach, WAThe pilot's selection of an unsuitable landing area.NTSB FTW95LA269Accident · No injuriesLimited investigationFinal reportCessna 180E · Springdale, ARThe pilot's failure to compensate for the crosswind conditions. Factors were the crosswind, and the pilot's improper weather evaluation.NTSB CHI95LA209Accident · No injuriesLimited investigationFinal reportCessna 182S · New Haven, MIThe pilot's improper raising of the flaps during the aborted landing. Factors associated with this accident were the pilot selecting the wrong runway, not attaining the appropriate touchdown point on the runway, and delay in aborting the landing.NTSB BFO95FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Frederick, MDthe pilot's continued flight into known adverse weather during descent, which resulted in in-flight collision with terrain. Related factors were the pilot's disregard of a hazardous weather advisory, and the low ceilings, fog and drizzle.NTSB ANC95LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Minto, AKThe pilot's failure to abort the takeoff in a timely manner. A factor relating to the accident was: the pilot's failure to use all of the available area (waterway) for the takeoff.NTSB BFO95LA068Accident · No injuriesLimited investigationFinal reportCessna 180H · Chatsworth, NJthe pilot's failure to maintain directional control during the takeoff roll. Related factors were the gusty crosswind conditions.