NTSB investigations: Lycoming O&VO-360 series, WI
8 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 per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2005 | 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\" = 'WI' 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 ('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."eventStateOrRegion" = 'WI' 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 ('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 CHI05FA180Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Lake Michigan, WIThe pilot's inaccurate preflight planning and his delayed en route decision to make a fuel stop, which resulted in the loss of engine power due to fuel exhaustion and subsequent ditching.NTSB CHI96LA346Accident · No injuriesLimited investigationFinal reportBeech B23 · Viroqua, WIthe pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.NTSB CHI94LA101Accident · No injuriesLimited investigationFinal reportMooney M20C · Richland Center, WIimproper use of carburetor heat. Factors related to the accident were carburetor icing conditions, and the sign and fence poles.NTSB CHI93LA367Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Crivitz, WIfuel starvation caused by foreign matter in the fuel tank strainer.NTSB CHI93LA055Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · West Bend, WITotal loss of engine power due to the failure of the pilot to select the fuel tank with the most fuel.NTSB CHI86FEP04Accident · No injuriesFinal reportDay Skybolt DB · Wisconsin Rapid, WIThe plt thought he had sufficient fuel for a 'short trip around the pattern.' However, shortly after taking off from rwy 29, the eng began to lose power. The plt attempted to land on rwy 2, but all power was lost & he was unable to reach the rwy. He landed…NTSB CHI85FA325Accident · No injuriesField investigationFinal reportPiper PA-28-181 · Eureka, WIPrior to takeoff the pilot calculated that with 48 gallons of fuel he could make the four hour flight to oshkosh with one hour of fuel to spare. Upon arriving at a point 25 mi sw of oshkosh he received a request to descend 1200 ft, a request to climb 1200 ft…NTSB CHI83LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Rice Lake, WIThe acft hit a ditch and nosed over during a forced landing after the engine quit. The plt was on a cross country and had landed enroute 3 times without refueling. With the assistance of eau claire fss he overflew Rice Lake arpt but could not find it. The…