NTSB investigations, AZ
15 cases where the first occurrence was “Main gear collapsed”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2003 | 1 |
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\" = 191)
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" = 191) 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 LAX03LA304Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Prescott, AZThe collapse of the right main gear during the landing roll for undetermined reasons.NTSB LAX00LA188Accident · No injuriesLimited investigationFinal reportCessna 310Q · Mesa, AZthe overload fracture and separation of the right main landing gear attachment.NTSB LAX99LA097Accident · No injuriesLimited investigationFinal reportCessna 414 · Phoenix, AZThe overload failure of the left main gear locking mechanism due to improper system rigging by maintenance personnel.NTSB LAX93LA036Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Phoenix, AZThe dual students premature retraction of the landing gear during the takeoff portion of a touch and go, and, the inadequate supervision of the flight by the instructor pilot. Factors which contributed to the accident were the deactivation of the landing gear…NTSB LAX92LA341Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sedona, AZThe failure of the fixed base operator to properly conduct an annual inspection and inadequate compliance with the airworthiness directive. Contributing to this accident was the total failure of the main landing gear trunion due to fatigue.NTSB LAX92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tucson, AZThe total failure of the landing gear strut (trunnion) due to fatigue. A factor in the accident was related to the inadequately performed recent annual inspection.NTSB LAX90DUJ01Accident · No injuriesFinal reportRoger Nelson Aeronica/T · Sierra Vista, AZThe pilot's inaccurate placement of the aircraft wheels into depressions in a platform mounted on a moving pickup truck during an airshow performance.NTSB LAX87LA086Accident · No injuriesLimited investigationFinal reportSwearingen SA227-AC · Yuma, AZThe left main landing gear retracted after a normal landing and the aircraft swerved off the left side of the runway into the dirt. Crewmembers stated that they observed three green landing gear position lights prior to touch down and that, after the aircraft…NTSB LAX86LA262Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Flagstaff, AZThe pilot stated that, on the landing roll, the right main landing gear collapsed and the right wing was damaged as a result of contact with the runway. The mechanic who examined the aircraft stated that the right landing gear failed to lock, however he was…NTSB LAX84LA141Accident · No injuriesLimited investigationFinal reportCessna 310 · Tucson, AZThe right main landing gear collapsed as the acft was being taxied to the ramp. The plt reported that the acft was traveling about 30 mph during entry into the taxi turn-off area at the time of the accident. Failure occurred in theright rear trunion pin.NTSB LAX84LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Chandler, AZPrior to landing the plt observed that the gear down light for the right gear did not illuminate. He recycled the gear 2 or 3 times, but the green gear down light would not illuminate. Ground personnel reported to the plt that the gear appeared to be down.…NTSB LAX83LA294Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Mesa, AZThe left main landing gear collapsed during landing. The pilot had difficulty getting all the landing gear warning lights to function properly in the pattern. After 1 recycle the gear indicated down but on rollout the left gear collapsed. The pilot feathered…NTSB LAX83FUJ11Accident · No injuriesFinal reportDouglas A26C · Phoenix, AZThe left gear retracted. The modification of the acft for experimental use reduced access to the rudder trim control with the gear selector in the down position. With the selector in neutral, it was possible to apply loads to the gear which removed the gear…NTSB LAX83LA062Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Prescott, AZThe right main landing gear collapsed during the landing roll. On-scene examination revealed that the right main gear was down & locked, but a material failure in the trunnion allowed the gear to rotate out & clockwise leading to collapse. A similarly located…NTSB LAX82DA328Accident · No injuriesFinal reportPiper PA-28-140 · Keyenta, AZLanding gear collapsed during landing roll on a muddy dirt strip.