NTSB investigations, AZ
17 cases where the first occurrence was “Undershoot”.
Cases per year
| 1982 | 3 |
|---|---|
| 1983 | 3 |
| 1989 | 2 |
| 1993 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2005 | 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\" = 390)
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" = 390) 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 SEA07CA273Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Chandler, AZThe pilot's inadequate compensation for wind conditions while landing, which resulted in an undershoot and an in-flight collision with terrain. Factors associated with the accident were the downdraft, the uneven terrain, and the flight instructor's delayed…NTSB LAX05LA223Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Yuma, AZthe pilot's misjudged distance and altitude, which resulted in an undershoot and collision with a airport boundary fence short of the runway. A factor in the accident was the pilot's lack of familiarity flying the airplane at a high gross weight with a center…NTSB LAX01LA122Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gila Bend, AZFailure of the CFI to properly supervise the flight and the failure of the dual studen to maintain flying airspeed. A contributing factor was the wind shear encountered.NTSB LAX99LA206Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · St. David, AZThe pilot's failure to maintain an adequate reference approach airspeed for the existing gusty wind conditions, and, his improper (uncoordinated) use of the pitch and power controls to arrest the resulting high sink rate.NTSB LAX96LA252Accident · No injuriesLimited investigationFinal reportCessna 402A · Grand Canyon, AZFailure of the pilot to properly judge his altitude during final approach resulting in an undershoot. A factor was a downdraft weather condition.NTSB LAX96LA088Accident · No injuriesLimited investigationFinal reportCessna 150L · Quartzite, AZthe pilot's misjudgement of his distance and altitude relationship to the runway, which resulted in an undershoot and failure to achieve the proper touchdown point for landing.NTSB LAX95LA164Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Peoria, AZthe pilot's misjudged evaluation of the weather, and his inadequate compensation for the gusting winds and downdrafts.NTSB LAX93FA274Accident · 5 fatalField investigationFinal reportCessna T303 · Prescott, AZThe pilot misjudging distance and altitude during a night approach. Factors which contributed to the accident were: the pilot's impairment due to fatigue exacerbated by alcohol consumption, the dark night, and the high density altitude and turbulent weather…NTSB LAX93LA266Accident · No injuriesLimited investigationFinal reportGlenn BD-4 · Somerton, AZThe second pilot's misjudgement of altitude and distance from the runway which resulted in an undershoot, and the pilot-in-command's inadequate supervision in not taking timely corrective action. In addition, neither pilot had any experience in the airplane,…NTSB LAX89LA159Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS125-700 · Scottsdale, AZThe captain misjudged distance and altitude to the runway and allowed the aircraft to touch down just short of the runway lip. The runway lip was a related factor.NTSB LAX89LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZThe failure of the instructor pilot to properly evaluate the weather conditions resulting in an encounter with an unanticipated downdraft condition and failure of the student pilot to maintain a proper descent rate.NTSB LAX83LA259Accident · No injuriesLimited investigationFinal reportCessna 421B · Buckeye, AZThe plt had made 3 night landings at the strip during the past 6 mths. The procedure that had been used for lighting thestrip was to place a vehicle at the west end with the headlights facing east down the centerline of the strip. However, on the night of the…NTSB LAX83LA224Accident · No injuriesLimited investigationFinal reportGoldwing Dragan · Gilbert, AZThe plt/owner had assembled the acft from a kit aprx 1 yr prior to the accident. He reported that the acft was not equipped with brakes. When he returned to land at the ultralight flt park, he decided to make a low, short final apch to decrease the stoppage…NTSB LAX83LA063Accident · Minor injuriesLimited investigationFinal reportCessna 172RG · Sedona, AZWhile enroute, the plt noticed that he had lost his airspeed indication. Observing the pitot head on the wing with a flashlight, he stated that the flip-up cover was down, covering the ram tube. Unable to maintain proper airspeed, the plt inadvertently…NTSB LAX83FA051Accident · Serious injuriesField investigationFinal reportCessna 172N · Casa Grande, AZThe aircraft flew into wires 34 feet above ground 800 feet from the runway at dusk. The wires were marked and both the student pilot and the instructor were aware of them. A no flap landing was being attempted. This was one of several landings made. All…NTSB LAX83FUJ02Accident · 1 fatalFinal reportHobbs B8M · Eloy, AZThe gyrocopter crashed approximately 125 ft short of & 30-45 ft to the right of the rwy threshold during proficiency flying.NTSB LAX82DA115Accident · No injuriesFinal reportCessna 152 · Winslow, AZThe pilot stated that he did a touch and go on runway 29, then pulled the power off at approximately 300 ft AGL over the intersection of runways 29 and 22. He reported that from there, he attempted to land on runway 22 with no power, failed to maintain…