NTSB investigations: Continental O-470 series
121 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of engine power”. 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 350))
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.
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB MIA00LA233Accident · No injuriesLimited investigationFinal reportCessna 188B · Washington, NCa loss of engine power for undetermined reason, resulting in a forced landing, and subsequent impact with a ditch.NTSB FTW99FA261Accident · 5 fatalField investigationFinal reportCessna 182A · Bryan, TXthe pilot's failure to maintain aircraft control resulting in an inadvertent stall. A factor was the loss of engine power as a result of fatigue cracking and separation of the #6 cylinder head.NTSB ANC99LA120Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fairbanks, AKA loss of engine power for an undetermined reason. A factor was unsuitable terrain for a forced landing.NTSB SEA99LA136Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Freeland, WAThe pilot-in-command's improper use of carburetor heat and overload of the nose gear assembly during the forced landing. Contributing factors were carburetor icing conditions, the ditch and fence.NTSB MIA99LA192Accident · No injuriesLimited investigationFinal reportCessna 182Q · Rock Springs, NC**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** Inadequate preflight by the commercial pilot/CFI receiving instruction resulting in an in-flight loss of engine power due to fuel exhaustion.NTSB SEA99LA078Accident · No injuriesLimited investigationFinal reportCessna 182K · Kalispell, MTA loss of engine power for undetermined reasons. Rough terrain was a factor.NTSB FTW99LA070Accident · No injuriesLimited investigationFinal reportCessna 180J · Granbury, TXThe loss of engine power due to an undetermined reason. A factor was the power lines crossing the final approach path.NTSB CHI98LA156Accident · No injuriesLimited investigationFinal reportCessna 182 · Independence, MOA loss of engine power due to the separation of the induction system balance tube coupling from the intake manifold tube assembly. A related factor was the soft field.NTSB NYC98LA042Accident · No injuriesLimited investigationFinal reportCessna 182P · Chatham, MAloss of engine power for undetermined reason(s). The tail wind component and an encounter with a ditch were related factors.NTSB MIA97LA241Accident · No injuriesLimited investigationFinal reportCessna 182B · Paris, TNTemporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.NTSB LAX97LA301Accident · No injuriesLimited investigationFinal reportBeech H35 · Goleta, CAwas a loss of engine power for undetermined reasons.NTSB ANC97LA077Accident · No injuriesLimited investigationFinal reportCessna 180 · Shaktoolik, AKloss of engine power for undetermined reason(s).NTSB SEA97LA026Accident · No injuriesLimited investigationFinal reportCessna 182G · Hardin, MTthe pilot's inadequate compensation for the wind conditions during the landing, and his failure to maintain directional control of the aircraft after touched down. Factors relating to the accident included the pilot's abrupt movement of the throttle as he…NTSB FTW96LA392Accident · Minor injuriesLimited investigationFinal reportBeech H35 · Boulder, COa loss of engine power due to a plugged fuel tank vent which resulted in fuel starvation. A factor was the lack of suitable terrain for the forced landing.NTSB SEA96LA160Accident · No injuriesLimited investigationFinal reportCessna 182A · Toledo, WAloss of engine power for undetermined reason(s). Factors relating to the accident were: the pilot's need to maneuvering to avoid obstructions near the approach end of the runway, and a ditch in the emergency landing area.NTSB IAD96LA081Accident · No injuriesLimited investigationFinal reportCessna 205A · Sommerville, VAthe loss of engine power for undetermined reasons during banner towing operations.NTSB SEA96LA075Accident · No injuriesLimited investigationFinal reportRyan Navion · Kent, WAthe pilot's attempted operation with known deficiencies in the equipment, and a loose fuel system fitting. The pilot's failure to maintain maintenance service on the airplane was a factor.NTSB FTW96LA065Accident · Serious injuriesLimited investigationFinal reportCessna 182E · Erie, COinadequate preflight by the pilot, by failing to properly remove water and other contamination from the fuel system before the flight. Factors relating to the accident were: deteriorated seals at the fuel filler neck/caps, and the annual inspection was…NTSB CHI96LA020Accident · No injuriesLimited investigationFinal reportCessna 180A · Goose Lake, IAinadequate maintenance, inadequate preflight by the pilot, and a loose fuel tank cap that allowed siphoning of fuel, buckling of the right fuel bladder, fuel exhaustion, and loss of engine power. Factors relating to the accident were: darkness, and the soft…NTSB MIA95LA139Accident · No injuriesLimited investigationFinal reportCessna 182A · Vero Beach, FLTotal loss of engine power for undetermined reasons while on final approach to land and unsuitable terrain encountered during the landing roll.NTSB NYC95LA067Accident · No injuriesLimited investigationFinal reportCessna 180J · West Dover, VTA loss of power for undetermined reasons. The frozen snow covered terrain was a factor.NTSB LAX94LA348Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Orland, CAThe pilot's failure to follow checklist procedures to assure that the fuel selector was in the both fuel tanks position. Fuel starvation and the dark night were factors in this accident.NTSB FTW94LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe loss of engine power for undetermined reasons. Factors were the wire strike and lack of suitable terrain.NTSB FTW94LA051Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Dalhart, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB SEA94LA016Accident · No injuriesLimited investigationFinal reportCessna 180K · Garfield, WAConnecting rod bolt fatigue.NTSB FTW93LA111Accident · No injuriesLimited investigationFinal reportCessna 182 · Washington, OKLoss of engine power for undetermined reason(s).NTSB CHI93LA001Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Marion, IAThe loss of engine power for undetermined reasons.NTSB SEA92LA135Accident · No injuriesLimited investigationFinal reportCessna 182K · Rock Springs, WYThe disconnection of the throttle cable and collapse of the nose landing gear. Factors contributing to the accident were: improper maintenance installation by the mechanic whose attention was diverted and the rouh/uneven terrain.NTSB FTW92LA170Accident · No injuriesLimited investigationFinal reportCessna 182D · Beeville, TXEngine power loss for undetermined cause. A factor was the pilots' failure to lower flaps for the short field landing.NTSB FTW92LA105Accident · No injuriesLimited investigationFinal reportCessna 182A · Stanton, TXPower loss for undetermined reasons. A factor was soft terrain.NTSB CHI91LA148Accident · No injuriesLimited investigationFinal reportCessna 182L · Port Huron, MIThe pilot's inadequate landing flare during the forced landing. The pilot's failure to use carburetor heat was a factor.NTSB NYC91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Princeton, NJPilot factor in that the pilot failed to use carburetor heat resulting in engine power loss due to carburetor ice. Factors were unsuitable terrain and obstructions.NTSB BFO90LA048Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Evans, WVFailure of the engine due to carburetor float chaffing resulting in a forced landing on unsuitable terrain. Contributing to the accident was failure of the operator to comply with a service bulletin.NTSB LAX90LA075Accident · No injuriesLimited investigationFinal reportBellanca 14-19-2 · Palos Verdes, CALoss of engine power for undetermined reasons.NTSB FTW90LA019Accident · No injuriesLimited investigationFinal reportCessna 182J · Leesville, LAThe loss of engine power for undetermined reasons. Contributing to the severity of the accident was: the lack of a suitable landing area.NTSB NYC89LA181Accident · No injuriesLimited investigationFinal reportCessna 185D · Wolfeboro, NHLoss of engine power for an unknown reason. Factors related to the accident were: the obstructions (trees & boats) in the emergency landing area.NTSB CHI89LA123Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Tecumseh, MILoss of engine power for an undetermined reason. The embankment (dirt bank) was a contributing factor.NTSB MIA88FA269Accident · 1 fatalField investigationFinal reportCessna 305A · Tampa, FLPlt experienced complete loss of engine power while climbing through 200 ft. the aircraft stalled and mushed, descending out of control and crashing to the ground. The engine was operated to full power after the accident. The cause of the loss of engine power…NTSB LAX88LA263Accident · No injuriesLimited investigationFinal reportCessna 182 · Ajo, AZThe plt rprtd that while on final apch to land, the eng suddenly lost power. A forced landing was made about 400' short of the rwy. Drg the landing roll, the acft hit a ditch & nosed over. The airplane was disassembled & moved before it was examined by…NTSB MIA88LA202Accident · No injuriesLimited investigationFinal reportCessna 180 · Bimini, BahamasLow engine oil pressure and subsequent engine seizure for undetermined reasons.NTSB LAX88LA029Accident · No injuriesLimited investigationFinal reportCessna 182A · Laveen, AZThe pilot stated that he was ferrying his aircraft three miles to a private strip. Shortly after takeoff, the engine began losing power. The pilot did not think he could make it to the private strip so he attempted a precautionary landing on a dirt road. He…NTSB FTW87LA030Accident · No injuriesLimited investigationFinal reportCessna 305A · Mason, TXPrivate pilot of Cessna 305A ferrying aircraft from glascow, MT. To mc allen TX. Engine failed approximately 1 1/2 hours after departure from graham TX. Pilot attempted downwind landing on farm-to-market road and struck tree. Aircraft was destroyed. Pilot and…NTSB SEA87LA029Accident · No injuriesLimited investigationFinal reportCessna 182Q · Mountain Home, IDOn short final the engine began running rough. The pilot elected at that time to place the carburetor heat in the on position. The engine then ceased operating. The pilot landed the aircraft short of the runway and struck a chain link fence during the landing…NTSB ATL86IA167Incident · No injuriesIncident investigationFinal reportBeech H35 · Birmingham, ALDuring takeoff ground run the aircraft would not develop full power according to the pilot. The pilot elected to abort the takeoff and during the aborted takeoff the aircraft ran off the end of the runway.NTSB NYC86LA082Accident · No injuriesLimited investigationFinal reportCessna 182 · Pepperell, MAAfter descending to traffic pattern altitude. The throttle was advanced with no response from the engine. On flare to landing, pilot experienced sun glare, drifted to the right, and touched down in a snow bank. Nose gear dug in and aircraft flipped over onto…NTSB ATL86LA060Accident · No injuriesLimited investigationFinal reportCessna 182Q · Carthage, MSWhile on final approach for landing the pilot advanced the throttle to adjust his final approach path and the engine lost power. The aircraft impacted the ground short of the runway and flipped inverted. The engine was later test run and performed to…NTSB NYC86LA065Accident · No injuriesLimited investigationFinal reportCessna 305-L-19 · Hilltown, PAThe Cessna was towing a glider when at an altitude of about 150 feet to about 200 feet, a decrease in RPM was experienced. The glider was detached from the aircraft, the nose was lowered and a left turn made while still over the gliderport. A rapid descent…NTSB FTW86LPJ03Accident · No injuriesFinal reportCessna 182 · Goldsby, OKThe plt stated the purpose of the flt was to drop parachute jumpers. The jumpers deplaned at 8500 ft MSL and the plt reduced pwr for a descent and landing at the arpt of departure. He stated he did not apply carb heat during the entire descent and he entered…NTSB CHI85LA285Accident · Serious injuriesLimited investigationFinal reportCessna 182 · North Canton, OHThe preflight, engine runup and initial takeoff were uneventful. At approx 600 ft AGL the engine sputtered for two or three seconds then stopped. The pilot turned back toward the runway but was too low. He crash landed in a gravel quarry after clipping power…NTSB FTW85LA108Accident · No injuriesLimited investigationFinal reportCessna 182A · Covington, LADuring an apch to land, the eng lost power & the plt made an off arpt landing. While he was landing, the acft collided with a levee & was damaged. Ample fuel was still remaining in the acft & no preimpact failure or malfunction was found that would have…