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 ATL91LA151Accident · No injuriesLimited investigationFinal reportCessna 182L · Macon, NCThe pilot's failure to accurately judge the distance required to stop the airplane. A factor in the accident was the wet, grass runway surface at the time of the accident.NTSB ANC91LA110Accident · No injuriesLimited investigationFinal reportCessna 182C · Cordova, AKA total loss of engine power while operating over water.NTSB ANC91LA105Accident · No injuriesLimited investigationFinal reportCessna 182 · Girdwood, AKImproper in flight planning, fuel starvation and fuel supply not understood by the pilot. Contributing to the accident was rough and uneven terrain.NTSB SEA91LA185Accident · No injuriesLimited investigationFinal reportCessna 180 · Cody, WYPilot's failure to maintain proper runway alignment. Factors were diverted attention, and gusty crosswinds.NTSB SEA91FA181Accident · 2 fatalField investigationFinal reportCessna 180J · Newcastle, WYPilot factor in that he did not maintain sufficient flying speed and allowed the aircraft to enter an inadvertent stall/spin. Factors include high density altitude.NTSB LAX91LA306Accident · 1 fatalLimited investigationFinal reportCessna 182 · Wailua, HIThe accidental deployment of jumpers reserve parachute inside the airplane.NTSB NYC91LA177Accident · No injuriesLimited investigationFinal reportCessna L-19 · Franconia, NHThe failure of the pilot to maintain airspeed, which resulted in a stall/spin and in flight collision with trees. Factors related to the accident were the improper in-flight planning by the pilot and the pilot's failure to compensate for winds and downdraft.NTSB NYC91LA175Accident · No injuriesLimited investigationFinal reportCessna 182 · Xenia, OHTotal loss of engine power due to fuel exhaustion resulting in a forced landing and subsequent nose over during the landing roll. Factors related to the accident was the pilot's failure to ensure sufficient fuel was available for the flight.NTSB CHI91LA215Accident · No injuriesLimited investigationFinal reportCessna 182A · Menomonee Falls, WIThe fatigue induced propeller blade failure. A related factor was the operator's delayed propeller overhaul.NTSB LAX91LA278Accident · No injuriesLimited investigationFinal reportCessna 182Q · Watsonville, CAThe pilot's improper flare and improper recovery from a bounced landing. Factors related to the accident were: gusty winds, the pilot's inadequate compensation for wind conditions, and the pilot's lack of experience in this make and model of aircraft.NTSB BFO91LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Baltimore, MDThe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI91LA198Accident · No injuriesLimited investigationFinal reportCessna 180 · Grayling, MIThe pilot in command's failure to maintain directional control during landing roll.NTSB CHI91LA197Accident · No injuriesLimited investigationFinal reportCessna 180 · Grand Rapids, MNThe pilot's failure to maintain a proper airspeed during landing and the improper recovery from a bounced landing. Factors related to the accident were the pilot's lack of total experience in seaplanes and the gusty wind condition.NTSB ATL91LA114Accident · No injuriesLimited investigationFinal reportCessna 182R · Dothan, ALLack of supervision by the flight instructor who allowed a dual student to make a hard landing.NTSB SEA91LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Pleasant Grove, UTThe pilot's failure to maintian proper airspeed while on final approach.NTSB DEN91LA084Accident · No injuriesLimited investigationFinal reportCessna 182Q · Lafayette, COThe pic's abrupt touchdown. Factors were: approach reference speed not maintained, proper descent rate not maintained by the PIC and inattention by the designated examiner.NTSB CHI91LA180Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNBecause of inadequate compensation for the wind conditions, aircraft control was lost by the pilot. A factor related to the accident was a gusty crosswind landing environment.NTSB FTW91LA096Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Farmerville, LAA fuel starvation induced power loss due to the pilot's failure to select the proper fuel tank.NTSB CHI91LA189Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Wausa, NEThe pilot's delayed decision to turn around after encountering IFR flight conditions. Factors were restricted forward visibility and power lines.NTSB ANC91LA073Accident · No injuriesLimited investigationFinal reportCessna 180 · Pilot Point, AKFuel exhaustion, due to the Pilot's inadequate preflight. Contributing to the accident was the soft and rough terrain.NTSB LAX91LA243Accident · 2 fatalLimited investigationFinal reportCessna 182E · Eureka, CAThe non-instrument rated pilot's inadvertent flight into IMC conditions. The pilot's lack of total experience, his disregard to the preflight meteorological briefing he received, low ceilings, fog, and the mountainous terrain over which the flight was…NTSB LAX91FA252Accident · 3 fatalField investigationFinal reportCessna 182 · Bermuda Dunes, CAThe pilot-in-command's failure to maintain airspeed while maneuvering to return to the departure airport, resulting in an in flight loss of control, stall, and in flight collision with terrain. Factors related to the accident were: partial loss of engine…NTSB DEN91LA081Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Fe, NMThe pilot misjudged the flare during landing.NTSB CHI91DEP07Accident · No injuriesFinal reportCessna 182M · Wissota, WIThe pilot in command's misjudgment of the proper touchdown point during an emergency landing and the pilot in command's failure to refuel the airplane.NTSB LAX91LA246Accident · No injuriesLimited investigationFinal reportCessna 182 · Lincoln, CAThat the pilot-in-command improperly flared the airplane by misjudging the altitude and improper recovery from the bounced landing.NTSB SEA91LA125Accident · No injuriesLimited investigationFinal reportCessna C-182A · Buhl, IDThe intentional high speed buzzing by the pilot, and his failure to maintain clearance from obstacles on the ground.NTSB CHI91LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Devils Lake, NDDirectional control not maintained by the pilot. A factor related to the accident was a crosswind condition.NTSB CHI91LA158Accident · No injuriesLimited investigationFinal reportCessna 180 · Scottsbluff, NEFailure of the pilot to maintain directional control during the landing roll. Factors related to the accident were a crosswind condition and lack of total experience in type of aircraft by the pilot.NTSB SEA91LA103Accident · No injuriesLimited investigationFinal reportCessna 182N · Shelton, WAThe total loss of power due to mechanical failure when the pilot was over unsuitable terrain for a forced landing. Factors include a hard landing after an inadvertent stall prior to touchdown on a highway.NTSB CHI91LA148Accident · No injuriesLimited investigationFinal reportCessna 182L · Port Huron, MIThe pilot's inadequate landing flare during the forced landing. The pilot's failure to use carburetor heat was a factor.NTSB LAX91LA199Accident · No injuriesLimited investigationFinal reportCessna 182 · Phoenix, AZThat the pilot failed to properly preflight the airplane to assure the engine contained an adequate oil supply. Contributing to this accident was total failure of the connecting rod due to lack of lubrication.NTSB LAX91LA192Accident · No injuriesLimited investigationFinal reportCessna 180 · Truckee, CAThat the pilot improperly used the flight controls and brakes to arrest the runway excursion. Contributing to this accident was encountering unfavorable winds, crosswind conditions, and lack of experience in this type of airplane.NTSB LAX91LA185Accident · No injuriesLimited investigationFinal reportCessna 182B · Arvin, CA1) The pilot inadequately compensated for wind conditions; 2) the pilot's improper inflight decision; and 3) the pilot not attaining the proper landing touchdown point.NTSB SEA91LA094Accident · No injuriesLimited investigationFinal reportCessna 180 · Vernal, UTThe pilot's impairment due to alcohol consumption and his failue to control the airplane during landing.NTSB ATL91LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Elberta, ALThe pilot's failure to apply carburetor heat. Factors were weather conditions for the formation of induction ice, and the soft terrain.NTSB LAX91LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Madera, CAThat the pilot's fuel consumption calculation were inaccurate. Contributing to this accident was fuel exhaustion.NTSB ANC91FA050Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Tatitlek, AKFailure of both pilots to see-and-avoid each other (inadequate visual lookout). A factor related to the accident was: inadequate communication among all participating aircrews.NTSB ANC91LA047Accident · No injuriesLimited investigationFinal reportCessna 180F · Yukon River, AKA carburetor fuel leak due to inadequate annual inspection. Contributing to the accident was the snow covered terrain.NTSB LAX91LA151Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Lake Elsinore, CAUndetermined engine power loss. A factor ws the soft terrain.NTSB DEN91LA054Accident · No injuriesLimited investigationFinal reportBeech H35 · Greeley, COThe pilot's inadvertent activation of the landing gear switch causing the landing gear to collapse while the aircraft was still on the landing roll.NTSB LAX91FA173Accident · 4 fatalField investigationFinal reportCessna 182F · Young, AZThe pilot's inadequate in-flight decision to continue VFR flight into instrument meteorological conditions and the loss of control of the airplane resulting in an inflight collision with terrain.NTSB CHI91LA119Accident · No injuriesLimited investigationFinal reportCessna 182P · Loup City, NEThe pilot's improper landing/touchdown. A related factor was the pilot's lack of total flight experience.NTSB ANC91LA035Accident · No injuriesLimited investigationFinal reportCessna 180K · Amos Lakes, AKThe pilot's selection of terrain that was rough, snow-covered and icy for takeoff.NTSB CHI91FA088Accident · 7 fatalField investigationFinal reportPiper PA-28-140 · Osceola, WIFailure of the pilots in both aircraft to seeing-and-avoid the other airplane.NTSB ATL91LA045Accident · No injuriesLimited investigationFinal reportCessna 182A · Warm Springs, GAAn electrical short related to the alternator from an undetermined source.NTSB MIA91LA063Accident · Serious injuriesLimited investigationFinal reportCessna 182N · La Belle, FLThe pilot's failure to maintain altitude. A factor was the pilot's failure to obtain a weather forecast.NTSB NYC91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Princeton, NJPilot factor in that the pilot failed to use carburetor heat resulting in engine power loss due to carburetor ice. Factors were unsuitable terrain and obstructions.NTSB SEA91FA038Accident · 2 fatalField investigationFinal reportCessna 182B · Estacada, ORA power loss due to carburetor ice, and missing muffler cones as a result of inadequate maintenance inspection. In addition, the pilot failed to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB MIA91FA058Accident · Serious injuriesField investigationFinal reportCessna 310 · New Smyrna Bch, FLThe pilot-in-command/mechanic reversal of the aileron control cables on the sprocket during installation. This resulted in an in flight loss of control on takeoff, uncontrolled descent, and in flight collision with terrain.NTSB LAX91LA062Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Imperial, CAFuel exhaustion.