NTSB investigations: Lycoming 0-235 series, FL
29 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 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1990 | 5 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1996 | 1 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 1 |
Where
Open the mapLatest 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\" = 'FL' 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" = 'FL' 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 MIA04CA001Accident · Minor injuriesData collectionFinal reportAmerican General AA-1 · Bartow, FLA loss of engine power due to oil starvation. Also causal was the pilot's improper maintenance.NTSB MIA00LA078Accident · No injuriesLimited investigationFinal reportCessna 152 · Kissimmee, FLThe failure of the pilot to obtain winds aloft for the planned cross country flight with a preflight weather briefing and inadequate fuel consumption calculations performed by the pilot resulting in the 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 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 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 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 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 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 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 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 MIA93LA138Accident · No injuriesLimited investigationFinal reportCessna 152 · Sarasota, FLPilot in command's failure to ensure the aircraft contained enough fuel to complete the flight resulting in the engine failing due to fuel exhaustion.NTSB MIA92LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Bradenton, FLThe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB MIA92FA110Accident · 1 fatalField investigationFinal reportCessna 152 · Bushnell, FLThe pilot-in-command's failure to maintain airspeed (vso) while maneuvering during a forced landing. This resulted in an inadvertent stall, in flight loss of control, and collision with terrain. Contributing to the accident was the pilot-in-command's failure…NTSB MIA91LA090Accident · No injuriesLimited investigationFinal reportCessna 152 · Jensen Beach, FLImproper in-flight planning decision by the pilot resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident were the unreliable fuel quantity indicators.NTSB MIA91LA049Accident · No injuriesLimited investigationFinal reportCessna 152 · Deland, FLFailure of the instructor pilot to utilize carburetor heat in icing conditions.NTSB MIA91LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Palmetto, FLPoor preflight planning by the pilot due to his failure to purchase fuel before departure resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the inaccurate fuel gauges.NTSB MIA91LA013Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Miami, FLInadequate preflight of the airplane by the pilot-in-command.NTSB MIA90FA106Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Marco Island, FLFuel exhaustion due to improper planning & decision by the pilot, and an inadvertent stall/spin while maneuvering for a forced landing.NTSB MIA90LA093Accident · No injuriesLimited investigationFinal reportCessna 152 · Mims, FLPilot's poor inflight monitoring of the a/c fuel state which resulted in fuel exhaustion and subsequent engine failure.NTSB MIA88LA215Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe plt stated that while inbound to Vero Beach, he ran out of fuel in the left tank. The engine quit, and he was unable to restart the engine before he crashed into a grove of trees.NTSB MIA88LA211Accident · No injuriesLimited investigationFinal reportCessna 152 · Marathon, FLThe student plt was on his 1st solo x-c flt. A portion of the flt included a 30 mi stretch over the Florida bay section of the gulf of Mexico. The flt carried no flotation gear. 5.2 hrs into the flt, the eng quit & a ditching was performed near a pleasure…NTSB MIA88LA155Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Mcdavid, FLThe plt stated that the flt was 15 miles from the destination & had been diverted due to haze. While flying at an alt of aprox 2,000 ft, the eng quit due to non-mechanical reasons. He was unable to restart it. The plt landed the a/c on a road, during which…NTSB MIA88LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Tallahassee, FLEn route to the destination during a cross country flt, the acft was diverted to an alternate arpt due to weather conditions below minimums. Unable to land at the alternate due to poor visibility the non-instrument rated plt requested vectors to the…NTSB MIA87LA139Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Melbourne, FLThe student pilot experienced an engine failure in flight and landed the aircraft in a pasture. He then restarted the engine and took off, after take off the engine failed two times and he restarted it. The engine failed the third time and he could not start…NTSB MIA86LA253Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Deltona, FLThe pilot stated that while in cruise flight the engine failed and he executed a forced landing to a lake and ditched the aircraft. The aircraft was recovered and examination of the power plant and systems failed to reveal any malfunction/failure that would…NTSB MIA85LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Miramar, FLAn interruption of pwr was experienced as an abrupt steep dive maneuver was entered to release the banner towed by the acft. The plt then attempted a 180 deg turn at an alt of aprx 200 ft AGL to avoid pwr lines. The acft entered a high descent rate and…NTSB MIA84LA023Accident · No injuriesLimited investigationFinal reportCessna C-152 · Miami, FLWhile cruising at 800 ft MSL the plt statd that the eng sputtered and lost all pwr as he opened the throttle. During the ensuing forced landing the plt veered to the left because of a bldg located at the end of the field. The acft collided with trees. An eng…NTSB MIA83LA232Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Quincy, FLWhile turning fm downwind to base the eng ran rough and quit. The acft stalled at 50 ft and came to rest in a soybean field. Examination of the wreckage revealed no evidence of fuel in the eng or the rt tk with the fuel selector positioned to the rt tk.NTSB MIA83LA080Accident · No injuriesLimited investigationFinal reportCessna C-152 · Yeehaw Junction, FLAccording to the student pilot the aircraft was fueled to maximum capacity prior to departure on a cross country flight. Approximately 3.2 hours later the engine quit and the pilot was forced to make an emergency landing in a wooded area. Subsequent engine…