NTSB investigations: Lycoming O&VO-360 series, 1992
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\") = 1992
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") = 1992
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 NYC93LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Oxford, CTThe pilot's improper level off which resulted in a hard landing. Contributing were wind gusts and the pilot's inadequate compensation for wind conditions.NTSB FTW93LA021Accident · No injuriesLimited investigationFinal reportCessna 177B · Las Cruces, NMThe pilot's delayed landing flare and the improper bounced landing recovery. A factor was the dark night.NTSB FTW92LA154Accident · No injuriesLimited investigationFinal reportBeech 76 · Sherman, TXThe instructor pilot's delayed remedial action, improper configuration, and inadvertent stall.NTSB CHI92LA109Accident · No injuriesLimited investigationFinal reportCessna 177BII · Bloomington, ILPilot's improper recovery from a bounced landing. Factors in the accident were excessive airspeed at landing and habit interference.NTSB CHI92LA107Accident · No injuriesLimited investigationFinal reportBeech C23 · Ozark, MOThe CFI pilot-in-command's failure to provide adequate supervision of a dual student. A factor contributing to the accident was the student pilot's failure to maintain airspeed.