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 SEA91LA035Accident · No injuriesLimited investigationFinal reportCessna 182-E · Anacortes, WAThe poor inflight decision by the PIC to land on a short grass airstrip in strong gusty tailwind conditions.NTSB SEA91LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Burns, ORThe formation of carburetor ice when the pilot delayed the use of carburetor heat.NTSB CHI91LA040Accident · No injuriesLimited investigationFinal reportCessna 182 · Howell, MIFuel exhaustion due to re-fueling not performed by the PIC. Contributing factors were fuel consumption calculations misjudged by the PIC.NTSB CHI91FA026Accident · 1 fatalField investigationFinal reportCessna 182D · Walker, MIVFR flight into IMC conditions. Factors related to the accident are failure to obtain a preflight weather briefing, becoming lost/disoriented, induction air filter icing, excessive workload, and lack of total experience in type of operation.NTSB ANC91LA010Accident · No injuriesLimited investigationFinal reportCessna 182N · Chugiak, AKThe pilot failed to maintain directional control. Contributing to the accident was the gusty crosswinds and slippery runway.NTSB LAX91LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Portal, AZFailure of the pilot to maintain proper altitude.NTSB CHI91LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Northwood, NDPoor in-flight planning and decision, unsuitable terrain selected by the PIC.NTSB ANC91LA009Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot-in-command's failure to maintain directional control of the airplane during the landing roll.NTSB DEN91LA015Accident · No injuriesLimited investigationFinal reportCessna 182C · Silver City, NMThe pilot's improper planning which resulted in fuel starvation.NTSB ANC91LA004Accident · No injuriesLimited investigationFinal reportCessna 180 · Anchorage, AKThe pilot's failure to maintain directional control. Contributing to the accident was the excessive taxi speed and inadequate maintenance on the brakes by the pilot.NTSB LAX91LA007Accident · No injuriesLimited investigationFinal reportCessna 182M · Bakersfield, CAThe pilot failed to properly recover from the bounced landing. Contributing to the accident was the pilot's lack of familiarity with the airplane.NTSB ANC90LA188Accident · No injuriesLimited investigationFinal reportCessna 180 · Swift River, AKThe pilot-in-command's failure to understand the performance data of the airplane, and his failure to identify unsuitable terrain.NTSB ANC90LA182Accident · No injuriesLimited investigationFinal reportCessna 180-A · Wood Creek, AKThe pilot-in-command's failure to attain proper lift off airspeed. Contributing to the accident was rough and uneven terrain.NTSB SEA90LA184Accident · No injuriesLimited investigationFinal reportCessna 180 · Enterprise, ORThe pilot's failure to maintain directional control of the aircraft during landing.NTSB CHI90LA267Accident · No injuriesLimited investigationFinal reportCessna 182 · Troy, MIA loss of engine power due to failure of the rocker arm bosses on the #2 cylinder.NTSB ANC90LA168Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot-in-command's improper in-flight planning and ultimate fuel exhaustion.NTSB SEA90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Ogden, UTThe failure of the pilot to correct the position of the fuel tank selector, causing erratic engine operation and loss of power.NTSB BFO90DID02Accident · 2 fatalFinal reportCessna 182R · Evington, VAThe pilot's failure to maintain control of the aircraft because of spatial disorientation. A contributing cause is failure of the vacuum system.NTSB SEA90LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Lummi Island, WAThe pilot's failure to maintain directional control while applying brakes after landing.NTSB NYC90LA211Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Peters Twp, PAThe pilot in commands failure to maintain airspeed on final approach resulting in an inadvertent stall and hard landing.NTSB LAX90LA308Accident · No injuriesLimited investigationFinal reportCessna 182P · Fernley, NVThe pilot's final approach airspeed was excessive.NTSB LAX90LA307Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fresno, CAThe pilot's failure to maintain airspeed on final approach, resulting in a stall and a porpoise on landing.NTSB ANC90LA156Accident · No injuriesLimited investigationFinal reportCessna 180-A · Lime Village, AKThe pilot-in-command's failure to understand the performance data during takeoff. Contributing to the accident was the unsuitable terrain not being identified by the pilot-in-command.NTSB FTW90LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Saint Joseph, LAThe pilot's failure to maintain directional control and his use of excessive braking.NTSB FTW90LA159Accident · No injuriesLimited investigationFinal reportCessna 182N · Justin, TXThe unexpected impairment of the pilot. Factors related to the accident were: the pilot's selection of a short grass runway with a tailwind, the high air temperature, and the obstructions (fence & power line) at the end of the runway.NTSB LAX90LA296Accident · Minor injuriesLimited investigationFinal reportCessna 182H · Temecula, CAThe pilot's inadequate preflight that resulted in his continuing flight with an inoperative alternator.NTSB ATL90LA164Accident · No injuriesLimited investigationFinal reportCessna 182N · Knightdale, NCThe failure of the pilot to execute timely go around procedures. The pilot's lack of experience in this make and model of airplane were factors in the accident.NTSB CHI90FA235Accident · 1 fatalField investigationFinal reportCessna 180 · Howell, MIThe pilot's failure to maintain adequate clearance above terrain while maneuvering during takeoff. A factor in the accident was the pilot's attempt to display the aircraft's performance.NTSB SEA90LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Wenatchee, WAImproper installation of the oil filter gasket by maintenance personnel resulting in loss of engine oil and seizure of the engine.NTSB LAX90LA344Accident · No injuriesLimited investigationFinal reportCessna 180 · Tucson, AZThe pilot's failure to maintain adequate distance from a MD-80'S jet exhaust.NTSB BFO90DIG02Accident · Minor injuriesFinal reportCessna 182J · Frederick, MDFailure of the pilot to assure that the magneto (ignition) switch was in the proper position. A factor related to the accident was: partial failure of the magneto switch, which allowed the key to be removed, though the switch was not in the 'off' position.NTSB NYC90LA174Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Hilltown, PAThe pilot receiving training misjudged the airplane's distance from the runway and altitude above the trees. In addition, the CFI failed to provide adequate supervision.NTSB NYC90LA173Accident · No injuriesLimited investigationFinal reportCessna 182G · Cincinnati, OHThe pilot did not properly compensate for the gusty wind conditions, resulting in the airplane landing hard and porpoising.NTSB ATL90LA148Accident · No injuriesLimited investigationFinal reportCessna 182 · Sanford, NCThe failure of the no.1 piston, for undetermined reasons, which resulted in a complete loss of engine power. A factor to the accident was, the forced landing in a soft field.NTSB CHI90LA183Accident · No injuriesLimited investigationFinal reportCessna 180 · Orr, MNThe pilot's failure to perform fuel consumption calculations which resulted in fuel exhaustion and subsequent loss of engine power. Factor was rough/uneven terrain.NTSB ATL90FA144Accident · 1 fatalField investigationFinal reportCessna 305A · Fruitdale, ALThe pilot exercised poor judgment by attempting to operate the airplane while impaired by alcohol.NTSB DEN90LA160Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Akron, COThe pilot's failure to correct a swerve during landing roll. A factor was wind gusts.NTSB NYC90LA155Accident · No injuriesLimited investigationFinal reportCessna 305A · Newburyport, MAFailure of the pilot in command to follow procedures for landing with a banner still attached, contributing to the accident was the improper modification of banner release mechanism.NTSB ANC90LA113Accident · No injuriesLimited investigationFinal reportCessna 180B · Butterfly Lake, AKThe pilot failed to retract the airplane's wheel prior to a water landing. Contributing factors are his failure to follow established procedures/directives, and habit interference caused by his concern over an air traffic conflict during the preceding takeoff.NTSB ANC90LA106Accident · No injuriesLimited investigationFinal reportCessna 180K · Homer, AKThe pilot loss of directional control.NTSB MKC90LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Cottage Grove, MNFuel exhaustion and remedial action not performed by the pilot in command.NTSB LAX90LA226Accident · No injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the pilot's improper compensation for the gusty wind conditions, and her improper bounced landing recovery.NTSB ATL90FA132Accident · 1 fatalField investigationFinal reportCessna 182E · Newland, NCAttempted VFR flight into instrument meteorological conditions.NTSB ANC90LA087Accident · No injuriesLimited investigationFinal reportCessna 180 · Deshka River, AKThe pilot-in-command's failure to maintain directional control.NTSB CHI90LA152Accident · No injuriesLimited investigationFinal reportBeech T-34A · Champaign, ILThe pilot's inadequate compensation for wind conditions, and his failure to adequately flare the aircraft for landing. The adverse wind was a related factor.NTSB SEA90LA096Accident · No injuriesLimited investigationFinal reportCessna 310B · Albany, ORThe pilot's failure to extend the landing gear before landing, when he became distracted by a change in his normal routine.NTSB LAX90LA207Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Colusa, CAThe pilot's failure to maintain directional control during touchdown.NTSB SEA90LA092Accident · No injuriesLimited investigationFinal reportCessna 182A · Tekoa, WAThe pilot turned off the carburetor heat while descending for landing in conditions conducive to carburetor icing.NTSB CHI90LA178Accident · No injuriesLimited investigationFinal reportCessna 182 · Rich Hill, MOInadequate landing flare by the pilot.NTSB BFO90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Evans, WVFailure of the engine due to carburetor float chaffing resulting in a forced landing on unsuitable terrain. Contributing to the accident was failure of the operator to comply with a service bulletin.