NTSB investigations: Lycoming O&VO-360 series, 1996
5 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Hard landing”. 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 | 5 |
| 1984 | 9 |
| 1985 | 6 |
| 1986 | 5 |
| 1987 | 2 |
| 1988 | 5 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 5 |
| 1993 | 4 |
| 1994 | 4 |
| 1995 | 3 |
| 1996 | 5 |
| 1997 | 1 |
| 1998 | 6 |
| 1999 | 5 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 7 |
| 2003 | 3 |
| 2004 | 8 |
| 2005 | 8 |
| 2006 | 6 |
| 2007 | 4 |
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\") = 1996
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\" = 200))
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") = 1996
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" = 200))
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 CHI96LA315Accident · No injuriesLimited investigationFinal reportBeech C-23 · Eden Prairie, MNthe instructor pilot delayed the remedial action and failed to maintain adequate supervision. The slow airspeed maintained by the student pilot was a factor.NTSB FTW96LA256Accident · No injuriesLimited investigationFinal reportCessna R172K · Watkins, COan improper flare by the pilot, which resulted in a hard landing.NTSB NYC96LA127Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2 · Fulton, NYthe student pilot's improper flare and the flight instructor's inadequate supervision.NTSB SEA96LA101Accident · No injuriesLimited investigationFinal reportCessna 177 · Corvallis, ORfailure of the pilot to properly judge the distance and altitude to the runway just before touching down, and his premature flare for landing. Factors relating to the accident were: the presence of sun glare during the landing, and the resultant degradation…NTSB MIA96LA093Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Panama City Bch, FLimproper compensation for wind conditions by the second pilot, his inadequate remedial action after the airplane lifted off during a wind gust, and inadequate supervision by the first pilot (PIC). A factor relating to the accident was: the gusty wind…