NTSB investigations: Lycoming O&VO-360 series, 1990
10 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\") = 1990
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") = 1990
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 MIA91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Inverness, MSThe student pilot's failure to refuel the airplane. Factors were: uel exhaustion, the pilot's lack of total aeronautical experience, and soft terrain.NTSB MIA91LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Orlando, FLInadequate planning by the pilot.NTSB CHI90LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fridley, MNEngine failure due to fuel exhaustion because of fuel consumption calculations mis-judged by the pilot in command. Contributing factors were unsuitable terrain and a railroad sign.NTSB DEN90LA167Accident · No injuriesLimited investigationFinal reportMooney M20C · Roswell, NMThe intentional wheels up landing in soft terrain. Contributing to the accident was the fuel starvation induced power loss, failure of the pilot to switch fuel tanks, improper positioning of the fuel selector during attempted restarts, and the soft terrain.NTSB ATL90LA106Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Cartersville, GAThe pilot's improper use of the engine fuel mixture control which resulted in fuel exhaustion.NTSB MKC90LA097Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Little Rock, ARPilot in command's failure to refuel the airplane, which resulted in fuel exhaustion. Related to the accident was: unsuitable terrain in the emergency landing area.NTSB MIA90FA107Accident · 3 fatalField investigationFinal reportCessna 177B · North Captiva, FLInadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall.NTSB CHI90LA079Accident · No injuriesLimited investigationFinal reportCessna 177B · Raleigh, ILInadequate preflight by the pilot and fuel exhaustion due to an inadequate supply of fuel. The unreliable fuel quantity gauge was a related factor.NTSB ATL90LA057Accident · No injuriesLimited investigationFinal reportMooney M20A · Parris Island, SCThe failure of the pilot to insure that sufficient fuel was aboard for the flight, resulting in fuel exhaustion.NTSB FTW90LA054Accident · No injuriesLimited investigationFinal reportAero Commander 100-180 · Bastrop, LALoss of engine power due to water contamination in the fuel. A factor related to the accident was: inadequate design of the fuel system drains, which prevented an adequate preflight of the fuel system.