NTSB investigations: Lycoming O&VO-360 series, 2003
7 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Loss of engine power”. 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 | 4 |
|---|---|
| 1983 | 4 |
| 1984 | 4 |
| 1985 | 1 |
| 1986 | 5 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 4 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 5 |
| 1997 | 4 |
| 1998 | 2 |
| 1999 | 3 |
| 2000 | 4 |
| 2001 | 9 |
| 2002 | 5 |
| 2003 | 7 |
| 2004 | 8 |
| 2005 | 4 |
| 2006 | 5 |
| 2007 | 5 |
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\" = 350))
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" = 350))
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 LAX04LA073Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Temecula, CAa loss of engine power for undetermined reasons.NTSB SEA04FA003Accident · 2 fatalField investigationFinal reportCessna 177B · Chinook, MTThe total loss of engine power in cruise flight due to the separation of the carburetor from its mounting bolts, and the pilot's failure to adequately compensate for strong crosswinds while attempting the subsequent forced landing. Additional factors include…NTSB NYC03LA172Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Leonardtown, MDA loss of engine power due to water contamination of the fuel. A factor was the fuel cap not being secured to the tank.NTSB CHI03LA213Accident · 1 fatalLimited investigationFinal reportAllenberg Swick BC 12-D · Winsted, MNThe inadequate aircraft preflight by both pilots of the closed main fuel valve which led to fuel starvation of the engine. Additional causes were the lack of recent experience in the accident airplane and the inadvertent stall by both pilots after a loss of…NTSB CHI03LA187Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Winamac, INA loss of engine power due to the improper installation of the crankshaft gear due to the omission of the retaining bolt and subsequent shear failure of the anti-rotation pin. The unsuitable terrain encountered, and the rough field were factors.NTSB FTW03LA113Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Bonham, TXThe loss of engine power due to fuel starvation as result of the unapproved fuel selector valve handle installed on the aircraft by an unknown person. A contributing factor was the lack of suitable terrain for the forced landing.NTSB NYC03LA056Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Blue Bell, PAThe pilot's failure to maintain directional control after a loss of engine power for undetermined reasons.