NTSB investigations: Lycoming O&VO-360 series, 2006
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\") = 2006
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") = 2006
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 SEA07CA029Accident · No injuriesData collectionFinal reportCessna 172RG · Laurel, MTThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and subsequent nose over. A contributing factor was the crosswind condition.NTSB LAX07CA044Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Springerville, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing. A factor was the crosswind.NTSB SEA07LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Billings, MTThe flight instructor's inadequate remedial action to maintain directional control, which resulted in a ground loop/swerve during takeoff roll. A factor was the failure of the pilot who was receiving instruction to maintain directional control.NTSB DEN06LA100Accident · No injuriesLimited investigationFinal reportMaule M 6 180C · Kemmerer, WYthe pilot's loss of directional control during takeoff due to the improper rigging of the airplane's flap system by unknown maintenance personnel. A contributing factor was the high density altitude.NTSB NYC06CA141Accident · No injuriesData collectionFinal reportMaule M-5-180C · Mount Pocono, PAThe disconnected tailwheel compression spring, which resulted in a loss of directional control.NTSB NYC06CA120Accident · No injuriesData collectionFinal reportPiper PA-28-280 · Tangier Island, VAThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a ditch. A factor was the rough runway condition.NTSB LAX06CA159Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Columbia, CAthe pilot's failure to maintain directional control during the landing roll.NTSB MIA06LA089Accident · No injuriesLimited investigationFinal reportBeech C24R · Panama City, FLA flat tire which occurred for undetermined reasons that resulted an inadvertent loss of control during the landing roll.NTSB ANC06LA022Accident · No injuriesLimited investigationFinal reportPiper PA-24 · El Cajon, CAThe student pilot's failure to maintain directional control during takeoff, which resulted in an on ground collision with a sign, and the collapse of the main landing gear.