NTSB investigations, AZ
287 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 17 |
|---|---|
| 1983 | 8 |
| 1984 | 12 |
| 1985 | 7 |
| 1986 | 11 |
| 1987 | 13 |
| 1988 | 7 |
| 1989 | 7 |
| 1990 | 5 |
| 1991 | 8 |
| 1992 | 10 |
| 1993 | 9 |
| 1994 | 6 |
| 1995 | 9 |
| 1996 | 11 |
| 1997 | 18 |
| 1998 | 14 |
| 1999 | 11 |
| 2000 | 6 |
| 2001 | 14 |
| 2002 | 14 |
| 2003 | 14 |
| 2004 | 15 |
| 2005 | 15 |
| 2006 | 16 |
| 2007 | 10 |
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 LAX08CA041Accident · Minor injuriesData collectionFinal reportFound Acft FBA-2C2 · Holbrook, AZThe pilot's failure to maintain directional control during landing rollout, which resulted in an inadvertent ground loop.NTSB LAX08CA030Accident · No injuriesData collectionFinal reportMaule MX-7-180A · Overgaard, AZThe student pilot's failure to maintain directional control during the landing roll.NTSB LAX08CA011Accident · No injuriesData collectionFinal reportMaule M-5-235-C · Mesa, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB SEA07CA244Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Salome, AZThe pilot's inadequate compensation for the tailwind condition and failure to maintain directional control during the takeoff roll/run, which resulted in a ground loop.NTSB LAX07CA203Accident · Serious injuriesData collectionFinal reportRajhamsa Xair · Pima, AZThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional airplane control during landing rollout.NTSB LAX07CA161Accident · No injuriesData collectionFinal reportAeronca 11AC · Glendale, AZThe private pilot's unstabilized approach and failure to maintain directional control during the landing roll, which resulted in a ground loop. Also causal was the instructor's inadequate supervision and failure to take remedial action.NTSB LAX07CA116Accident · No injuriesData collectionFinal reportCessna 180D · Winslow, AZthe pilot's failure to maintain directional control during landing.NTSB LAX07CA101Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZthe student pilot's failure to maintain directional during the landing rollout and the certified flight instructor's inadequate supervision.NTSB SEA07CA070Accident · No injuriesData collectionFinal reportWaltz Sonex Waiex · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll. The fact that the pilot had only two hours total time in this make and model aircraft was a factor in the accident.NTSB SEA07LA049Accident · No injuriesLimited investigationFinal reportCessna 150A · Cottonwood, AZThe pilot's failure to compensate for a gusty crosswind during the landing roll, which resulted in a loss of control and an on-ground encounter with a ditch. Factors associated with the accident are a crosswind and wind gusts.NTSB LAX07CA044Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Springerville, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during landing. A factor was the crosswind.NTSB LAX07CA038Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Grand Canyon, AZThe pilot's inadequate compensation for the crosswind condition during the landinf roll which resulted in a loss of control and an on ground collision with a berm.and failure to maintain directional control.NTSB LAX07CA030Accident · No injuriesData collectionFinal reportGreat Lakes 2T-1A-2 · Glendale, AZthe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX06CA303Accident · No injuriesData collectionFinal reportCleberg Sportsman 2+2 GS-2 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during landing.NTSB LAX06CA295Accident · No injuriesData collectionFinal reportBeech A36 · Chandler, AZthe student's failure to establish a stabilized approach, which resulted in a bounced landing and a loss of directional control. Also causal was the flight instructor's inadequate supervision of the flight, delayed remedial action, and failure to verbally…NTSB LAX06LA266Accident · 1 fatalLimited investigationFinal reportSaloff Sonerai Iilt · Williams, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB LAX06LA240Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Show Low, AZthe pilot's failure to maintain directional control during landing.NTSB LAX06CA195Accident · No injuriesData collectionFinal reportWaco Classic YMF 5C · Holbrook, AZthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control of the airplane during landing, which resulted in a ground loop.NTSB LAX06CA181Accident · No injuriesData collectionFinal reportCessna 152 · Buckeye, AZthe pilot's failure to maintain directional control during landing.NTSB LAX06CA177Accident · No injuriesData collectionFinal reportCessna 150M · Tucson, AZthe failure of the student pilot to maintain directional control and the certified flight instructor's delayed remedial actions and inadequate supervision of the flight.NTSB LAX06CA144Accident · No injuriesData collectionFinal reportAviat A-1B · Chandler, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout. A contributing factor was the pilot's excessive use of the flight controls.NTSB LAX06CA142Accident · No injuriesData collectionFinal reportAir Tractor 502A · Stanfield, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing roll.NTSB LAX06CA136Accident · No injuriesData collectionFinal reportCessna 172 · Wickenburg, AZthe pilot's failure to maintain directional control.NTSB LAX06CA128Accident · No injuriesData collectionFinal reportCirrus SR22 · Scottsdale, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control.NTSB LAX06CA117Accident · No injuriesData collectionFinal reportCessna 172M · Prescott, AZthe pilot's inadequate compensation for the crosswind conditions and his failure to maintain directional control.NTSB LAX06CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Maricopa, AZThe pilot's failure to maintain directional control during landing rollout. A factor was the soft dirt adjacent to the runway.NTSB LAX06CA042Accident · Minor injuriesData collectionFinal reportCessna A185E · Show Low, AZthe pilot's inadequate compensation for crosswind conditions and failure to maintain directional control, which resulted in a ground loop.NTSB LAX05CA260Accident · No injuriesData collectionFinal reportMaule M-4-220C · Tucson, AZthe pilot's failure to maintain directional control.NTSB LAX05CA256Accident · No injuriesData collectionFinal reportLuscombe 8A · Benson, AZthe non-certificated pilot's failure to maintain directional control during the landing roll.NTSB LAX05LA236Accident · No injuriesLimited investigationFinal reportSergent Great Lakes 2T1A · Phoenix, AZthe pilot's failure to maintain directional control on landing roll, which resulted in a ground loop and nose over of the airplane.NTSB LAX05LA220Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Prescott, AZthe pilot's failure to maintain directional control during the landing rollout.NTSB LAX05CA211Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Phoenix, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB LAX05LA138Accident · No injuriesLimited investigationFinal reportCessna 150F · Prescott, AZthe pilot's failure to maintain directional control on landing.NTSB LAX05CA123Accident · No injuriesData collectionFinal reportPeter A. Geiser Lee/Geiser Nieuprt17 · Chandler, AZThe pilot's inadequate compensation for the gusting crosswind condition and failure to maintain directional control during landing rollout.NTSB LAX05CA121Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's failure to maintain directional control.NTSB LAX05LA116Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Flagstaff, AZthe loss of directional control during landing for undetermined reasons.NTSB LAX05LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Tucson, AZa loss of directional control due to the failure of unknown maintenance personnel to install the tailwheel-locking collar, and the inadequate maintenance inspection of the worn tailwheel steering arm.NTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.NTSB LAX05CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Roosevelt, AZthe pilot's failure to maintain directional control.NTSB LAX05CA067Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB LAX05CA066Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Tucson, AZthe pilot's failure to maintain directional control during landing rollout.NTSB LAX05LA051Accident · No injuriesLimited investigationFinal reportCessna 177RG · Phoenix, AZthe pilot's inadequate compensation for the existing crosswind condition and failure to maintain directional control during landing.NTSB LAX05LA040Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Prescott, AZthe pilot's failure to maintain directional control during landing rollout. A contributing factor in the accident was the pilot's unfamiliarity with the airplane.NTSB LAX05LA013Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Mesa, AZthe student pilot's failure to maintain directional control of the airplane during a touch-and-go takeoff.NTSB LAX05CA005Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Winslow, AZthe pilot's failure to maintain directional control during the landing rollout that resulted in a ground loop.NTSB LAX04CA307Accident · No injuriesData collectionFinal reportChampion 7ECA · Williams, AZThe pilot's inadequate compensation for the wind condition and his failure to maintain directional/airplane control during landing rollout. Contributing factors were the gusty crosswind and the pilot's inadequate remedial action.NTSB LAX04CA286Accident · No injuriesData collectionFinal reportPiper PA-20 · Glendale, AZthe pilot's failure to maintain directional control during the takeoff roll.NTSB LAX04CA250Accident · No injuriesData collectionFinal reportCessna 172S · Glendale, AZthe pilot's failure to maintain directional control of the airplane, which resulted in a veer off the runway and collision with terrain.NTSB LAX04LA266Accident · No injuriesLimited investigationFinal reportLancair LC-40-550FG · Show Low, AZthe pilot's failure to maintain directional control of the airplane during landing after encountering a dust devil.NTSB LAX04CA224Accident · No injuriesData collectionFinal reportCessna 177B · Grand Canyon, AZthe pilot's inadequate compensation for crosswind conditions, which resulted in a loss of directional control.