NTSB investigations: Lycoming O&VO-360 series
247 cases on aircraft whose registry engine model is Lycoming O&VO-360 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 ('41514')
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 ('41514')
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 DEN03LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Vernal, UTthe pilot's improper in-flight planning/decision. Factors contributing to the accident were fuel exhaustion and the fog.NTSB DEN03LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Salt Lake City, UTfuel exhaustion as a result of the pilot's inadequate preflight planning. A contributing factor was the pilot's decision to continue the flight without stopping for fuel.NTSB DEN03LA006Accident · No injuriesLimited investigationFinal reportMooney M20B · Loa, UTthe pilot's inadvertent placement of the fuel selector position in the off position. A contributing factor was the pilot's lack of familiarity with the aircraft.NTSB MIA02FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cheraw, SCThe misrouting of the fuel lines to the fuel selector, which resulted in the use of a fuel tank with inadequate fuel supply, fuel starvation, and the loss of engine power. Contributing was the pilot's inadequate remedial action for conducting an emergency…NTSB DEN02LA033Accident · Serious injuriesLimited investigationFinal reportCessna 172Q · Fruitland, UTthe pilot's failure to apply carburetor heat. Contributing factors included carburetor icing conditions, the unavailability of suitable terrain on which to make a forced landing, and night conditions.NTSB LAX02LA107Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Santa Clarita, CAThe pilot performed inadequate planning and inaccurate fuel computations, and intiated flight without refueling. This resulted in a forced landing on a road at night due to fuel exhaustion.NTSB MIA02LA020Accident · No injuriesLimited investigationFinal reportMooney M20C · High Springs, FLThe pilot's improper preflight planning/preparation and failure to ensure sufficient fuel was available to complete the flight, which resulted in fuel exhaustion, a forced landing, and damage to the aircraft when it collided with a fence during the landing…NTSB MIA01LA128Accident · No injuriesLimited investigationFinal reportSteen Aero Lab Skybolt I · Germantown, TNThe pilot's failure to conduct proper preflight planning and preparation, resulting in fuel exhaustion during cruise flight, and the subsequent emergency descent and forced landing to a residential street colliding with a vehicle, utility pole, mail box, and…NTSB CHI01LA115Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-180AC · Buffalo, MNthe water contamination of the aircraft's fuel system and the inadequate preflight performed by the pilot. The muddy terrain was a contributing factor.NTSB SEA01LA066Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Gresham, ORThe pilot's inadequate decision in which he failed to refuel while en route, resulting in fuel exhaustion and loss of engine power.NTSB LAX01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAFuel starvation due to the pilot inadvertently shutting off its supply on approach for landing.NTSB LAX00LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Prescott, AZAn improper engine installation by other maintenance personnel that resulted in a fuel leak at the main fuel line fitting to the carburetor and subsequent fuel exhaustion during cruise flight.NTSB CHI00LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Plattsmouth, NEthe pilot's improper preflight planning, improper in-flight planning and decision not to land before exhausting the airplane's fuel. Factors relating to this accident were the power lines, the roadway, and the ditch.NTSB NYC00FA240Accident · Serious injuriesField investigationFinal reportPiper PA-44-180 · Lake Hopatcong, NJThe flight instructor's improper placement of both fuel-selector switches, which resulted in a total loss of engine power on both engines.NTSB DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.NTSB LAX00LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Maria, CAThe pilot's failure to ensure that an adequate fuel supply was on board at last departure, which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane at the en route stop was also causal.NTSB LAX00LA222Accident · No injuriesLimited investigationFinal reportMooney M20D · Baker, CAThe fuel flow became restricted by remnants of fuel tank sealant that had accumulated in the fuel selector screen. Contributing to the pilot's inability to restart the engine in flight was the empty fuel tank in the left wing and the fuel gauge indication.…NTSB LAX00LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Marana, AZthe pilot's failure to refuel the airplane as required by the airplane's published flight manual resulting in a loss of engine power due to fuel starvation.NTSB NYC00LA117Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Middletown, RIan inadequate preflight inspection by the pilot which did not detect the water in the fuel tanks prior to departure.NTSB MIA00LA082Accident · Minor injuriesLimited investigationFinal reportMooney M-20C · Andrews, NCThe pilot's failure to use carburetor heat in a timely manner while maneuvering in conditions conducive to carburetor icing, resulting in the loss of engine power and collision with trees during the subsequent emergency descent.NTSB LAX00LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Palo Alto, CAThe failure of the pilot to properly calculate fuel consumption rate, and his improper in-flight planning to continue the flight to the destination airport instead of landing at a closer alternate airport. A factor was the pilot's inadequate aircraft control…NTSB NYC00LA037Accident · No injuriesLimited investigationFinal reportBeech C23 · Fincastle, VAThe restricted movement of the fuel selector and the pilot-in-command's failure to verify the fuel selector was in a proper position.NTSB LAX99LA268Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Sacramento, CAFuel exhaustion due to the pilot's failure to ensure that sufficient fuel was on board to complete the flight, and, the flight instructor's inadequate supervision of the flight.NTSB CHI99LA292Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Hudson, MIwas an inadequate preflight and misjudged flare to landing during the autorotation by the pilot. A factor in this accident was a totally blocked fuel tank vent system.NTSB MIA99LA199Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Dunedin, FLThe pilot's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power.NTSB DEN99LA062Accident · No injuriesLimited investigationFinal reportSly RV-6A · Payson, UTThe development of carburetor ice resulting in a loss of engine power, and the inadequate carburetor heat shroud. Factors were the carburetor icing weather conditions, the kit manufacturer's inadequate carburetor heat shroud design, the FAA's inadequate…NTSB IAD99LA035Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Irving, NYwas the pilot's intentional flight into known icing conditions.NTSB IAD99FA034Accident · 2 fatalField investigationFinal reportBeech BE-76 · Dravosburg, PAThe pilot's failure to accurately calculate fuel required for the flight, and his decision not to divert for fuel prior to his intended destination. A factor in the accident was the pilot's over confidence in his ability to operate the airplane with minimal…NTSB ATL99FA045Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Brevard, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion and the subsequent loss of engine power.NTSB MIA99LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Knoxville, TNThe engines excessive fuel consumption for undetermined reasons and the pilot's failure to plan the flight with adequate fuel reserves resulting in engine failure due to fuel exhaustion.NTSB ATL99LA030Accident · No injuriesLimited investigationFinal reportMichael L. Thibault RV-4 · Okeechobee, FLThe pilot's failure to use carburetor heat that resulted in the total loss of engine power. Factors were conditions favorable for the formation of carburetor ice.NTSB CHI99LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mason, MIthe pilot's inattention to fuel management in that he failed to switch fuel tanks in a timely manner which resulted in fuel starvation. A factor related to the accident was the low altitude at which the loss of engine power occurred.NTSB CHI99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Iowa Falls, IAthe pilot's improper preflight planning and preparation, and his not refueling the airplane. Factors were fuel exhaustion and the fence.NTSB FTW99LA010Accident · No injuriesLimited investigationFinal reportMooney M20A · Oklahoma City, OKThe loss of engine power due to fuel starvation as result of the pilot's improper placement of the fuel tank selector switch. A factor was the lack of suitable terrain for the pilot to execute the forced landing.NTSB ATL99LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Spartanburg, SCThe pilot's failure to manage the fuel supply which resulted in fuel starvation to the engine.NTSB FTW99LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Horizon City, TXThe fuel exhaustion due to the pilot's failure to refuel the airplane. Factors were the unfavorable wind condition and the lack of suitable terrain for the forced landing.NTSB LAX98LA284Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oroville, CAthe pilot's inaccurate preflight and in-flight fuel consumption calculations, which resulted in fuel exhaustion. The pilot's failure to obtain the proper engine power setting charts to use in fuel consumption calculations was also causal.NTSB ATL98LA105Accident · Serious injuriesLimited investigationFinal reportMooney M20A · Marathon, FLThe inadequate inspection of the fuel pump during the last engine overhaul, that subsequently resulted in a worn diaphragm, fuel venting overboard, and loss of engine power from fuel exhaustion during a critical phase of flight.NTSB IAD98LA063Accident · No injuriesLimited investigationFinal reportCessna 175 · Pemberton, NJThe pilot's inadequate fuel consumption calculations and his improper in-flight decision to continue flying with an inadequate fuel supply.NTSB CHI98LA104Accident · No injuriesLimited investigationFinal reportMooney M20C · White River, SDthe pilot's delay in applying carburetor heat. A factor associated with the accident was the low altitude at which the pilot was flying which limited his landing site selections when the loss of power occurred.NTSB FTW98LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Monroe, LAThe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA052Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Fayetteville, NCfuel system contamination (rubber shavings), which led to blockage of a fuel line, fuel starvation, loss of engine power, and a collision with terrain.NTSB MIA98LA044Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Everglades City, FLthe pilot's improper fuel management and improper in-flight planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing. Related factors were: the light conditions at dusk, and the lack of suitable terrain for a forced…NTSB LAX98LA035Accident · No injuriesLimited investigationFinal reportBeech C23 · Corona, CAThe loss of engine power for undetermined reasons. A factor was the rough terrain that resulted in a nose over during the landing roll.NTSB FTW98LA042Accident · No injuriesLimited investigationFinal reportMooney M20C · Ozona, TXthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing. A related factor was the lack of suitable terrain for the forced landing.NTSB FTW97LA355Accident · Serious injuriesLimited investigationFinal reportAmerican General AG5B · Texarkana, ARthe pilot's improper planning/decision, by failing to ensure timely refueling of the airplane, which resulted in fuel exhaustion, loss of engine power, and a forced landing.NTSB LAX97LA314Accident · Serious injuriesLimited investigationFinal reportHallam RV-6 · Woodlake, CAfailure of the pilot to accurately determine the quantity of fuel onboard the airplane before flight, and subsequent loss of engine power due to fuel starvation, which resulted in a forced landing.NTSB NYC97LA167Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Brickerville, PAFuel starvation as a result of the pilot performing a takeoff with the fuel selector in the 'OFF' position.NTSB FTW97FA269Accident · 1 fatalField investigationFinal reportMooney M20C · Sarepta, LAThe pilot's impairment (drugs) resulting in his becoming disoriented and the ensuing loss of engine power due to fuel exhaustion. Factors were the lack of suitable terrain for the forced landing and the inaccurate navigation chart.NTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.