NTSB investigations: Continental O-470 series, CA

657 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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 WPR14CA241Accident · No injuriesData collectionFinal reportCessna 180H · Hesperia, CAThe pilot's failure to maintain directional control during the landing roll.Jun 7, 2014 · N73BT · Substantial damageNTSB WPR14LA208Accident · No injuriesLimited investigationFinal reportCessna 182P · Mammoth Lakes, CAThe total loss of engine power due to carburetor icing, which resulted from the pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to carburetor icing.May 24, 2014 · N21048 · Substantial damageNTSB WPR14CA184Accident · No injuriesData collectionFinal reportCessna 180D · Murieta, CAThe pilot's loss of directional control during takeoff. Contributing to the accident was the pilot's failure to abort the takeoff at the initial veer off.May 3, 2014 · N8603X · Substantial damageNTSB WPR14LA117Accident · Serious injuriesLimited investigationFinal reportBeech A45 · Hollister, CAThe total loss of engine power during initial climb due to fuel starvation and the pilot’s inadequate preflight inspection and improper fuel management.Feb 22, 2014 · N666 · Substantial damageNTSB WPR13CA428Accident · Minor injuriesData collectionFinal reportCessna 182Q · Big Bear, CAThe pilot's failure to maintain a stabilized landing approach, which resulted in a collision with a fence short of the runway.Sep 28, 2013 · N759UP · Substantial damageNTSB WPR13LA317Accident · No injuriesLimited investigationFinal reportCessna 182H · Hesperia, CAThe loss of engine power during cruise flight due to the detachment of the mixture control cable from its mounting clamp.Jul 9, 2013 · N2062X · Substantial damageNTSB WPR13CA278Accident · No injuriesData collectionFinal reportCessna 180 · Nervino, CAThe pilot’s decision to takeoff from an area off the runway surface which resulted in a collision with an object.Jun 7, 2013 · N1677C · Substantial damageNTSB WPR13CA257Accident · Serious injuriesData collectionFinal reportCessna 182P · Bridgeport, CAThe pilot's distracted attention while on final approach which resulted in his failure to maintain adequate airspeed and subsequent loss of aircraft control.Jun 2, 2013 · N21231 · Substantial damageNTSB WPR13LA112Accident · No injuriesLimited investigationFinal reportCessna 305A · Camarillo, CAA tailwheel vibration upon touchdown and the subsequent loss of directional control for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.Feb 2, 2013 · N342FS · Substantial damageNTSB WPR12CA352Accident · No injuriesData collectionFinal reportCessna 180 · Upland, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.Aug 12, 2012 · N2927K · Substantial damageNTSB WPR12FA316Accident · Serious injuriesField investigationFinal reportCessna 182P · Corona, CAA loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision to take off…Jul 21, 2012 · N640AM · Substantial damageNTSB WPR12LA286Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Watsonville, CAA total loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.Jun 24, 2012 · N55DN · Substantial damageNTSB WPR12CA268Accident · Minor injuriesData collectionFinal reportCessna 182P · Woodland, CAThe pilot's failure to maintain a proper descent path during the approach to land, which resulted in a hard, bounced landing, and his improper retraction of the flaps during the subsequent attempted go-around.Jun 17, 2012 · N7437Q · Substantial damageNTSB WPR12CA169Accident · No injuriesData collectionFinal reportCessna 182G · Georgetown, CAThe pilot’s failure to maintain control of the airplane while landing with a gusting wind.Apr 17, 2012 · N3272S · 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 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 WPR11CA174Accident · Minor injuriesData collectionFinal reportCessna 182C · Stockton, CAThe pilot's failure to secure the airplane before pulling the propeller to start the engine.Mar 20, 2011 · N9040T · Substantial damageNTSB WPR11CA100Accident · No injuriesData collectionFinal reportCessna 180 · Fullerton, CAThe pilot’s failure to maintain directional control during landing.Jan 14, 2011 · N1630C · Substantial damageNTSB WPR10FA423Accident · Minor injuriesField investigationFinal reportCessna 182 · Ojai, CAA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Aug 24, 2010 · N3850D · Substantial damageNTSB WPR10CA402Accident · No injuriesData collectionFinal reportCessna 182P · Compton, CAThe pilot's failure to attain the proper touchdown point that resulted in an overrun of the runway and collision with a wall.Aug 14, 2010 · N20872 · Substantial damageNTSB WPR10FA324Accident · 1 fatalField investigationFinal reportCessna 182P · Avalon, CAThe pilot's incapacitation due to a heart attack, which resulted in a loss of airplane control.Jul 1, 2010 · N222CG · Substantial damageNTSB WPR10CA227Accident · No injuriesData collectionFinal reportCessna 182M · Angwin, CAThe pilot's inadequate compensation for the crosswind resulting in the loss of directional control during the landing roll.May 3, 2010 · N91603 · Substantial damageNTSB WPR10LA209Accident · Minor injuriesLimited investigationFinal reportCessna 182 · El Cajon, CAThe pilot's delayed use of carburetor heat while operating in conditions conducive to carburetor icing.Apr 17, 2010 · N5318B · Substantial damageNTSB WPR10CA176Accident · No injuriesData collectionFinal reportCessna 182Q · Fallbrook, CAThe pilot’s failure to maintain directional control of the airplane during landing.Mar 23, 2010 · N735KL · Substantial damageNTSB WPR10CA095Accident · No injuriesData collectionFinal reportCessna 182P · Fallbrook, CAThe pilot's misjudged altitude and airspeed that resulted in his failure to attain the proper touchdown point.Jan 3, 2010 · N7417N · Substantial damageNTSB WPR10LA059Accident · 1 fatalLimited investigationFinal reportCessna 182K · Susanville, CAThe pilot's decision to takeoff into weather conditions conducive to ice accumulation, which resulted in an inadvertent stall/spin while maneuvering in the initial climb. Contributing to the accident was the likely accumulation of snow and ice on the airborne…Nov 20, 2009 · N2650R · Substantial damageNTSB WPR09LA445Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Chemehuevi Valley, CAThe pilot's improper flare while landing with a tailwind, resulting in a bounced landing.Sep 11, 2009 · N2819R · Substantial damageNTSB 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.Jul 8, 2009 · N7314S · Substantial damageNTSB WPR09LA242Accident · No injuriesLimited investigationFinal reportCessna 182M · Madera, CAThe pilot’s failure to maintain directional control of the airplane throughout the landing.May 9, 2009 · N71165 · Substantial damageNTSB WPR09CA035Accident · No injuriesData collectionFinal reportCessna 305A · El Cajon, CAThe pilot’s failure to maintain directional control during the landing roll.Nov 10, 2008 · N5263G · Substantial damageNTSB LAX08LA140Accident · No injuriesLimited investigationFinal reportCessna 182P · Santa Maria, CAThe pilot's impairment from alcohol and his improper flare, which resulted in a bounced landing. Contributing to the accident was the FAA's failure to obtain additional information about the pilot's alcohol use history to verify that he met the requirements…May 15, 2008 · N4660K · Substantial damageNTSB LAX07CA286Accident · No injuriesData collectionFinal reportCessna 182F · Bakersfield, CAThe pilot's inadequate preflight inspection and pretakeoff checks during which he failed to remove the gust lock.Oct 1, 2007 · N3580Y · Substantial damageNTSB SEA07CA236Accident · No injuriesData collectionFinal reportCessna 182R · Redding, CAThe pilot's failure to achieve the proper touchdown point, which resulted in a runway overrun and collision with a fence.Aug 27, 2007 · N8280E · Substantial damageNTSB SEA07CA215Accident · No injuriesData collectionFinal reportCessna 305-C · Chino, CAThe pilot's failure to maintain directional control during the landing roll.Jul 26, 2007 · N919BD · Substantial damageNTSB LAX07LA216Accident · No injuriesLimited investigationFinal reportCessna 180A · Redding, CAFuel exhaustion due to the pilot's inadequate in-flight planning/decision concerning fuel system management and his failure to refuel while en route.Jul 13, 2007 · N5248D · Substantial damageNTSB LAX07LA212Accident · No injuriesLimited investigationFinal reportCessna 182G · Orland, CAFuel exhaustion due to the pilot's improper preflight inspection and preparation, and his failure to ensure adequate fuel was onboard for the anticipated flight.Jul 9, 2007 · N4521M · Substantial damageNTSB LAX07LA140Accident · 3 fatalLimited investigationFinal reportCessna 182Q · Carlsbad, CAthe pilot's loss of control due to spatial disorientation.Apr 29, 2007 · N97287 · DestroyedNTSB LAX07LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Banning, CALoss of engine power while on final approach for undetermined reasons. Contributing to the accident was the unfavorable wind condition.Mar 3, 2007 · N735SD · Substantial damageNTSB LAX06FA256Accident · 2 fatalField investigationFinal reportCessna 182P · Whitethorn, CAThe pilot's loss of situational awareness with regard to the airplane's proximity to mountainous terrain, and her failure to maintain an adequate terrain clearance altitude or flight path, which resulted in an in-flight collision with the terrain.Aug 4, 2006 · N9904E · Substantial damageNTSB LAX06CA244Accident · No injuriesData collectionFinal reportCessna 182D · Santa Clarita, CAA loss of engine power due to fuel exhaustion. The fuel exhaustion was the result of a split O-ring on the right fuel cap, which allowed fuel to siphon out of the right fuel tank during flight.Jul 25, 2006 · N8961X · Substantial damageNTSB LAX06LA242Accident · No injuriesLimited investigationFinal reportCessna 182P · Hemet, CAthe shaking and backfiring of the engine for undetermined reasons.Jul 23, 2006 · N9886M · Substantial damageNTSB LAX06LA198Accident · Serious injuriesLimited investigationFinal reportCessna 182B · El Dorado, CAA loss of engine power for undetermined reasons and encounter with trees during the forced landing.Jun 8, 2006 · N2404G · Substantial damageNTSB LAX06LA192Accident · No injuriesLimited investigationFinal reportCessna 180A · Marina, CAthe installation of the unapproved forward seat stop by unknown maintenance personnel, which did not allow for full depth engagement of the seat lock pin, resulting in the seat slipping aft during the takeoff roll and subsequent loss of directional control. A…Jun 4, 2006 · N180LG · Substantial damageNTSB LAX06FA106Accident · 3 fatalField investigationFinal reportCessna 172RG · El Cajon, CAThe pilots of both airplanes failure to maintain an adequate visual lookout due to their relative flight paths, which limited the available visual cues. Factors were the failure of the air traffic controller(s) to issue a conflict alert to the Cessna 172RG…Feb 9, 2006 · N9531B · 2 aircraft · DestroyedNTSB LAX06FA091Accident · 1 fatalField investigationFinal reportCessna 182P · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude during a cruise descent that resulted in controlled flight into terrain (CFIT). Factors in the accident were the rising mountainous terrain, the dark nighttime lighting condition.Jan 18, 2006 · N6034J · DestroyedNTSB LAX06LA048Accident · No injuriesLimited investigationFinal reportCessna 182A · San Diego, CAThe failure of the camshaft due to fatigue of one of the gear teeth, which resulted in a loss of engine power. Factors were the fence and the fence post.Nov 27, 2005 · N3936D · Substantial damageNTSB LAX06CA025Accident · No injuriesData collectionFinal reportCessna 182Q · Torrance, CAthe pilot's excessive taxi speed, and his failure to maintain an adequate clearance from objects.Nov 4, 2005 · N182HG · Substantial damageNTSB LAX06CA010Accident · No injuriesData collectionFinal reportCessna 182B · Mokelumne Hill, CAthe pilot's improper flare resulting in a hard landing. A related factor was gusty wind conditions.Oct 15, 2005 · N2728B · Substantial damageNTSB LAX05CA219Accident · Minor injuriesData collectionFinal reportCessna 180A · Big Bend, CAthe pilot misjudged his clearance altitude above the surface of the lake, resulting in a collision with water.Jun 29, 2005 · N2929C · Substantial damageNTSB LAX05FA175Accident · 2 fatalField investigationFinal reportCessna 182M · Palm Springs, CAThe pilot's inadequate in-flight planning/decision, and his failure to maintain clearance while maneuvering in rising terrain, resulting in an in-flight collision with terrain.May 15, 2005 · N333LP · Destroyed