NTSB investigations, AZ
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
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' 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' 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 WPR12IA296Incident · No injuriesIncident investigationFinal reportCirrus Design SR20 · Deer Valley, AZThe pilot's failure to maintain directional control during taxi due to excessive taxi speed.NTSB WPR12LA247Accident · No injuriesLimited investigationFinal reportPiper PA28R · Peoria, AZA 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 WPR12CA232Accident · No injuriesData collectionFinal reportCessna 172S · Page, AZThe pilot's failure to maintain directional control during the landing flare.NTSB WPR12LA211Accident · No injuriesLimited investigationFinal reportBeech F33A · Mobile, AZThe student pilot's failure to maintain directional control during takeoff.NTSB WPR12CA196Accident · No injuriesData collectionFinal reportCessna 195 · Heber-Overgaard, AZThe pilot's loss of directional control during takeoff roll upon encountering a wind gust.NTSB WPR12FA191Accident · Serious injuriesField investigationFinal reportHughes 269C · Phoenix, AZA loss of tail rotor drive due to a fatigue failure of the main transmission pinion, which resulted in a loss of directional control during cruise flight.NTSB WPR12CA187Accident · No injuriesData collectionFinal reportGlass Roy L RV-6 · Coolidge, AZThe pilot’s loss of directional control during landing.NTSB WPR12LA444Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot's inadequate flare and compensation for gusting wind conditions, which resulted in a bounced landing.NTSB WPR12CA168Accident · Minor injuriesData collectionFinal reportApollo Monsoon · Oro Valley, AZThe pilot’s failure to lower the nose landing gear in time to prevent it from slamming onto the runway and collapsing.NTSB WPR12CA175Accident · No injuriesData collectionFinal reportLuscombe 8E · Winslow, AZThe pilot did not maintain directional control during the landing roll.NTSB WPR12LA165Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · San Manuel, AZThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.NTSB WPR12CA171Accident · No injuriesData collectionFinal reportCessna 172S · Prescott, AZThe pilot's inadequate compensation for a crosswind during takeoff, which resulted in a loss of directional control.NTSB WPR12CA163Accident · No injuriesData collectionFinal reportAvian Balloon Magnum IX · Sedona, AZThe pilot did not maintain adequate clearance during approach for landing between his basket and the envelope of another balloon that was also on approach, which resulted in a midair collision.NTSB WPR12LA152Accident · 2 fatalLimited investigationFinal reportNelson Rans S-12 · Mesa, AZThe pilot’s failure to maintain airplane control while maneuvering at low altitude shortly after takeoff.NTSB WPR12CA151Accident · No injuriesData collectionFinal reportLake LA-4-200 · Lake Havasu City, AZThe pilot did not maintain directional control during a water touchdown.NTSB WPR12CA150Accident · No injuriesData collectionFinal reportArado-Flugzeugwerke FW190 A-5 · Casa Grande, AZThe pilot did not maintain directional control of the airplane during the landing roll.NTSB WPR12LA138Accident · Minor injuriesLimited investigationFinal reportRaven Industries S-66A · Avra Valley, AZThe pilot's improper decision to partially open the balloon's vent before clearing a power line while landing, which resulted in the balloon descending too soon and contacting the power line.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 WPR12LA107Accident · Minor injuriesLimited investigationFinal reportBell AH-1F · Coolidge, AZA flight control malfunction while maneuvering for reasons that could not be determined because postaccident examination revealed no evidence of a mechanical malfunction or failure that would have precluded normal operation.NTSB WPR12FA091Accident · 2 fatalField investigationFinal reportCessna T206H · Show Low, AZThe pilot’s encounter with low clouds/low visibility conditions during the initial climb, which resulted in spatial disorientation and loss of airplane control.NTSB WPR12CA084Accident · Minor injuriesData collectionFinal reportSchweizer SGS 2-33A · Peoria, AZThe glider pilot released from the tow airplane at a lower altitude than the planned altitude, which resulted in an off-airport landing.NTSB WPR12LA076Accident · No injuriesLimited investigationFinal reportPiper PA28 · Phoenix, AZThe pilot’s inability to maintain directional control during the landing roll for reasons that could not be determined because impact damage precluded determination of the preaccident functionality of the braking and steering systems.NTSB WPR12LA074Accident · No injuriesLimited investigationFinal reportCzech Sportplanes Sro Dynamic WT9 · Glendale, AZThe pilot did not shut down the engine upon recognizing a brake malfunction. Contributing to the accident was the airplane's brake malfunction for undetermined reasons.NTSB WPR12FA067Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Phoenix, AZThe pilot's failure to maintain adequate separation behind a corporate jet, which resulted in an encounter with wake turbulence and a subsequent loss of control.NTSB WPR12FA066Accident · Serious injuriesField investigationFinal reportRobinson Helicopter R22 Beta · Tucson, AZA loss of engine power due to the pilot's failure to utilize carburetor heat while maneuvering. .NTSB WPR12FA059Accident · 1 fatalField investigationFinal reportVans RV7 - A · Surprise, AZAn electrical or engine electronic problem, which resulted in a loss of engine power, followed by a low-altitude stall.NTSB WPR12LA047Accident · No injuriesLimited investigationFinal reportCessna 310I · Sedona, AZThe collapse of the right main landing gear after landing for a reason that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and postaccident testing could not be performed due…NTSB WPR12MA046Accident · 6 fatalMajor investigationFinal reportRockwell 690 · Apache Junction, AZThe pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…NTSB WPR12LA039Accident · Serious injuriesLimited investigationFinal reportWilliams Helicopter UH-1H · Grand Canyon, AZThe loss of main rotor power due to a main rotor transmission failure from a lack of lubrication.NTSB WPR12CA038Accident · No injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe student pilot's inadequate directional control during takeoff.NTSB WPR12CA033Accident · No injuriesData collectionFinal reportCasler Scott CX-4 · San Carlos, AZThe pilot's inadequate directional control during takeoff.NTSB WPR12FA031Accident · 3 fatalField investigationFinal reportCessna 182Q · Lake Havasu City, AZThe pilot's continued cruise flight into cloudy conditions at night, which resulted in a loss of airplane control due to spatial disorientation.NTSB WPR12CA016Accident · No injuriesData collectionFinal reportBeech D17S · Phoenix, AZThe pilot's failure to extend the landing gear.NTSB WPR11CA470Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · Chandler, AZThe certified flight instructor's and pilot-undergoing-instruction's improper flare, which resulted in a hard landing.NTSB WPR11CA466Accident · Minor injuriesData collectionFinal reportCessna 172S · Phoenix, AZThe pilot’s failure to maintain directional control during the landing rollout.NTSB WPR11LA444Accident · Minor injuriesLimited investigationFinal reportMaule M-4-220C · Show Low, AZThe pilot’s failure to maintain directional control during the landing, which resulted in a ground loop.NTSB WPR11CA440Accident · No injuriesData collectionFinal reportCessna 172 · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll.NTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.NTSB WPR11CA446Accident · No injuriesData collectionFinal reportCessna 182A · Prescott, AZThe pilot's failure to maintain directional control while taxiing.NTSB WPR11LA375Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-602 · Willcox, AZThe pilot's failure to maintain clearance from a tower while maneuvering at low altitude. Contributing to the accident was the recent installation of the unmarked tower.NTSB WPR11FA354Accident · 2 fatalField investigationFinal reportCirrus SR20 · Fredonia, AZThe non-instrument-rated pilots’ loss of situational awareness during a dark night flight over a remote area, which resulted in their failure to maintain an altitude sufficient to ensure adequate terrain clearnance. Contributing to the accident was the…NTSB WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR11CA357Accident · No injuriesData collectionFinal reportCessna 175 · Greer, AZThe pilot’s improper flare and inadequate recovery from a bounced landing which resulted in a nose gear collapse.NTSB WPR11FA331Accident · 2 fatalField investigationFinal reportMooney M20F · Winslow, AZA loss of engine power due to fuel system contamination, and the pilot’s subsequent failure to maintain an adequate airspeed, which resulted in a loss of control.NTSB WPR11CA328Accident · No injuriesData collectionFinal reportTaylorcraft F-22 · Payson, AZThe pilot's selection of a wrong runway to practice touch-and-go takeoffs and landings.NTSB WPR11CA312Accident · No injuriesData collectionFinal reportCessna 150G · Mesa, AZThe pilot's failure to maintain directional control during the go around.NTSB WPR11LA305Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Nogales, AZThe pilot did not maintain airplane control during the initial climb.NTSB WPR11CA301Accident · No injuriesData collectionFinal reportCessna A185F · Page, AZThe pilot's decision to take off with a gusty quartering tailwind.NTSB OPS11IA686Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-83(MD-83) · Apache Junction, AZThe failure of the pilots of both airplanes to see and avoid each other and to maneuver as advised by the air traffic controller in time to prevent the conflict that resulted in the reported near midair collision.NTSB 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…