NTSB investigations, AZ
6 cases where the first occurrence was “Nose gear collapsed”.
Cases per year
| 1984 | 2 |
|---|---|
| 1986 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2005 | 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\" = 192)
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" = 192) 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 LAX06CA020Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Prescott, AZThe nose landing gear collapsing during the landing roll for undetermined reasons.NTSB LAX98LA088Accident · No injuriesLimited investigationFinal reportCessna 182P · Payson, AZThe collapse of the nose landing gear for undetermined reasons.NTSB LAX96LA055Accident · No injuriesLimited investigationFinal reportSchafer Lancair 360 · Mesa, AZfailure of the nose gear strut, during landing.NTSB LAX86LA166Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Mesa, AZThe pilot lost control of the aircraft which traveled off the runway following a nose gear collapse during landing. Examination of the aircraft revealed evidence of side loading.NTSB LAX84LA490Accident · No injuriesLimited investigationFinal reportCessna 411 · Dolan Springs, AZAfter lndg, the plt was taxiing back up the rwy to a parking area when the nose wheel 'fell into' a sand filled depression in the surface, collapsing the nose gear. County maintenance personnel had graded the rwy surface after heavy rains but no compaction…NTSB LAX84LA408Accident · Minor injuriesLimited investigationFinal reportNesmith Cougar 1 · Williams, AZWhile en route, the plt elected to land at the Williams muni arpt for a rest stop. He noted that rwy 2/20 was closed; however, he observed what appeared to be a new gravel strip, oriented north/south & an airplane on the arpt. The plt assumed the arpt was…