NTSB investigations: Lycoming O&VO-360 series, 2000
9 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\") = 2000
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") = 2000
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 LAX00LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Prescott, AZAn improper engine installation by other maintenance personnel that resulted in a fuel leak at the main fuel line fitting to the carburetor and subsequent fuel exhaustion during cruise flight.NTSB CHI00LA272Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Plattsmouth, NEthe pilot's improper preflight planning, improper in-flight planning and decision not to land before exhausting the airplane's fuel. Factors relating to this accident were the power lines, the roadway, and the ditch.NTSB NYC00FA240Accident · Serious injuriesField investigationFinal reportPiper PA-44-180 · Lake Hopatcong, NJThe flight instructor's improper placement of both fuel-selector switches, which resulted in a total loss of engine power on both engines.NTSB DEN00LA137Accident · No injuriesLimited investigationFinal reportMooney M20C · Longmont, COThe pilot's improper fuel tank selector position resulting in fuel starvation and the ditch impacted during the landing roll. A contributing factor was the pilot's failure to follow published procedures and directives.NTSB LAX00LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Maria, CAThe pilot's failure to ensure that an adequate fuel supply was on board at last departure, which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane at the en route stop was also causal.NTSB LAX00LA222Accident · No injuriesLimited investigationFinal reportMooney M20D · Baker, CAThe fuel flow became restricted by remnants of fuel tank sealant that had accumulated in the fuel selector screen. Contributing to the pilot's inability to restart the engine in flight was the empty fuel tank in the left wing and the fuel gauge indication.…NTSB LAX00LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Marana, AZthe pilot's failure to refuel the airplane as required by the airplane's published flight manual resulting in a loss of engine power due to fuel starvation.NTSB NYC00LA117Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Middletown, RIan inadequate preflight inspection by the pilot which did not detect the water in the fuel tanks prior to departure.NTSB MIA00LA082Accident · Minor injuriesLimited investigationFinal reportMooney M-20C · Andrews, NCThe pilot's failure to use carburetor heat in a timely manner while maneuvering in conditions conducive to carburetor icing, resulting in the loss of engine power and collision with trees during the subsequent emergency descent.