NTSB investigations, AZ
8 cases where the first occurrence was “Gear collapsed”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 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\" = 190)
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" = 190) 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 SEA07LA036Accident · No injuriesLimited investigationFinal reportPiper PA 23-235 · Phoenix, AZThe landing gear collapsed for undetermined reasons while the aircraft was standing on the taxiway with the engines operating.NTSB LAX06LA101Accident · No injuriesLimited investigationFinal reportCessna R182 · Bullhead City, AZoverload of the nose landing gear actuator attach bracket resulting in collapse of the nose gear while taxiing. It is undetermined when and under what circumstances the overload occurred.NTSB LAX05LA130Accident · No injuriesLimited investigationFinal reportCessna 421B · Lake Havasu Cit, AZthe fracture of the landing gear shaft roll pin that resulted in a main gear collapse during the taxi.NTSB LAX03LA085Accident · No injuriesLimited investigationFinal reportMooney M20D · Casa Grande, AZCollapse of the landing gear during landing rollout, resulting from the pilot/mechanic's incorrect landing gear locking mechanism (linkage) adjustment.NTSB LAX97LA277Accident · No injuriesLimited investigationFinal reportCessna 310 · Mesa, AZinadequate maintenance inspection of the landing gear system, following a prior incident, due to the mechanic's failure to follow the service manual instructions.NTSB LAX95LA073Accident · No injuriesLimited investigationFinal reportCessna 421C · Chinle, AZthe overload failure of the nose gear trunion for undetermined reasons.NTSB LAX85LA249Accident · No injuriesLimited investigationFinal reportHiller 12-C · Casa Grande, AZThe plt was demonstrating autorotations to a touchdown on a dirt rwy into a 5 kt headwind. On the final landing he said that the touchdown felt the same as others he had done. Speed at touchdown was 15 mph and the helicopter slid forward in a straight line…NTSB LAX84LA240Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Phoenix, AZThe gear was inadvertently retracted at about 50 mph by the pilot in command during landing roll.