NTSB investigations, UT
14 cases where NTSB found Experience/qualifications.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 3 |
| 2011 | 2 |
| 2012 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2022 | 1 |
| 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\", '020310'))
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", '020310')) 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 WPR23LA194Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2300 · Spanish Fork, UTThe pilot's decision to attempt an unfamiliar takeoff technique, his failure to maintain pitch control during takeoff, and his subsequent decision to retract flaps at a low altitude, which resulted in a descent into a building.NTSB WPR22FA227Accident · 2 fatalClass 3 · FieldFinal reportCessna 152 · Mendon, UTThe flight instructor’s failure to recover from a developed spin, which resulted in impact with terrain. Contributing to the accident was the flight instructor’s decision to enter the maneuver below the operator’s altitude limitation.NTSB GAA19CA359Accident · Minor injuriesData collectionFinal reportAutogyro Cavalon · Nephi, UTThe pilot's insufficient rudder input during takeoff, which resulted in a loss of yaw control and a hard landing.NTSB WPR18LA217Accident · 1 fatalLimited investigationFinal reportSmith Hornet · St. George, UTThe pilot's loss of airplane control during takeoff due to an unexpected gust of wind.NTSB WPR18FA095Accident · 4 fatalField investigationFinal reportPiper PA32R · Monticello, UTThe noninstrument-rated pilot's continued flight into a region of deteriorating ceiling and visibility conditions, which resulted in controlled flight into terrain event.NTSB WPR17LA098Accident · Serious injuriesLimited investigationFinal reportRobert E Bounds Bounds Bearcoupe · Hanksville, UTThe flight instructor's failure to maintain airplane control during landing when he inadvertently applied brake pressure to the toe brakes when the airplane touched down.NTSB GAA17CA073Accident · No injuriesData collectionFinal reportCarter Richard L Buddy Baby Lakes · Hurricane, UTThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion.NTSB WPR12FA235Accident · 4 fatalField investigationFinal reportCirrus SR20 · Duck Creek Village, UTThe pilot's failure to maintain sufficient airspeed and airplane control while maneuvering a heavily loaded airplane over high mountainous terrain in a high density altitude environment. Contributing to the accident was the pilot’s lack of experience…NTSB WPR11LA270Accident · 1 fatalLimited investigationFinal reportSix Chuter Skye Ryder Aerochute · Tooele, UTThe operation of a powered parachute by a non-certificated pilot. Contributing to the accident was the pilot's decision to conduct a flight in a strong gusty wind.NTSB WPR11LA151Accident · No injuriesLimited investigationFinal reportBell 206B-III · Tooele, UTThe pilot did not maintain yaw control of the helicopter during a maneuvering hover. Contributing to the accident was the pilot’s lack of experience in the make and model helicopter.NTSB WPR10FA315Accident · 1 fatalField investigationFinal reportAero Commander CallAir · Salt Lake City, UTThe pilot’s failure to maintain airspeed, which resulted in a stall/spin to the ground.NTSB WPR10LA292Accident · 1 fatalLimited investigationFinal reportAir Creation GTE · Springville, UTThe pilot's inadequate preflight planning and his failure to maintain clearance from obstacles during takeoff. Contributing to the accident was the pilot's lack of experience.NTSB WPR10CA129Accident · No injuriesData collectionFinal reportMaule M-5-235C · Kelton, UTThe non-instrument-rated pilot's decision to take off and fly into marginal weather conditions.NTSB LAX08TA116Accident · No injuriesFinal reportHughes TH-55 · Logan, UTThe pilot's inadequate compensation for the wind conditions and failure to maintain control of the helicopter while hovering. Contributing to the accident were the wind gusts and the pilot's lack of recent experience in helicopters.