NTSB investigations, AZ
52 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2010 | 4 |
| 2011 | 6 |
| 2012 | 1 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 2 |
Where
Open the mapLatest 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '096' 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" = '096' 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 WPR26LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Carefree, AZThe pilot reported that he landed the tailwheel equipped airplane at a backcountry airstrip, and while taxiing on rough terrain, the tailwheel spring failed and the tailwheel assembly separated from the airplane. The pilot shut down the airplane and exited to…NTSB WPR26LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 172E · Kingman, AZThe pilot’s failure to use a pre-takeoff checklist, which resulted in the fuel selector being in the off position, and subsequent loss of engine power during takeoff.NTSB WPR26LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 185C · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll with a left crosswind.NTSB WPR25LA148Accident · No injuriesClass 3 · LimitedPreliminary reportRutan LONG-EZE · Tucson, AZOn May 1, 2025, about 1030 mountain standard time, an experimental amateur-built Long EZE, N433EZ, was substantially damaged when it was involved in an accident near Tucson, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code of…NTSB WPR25LA070Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV-7A · Gila Bend, AZA disconnection of the mixture control linkage during flight, which resulted in fuel starvation and a total loss of engine power. Contributing was the inadequate inspection of the mixture control arm attachment hardware.NTSB WPR25LA044Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Show Low, AZThe pilot’s failure to maintain directional control during the takeoff.NTSB WPR23LA241Accident · No injuriesClass 3 · LimitedFinal reportCessna 172K · Marana, AZA total loss of engine power due to fuel exhaustion.NTSB WPR23LA195Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1B · Mobile, AZThe pilot’s failure to maintain directional control during landing, resulting in a runway excursion and nose over.NTSB WPR23LA015Accident · No injuriesClass 4 · LimitedFinal reportAeroprakt Manufacturing SP Zoo A22LS · Prescott, AZThe pilot’s loss of directional control during landing with a wind gust, which resulted in a runway excursion and nose over.NTSB WPR22LA318Accident · No injuriesClass 4 · LimitedFinal reportLeon E Everett Carbon CUB EX · Maricopa, AZThe pilot's failure to maintain airplane control during landing with a crosswind and the use of excessive braking application, which resulted in a nose over.NTSB WPR21LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150E · Marana, AZThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR20LA115Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Sedona, AZThe pilot’s loss of pitch control while landing in crosswind conditions, which resulted in a collapsed nose gear and departure of the airplane from the runway.NTSB 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.NTSB GAA19CA309Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 · Sedona, AZThe pilot's failure to maintain pitch control during landing in gusting wind conditions, which resulted in a nose-over.NTSB WPR19LA070Accident · No injuriesClass 3 · LimitedFinal reportHill Group CCX-2000 · Roll, AZThe loss of engine power due to a fatigue failure of the crankshaft for reasons that could not be determined based on the available information.NTSB GAA19CA112Accident · No injuriesData collectionFinal reportZlin Savage · Prescott, AZThe pilot's failure to maintain directional control during the landing roll with a tailwind.NTSB GAA19CA057Accident · No injuriesData collectionFinal reportAviat A1 · Red Creek, AZThe pilot's improper brake application during landing on a soft, dirt airstrip, which resulted in a nose-over.NTSB GAA18CA338Accident · No injuriesData collectionFinal reportLuscombe 8 · Phoenix, AZThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB GAA18CA298Accident · No injuriesData collectionFinal reportGarcia Benigno Baby ACE D · St. Johns, AZThe pilot’s failure to maintain directional control during landing in gusting, quartering tailwind conditions.NTSB GAA18CA180Accident · Minor injuriesData collectionFinal reportAnderson Darrell L Starduster TOO · Tucson, AZThe failure of the left main landing gear axle weld during the landing roll.NTSB GAA18CA141Accident · No injuriesData collectionFinal reportCessna 172 · Show Low, AZThe flight instructor’s failure to maintain directional control during the landing roll in gusting crosswind and tailwind conditions.NTSB GAA17CA370Accident · Minor injuriesData collectionFinal reportAero-Ace CE 1 · Cottonwood, AZThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB GAA17CA292Accident · Minor injuriesData collectionFinal reportAirtime Cygnet · Casa Grande, AZThe flight instructor's failure to maintain directional control during takeoff in gusting crosswind conditions.NTSB GAA17CA214Accident · Minor injuriesData collectionFinal reportRonald J Bender Baking Duce · Willcox, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll after encountering a dirt devil.NTSB WPR17LA053Accident · Serious injuriesClass 3 · LimitedFinal reportCessna T210 · Buckeye, AZThe pilot's failure to maintain directional control of the airplane during the landing roll.NTSB GAA16CA404Accident · No injuriesData collectionFinal reportCessna 177 · Wickenburg, AZThe pilot's incorrect balked landing procedure, which resulted in an uncontrolled descent, hard landing, a runway excursion, and nose gear collapse.NTSB WPR16LA079Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Fountain Hills, AZA partial loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA037Accident · No injuriesData collectionFinal reportJabiru Jabiru - SP · Surprise, AZThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR15LA130Accident · Minor injuriesLimited investigationFinal reportVans RV6A · Green Valley, AZThe total loss of engine power during initial climb due to the disconnection of both fuel pump power wires.NTSB WPR14CA266Accident · No injuriesData collectionFinal reportLuscombe 8A · Tucson, AZThe student pilot's use of excessive brakes during taxi, which resulted in a loss of aircraft control.NTSB WPR14CA107Accident · No injuriesData collectionFinal reportCessna 170 · Wikieup, AZThe pilot's failure to maintain clearance from terrain during takeoff.NTSB WPR14LA046Accident · No injuriesLimited investigationFinal reportRovey Jason H RV-8 · Wickenburg, AZThe fatigue failure of a propeller pitch change pin due to excessive shot peening of the pin’s surface during the manufacturing process.NTSB WPR13LA408Accident · No injuriesLimited investigationFinal reportCessna 182A · Casa Grande, AZA loss of engine power during final approach for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation.NTSB WPR13LA351Accident · Minor injuriesLimited investigationFinal reportStribling RV4 · San Manuel, AZThe pilot’s loss of directional control during takeoff with a tailwind, which resulted in a runway excursion.NTSB 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.NTSB WPR13CA097Accident · No injuriesData collectionFinal reportCessna 140 · Tucson, AZThe pilot’s failure to maintain directional control during the landing roll and his excessive application of brakes, which resulted in a noseover.NTSB WPR12LA135Accident · Minor injuriesLimited investigationFinal reportCook Smith AVN Replica SU · St. Johns, AZThe pilots’ failure to maintain directional control when the right brake locked up during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR12CA038Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student pilot's inadequate directional control during takeoff.NTSB WPR11CA312Accident · No injuriesData collectionFinal reportCessna 150G · Mesa, AZThe pilot's failure to maintain directional control during the go around.NTSB 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.NTSB WPR11CA224Accident · No injuriesData collectionFinal reportMaule M7 · Mammoth, AZThe pilot's failure to maintain clearance from a tree during the landing roll.NTSB WPR11LA211Accident · No injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's inadequate directional control during the landing roll.NTSB WPR11CA106Accident · No injuriesData collectionFinal reportCessna 180 · Prescott, AZThe pilot's loss of airplane control during the landing roll.NTSB WPR10LA426Accident · No injuriesLimited investigationFinal reportGrob-Werke G 120A · Buckeye, AZThe student pilot's improper flare, which resulted in a hard landing.NTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.NTSB WPR10CA233Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Lake Havasu City, AZThe student pilot's failure to maintain aircraft control during a go-around, resulting in a stall/mush.NTSB WPR10LA166Accident · Serious injuriesLimited investigationFinal reportKjonaas Varieze · Casa Grande, AZA loss of engine power during cruise flight due to fuel exhaustion.NTSB WPR09CA285Accident · No injuriesData collectionFinal reportCessna 175A · Polacca, AZThe pilot’s failure to adequately estimate the required distance to avoid obstructions while taking off from a road.NTSB WPR09CA199Accident · No injuriesData collectionFinal reportCessna A185F · Bisbee, AZThe flight instructor's inadequate supervision of the flight and inadequate recovery from a bounced landing.NTSB WPR09CA127Accident · No injuriesData collectionFinal reportCub Crafters PA-18-150 · Buckeye, AZThe pilot's failure to maintain directional control.