NTSB investigations: Lycoming O&VO-360 series, 1995
7 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\") = 1995
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") = 1995
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 FTW96LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Heber Springs, ARFailure of the pilot to maintain directional control of the airplane during transition from landing roll to taxi. A factor relating to the accident was: a soft area in the grass runway.NTSB NYC95LA213Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Meriden, CTthe pilot's failure to maintain directional control during the landing roll which resulted in the aircraft veering off the runway, and a subsequent collision with a fence.NTSB FTW95LA333Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the crosswind condition.NTSB FTW95LA329Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Englewood, COThe pilot's improper compensation for the 6 knot crosswind. Factors were the pilot's delay in initiating an aborted landing and his lack of total experience.NTSB CHI95LA216Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, MOThe pilot's failure to maintain control of the airplane while landing and his inadequate compensation for wind conditions. A factor in the accident was the gusty crosswind conditions.NTSB ANC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Gustavus, AKThe pilot's failure to maintain directional control. A factor relating to the accident was: the diminished nosewheel steering capability due to an overinflated nosewheel strut.NTSB FTW95LA118Accident · No injuriesLimited investigationFinal reportCessna 177B · Terlingua, TXThe pilot's failure to maintain directional control. Factors were his decision to land on the unlit runway and the dusk light conditions.