NTSB investigations: Lycoming 0-320 series, AZ
45 cases on aircraft whose registry engine model is Lycoming 0-320 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 | 5 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 9 |
| 1998 | 2 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 4 |
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 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\" = 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 ('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" = 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 LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.NTSB LAX06CA144Accident · No injuriesData collectionFinal reportAviat A-1B · Chandler, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout. A contributing factor was the pilot's excessive use of the flight controls.NTSB LAX06CA117Accident · No injuriesData collectionFinal reportCessna 172M · Prescott, AZthe pilot's inadequate compensation for the crosswind conditions and his failure to maintain directional control.NTSB LAX06CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Maricopa, AZThe pilot's failure to maintain directional control during landing rollout. A factor was the soft dirt adjacent to the runway.NTSB LAX05CA121Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's failure to maintain directional control.NTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.NTSB LAX05CA067Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB LAX05CA066Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB LAX05LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Prescott, AZthe pilot's failure to maintain directional control during landing rollout. A contributing factor in the accident was the pilot's unfamiliarity with the airplane.NTSB LAX05CA005Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Winslow, AZthe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.NTSB LAX03LA153Accident · No injuriesLimited investigationFinal reportBeech B19 · Chandler, AZthe pilot's failure to maintain directional control on the landing roll due to his inadvertent use of brakes.NTSB LAX02LA199Accident · No injuriesLimited investigationFinal reportCessna 172M · Saint Johns, AZthe pilot's inadequate compensation for wind conditions resulting in a loss of directional control and collision with terrain. Related factors were the wind gusts, crosswind and soft terrain.NTSB LAX02LA070Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Payson, AZFailure of the pilot to maintain directional control of the airplane. A contributing factor was the premature raising of the flaps.NTSB LAX02LA026Accident · No injuriesLimited investigationFinal reportCessna 172M · Chandler, AZFailure of the student pilot to maintain directional control during landing.NTSB LAX02LA017Accident · No injuriesLimited investigationFinal reportCessna 172M · Prescott, AZThe CFI's improper remedial action and failure to maintain directional control during landing in a strong crosswind condition.NTSB LAX01LA130Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Holbrook, AZFailure of the rudder lower hinge attach point resulting in a loss of rudder control and steerable tailwheel control. A factor was the crosswind condition.NTSB LAX01LA115Accident · No injuriesLimited investigationFinal reportCessna 172N · Show Low, AZThe pilot's failure to maintain directional control resulting in an encounter with terrain and a nose over.NTSB LAX00LA309Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Scottsdale, AZFailure of the pilot to maintain directional control on the landing rollout. Also causal to the accident was his failure to retract flaps during the aborted landing attempt, which lead to a loss of lift and a hard landing followed by a ground loop.NTSB LAX00LA256Accident · No injuriesLimited investigationFinal reportCessna 172 · Chandler, AZfailure of the pilot-in-command to adequately compensate for a crosswind condition and maintain directional control during the landing roll, resulting in the airplane departing the runway and colliding with a sign.NTSB LAX99LA131Accident · No injuriesLimited investigationFinal reportCessna 172N · Scottsdale, AZFailure of the student pilot to maintain directional control of the aircraft while retracting the flaps during a touch-and-go.NTSB LAX98LA174Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Sedona, AZThe pilot's failure to maintain directional control during the landing rollout. A factor was the gusty wind.NTSB LAX98LA077Accident · No injuriesLimited investigationFinal reportPitts S1 · Prescott, AZThe pilot's failure to maintain directional control of the aircraft.NTSB LAX98LA002Accident · No injuriesLimited investigationFinal reportBlackwell Midget Mustang · Glendale, AZThe pilot's inability to maintain directional control of the aircraft due to the deflation of the right main gear tire. Factors in this accident were the soft sand on the side of the runway and the left crosswind.NTSB LAX97LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZthe student pilot's failure to maintain directional control of the airplane and proper alignment with the runway during landing.NTSB LAX97LA294Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZThe student's failure to maintain directional control due to excessive use of the rudder, and the instructor's delayed remedial action.NTSB LAX97LA284Accident · No injuriesLimited investigationFinal reportCessna 152 · San Manuel, AZThe student pilot's improper recovery from a bounced landing, and failure to maintain directional control of the aircraft. A factor related to the accident was the pilot's fatigue from improper rest the evening before the flight.NTSB LAX97LA271Accident · No injuriesLimited investigationFinal reportMiller S-1 · Cottonwood, AZThe inadequate strength and braking capability of the landing gear and wheel brakes, and the builder's attempt to adapt motorcycle parts to an aircraft application. A factor in this accident was the pilot's lack of familiarity with this experimental aircraft.NTSB LAX97LA229Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Page, AZThe pilot's inadequate compensation for crosswind gusts and his failure to maintain directional control.NTSB LAX97LA166Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZthe pilot's encounter with crosswind gusts beyond the performance capability of the aircraft. A lack of crosswind limit information published in the Cessna 172N Pilot's Operating Handbook for landing and taxiing operations is a factor in the accident.NTSB LAX97LA152Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper runway alignment.NTSB LAX97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Chandler, AZfailure of the student pilot to maintain directional control of the aircraft, and the flight instructor's inadequate supervision of the flight. The student's diverted attention was a related factor.NTSB LAX96LA227Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe failure of the pilot to adequately compensate for gusty crosswind conditions, which resulted in loss of aircraft control.NTSB LAX96LA031Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Bullhead City, AZThe failure of the pilot/flight instructor to adequately supervise the student pilot resulting in loss of directional control, and his abrupt overcorrection resulting in a waterloop. A contributing factor was the pilot's limited experience as a flight…NTSB LAX94LA334Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain directional control by his improper use of the flight controls. Factors related to this accident were the pilot's lack of total experience and the crosswind.NTSB LAX93LA301Accident · Minor injuriesLimited investigationFinal reportFerdon Thorp S-18 · Ash Fork, AZThe pilots inadequate compensation for wind conditions and failure to maintain directional control of the airplane during a precautionary landing, that resulted in collision with a fence and nose over of the airplane. A cross wind condition was a factor in…NTSB LAX88LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Payson, AZThe pilot reported that during the landing roll a dust devil (whirlwind) pushed the aircraft off the runway, colliding with the terrain resulting in substantial damage. The pilot reported that the wind velocity was 25 knots gusting to 30 as a quartering…NTSB LAX88LA035Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Tucson, AZThe pilot reported that the engine would not start by pressing the starter so he decided to hand prop the engine. After several attempts the engine finally started. The engine immediately increased power and the aircraft jumped the chocks. The non-pilot…NTSB LAX86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Springerville, AZThe acft collided with two parked acft after the student pilot lost control during a go-around. The student stated that during his first landing of the day the acft started to 'slide sideways' and he elected to go-around. He increased the throttle and the…NTSB LAX86LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chino Valley, AZWhen the flt departed prescott for the local flt, the plt said the rwys switched several times between 11 & 03 due to the winds. The official prescott surfact observation reported the winds from 110 degrees at 8 KTS with gusts to 17 KTS. After departing…NTSB LAX85LA124Accident · No injuriesLimited investigationFinal reportCessna 172N · Grand Canyon, AZThe 50 year old private pilot, with a total of 158 flight hours, said the landing was made on the right half of the 150 ft wide rwy. As he attempted to steer to the middle of the rwy the acft skidded off the left side of the rwy and contacted a snow bank aprx…NTSB LAX82DA303Accident · Minor injuriesFinal reportCessna 172N · Pine Springs, AZPlt stated he landed at what he thought was his destination arpt. The field was soft & an attempted takeoff was unsuccessful. He then taxied to an adjacent paved road & a second takeoff was attempted. The main landing gear went off the shoulder & the acft…NTSB LAX82DA157Accident · No injuriesFinal reportPiper PA-18-150 · Chandler, AZDuring landing roll the pilot stated that a gust of wind or a dust devil picked up the left wing and turned the aircraft to the right. The aircraft departed the runway and went into a small plowed field coming to rest in the opposite direction of the runway.NTSB LAX82DA131Accident · No injuriesFinal reportCessna 172 · Holbrook, AZThe student pilot was on his first solo flight. During the first touchdown, the aircraft bounced to the right. The student reported that after bouncing, the airspeed deteriorated as the aircraft floated and settled to the right. The aircraft struck sagebrush…NTSB LAX82DA052Accident · No injuriesFinal reportCessna 172 · Flagstaff, AZThe pilot made a night landing without landing lights. The runway was narrowed by snow banks inside the runway lights. The aircraft skidded on the icy runway and rode up onto the right snowbank, dragging the left wing. When the aircraft yawed to the right the…NTSB LAX82DA041Accident · No injuriesFinal reportCessna 172N · Bullhead City, AZWhile the pilot was landing with a tailwind, the aircraft went off the left side of the runway and traveled over a raised area beside the runway. The pilot reported that the nosewheel caught on the hillside as a gust of wind was encountered and the airplane…