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 DEN92FA052Accident · Serious injuriesField investigationFinal reportCessna 182 · Frederick, COThe pilot and operator attempting to operate the aircraft over maximum gross weight.NTSB ATL92LA097Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Cartersville, GAThe pilot's failure to operate the flight controls properly during the takeoff attempt and the pilot's planning decision during rollout.NTSB ANC92LA071Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Chitina, AKThe pilot's failure to maintain proper alignment with the landing area. Contributing factors were the gusty wind and the trees.NTSB ANC92LA068Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's improper use of carburetor heat which resulted in loss of engine power due to carburetor ice.NTSB ANC92LA072Accident · No injuriesLimited investigationFinal reportCessna C-180J · Seldovia, AKThe improper in-flt planning/decision by the pilot to land on a short gravel airstrip in tailwind wx conditions and his failure to correct a gnd loop/swerve during landing roll. Factors relating to the accident were the gusty, tailwind weather conditions.NTSB LAX92LA203Accident · No injuriesLimited investigationFinal reportCessna 182K · Carefree, AZInadequate aircraft maintenance and the failure of the pilot to ensure that adequate engine oil was on board prior to departure.NTSB ATL92LA095Accident · No injuriesLimited investigationFinal reportCessna 180B · Jacksonville, NCThe pilot's failure to ensure an adequate supply of fuel for the planned flight; which resulted in fuel exhaustion. A factor was the high vegetation in the forced landing field.NTSB SEA92LA086Accident · No injuriesLimited investigationFinal reportCessna 182B · Dixie, IDThe pilot's inadequate compensation for the wind conditions. Factors relating to the accident were the high density attitude and the downdraft.NTSB NYC92LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Winfield, WVThe improper in-flight planning and decision of the pilot to land on the strip and the pilot's delay in attempting the go-around. Factors in this accident were: the pilot was unable to maintain control of the aircraft due to the wet grass and the tail wind.NTSB MIA92FA112Accident · 1 fatalField investigationFinal reportNavion NAV-A · Monteverde, FLThe pilot's inadvertent flight into IMC conditions and subsequent loss of control of the airplane in flight.NTSB ANC92LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · Tolovana, AKThe pilot's failure to use all of the available runway (landing area on the road) for the precautionary landing. Contributing to the accident were the precautionary landing, the pilot's inadequate pre flight and in flight planning/preparation, and the road…NTSB FTW92LA105Accident · No injuriesLimited investigationFinal reportCessna 182A · Stanton, TXPower loss for undetermined reasons. A factor was soft terrain.NTSB ATL92LA067Accident · 1 fatalLimited investigationFinal reportCessna 182 · Barnwell, SCThe pilot's failure to maintain a safe altitude above the ground while making a low pass at night.NTSB CHI92LA112Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Munising, MIThe inadequate maintenance inspection to remove water from the fuel system, and the pilot's inadequate preflight inspection.NTSB MIA92LA095Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Deland, FLFailure of the pilot-in-command to maintain the proper airspeed (vs) resulting in an inadvertent stall. Factors in the accident were incorrect fuel selector position resulting in the total loss of engine power due to fuel starvation and fatigue of the pilot.NTSB CHI92LA093Accident · No injuriesLimited investigationFinal reportCessna 182B · Auburn, INThe improper maintenance and adjustment of the carburetor by other maintenance personnel.NTSB SEA92LA053Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Quilcene, WAThe pilot's failure to maintain directional control. Factors include a poor in flight decision and unfavorable/gusty winds.NTSB LAX92LA125Accident · No injuriesLimited investigationFinal reportCessna 182N · San Ardo, CAThe pilot's inadequate preflight inspection. Contributing to this accident was water contamination in the fuel and the soft soil landing area.NTSB SEA92LA050Accident · No injuriesLimited investigationFinal reportCessna 182D · Monroe, UTAn aborted takeoff was not performed. The wet, soft runway was a factor.NTSB ANC92LA038Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Shishmaref, AKThe non-instrumented rated pilot-in-command attempted visual flight into known instrument meteorological conditions. Factors contributing to the accident were the fog, the icing conditions, and the pilot's over confidence in his personal ability.NTSB CHI92LA103Accident · No injuriesLimited investigationFinal reportCessna 182P · Monee, ILThe pilot misjudged the landing flare and touchdown. A related factor was: the dark night light conditions.NTSB CHI92LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Lake Elmo, MNThe proper touchdown point was not attained and an aborted landing was delayed by the pilot. A factor related to the accident was the icy runway conditions.NTSB ANC92LA025Accident · No injuriesLimited investigationFinal reportCessna 180 · Atmautluak, AKThe pilot selected unsuitable terrain. Factors contributing to the accident were the dawn light condition and the snow on the runway.NTSB CHI92LA064Accident · Serious injuriesLimited investigationFinal reportCessna 182K · Huntington, INPilot factor in that he failed to maintain flying speed in a turn which resulted in an inadvertent stall. Factors related to the accident are; icing conditions, hazardous weather advisory disregarded, flight into known adverse weather, and overconfidence in…NTSB SEA92LA033Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Toledo, WAThe pilot's failure to maintain a proper glidepath.NTSB FTW92FA048Accident · 1 fatalField investigationFinal reportCessna 182 · Santa Teresa, NMThe pilot's failure to maintain control. Factors were the dark night, pilot's apprehension, pilot's lack of instrument experience, spatial disorientation, poor instrument location, visual perception and inadequate cockpit lighting.NTSB CHI92LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Point Lookout, MOFailure of the pilot to attain the proper touchdown Point and maintain directional control of the aircraft. A factor related to the accident was: a go-around was not performed by the pilot.NTSB FTW92LA030Accident · Serious injuriesLimited investigationFinal reportCessna 182F · Morse, TXThe pilot's attempted VFR flight into IMC conditions. Factors were, the pilot's lack of instrument qualification, his failure to obtain a weather briefing prior to the flight, and dark night conditions.NTSB LAX92LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · Long Beach, CAThe failure of the pilot to maintain directional control during the landing touchdown.NTSB CHI92LA070Accident · No injuriesLimited investigationFinal reportCessna 180H · Shenandoah, IAThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. An associated factor is the pilot's lack of experience in this type operation (crosswind takeoffs).NTSB CHI92LA025Accident · No injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOInadvertent deployment of the sky diver's parachute.NTSB LAX92LA048Accident · No injuriesLimited investigationFinal reportCessna 182H · Fortuna, CAThat the pilot misjudged the flare altitude. Contributing to the accident was the failure of the flight instructor to adequately supervise the flight.NTSB LAX92LA037Accident · No injuriesLimited investigationFinal reportCessna 180 · Sacramento, CAThe partial failure of the brake system due to contamination.NTSB CHI92LA019Accident · No injuriesLimited investigationFinal reportCessna 182U · Rolla, MOThe pilot in command's failure to attain a proper flare on landing. A factor contributing to the accident was the pilot in command's inadvertent encounter with instrument meteorological conditions.NTSB CHI92LA015Accident · No injuriesLimited investigationFinal reportNorth American Navion D · Lake Geneva, WIFatigue failure of the crankshaft. A factor in the accident was inadequate quality control by other maintenance personnel.NTSB ANC92LA009Accident · No injuriesLimited investigationFinal reportCessna 180 · Berners Bay, AKThe pilot's loss of control during the pre takeoff taxi, due to his improper handling of the airplane. Contributing to the accident was the soft takeoff area.NTSB LAX92T#A01Accident · No injuriesClass 3Final reportCessna L-19 · Tonopah, NVNTSB LAX91LA403Accident · No injuriesLimited investigationFinal reportCessna 180K · Mammoth Lakes, CAThe pilot-in-command failed to maintain directional control. Contributing to this accident was the pic's lack of experience in the airplane and the soft terrain.NTSB NYC91LA242Accident · No injuriesLimited investigationFinal reportCessna 180L · Vestal, NYImproper use of carburetor heat by the pilot which resulted in a power loss due to carburetor ice over unsuitable terrain.NTSB ANC91LA148Accident · No injuriesLimited investigationFinal reportCessna 180 · Telida, AKThe pilot getting disoriented during flight due to his inattentiveness, the airplane's low fuel level, the fss specialist's giving the pilot an incorrect heading to fly, poor radio communications between the fss and the pilot, the strong crosswind, and the…NTSB MIA91LA216Accident · No injuriesLimited investigationFinal reportCessna 182 · Titusville, FLThe pilot in command's improper preflight planning and his failure to ensure that the aircraft contained sufficient fuel for the flight.NTSB LAX91LA385Accident · 1 fatalLimited investigationFinal reportCessna C-310B · San Pedro, CAAn inflight loss of control for undetermined reasons.NTSB ANC91LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Bethel, AKThe pilot's failure to obtain proper airspeed. Contributing to the accident was the pilot's improper compensation for wind conditions and the unfavorable wind.NTSB LAX91LA372Accident · No injuriesLimited investigationFinal reportCessna 182 · Columbia, CAThe pilot of the aircraft experienced a bounced landing on his initial landing attempt. He executed a go-around and landed without incident on the second attempt. Substantial damage to the firewall was discovered afterwards. The pilot believes the bounced…NTSB ANC91LA127Accident · No injuriesLimited investigationFinal reportCessna 180A · King Salmon, AKThe pilot's failure to maintain directional control of the airplane during the takeoff run. Contributing to the accident was the rough water.NTSB DEN91FA116Accident · 1 fatalField investigationFinal reportCessna 182N · Climax, COImproper in-flight planning/decision by the non-rated pilot and his failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was: the pilot's lack of qualification.NTSB SEA91LA205Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Boring, ORFuel exhaustion and improper inflight decision by the pilot in command followed by rough terrain during the forced landing. Factors contributing to the accident were a fuel system leak and the pilot's failure to refuel en route.NTSB CHI91LA262Accident · No injuriesLimited investigationFinal reportCessna 310 · Plattsmouth, NEImproper maintenance by the owner/pilot. A factor related to the accident was the built-up of corrosion on he landing gear retraction system.NTSB CHI91LA255Accident · No injuriesLimited investigationFinal reportCessna 180 · Walker, MNDirectional control after landing was not maintained by the pilot. Factors related to the accident were a gusty crosswind and a downhill embankment (ditch).NTSB CHI91LA253Accident · No injuriesLimited investigationFinal reportCessna 180 · Eveleth, MNThe pilot's failure to maintain the proper descent rate and adequate airspeed during the approach. A factor related to the accident is the lack of recent total experience.