NTSB investigations: Lycoming 0-235 series, CA
32 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 per year
| 1983 | 5 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 2 |
| 1989 | 3 |
| 1990 | 2 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 4 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
Where
Latest cases
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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
AND 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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
AND 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 LAX06CA079Accident · No injuriesData collectionFinal reportCessna 152 · Rancho Murieta, CAfuel contamination (water) due to the inadequate preflight by both pilots, which failed to detect the residual water contamination in fuel system. A factor in the accident was the soft terrain condition at the forced landing site.NTSB LAX05LA158Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · San Luis Obispo, CAa loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.NTSB LAX04CA181Accident · No injuriesData collectionFinal reportPiper PA-38-112 · McKinleyville, CAa loss of engine power due fuel exhaustion, which was caused by the pilot's inadequate in-flight planning/decision, inadequate in-flight fuel consumption calculations, and failure to divert to an alternate airport before the fuel situation became critical.…NTSB LAX03LA132Accident · Minor injuriesLimited investigationFinal reportDeer/Reffalt BD · Greenfield, CAThe loss of engine power during cruise flight for undetermined reasons.NTSB LAX01LA263Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Pacoima, CAthe pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion and loss of engine power while on approach for landing.NTSB LAX00LA307Accident · No injuriesLimited investigationFinal reportHickey SE5-A · San Bernardino, CAthe pilot's inadequate preflight inspection, and his failure to verify adequate fuel for the planned flight, which resulted in a loss of engine power with no suitable forced landing site.NTSB LAX00LA225Accident · No injuriesLimited investigationFinal reportCessna 152 · Lodi, CAThe pilot's inaccurate fuel consumption calculations, his misjudged in-flight planning, and his failure to flare during the landing attempt. A factor was the pilot's improper preflight inspection when he refueled the airplane.NTSB LAX00LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Fresno, CAFuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.NTSB LAX00LA083Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilot's misinterpretation of his VOR navigation indicator, which subsequently led to his becoming lost and disoriented while navigating to an alternate airport and resulted in fuel exhaustion. The pilot's failure to obtain either a preflight weather…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 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 LAX95LA007Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Atherton, CAthe pilot's inadequate fuel consumption calculations and failure to refuel the aircraft while en route.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 LAX93LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Camarillo, CAFuel exhaustion due to the inadequate preflight fuel consumption planning, the inadequate en route fuel consumption calculations, and the failure of the pilot to stop en route for fuel.NTSB LAX92LA324Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Porterville, CAFuel exhaustion due to the student pilot's inadequate preflight and inflight planning, and the failure to refuel the aircraft.NTSB LAX91LA262Accident · No injuriesLimited investigationFinal reportCessna 152 · Oceanside, CAFuel exhaustion due to the pilot's improper preflight planning.NTSB LAX91LA240Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Stockton, CAThat the pilot-in-command used poor preflight planning, inflight decision, and fuel consumption calculations. Contributing to this accident was fuel exhaustion.NTSB LAX90LA240Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Hickman, CAThe pilot's improper planning & decision, an inadequate fuel supply, and fuel exhaustion. A contributing factor was related to the false indication of the fuel quantity gages.NTSB LAX90LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Lucerne Valley, CAThe pilot's failure to use carburetor heat and improper emergency procedures. Contributing to the accident was the pilot's lack of total experience.NTSB LAX89LA154Accident · No injuriesLimited investigationFinal reportCessna 152 · Taft, CAThe pilots improper use of carburetor heat in weather conditions which were conducive to the formation of carburetor ice.NTSB LAX89LA128Accident · Minor injuriesLimited investigationFinal reportCessna 152 · San Jose, CAImproper in-flight planning/decision by the pilot and subsequent fuel exhaustion. Contributing factors were: dark night,trees, and the building.NTSB LAX89LA084Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Westlake, CAImproper planning and decision by the pilot which resulted in fuel exhaustion. Contributing factors were: faulty fuel indication, utility pole & uneven terrain.NTSB LAX87LA301Accident · No injuriesLimited investigationFinal reportCessna 152 · Madera, CAAfter the aircraft was flown for 3 hours and 30 minutes the engine failed. The aircraft entered a forced landing approach to an open field. The aircraft landed hard and nosed over onto its back. Ground witnesses who were on scene shortly after the accident…NTSB LAX87LA097Accident · No injuriesLimited investigationFinal reportCessna 152 · Glendora, CADuring a local pleasure flight, the engine lost power and the pilot made a forced landing on a golf course. Visual inspection of the fuel tanks revealed that both tanks were empty and no fuel drained from the sumps. No mechanical failure or malfunction with…NTSB LAX86LA018Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Turlock, CAThe acft made a forced lndg after a loss of power during a descent. The plt stated that the eng RPM decreased to 1100 with all other gauges in the green. He also said he could not get the fuel drain sumpt to drain as it was frozen shut during preflt. The plt…NTSB LAX85LA318Accident · Minor injuriesLimited investigationFinal reportGrumman AA-1B · Paso Robles, CAThe Paso Robles (prb) flight service station air traffic control specialist reptd that the pilot radioed that the aircraft ran out of fuel abt 5 miles so of prb. Examination of the wreckage disclsed both wing fuel tanks contained less that 1 gallon of fuel in…NTSB LAX84LA236Accident · No injuriesLimited investigationFinal reportCessna 152 · Escalon, CAThe acft was damaged during a forced landing. The acft collided with trees and nosed down. Post accident examination of the acft showed 1 gallon of fuel on board the acft. The flt had lasted 3 and 1/3 hours. The endurance of a Cessna 152 under the stated…NTSB LAX84LA086Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fairfield, CAAfter taking off & while climbing thru about 100 to 300 ft, the eng lost power. During a forced landing, the acft impacted a fence & a berm, and went over railroad tracks, then came to rest inverted in a ditch. An exam of the acft revealed corrosion in the…NTSB LAX84FA057Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Inglewood, CAThe student said that the eng lost power & he initiated an emergency landing. He switched fuel tanks, applied carburetor heat & checked the magnetos. However, before landing, the eng restarted & the student applied full power & began to climb, not realizing…NTSB LAX84FA046Accident · No injuriesField investigationFinal reportPiper PA38-112 · Corona, CAThe acft landing gear collapsed during an off rwy but on arpt forced landing. The pilot had just completed the annual inspection and was testing the acft. At 150 ft AGL during takeoff the engine quit. The plt landed on rough terrain ABOUT1/4 mile west of the…NTSB LAX83LA372Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Weaverville, CAThe acft crash landed in mountainous terrain after the engine lost power. At 2040 PDT a mayday call was heard from the accident acft by the redding tower. The acft was advised to squawk code 7700 and to transmit on several other frequencies. No further…NTSB LAX83FA123Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Blythe, CAShortly after takeoff the acft experienced a power loss. During the subsequent forced landing the acft collided with trees. Wreckage examination disclosed no evidence of fuel and the engine operated normally during a functional test conducted 6 days after the…