NTSB investigations: Continental IO-520 series
153 cases on aircraft whose registry engine model is Continental IO-520 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 ('17032')
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 ('17032')
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 FTW02LA022Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Clarendon, TXthe loss of engine power for undetermined reasons. Contributing factors to the accident were the dark night light conditions and the lack of suitable terrain for the forced landing.NTSB ATL02LA015Accident · No injuriesLimited investigationFinal reportCessna 188B · Whiteville, TNThe failure of the engine driven fuel pump that contaminated the fuel system and restricted fuel flow to the engine.. A factor is rough/uneven terrain.NTSB CHI01LA225Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Freemont, MIThe broken throttle cable during cruise flight and the pilot's inadequate flare during the forced landing attempt. Factors relating to this accident were the low airspeed during the forced landing attempt and the short, corn stubble field.NTSB CHI01FA206Accident · 6 fatalField investigationFinal reportBeech E-55 · Carterville, MOThe pilot's failure to maintain aircraft control and the pilot's improper in-flight planning and decisions. Factors relating to the accident were the pilot's lack of experience in the airplane, the inadvertent spiral, and the residence.NTSB MIA01LA155Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Kill Devil Hill, NCThe loss of engine power due to fuel starvation for undetermined reasons resulting in the forced landing and subsequent on-ground collision with a sand dune with a resulting nose over. A factor in the accident was the unsuitable terrain encountered during the…NTSB CHI01FA139Accident · Serious injuriesField investigationFinal reportBeech 95-C55 · St Cloud, MNthe pilot not maintaining aircraft control during the loss of right engine power during initial climb. Factors were the loss of right engine power for an undetermined reason, the pilot not complying with flight manual emergency procedures, and the trees.NTSB SEA01LA025Accident · No injuriesLimited investigationFinal reportCessna A185F · Lynwood, WAFuel exhaustion due to refueling was not performed by the pilot-in-command. Trees and a fence were factors.NTSB LAX01LA034Accident · No injuriesLimited investigationFinal reportCessna 185F · Carson City, NVFuel starvation precipitated by the pilot's continued use of the fuel selector valve that was not seating in the detents properly.NTSB SEA00LA140Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Lone Pine, ORThe complete loss of engine power for undetermined reasons. Factors include an irrigation system in the field where the forced landing took place, and the pilot's intentional initiation of a ground loop in order to miss the pipes of the irrigation system.NTSB MIA00LA199Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Albany, GAThe dual student's failure to purge the fuel lines of air after a fuel tank was run dry on the previous flight and the failure of the electric fuel boost pump on or low position due to a loose wire which resulted in failure of the engine due to air in the…NTSB CHI00LA069Accident · No injuriesLimited investigationFinal reportBeech A36 · Olathe, KSthe pilots improper use of powerplant controls. A factor in the accident was the plowed farm field.NTSB NYC00LA029Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canandaigua, NYThe pilot's inadequate preflight which resulted in a loss of power due to fuel contamination. Factors related to the accident were the pilot's non-compliance of an airworthiness directive, failure to perform an annual inspection, and improper modifications of…NTSB CHI00LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Sprague, NEEngine failure due to fouled and rusted spark plugs, and a clogged fuel filter. Factors relating to this accident were the inadequate annual inspection performed on the airplane, the trees and the ditch.NTSB MIA99LA251Accident · No injuriesLimited investigationFinal reportBellanca BL-17-30 · Athens, GAThe pilot's improper fuel management resulting in loss of engine power on approach due to fuel starvation and damage to the aircraft during the subsequent forced landing.NTSB ANC99LA126Accident · No injuriesLimited investigationFinal reportCessna A185E · Anchorage, AKThe total loss of engine power for an undetermined reason.NTSB ANC99LA096Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe total loss of engine power for undetermined reasons. A factor in this accident was the mountainous terrain in which the pilot had to perform a forced landing.NTSB NYC99LA156Accident · Serious injuriesLimited investigationFinal reportCessna 185E · East Haddam, CTThe loss of engine power due to water in the fuel system.NTSB ATL99LA062Accident · No injuriesLimited investigationFinal reportCessna 210 · Opa Locka, FLThe loss of engine power for undetermined reasons.NTSB LAX99LA094Accident · No injuriesLimited investigationFinal reportBeech F33 · Prescott, AZA total loss of engine power for undetermined reasons.NTSB ATL99LA042Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Hallandale Beac, FLThe loss of engine power for undetermined reasons.NTSB ANC99FA021Accident · Minor injuriesField investigationFinal reportCessna 207 · Quinhagak, AKLoss of engine power due to fracture of the engine crankshaft, and the manufacturer's improper manufacturing procedure during engine assembly. Factors associated with the accident were the manufacturer's inadequate quality control standards, trees, and…NTSB FTW99LA051Accident · Minor injuriesLimited investigationFinal reportBeech BE-35 · Waxahachie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB CHI98LA348Accident · No injuriesLimited investigationFinal reportCessna A185F · Bottineau, NDThe partial loss of engine power for undetermined reasons, and the pilot's excessive use of brake pressure which resulted in the aircraft nosing over..NTSB LAX98LA280Accident · No injuriesLimited investigationFinal reportCessna 188B · Dixon, CAA partial loss of engine power for an undetermined reason, and the ignition of a highly combustible compound in the application hopper.NTSB MIA98LA220Accident · No injuriesLimited investigationFinal reportCessna 188 · Atlantic Ocean (Atlantic Ocean)A complete loss of engine power due to loss of oil pressure, resulting in a force landing on non suitable terrain, and the subsequent sinking of the airplane in deep water.NTSB CHI98LA245Accident · No injuriesLimited investigationFinal reportCessna 188B · Atlanta, NEA loss of engine power due to a loose 'B' nut on the fuel line fitting. Contributing to the accident was the inadequate maintain and the soft terrain.NTSB FTW98LA266Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Mcgehee, ARA loss of engine power for undetermined reasons.NTSB ANC98LA075Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Anchorage, AKThe total loss of engine power for undetermined reasons.NTSB ANC98LA064Accident · No injuriesLimited investigationFinal reportCessna 185F · Iliamna, AKThe loss of engine power for undetermined reasons. A factor was the hilly terrain.NTSB CHI98LA162Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Crookston, MNthe pilot inadvertently stalled the airplane. Factors included the loss of engine power due to fuel exhaustion when the pilot failed to refuel the airplane. Another factor was fatigue.NTSB FTW98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Fruita, COThe total loss of engine power for undetermined reasons .NTSB FTW97LA338Accident · No injuriesLimited investigationFinal reportBeech V35B · Saguache, CO**This report was modified on 2/23/2016. Please see the public docket for this accident for additional information.** the loss of engine power during cruise for undetermined reasons and the unsuitable terrain encountered by the pilot during the forced…NTSB CHI97LA241Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Eagle, MIthe pilot's inaccurate fuel consumption calculations, his decision to switch fuel tanks too late, and fuel starvation.NTSB CHI97LA210Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNloss of engine power for undetermined reason(s). A factor relating to the accident was: the wet/soft terrain in the emergency landing area.NTSB IAD97LA093Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlton, MAThe loss of engine power for undetermined reasons..NTSB CHI97LA157Accident · No injuriesLimited investigationFinal reportCessna A188B · La Moure, NDa loss of engine power for undetermined reasons and the pilot's failure to jettison the load. Factors involved were the exceeded weight and balance limits, and the pilot's inadequate preflight planning and preparation.NTSB MIA97LA118Accident · No injuriesLimited investigationFinal reportCessna 210M · Troy, ALThe pilot's failure to obtain the proper touchdown point during an emergency landing resulting in an overrun and subsequent nose over. A factor in the accident was a reported partial loss of engine power for undetermined reasons.NTSB CHI97LA077Accident · No injuriesLimited investigationFinal reportBeech A36 · Matherville, ILa loss of engine as a result of the pilot-in-command's improper positioning of the fuel tank selector. A factor was the rough terrain.NTSB MIA97LA083Accident · No injuriesLimited investigationFinal reportCessna 210L · Weston, FLa loss of engine power for undetermined reasons. A factor was thew lack of suitable terrain for the forced landing.NTSB MIA97LA023Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Brunswick, GAa complete loss of engine power as a result of piston failure, oil starvation, and the subsequent forced landing in unsuitable terrain.NTSB MIA97LA022Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Columbiana, ALthe pilot's improper use of the fuel selector, which resulted in fuel starvation, and his failure to select a tank with fuel for a restart, which resulted in a failure to restart the engine, a forced landing, and subsequent impact with terrain. High…NTSB ATL97LA016Accident · No injuriesLimited investigationFinal reportCessna 188B · Ocilla, GAThe pilot's failure to adequately preflight and plan the fuel required for the flight.NTSB FTW97LA028Accident · Serious injuriesLimited investigationFinal reportCessna A185E · Giddings, TXThe loss of engine power as result of an oil leak due to a pinched 'O' ring in the oil filter. Factors were the improper installation of the oil filter, and the lack of suitable terrain for the forced landing.NTSB MIA96LA225Accident · No injuriesLimited investigationFinal reportCessna A188B · Winona, MSimproper maintenance of the airplane by the unqualified pilot/owner, by providing inadequate clearance between a flexible oil hose and a heat shield, which resulted in chafing of the hose, an oil leak, and subsequent oil starvation. A factor relating to the…NTSB MIA96LA215Accident · No injuriesLimited investigationFinal reportCessna 210M · Opa Locka, FLthe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation, a forced landing, and subsequent in flight collision with terrain. The lack of suitable terrain for a forced landing was a related factor.NTSB LAX96FA308Accident · 1 fatalField investigationFinal reportCessna 210E · Big Bear City, CAan inadequate annual inspection conducted by other maintenance personnel.NTSB CHI96LA292Accident · No injuriesLimited investigationFinal reportCessna 210E · Clarksville, MOfuel starvation for undetermined reason(s). Factors relating to the accident were: the crop, and the uphill terrain condition in the emergency landing area.NTSB IAD96LA092Accident · No injuriesLimited investigationFinal reportBeech V35B · Westminster, MDThe fracture of the engine crankshaft which had a subsurface origin and progressed in fatigue until overload and separation occurred.NTSB FTW96LA226Accident · Serious injuriesLimited investigationFinal reportNavion NA1 · Los Lunas, NMThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB MIA96LA137Accident · No injuriesLimited investigationFinal reportCessna U206G · Gulf Of MexicoLoss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain encountered during the forced landing.