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 SEA98LA174Accident · No injuriesLimited investigationFinal reportCessna 180J · Oroville, WAThe pilot-in-command's failure to establish and maintain proper alignment.NTSB NYC98LA176Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bingham, METhe pilot's inattention to changing wind conditions, and lack of correction for the change. A factor in the accident was the damp grass runway.NTSB CHI98LA327Accident · No injuriesLimited investigationFinal reportCessna 310B · Breezy Point, MNthe pilot's improper flare of the airplane, and his not maintaining control of the airplane.NTSB ANC98LA127Accident · No injuriesLimited investigationFinal reportCessna 180 · Cordova, AKThe pilot's failure to maintain directional control during takeoff. Factors associated with the accident were soft airstrip conditions, and trees.NTSB FTW98LA373Accident · No injuriesLimited investigationFinal reportCessna 182L · St. George, UTThe pilot's failure to maintain control of the airplane. Factors were excessive airspeed and allowing the airplane to porpoise with subsequent loss of directional control.NTSB SEA98LA167Accident · No injuriesLimited investigationFinal reportCessna 180 · Anaconda, MTA ground-loop resulting from the pilot's inadequate remedial action while attempting to correct for an inadvertent loss of directional control during the landing roll. Factors include the loss of directional control and attempting to land with a tailwind.NTSB ATL98LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Lantana, FLThe pilot's inadequate preflight inspection of the fuel system that resulted in the loss of engine power due to water contamination. A factor was the rough terrain on the departure end of the runway.NTSB SEA98LA158Accident · No injuriesLimited investigationFinal reportCessna 182 · Yellowpine, IDRight main landing gear spring strut fatigue, improper maintenance, and subsequent separation of the strut end.NTSB LAX98LA259Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Willits, CAThe pilot's selection of an inadequate landing area and failure to maintain clearance from obstacles during the landing roll.NTSB FTW98LA343Accident · Minor injuriesLimited investigationFinal reportCessna 182R · Watkins, COThe pilot's loss of control during taxi due to excessive taxi speed.NTSB CHI98LA297Accident · No injuriesLimited investigationFinal reportCessna 180 · Oshkosh, WIthe pilot of the other airplane did not maintain proper clearance.NTSB LAX98LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · California City, CAThe pilot's failure to assure that an adequate supply of fuel was available for the flight and his inadequate preflight planning/preparation.NTSB FTW98FA333Accident · 4 fatalField investigationFinal reportCessna 182P · Jal, NMThe pilot's failure to maintain adequate airspeed. Contributing factors were high density altitude and excessive airplane weight.NTSB MIA98LA204Accident · No injuriesLimited investigationFinal reportCessna 182P · Concord, NCthe failure of the pilot to maintain directional control and his failure to maintain wingtip clearance with trees that border the right side of the runway.NTSB ANC98LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Fairbanks, AKThe pilot's failure to attain the proper touchdown point. A factor associated with this accident was the high brush at the approach end of the landing area.NTSB IAD98LA093Accident · No injuriesLimited investigationFinal reportCessna 182 · Edgartown, MAwas the pilot's improper flare prior to touchdown.NTSB CHI98LA261Accident · No injuriesLimited investigationFinal reportCessna 182A · Springbrook, WIThe pilot's improper attitude and excessive sink rate during landing. The terrain condition was a contributing factor in the accident.NTSB CHI98LA246Accident · No injuriesLimited investigationFinal reportCessna 182L · Mackinac Island, MIThe pilot's failure to attain a stabilized approach and a touchdown point. The factors contributing to the accident were the pilot in command's improper use of flaps and his not performing a go-around. An additional factor was the pilot in command not using…NTSB FTW98LA300Accident · No injuriesLimited investigationFinal reportBeech H35 · Marshall, TXThe loss of engine power due to fuel starvation as a result of the improper position of the fuel selector. A factor was the pilot's lack of experience in this make and model of airplane.NTSB ATL98LA092Accident · 1 fatalLimited investigationFinal reportCessna 182 · Green Sea, SCThe inadvertent activation of the skydivers pilot chute, pulling him into the horizontal stabilizer/elevator, resulting in substantial damage to the airplane.NTSB SEA98LA117Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Big Creek, IDDirectional control was not maintained. A wet runway surface was a factor.NTSB SEA98LA114Accident · No injuriesLimited investigationFinal reportCessna 182P · Chico Hot Spgs., MTThe pilot's inadequate remedial action while attempting to compensate for a change in crosswind velocity. Factors include a crosswind, hills near the runway, and high vegetation (weeds) near the runway.NTSB LAX98LA216Accident · No injuriesLimited investigationFinal reportCessna 180H · Ocotillo Wells, CAFailure of the left main landing gear due to a probable hard landing at an undetermined time.NTSB CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.NTSB FTW98LA277Accident · No injuriesLimited investigationFinal reportCessna 180 · Albuquerque, NMThe pilot's failure to maintain control of the aircraft during landing roll. A factor was crosswind.NTSB MIA98LA174Accident · No injuriesLimited investigationFinal reportCessna 180D · Natchez, MSThe pilot's improper use of brakes on landing rollout. The tailwind was a factor.NTSB CHI98LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Independence, MOA loss of engine power due to the separation of the induction system balance tube coupling from the intake manifold tube assembly. A related factor was the soft field.NTSB ANC98LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Palmer, AKThe pilot's failure to abort the landing. A factor associated with the accident is the presence of a variable wind condition.NTSB IAD98LA069Accident · No injuriesLimited investigationFinal reportCessna 182L · Marlborough, MAThe pilot's improper flare. A related factor was the crosswind.NTSB FTW98LA230Accident · No injuriesLimited investigationFinal reportCessna 180 · Abilene, TXThe pilot's improper compensation for the crosswind conditions resulting in a ground loop. A factor was the crosswind condition.NTSB CHI98LA137Accident · No injuriesLimited investigationFinal reportCessna 305 · Fredricktown, MOthe pilot's failure to maintain aircraft control after landing. Factors contributing to this accident were the embankment, and the soft , muddy soil making up the embankment.NTSB CHI98LA135Accident · No injuriesLimited investigationFinal reportCessna C-182 · Emporia, KSThe pilot's failure to maintain control of the airplane. Factors contributing to this accident were the strong crosswind and the wind gusts.NTSB FTW98LA184Accident · No injuriesLimited investigationFinal reportCessna 182N · Albuquerque, NMThe pilot's failure to attain the proper touchdown point during landing, resulting in an overrun, and his exceeding the airplane's maximum crosswind component. A factor was the gusty crosswind.NTSB FTW98LA177Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Las Cruces, NMthe pilot's improper use of (or failure to use) carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Related factors were: the carburetor icing (weather) conditions, and the lack of suitable terrain for a forced…NTSB MIA98FAMS2Accident · 1 fatalMissing aircraftFinal reportCessna 182H · MissingUndetermined.NTSB CHI98LA109Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Whitewood, SDfailure of the pilot to maintain clearance from obstructions (wires) during an approach for a precautionary landing. Factors associated with the accident were: the pilot's inadequate evaluation of the weather conditions, low ceilings, icing conditions, and…NTSB LAX98LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Santa Rosa, CAThe loss of engine power for undetermined reasons.NTSB IAD98LA031Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Fogelsville, PAThe pilot's failure to maintain control of the aircraft upon glider release. A contributing factor was the high vegetation (corn).NTSB LAX98LA107Accident · No injuriesLimited investigationFinal reportCessna 182 · Pioche, NVThe total loss of engine power due to carburetor icing. An additional factor in this accident was the pilot's decision to make the flight under known icing conditions.NTSB ANC98LA024Accident · No injuriesLimited investigationFinal reportCessna 180H · Tatitna, AKThe pilot's selection of unsuitable terrain for landing. A factor was the snow machine ruts creating a rough landing surface.NTSB ANC98LA021Accident · No injuriesLimited investigationFinal reportCessna 180H · Anchorage, AKThe pilot's failure to attain the proper touchdown point on the runway. Factors in the accident were: snow covered terrain at the approach end of the runway and flat light conditions.NTSB LAX98LA088Accident · No injuriesLimited investigationFinal reportCessna 182P · Payson, AZThe collapse of the nose landing gear for undetermined reasons.NTSB NYC98LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · East Moriches, NYthe pilot's improper planning/decision, and failure to attain rotation the airplane for lift-off, which led to an aborted takeoff and collision with a fence. The proximity of the fence was a related factor.NTSB SEA98LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Sun Valley, IDthe pilot's inadvertent actuation of the parking brake.NTSB FTW98LA115Accident · No injuriesLimited investigationFinal reportCessna 182E · Steamboat Sprng, COThe total nonmechanical power loss due to the formation of carburetor ice. A factor was the deep snow covered field on which the forced landing was made.NTSB FTW98LA113Accident · No injuriesLimited investigationFinal reportCessna 182Q · Keeline, WYfailure of the pilot to maintain directional control of the airplane during the landing roll. Factors relating to the accident included: a snow covered/icy/muddy area on the runway, and the proximity of a snowbank to the runway.NTSB ANC98LA015Accident · No injuriesLimited investigationFinal reportCessna 180H · Chugiak, AKthe pilot's selection of an unsuitable area for landing. A factor relating to the accident was: the crusty, snow covered surface of the airstrip.NTSB FTW98LA077Accident · No injuriesLimited investigationFinal reportCessna 180J · Fort Worth, TXthe pilot's improper planning/decision, by allowing the airplane to get in a situation, where he could not compensate for wind conditions. A related factor was the gusty crosswind.NTSB LAX98LA060Accident · No injuriesLimited investigationFinal reportCessna 180H · Santa Ynez, CAThe pilot's improper flare. Related factors were the crosswind conditions.NTSB NYC98LA042Accident · No injuriesLimited investigationFinal reportCessna 182P · Chatham, MAloss of engine power for undetermined reason(s). The tail wind component and an encounter with a ditch were related factors.