NTSB investigations, AZ

58 cases where the sequence of events included Attempted remediation/recovery.

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\" = '060' 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 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 WPR11CA243Accident · No injuriesData collectionFinal reportBell 206B3 · Glendale, AZThe certified flight instructor's failure to maintain adequate main rotor RPM during the autorotation.May 27, 2011 · N59383 · Substantial damageNTSB WPR11CA031Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Prescott, AZThe student pilot's failure to maintain the proper airspeed and the certificated flight instructor's inadequate supervision and delayed remedial action during a practice autorotation, which resulted in a hard landing and rollover.Oct 29, 2010 · N844SH · Substantial damageNTSB OPS10IA015Incident · No injuriesIncident investigationFinal reportCessna 208B · Phoenix, AZThe Cessna 208 pilot’s failure to identify the correct landing runway.Mar 20, 2010 · N992FE · 2 aircraft · No damageNTSB WPR10CA028Accident · No injuriesData collectionFinal reportEurocopter AS 350 B3 · Marana, AZThe improper use of the throttle by the pilot receiving instruction, and the check pilot's inadequate supervision and delayed remedial action, which resulted in the collision with terrain.Oct 22, 2009 · N105LN · Substantial damageNTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.Mar 30, 2009 · N74815 · Substantial damageNTSB DEN08IA160IncidentIncident investigationFinal reportRaytheon Cobra · Whetstone, AZA total off of engine power resulting from an overheated piston, and the pilot's subsequent failure to send a proper command to the UAS. Contributing to the accident was the operation of the engine at high power for an extended period with a lean fuel setting.Sep 24, 2008 · N602RN · DestroyedNTSB LAX08FA092Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Benson, AZThe pilot's misjudged speed and altitude during approach that led to a long landing and his subsequent failure to maintain control during an attempted go-around. Contributing to the accident were the dark night, the pilot's low total night flight experience,…Apr 3, 2008 · N20480 · Substantial damage