NTSB investigations: Lycoming O&VO-360 series, 2002
11 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Loss of control - in flight”. 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 | 7 |
| 1984 | 8 |
| 1985 | 7 |
| 1986 | 8 |
| 1987 | 4 |
| 1988 | 11 |
| 1989 | 4 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 10 |
| 1995 | 6 |
| 1996 | 6 |
| 1997 | 9 |
| 1998 | 8 |
| 1999 | 7 |
| 2000 | 7 |
| 2001 | 9 |
| 2002 | 11 |
| 2003 | 16 |
| 2004 | 13 |
| 2005 | 12 |
| 2006 | 7 |
| 2007 | 8 |
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\") = 2002
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\" = 250))
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") = 2002
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" = 250))
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 ANC03GA020Accident · 1 fatalFinal reportAviat A-1B · King Salmon, AKThe pilot's failure to maintain adequate airspeed which resulted in an in-flight collision with terrain.NTSB NYC03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Edgartown, MAThe pilot's inadequate in-flight evaluation of the landing facilities wind conditions, and inadequate airspeed resulting in a stall/mush. A factor related to the accident was the tailwind condition.NTSB IAD02LA093Accident · No injuriesLimited investigationFinal reportCessna 177 · Dayton, OHThe pilot's failure to maintain adequate airspeed, resulting in a stall.NTSB NYC02FA166Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Deerfield, VAThe pilot's improper preflight decision to takeoff on an up-sloping runway with a tailwind, which resulted in an inadvertent stall and collision with a tree. Factors were the pilot's lack of familiarity with the geographic area, and a tailwind.NTSB MIA02FA148Accident · 3 fatalField investigationFinal reportBeech C23 · Centerville, TNthe pilot's failure to maintain airspeed which resulted in an inadvertent stall shortly after takeoff. A contributing factor was the pilot's decision to takeoff in an over gross weight condition and his lack of familiarity with the aircraft.NTSB FTW02LA224Accident · Serious injuriesLimited investigationFinal reportCessna 172S · Marietta, OKThe pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB CHI02FA193Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lee's Summit, MOThe inadequate preflight planning/preparation, the flight into instrument meteorological conditions, and lack of instrument certification by the pilot. Contributing factors were fog/clouds and the pilot's nondisclosure of his physical condition to the Federal…NTSB DEN02GA039Accident · 1 fatalFinal reportPiper/Cub Crafters PA-18-150 · USAF Academy, COThe loss of control for undetermined reasons.NTSB CHI02FA113Accident · 1 fatalField investigationFinal reportCessna 172RG · Marthasville, MOThe inadequate supervision and the stall encountered by the certified flight instructor.NTSB LAX02LA139Accident · No injuriesLimited investigationFinal reportBeech 76 · Petaluma, CAThe flight instructor's decision to execute a simulated single engine go-around at an altitude insufficient to preclude the inadvertent ground contact of the airplane and the resultant loss of directional control. The flight instructor's delayed remedial…NTSB DEN02FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Glenwood Sprngs, COthe pilot's failure to maintain aircraft control due to spatial disorientation, resulting in a collision with terrain. Contributing factors were the pilot's lack of an instrument rating and the dark night conditions.