NTSB investigations, AZ
8 cases where the first occurrence was “Wheels up landing”.
Cases per year
| 1994 | 1 |
|---|---|
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 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\" = 232)
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" = 232) 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 LAX07LA019Accident · No injuriesLimited investigationFinal reportCessna 310N · Lake Havasu Cit, AZthe pilot's failure to extend the landing gear prior to touchdown.NTSB LAX06CA119Accident · No injuriesData collectionFinal reportBeech 95 · Kingman, AZthe flight instructor's failure to perform the before landing checklist and extend the landing gear prior to touchdown. A contributing factor was the pilot's diverted attention with another airplane that had departed from the opposite runway.NTSB LAX06LA034Accident · No injuriesLimited investigationFinal reportBeech H35 · Kingman, AZa touchdown with the gear partially extended. A factor in the accident was an inoperative landing gear warning horn.NTSB LAX04CA303Accident · No injuriesData collectionFinal reportRockwell 112TC · Bullhead City, AZthe pilot's failure to extend the landing gear prior to landing. Factors in the accident were the pilot's failure to use a checklist and to verify that the gear were extended.NTSB LAX02LA236Accident · No injuriesLimited investigationFinal reportCessna TR182 · Yuma, AZthe pilot's failure to properly verify that the landing gear was in the down and locked position.NTSB LAX02LA047Accident · No injuriesLimited investigationFinal reportBeech 95 · Kingman, AZthe pilot's failure to complete and verify the prelanding checklist and extend the landing gear, which resulted in the gear-up landing.NTSB LAX00LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1 · Scottsdale, AZThe pilot's failure to ensure that the landing gear was lowered before touchdown.NTSB LAX95IA011Incident · No injuriesIncident investigationFinal reportCessna 402 · Grand Canyon, AZthe fracture and failure of the left main landing gear bellcrank which jammed the landing gear in the retracted position.