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 CEN09FA430Accident · Serious injuriesField investigationFinal reportBeech 35-A33 · Las Vegas, NMThe loss of engine power for undetermined reasons.NTSB WPR09FA334Accident · 2 fatalField investigationFinal reportCessna 182P · Mammoth Lakes, CAThe pilot's improper in-flight planning/decision to attempt to fly at a low altitude in a confined area of mountainous terrain in a high density altitude weather condition, and his failure to maintain clearance from the trees.NTSB CEN09CA419Accident · No injuriesData collectionFinal reportCessna 182Q · Ballinger, TXThe loss of engine power due to fuel exhaustion as a result of the pilot's inadequate pre-flight planning.NTSB WPR09CA332Accident · Minor injuriesData collectionFinal reportCessna 182M · Wilson Bar, IDThe pilot’s misjudged approach that led to a long landing and his failure to execute a go-around when he realized that he overshot his intended point of landing.NTSB WPR09CA335Accident · No injuriesData collectionFinal reportCessna 180 · La Grande, ORThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB ANC09CA057Accident · No injuriesData collectionFinal reportCessna 180F · King Salmon, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.NTSB WPR09CA278Accident · No injuriesData collectionFinal reportCessna 180J · Bellingham, WAThe pilot's failure to maintain directional control during landing.NTSB WPR09FA282Accident · 1 fatalField investigationFinal reportCessna 182M · Atlanta, IDThe pilot's failure to maintain terrain clearance during cruise flight.NTSB ERA09CA363Accident · No injuriesData collectionFinal reportCessna 182P · Destin, FLThe pilot's improper recovery from a bounced landing.NTSB CEN09LA325Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Skiatook, OKLoss of engine power for undetermined reasons.NTSB CEN09CA317Accident · Serious injuriesData collectionFinal reportCessna 182E · Martinsville, INThe pilot's failure to attain the proper touchdown point during landing and his delay in initiating a successful go-around, which resulted in a loss of airspeed and an aerodynamic stall.NTSB WPR09LA242Accident · No injuriesLimited investigationFinal reportCessna 182M · Madera, CAThe pilot’s failure to maintain directional control of the airplane throughout the landing.NTSB WPR09LA223Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Puyallup, WAA loss of engine power due to fuel starvation as a result of the pilot’s failure to verify the fuel levels in the tanks, and, his failure to select the proper fuel tank.NTSB WPR09CA194Accident · Minor injuriesData collectionFinal reportCessna 182A · Las Vegas, NVThe pilot's inadequate compensation for the gusty crosswind conditions while landing.NTSB WPR09LA179Accident · No injuriesLimited investigationFinal reportCessna 182 · Kalispell, MTA partial loss of engine power during a go-around for undetermined reasons. Contributing to the accident was a fatigue failure of the right main landing gear spring.NTSB ANC09CA027Accident · No injuriesData collectionFinal reportCessna 180K · Bettles, AKThe pilot's selection of an unsuitable landing area.NTSB WPR09LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's failure to achieve the proper touchdown point during a full-stop landing attempt. Contributing to the accident were the pilot's failure to ensure that the aircraft was properly configured for landing, his not initiating a go-around, and a…NTSB WPR09LA167Accident · No injuriesLimited investigationFinal reportCessna 180G · Wendover, UTA loss of directional control during landing as a result of the binding in one main landing gear brake assembly due to incorrect maintenance procedures. Contributing to the accident was the pilot's failure to correctly reconfigure the airplane during an…NTSB ERA09FA215Accident · 1 fatalField investigationFinal reportCessna 182Q · Lexington, KYThe pilot's failure to maintain control of the airplane for undetermined reasons.NTSB WPR09FA154Accident · 1 fatalField investigationFinal reportCessna 180F · Townsend, MTThe pilot's failure to maintain clearance from trees and terrain while maneuvering at a low altitude.NTSB ERA09FA185Accident · 3 fatalField investigationFinal reportCessna 182P · Carrollton, GAThe pilot's decision to continue visual flight rules flight into an area of reduced visibility weather conditions, which resulted in disorientation and subsequent loss of aircraft control.NTSB CEN09FA178Accident · 3 fatalField investigationFinal reportCessna 182M · Albany, LAThe pilot's loss of control of the airplane due to spatial disorientation after an encounter with marginal VMC and/or instrument meteorological conditions. Contributing to the accident was the pilot’s decision to attempt the flight with the preflight…NTSB WPR09CA121Accident · Minor injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat before reducing power and his failure to clear the engine during a prolonged glide.NTSB CEN09LA183Accident · No injuriesLimited investigationFinal reportCessna 182 · Kelleys Island, OHThe pilot's failure to maintain aircraft control while landing in gusty winds due to inadequate aileron cable tension.NTSB CEN09LA167Accident · No injuriesLimited investigationFinal reportBeech H35 · Grain Valley, MOThe loss of engine power due to fuel starvation (mechanical). Contributing to the accident was the forced landing on unsuitable terrain.NTSB CEN09CA191Accident · No injuriesData collectionFinal reportCessna 182Q · Clinton, ARThe pilot's improper flare, resulting in a hard landing. Contributing to the accident was the gust of wind as reported by the pilot.NTSB CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.NTSB ERA09FA068Accident · 3 fatalField investigationFinal reportBeech 95-B55 (T4 · Whites Creek, TNThe pilot's failure to feather the left propeller and secure the left engine following the total loss of left engine power, and his subsequent failure to maintain airspeed, lateral, and directional control of the airplane. Contributing to the accident was the…NTSB CEN09LA061Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Downers Grove, ILThe pilot's failure to maintain a proper glidepath while on final approach in night conditions, due to his impairment from recent use of alcohol, cocaine, and over-the-counter and prescription medications.NTSB ANC09LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairbanks, AKThe failure of the instructor pilot in the other airplane to maintain separation from the Cessna 182R, and his failure to follow the tower controller’s instructions.NTSB CEN09LA056Accident · 1 fatalLimited investigationFinal reportCessna 182M · Basalt, COThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in his loss of control of the airplane in flight.NTSB WPR09CA035Accident · No injuriesData collectionFinal reportCessna 305A · El Cajon, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN09LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Whitewater, COBoth pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.NTSB CEN09CA027Accident · Minor injuriesData collectionFinal reportCessna 180 · Denton, TXThe pilot's loss of directional control and subsequent "ground-loop."NTSB CEN09CA004Accident · No injuriesData collectionFinal reportCessna 182P · Mount Vernon, MOThe pilot failed to maintain a proper landing aim point. Contributing to the accident were the setting sun and the uneven terrain approaching the runway.NTSB SEA08CA211Accident · No injuriesData collectionFinal reportCessna 180 · Bluff, UTThe pilot's encounter with the rough, uneven, and eroded condition of the airstrip.NTSB DFW08LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Orange Grove, TXA total loss of engine power due to an improperly installed intake manifold tube.NTSB MIA08LA180Accident · No injuriesLimited investigationFinal reportCessna 182A · Elizabethtown, KYA loss of engine power due to fuel exhaustion. Contributing to the accident was pressure from the company for the pilot to fly the second load of skydivers without refueling.NTSB NYC08CA295Accident · No injuriesData collectionFinal reportCessna 182A · Danielson, CTFuel exhaustion due to the pilot’s inadequate fuel consumption calculations.NTSB DFW08CA214Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Keller, TXThe pilot's inadequate preflight inspection of the airplane which resulted in an attempted takeoff without fuel present in the selected fuel tank.NTSB LAX08CA270Accident · No injuriesData collectionFinal reportCessna 182Q · Mesa, AZThe pilot's failure to maintain directional control during landing.NTSB DFW08LA210Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Caldwell, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's failure to secure the right wing's fuel cap, leading to fuel being siphoned from the tank during flight.NTSB CHI08CA255Accident · No injuriesData collectionFinal reportCessna 182C · Sparta, ILThe pilot's inadequate preflight/planning which resulted in the failure to assure an adequate fuel supply for the flight and the improper flare during the landing. Contributing to the accident was the ditch that the airplane contacted.NTSB ANC08FA133Accident · 2 fatalField investigationFinal reportCessna 182 · Juneau, AKThe pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in the pilot experiencing a loss of visual reference and subsequent controlled flight into terrain. Contributing to the accident was the…NTSB SEA08FA175Accident · 2 fatalField investigationFinal reportCessna 180K · Garden City, UTThe pilot's failure to maintain adequate airspeed, which led to an aerodynamic stall/spin.NTSB ANC08CA102Accident · No injuriesData collectionFinal reportCessna 182 · Cantwell, AKThe pilot's misjudged distance while step-taxiing after landing. Factors in the accident were rain showers, wind, and spray from the airplane's propeller.NTSB LAX08CA260Accident · No injuriesData collectionFinal reportCessna 182D · Gerlach, NVThe pilot's failure to maintain obstacle clearance during takeoff initial climb.NTSB NYC08CA268Accident · Minor injuriesData collectionFinal reportCessna 182L · Westerly, RIA loss of power due to a partial blockage of the air induction system.NTSB CHI08CA236Accident · No injuriesData collectionFinal reportBeech H35 · Bay City, MIThe checklist not followed and the inadvertent wheels up landing by the pilot.NTSB ANC08CA090Accident · No injuriesData collectionFinal reportCessna 180G · Anchorage, AKThe pilot's failure to maintain directional control during landing. Contributing to the accident was an inadvertent ground-loop.