NTSB investigations, 2015, 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\") = 2015
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") = 2015 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 WPR16FA036Accident · 2 fatalClass 3 · FieldFinal reportBarnett Allen S RV7 · Hurricane, UTThe pilot’s aerobatic maneuver leading to airspeeds above the airplane’s never exceed speed, which resulted in rudder flutter and an in-flight breakup.NTSB GAA16CA027Accident · No injuriesData collectionFinal reportCessna A188A · Elberta, UTThe pilot's failure to compensate for wind while maneuvering at a low altitude, resulting in a collision with terrain and a postcrash fire.NTSB GAA16CA012Accident · No injuriesData collectionFinal reportPiper PA 46-350P · Kanab, UTThe pilot's failure to monitor the airplane's movement on the ground while programming the GPS, which resulted in a collision with a pole.NTSB WPR16FA002Accident · 2 fatalField investigationFinal reportCessna 152 · Cedar City, UTThe failure of the pilots to maintain control of the airplane while maneuvering, which resulted in an aerodynamic stall from which they did not recover.NTSB GAA15CA257Accident · No injuriesData collectionFinal reportGlenn Timothy C Skystar Series 5 · Green River, UTThe pilot's failure to maintain pitch attitude, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.NTSB GAA15CA258Accident · No injuriesData collectionFinal reportAirbus AS350 · Draper, UTThe ground recovery team member's failure to secure a rescue rope during the helicopter loading process in steep terrain, resulting in the rope fouling the helicopter's main rotor system.NTSB GAA15CA215Accident · No injuriesData collectionFinal reportCessna 560XL · Spanish Fork, UTThe Captain's decision to taxi on a closed taxiway, which resulted in a collision with a parked construction vehicle. Contributing to the accident was a ground crew employee's decision to move barricades from the closed taxiway.NTSB WPR15LA232Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 20B · Logan, UTThe pilot’s failure to maintain glider control when it encountered a strong downdraft while maneuvering near a ridgeline.NTSB GAA15CA189Accident · No injuriesData collectionFinal reportCessna 182Q · Hanksville, UTThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and a collision with terrain.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 GAA15CA157Accident · Minor injuriesData collectionFinal reportBalloon Works FIREFLY8 - 24 · Provo, UT**This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…NTSB WPR15LA203Accident · No injuriesLimited investigationFinal reportBeech C 99 · Salt Lake City, UTThe airplane’s unmanageable right yaw during takeoff for reasons that could not be determined because postaccident examination of the rudder and rudder assembly did not reveal any anomalies that would have precluded normal operation.NTSB DCA15CA145Accident · Serious injuriesData collectionFinal reportBoeing 737 832 · Salt Lake City, UTinadvertent contact by beverage cart during cabin service.NTSB GAA15CA158Accident · No injuriesData collectionFinal reportCessna 337 · Blanding, UTThe pilot's selection of a departure runway of inadequate length for the density altitude, resulting in the airplane not gaining sufficient lift, departing the runway, and impacting terrain.NTSB GAA15CA156Accident · No injuriesData collectionFinal reportCessna 172N · Vernal, UTThe pilot's failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and an impact with an airport sign.NTSB WPR15LA185Accident · No injuriesLimited investigationFinal reportCessna 182A · Moab, UTThe pilot’s inadequate preflight fuel planning and inflight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR15LA170Accident · Serious injuriesLimited investigationFinal reportDuenas Pulsar III · Hurricane, UTAn elevated oil temperature and subsequent total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA15CA100Accident · No injuriesData collectionFinal reportCessna 305 · Richfield, UTThe pilot's loss of directional control during landing, which resulted in a ground loop.NTSB GAA15CA029Accident · No injuriesData collectionFinal reportKerr John A Kitfox Classic IV · Logan, UTThe pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, and a loss of engine power en route.NTSB GAA15CA026Accident · No injuriesData collectionFinal reportCessna 172S · Vernal, UTThe student pilot's failure to maintain attitude control during landing flare.NTSB GAA15CA024Accident · No injuriesData collectionFinal reportDavid Shell Zenith CH701 · Fairfield, UTThe pilot's failure to maintain directional control during a precautionary off airport landing.NTSB WPR15LA129Accident · No injuriesLimited investigationFinal reportCessna 310Q · St. George, UTFailure of the left main landing gear lower adjusting bolt due to overstress, which resulted in the left main landing gear collapse during landing.NTSB GAA15CA004Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Hurricane, UTThe pilot's failure to maintain directional control during the landing roll.NTSB WPR15LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Layton, UTThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight and in-flight fuel planning, which did not account for the increased headwind.NTSB WPR15FA082Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Tooele, UTThe non-instrument rated pilot’s decision to depart into low visibility conditions, which resulted in spatial disorientation and a loss of control. Contributing to the accident was the pilot’s impaired performance due to his use of the sedating antihistamine,…