NTSB investigations, UT
14 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 2002 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 320)
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 320) 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 SEA07CA168Accident · No injuriesData collectionFinal reportCessna 172D · Halls Crossing, UTThe pilot's failure to select suitable terrain for landing. A contributing factor was the rough/uneven terrain.NTSB SEA07LA131Accident · No injuriesLimited investigationFinal reportCessna 150M · Spanish Fork, UTThe student pilot's inadequate compensation for gusty crosswind conditions, and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds, and a ditch near the runway environment.NTSB SEA06CA181Accident · No injuriesData collectionFinal reportCessna 172M · Moab, UTThe pilot's failure to obtain current NOTAMS which resulted in an on-ground collision with a construction berm while landing.NTSB DEN04LA049Accident · No injuriesLimited investigationFinal reportCessna 182P · Hanksville, UTthe pilot's selection of unsuitable terrain to conduct a precautionary landing. Factors contributing to the accident was the soft, dirt road.NTSB DEN02LA095Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Lehi, UTthe pilot's inadequate in-flight planning resulting in the glider impacting terrain short of the runway, and the pilot's subsequent abrupt handling of the glider when it became airborne again, which resulted in a hard second landing. A contributing factor was…NTSB SEA95LA153Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ogden, UTThe pilot-in-command's failure to maintain directional control. Hte loose tailwheel assembly bolt was a factor.NTSB SEA95LA054Accident · No injuriesLimited investigationFinal reportCessna TR182 · Bountiful, UTThe pilot's failure to attain proper runway alignment. Factors in the accident were: the dark night conditions and inadequate maintenance of the runway lighting system.NTSB SEA94LA238Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullfrog, UTThe pilot-in-command exceeded the airplane's maximum crosswind component capability. A factor related to the accident was the gusty crosswind.NTSB SEA94LA073Accident · Minor injuriesLimited investigationFinal reportBell 206 L-1 · Salt Lake City, UTThe pilot's selection of unsuitable terrain for a landing site. Factors include snow covered terrain.NTSB SEA91LA114Accident · No injuriesLimited investigationFinal reportCessna TR182 · Green River, UTWorn brakes. Contributing to the accident was: poor maintenance.NTSB DEN90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Clarkston, UTJammed ailerons resultant from the collision with crops.NTSB DEN89LA059Accident · No injuriesLimited investigationFinal reportBell 206B III · Park City, UTThe selection of an unsuitable landing site by the pilot, resulting in tail rotor contact with the terrain and shearing of the tail rotor driveshaft.NTSB DEN85LA174Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Glen Canyon, UTThe plt became lost/disoriented near the end of a x-country flt from west jordan to blanding, Utah. When fuel quantity became low, the plt decided to make a precautionary landing on a dirt road. During the landing falre, a x-wind gust drifted the acft to the…NTSB DEN84LA169Accident · No injuriesLimited investigationFinal reportCessna 182P · Junction, UTThe pilot inadvertently landed on a closed section of highway which he mistook for a dirt runway. The highway surface was narrow and contained broken chunks of asphalt. During the landing roll, the left main gear contacted a 1 ft x 1 ft rock. The acft then…