NTSB investigations: Lycoming O&VO-360 series, 2003
16 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
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\") = 2003
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") = 2003
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 LAX04CA048Accident · No injuriesData collectionFinal reportRobinson R22 · Chandler, AZthe student pilot's failure to maintain control of the helicopter while hovering. A factor to the accident was the student pilot's lack of experience.NTSB NYC03FA206Accident · 2 fatalField investigationFinal reportPiper PA-18-180 · Bardstown, KYThe pilot-in-command's failure to maintain aircraft control for undetermined reasons.NTSB LAX03CA263Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Pauma Valley, CAthe pilot's failure to maintain an adequate airspeed, which resulted in a stall. The rising terrain was a factor.NTSB FTW03LA203Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Ozona, TXThe pilot's decision to hover out of ground effect, which resulted in a loss of tail rotor effectiveness. A contributing factor was the lack of suitable terrain.NTSB DEN03FA136Accident · 4 fatalField investigationFinal reportMooney M20C · Blanding, UTthe pilot's failure to maintain airspeed which resulted in a stall/spin.NTSB SEA03FA148Accident · 1 fatalField investigationFinal reportRobinson R22 Beta · Tulalip, WAA loss of control for unknown reasons.NTSB DEN03FA133Accident · 3 fatalField investigationFinal reportGrumman American AA-5B · Steamboat Sprng, COThe pilot's failure to maintain terrain clearance. Contributing factors include the pilot's inadequate preflight planning/preparation, high density altitude, and mountainous conditions.NTSB NYC03LA151Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Manorville, NYThe pilot's failure to obtain the proper airspeed and his delayed remedial action to jettison the banner.NTSB LAX03CA215Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm, and, his improper use of the collective, throttle, and anti-torque controls during the attempted recovery. Factors in the accident were the pilot's failure to completely relinquish the controls, and the…NTSB NYC03FA132Accident · 1 fatalField investigationFinal reportAviat A-1 · Tyringham, MAThe pilot's incapacitation due to a heart attack, which resulted in a loss of aircraft control.NTSB NYC03FA082Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Conesus, NYThe flight instructor's failure to maintain adequate airspeed which resulted in an inadvertent spin.NTSB LAX03LA120Accident · No injuriesLimited investigationFinal reportBeech 19A · Coalinga, CAThe pilot's failure to obtain/maintain an adequate airspeed, which resulted in a stall/mush.NTSB DEN03LA047Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Colo Springs, COthe pilot's failure to maintain aircraft control during initial climb which resulted in impact with terrain. Contributing factors include the downdraft, crosswind and gusty wind conditions.NTSB SEA03LA040Accident · 1 fatalLimited investigationFinal reportPiper PA-22-150 · Garryowen, MTThe pilot in command's allowing the aircraft to inadvertently enter into a stall condition at low altitude while maneuvering. A contributing factor was the pilot's intentional low altitude maneuvering.NTSB ATL03LA047Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Valdosta, GAThe pilot's failure to maintain adequate airspeed during a go-around resulting in an inadvertent stall and collision with trees.NTSB MIA03LA057Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Pompano Beach, FLThe student pilot's failure to maintain control during takeoff which resulted in in uncontrolled descent and the helicopter impacting the ground.