NTSB investigations: Lycoming 0-235 series
268 cases on aircraft whose registry engine model is Lycoming 0-235 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 ('41505')
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 ('41505')
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 MIA00LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Bayou La Batre, ALThe pilot's improper preflight fuel planning and the his improper en route fuel consumption calculations resulting in a total loss of engine power due to fuel exhaustion.NTSB MIA00LA001Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe failure of the pilot to ensure the aircraft contained adequate fuel to complete the flight resulting in engine failure due to fuel exhaustion and damage to the aircraft during the subsequent forced landing.NTSB FTW99LA273Accident · No injuriesLimited investigationFinal reportCessna 152 · Slaton, TXThe pilot's failure to refuel the airplane resulting in fuel exhaustion. Factors were the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.NTSB LAX99LA269Accident · No injuriesLimited investigationFinal reportCessna 152 · Buckeye, AZfuel exhaustion due to the pilot's inaccurate fuel consumption calculations used in flight planning.NTSB CHI99LA034Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Carrol, IAthe pilot's inadequate preflight inpection of the fuel tanks and filler neck caps before departure. Factors associated with this accident were the leaking right wing fuel tank filler cap and fuel exhaution.NTSB LAX99LA034Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Orinda, CAA loss of engine power due to water contamination of the fuel. A factor was the pilot's inadequate preflight, during which he neglected to note the contamination, and the dark night which made it difficult to select a landing spot.NTSB MIA99LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Coral Springs, FLThe delay by the pilot to obtain proper assistance after becoming lost/disoriented resulting in total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's lack of total experience.NTSB CHI98LA321Accident · No injuriesLimited investigationFinal reportCessna 152 · Beecher, ILFuel exhaustion due to fuel mismanagement by the pilot-in-command. The rough terrain was a contributing factor.NTSB ATL98LA082Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Boynton Beach, FLThe pilot's inadequate preflight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB FTW98LA132Accident · No injuriesLimited investigationFinal reportCessna 152 · Norman, OKFuel exhaustion due to the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB ATL98LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · Americus, GAthe pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing on unprepared terrain.NTSB FTW98LA125Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Sheridan, WYthe pilot's improper use of carburetor heat, which resulted in loss of engine power due to carburetor ice. Factors relating to the accident were: the carburetor icing (weather) condition, and the lack of a suitable area for an emergency landing.NTSB ATL97LA141Accident · No injuriesLimited investigationFinal reportTomlinson Pober Super ACE · Lebanon, TNThe pilot's failure to follow normal checklist procedures that resulted in fuel starvation.NTSB ATL97LA125Accident · No injuriesLimited investigationFinal reportCessna 152 · West Palm Beach, FLthe flight instructor's (CFI's) inaccurate assessment of fuel available for the flight, and his improper in-flight planning/decision by continuing the training flight with minimal fuel, which resulted in fuel exhaustion and loss of engine power.NTSB LAX97LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gila Bend, AZthe pilot's failure to verify the fuel quantity prior to departure, and his failure to perform sufficient en route fuel consumption calculations during the cross-country flight.NTSB FTW97LA244Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfuel exhaustion, due to the pilot's failure to refuel before taking off on the remainder of the flight after making a precautionary landing. Factors related to the accident were: the pilot becoming lost and disoriented, and the lack of suitable terrain for a…NTSB FTW97LA218Accident · No injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXThe loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.NTSB IAD97LA074Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Lewisburg, WVThe pilot's inadequate preflight, which led to the loss of a fuel cap and subsequent fuel exhaustion.NTSB FTW97FA173Accident · Minor injuriesField investigationFinal reportGowan LONG-EZ · Roanoke, TXThe pilot's failure to maintain the proper descent rate. A factor was the gascolator's filter screen becoming contaminated with fiber glass residue due to the pilot/mechanic's inadequate maintenance.NTSB ATL97LA066Accident · No injuriesLimited investigationFinal reportPiper PA-22-180 · Russellville, ALThe loss of engine power for undetermined reasons. A factor was conditions were favorable for the formation of carburetor ice.NTSB ATL97LA039Accident · No injuriesLimited investigationFinal reportCessna 152 · Gulfport, MSthe pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel.NTSB FTW97LA095Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Boswell, OKThe student pilot's improper inflight planning and decision, after becoming lost/disoriented, which resulted in fuel exhaustion, before landing in a suitable landing area. Factors relating to the accident were: the pilot of another aircraft did not accurately…NTSB MIA97LA064Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Boca Raton, FLInadequate inspection of the fuel caps by company maintenance personnel resulting in a cap with a deteriorated seal being allowed to continue in service. This allowed water to leak into the fuel tank which resulted in loss of engine power due to water…NTSB FTW97LA013Accident · No injuriesLimited investigationFinal reportDickson RV-3A · Rosharon, TXThe pilot's failure to follow procedures and directives in that he did not use carburetor heat and he did not periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the transmission wire.NTSB MIA96LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-108 · Pensacola, FLloss of engine power during the initial climb due to contamination in the carburetor. Trees in the emergency landing area were a related factor.NTSB ANC96LA157Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKthe pilot's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion. A factor associated with the accident was: the erroneous (false) indication of the fuel sight tubes.NTSB NYC96LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Castine, MEthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Factors relating to the accident were: false indication from the fuel quantity gauge, and soft terrain in the emergency…NTSB MIA96LA188Accident · No injuriesLimited investigationFinal reportCessna 152 · Troy, ALfuel contamination, which resulted in loss of engine power, a forced landing, and impact with trees. A factor relating to the accident was: inadequate maintenance and/or inspection after the previous loss of engine power and forced landing.NTSB ATL96LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Gatesville, NCThe pilot's inadequate preflight inspection which resulted in engine stoppage due to water contamination in the fuel system. A factor was the lack of suitable terrain for a forced landing.NTSB NYC96LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Groton, NYthe pilot's inadequate fuel management, and his improper use of the fuel selector valve, which resulted in fuel starvation and the subsequent collision with bails of hay during the forced landing.NTSB LAX96LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Carlsbad, CAinadequate preflight by the pilot, and subsequent fuel exhaustion, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related factors.NTSB ATL96LA062Accident · No injuriesLimited investigationFinal reportCessna 152U · Rincon, GAInaccurate fuel consumption calculations by the pilot, and an inadequate supply of fuel, which resulted in fuel exhaustion and subsequent nose over of the airplane, during a forced landing on uneven terrain with high vegetation (small trees).NTSB FTW96LA105Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Falfurrias, TXfuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.NTSB MIA96LA040Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Macon, GAThe pilot-in-command's failure to assure an adequate amount of fuel was available for the flight.NTSB SEA96LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Chimacum, WAthe pilot-in-command's delayed application of carburetor heat which resulted in a power loss due to carburetor ice. Carburetor icing conditions, a short takeoff area, and a ditch at the end of the airstrip were factors.NTSB FTW95LA262Accident · No injuriesLimited investigationFinal reportBeech 77 · Mcallen, TXThe dual student's failure to properly operate the throttle and the inadequate supervision by the flight instructor. A factor was the lack of suitable terrain for the forced landing.NTSB MIA95LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Laurel, MSThe failure of the pilot-in-command to refuel the aircraft resulting in loss of engine power due to fuel exhaustion.NTSB NYC95LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · North Bergen, NJThe pilot's inadequate in-flight planning which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB ATL95FA022Accident · 2 fatalField investigationFinal reportAmerican AA-1A · Gastonia, NCThe pilot's failure to adequately plan the fuel requirements for the flight, which resulted in fuel exhaustion, and the subsequent loss of engine power. The pilot also failed to maintain flying airspeed which resulted in a loss of control, during the…NTSB LAX95LA007Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Atherton, CAthe pilot's inadequate fuel consumption calculations and failure to refuel the aircraft while en route.NTSB MIA94LA211Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe failure of the pilot-in-command to calculate fuel consumption correctly resulting in loss of engine power due to fuel exhaustion.NTSB MIA94LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aguadilla, PRThe failure of the pilot-in-command to divert and refuel resulting in loss of engine power due to fuel exhaustion.NTSB NYC94LA142Accident · Minor injuriesLimited investigationFinal reportArthur Chase EAA Biplane · North Canaan, CTThe pilot's inadequate preflight inspection that failed to detect water contaminated fuel and which resulted in a loss of engine power. The inadequately designed fuel drain system was also a cause.NTSB CHI94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Springfield, MOThe pilot's failure to refuel prior to fuel exhaustion. The lack of suitable terrain available for the forced landing is a related factor.NTSB ANC94LA057Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Kenai, AKFuel exhaustion as a result of the student pilot-in-command's failure to refuel. The lack of suitable terrain for a forced landing was a factor.NTSB MIA94LA071Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Port St. Lucie, FLThe failure of the pilot-in-command to properly preflight the airplane and ensure there was adequate fuel on board, and his improper in-flight planning/decision to continue the flight.NTSB LAX94LA121Accident · No injuriesLimited investigationFinal reportGrumman AA-1A · Bishop, CAfuel exhaustion due to the pilot's inadequate preflight planning and en route fuel consumption monitoring.NTSB ATL94LA032Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edisto Island, SCFailure of the pilot to use carburetor heat, while maneuvering and changing altitudes, which resulted in carburetor ice. A factor related to the accident was that weather conditions were favorable for the formation of carburetor ice.NTSB CHI94LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Jackson, MOthe failure of the pilot to refuel prior to fuel exhaustion.NTSB CHI94LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Arcadia, WIthe loss of engine power for an undetermined reason(s).