NTSB investigations: Continental O-470 series

87 cases on aircraft whose registry engine model is Continental O-470 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 ('17026')
      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 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 ERA12LA470Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Farmingdale, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 21, 2012 · N2166G · 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 WPR12CA257Accident · No injuriesData collectionFinal reportCessna 182A · Colfax, WAThe total loss of engine power during cruise flight due to the missing carburetor drain plug, which had not been secured with safety wire.Jun 11, 2012 · N4715D · Substantial damageNTSB CEN12CA079Accident · Minor injuriesData collectionFinal reportBeech 95-B55 (T42A) · College Station, TXThe total loss of engine power from both engines, which resulted from fuel exhaustion due to the pilot’s inadequate pre-flight preparation.Nov 10, 2011 · N8188R · Substantial damageNTSB CEN12CA051Accident · Minor injuriesData collectionFinal reportDowner Bellanca 14-19-2 · Borger, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident was the pilot’s diverted attention with the broken fuel gauge knob.Nov 1, 2011 · N711W · Substantial damageNTSB CEN11FA559Accident · Minor injuriesField investigationFinal reportCessna 182C · Boulder, COThe malfunction of the throttle linkage to the induction air box, which resulted in a loss of engine power and subsequent forced landing.Aug 9, 2011 · N8717T · Substantial damageNTSB WPR11LA359Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Emmett, IDA total loss of engine power due to carburetor icing because the pilot did not use carburetor heat.Aug 2, 2011 · N6399B · Substantial damageNTSB CEN11LA490Accident · No injuriesLimited investigationFinal reportDarrow Stephen AL-6 · Peyton, COThe loss of engine power during the descent for reasons that could not be determined because a thorough examination of the engine could not be completed due to the remote accident site.Jul 13, 2011 · N61262 · Substantial damageNTSB ERA11LA399Accident · No injuriesLimited investigationFinal reportCessna 182K · Stevensville, MDA total loss of engine power during initial climb for undetermined reasons.Jun 30, 2011 · N2888R · Substantial damageNTSB ERA11CA237Accident · No injuriesData collectionFinal reportCessna 182A · Lesage, WVA loss of engine power due to fuel exhaustion. Contributing to the accident was the improper installation of snap fasteners to the rubberized type fuel cells which resulted in wrinkling of the fuel bladders and incorrect fuel quantity for the flight.Apr 10, 2011 · N4810D · 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 ERA11LA190Accident · No injuriesLimited investigationFinal reportCessna 182P · Alachua, FLA loss of engine power due to the failure of the camshaft gear teeth and crankshaft gear teeth for undetermined reasons.Mar 15, 2011 · N430ML · Substantial damageNTSB CEN11LA189Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Hueco Tanks, TXThe loss of engine power for reasons undetermined.Feb 14, 2011 · N7655B · Substantial damageNTSB CEN11LA148Accident · No injuriesLimited investigationFinal reportBeech H35 · Des Moines, IAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Dec 18, 2010 · N5537D · 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 CEN11CA038Accident · No injuriesData collectionFinal reportCessna 182L · Mancelona, MIA loss of engine power in flight due to the failure of the engine's No. 5 piston.Oct 19, 2010 · N808HC · Substantial damageNTSB ERA11LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Columbia, SCA total loss of engine power due to a loss of lubrication after the engine experienced a piston ring failure for undetermined reasons.Oct 5, 2010 · N21415 · 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 CEN10LA489Accident · No injuriesLimited investigationFinal reportMeyers Industries 200C · Justin, TXA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.Aug 19, 2010 · N189M · Substantial damageNTSB WPR10CA401Accident · Minor injuriesData collectionFinal reportCessna 180D · Hillsboro, ORA loss of engine power due to fuel starvation resulting from unporting when the pilot entered into a slip during the turn to the final approach leg.Aug 13, 2010 · N6475X · Substantial damageNTSB CEN10LA433Accident · No injuriesLimited investigationFinal reportBeech H35 · Green Lake, WIA total loss of engine power during descent due to the overhaul facility’s inadequate maintenance.Jul 25, 2010 · N5443D · Substantial damageNTSB CEN10CA297Accident · Minor injuriesData collectionFinal reportCessna 180 · Humble, TXA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel management.Jun 3, 2010 · N154JD · Substantial damageNTSB ERA10TA197Accident · Minor injuriesFinal reportCessna 182P · Frederick, MDA loss of engine power for undetermined reasons following a reported severe turbulence encounter.Mar 30, 2010 · N52790 · Substantial damageNTSB CEN10LA168Accident · No injuriesLimited investigationFinal reportCessna 182G · Mount Vernon, MOA loss of engine power due to the failure of the number four connecting rod for undetermined reasons.Mar 18, 2010 · N2381R · Substantial damageNTSB WPR10LA118Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Reno, NVA total loss of engine power during cruise due to oil starvation as a result of foreign material blockage of the oil pickup tube.Jan 23, 2010 · N8948T · Substantial damageNTSB WPR10LA001Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Mitchell, ORThe pilot’s lack of understanding of the airplane’s fuel system, which resulted in a loss of engine power due to fuel exhaustion.Oct 2, 2009 · N1621C · Substantial damageNTSB ANC09LA086Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Chugiak, AKThe pilot’s delayed use of carburetor heat while operating in conditions conducive to carburetor icing.Aug 25, 2009 · N4601A · Substantial damageNTSB CEN09FA430Accident · Serious injuriesField investigationFinal reportBeech 35-A33 · Las Vegas, NMThe loss of engine power for undetermined reasons.Jul 10, 2009 · N4334W · Substantial damageNTSB WPR09LA223Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Puyallup, WAA loss of engine power due to fuel starvation as a result of the pilot’s failure to verify the fuel levels in the tanks, and, his failure to select the proper fuel tank.May 1, 2009 · N382CH · Substantial damageNTSB WPR09CA121Accident · Minor injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat before reducing power and his failure to clear the engine during a prolonged glide.Feb 20, 2009 · N4729D · Substantial damageNTSB DFW08LA226Accident · Serious injuriesLimited investigationFinal reportCessna 182D · Orange Grove, TXA total loss of engine power due to an improperly installed intake manifold tube.Sep 5, 2008 · N8979X · Substantial damageNTSB NYC08CA295Accident · No injuriesData collectionFinal reportCessna 182A · Danielson, CTFuel exhaustion due to the pilot’s inadequate fuel consumption calculations.Aug 27, 2008 · N169DP · Substantial damageNTSB DFW08CA214Accident · No injuriesData collectionFinal reportBellanca 14-19-2 · Keller, TXThe pilot's inadequate preflight inspection of the airplane which resulted in an attempted takeoff without fuel present in the selected fuel tank.Aug 24, 2008 · N7653B · Substantial damageNTSB CHI08CA255Accident · No injuriesData collectionFinal reportCessna 182C · Sparta, ILThe pilot's inadequate preflight/planning which resulted in the failure to assure an adequate fuel supply for the flight and the improper flare during the landing. Contributing to the accident was the ditch that the airplane contacted.Aug 16, 2008 · N8643T · Substantial damageNTSB NYC08CA268Accident · Minor injuriesData collectionFinal reportCessna 182L · Westerly, RIA loss of power due to a partial blockage of the air induction system.Aug 2, 2008 · N42366 · Substantial damageNTSB MIA08LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182L · Louisville, KYA total fatigue failure of the No. 5 piston during climb.May 7, 2008 · N42116 · Substantial damage