NTSB investigations: Lycoming O&VO-360 series, AZ
10 cases on aircraft whose registry engine model is Lycoming O&VO-360 series, where the first occurrence was “Loss of control - on ground/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 | 1 |
|---|---|
| 1987 | 1 |
| 1989 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2004 | 2 |
| 2006 | 1 |
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 c.\"eventStateOrRegion\" = 'AZ' AND c.\"eventCountry\" = 'USA'
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\" = 260))
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 c."eventStateOrRegion" = 'AZ' AND c."eventCountry" = 'USA'
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" = 260))
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 LAX07CA044Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Springerville, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing. A factor was the crosswind.NTSB LAX04CA224Accident · No injuriesData collectionFinal reportCessna 177B · Grand Canyon, AZthe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of directional control.NTSB LAX04CA118Accident · No injuriesData collectionFinal reportMooney M20C · Mesa, AZthe pilot's failure to maintain directional control of the airplane, which resulted in a collision with an airport sign.NTSB LAX00LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZThe student pilot's failure to maintain directional control of the airplane during landing.NTSB LAX93LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZThe pilot's failure to maintain directional control on landing and her failure to maintain aircraft control during the attempted go around. Factors in the accident were: 1) the pilot's low total experience, 2) the fuel imbalance between the wing fuel tanks,…NTSB LAX92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Young, AZThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the soft muddy runway conditions at the dirt airstrip.NTSB LAX89DUJ05Accident · Serious injuriesFinal reportWarwick Thorp T-18 · Aguila, AZFailure of the pilot to maintain directional control, which resulted in the aircraft veering off the runway. Factors related to the accident were: uneven runway & the ditch.NTSB LAX89LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Show Low, AZDelayed retraction of flaps and the inadvertent application of left rudder due to diversion of attention resulting in the airplane's departure from the runway. A contributing factor was the inexperience of the student pilot.NTSB LAX87LA343Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tucson, AZA Piper PA-28-180 collided with a tree after veering off runway 15. The pilot indicated that he encountered a right crosswind during the landing roll and veered off the left side of the runway. The aircraft's left wing then struck a tree severing it from the…NTSB LAX82DA339Accident · Minor injuriesFinal reportMooney M20B · Scottsdale, AZThe plt reported he encountered a small amount of turbulence & a fairly strong crosswing on final. Touchdown was smooth & on the left side of the rwy. The acft then veered to the right. The plt saw a ditch ahead & applied full power before becoming airborne.…