NTSB investigations: Continental O-470 series
6,204 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 LAX89LA291Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAInadequate crew coordination between the tow pilot and glider pilot, failure of the glider pilot to obtain proper assistance, and the tow pilot's misunderstanding of the glider pilot's intentions.NTSB MIA89LA236Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Milton, FLFlight in known adverse weather by the pilot. Turbulence from the nearby thunderstorm was a related factor.NTSB NYC89LA200Accident · No injuriesLimited investigationFinal reportCessna 182F · Albany, NYThe pilot's improper flare during landing.NTSB NYC89LA201Accident · No injuriesLimited investigationFinal reportCessna 182R · Warren, VTImproper flare by the pilot, and his improper recovery from a bounced landing.NTSB FTW89LA145Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Comfort, TXThe fuel exhaustion induced power loss which resulted from the fuel pilot's failure to accurately determine the amount of fuel available for the flight.NTSB NYC89LA181Accident · No injuriesLimited investigationFinal reportCessna 185D · Wolfeboro, NHLoss of engine power for an unknown reason. Factors related to the accident were: the obstructions (trees & boats) in the emergency landing area.NTSB NYC89LA218Accident · No injuriesLimited investigationFinal reportCessna 305A · Chalfont, PAThe pilot's improper use of carburetor heat, which resulted in a power loss due to carburetor ice. Factors related to the accident were: carburetor icing conditions and rough/uneven terain in the emergency landing area.NTSB CHI89FA153Accident · No injuriesField investigationFinal reportCessna 182Q · Oshkosh, WIThe pilot of Cessna N95914 misjudging the distance necessary to avoid collisions with a the standing Piper N5937W.NTSB DEN89LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Weston, COWater in the fuel and inadequate preflight by the pilot. A contributing factor was the ditch.NTSB NYC89LA165Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lancaster, NYWater contamination of the fuel, and an inadequate preflight by the pilot-in-command.NTSB ANC89LA114Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKA blocked fuel line between the fuel selector and the engine which caused fuel starvation.NTSB FTW89LA129Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Elmendorf, TXPilot's decision to discontinue the use of carburetor heat, in carburetor icing conditions, that led to a complete loss of power at an altitude insufficient for a safe landing on the airport.NTSB CHI89LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tecumseh, MILoss of engine power for an undetermined reason. The embankment (dirt bank) was a contributing factor.NTSB ANC89LA107Accident · No injuriesLimited investigationFinal reportCessna 180H · Naknek, AKThe pilot's selection of an unsuitable landing area.NTSB ANC89LA098Accident · No injuriesLimited investigationFinal reportCessna 182A · Tyonek, AKSelection of unsuitable terrain by the pilot. Probable contributing factors were the soft sand and the pilot's delay in aborting the takeoff.NTSB ANC89LA095Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKLoss of directional control by the pilot & inadvertent ground loop/swerve of the aircraft during the landing.NTSB DEN89LA137Accident · No injuriesLimited investigationFinal reportCessna 182 · Moab, UTFailure of the pilot to refuel the aircraft before the flight and company induced pressure by the company/operator management, which resulted in fuel exhaustion from a lack of fuel. The terrain conditions and the tree were considered to be contributing…NTSB ANC89LA085Accident · No injuriesLimited investigationFinal reportCessna 180-J · Glennallen, AKPilot used poor judgement and planning for his takeoff.NTSB CHI89DEM01Accident · Serious injuriesFinal reportCessna 188A · Belding, MIThe pilot's poor preflight assessment of the runway condition/aircraft performance capabilities, and the aircraft's resultant failure to attain flying speed. Soft terrain is a factor in the accident.NTSB ANC89LA077Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Green Island, AKFailure of the pilot to select a suitable landing area. Factors related to the accident were: rough water conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB ANC89FA075Accident · No injuriesField investigationFinal reportCessna 180J · Anchorage, AKPilot-in-command's poor judgement, and his lack of initial training (none) in seaplane operations.NTSB ANC89LA072Accident · No injuriesLimited investigationFinal reportCessna 182H · White Mountain, AKThe pilot's selection of the wrong runway, which was closed. A factor related to the accident was: the snow crusted runway.NTSB ANC89LA082Accident · No injuriesLimited investigationFinal reportCessna 180H · Togiak, AKImproper planning/decision by the pilot. Contributing factors were: light conditions at dusk, an unsafe/hazardous condition (drum that someone had left near the landing area).NTSB ATL89LA143Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Lugoff, SCInadequate compensation for wind conditions by the pilot and his failure to maintain adequate speed for the wind conditions, which resulted in a stall on final approach. His excessive use of flaps and the wind conditions were considered to be contributing…NTSB LAX89LA179Accident · No injuriesLimited investigationFinal reportCessna 180 · Cottonwood, AZImproper flight planning/decision by the PIC when he decided to land with such a crosswind, and not maintaining compensation for the crosswind after he decided to attempt the landing.NTSB DEN89LA115Accident · No injuriesLimited investigationFinal reportCessna 182G · St. Xavier, MTThe pilot's failure to maintain airspeed while maneuvering for a forced landing following a failure of the number two piston. Contributing to the accident was smoke in the cockpit.NTSB NYC89LA130Accident · No injuriesLimited investigationFinal reportCessna C182Q · Beaver Falls, PAThe pilot failure to properly flare the airplane during landing and the improper recovery from a bounced landing.NTSB FTW89LA088Accident · No injuriesLimited investigationFinal reportCessna 182 · Owasso, OKInadequate preflight by the pilot, which resulted in fuel exhaustion from lack of fuel. The presence of trees was was a contributing factor.NTSB ANC89LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB FTW89LA080Accident · No injuriesLimited investigationFinal reportCessna 182Q · Leakey, TXThe pilot's improper compensation for wind conditions, improper flare, and improper recovery from a bounced landing. Factors related to the accident were: the gusty wind condition and the pilot's lack of experience in this make and model of aircraft.NTSB MIA89LA131Accident · No injuriesLimited investigationFinal reportCessna 182P · Tavernier, FLFailure of the pilot to maintain runway alignment and retract the flaps to the recommended setting during the go-around.NTSB SEA89LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Arlington, ORThe student pilot touched down too FAR down the runway to allow him to stop before running into a trailer.NTSB MKC89LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Marshall, MNThe failure of an unapproved weld between the exhaust system and muffler. The failed weld resulted in the muffler separating and an in-flight fire.NTSB DEN89LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Los Lunas, NMInadequate preflight by the pilot, which resulted in fuel exaustion from an inadequate supply of fuel. Factors related to the accident were: false fuel quantity indication, hard landing by the pilot, and uneven terrain conditions.NTSB DEN89FA149Accident · 1 fatalField investigationFinal reportCessna 182P · Steamboat Sprg., COThe plt's failure to discontinue the VFR flight when he encountered IMC; and the plt's failure to maintain adequate altitude to clear the mountainous terrain.NTSB LAX89LA149Accident · No injuriesLimited investigationFinal reportCessna 182Q · Eureka, CAThe pilot's improper flare during the landing.NTSB SEA89LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Tacoma, WAThe pilot's improper flare and improper recovery from the bounced landing. Contributing factors were the pilot's low total flight time and his inexperience in the Cessna 180 airplane.NTSB ANC89LA054Accident · No injuriesLimited investigationFinal reportCessna 180-A · Skwentna, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run. A contributing factor to the accident is the pilot's selection of an unsuitable landing/takeoff site.NTSB ATL89FA106Accident · 2 fatalField investigationFinal reportBeech H35 · Knoxville, TNThe pilot's continued operation of the airplane with a known mechanical defect in the engine carburetor/fuel supply system as evidenced by the past history of engine stoppage during ground operation. Contributing to the accident was the pilot's performance of…NTSB MIA89LA103Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Jacksonville, FLFailure of the pilot to use the carburetor heat, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstructions (power lines & vehicles) in the emergency landing area.NTSB LAX89LA118Accident · No injuriesLimited investigationFinal reportCessna 310 · Long Beach, CAThe failure of the landing gear strut on the right main gear due to improper maintenance.NTSB DEN89LA086Accident · No injuriesLimited investigationFinal reportCessna 182 · Tooele, UTInadequate compensation for wind conditions by the pilot which resulted in loss of directional control and inadvertent ground swerve. The quartering crosswind, gusts, and lack of pilot experience were contributing factors.NTSB LAX89LA124Accident · No injuriesLimited investigationFinal reportCessna 182L · Upland, CAThe pilot failed to correct the attitude of the aircraft and achieve proper alignment with the runway prior to landing touchdown.NTSB ATL89LA097Accident · No injuriesLimited investigationFinal reportCessna 180J · W. Columbia, SCImproper torquing of the attachment bolt during installation by unknown person(s), which resulted in the separation of the bolt and nut and subsequent separation of the main landing gear from the airplane.NTSB FTW89LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Temple, TXImproper planning/decision, by the pilot which resulted in fuel exhaustion, due to an inadequate supply o fuel.NTSB CHI89LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Baldwin, WIFailure of the pilot to go around when he landed long with too much speed for the conditions. Factors related to the accident were: the pilot's excessive airspeed, his failure to attain the proper touchdown point, the crosswind, snowy/icy runway conditions,…NTSB SEA89LA047Accident · No injuriesLimited investigationFinal reportCessna 180 · Wrangell, AKThe plt's failure to properly compensate for the wind during takeoff on unsuitable terrain. Contributing to the accident were the terrain conditions and gusting winds.NTSB SEA89LA046Accident · No injuriesLimited investigationFinal reportCessna 180J · Elk City, IDThe pilot's failure to maintain a proper runway alignment on touchdown. Contributing to the accident were the soft snow conditions on the ranch airstrip.NTSB NYC89FA074Accident · 1 fatalField investigationFinal reportCessna 305A · Blairstown, NJDelays by both pilots in releasing the glider tow line after the glider pilot allowed the glider to maneuver excessively above the tow aircraft. The weather conditions were factors.NTSB ATL89LA075Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Russells Point, OHThe pilot's inaccurate evaluation of weather condition, and his failure to use available weather briefing resources. As a result, the pilot encountered structural icing which covered the windscreen, blocking forward visibility.