NTSB investigations, AZ
7 cases where the first occurrence was “Forced landing”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 2007 | 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\" = 180)
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" = 180) 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 SEA08LA038Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Yuma, AZFatigue fracture of the control rotor blade spar and failure of maintenance personnel to follow maintenance directives.NTSB LAX87LA104Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Marana, AZDuring a winch tow, the cable prematurely released the glider at approximately 100 to 150 feet. The glider remained in a nose high attitude momentarily then began a shallow descending right turn. At approximately 75 feet the roll, pitch, and descent rate…NTSB LAX86LA197Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Benson, AZA Schempp-Hirth standard Cirrus glider collided with rocks on landing roll in an open field. The pilot stated he was competing in an air meet. While enroute he lost altitude and was unable to regain it. He selected an open field to land in, but did not see…NTSB LAX86LA026Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Flagstaff, AZThe plt reported that while sight-seeing in the vicinity of the grand canyon, he became disoriented and lost. The fuel in the left tank was exhausted and the right fuel tank contained minimum fuel. The pilot negotiated a precautionary landing on the hard…NTSB LAX83LA280Accident · No injuriesLimited investigationFinal reportLet L-13 · Maricopa, AZThe sailplane collided with a small tree and groundlooped during a precautionary landing. The pilot stated the acft had encountered a high sink rate while gliding at 5000 ft. a ridge was between the pilot and the intended route. The pilot elected to land…NTSB LAX83IA257Incident · No injuriesIncident investigationFinal reportDouglas DC-9-31 · Luke Afb, AZWhile descending through 31,600 ft the master caution & the right 'inlet fuel pressure low' lights illuminated. The fuelquantity transfer circuit breaker was found tripped, & when reset the fuel quantity gauges went to zero. An emergency was declared to…NTSB LAX82DA324Accident · No injuriesFinal reportBell 206B · Colorado City, AZThe pilot was demonstrating an autorotation to a company offical. During the flare, when power was applied, the engine did not respond and a hard landing was made. The bendix fuel control was found to be out of limits at certain test points.