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.

NTSB ATL04LA081Accident · No injuriesLimited investigationFinal reportCessna 182P · Nashville, TNThe pilot's improper landing flare and his inadequate recovery from a bounced landing resulting in a hard landing and propeller strike of the runway.Mar 7, 2004 · N325LA · Substantial damageNTSB LAX04CA147Accident · No injuriesData collectionFinal reportCessna 182E · Sonora, CAthe pilot's inadequate preflight inspection and failure to ensure adequate fuel was aboard, which resulted in fuel exhaustion and loss of engine power.Mar 6, 2004 · N2819Y · Substantial damageNTSB IAD04CA012Accident · No injuriesData collectionFinal reportCessna 182P · Titusville, PAThe pilot's failure to maintain directional control during the landing roll. A factor in the accident was the snow bank.Feb 22, 2004 · N7388N · Substantial damageNTSB CHI04FA071Accident · 1 fatalField investigationFinal reportCessna 182Q · Rozel, KSThe inadvertent flight into instrument meteorological conditions, the spatial disorientation, and aircraft control not maintained by the pilot during cruise flight. Contributing to the accident were the night instrument meteorological conditions due to low…Feb 16, 2004 · N735RD · DestroyedNTSB ANC04LA031Accident · No injuriesLimited investigationFinal reportCessna 182M · Yakutat, AKThe pilot's delayed use of carburetor heat, which resulted in an engine power loss during takeoff-initial climb, a forced landing, and subsequent collision with terrain. A factor contributing to the accident was the presence of carburetor icing conditions.Feb 9, 2004 · N71886 · Substantial damageNTSB FTW04LA064Accident · No injuriesLimited investigationFinal reportCessna 182R · Ringgold, TXThe pilots failure to maintain clearance from the support wire while on a pipeline patrol flight. A contributing factor was the haze restricting the pilots forward visibility, and low altitude flight.Jan 22, 2004 · N9374H · Substantial damageNTSB DEN04LA039Accident · No injuriesLimited investigationFinal reportCessna 182Q · St. George, UTthe pilot's improper flare which resulted in a hard landing.Jan 18, 2004 · N5202N · Substantial damageNTSB ATL04FA069Accident · 1 fatalField investigationFinal reportCessna 182A · Traphill, NCThe loss of engine power due to carburetor ice. Contributing factors were conditions conducive for carburetor icing.Jan 17, 2004 · N4744D · DestroyedNTSB CHI04FA055Accident · 2 fatalField investigationFinal reportCessna 182P · Baudette, MNThe pilot's intentional flight into adverse weather conditions, and his failure to maintain adequate terrain clearance. Contributing factors were the pilot's lack of an instrument rating, low ceiling, low altitude, and the dark night conditions.Jan 11, 2004 · N5787J · DestroyedNTSB ATL04LA063Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Taylorsville, NCThe pilot's failure to follow the checklist, resulting in a loss of directional control on the takeoff roll when the seat moved rearward, and on ground collision with an embankment.Jan 3, 2004 · N3102S · Substantial damageNTSB SEA04FA032Accident · 4 fatalField investigationFinal reportCessna 182G · Glasgow, MTLoss of aircraft control resulting in an in-flight collision with terrain. Factors include marginal weather and dark night conditions.Jan 2, 2004 · N3171S · DestroyedNTSB CHI04LA050Accident · No injuriesLimited investigationFinal reportCessna 182A · West Chicago, ILThe inadequate starting and flooded engine procedure used by certified flight instructor while providing instruction to the dual student.Dec 30, 2003 · N5894B · Substantial damageNTSB DEN04LA034Accident · No injuriesLimited investigationFinal reportCessna 182 · Hudson, COthe pilot's failure to maintain directional control due to an excessive crosswind component, resulting in an uncontrolled groundloop/swerve. Contributing factors were the crosswind gust and the soft, sandy terrain.Dec 28, 2003 · N5609B · Substantial damageNTSB ATL04LA068Accident · No injuriesLimited investigationFinal reportCessna 182L · Knoxville, TNThe pilot's improper flare and his inadequate compensation for wind conditions. Wind gust was a factorDec 16, 2003 · N3191R · Substantial damageNTSB LAX04FA068Accident · Minor injuriesField investigationFinal reportCessna 182P · Watsonville, CAa loss of engine power due to water contamination of the fuel system and the pilot's inadequate preflight inspection. A contributing factor was the pilot/owner's failure to comply with the appropriate Airworthiness Directive.Dec 15, 2003 · N1595M · DestroyedNTSB FTW04FA044Accident · 1 fatalField investigationFinal reportBeech H-35 · Mena, ARThe pilot's failure to maintain proper altitude and clearance from terrain. Contributing factors were the mountainous terrain, fog, clouds, and turbulence.Dec 15, 2003 · N7929D · DestroyedNTSB ATL04LA044Accident · Minor injuriesLimited investigationFinal reportCessna 182-K · Birmingham, ALA loss of engine power due to the throttle/power lever cable becoming disconnected in-flight, as a result of maintenance personnel failure to comply with Airworthiness Directive (AD) 86-24-07 and Cessna information letter SE79-6.Dec 3, 2003 · N3056Q · Substantial damageNTSB CHI04LA036Accident · No injuriesLimited investigationFinal reportCessna 182R · Wausau, WIThe pilot 's improper flare which resulted in a hard landing, and the flight instructors inadequate supervision.Nov 22, 2003 · N323KW · Substantial damageNTSB FTW04FA025Accident · 2 fatalField investigationFinal reportBeech A45 · Montgomery, TXThe non-compliance with applicable Airworthiness Directives which required wing spar inspections, and the continued operation of the aircraft beyond the compliance time extension granted as per the approved alternate means of compliance (AMOC). Also causal…Nov 19, 2003 · N44KK · DestroyedNTSB NYC04FA033Accident · 2 fatalField investigationFinal reportCessna 180 · Westerly, RIThe Piper pilot's improper decision to continue a landing on an occupied runway, which resulted in an in-flight collision with the departing Cessna. Factors related to the accident were the departing Cessna pilot's inattentive radio communications, and the…Nov 16, 2003 · N34AG · 2 aircraft · Substantial damageNTSB ANC04LA007Accident · No injuriesLimited investigationFinal reportCessna 180 · Skwentna, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor contributing to the accident was the presence of deep/soft snow.Nov 9, 2003 · N49JT · Substantial damageNTSB SEA04LA016Accident · No injuriesLimited investigationFinal reportCessna 182A · Kapowsin, WAThe loss of engine power for undetermined reasons. A contributing factor to the accident was the trees.Nov 8, 2003 · N2106G · Substantial damageNTSB NYC04CA022Accident · No injuriesData collectionFinal reportCessna 182M · Laytonsville, MDThe pilot's abrupt evasive maneuver to avoid the deer, which resulted in the loss of airspeed and an inadvertent stall.Nov 1, 2003 · N70800 · Substantial damageNTSB DEN04LA018Accident · No injuriesLimited investigationFinal reportCessna 182A · Albuquerque, NMthe pilot's delayed use of carburetor heat and his inadequate flare resulting in a loss of engine power and a hard landing. Also causal was the inadequate supervision of the flight. Carburetor icing conditions was a contributing factor.Oct 31, 2003 · N5127D · DestroyedNTSB DEN04LA016Accident · No injuriesLimited investigationFinal reportCessna 180J · Watkins, COThe pilot's failure to maintain aircraft control resulting in the ground loop. Factors contributing to the accident were the crosswind and the gusts.Oct 26, 2003 · N9794G · Substantial damageNTSB NYC04LA014Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Athol, MAThe loss of power due to disengagement of the magneto idler gear. Also causal was the improper reinstallation of the magneto during the annual inspection.Oct 21, 2003 · N3419S · Substantial damageNTSB DEN04LA008Accident · No injuriesLimited investigationFinal reportCessna 182R · Lysite, WYthe pilot's fuel mismanagement resulting in the loss of engine power and the subsequent forced landing. A contributing factor was the lack of suitable terrain for a forced landing and the nose over.Oct 12, 2003 · N4981E · Substantial damageNTSB NYC04CA009Accident · No injuriesData collectionFinal reportCessna 182C · Clarence Center, NYThe pilot's delayed go-around decision. A factor in this accident was the night light condition.Oct 10, 2003 · N8511T · Substantial damageNTSB ANC04LA001Accident · No injuriesLimited investigationFinal reportCessna 180 · McCarthy, AKThe separation of the left main landing gear wheel from the gear leg, which resulted in a loss of directional control, and collapse of the right main landing gear. A factor contributing to the accident was the rough and uneven airstrip.Oct 10, 2003 · N9278C · Substantial damageNTSB DEN04LA004Accident · No injuriesLimited investigationFinal reportCessna 182L · Randolph, UTthe pilot's failure to maintain adequate airspeed which resulted in a stall. Contributing factors were the wind gusts and crosswind conditions.Oct 7, 2003 · N3348R · DestroyedNTSB ATL04LA008Accident · No injuriesLimited investigationFinal reportCessna 182H · Knoxville, TNThe pilot's inadequate preflight inspection by his failure to secure the left fuel tank cap which resulted in fuel exhaustion, and the loss of engine power.Oct 5, 2003 · N1919X · Substantial damageNTSB ATL04LA004Accident · No injuriesLimited investigationFinal reportCessna 180K · Starkville, MSThe pilot's failure to compensate for a crosswind condition that resulted in the loss of directional control during a landing. A factor was the crosswind condition.Oct 4, 2003 · N77NP · Substantial damageNTSB CHI04LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Shenandoah, IALoss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.Oct 3, 2003 · N3772D · Substantial damageNTSB SEA03CA195Accident · No injuriesData collectionFinal reportCessna 180 H · Council, IDAircraft control not maintained during the landing roll. Factors include soft, water soaked terrain.Sep 26, 2003 · N9707G · Substantial damageNTSB CHI03LA321Accident · No injuriesLimited investigationFinal reportCessna 305A · New Richmond, WIThe pilot's inadequate compensation for wind and his failure to maintain directional control. The pilot's in-flight selection of the wrong runway and excessive application of brake pressure are contributing factors.Sep 25, 2003 · N5237G · Substantial damageNTSB CHI03LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Versailles, MOThe pilot touched down with excessive airspeed. Factors associated with the accident were the trees, the wet runway, the wet grass that the airplane traveled onto, and the ditch which the airplane contacted.Sep 22, 2003 · N74LW · Substantial damageNTSB NYC03CA202Accident · Serious injuriesData collectionFinal reportCessna 182B · Spencerport, NYPilot's failure to perform a go-around.Sep 21, 2003 · N7225E · Substantial damageNTSB ATL03LA145Accident · No injuriesLimited investigationFinal reportCessna 180 · Pavo, GAThe pilot's failure to maintain airspeed, resulting in an inadvertent stall.Sep 21, 2003 · N2807A · Substantial damageNTSB LAX03LA293Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Georgetown, CAthe pilot's misjudged speed and distance, and his failure to perform a go-around which resulted in a runway overrun.Sep 20, 2003 · N9921B · Substantial damageNTSB ANC03LA122Accident · No injuriesLimited investigationFinal reportCessna 180 · Cape Yakataga, AKThe pilot's selection of unsuitable terrain for departure, which resulted in a collision with a log during the takeoff roll. Factors contribuiting to the accident were the presence of hidden obstructions, and sunglare.Sep 18, 2003 · N2162Z · Substantial damageNTSB LAX03CA296Accident · No injuriesData collectionFinal reportCessna 182K · Young, AZthe collision with a bull during takeoff.Sep 17, 2003 · N2646R · Substantial damageNTSB CHI03LA312Accident · Minor injuriesLimited investigationFinal reportCessna 182P · St. Louis, MOThe pilot's failure to maintain directional control during the landing rollout.Sep 17, 2003 · N9072M · Substantial damageNTSB ANC03LA116Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKThe pilot's misjudgment of the distance/altitude to the touchdown point during landing, which resulted in an undershoot and collision with a river bank. A factor contributing to the accident was the presence of a river bank that formed the beginning of the…Sep 15, 2003 · N3386U · Substantial damageNTSB SEA03LA190Accident · 2 fatalLimited investigationFinal reportCessna 182 · Challis, IDThe pilot's failure to maintain clearance from trees while maneuvering. Factors include mountainous terrain and trees.Sep 13, 2003 · N5547B · DestroyedNTSB CHI03LA310Accident · No injuriesLimited investigationFinal reportCessna 182D · Rushville, INThe pilot failed to maintain control of the airplane during the initial takeoff climb which resulted in an inadvertent stall.Sep 12, 2003 · N8702X · Substantial damageNTSB NYC03LA196Accident · Minor injuriesLimited investigationFinal reportCessna 180D · Greenville, METhe inadequate installation and inspection of an aileron cable by maintenance personnel, which resulted in a loss of control in-flight and subsequent collision with water.Sep 7, 2003 · N6445X · Substantial damageNTSB DEN03LA150Accident · No injuriesLimited investigationFinal reportCessna 182A · Pine Haven, WYThe loss of engine power for undetermined reasons. The lack of suitable terrain is a contributing factor.Sep 7, 2003 · N6384B · Substantial damageNTSB LAX03CA272Accident · No injuriesData collectionFinal reportCessna 182J · Marble Canyon, AZthe failure of the pilot to retract the flaps and attain a sufficient airspeed during the attempted go-around, which resulted in a stall. The full nose-up trim was a contributing factor.Aug 31, 2003 · N2898F · Substantial damageNTSB ANC03LA103Accident · No injuriesLimited investigationFinal reportCessna 180 · Nenana, AKThe pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power and a forced landing in unsuitable terrain.Aug 26, 2003 · N2117Z · Substantial damageNTSB LAX03LA262Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Brownsville, CAThe pilot's improper flare and his failure to maintain directional control. Contributing factors were excessive airspeed, pilot-induced oscillation, and inadequate recovery from a bounced landing.Aug 25, 2003 · N6250A · Substantial damage