NTSB investigations, AZ

107 cases where the sequence of events included Off-field or emergency landing.

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR15LA055Accident · No injuriesLimited investigationFinal reportFouga CM 170R Magister · Lake Havasu City, AZA total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.Dec 6, 2014 · N300FM · Substantial damageNTSB WPR15LA020Accident · Serious injuriesLimited investigationFinal reportWinston W Walker Thunder Mustang · Globe, AZThe separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…Oct 24, 2014 · N244SW · Substantial damageNTSB WPR15LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA28 151 · Bullhead City, AZA partial loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.Oct 18, 2014 · N56873 · Substantial damageNTSB WPR14LA374Accident · No injuriesLimited investigationFinal reportBell 206 · Tombstone, AZA partial loss of engine power during cruise flight due to loose “B” nut fittings and a bent tube as a result of maintenance personnel’s inadequate inspection of the nuts during the most recent inspection.Sep 12, 2014 · N64AW · Substantial damageNTSB WPR14LA242Accident · No injuriesLimited investigationFinal reportAdams Dragonfly · Mesa, AZA partial loss of engine power due to a reduction in the No. 3 cylinder’s compression as a result of the exhaust valve not having consistent uniform contact with the cylinder head valve seat.Jun 12, 2014 · N85TL · Substantial damageNTSB WPR14TA236Accident · No injuriesFinal reportMcdonnell Douglas Helicopter 369E · Mesa, AZThe loss of engine power during cruise flight due to the decoupling of the engine’s turbine and compressor sections. Contributing to the decoupling was the excessive wear of the turbine-to-compressor coupling components due maintenance personnel’s placement…Jun 8, 2014 · N504MP · Substantial damageNTSB WPR14CA227Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe inadvertent activation of the engine's mixture control during cruise flight by the pilot undergoing instruction, which resulted in a total loss of engine power. Contributing to the accident was the flight instructor's inadequate monitoring of the pilot's…Jun 4, 2014 · N223G · Substantial damageNTSB WPR14FA194Accident · 1 fatalField investigationFinal reportAero Commander 500 S · Fort Huachuca, AZThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack after a total loss of engine power during the takeoff initial climb, which resulted in an aerodynamic stall and impact with terrain. The reason for…May 17, 2014 · N40TC · Substantial damageNTSB WPR14LA169Accident · Minor injuriesLimited investigationFinal reportPiper PA30 - NO Series · Bullhead City, AZThe pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…Apr 21, 2014 · N7880Y · Substantial damageNTSB WPR13LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Overgaard, AZThe partial loss of engine power during takeoff due to the separation of the exhaust baffling, which resulted in a partial blockage of airflow. Contributing to the accident was inadequate maintenance of the exhaust system.Aug 10, 2013 · N9752J · Substantial damageNTSB WPR13LA266Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Grand Canyon, AZA loss of throttle control movement during a practice autorotation that was planned to terminate with a power recovery for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal…Jun 8, 2013 · N130PH · Substantial damageNTSB WPR13LA190Accident · Serious injuriesLimited investigationFinal reportBeech 35-B33 · San Manuel, AZA loss of engine power due to fuel starvation during the landing approach. Contributing to the accident was the pilot’s failure to follow the emergency checklist and switch tanks. Contributing to the severity of the pilot's injuries was the lack of a shoulder…Apr 13, 2013 · N6841Q · Substantial damageNTSB WPR13FA169Accident · 1 fatalField investigationFinal reportMooney M20A · Wikieup, AZThe manufacture and installation of a nonstandard part by unknown maintenance personnel to compensate for a bent, misaligned crankshaft propeller flange, which resulted in the improper clearance of the bearings on the crankshaft journal, a loss of oil…Mar 28, 2013 · N6018X · Substantial damageNTSB WPR13LA134Accident · No injuriesLimited investigationFinal reportBlumer Challenger II Spec · Peoria, AZA cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach.Feb 26, 2013 · N107BW · Substantial damageNTSB WPR13LA099Accident · No injuriesLimited investigationFinal reportGoetz Helicycle · Mesa, AZThe pilot's failure to properly install and secure the wire connecting the electronic speed controller unit to the fuel controller actuator motor, which resulted in the wire’s disconnection in flight and the resultant partial loss of engine power.Jan 22, 2013 · N143PG · Substantial damageNTSB WPR13LA043Accident · Minor injuriesLimited investigationFinal reportCirrus SR22 · Show Low, AZThe fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.Nov 16, 2012 · N800RW · 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 WPR12LA408Accident · No injuriesLimited investigationFinal reportBell Helicopter Textron 206L-1 · Grand Canyon, AZA total loss of engine power during descent for reasons that could not be determined because postaccident engine examinations and testing revealed no evidence of an anomaly that would have precluded normal operation.Sep 9, 2012 · N5745Y · 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 WPR12CA084Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-33A · Peoria, AZThe glider pilot released from the tow airplane at a lower altitude than the planned altitude, which resulted in an off-airport landing.Jan 28, 2012 · N17873 · Substantial damageNTSB WPR12LA039Accident · Serious injuriesLimited investigationFinal reportWilliams Helicopter UH-1H · Grand Canyon, AZThe loss of main rotor power due to a main rotor transmission failure from a lack of lubrication.Nov 15, 2011 · N502AW · Substantial damageNTSB WPR11LA375Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Willcox, AZThe pilot's failure to maintain clearance from a tower while maneuvering at low altitude. Contributing to the accident was the recent installation of the unmarked tower.Aug 8, 2011 · N5123L · Substantial damageNTSB WPR11LA246Accident · No injuriesLimited investigationFinal reportScottish Series 100 MDL 101 · Chandler, AZA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Jun 3, 2011 · N101MY · 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 WPR11FA186Accident · No injuriesField investigationFinal reportCessna 177RG · Gila Bend, AZA total loss of engine power during cruise flight due to both sets of magneto points failing to open as a result of excessive wear of the magneto cam followers.Apr 5, 2011 · N2637V · Substantial damageNTSB WPR11LA167Accident · No injuriesLimited investigationFinal reportRotorway A600 · Chandler, AZA design modification that changed the fasteners and components used to attach the main rotor drive pulley to the engine, which resulted in fatigue failure of those fasteners and a complete loss of power to the main rotor.Mar 15, 2011 · N602RW · Substantial damageNTSB WPR11LA140Accident · No injuriesLimited investigationFinal reportRearwin 8135 · Casa Grande, AZThe partial loss of engine power due to the separation of an exhaust valve rocker box as a result of the failure of the rocker box attaching studs.Feb 18, 2011 · NC25545 · Substantial damageNTSB WPR11LA135Accident · No injuriesLimited investigationFinal reportCessna 172H · Wikieup, AZA total loss of engine power during cruise flight resulting from the failure of a fuel line. Contributing to the accident was inadequate maintenance inspections that failed to detect the deteriorating fuel line.Feb 15, 2011 · N2561L · Substantial damageNTSB WPR11LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-181 · Wittmann, AZThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 1, 2010 · N4122F · Substantial damageNTSB WPR10FA371Accident · 3 fatalField investigationFinal reportAmerican Eurocopter AS 350 B3 · Tucson, AZThe repair station technician did not properly install the fuel inlet union during reassembly of the engine; the operator’s maintenance personnel did not adequately inspect the technician's work; and the pilot who performed the post maintenance check flight…Jul 28, 2010 · N509AM · Substantial damageNTSB WPR10LA357Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Phoenix, AZA loss of engine power during descent due to fuel starvation that resulted from the pilot's mismanagement of the fuel system.Jul 18, 2010 · N9SH · Substantial damageNTSB WPR10LA341Accident · Serious injuriesLimited investigationFinal reportRonald V White CH701 · Pima, AZA total loss of engine power while maneuvering due to a spark plug failure.Jul 10, 2010 · N3784A · Substantial damageNTSB WPR10LA317Accident · Serious injuriesLimited investigationFinal reportWorgull Hornet · Camp Verde, AZThe in-flight separation of the exhaust clamps for an undetermined reason, which resulted in the exhaust system striking the wooden propeller.Jun 28, 2010 · N707BD · Substantial damageNTSB WPR10LA280Accident · No injuriesLimited investigationFinal reportBeech F33 · Marana, AZThe loss of engine power while maneuvering to land for undetermined reasons.Jun 5, 2010 · N1565A · Substantial damageNTSB WPR10LA251Accident · Minor injuriesLimited investigationFinal reportCessna 210A · Benson, AZA loss of engine power due to fuel starvation as a result of a loss of fuel pressure caused by the fuel pump screws being loose. Contributing to the accident was inadequate maintenance.May 21, 2010 · N6630X · Substantial damageNTSB WPR10CA215Accident · No injuriesData collectionFinal reportPZL-Swidnik PW-5 · Marana, AZThe pilot's inability to find thermal lift. Contributing to the accident was the failure of a computer that provided glide information and vertical speed instrumentation as a result of an improperly routed electrical cable that caused a short in the…Apr 26, 2010 · N500JN · Substantial damageNTSB WPR10LA166Accident · Serious injuriesLimited investigationFinal reportKjonaas Varieze · Casa Grande, AZA loss of engine power during cruise flight due to fuel exhaustion.Mar 17, 2010 · N50894 · Substantial damageNTSB WPR10LA130Accident · Minor injuriesLimited investigationFinal reportNanchang China CJ-6A · Mesa, AZSeparation of the cylinder from the engine during cruise flight due to fatigue in the studs attaching it to the engine casing.Feb 7, 2010 · N6263D · Substantial damageNTSB WPR10LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZA loss of engine power for undetermined reasons.Nov 8, 2009 · N2165M · Substantial damageNTSB WPR10LA039Accident · Minor injuriesLimited investigationFinal reportSauer KR-2S · Glendale, AZA loss of engine power due to fuel starvation as a result of a reduced fuel flow to the engine resulting from a misrouted fuel tank vent line, during initial climb.Oct 30, 2009 · N811RJ · 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 WPR09LA422Accident · No injuriesLimited investigationFinal reportCessna 210K · Show Low, AZA total loss of engine power due to the displaced oil filter adapter gasket, which resulted in an oil leak and oil exhaustion. Contributing to the accident was the unsuitable terrain for a forced landing.Aug 27, 2009 · N4600Q · Substantial damageNTSB WPR09LA395Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glendale, AZA loss of engine power for undetermined reasons.Aug 12, 2009 · N86GW · Substantial damageNTSB WPR09CA389Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Marana, AZA loss of lift that resulted in an off-airport landing.Aug 5, 2009 · N77MA · 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 WPR09LA251Accident · No injuriesLimited investigationFinal reportErcoupe 415C · San Manuel, AZA loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and impact with terrain.May 15, 2009 · N2339H · Substantial damageNTSB WPR09LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Glendale, AZA loss of engine power due to the failure of both magnetos resulting from an improper maintenance repair by maintenance personnel.Apr 15, 2009 · N6285M · Substantial damageNTSB WPR09CA152Accident · No injuriesData collectionFinal reportKenneth K Knowles Sonex · Cottonwood, AZThe loss of engine power for undetermined reasons.Mar 18, 2009 · N997KK · Substantial damageNTSB WPR09IA140Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B2 · Peach Springs, AZA loss of engine power due to the failure of the number three engine bearing as a result of oil starvation due to coked oil obstructing the oil passages.Mar 3, 2009 · N197AE · Minor damageNTSB WPR09LA075Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Casa Grande, AZThe pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.Jan 6, 2009 · N797BS · Substantial damage