NTSB investigations, UT
20 cases where NTSB found Runway/land/takeoff/taxi surface.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2022 | 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\" = '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\", '030230'))
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", '030230')) 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 WPR23LA053Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · Morgan, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low attitude. Contributing to the accident was the pilot’s loss of visual reference due to snow and flat light conditions.NTSB WPR22LA208Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Fort Duchesne, UTThe pilot’s decision to takeoff from an unimproved surface which resulted in a collision with an object and the airplane nosing over.NTSB GAA19CA199Accident · No injuriesData collectionFinal reportBeech 36 · Monument Valley, UTThe pilot's failure to maintain directional control and runway heading during landing, which resulted in a runway excursion and the nose landing gear collapsing.NTSB GAA19CA125Accident · No injuriesData collectionFinal reportPiper PA 12 · Cedar City, UTThe pilot's failure to maintain pitch control while conducting a touch-and-go landing on an unimproved, snow-covered airstrip, which resulted in a nose-over.NTSB GAA19CA077Accident · No injuriesData collectionFinal reportScott Taylor Eclipse 10 · Kanab, UTThe pilot's failure to maintain directional control during takeoff from an unimproved dirt road.NTSB GAA18CA057Accident · No injuriesData collectionFinal reportKarpayev Vladyslav V RV-9 · Moab, UTThe pilot’s selection of an unsuitable taxiway, which resulted in the wings striking hidden fence posts.NTSB WPR16LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Boulder, UTThe pilot's failure to abort the takeoff from the soft runway surface, which precluded optimal acceleration during the takeoff sequence.NTSB GAA16CA120Accident · Minor injuriesData collectionFinal reportCessna 210 · Park Valley, UTThe pilot's decision to drag the left main landing gear on a snow covered dry lake bed, which resulted in a loss of directional control and a nose over during an aborted landing.NTSB WPR14LA113Accident · No injuriesLimited investigationFinal reportBell 206 · Bountiful, UTThe pilots' inaccurate assessment of the snow depth on the landing zone, which resulted in a landing on snow deeper than that for which the helicopter was equipped and led to dynamic rollover.NTSB WPR13CA068Accident · No injuriesData collectionFinal reportRobinson R22 · Logan, UTThe flight instructor’s delayed remedial action and inadequate supervision during a practice autorotation, which resulted in a failure to maintain adequate main rotor rpm. Contributing to the accident was the wet landing surface.NTSB WPR11CA449Accident · No injuriesData collectionFinal reportCessna 172M · Wendover, UTThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB WPR11LA058Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Salt Lake City, UTThe tug driver’s loss of airplane control during pushback due to a loss of traction in slippery conditions on the ramp. Contributing to the accident was the ground crews’ and airline operators’ inadequate guidance with regard to pushback procedures during low…NTSB WPR10LA092Accident · No injuriesLimited investigationFinal reportCessna 402C · Moab, UTThe pilot's decision to depart on a snow covered runway, which resulted in a loss of control and encounter with terrain. Contributing to the accident was the airport manager's failure to adhere to the Airport Certification Manual and close the runway due to…NTSB LAX08CA248Accident · No injuriesData collectionFinal reportBristol Titan Tornado II · Green River, UTThe encounter with rough terrain during an off-field precautionary landing.NTSB SEA08LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · East Carbon, UTThe pilot's inadequate in-flight planning and decision to continue flight into a canyon area with questionable aircraft performance. Contributing to the accident was the lack of suitable terrain for the precautionary landing and a high density altitude…NTSB LAX08CA167Accident · No injuriesData collectionFinal reportCessna 182 · Moab, UTThe pilot's inadequate compensation for the tailwind condition, and improper use of additional power while taxiing. Contributing to the accident was soft ground and a gusting tailwind.NTSB LAX08LA135Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Oljato, UTThe pilot's failure to achieve a normal touchdown location and loss of directional control during landing roll out. Contributing to the accident were the runway's soft surface and short length.NTSB LAX08CA074Accident · Minor injuriesData collectionFinal reportCessna 172M · Richfield, UTThe pilot's improper use of the flight controls and failure to maintain directional control.NTSB SEA08LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Moab, UTThe pilot's failure to maintain directional control of the tail wheel-equipped airplane during the flare/touchdown phase of a three-point landing.NTSB SEA08LA069Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Parowan, UTThe pilot's improper in-flight decision not to over fly/inspect the snow covered runway prior to landing, and his failure to align the airplane over the centerline of the runway. Contributing to the accident was the snow covered runway, the airport operator's…