NTSB investigations, UT
10 cases where NTSB found Climb rate.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2015 | 1 |
| 2017 | 2 |
| 2021 | 2 |
| 2023 | 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\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01062035'))
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" = 'UT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01062035')) 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 WPR23LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Cedar Mountain, UTThe pilot’s decision to depart with a high density altitude, which degraded the airplane’s climb performance and resulted in an impact with trees.NTSB WPR21FA321Accident · 3 fatalClass 3 · FieldFinal reportCessna 182H · Bountiful, UTThe decision of both pilots to fly into a steep canyon, which resulted in the airplane being unable to maintain a sufficient altitude to clear rising terrain. Contributing to the accident was their delayed initial action in responding to the hazard, and their…NTSB WPR21LA319Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Panguitch, UTThe airplane’s inability to maintain altitude during the initial climb due to a degradation in the airplane’s performance due to high-density altitude conditions. Contributing to the accident was the pilot’s failure to conduct preflight performance planning…NTSB GAA17CA517Accident · No injuriesData collectionFinal reportJeff Jardine Kitfox S7 Supersport · Kanab, UTThe pilot's failure to maintain directional control during landing and the airplane’s subsequent failure to attain a climb rate during an attempted go-around in high-density altitude conditions.NTSB WPR17LA183Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA 28R-200 · West Jordan, UTThe pilot's failure to account for operation at high density altitude at or near the airplane’s maximum gross weight, which led to degraded engine performance and prevented the airplane from achieving an adequate airspeed for a positive rate of climb,…NTSB GAA15LA131Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Escalante, UTThe pilot’s inadequate preflight planning and his subsequent decision to attempt to climb over rising terrain with the helicopter over maximum gross weight while operating in high-density altitude conditions with a tailwind, which resulted in its inability to…NTSB WPR10CA320Accident · No injuriesData collectionFinal reportCessna 175 · Huntsville, UTThe pilot's failure to maintain adequate clearance from terrain during climb.NTSB WPR10CA146Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20-C1 · Delta, UTThe student pilot's incorrect use of the flaps and failure to attain and maintain an adequate airspeed during the attempted go-around procedure, which led to a stall/mush condition. Contributing to the accident was the student pilot's lack of familiarity with…NTSB WPR09CA105Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 II · Bountiful, UTThe pilot's improper decision to fly at low altitude while maneuvering in mountainous terrain in a canyon and inadvertently exceeding the climb capability of the helicopter. Contributing to the accident were a high density altitude, mountainous terrain, and a…NTSB WPR09LA043Accident · 1 fatalLimited investigationFinal reportCessna 170B · Hanna, UTThe flight's encounter with adverse tailwinds and downdrafts in mountainous terrain that exceeded the airplane's climb capability.