NTSB investigations: Continental O-470 series
233 cases on aircraft whose registry engine model is Continental O-470 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 ('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\" = 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 ('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" = 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 ANC01LA063Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot's failure to refuel the airplane, his inadequate preflight planning/decision making, and subsequent fuel exhaustion during cruise flight.NTSB NYC01LA112Accident · No injuriesLimited investigationFinal reportCessna 182Q · Paintsville, KYThe pilot's inadequate preflight inspection of the aircraft, which resulted in fuel exhaustion during cruise flight.NTSB ATL01LA045Accident · Serious injuriesLimited investigationFinal reportCessna 182 P · Kennesaw, GAThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.NTSB ATL01LA037Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Durham, NCThe loss of engine power for undetermined reasons. Conditions for carburetor icing were present at the time of the accident.NTSB FTW01LA074Accident · No injuriesLimited investigationFinal reportCessna 182P · Tuttle, OKfuel exhaustion due to a loose fuel cap as a result of the pilot's inadequate preflight. A contributory factor was the lack of suitable terrain for the forced landing.NTSB CHI01LA045Accident · No injuriesLimited investigationFinal reportLarson Aero COMP-6 · Brainerd, MNThe pilot's inadequate preflight of the airplane which resulted in fuel exhaustion. Factors associated with the accident were the loose fuel cap and the snow covered terrain.NTSB DEN00LA059Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Rifle, COLoss of engine power for undetermined reasons. A factor was unsuitable terrain on which to make a forced landing.NTSB CHI00LA031Accident · No injuriesLimited investigationFinal reportCessna 182 · Shelbyville, INthe inadequate preflight planning by the pilot and the exhaustion of usable fuel. A factor was the drainage ditch encountered on landing.NTSB ATL99LA128Accident · No injuriesLimited investigationFinal reportCessna 182P · Collegedale, TNThe pilot's failure to secure the fuel cap which resulted in fuel exhaustion and the loss of engine power. A factor was the collision with a fence post.NTSB FTW99LA229Accident · Serious injuriesLimited investigationFinal reportCessna 182B · Houston, TXThe loss of engine power as a result of fuel starvation due to the pilot's improper fuel management.NTSB DEN99LA164Accident · No injuriesLimited investigationFinal reportCessna 180 · Columbus, NMFuel exhaustion because the pilot issued instructions that the fuel tanks not be filled to capacity. A factor was the unsuitable terrain on which to make a forced landing.NTSB CHI99FA252Accident · Minor injuriesField investigationFinal reportCessna 182D · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations and the subsequent fuel exhaustion. Factors associated with the accident were the crops and the soft field conditions.NTSB CHI99LA180Accident · No injuriesLimited investigationFinal reportCessna 182D · Zurich, KSthe pilot's inadequate preflight planning/preparation. A factor was fuel exhaustion.NTSB ANC99LA033Accident · No injuriesLimited investigationFinal reportCessna 180G · Fairbanks, AKWater contamination of the fuel supply, and the pilot's inadequate preflight inspection to ensure all water was removed from the fuel supply. Factors in the accident were a wrinkle in the wing fuel tank bladder, and snow covered terrain.NTSB CHI99LA084Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Lincoln, NEthe pilot's failure to perform an aircraft preflight which resulted in him selecting a fuel tank which had insufficient fuel for the flight and the subsequent fuel starvation.NTSB CHI99LA050Accident · No injuriesLimited investigationFinal reportCessna 310 · Ashland, NEthe pilot's not refueling the airplane to avoid fuel exhaustion, and his inadequate preflight planning. A factor was fuel exhaustion.NTSB FTW99LA014Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Farmerville, LAThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight. Factors were the pilot's failure to verify the refueling of the airplane and the lack of suitable terrain for the forced landing.NTSB ATL98LA113Accident · Minor injuriesLimited investigationFinal reportCessna 305 · Lantana, FLThe pilot's inadequate preflight inspection of the fuel system that resulted in the loss of engine power due to water contamination. A factor was the rough terrain on the departure end of the runway.NTSB LAX98LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · California City, CAThe pilot's failure to assure that an adequate supply of fuel was available for the flight and his inadequate preflight planning/preparation.NTSB FTW98LA300Accident · No injuriesLimited investigationFinal reportBeech H35 · Marshall, TXThe loss of engine power due to fuel starvation as a result of the improper position of the fuel selector. A factor was the pilot's lack of experience in this make and model of airplane.NTSB FTW98LA177Accident · Minor injuriesLimited investigationFinal reportCessna 182E · Las Cruces, NMthe pilot's improper use of (or failure to use) carburetor heat, which resulted in carburetor ice, loss of engine power, and a forced landing. Related factors were: the carburetor icing (weather) conditions, and the lack of suitable terrain for a forced…NTSB LAX98LA109Accident · No injuriesLimited investigationFinal reportCessna 182 · Santa Rosa, CAThe loss of engine power for undetermined reasons.NTSB LAX98LA107Accident · No injuriesLimited investigationFinal reportCessna 182 · Pioche, NVThe total loss of engine power due to carburetor icing. An additional factor in this accident was the pilot's decision to make the flight under known icing conditions.NTSB FTW98LA115Accident · No injuriesLimited investigationFinal reportCessna 182E · Steamboat Sprng, COThe total nonmechanical power loss due to the formation of carburetor ice. A factor was the deep snow covered field on which the forced landing was made.NTSB LAX97LA316Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Madera, CAfuel exhaustion due to the pilot's failure to compute the fuel required and the fuel available. The pilot's decision to extend his downwind beyond gliding distance of the runway after entering the traffic pattern was a factor in this accident.NTSB CHI97LA215Accident · No injuriesLimited investigationFinal reportCessna 182 · Chippewa Falls, WIthe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.NTSB LAX97LA190Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Lamont, CAthe pilot's failure to maintain adequate fuel for the flight.NTSB LAX97LA184Accident · No injuriesLimited investigationFinal reportCessna 182G · Corona, CAfuel exhaustion due to the pilot's failure to perform either preflight or en route fuel consumption calculations. The pilot's decision to fly the aircraft without the required pilot's operating handbook (POH) on board was a factor in this accident.NTSB LAX97LA080Accident · No injuriesLimited investigationFinal reportCessna 182P · Fullerton, CAFuel system water contamination due to the failure of both pilots to purge all water from the fuel system prior to departure. Contributing factors were: failure of the mechanic conducting the recent annual inspection to identify and replace a deteriorated…NTSB ANC97TA016Accident · No injuriesFinal reportCessna 180 · St Mary'S, AKthe pilot's improper use of carburetor heat, and subsequent loss of engine power. Factors associated with the accident were the presence of ice crystals in the atmosphere, and unsuitable terrain for a forced landing.NTSB MIA97LA024Accident · No injuriesLimited investigationFinal reportCessna 182C · Anderson, SCthe pilot's improper preflight, resulting in the fuel cap(s) not being secured; and subsequent siphoning and loss of fuel, which resulted in loss of engine power, a forced landing, and subsequent collision with a ditch during the emergency landing.NTSB SEA97LA017Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pocatello, IDinadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Soft terrain at the emergency landing site was a related factor.NTSB CHI96LA331Accident · No injuriesLimited investigationFinal reportCessna 182 · Eden Prairie, MNthe pilot's misjudging the fuel supply and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.NTSB LAX96LA322Accident · Minor injuriesLimited investigationFinal reportCessna 305A · San Diego, CAFuel exhaustion due to the pilot's improper preflight planning, and an inadequate fuel supply.NTSB ANC96LA134Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Port Alsworth, AKThe fuel starvation caused by the unporting of the right fuel tank, and the pilot's inadequate preflight by not dipping the fuel tank to ensure sufficient fuel quantity to prevent the unporting.NTSB LAX96LA303Accident · No injuriesLimited investigationFinal reportCessna 182B · Santa Ana, CAImproper fuel management by the pilot resulting in exhaustion of the aircraft's fuel supply.NTSB CHI96LA267Accident · No injuriesLimited investigationFinal reportYakovlev YAK-3UA · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.NTSB LAX96LA241Accident · No injuriesLimited investigationFinal reportCessna 182 · Mendota, CAThe pilot's decision to intentionally shut down the engine; his failure to verify the surface winds during the prolonged orbiting descent over the airport, which resulted in a final approach with a tailwind component; and his misjudging of the aircraft's…NTSB ANC96LA043Accident · No injuriesLimited investigationFinal reportCessna 180 · Big Lake, AKfuel starvation due to unporting of the fuel tank inlet, and the pilot's use of a steep, nose-low attitude during descent on the approach to land. The low level of fuel remaining was a related factor.NTSB FTW96LA122Accident · No injuriesLimited investigationFinal reportCessna 182P · New Orleans, LAThe pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.NTSB FTW96LA017Accident · No injuriesLimited investigationFinal reportCessna 182A · Norman, OKthe pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.NTSB CHI96FA002Accident · 2 fatalField investigationFinal reportBeech H35 · Ozark, MOthe pilot's improper fuel management which resulted in fuel starvation, and his failure to maintain airspeed during the forced landing.NTSB CHI95LA319Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Yale, MIloss of engine power due to an inadequate fuel supply leading to fuel exhaustion. The inadvertent stall during the forced landing was a factor.NTSB FTW95LA302Accident · No injuriesLimited investigationFinal reportCessna 182L · Oklahoma City, OKFuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for a forced landing.NTSB SEA95LA081Accident · No injuriesLimited investigationFinal reportCessna 180D · Nyssa, ORFuel exhaustion due to the pilot's failure to refuel en route.NTSB CHI95LA100Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Bowling Green, MOThe pilot misjudged the fuel supply.NTSB FTW94LA309Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Denton, TXThe fuel starvation induced power loss due to the pilot's failure to maintain an adequate amount of fuel. Factors which contributed were: the lack of suitable terrain for the forced landing, and the pilot's evasive maneuver.NTSB SEA94LA236Accident · No injuriesLimited investigationFinal reportCessna 182 · Circle, MTThe failure of the pilot-in-command (CFI) to perform an adequate preflight inspection of the airplane, including the proper securing of the fuel cap. The pilot's failure to divert to the nearest airport after recognizing excessive fuel consumption was a…NTSB CHI94LA306Accident · No injuriesLimited investigationFinal reportCessna 182 · Indianapolis, INthe pilot's improper use of the mixture control, the poorly planned approach and the inadvertent stall.NTSB ATL94LA143Accident · No injuriesLimited investigationFinal reportCessna 182F · Raeford, NCAn engine power loss due to water in the fuel system, and the pilot's inadequate preflight of the aircraft. A factor was the presence of trees at the forced landing area.