NTSB investigations, 2017, UT
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1963 | 1 |
|---|---|
| 1964 | 54 |
| 1965 | 54 |
| 1966 | 65 |
| 1967 | 52 |
| 1968 | 44 |
| 1969 | 45 |
| 1970 | 39 |
| 1971 | 27 |
| 1972 | 39 |
| 1973 | 44 |
| 1974 | 33 |
| 1975 | 38 |
| 1976 | 57 |
| 1977 | 42 |
| 1978 | 42 |
| 1979 | 41 |
| 1980 | 52 |
| 1981 | 58 |
| 1982 | 41 |
| 1983 | 45 |
| 1984 | 53 |
| 1985 | 41 |
| 1986 | 32 |
| 1987 | 37 |
| 1988 | 28 |
| 1989 | 40 |
| 1990 | 32 |
| 1991 | 31 |
| 1992 | 26 |
| 1993 | 36 |
| 1994 | 31 |
| 1995 | 24 |
| 1996 | 27 |
| 1997 | 36 |
| 1998 | 35 |
| 1999 | 29 |
| 2000 | 49 |
| 2001 | 33 |
| 2002 | 39 |
| 2003 | 40 |
| 2004 | 34 |
| 2005 | 25 |
| 2006 | 32 |
| 2007 | 44 |
| 2008 | 42 |
| 2009 | 37 |
| 2010 | 35 |
| 2011 | 31 |
| 2012 | 26 |
| 2013 | 20 |
| 2014 | 25 |
| 2015 | 25 |
| 2016 | 18 |
| 2017 | 27 |
| 2018 | 26 |
| 2019 | 29 |
| 2020 | 21 |
| 2021 | 23 |
| 2022 | 28 |
| 2023 | 35 |
| 2024 | 27 |
| 2025 | 22 |
| 2026 | 23 |
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 year(c.\"eventDate\") = 2017
AND c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2017 AND c."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA' 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 WPR18FA063Accident · 2 fatalField investigationFinal reportCessna 172M · Ogden, UTThe pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.NTSB GAA18CA073Accident · No injuriesData collectionFinal reportBrock Steiner Sport Copter Vortex · Spanish Fork, UTThe pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.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 WPR18LA009Accident · No injuriesLimited investigationFinal reportBarber Warren D Turbine Cubs P A 18 · Skull Valley, UTThe activation of the wheel brakes during landing, which resulted in a nose-over. The reason for the wheel brake activation could not be determined.NTSB GAA17CA543Accident · No injuriesData collectionFinal reportCessna T210 · St George, UTThe pilot’s failure to extend the landing gear before landing.NTSB WPR17LA202Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Ogden, UTThe airplane's inability to maintain an initial takeoff climb for reasons that could not be determined based on available information.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 WPR17LA187Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 310I · Salt Lake City, UTA loss of engine power for reasons that could not be determined based on the available information.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 GAA17CA468Accident · Serious injuriesData collectionFinal reportCessna 170 · Moab, UTThe pilot’s improper decision to depart in unfavorable weather conditions, which resulted in a hard, forced landing.NTSB WPR17FA166Accident · 4 fatalField investigationFinal reportBeech A36TC · Ogden, UTA loss of control during takeoff for reasons that could not be determined.NTSB WPR17LA157Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe failure of the No. 4 cylinder exhaust valve head, which resulted in a total loss of engine power due to oil starvation.NTSB WPR17FA149Accident · 2 fatalField investigationFinal reportAviat A · Herriman, UTThe flight instructor's decision to conduct a low-altitude flight into a box canyon in high density altitude conditions and his failure to maintain airspeed while maneuvering to escape the canyon, which resulted in an exceedance of the airplane's critical…NTSB GAA17CA371Accident · No injuriesData collectionFinal reportAero Commander Callair A 9 · Morgan, UTThe pilot’s failure to see and avoid transmission wires.NTSB GAA17CA327Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe student pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB GAA17CA314Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Logan, UTThe pilot’s failure to maintain directional control during the landing roll due to the high placement of his feet on the rudder pedals, which led to the inadvertent application of the brakes.NTSB GAA17CA276Accident · No injuriesData collectionFinal reportCessna 172 · Monument Valley, UTThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA269Accident · No injuriesData collectionFinal reportJohnson Kenneth Super CUB Sport · Spanish Fork, UTThe pilot's decision to land with a gusting tailwind and his subsequent failure to maintain directional control.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 GAA17CA259Accident · No injuriesData collectionFinal reportCurtis Lund Vortex · Spanish Fork, UTThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA17CA262Accident · No injuriesData collectionFinal reportBalony Kubicek Spol Sro BB70Z · Park City, UTThe pilot’s failure to see and avoid power lines during landing.NTSB GAA17CA235Accident · No injuriesData collectionFinal reportRaytheon B200 · Richfield, UTThe pilot’s failure to maintain separation from a fence post during taxi at night.NTSB GAA17CA217Accident · Minor injuriesData collectionFinal reportFunk B85C · Cedar City, UTThe pilot’s failure to maintain directional control of the airplane during the takeoff roll.NTSB GAA17CA207Accident · No injuriesData collectionFinal reportCessna 550 · Salt Lake City, UTAn in-flight collision with a goose during approach.NTSB WPR17FA065Accident · 3 fatalField investigationFinal reportCessna 172 · Panguitch, UTThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's inadequate preflight weather planning and his poor decision-making.NTSB GAA17CA135Accident · No injuriesData collectionFinal reportHughes OH 6A · Price, UTThe fuel truck driver’s failure to stop before impacting the helicopter’s main rotor blades.NTSB GAA17CA117Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Vernon, UTThe pilot’s failure to maintain clearance from mountainous terrain.