NTSB investigations: Continental IO-520 series

134 cases on aircraft whose registry engine model is Continental IO-520 series, where the defining event was Loss of engine power (total). 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 ('17032')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341'))
  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 CEN17LA352Accident · No injuriesLimited investigationFinal reportCessna 210G · Hallsville, MOThe total loss of engine power due to a fatigue failure of the engine mixture control cable.Sep 13, 2017 · N5906F · Substantial damageNTSB ERA17LA307Accident · Minor injuriesClass 3 · LimitedFinal reportCessna U206 · Harpswell, MEA total loss of engine power due to maintenance personnel's failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1, 2, and 3 main bearings, loss of lubrication, and failure of the crankshaft.Sep 1, 2017 · N4615X · Substantial damageNTSB ANC17LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Wasilla, AKThe pilot’s failure to manage fuel quantity in flight, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow manufacturer guidance for restoring engine power after emptying a fuel…Jul 16, 2017 · N401WC · Substantial damageNTSB CEN17LA286Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Walters, OKMaintenance personnel’s installation of an improper vacuum pump gasket, which resulted in oil starvation to the engine and a subsequent total loss of engine power.Jul 8, 2017 · N6257V · Substantial damageNTSB WPR17LA070Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Pomona, CAThe total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no mechanical malfunctions or failures that would have precluded normal operation.Feb 16, 2017 · N222EN · Substantial damageNTSB CEN17LA081Accident · No injuriesLimited investigationFinal reportBellanca 17 30 · Kidron, OHMaintenance personnel’s failure to properly secure the vacuum pump, which resulted in a loss of engine oil and the subsequent total loss of engine power due to oil starvation.Jan 21, 2017 · N39819 · Substantial damageNTSB CEN17LA058Accident · No injuriesLimited investigationFinal reportBellanca 17 30A · Blaine, MNA total loss of engine power due to a lack of crankshaft lubrication to the No. 4 connecting rod journal.Dec 18, 2016 · N4204B · Substantial damageNTSB ERA16WA232Accident · No injuriesForeign investigationCessna U206 · Fresh Creek, BahamasOn June 25, 2016, about 2106 Universal Coordinated Time (UTC), a Cessna U206F, N9662G, operated by Chrimat Inc., was substantially damaged following a loss of engine power and forced landing at Fresh Creek, Bahamas. The pilot was not injured. The airplane…Jun 25, 2016 · N9662G · Substantial damageNTSB ERA16CA203Accident · No injuriesData collectionFinal reportBeech F33A · Fairfield, NJThe pilot's failure to adequately manage the available fuel supply, resulting in fuel starvation and a total loss of engine power.Jun 5, 2016 · N444VT · Substantial damageNTSB ERA16LA158Accident · No injuriesLimited investigationFinal reportCessna U206 · Atlantic Ocean (Atlantic Ocean)A total loss of engine power for reason(s) that could not be determined because the airplane was not recovered.Apr 15, 2016 · N1346Q · Substantial damageNTSB CEN16LA090Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Overbrook, OKThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent decision to circle to the north end of the airport due to a light tailwind condition instead of making a downwind landing.Jan 17, 2016 · N194DW · Substantial damageNTSB CEN15FA424Accident · 2 fatalField investigationFinal reportBeech S35 · Pagosa Springs, COImproper engine assembly by unknown maintenance personnel, which resulted in the failure of the No. 6 connecting rod due to oil starvation from the shifting of the crankshaft's No. 4 main bearing.Sep 25, 2015 · N193Q · DestroyedNTSB CEN15LA336Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Austin, TXA total loss of engine power due to an excessively rich fuel mixture as a result of the improper adjustment of the fuel pump aneroid.Aug 4, 2015 · N17544 · Substantial damageNTSB CEN15LA107Accident · Serious injuriesLimited investigationFinal reportCessna 210J · Dodge City, KSThe loss of engine power on approach due to fuel exhaustion, which resulted from the pilot's improper preflight fuel planning and inspection.Jan 14, 2015 · N3320S · Substantial damageNTSB ERA15LA090Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Key West, FLA total loss of engine power for reasons that could not be determined during postaccident examinations and testing.Jan 3, 2015 · N2534X · Substantial damageNTSB ERA14LA436Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, GAThe improper installation of the oil filter adapter at an unknown time, which resulted in an oil leak and subsequent oil starvation to the engine.Sep 14, 2014 · N6648V · Substantial damageNTSB ERA14FA403Accident · 1 fatalField investigationFinal reportBeech S35 · Laurel Hill, FLA total loss of engine power due to detonation/preignition damage of the No. 6 cylinder. Contributing to the accident was the pilot’s decision to continue flight after receiving an indication of an impending engine failure.Aug 23, 2014 · N334DF · DestroyedNTSB CEN14LA425Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Braithwaite, LAThe pilot's mismanagement of the fuel system, which resulted in a total loss of engine power due to fuel starvation and the subsequent forced landing.Aug 13, 2014 · N2272X · Substantial damageNTSB CEN14LA393Accident · Serious injuriesLimited investigationFinal reportBeech 35-C33A · Pueblo, COA total loss of engine power due to fuel starvation, which resulted from the pilot’s improper fuel management and resulted in a forced landing on unsuitable terrain.Jul 27, 2014 · N72CW · Substantial damageNTSB CEN14LA331Accident · No injuriesLimited investigationFinal reportCessna A188 · Arlington, TXThe total loss of engine power due to a loose oil filter adapter, which resulted in oil starvation. Contributing to the accident was maintenance personnel’s failure to comply with a Federal Aviation Administration airworthiness directive.Jun 27, 2014 · N8157V · Substantial damageNTSB ANC14LA040Accident · No injuriesLimited investigationFinal reportCessna U206C · Chitina, AKThe failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue, which resulted in a total loss of engine power during cruise flight.Jun 9, 2014 · N29137 · Substantial damageNTSB CEN14LA253Accident · No injuriesLimited investigationFinal reportBeech A36 · Rockdale, TXA loss of engine power for reasons that could not be determined because postaccident testing revealed no anomalies.May 26, 2014 · N188DP · Substantial damageNTSB ERA14LA193Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Louisa, VAThe pilot's decision to continue operation of the airplane with known mechanical issues (fluctuating oil pressure and metal in the oil filter), which was the result of undertorqued cylinder through bolts. Contributing to the accident was the mechanic's…Apr 11, 2014 · N156SA · Substantial damageNTSB ERA14LA076Accident · Serious injuriesLimited investigationFinal reportCessna 210N · Tampa, FLA total loss of engine power due to the fatigue failure of the No. 4 connecting rod. Contributing to the accident was a likely loss of lubrication for reasons that could not be determined during a postaccident engine examination.Dec 20, 2013 · N5307A · Substantial damageNTSB ERA14LA052Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Trussville, ALThe failure of the No. 2 connecting rod due to oil starvation, which resulted in a total loss of engine power.Nov 28, 2013 · N5655D · Substantial damageNTSB ERA14LA051Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Montrose, PAThe pilot’s failure to check the fuel tanks for contaminants after fueling, which resulted in a total loss of engine power due to water contamination.Nov 28, 2013 · N777BK · Substantial damageNTSB CEN14LA002Accident · Serious injuriesLimited investigationFinal reportBeech S35 · Brownwood, TXA loss of engine power due to fuel starvation, which resulted from a foreign material in the fuel system blocking the fuel flow to the engine.Oct 8, 2013 · N6861Q · Substantial damageNTSB ERA13LA428Accident · No injuriesLimited investigationFinal reportBeech A36 · Wellington, FLA total loss of engine power due to an interruption in fuel flow, which was most likely due to fuel starvation. Contributing to the accident was the pilot’s failure to maintain control of the airplane while performing the subsequent forced landing to a wet…Sep 23, 2013 · N40KG · Substantial damageNTSB ERA13LA331Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Tupelo, MSThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 20, 2013 · N117HB · Substantial damageNTSB CEN13FA267Incident · No injuriesField investigationFinal reportBeech 58 · Mena, ARA partial loss of power on both engines during takeoff for reasons that could not be determined because examination of the airframe and a test run of both engines revealed no mechanical anomalies that would have precluded normal operation.May 4, 2013 · N44GC · Minor damageNTSB CEN13LA204Accident · No injuriesLimited investigationFinal reportBeech A36 · Cordova, ILA partial loss of engine power for reasons that could not be determined because a postaccident test run of the engine revealed no mechanical failures or malfunctions that would have precluded normal operation.Mar 23, 2013 · N6038R · Substantial damageNTSB ANC13LA029Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe failure of the engine’s No. 1 piston connecting rod retaining bolts due to fatigue fracturing, which resulted in a loss of engine power during cruise flight.Mar 6, 2013 · N1704U · Substantial damageNTSB WPR13LA052Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAA partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.Nov 25, 2012 · N5229U · Substantial damageNTSB WPR13LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · San Rafael, CAThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Nov 20, 2012 · N3919Y · Substantial damageNTSB CEN13LA056Accident · Minor injuriesLimited investigationFinal reportCessna 210L · La Grange, TXThe total loss of engine power due to the loss of oil to the engine. Contributing to the accident was maintenance personnel’s improper installation of the engine oil filter adaptor, which resulted in the loss of oil to the engine.Nov 9, 2012 · N732BL · Substantial damageNTSB ANC12LA093Accident · No injuriesLimited investigationFinal reportCessna U206D · Nikolai, AKThe total loss of engine power for reasons that could not be determined because the engine was not made available for examination.Aug 25, 2012 · N729RV · Substantial damageNTSB ERA12LA500Accident · No injuriesLimited investigationFinal reportBeech V35B · Effingham, SCThe pilot's failure to avoid an encounter with known adverse weather conditions, which resulted in an in-flight upset, temporary loss of control, and loading of the airframe, engine, and propeller that led to the in-flight separation of the propeller and the…Aug 11, 2012 · N11JK · Substantial damageNTSB ANC12FA079Accident · Minor injuriesField investigationFinal reportBeechcraft F33A · Fairbanks, AKThe total loss of engine power reason that could not be determined because postaccident examination and test run did not reveal any anomalies that would have precluded normal operation.Jul 26, 2012 · N334DH · Substantial damageNTSB WPR12LA309Accident · No injuriesLimited investigationFinal reportBeech A36 · Rock Springs, WYThe total loss of engine power due to fuel starvation because of the incorrectly installed fuel cap. Contributing to the accident was the pilot’s decision to continue the flight using fuel from the left fuel tank after she observed fuel streaming from the…Jun 22, 2012 · N4972M · Substantial damageNTSB CEN12LA224Accident · No injuriesLimited investigationFinal reportCessna U206B · Winterset, IAThe loss of oil pressure to the No. 4 connecting rod journal and the subsequent loss of engine power.Apr 1, 2012 · N3830G · Substantial damageNTSB ERA12LA157Accident · Minor injuriesLimited investigationFinal reportCessna 210E · Port Orange, FLThe total loss of engine power for reasons that could not be conclusively determined during postaccident examination.Jan 25, 2012 · N7130U · Substantial damageNTSB ERA12FA074Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · Ulysses, PAThe total loss of left engine power due to fuel starvation, and the pilot’s improper configuration of the fuel system during remedial actions, which resulted in fuel starvation of the right engine. Contributing to the accident was the pilot’s incomplete…Nov 17, 2011 · N54552 · Substantial damageNTSB CEN12LA074Accident · No injuriesLimited investigationFinal reportBeech S35 · Elkhart Lake, WIThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Nov 15, 2011 · N5858S · Substantial damageNTSB WPR12LA027Accident · No injuriesLimited investigationFinal reportBeech A36 · Yucca Valley, CAA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Nov 6, 2011 · N64Z · Substantial damageNTSB ANC11LA103Accident · No injuriesLimited investigationFinal reportCessna U206G · Beluga, AKThe total loss of engine power for an undetermined reason.Sep 15, 2011 · N1779R · Substantial damageNTSB WPR11LA410Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Napa, CAThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation.Aug 28, 2011 · N6052W · Substantial damageNTSB ANC11LA061Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Anchorage, AKThe pilot’s decision to depart with minimal fuel and his improper fuel management and engine restart procedures, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the Pilot Operating Handbook did not provide the…Jul 9, 2011 · N9129M · Substantial damageNTSB CEN11LA381Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canton, TXThe loss of fuel pressure for undetermined reasons, which resulted in a loss of engine power.Jun 8, 2011 · N93650 · Substantial damageNTSB CEN11FA274Accident · Minor injuriesField investigationFinal reportBeech A36 · Monaville, TXA total loss of engine power for undetermined reasons.Apr 7, 2011 · N24192 · Substantial damageNTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.Dec 5, 2010 · N9742Z · Substantial damage