NTSB investigations: Continental IO-520 series
198 cases on aircraft whose registry engine model is Continental IO-520 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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\" = 353))
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" = 353))
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 FTW98LA081Accident · Minor injuriesLimited investigationFinal reportCessna 310R · Grants, NMThe pilot's failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was the pilot's inadequate preflight inspection, which failed to secure the right engine oil cap, resulting in oil exhaustion and the loss of engine…NTSB LAX98LA040Accident · No injuriesLimited investigationFinal reportAero Commander 200D · San Carlos, CAThe pilot's failure to verify that there was an adequate supply of fuel in the selected fuel tank prior to takeoff.NTSB SEA98LA004Accident · Serious injuriesLimited investigationFinal reportBeech V-35 · Medford, ORthe pilot's failure to refuel the airplane.NTSB ANC97LA153Accident · No injuriesLimited investigationFinal reportCessna 185E · Wasilla, AKThe loss of engine power due to water contaminated fuel, and the pilot's inadequate preflight inspection of the airplane. A factor associated with the accident was the lack of suitable terrain for a forced landing.NTSB LAX97LA299Accident · Serious injuriesLimited investigationFinal reportCessna 210E · Oxnard, CAThe failure of maintenance personnel to properly secure a fuel supply line during a 100-hour inspection and the failure of inspection personnel to detect the loose fitting.NTSB FTW97LA224Accident · No injuriesLimited investigationFinal reportAero Commander 200D · Little Rock, ARa loss of engine power due to fuel starvation from a partially blocked fuel line which was the result of improper maintenance by unknown person(s). A factor was the lack of suitable terrain for landing.NTSB LAX97LA097Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Los Angeles, CAFuel starvation resulting from the pilot's improper fuel tank selector position and failure to perform correct emergency procedures.NTSB FTW97LA066Accident · No injuriesLimited investigationFinal reportCessna 210N · Kerrville, TXthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor relating to the accident was: the lack of suitable terrain for a forced landing.NTSB MIA96LA198Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Sarasota, FLthe pilot's inadequate preflight inspection of the fuel tanks resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB LAX96LA276Accident · No injuriesLimited investigationFinal reportCessna A188B · Merced, CAFuel exhaustion due to the pilot's inadequate preflight inspection and his failure to ensure that adequate fuel was onboard to complete the flight.NTSB LAX96LA175Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Santa Barbara, CAThe pilot's failure to select a fuel tank containing an adequate quantity of fuel prior to landing, which resulted in fuel starvation.NTSB ANC95LA126Accident · No injuriesLimited investigationFinal reportCessna 206G · Skwentna, AKThe pilot's improper handling of the aircraft (prolonged yawing maneuver during step taxi turn), which resulted in uncovering of the fuel tank outlets and subsequent fuel starvation during takeoff.NTSB LAX95LA234Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Truckee, CAfuel exhaustion due to the pilot's inadequate preflight fuel planning, and his failure to refuel the aircraft while en route.NTSB FTW95LA273Accident · No injuriesLimited investigationFinal reportCessna A188A · Pharr, TXThe pilot's inadequate aircraft preflight which failed to purge the aircraft fuel system of contaminants. A factor was the unsuitable terrain in the emergency landing area.NTSB ATL95LA066Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Cleveland, TNThe pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion during the final approach for landing.NTSB ATL95LA048Accident · Minor injuriesLimited investigationFinal reportCessna T210G · Covington, TNThe pilot's inadequate preflight inspection of the aircraft, in that he did not adequately drain water from the fuel system, resulting in water ingestion into the engine.NTSB LAX95LA070Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Lancaster, CAfuel starvation due to the pilot's failure to select a tank containing fuel.NTSB ATL95LA032Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Union City, TNThe improper preflight planning by the pilot which resulted in the exhaustion of the aircraft's fuel. The rough terrain condition was a factor.NTSB CHI94LA333Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Elkhart, INthe pilot's improper use of the fuel selector position which resulted in fuel starvation.NTSB FTW94LA264Accident · No injuriesLimited investigationFinal reportCessna A188B · Sherman, TXThe pilot's failure to refuel the airplane. A factor was the leaking fuel caps.NTSB CHI94LA254Accident · Serious injuriesLimited investigationFinal reportBeech 33 · Wichita, KSthe pilot's inadequate management of the fuel which resulted in fuel starvation.NTSB FTW94LA079Accident · Minor injuriesLimited investigationFinal reportCessna T210H · Mcallen, TXThe pilot's inadvertent stall of the airplane. Factors were the pilot's failure to refuel and the resultant fuel exhaustion.NTSB BFO93LA159Accident · No injuriesLimited investigationFinal reportCessna 206 · Inlet, NYthe blocked header tank fuel port which resulted in fuel starvation. A factor to the accident were the high obstructions in the emergency landing area.NTSB FTW93LA193Accident · Serious injuriesLimited investigationFinal reportCessna AT188B · Holly Grove, ARTotal loss of power due to fuel exhaustion due to the pilot not refueling. A factor was the lack of suitable terrain for the forced landing.NTSB SEA93LA129Accident · Minor injuriesLimited investigationFinal reportCessna T210K · Forest Grove, ORLoss of engine power due to fuel exhaustion, resulting from inadequate preflight planning/preparation by the PIC.NTSB LAX93LA218Accident · No injuriesLimited investigationFinal reportBeech 36 · Hayward, CAfuel starvation due to the pilot's inadequate preflight inspection of the aircraft and his failure to ensure that adequate fuel existed in the fuel tanks to be used.NTSB SEA93LA096Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Laurel, MTThe loss of engine power from fuel exhaustion due to the pilot's failure to ensure an adequate supply of fuel for the flt.NTSB FTW93LA109Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Plainview, TXThe pilot's the improper flare prior to touchdown. Factors were the fuel starvation power loss and improper positioning of the fuel selector.NTSB FTW93LA097Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Plano, TXFuel starvation induced power loss resultant from failure of the pilot to switch the fuel selector to the proper fuel tank. Factors were the dark night conditions and lack of suitable terrain for a forced landingNTSB ANC93LA039Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKThe fuel system selector valve being placed in the off position due to the improper installation of the fuel selector placard by an unqualified person. The snow covered forced landing area was a factor.NTSB SEA93LA059Accident · No injuriesLimited investigationFinal reportCessna A185F · Inglewood, WAFuel exhaustion, the pilot in command's inadequate preflight, and his failure to flare on landing. A factor contributing to the accident was fog.NTSB ATL92LA171Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sylvania, GAAn inadequate preflight inspection by the pilot which resulted in fuel contamination and a loss of engine power.NTSB NYC92FA164Accident · Serious injuriesField investigationFinal reportBeech D55 · Oxford, METhe pilot's improper preflight and fuel tank selection for takeoff, which resulted in fuel starvation and loss of power in both engines during takeoff.NTSB MIA92LA133Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Panama City, FLThe pilot in command's failure to enrich the mixture control during descent, resulting in loss of engine power, and his improper engine restart procedure which resulted in his being unable to get the engine started prior to an off airport landing.NTSB LAX92FA185Accident · 2 fatalField investigationFinal reportBeech S35 · Long Beach, CAThe pilot's failure to maintain an airspeed above the airplane's stall speed (vs) and inadvertent entry into a spin. The engine failure resulting from contaminated fuel and inadequate preflights were factors in the accident.NTSB ATL92LA088Accident · No injuriesLimited investigationFinal reportBellanca 17-30 · Alto, GAThe pilot's mismangement of the fuel in that he delayed selection of a fuel tank with usable fuel, and the excessive final landing speed. Factors were the pilot's failure to extend the flaps and the rough/uneven terrain because of the railroad spur.NTSB LAX92LA181Accident · No injuriesLimited investigationFinal reportNavion G · Santa Paula, CAThe pilot's improper aircraft preflight by failing to assure the fuel selector handle was in the proper position. Factors relating to this accident was the engine fuel starvation.NTSB ANC92LA045Accident · No injuriesLimited investigationFinal reportCessna 207A · Quinhagak, AKThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain on which to make the forced landing.NTSB FTW92LA060Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Albuquerque, NMThe pilot in command failed to properly monitor the fuel consumption rate of the airplane when he perceived that it might be higher than normal. The engine failure was a result of fuel exhaustion, aggravated by possible fuel siphoning from the tanks.NTSB BFO91LA067Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Norton, WVThe pilot's inadequate inflight decision which resulted in fuel exhaustion and the lost of engine power.NTSB ANC91LA074Accident · No injuriesLimited investigationFinal reportCessna A185E · King Salmon, AKFuel exhaustion, the pilot's inadequate preflight and the inadequate fuel consumption calculations. Contributing to the accident was the soft terrain, and tundra.NTSB NYC91LA234Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Sanford, METhe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a forced landing in trees.NTSB ANC91IA039Incident · No injuriesIncident investigationFinal reportCessna U206G · Sparrevohn Afs, AKThe loss of engine power due to the ice in the fuel strainer/gascalator. Contributing was: the inadequate preflight preparation by the pilot, and unsuitable terrain on which to make the forced landing.NTSB LAX91LA114Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Coalinga, CAFuel starvation and the improper use of the fuel selector by the pilot. The rough terrain on which the aircraft landed was a factor in the accident.NTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.NTSB ANC90LA175Accident · No injuriesLimited investigationFinal reportCessna 206 · Puntilla Lake, AKAn inadequate preflight.NTSB LAX90LA249Accident · No injuriesLimited investigationFinal reportBeech V35B · Big Bear, CAThe fuel starvation due to the pilot's inadvertent selection of an empty fuel tank.NTSB FTW90DPA02Accident · No injuriesFinal reportCessna A188B · Perry, TXThe total loss of engine power as a result of water contamination of the fuel supply. A factor was the unsuitable terrain in which the pilot had to make the forced landing.NTSB ANC90LA058Accident · No injuriesLimited investigationFinal reportCessna 185E · Bethel, AKImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadeqaute supply of fuel.NTSB FTW90DRA01Accident · Minor injuriesFinal reportCessna A188B · Muldoon, TXA total power loss due to water contamination in the fuel. A factor was the pilot's inadequate preflight inspection.