NTSB investigations: Lycoming O&VO-360 series, 2005
7 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “In flight collision with terrain/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 | 5 |
|---|---|
| 1983 | 4 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 6 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 5 |
| 1993 | 3 |
| 1994 | 8 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 8 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 7 |
| 2006 | 3 |
| 2007 | 1 |
Where
Open the mapLatest 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\") = 2005
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\" = 230))
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") = 2005
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" = 230))
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 CHI06FA057Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · La Vista, NEThe non-instrument rated pilot not maintaining aircraft control and not maintaining altitude/clearance from terrain during takeoff into instrument meteorological conditions. Contributing factors were the low ceilings, night conditions present, and the pilot's…NTSB NYC05CA135Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Hancock, NYThe pilot's inadequate compensation for wind conditions, which resulted in the airplane impacting the ground. A factor in the accident was the downdraft wind condition, as reported by the pilot.NTSB DEN05FA125Accident · 2 fatalField investigationFinal reportCessna 177B · Centennial, WYthe pilot's improper in-flight planning/decision, in that he failed to maintain a steady state climb rate to a safe altitude and continued flight towards visible weather that obstructed his chosen route of flight, and his failure to maintain terrain…NTSB CHI05CA159Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Osage Beach, MOThe pilot not maintaining clearance from the water while maneuvering for photographs.NTSB CHI05CA120Accident · No injuriesData collectionFinal reportBrantly Helicopter B-2B · Lakeview, MIThe dual student failed to maintain adequate rotor rpm during the practice autorotation and the instructor's delay in attempting remedial action. A factor associated with the accident was the soft terrain that was encountered.NTSB LAX05FA106Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Yucaipa, CAThe failure of the private pilot and the flight instructor to maintain adequate terrain clearance while flying in unfamiliar mountainous terrain in dark night conditions.NTSB ANC05LA035Accident · Minor injuriesLimited investigationFinal reportBellanca 8GCBC · Koyukuk, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an in flight collision with the snow during takeoff initial climb. A factor contributing to the accident was soft snow conditions.