NTSB investigations, AZ
347 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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\" = '470' 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.
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" = '470' 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
Run 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 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.NTSB WPR11CA124Accident · No injuriesData collectionFinal reportCessna 182D · Quartzsite, AZThe pilot's inadequate compensation for the wind and subsequent loss of directional control, which resulted in a runway excursion and collision with a parked aircraft.NTSB WPR11CA097Accident · No injuriesData collectionFinal reportCessna 180 · Flagstaff, AZThe pilot's failure to maintain directional control during landing that resulted in a ground loop.NTSB WPR11LA080Accident · Serious injuriesLimited investigationFinal reportSchaefer Kitfox 4 · Glendale, AZThe pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…NTSB WPR11LA069Accident · 1 fatalLimited investigationFinal reportSabre Trike · Peoria, AZAn in-flight loss of control for undetermined reasons.NTSB 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.NTSB WPR11CA026Accident · No injuriesData collectionFinal reportCessna 340A · Camp Verde, AZThe pilot's misjudged approach and failure to attain the correct touchdown point, which resulted in a runway overrun.NTSB WPR11CA024Accident · No injuriesData collectionFinal reportCessna 185 · Fort Thomas, AZThe airplane's encounter with a dust devil during landing rollout, which resulted in the pilot not being able to maintain directional control.NTSB WPR10LA454Accident · No injuriesLimited investigationFinal reportExtra Flugzeugbau EA-300 · Sierra Vista, AZA loss of engine power due to metal debris contamination of the inverted oil system shuttle valve, which resulted in a disruption of oil flow and subsequent oil starvation.NTSB WPR10FA435Accident · 1 fatalField investigationFinal reportRemos Remos G-3/600 · Tucson, AZThe pilot's failure to maintain airplane control while maneuvering at a low altitude.NTSB 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.NTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.NTSB WPR10FA383Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Phoenix, AZThe pilot‘s failure to maintain airspeed and airplane control during a turn from the base leg to final approach due to his diverted attention.NTSB 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…NTSB 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.NTSB WPR10LA341Accident · Serious injuriesLimited investigationFinal reportRonald V White CH701 · Pima, AZA total loss of engine power while maneuvering due to a spark plug failure.NTSB WPR10CA342Accident · No injuriesData collectionFinal reportPiper PA32RT · Sedona, AZThe pilot’s failure to maintain runway alignment during approach and subsequent loss of directional control during landing.NTSB WPR10LA280Accident · No injuriesLimited investigationFinal reportBeech F33 · Marana, AZThe loss of engine power while maneuvering to land for undetermined reasons.NTSB WPR10LA258Accident · 1 fatalLimited investigationFinal reportRice GN-1 AIR Campier · Paulden, AZThe pilot's loss of airplane control for undetermined reasons while on final approach to land.NTSB 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.NTSB WPR10LA212Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Buckeye, AZA partial loss of engine power during the takeoff roll for undetermined reasons.NTSB WPR10CA172Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe flight instructor's failure to attain and maintain adequate airspeed while demonstrating a soft-field takeoff.NTSB WPR10LA156Accident · 1 fatalLimited investigationFinal reportNorth American P51D · Chandler, AZThe pilot’s improper flare, resulting in a bounced landing, stall, and loss of directional control.NTSB WPR10CA153Accident · No injuriesData collectionFinal reportAviat A-1C-200 · St. Johns, AZThe pilot's inadequate compensation for the crosswind gusts and failure to maintain proper runway alignment during takeoff.NTSB WPR10FA133Accident · 5 fatalField investigationFinal reportEurocopter EC135 · Cave Creek, AZThe sudden and inadvertent lowering of the collective to near the lower stop, followed by a simultaneous movement of the collective back up and the cyclic control to a nearly full-aft position, which resulted in the main rotor disc diverging from its normal…NTSB 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.NTSB WPR10LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tucson, AZA loss of engine power for undetermined reasons.NTSB WPR10LA046Accident · Serious injuriesLimited investigationFinal reportEurocopter AS350BA · Globe, AZThe pilot receiving instruction’s failure to maintain adequate airspeed or control of the helicopter during a simulated hydraulic failure maneuver, which resulted in a hard landing. Contributing to the accident was the flight instructor’s delayed remedial…NTSB 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.NTSB WPR10CA030Accident · No injuriesData collectionFinal reportPiper PA18 · Chandler, AZThe student pilot's failure to maintain directional control while landing.NTSB WPR10CA013Accident · No injuriesData collectionFinal reportCessna 172H · Tucson, AZThe pilot's failure to maintain directional control during the takeoff ground roll.NTSB WPR10LA010Accident · 1 fatalLimited investigationFinal reportCruz SE5A Replica · Phoenix, AZThe pilot's failure to maintain airspeed during initial climb, which resulted in a stall/spin and impact with the ground.NTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.NTSB 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.NTSB WPR09CA410Accident · No injuriesData collectionFinal reportPiper PA28 · Glendale, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB WPR09CA406Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s inadequate compensation for the crosswind condition and failure to maintain directional control during landing.NTSB WPR09FA400Accident · 2 fatalField investigationFinal reportPiper PA-24 · Prescott, AZThe pilot’s failure to maintain an adequate airspeed while maneuvering to return to the runway at a high density altitude, which resulted in an aerodynamic stall.NTSB WPR09LA395Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Glendale, AZA loss of engine power for undetermined reasons.NTSB WPR09CA389Accident · No injuriesData collectionFinal reportEiriavion PIK 20B · Marana, AZA loss of lift that resulted in an off-airport landing.NTSB WPR09CA387Accident · No injuriesData collectionFinal reportBeech 35 · St. Johns, AZThe pilot’s inadequate compensation for the crosswind gust and failure to maintain directional control of the airplane during the takeoff. Contributing to the accident was the gusty crosswind weather conditions.NTSB WPR09LA384Accident · 1 fatalLimited investigationFinal reportBoeing E75 · Happy Jack, AZThe pilot's failure to maintain airspeed while maneuvering which resulted in an inadvertent stall/spin. Contributing to the accident was the high density altitude.NTSB WPR09CA366Accident · Minor injuriesData collectionFinal reportRans S-12 XL Airaile · Marana, AZThe pilot's failure to maintain directional control during takeoff.NTSB WPR09LA327Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Taylor, AZThe loss of engine power for undetermined reasons.NTSB WPR09LA324Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Tucson, AZThe pilot’s failure to maintain directional and lateral aircraft control during takeoff. Contributing to the accident was the partial loss of left engine power for undetermined reasons.NTSB WPR09FA309Accident · 4 fatalField investigationFinal reportBeech B95 · Holbrook, AZThe pilot’s decision to depart when ill and his failure to maintain control of the airplane during a return to the airport, likely because of his physical illness and drug impairment.NTSB WPR09LA308Accident · 2 fatalLimited investigationFinal reportMayo RV-6A · Cottonwood, AZThe partial loss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed, which resulted in an inadvertent stall/spin.NTSB WPR09FA284Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Morristown, AZThe pilot's failure to maintain clearance from the power line.NTSB WPR09LA263Accident · 2 fatalLimited investigationFinal reportLanham Lancair IV · Seligman, AZThe pilot's loss of airplane control during en route descent while operating in known icing conditions.NTSB WPR09LA253Accident · 2 fatalLimited investigationFinal reportGauchat Safari · Rock Springs, AZThe separation of the main rotor head during cruise flight as a result of cyclic fatigue of the main rotor head spindle. The fatigue crack was due to an inadequate manufacturing process.NTSB WPR09CA266Accident · No injuriesData collectionFinal reportCessna 172S · Flagstaff, AZThe student pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control during landing.