Fatal NTSB investigations: Continental O-470 series

527 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.\"highestInjuryLevel\" = 'Fatal'
    AND 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 WPR16FA152Accident · 4 fatalField investigationFinal reportCessna 310B · Columbia, CAThe pilot's failure to maintain control during takeoff initial climb for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Jul 27, 2016 · N6605B · Substantial damageNTSB WPR16FA116Accident · 5 fatalField investigationFinal reportCessna 182 · Hanapepe, HIThe pilot's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic…May 23, 2016 · N2007X · DestroyedNTSB CEN16FA169Accident · 1 fatalField investigationFinal reportCessna 182L · Carrollton, OHAn in-flight collision with trees and terrain for reasons that could not be determined because no anomalies consistent with a preimpact failure or malfunction were observed during the examination.Apr 24, 2016 · N42411 · Substantial damageNTSB WPR16FA084Accident · 4 fatalField investigationFinal reportCessna 182A · Alpine, WYThe noninstrument-rated pilot's failure to maintain airspeed during the initial climb in dark night conditions with no visual reference, which resulted in a stall and collision with terrain.Mar 13, 2016 · N2230G · Substantial damageNTSB CEN16FA059Accident · 1 fatalField investigationFinal reportCessna 182C · Pattonsburg, MOThe pilot's loss of airplane control while maneuvering during low-level flight for reasons that could not be determined because examination of the airframe and engine did not reveal any preimpact anomalies.Dec 6, 2015 · N8777T · DestroyedNTSB CEN16FA042Accident · 3 fatalField investigationFinal reportCessna 182G · Sandia Park, NMThe pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.Nov 16, 2015 · N2440R · DestroyedNTSB CEN16FA037Accident · 1 fatalField investigationFinal reportCessna 182Q · Richmond, MOThe airplane's impact with trees and terrain during an off-airport forced landing in dark night conditions following a partial loss of engine power. The reason for the partial loss of engine power could not be determined because postaccident examination did…Nov 11, 2015 · N96381 · Substantial damageNTSB WPR16FA006Accident · 3 fatalField investigationFinal reportCessna 182 · Hope, IDThe pilot's selection of an inadequate altitude to cross mountainous terrain and her subsequent failure to maintain terrain clearance. Contributing to the accident was the pilot's inadequate preflight evaluation of the weather conditions and flight plan.Oct 8, 2015 · N6184F · DestroyedNTSB CEN15FA427Accident · 1 fatalField investigationFinal reportCessna 182 · Lexington, TXThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during a climbing turn, which resulted in an aerodynamic stall/spin at too low of an altitude to recover.Sep 27, 2015 · N3921D · Substantial damageNTSB ANC15FA066Accident · 2 fatalField investigationFinal reportCessna 180 · Kasilof, AKThe total loss of engine power for reasons that could not be determined based on postaccident examination and testing.Aug 23, 2015 · N3043E · Substantial damageNTSB WPR15FA236Accident · 2 fatalField investigationFinal reportCessna 182F · Montecito, CAOil starvation that led to the failure of the No. 5 connecting rod and a subsequent loss of engine power.Aug 7, 2015 · N5738F · Substantial damageNTSB ANC15WA036Accident · 2 fatalForeign investigationCessna 182 · Sikanni Chief, CanadaJun 1, 2015 · N759AS · DestroyedNTSB ERA15FA204Accident · 1 fatalField investigationFinal reportCessna 182 · Mulberry, TNThe pilot's failure to recover from a controlled descent for reasons that could not be determined during the postaccident investigation.May 3, 2015 · N6579M · DestroyedNTSB ANC15FA021Accident · 1 fatalField investigationFinal reportCessna 180 · Whittier, AKThe pilot's decision to continue flight into known icing conditions, contrary to the airplane’s limitations, which resulted in a total loss of engine power due to icing.Apr 14, 2015 · N9247C · Substantial damageNTSB CEN15FA174Accident · 1 fatalField investigationFinal reportCessna 182Q · El Paso, TXThe pilot's decision to continue a visual flight rules flight into known instrument flight rules conditions, which resulted in controlled flight into terrain.Mar 17, 2015 · N735KF · DestroyedNTSB CEN15FA119Accident · 1 fatalField investigationFinal reportCessna 182L · Owen, WIThe flight instructor's decision to initiate flight into forecasted icing conditions in an airplane that was not certified or equipped for flight into icing conditions, which resulted in significant structural ice accumulation to the extent that the airplane…Jan 26, 2015 · N3181R · Substantial damageNTSB ERA14FA417Accident · 2 fatalField investigationFinal reportCessna 180 · North Hampton, NHThe pilot’s failure to ensure the airplane maintained adequate airspeed during the initial climb and the subsequent exceedance of its critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident were the pilot’s impairment…Sep 1, 2014 · N6510A · Substantial damageNTSB CEN14WA416Accident · 3 fatalForeign investigationCessna 182P · Lake of the Woods, CanadaAug 8, 2014 · N1292S · DestroyedNTSB ERA14FA372Accident · 2 fatalField investigationFinal reportCessna 182F · Gansevoort, NYThe pilot’s failure to maintain directional control during initial climb following a banner pick-up, resulting in collision with a tree.Aug 2, 2014 · N1DZ · DestroyedNTSB WPR14FA303Accident · 4 fatalField investigationFinal reportCessna 182L · Sedona, AZThe pilot’s failure to maintain adequate airspeed and his exceedance the airplane’s critical angle-of attack while maneuvering through a canyon in high-density altitude conditions at low altitude, which resulted in an aerodynamic stall.Jul 20, 2014 · N42474 · DestroyedNTSB WPR14FA286Accident · 1 fatalField investigationFinal reportCessna 182 · Fall City, WAThe pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jul 8, 2014 · N5816B · Substantial damageNTSB ERA14FA313Accident · 1 fatalField investigationFinal reportCessna 182 · Littleton, NCMaintenance personnel's application of sealant to the engine case halves during engine overhaul, contrary to manufacturer's instructions, which resulted in internal failure of the engine due to the loss of case bolt torque.Jun 27, 2014 · N182PE · Substantial damageNTSB CEN14FA071Accident · 1 fatalField investigationFinal reportCessna 182E · Delta, COThe student pilot’s decision to attempt flight into instrument meteorological conditions, which resulted in a loss of control and ground impact.Nov 29, 2013 · N3087Y · DestroyedNTSB WPR13FA284Accident · 2 fatalField investigationFinal reportBeech A45 · Boulder City, NVThe pilot/mechanic's loss of control during an emergency descent following a loss of engine power while in cruise flight. Contributing to the accident was the pilot/mechanic's incorrect assembly of the No. 6 cylinder at the last cylinder change, which…Jun 23, 2013 · N434M · Substantial damageNTSB CEN13WA328Accident · 2 fatalForeign investigationCessna 182R · Micoxtla, MexicoOn June 7, 2013, about 1755 hours central daylight time, a Cessna 182R, United States registration N6241H, impacted terrain near Micoxtla, Mexico. The pilot and passenger were fatally injured, and the airplane was destroyed. The accident investigation is…Jun 7, 2013 · N6241H · DestroyedNTSB WPR13FA201Accident · 2 fatalField investigationFinal reportCessna 182D · Wellington, NVThe pilot’s failure to maintain clearance from mountainous terrain during a night, visual descent to the destination airport, which resulted in controlled flight into terrain.Apr 15, 2013 · N9078X · DestroyedNTSB WPR13FA183Accident · 1 fatalField investigationFinal reportCessna 182C · Circle, MTThe pilot’s failure to maintain airplane control as a result of spatial disorientation. Contributing to the accident was the pilot’s decision to continue flight into low visibility conditions.Apr 6, 2013 · N8721T · DestroyedNTSB ANC13FA027Accident · 3 fatalField investigationFinal reportCessna 182B · Nikolai, AKThe pilot’s failure to maintain adequate airspeed while maneuvering inside a box canyon and the airplane’s subsequent aerodynamic stall, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot’s visual…Mar 4, 2013 · N2343G · Substantial damageNTSB ERA13FA105Accident · 3 fatalField investigationFinal reportBeech H35 · Palm Coast, FLA total loss of engine power after the failure of the No. 4 connecting rod due to oil starvation, which resulted in a subsequent forced landing. Contributing to the accident was the pilot’s failure to clearly state that the aircraft had lost all power and the…Jan 4, 2013 · N375B · DestroyedNTSB CEN13FA069Accident · 1 fatalField investigationFinal reportCessna 310B · Mancelona, MIThe pilot's failure to maintain control of the airplane after a loss of right engine power for reasons that could not be determined because postaccident examination revealed no preimpact malfunction or anomaly that would have precluded normal operation.Nov 21, 2012 · N5419A · Substantial damageNTSB WPR13FA053Accident · 1 fatalField investigationFinal reportCessna 182D · Bondurant, WYThe noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.Nov 17, 2012 · N61LN · DestroyedNTSB CEN13FA044Accident · 2 fatalField investigationFinal reportCessna 310 · Stotts City, MOThe pilot's failure to maintain airplane control after he shut down the right engine in flight due a loss of oil pressure. Contributing to the accident was the pilot's decision to reposition the unairworthy airplane during twilight after extensive maintenance…Nov 5, 2012 · N6BS · Substantial damageNTSB WPR13FA017Accident · 1 fatalField investigationFinal reportCessna 182P · Yucca, AZThe pilot’s failure to take corrective action to avoid terrain during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Oct 18, 2012 · N20939 · Substantial damageNTSB CEN12WA338Accident · 1 fatalForeign investigationCessna 182N · Pista Aérea, MexicoJun 2, 2012 · N92201 · Substantial damageNTSB CEN12FA199Accident · 2 fatalField investigationFinal reportCessna 172S · Longmont, COThe inadequate visual lookout by the pilots of both airplanes, which resulted in a mid-air collision.Mar 23, 2012 · N10468 · 2 aircraft · Substantial damageNTSB ERA12FAMS1Accident · 1 fatalMissing aircraftFinal reportCessna 182P · Atlantic Ocean (Atlantic Ocean)Undetermined; the airplane and pilot are missing.Mar 1, 2012 · N1338S · Substantial damageNTSB CEN12FA090Accident · 2 fatalField investigationFinal reportCessna 182R · Mescalero, NMThe pilot's intentional attempt to fly into adverse weather, which resulted in an in-flight loss of control. Contributing to the accident was the pilot's lack of instrument experience.Nov 26, 2011 · N9408X · Substantial damageNTSB ERA12FA062Accident · 2 fatalField investigationFinal reportBeech D-45 · Williston, FLThe flight instructor's failure to maintain airspeed in changing wind conditions during a steep climb after takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the flight instructor’s ostentatious display close to the ground.Nov 5, 2011 · N34KT · Substantial damageNTSB WPR12FA021Accident · 1 fatalField investigationFinal reportCessna 182R · Lexington, ORThe pilot’s failure to maintain situational awareness and terrain clearance on a dark night during the approach to landing.Oct 27, 2011 · N6545E · Substantial damageNTSB WPR11FA448Accident · 2 fatalField investigationFinal reportCessna 182H · Stanley, IDThe pilot's failure to maintain airplane control due to spatial disorientation while executing a turn to reverse his course in dark night and low-visibility conditions. Contributing to the accident was the pilot's decision to initiate the flight into an area…Sep 13, 2011 · N2404X · Substantial damageNTSB ANC11FA071Accident · 4 fatalField investigationFinal reportCessna U206G · Talkeetna, AKThe inadequate visual lookout and failure to see and avoid by the pilots of both airplanes while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the lack of standardized, unequivocal procedures concerning common…Jul 30, 2011 · N756MP · 2 aircraft · Minor damageNTSB ANC11FA069Accident · 2 fatalField investigationFinal reportCessna 182P · Juneau, AKThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Contributing to the accident was the pilot's self-induced pressure to reach his destination.Jul 24, 2011 · N7304S · Substantial damageNTSB WPR11FA304Accident · 2 fatalField investigationFinal reportCessna 180D · Santa Paula, CAThe pilot’s failure to maintain clearance from a telephone line while flying at a low altitude in dusk lighting conditions.Jul 4, 2011 · N6451X · Substantial damageNTSB ANC11FA037Accident · 5 fatalField investigationFinal reportCessna 180 · Chugiak, AKThe pilot's loss of control of the airplane during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in make and model, his lack of currency in FAA required takeoffs and landings, and his…May 27, 2011 · N4955A · Substantial damageNTSB WPR11FA184Accident · 1 fatalField investigationFinal reportNorth American Navion A · Alameda, CAThe pilot’s failure to maintain airspeed while maneuvering for an emergency landing, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power for undetermined reasons during initial climb.Apr 3, 2011 · N91472 · Substantial damageNTSB CEN11FA244Accident · 2 fatalField investigationFinal reportCessna 182M · Hot Springs, ARA total loss of engine power for undetermined reasons.Mar 24, 2011 · N70922 · Substantial damageNTSB CEN11FA195Accident · 2 fatalField investigationFinal reportCessna 182P · Levelland, TXThe pilot’s failure to maintain control of the airplane during a landing and subsequent go-around with a crosswind.Feb 18, 2011 · N325LA · Substantial damageNTSB WPR11FA116Accident · 3 fatalField investigationFinal reportCessna 182K · Adrian, ORThe non-instrument-rated pilot did not maintain sufficient altitude to clear mountainous terrain while in cruise flight in the dark.Jan 30, 2011 · N3083Q · Substantial damageNTSB CEN11FA115Accident · 3 fatalField investigationFinal reportCessna 182C · Crowley, LAA loss of engine power due to the magneto failure for undetermined reasons.Dec 18, 2010 · N8556T · Substantial damageNTSB WPR10FA438Accident · 1 fatalField investigationFinal reportCessna 182C · Belgrade, MTThe non-instrument rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of airplane control.Aug 30, 2010 · N8957T · Substantial damage