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 ANC13LA081Accident · Minor injuriesLimited investigationFinal reportCessna 180J · Palmer, AKThe pilot’s failure to maintain adequate airspeed during initial climb after takeoff, which resulted in a subsequent aerodynamic stall. Contributing to the accident was the pilot’s decision to take off with a slight tailwind.Aug 21, 2013 · N7807K · Substantial damageNTSB WPR13LA359Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Stanwood, WAThe pilot’s unstabilized approach and his subsequent failure to maintain airspeed during the aborted landing, which resulted in a stall and the airplane bouncing hard on the runway.Aug 4, 2013 · N58437 · Substantial damageNTSB WPR13CA352Accident · No injuriesData collectionFinal reportCessna 180J · Hungry Horse, MTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.Jul 26, 2013 · N9286C · Substantial damageNTSB CEN13LA459Accident · No injuriesLimited investigationFinal reportCessna 180H · Greencastle, INThe pilot's excessive application of the right brake during the landing, which resulted in a runway excursion.Jul 25, 2013 · N28RR · Substantial damageNTSB ANC13LA067Accident · No injuriesLimited investigationFinal reportCessna 180A · Anchorage, AKThe pilot’s loss of directional control of the airplane during a wheel landing.Jul 24, 2013 · N4814 · 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 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 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 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 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 ERA13CA265Accident · No injuriesData collectionFinal reportCessna 180 · Concord, NHThe pilot’s delayed remedial action following a loss of directional control during the landing roll.May 31, 2013 · N2724X · Substantial damageNTSB ERA13LA262Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Brevard, NCThe cylinder manufacturer's misalignment of the exhaust valve guides in the No. 2 cylinder during manufacture, which resulted in the exhaust valve sticking and the pushrod breaking and the subsequent total loss of engine power.May 30, 2013 · N6525M · Substantial damageNTSB WPR13CA242Accident · No injuriesData collectionFinal reportCessna 182R · Alpine, WYThe pilot’s inadequate flare and loss of aircraft control during landing.May 25, 2013 · N9760H · Substantial damageNTSB ERA13LA257Accident · No injuriesLimited investigationFinal reportCessna 180J · Greenwood, MSA partial loss of engine power due to carburetor icing.May 23, 2013 · N9996N · Substantial damageNTSB CEN13LA286Accident · No injuriesLimited investigationFinal reportCessna 182C · Fremont, MIThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion while in the traffic pattern.May 18, 2013 · N9075T · Substantial damageNTSB ERA13CA247Accident · No injuriesData collectionFinal reportCessna 182D · East Moriches, NYThe inadvertent deployment of the skydiving instructor's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.May 17, 2013 · N8775X · Substantial damageNTSB WPR13CA231Accident · No injuriesData collectionFinal reportCessna 182P · Carson City, NVThe pilot's failure to maintain aircraft control after an encounter with downdrafts while flying over mountainous terrain.May 15, 2013 · N911HE · Substantial damageNTSB ERA13LA241Accident · No injuriesLimited investigationFinal reportCessna 182E · Southwick, MAThe partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any malfunctions or failures that would have precluded normal operation.May 13, 2013 · N817JT · Substantial damageNTSB ERA13LA239Accident · No injuriesLimited investigationFinal reportCessna 182G · Clewiston, FLThe private pilot’s inadequate preflight planning and fuel management and the flight instructor’s inadequate supervision, which resulted in a total loss of engine power due to fuel starvation.May 9, 2013 · N2440R · Substantial damageNTSB ERA13CA231Accident · No injuriesData collectionFinal reportCessna 182G · Arcadia, NYThe pilot's improper decision to continue a high approach with a tailwind, rather than perform a go-around, which resulted in an overrun on a wet, down-sloping, grassy runway.May 4, 2013 · N2143R · Substantial damageNTSB ERA13CA216Accident · No injuriesData collectionFinal reportCessna 180 · Bethel, METhe pilot’s failure to maintain directional control during landing.Apr 28, 2013 · N180VW · Substantial damageNTSB 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 CEN13CA223Accident · No injuriesData collectionFinal reportCessna 180 · Roswell, NMThe pilot's failure to maintain directional control on the landing roll after encountering a gust of wind, which resulted in a ground loop.Mar 29, 2013 · N7714A · Substantial damageNTSB 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 ERA13CA141Accident · No injuriesData collectionFinal reportCessna 180 · Halifax, NCThe pilot's decision to land in gusty crosswind conditions, which resulted in a loss of airplane directional control during the landing roll.Feb 20, 2013 · N9411C · 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 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 WPR13CA079Accident · No injuriesData collectionFinal reportCessna 182P · Chiloquin, ORThe flight instructor’s failure to maintain airplane control during a landing on a snow-covered runway.Jan 1, 2013 · N58677 · Substantial damageNTSB CEN13CA106Accident · No injuriesData collectionFinal reportCessna 182Q · Bellview, TXThe pilot's inadequate compensation for a sudden wind shift during the approach and landing, which resulted in a runway overrun.Dec 15, 2012 · N735BV · Substantial damageNTSB 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 ERA13CA027Accident · No injuriesData collectionFinal reportCessna 182P · Maryville, TNThe pilot’s inadequate recovery from a bounced landing and his subsequent delayed decision to perform a go-around, which resulted in the airplane’s failure to clear obstacles.Oct 16, 2012 · N1264S · Substantial damageNTSB WPR13LA005Accident · Minor injuriesLimited investigationFinal reportCessna 180H · St Maries, IDThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.Oct 7, 2012 · N2780X · Substantial damageNTSB ANC12CA115Accident · No injuriesData collectionFinal reportCessna 182A · Port Lions, AKThe pilot's decision to take off with ice- and snow-contaminated wings.Oct 1, 2012 · N2028G · Substantial damageNTSB CEN12CA665Accident · Minor injuriesData collectionFinal reportCessna 182 · Tiskilwa, ILThe pilot’s loss of control while preforming a short field takeoff.Sep 30, 2012 · N82GS · Substantial damageNTSB WPR12CA440Accident · No injuriesData collectionFinal reportCessna 180 · Huntington, UTThe pilot's inadvertent encounter with a gust front during the takeoff roll, which resulted in loss of control of the airplane.Sep 29, 2012 · N3115D · Substantial damageNTSB ERA12LA575Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Fort Thomas, KYThe pilot’s failure to periodically add engine power during an extended descent in carburetor icing conditions, which resulted in insufficient carburetor heat, the gradual build-up of carburetor ice, and the subsequent loss of engine power.Sep 23, 2012 · N735FJ · Substantial damageNTSB CEN12LA635Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mecosta, MIThe pilot's improper landing flare, which resulted in a bounced landing and loss of airplane control.Sep 15, 2012 · N58844 · Substantial damageNTSB WPR12LA418Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Nampa, IDAn uncommanded bank after takeoff followed by an aerodynamic stall. The reason for the uncommanded bank could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Sep 14, 2012 · N90RW · Substantial damageNTSB WPR12CA389Accident · Minor injuriesData collectionFinal reportCessna 182L · Metaline Falls, WAThe pilot’s inadequate compensation for a sudden wind shift during the landing roll, which resulted in a runway overrun.Sep 2, 2012 · N42014 · Substantial damageNTSB CEN12TA604Accident · Serious injuriesFinal reportCessna 182P · Newberry, MIThe pilot’s failure to maintain control of the airplane due to distraction from a combination of smoke in the cockpit and a sudden turbulence encounter while on short final approach. The cause of the cockpit smoke could not be determined due to the extensive…Sep 2, 2012 · N5981J · Substantial damageNTSB CEN12CA585Accident · No injuriesData collectionFinal reportCessna 180 · Brookville, OHThe pilot's failure to maintain directional control of the airplane during the attempted takeoff in gusting crosswind conditions.Aug 28, 2012 · N2909A · Substantial damageNTSB WPR12LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · McCall, IDThe flight instructor’s selection of the wrong route while flying in mountainous terrain at a high-density altitude, which resulted in the airplane impacting terrain when the increase in elevation exceeded the airplane’s climb performance.Aug 20, 2012 · N735KV · Substantial damageNTSB WPR12CA399Accident · No injuriesData collectionFinal reportCessna 182F · Hood River, ORThe pilot's improper landing flare and inadequate recovery from a bounced landing.Aug 20, 2012 · N34SR · Substantial damageNTSB CEN12CA590Accident · No injuriesData collectionFinal reportCessna 180J · Wausau, WIThe pilot's loss of control during landing roll out, resulting in a runway excursion. Contributing to the accident was an unexpected crosswind wind gust.Aug 14, 2012 · N52187 · 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 WPR12CA353Accident · No injuriesData collectionFinal reportCessna 182 · Joseph, ORThe pilot’s excessive use of brakes during the landing roll in a gusting crosswind, which resulted in a noseover.Aug 2, 2012 · N5418B · Substantial damage