NTSB investigations: Lycoming O&VO-360 series, 2007
9 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Loss of control - on ground/water”. 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 | 9 |
|---|---|
| 1983 | 6 |
| 1984 | 9 |
| 1985 | 12 |
| 1986 | 7 |
| 1987 | 11 |
| 1988 | 8 |
| 1989 | 8 |
| 1990 | 8 |
| 1991 | 2 |
| 1992 | 9 |
| 1993 | 9 |
| 1994 | 7 |
| 1995 | 7 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 9 |
| 1999 | 3 |
| 2000 | 7 |
| 2001 | 9 |
| 2002 | 8 |
| 2003 | 9 |
| 2004 | 9 |
| 2005 | 10 |
| 2006 | 9 |
| 2007 | 9 |
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\" = 260))
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" = 260))
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 DEN08CA034Accident · No injuriesData collectionFinal reportGodwin, David P Sorrell SNJ-7 · Belen, NMthe pilot's loss of directional control during landing resulting in a ground loop.NTSB NYC07CA240Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Bridgeport, CTThe pilot's failure to maintain directional control of the airplane during the landing. Contributing was the crosswind weather condition.NTSB DFW07CA213Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Tunica, MSThe pilot's failure to compensate for the existing wind conditions during a crosswind landing. A factor was the crosswind.NTSB CHI07CA236Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Berryville, ARThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane departing the runway and impacting terrain. A factor in the accident was the dirt embankment.NTSB DFW07CA101Accident · No injuriesData collectionFinal reportMaule MXT-7-180 · Sierra Blanca, TXThe loss of control as result of the pilot's failure to compensate for the existing wind conditions. A contributing factor was the crosswind.NTSB ATL07CA062Accident · No injuriesData collectionFinal reportPiper PA-28A-180C · Atlanta, GAThe pilot's failure to maintain directional control of the airplane while landing with a flat main tire.NTSB NYC07CA079Accident · No injuriesData collectionFinal reportBeech C23 · Fredericksburg, VAThe pilot's misjudgment of the airplane's speed and distance during the landing approach.NTSB SEA07CA042Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Buckley, WAThe pilot's failure to release brake pressure soon enough when his airplane skidded from wet grass onto dry terrain during an off-airport, full-stop landing. A factor was the change in terrain from wet grass to dry ground in the landing area.NTSB LAX07CA070Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Jackpot, NVthe pilot's failure to maintain directional control after encountering loose snow conditions on the runway.