NTSB investigations: Lycoming 0-320 series, AZ
30 cases on aircraft whose registry engine model is Lycoming 0-320 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 4 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 6 |
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 ('41508')
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 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 ('41508')
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 SEA08LA066Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Benson, AZThe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to avoid a stall. Contributing to the accident was a variable tailwind.NTSB SEA07CA265Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Flagstaff, AZThe pilot's failure to attain an adequate airspeed, which resulted in a forced landing off the end of the runway. A contributing factor to the accident was the gusting wind.NTSB SEA07CA109Accident · Minor injuriesData collectionFinal reportCessna 172I · Peach Springs, AZThe pilot's failure to adequately compensate for the gusty wind condition encountered on final approach, resulting in a loss of control and an in-flight collision with a dirt berm. A contributing factor was the gusty wind condition.NTSB SEA07LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Cibecue, AZThe pilot's failure to maintain proper control of the airplane during an off airport landing. Contributing factors were the pilot's psychological condition, impairment due to overdose of prescription medication, inadequate in-flight planning and mountainous…NTSB LAX07FA123Accident · 2 fatalField investigationFinal reportCessna 172N · Page, AZThe pilot's failure to maintain an adequate terrain clearance altitude, and, his failure to maintain an adequate airspeed while maneuvering to reverse course in a box canyon. Contributing to the accident were the rising terrain and the box canyon.NTSB SEA07CA074Accident · Minor injuriesData collectionFinal reportCessna 172N · Phoenix, AZThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall and uncontrolled descent into terrain during landing. A contributing factor was the pilot's distracted attention due to the inaccurate flap indicator.NTSB LAX06LA182Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Eagar, AZthe flight instructor's failure to attain and maintain the proper climb airspeed, which resulted in a stall/mush.NTSB LAX06CA162Accident · No injuriesData collectionFinal reportBeech BE23 · Kingman, AZthe student pilot's failure to attain/maintain a proper glide path, which resulted in an encounter with wake turbulence and subsequent hard landing.NTSB LAX05FA061Accident · 2 fatalField investigationFinal reportVail Lancair 235 · Sacaton, AZThe pilot's failure to maintain an adequate airspeed while maneuvering, which resulted in a stall/spin.NTSB LAX05FA029Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Mesa, AZthe pilot's failure to obtain and maintain an adequate airspeed during the takeoff initial climb, which resulted in a stall/spin.NTSB LAX03LA152Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Payson, AZthe pilot's inadequate recovery from a bounced landing, failure to retract the flaps during an aborted landing attempt, failure to maintain an adequate airspeed, and failure to maintain directional control. A factor in the accident was the high density…NTSB LAX00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Flagstaff, AZThe pilot's improper go-around procedure and his failure to maintain directional control on landing.NTSB LAX00LA128Accident · Serious injuriesLimited investigationFinal reportAero Commander 100 · Buckeye, AZThe pilot's improper judgment and his failure to maintain clearance from the ground. A factor was the pilot's lack of recent experience.NTSB LAX99LA257Accident · No injuriesLimited investigationFinal reportEwertz Starduster II · Winslow, AZthe pilot's failure to attain and maintain a sufficient flying airspeed for the existing density altitude conditions, which resulted in an inadvertent stall/mush.NTSB LAX98LA239Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of the pilot to maintain directional control of the aircraft during takeoff.NTSB LAX98LA135Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Scottsdale, AZThe pilot's failure to maintain directional control and his inadequate compensation for the wind condition. A contributing factor was the crosswind.NTSB LAX97LA260Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Chandler, AZThe CFI's failure to recognize and correct for a vortex ring state, and his improper use of the flight controls, which resulted in the loss of control and uncontrolled descent.NTSB LAX96FA131Accident · 2 fatalField investigationFinal reportVarga 2180A · Peoria, AZfailure of the pilot to obtain or maintain adequate airspeed for turning (maneuvering) after takeoff, which resulted in an inadvertent stall/spin. The lack of altitude for stall/spin recovery was a related factor.NTSB LAX93LA176Accident · No injuriesLimited investigationFinal reportCessna 172N · Flagstaff, AZThe pilot's poor aircraft handling techniques, his failure to correctly configure the carburetor heat control during the go around, and, his failure to maintain an adequate airspeed which resulted in an inadvertent stall mush condition. Factors in the…NTSB LAX91LA336Accident · No injuriesLimited investigationFinal reportCessna 172N · Sedona, AZThe pilot's misjudged landing flare and his failure to maintain a proper go-around course over the runway.NTSB LAX91FA288Accident · 1 fatalField investigationFinal reportRobinson R-22B · Phoenix, AZA divergence of the main rotor from its normal plane of rotation for an undetermined reason, which resulted in rotor contact to the cockpit.NTSB LAX90FA235Accident · 3 fatalField investigationFinal reportCessna 177 · Lake Havasu, AZThe pilot's inflight loss of control due to failure to maintain adequate airspeed. Contributing to the accident was the high density altitude, overweight airplane, and the pilot's alcohol level.NTSB LAX89LA251Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Scottsdale, AZImproperly use of the flight controls by the pilot and his failure to maintain control of the helicopter.NTSB LAX89LA150Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZImproper use of the elevator flight control by the pilot and his failure to maintain a proper rate of climb after lift-off. Contributing factors were: improper use of elevator trim by the pilot, his lack of total experience, and an inadvertent porpoise.NTSB LAX86FA315Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Phoenix, AZThe recently certificated private pilot initiated flt with an over loaded acft into high density alt conditions. The acft stalled as it made a climbing left turn to the crosswind leg of the traffic pattern. The stall resulted in an uncontrolled collision with…NTSB LAX86LA269Accident · No injuriesLimited investigationFinal reportBeech B-19 · Scottsdale, AZThe acft was fast and long during a landing attempt according to the student plt. He elected to make a go-around but in doing so he raised the flaps too rapidly and the acft landed hard after which it bounced into the dirt off to the side of the rwy.NTSB LAX86LA175Accident · No injuriesLimited investigationFinal reportRobinson R22 · Grand Canyon, AZThe pilot stated that he was attempting to land on a dirt road and that the helicopter was at a two to five foot hover when a gust of wind pivoted the tail into the wind. The helicopter touched down and rolled over onto its right side. The pilot further…NTSB LAX86FA089Accident · 3 fatalField investigationFinal reportCessna 172N · Grand Canyon, AZThe acft deptd runway 03 at Grand Canyon airport, Grand Canyon, AZ on a moonless night. Shortly after departure the aircraft entered into a left turn. The aircraft collided into some trees in about a 45 deg nose down and about a 15 deg left wing down attitude…NTSB LAX85LA166Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZThe plt was commencing his 1st solo x-country flt. At lift-off, the acft entered a left bank of about 45 degs. The student plt reduced power & the acft touched down hard on the dirt beside the rwy & was damaged. The plt believed that he may have encountered…NTSB LAX83LA107Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Grand Canyon, AZThe acft was blown off the right side of the runway during the flare for landing and the gear collapsed after landing. The pilot received a weather briefing and wind warning. He stated that the acft floated about 2000 feet down the runway after he flared…