NTSB investigations: Lycoming O&VO-360 series, 2007
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
| 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
Latest 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\") = 2007
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") = 2007
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 NYC08FA020Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Boynton Beach, FLA total loss of engine power due to fuel starvation as a result of the pilots' improper in-flight fuel management.NTSB NYC08CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Fairview, TNA loss of engine power due to fuel exhaustion.NTSB DFW07CA202Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Taylor, TXThe loss of engine power due to fuel exhaustion as result of the pilot's inadequate in-flight planning/decision. Contributing factors were the lack of suitable terrain for the forced landing and the dark night.NTSB NYC07FA200Accident · Serious injuriesField investigationFinal reportBeech C24R · Niceville, FLThe pilot’s inadequate preflight inspection of the fuel quantity.NTSB LAX07CA232Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Eagle Point, ORFuel exhaustion due to the pilot's inadequate fuel consumption calculations.NTSB LAX07CA151Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Las Vegas, NVfuel starvation due to the pilot's inadequate fuel system management.NTSB ATL07CA055Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Myrtle Beach, SCThe loss of engine power due to undetermined reasons. A factor in the accident was the pilot's failure to follow emergency procedures when he failed to jettison the advertising banner prior to his forced landing in water.NTSB LAX07CA098Accident · No injuriesData collectionFinal reportMooney M20D · Visalia, CAThe pilot's inadequate in-flight fuel system management, which resulted in fuel starvation and a loss of engine power.