NTSB investigations: Lycoming O&VO-360 series, 2003
12 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
| 1982 | 10 |
|---|---|
| 1983 | 11 |
| 1984 | 8 |
| 1985 | 14 |
| 1986 | 8 |
| 1987 | 6 |
| 1988 | 9 |
| 1989 | 9 |
| 1990 | 10 |
| 1991 | 9 |
| 1992 | 8 |
| 1993 | 15 |
| 1994 | 9 |
| 1995 | 9 |
| 1996 | 11 |
| 1997 | 9 |
| 1998 | 13 |
| 1999 | 9 |
| 2000 | 9 |
| 2001 | 5 |
| 2002 | 7 |
| 2003 | 12 |
| 2004 | 4 |
| 2005 | 19 |
| 2006 | 6 |
| 2007 | 8 |
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 year(c.\"eventDate\") = 2003
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 year(c."eventDate") = 2003
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 LAX04LA038Accident · 1 fatalLimited investigationFinal reportCathaway RV-6A · Saticoy, CAA loss of engine power due to fuel exhaustion as a result of a loose B-nut fitting for the carburetor fuel inlet line, which allowed fuel to leak out.NTSB LAX04LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · San Rafael, CAa loss of engine power due to fuel exhaustion.NTSB ATL03LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Talladega, ALThe pilot's failure to use carburetor heat when weather conditions were favorable for carburetor icing.NTSB NYC03CA156Accident · Minor injuriesData collectionFinal reportMooney M20C · Utica, OHThe pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A factor was the unsuitable terrain.NTSB SEA03FA121Accident · 1 fatalField investigationFinal reportLamb RV-4 · Vail, WAA loss of engine power due to the pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing factors were the non-operating (vandalized) runway lights, the pilot's delayed departure to his…NTSB MIA03LA112Accident · No injuriesLimited investigationFinal reportBeech C23 · Ormond Beach, FLThe pilot's inadequate preflight and his failure to refuel the airplane before departure resulting in the total loss of engine power due to fuel exhaustion and a hard landing during the subsequent forced landing.NTSB NYC03LA098Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Ava, NYThe pilot's inadequate preflight which did not detect the contamination in the fuel, and subsequent power loss due to contaminated fuel while operating over unsuitable terrain.NTSB SEA03LA075Accident · Minor injuriesLimited investigationFinal reportDeJager RV-6 · Bellingham, WAThe pilot's inadequate in flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power.NTSB LAX03LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Santa Maria, CAThe pilot's inadequate in-flight planning/decision resulting in fuel exhaustion which resulted in a total loss of engine power during cruise flight, and a subsequent on-ground collision with a pole and a fence during the ensuing emergency landing.NTSB DEN03LA055Accident · No injuriesLimited investigationFinal reportMohr Starduster Too · Espanola, NMthe pilot's improper inflight planning in that he failed to consult the airplane flight manual, his use of incorrect fuel consumption figures, and fuel exhaustion. Contributing factors were the loss of the en route chart, the unavailability of a nav/comm…NTSB FTW03LA110Accident · No injuriesLimited investigationFinal reportCessna 177A · England, ARThe pilot's failure to refuel the airplane while searching for a private grass airstrip, which resulted in fuel exhaustion. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DEN03LA042Accident · No injuriesLimited investigationFinal reportBeech C23 · Pagosa Springs, COthe pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. Contributing factors were the student pilot's improper flare, the instructor's inadequate remedial actions, and terrain conditions.