NTSB investigations, AZ
113 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 8 |
|---|---|
| 1983 | 5 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 6 |
| 1987 | 6 |
| 1988 | 6 |
| 1989 | 10 |
| 1990 | 4 |
| 1991 | 5 |
| 1992 | 2 |
| 1993 | 6 |
| 1994 | 3 |
| 1995 | 6 |
| 1996 | 2 |
| 1997 | 3 |
| 1998 | 3 |
| 1999 | 4 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 8 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
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" = 220) 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 LAX07LA281Accident · Minor injuriesLimited investigationFinal reportEurocopter France EC 130 B4 · Meadview, AZCollision with a bird during cruise flight.NTSB LAX07LA137Accident · No injuriesLimited investigationFinal reportRiesland Fly Baby 1 · Grand Canyon, AZThe pilot's failure to maintain clearance from a fence during landing.NTSB LAX07LA025Accident · 2 fatalLimited investigationFinal reportOlson Vans RV-6 · Rio Verde, AZThe pilot's failure to maintain clearance from power lines while intentionally flying at a low altitude.NTSB LAX07LA017Accident · 2 fatalLimited investigationFinal reportWilson Quicksilver Sport 2S · Buckeye, AZFailure of the pilot to maintain adequate clearance from obstacles.NTSB LAX06LA006Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R-22 Beta II · Eagar, AZThe pilots' inadequate in-flight planning, which led the helicopter toward rising terrain in excess of the performance capability of the helicopter. Contributing factors were the high density altitude, and the rapidly rising terrain.NTSB LAX05FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Marana, AZthe failure of the pilot to maintain an adequate altitude and clearance from obstructions that resulted in an in-flight collision with power lines.NTSB LAX04CA121Accident · No injuriesData collectionFinal reportBell 47-G3B2 · Salome, AZthe pilot's failure to maintain an adequate clearance from trees while approaching the landing zone.NTSB LAX03CA296Accident · No injuriesData collectionFinal reportCessna 182K · Young, AZthe collision with a bull during takeoff.NTSB LAX03LA240Accident · Minor injuriesLimited investigationFinal reportCessna 180C · Punkin Center, AZThe pilot's inadequate preflight planning and failure to attain adequate climb rate to ensure clearance from obstacles. The tailwind and high density altitude were factors.NTSB LAX03TA229Accident · No injuriesFinal reportSikorsky S-64E · Tucson, AZthe pilot's failure to maintain tail rotor clearance while hovering resulting in a tail rotor blade strike.NTSB LAX03LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-301T · Paulden, AZthe pilot's failure to attain and maintain the proper climb airspeed. The high density altitude condition was a factor.NTSB LAX03LA139Accident · 1 fatalLimited investigationFinal reportAero Commander 200D · Corona De Tucso, AZThe pilot's failure to maintain an adequate clearance from obstructions while performing low level passes. The pilot's physical impairment due to a high blood alcohol level was also causal.NTSB LAX03LA122Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Avondale, AZThe pilot failed to maintain adequate visual lookout and did not maintain clearance from power lines. The backhoe's location, which caused the pilot to alter his planned flight path, was a factor.NTSB LAX03LA104Accident · No injuriesLimited investigationFinal reportTowner Kit Fox 4 · Glendale, AZthe propeller's separation in-flight as a result of a bird strike.NTSB LAX03LA080Accident · No injuriesLimited investigationFinal reportBeech S-35 · Quartzsite, AZThe driver of the vehicle did not stop prior to crossing the airstrip as directed by airstrip signage.NTSB LAX03FA054Accident · 2 fatalField investigationFinal reportRobinson R22 Beta · Dolan Springs, AZthe pilot's inadequate visual lookout and failure to maintain clearance from power lines. A factor was the pilot's decision to conduct cruise flight at a low altitude.NTSB ANC03LA015Accident · 1 fatalLimited investigationFinal reportBell 206B · Kingman, AZThe pilot's failure to maintain altitude/clearance from obstacles during cruise flight, which resulted in the helicopter striking a transmission line, and subsequently the ground.NTSB LAX03LA027Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS350B · Kingman, AZthe pilot's inadequate visual lookout and failure to maintain adequate clearance from transmission wires while performing low altitude operations.NTSB LAX01LA286Accident · 1 fatalLimited investigationFinal reportCessna 172L · Tucson, AZthe pilot's controlled descent into a residence for undetermined reasons.NTSB LAX01LA300Accident · Serious injuriesLimited investigationFinal reportCessna 182G · Cottonwood, AZThe pilot's failure to obtain/maintain a proper descent rate, as well as prematurely starting his decent during nighttime operations, subsequently colliding with 60-foot power lines 4 miles from the airport.NTSB LAX01FA049Accident · 1 fatalField investigationFinal reportBeech BE-55-D55 · Clifton, AZthe pilot's improper in-flight decision to attempt a landing on an unlit runway at night, and his failure to maintain the proper glide path and clearance from obstacles while on final approach, which resulted in the collision with a utility pole. A…NTSB LAX99LA229Accident · Serious injuriesLimited investigationFinal reportAerostar Rally RX-7 · Prescott Valley, AZThe pilot's inadequate visual lookout and subsequent failure to maintain adequate clearance with the wires.NTSB LAX99FA199Accident · 1 fatalField investigationFinal reportCessna 180J · Wickenburg, AZThe pilot's failure to maintain altitude/clearance from ground obstacles. A factor was the pilot's diverted attention in this accident.NTSB LAX99LA107Accident · 1 fatalLimited investigationFinal reportWeatherly 620B · Yuma, AZThe pilot's failure to maintain an adequate clearance from the power lines during an aerial application flight. A factor in the accident was the dark night lighting conditions.NTSB LAX99LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Arlington, AZThe flight instructor's inadequate supervision of his student and his failure to initiate timely remedial action. Contributing factors were the student's failure to maintain the proper glidepath under the existing downdraft condition, the flight instructor's…NTSB LAX99LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Payson, AZthe pilot's failure to maintain runway alignment during a go-around.NTSB LAX98LA227Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Sedona, AZThe failure of the pilot to maintain a visual clearance with the trees.NTSB LAX98FA066Accident · 2 fatalField investigationFinal reportCessna 172M · Chandler, AZThe pilot's intentional flying at a low altitude and failure to see and avoid the power lines during dusk conditions.NTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.NTSB LAX98FA013Accident · No injuriesField investigationFinal reportBeech 99-C99 · Meadview, AZThe pilot's inadequate in-flight decision, inadequate visual lookout, and his failure to maintain adequate obstacle clearance. Contributing was low altitude flight.NTSB LAX97LA287Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Marana, AZThe pilot's in-flight planning/decision to continue his flight after striking a fence, and his inability to attain the proper climb rate, which subsequently led to the in-flight collision with the transmission power line.NTSB LAX96TA186Accident · No injuriesFinal reportHughes 369 · Yuma, AZfailure of the pilot to maintain altitude and/or clearance from obstacles, while maneuvering a low altitude at night. Factors relating to the accident were: darkness and the lack of visual cues.NTSB LAX96FA106Accident · 4 fatalField investigationFinal reportConvair C-131E · Saint Johns, AZinadequate preflight planning and preparation by the first pilot (PIC), his failure to ensure the aircraft was properly loaded within limitations, his failure to use proper flaps for takeoff, his failure to use ADI assisted takeoff, and his resultant failure…NTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.NTSB FTW95FA349Accident · 4 fatalField investigationFinal reportCessna 172D · Tsaile, AZThe pilot's failure to maintain terrain clearance. Factors were the pilot's lack of mountain flying experience and the rising terrain.NTSB LAX95LA154Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Stanfield, AZthe pilot's failure to maintain an adequate visual lookout for, and clearance from, obstacles while conducting simulated aerial application operations.NTSB LAX95LA135Accident · 2 fatalLimited investigationFinal reportCessna 180 · Winslow, AZThe pilot's poor judgement by intentionally deciding to buzz.NTSB LAX95LA106Accident · No injuriesLimited investigationFinal reportBurkhart Grob Twin Astir · Fort Huachuca, AZImproper in-flight planning/decision by the pilot, which resulted in his failure to remain clear of tree(s) during an off-airport landing. Factors related to the accident were: lack of thermal lift, and high obstructions in the off-airport landing area.NTSB LAX95LA075Accident · No injuriesLimited investigationFinal reportKaman HH43 · Glendale, AZThe pilot's failure to maintain an adequate visual lookout to avoid a collision with a tree during an aerial application swath run.NTSB LAX94LA326Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Chinle, AZthe pilot's premature liftoff, and his failure to attain the appropriate airspeed during a takeoff attempt under high density altitude conditions.NTSB LAX94LA255Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dateland, AZThe pilot's inadequate preflight planning and his failure to maintain an adequate visual lookout for obstacles. Night lighting conditions and the dust were factors in the accident.NTSB LAX94LA090Accident · 1 fatalLimited investigationFinal reportBell 206B · Coolidge Dam, AZthe pilot's selection of a cruise altitude insufficient to ensure adequate obstacle clearance and his inadequate visual lookout. A factor in the accident was the inconspicuousness of the power lines.NTSB LAX94LA082Accident · 2 fatalLimited investigationFinal reportCessna 175 · Peoria, AZthe pilot's failure to attain sufficient altitude following takeoff. A factor in the accident was the pilot's failure to use all available runway for takeoff.NTSB LAX93LA331Accident · Serious injuriesLimited investigationFinal reportUltimate 10-80 · Chandler, AZThe noncertificated pilot's failure to follow the prescribed VFR procedures and poor visual lookout. The other aircraft pilot's restricted visual lookout was a factor in this accident.NTSB LAX93FA316Accident · Serious injuriesField investigationFinal reportBell 206L1 · Tusayan, AZFailure of the pilot of N444CR to maintain adequate main rotor clearance from N38903, and the operator's failure to provide adequate or recommended safe helipad dimensions. A factor in the accident was the lack of visual reference to the rotating blades of…NTSB LAX93LA290Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Buckeye, AZthe pilot's failure to visually detect and avoid a power line. A factor in the accident was the twilight light condition.NTSB LAX93LA283Accident · No injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Phoenix, AZThe pilot's inadequate planned approach to the landing area.NTSB LAX93LA162Accident · No injuriesLimited investigationFinal reportPiper J3 · Buckeye, AZThe pilot's inadequate visual look-out and failure to maintain clearance from the wires. Lack of experience in the geographical (airport) area was a factor.NTSB LAX93LA003Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Three Points, AZThe pilot's poor judgment, intentional buzzing, and poor visual lookout. Contributing to this accident was the pilot's diverted attention.NTSB LAX92FA135Accident · 2 fatalField investigationFinal reportCessna 150 · Williams, AZThe pilot inadequately evaluating the weather condition, and the pilot's inflight decision to continue flight into adverse weather conditions. Factors in this accident were the pilot's visual lookout ability being restricted by the prevailing weather…