NTSB investigations: Lycoming 0-320 series, AZ

383 cases on aircraft whose registry engine model is Lycoming 0-320 series. 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, newest first

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'))
  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.

NTSB WPR13CA219Accident · Serious injuriesData collectionFinal reportPiper PA-28 · Cottonwood, AZThe student pilot's decision to attempt a night landing on an unlit runway, which resulted in a misaligned approach and subsequent collision with a fence. Contributing to the accident was the student pilot's improper set-up of the airplane radios, which…May 7, 2013 · N47717 · Substantial damageNTSB WPR13CA152Accident · Minor injuriesData collectionFinal reportCessna 172N · Gila Bend, AZThe student pilot's failure to maintain airplane control during an attempted go-around.Mar 17, 2013 · N5802J · Substantial damageNTSB WPR13LA113Accident · No injuriesLimited investigationFinal reportCessna 172 · Wilcox, AZThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any abnormalities that would have precluded normal operation.Feb 2, 2013 · N1421V · Substantial damageNTSB WPR13FA058Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Tacna, AZThe pilot’s failure to maintain airplane control. Contributing to the accident was the pilot’s impairment due to acute psychosis with paranoid thoughts.Nov 23, 2012 · N5076W · Substantial damageNTSB WPR13LA038Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Maricopa, AZThe pilot’s failure to maintain proper pitch control during the initial climb, which resulted in a stall, loss of airplane control, and collision with terrain.Nov 11, 2012 · N65835 · Substantial damageNTSB WPR13LA025Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Mariner · Lake Havasu, AZThe pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.Oct 27, 2012 · N2627M · Substantial damageNTSB WPR13FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Marana, AZThe pilot’s flight in dark night conditions with no visual reference and his subsequent spatial disorientation.Oct 15, 2012 · N151SV · Substantial damageNTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.Oct 5, 2012 · N8115Q · 2 aircraft · Substantial damageNTSB WPR12LA423Accident · No injuriesLimited investigationFinal reportBarney Stardustrer SA-100 · Chandler, AZA loss of engine power as a result of fuel exhaustion due to a fuel line failure. Contributing to the accident was the pilot’s failure to adhere to the maintenance inspection criteria for the airplane.Sep 17, 2012 · N1356Y · Substantial damageNTSB WPR12CA425Accident · No injuriesData collectionFinal reportCessna 172N · Eloy, AZThe pilot's improper flare, and his inadequate recovery from a bounced landing.Sep 16, 2012 · N8293E · Substantial damageNTSB WPR12CA342Accident · Serious injuriesData collectionFinal reportPiper PA18 · McNeal, AZThe pilot's in-flight decision to fly at low level into an unfamiliar canyon, which resulted in an off-airport landing when the airplane's climb capability was exceeded. Contributing to the accident was the airplane’s decreased performance due to the high…Aug 2, 2012 · N2364P · Substantial damageNTSB WPR12CA187Accident · No injuriesData collectionFinal reportGlass Roy L RV-6 · Coolidge, AZThe pilot’s loss of directional control during landing.Apr 27, 2012 · N164RG · Substantial damageNTSB WPR12LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · San Manuel, AZThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.Apr 13, 2012 · N3583K · Substantial damageNTSB WPR12FA066Accident · Serious injuriesField investigationFinal reportRobinson Helicopter R22 Beta · Tucson, AZA loss of engine power due to the pilot's failure to utilize carburetor heat while maneuvering. .Dec 14, 2011 · N4052G · Substantial damageNTSB WPR11CA212Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZThe pilot’s failure to maintain directional control during the landing roll.Apr 27, 2011 · N9683P · Substantial damageNTSB WPR11LA193Accident · Minor injuriesLimited investigationFinal reportBartholomew Lancair 320 · Temple Bar, AZThe pilot did not use carburetor heat in cruise flight while operating in an area conducive to carburetor icing, which resulted in a loss of engine power.Apr 8, 2011 · N320BB · Substantial damageNTSB WPR10LA429Accident · 2 fatalLimited investigationFinal reportFinney Thorp T-18 · Willcox, AZThe pilot’s failure to maintain sufficient airspeed during a steep turn and at a low altitude in the traffic pattern, which resulted in an aerodynamic stall.Aug 26, 2010 · N467JF · Substantial damageNTSB WPR10FA264Accident · Serious injuriesField investigationFinal reportPiper PA-28-161 · Chandler, AZFailure of the maintenance personnel to ensure adequate torque of a fuel line fitting, which resulted in an in-flight fire.May 26, 2010 · N4122T · Substantial damageNTSB WPR10CA183Accident · No injuriesData collectionFinal reportStolp Starduster SA-300 · Goodyear, AZThe pilot's failure to maintain directional control during landing rollout with a quartering tailwind, resulting in collapse of the right main landing gear.Mar 28, 2010 · N4493 · Substantial damageNTSB WPR10CA170Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Phoenix, AZThe student pilot's inadequate compensation for the quartering tailwind during landing and the flight instructor's delay in taking remedial action.Mar 18, 2010 · N8830D · Substantial damageNTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.Oct 24, 2009 · N83281 · Substantial damageNTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.Oct 10, 2009 · N51302 · Substantial damageNTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.Sep 9, 2009 · N94741 · 2 aircraft · Substantial damageNTSB WPR09LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taylor, AZThe loss of engine power for undetermined reasons.Jul 6, 2009 · N5957U · Substantial damageNTSB WPR09LA160Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Prescott, AZThe pilot's failure to maintain adequate main rotor rpm while maneuvering at a low altitude.Mar 20, 2009 · N90764 · Substantial damageNTSB WPR09CA106Accident · No injuriesData collectionFinal reportGrumman AA-5 · Payson, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain directional control. Contributing to the accident was the crosswind condition.Feb 1, 2009 · N5423L · Substantial damageNTSB WPR09CA054Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Goodyear, AZThe failure of the student pilot to maintain directional control during takeoff.Dec 5, 2008 · N268ML · Substantial damageNTSB WPR09CA053Accident · No injuriesData collectionFinal reportCessna 172 · Sedona, AZThe pilot's improper flare and inadequate recovery from a bounced landing.Nov 29, 2008 · N98774 · Substantial damageNTSB SEA08CA180Accident · No injuriesData collectionFinal reportCessna 177 · Glendale, AZThe loss of engine power due to vapor lock. Contributing to the accident was the high atmospheric temperature.Aug 17, 2008 · N29304 · Substantial damageNTSB SEA08LA179Accident · 1 fatalLimited investigationFinal reportCessna 177 · St. Johns, AZThe failure of both pilots to abort the takeoff when a suitable climb rate could not be attained. Contributing to the accident was the reduction of available power due to the camshaft lobe and lifter corrosion/wear, the high density altitude, and the CFI’s…Aug 16, 2008 · N3487T · Substantial damageNTSB LAX08CA155Accident · No injuriesData collectionFinal reportCessna 172N · Sells, AZThe pilot's inadequate recovery from a bounced landing and failure to maintain proper runway alignment.May 26, 2008 · N2857E · Substantial damageNTSB SEA08LA137Accident · 1 fatalLimited investigationFinal reportNolan RV-4 · Tolani Lake, AZAn in-flight collision with terrain for undetermined reasons.May 25, 2008 · N6290F · Substantial damageNTSB SEA08LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe student pilot's delay in initiating the go-around, and the flight instructor's inadequate supervision of the flight and delayed remedial action. Contributing to the accident were the momentary failure of the engine to respond, the failure of both the…Mar 3, 2008 · N8400A · Substantial damageNTSB 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.Nov 11, 2007 · N9592U · Substantial damageNTSB LAX08LA009Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Prescott, AZThe failure of maintenance personnel to detect fatigue cracks in the number 3 exhaust rocker arm, which lead to a partial loss of engine power.Oct 10, 2007 · N9897G · Substantial damageNTSB SEA07CA273Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Chandler, AZThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were the downdraft, the uneven terrain, and the flight instructor's delayed…Sep 25, 2007 · N6716J · Substantial damageNTSB 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.Sep 18, 2007 · N4764T · Substantial damageNTSB SEA07CA180Accident · No injuriesData collectionFinal reportRobinson R22 · Tucson, AZThe certified flight instructor's inadequate supervision of the practice autorotation. Contributing factors included the terrain drop off and the failure of the pilot undergoing instruction to maintain adequate rotor rpm.Jun 25, 2007 · N980SM · Substantial damageNTSB LAX07LA153Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Tucson, AZA loss of engine power while maneuvering due to a broken exhaust valve. Contributing to the accident was the rough terrain.May 8, 2007 · N5895U · Substantial damageNTSB 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.Apr 20, 2007 · N35562 · Substantial damageNTSB 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…Apr 9, 2007 · N42487 · Substantial damageNTSB 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.Apr 9, 2007 · N6267D · DestroyedNTSB 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.Mar 9, 2007 · N4663D · Substantial damageNTSB 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.Nov 19, 2006 · N8477F · Substantial damageNTSB LAX07LA025Accident · 2 fatalLimited investigationFinal reportOlson Vans RV-6 · Rio Verde, AZThe pilot's failure to maintain clearance from power lines while intentionally flying at a low altitude.Nov 2, 2006 · N606RV · Substantial damageNTSB LAX07LA011Accident · Minor injuriesLimited investigationFinal reportMorrisey 2150A · Chandler, AZLoss of engine power during cruise flight due to a crack in the oil cooler and subsequent loss of engine oil.Oct 18, 2006 · N5114V · Substantial damageNTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.Oct 6, 2006 · N97811 · Substantial damageNTSB 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.May 26, 2006 · N6309W · Substantial damageNTSB 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.May 5, 2006 · N8750M · Substantial damageNTSB 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.Apr 22, 2006 · N143HP · Substantial damage