NTSB investigations, AZ

9 cases where NTSB found Power plant.

Cases per year

20082026
NTSB investigations, AZ per year, 2008–2026: 9 cases
20082
20111
20162
20191
20201
20221
20231

Latest 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010571'))
  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 WPR24LA029Accident · Serious injuriesClass 3 · LimitedFinal reportAerostar International RX 8 · Page, AZA hard landing after both burner pilot lights extinguished during the landing approach for undetermined reasons. Contributing to the accident was the pilot's inability to relight the burner pilot lights.Nov 4, 2023 · N50466 · No damageNTSB WPR23LA060Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 177 · Willow Spring, AZThe airplane’s loss of engine power for undetermined reasons.Nov 27, 2022 · N2994X · Substantial damageNTSB WPR20LA144Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Phoenix, AZA total loss of engine power due to oil starvation for reasons that could not be determined due to a lack of available evidence, which resulted in impact with terrain during a subsequent forced landing.May 13, 2020 · N201HH · Substantial damageNTSB WPR20LA040Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV 6 · Pima, AZA total loss of engine power for reasons that could not be determined based on the available evidence.Dec 5, 2019 · N616RV · Substantial damageNTSB WPR17LA004Accident · Serious injuriesClass 3 · LimitedFinal reportRockwell International 112A · Phoenix, AZA catastrophic engine failure due to lack of lubrication due to the absence of 2 piston cooling nozzles that backed out of their respective threaded bores, which resulted in a forced landing on unsuitable terrain.Oct 12, 2016 · N509CA · Substantial damageNTSB WPR16LA179Accident · No injuriesClass 3 · LimitedFinal reportMccluskey Challenger II · Bisbee, AZA total loss of engine power for reasons that could not be determined based on the available information.Sep 10, 2016 · N6162Y · Substantial damageNTSB WPR11LA313Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Flagstaff, AZFatigue failure of an engine mount attachment foot, which resulted in collapse of the nose landing gear during landing. Contributing to the accident was the failure of the owner/operator to adhere to the manufacturer's suggested engine mount inspection…Jun 26, 2011 · N9246M · Substantial damageNTSB LAX08LA098Accident · Minor injuriesLimited investigationFinal reportNorth American T-28C · Kingman, AZA total loss of engine power during cruise flight due to an undetermined catastrophic internal engine failure.Apr 11, 2008 · N9022N · 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 damage