NTSB investigations, 2023, UT
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2023
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") = 2023 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 WPR24LA064Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Spanish Fork, UTMaintenance personnel’s improper installation of the left magneto, which resulted in oil starvation to the engine and a subsequent total loss of engine power.NTSB WPR24FA035Accident · 2 fatalClass 3 · FieldFinal reportCessna 172G · Provo, UTThe pilot's exceedance of the airplane's critical angle of attack during a chandelle maneuver, which resulted in an aerodynamic stall and descent into trees and terrain. Contributing to the accident was the pilot’s decision to maneuver into a canyon and…NTSB WPR24FA024Accident · 1 fatalClass 3 · FieldFinal reportCessna T206H · Orangeville, UTThe pilot's controlled flight into mountainous terrain for reasons that could not be determined.NTSB WPR24LA026Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage · Fairfield, UTThe pilot’s failure to maintain airplane control during the landing, which resulted in a ground loop.NTSB WPR24LA016Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-235C · Provo, UTThe pilot’s failure to maintain directional control during landing.NTSB WPR24FA010Accident · 1 fatalClass 3 · FieldFinal reportRobert L Thurmond RV8 · Centerville, UTThe pilot’s exceedance of the airplane’s critical angle of attack while attempting to return to the departure airport, which resulted in an aerodynamic stall at an altitude too low for recovery. Contributing to the accident was the failure of the No. 2…NTSB WPR24FA002Accident · 4 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Moab, UTThe pilot’s loss of visual reference to the horizon while departing during dark night, which resulted in the pilot experiencing spatial disorientation and subsequent controlled flight into terrain.NTSB WPR23LA358Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Salt Lake City, UTThe student pilot’s failure to maintain directional control during landing.NTSB WPR23LA353Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Monument Valley, UTThe pilot’s failure to maintain directional control after encountering a wind gust on the landing roll, which resulted in a ground loop.NTSB WPR23LA343Accident · Minor injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Monticello, UTA partial loss of engine power for reasons that could not be determined.NTSB WPR23LA329Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Kanab, UTThe pilot's decision to take off in high density altitude conditions, which resulted in a loss of control and subsequent impact with terrain.NTSB WPR23LA324Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20 · Fairfield, UTThe flight pilots improper fuel management, which resulted a total loss of engine power, and impact with terrain during an off-airport landing. Contributing to the accident was the flight instructor’s failure to follow the airplane checklist.NTSB WPR23FA323Accident · 1 fatalClass 3 · FieldFinal reportHensler Howard Cassutt · West Jordan, UTA loss of control during the initial climb for reasons that could not be determined.NTSB WPR23LA319Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Moab, UTThe pilot’s loss of directional control during landing, which resulted in a ground loop.NTSB WPR23LA308Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Ritchfield, UTThe pilot’s improper preflight planning that resulted in the loss of engine power due to fuel exhaustion.NTSB WPR23LA278Accident · No injuriesClass 3 · LimitedFinal reportAerospatiale AS-355E Twin Star · Farmington, UTThe premature failure of one of the No. 2 engine compressor bleed valve, which resulted in a partial loss of power to that engine.NTSB WPR23LA260Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fremont Island, UTThe pilot undergoing instruction’s excessive application of asymmetrical braking during landing, which resulted in a ground loop.NTSB WPR23LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Cedar Mountain, UTThe pilot’s decision to depart with a high density altitude, which degraded the airplane’s climb performance and resulted in an impact with trees.NTSB WPR23LA228Accident · No injuriesClass 4 · LimitedFinal reportBenoit Leclair Rans S-7S · Bryce Canyon, UTThe pilot's failure to maintain control of the airplane during the landing roll and subsequent impact with terrain during go-around.NTSB WPR23LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Nephi, UTA total loss of engine power due to fuel contamination as a result of the inadequate removal of fuel system corrosion during previous maintenance.NTSB WPR23LA203Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · West Jordan, UTLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl.NTSB WPR23LA204Accident · No injuriesClass 4 · LimitedFinal reportCessna 175A · Enterprise, UTThe pilot’s inability to maintain altitude during an initial climbout in mountainous terrain after encountering a suspected downdraft.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 WPR23LA191Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Spanish Fork, UTThe instructor pilot’s improper landing flare during a straight-in autorotation, which resulted in a hard landing.NTSB WPR23LA149Accident · No injuriesClass 3 · LimitedFinal reportStevens Kelly C RV-7 · Morgan, UTThe pilot/builder improperly torqued the propeller attachment bolts while reinstalling the propeller, which resulted in the fatigue failure of the bolts and the separation of the propeller assembly.NTSB WPR23LA147Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Midway, UTThe pilot’s failure to maintain aircraft control during a pinnacle landing that resulted in a hard landing and subsequent roll over.NTSB WPR23LA136Accident · No injuriesClass 3 · LimitedFinal reportCessna 177RG · Spanish Fork, UTThe retraction of the main landing gear for undetermined reasons.NTSB WPR23LA134Accident · No injuriesClass 3 · LimitedFinal reportHarris Robert W Zenith CH 801 · Brigham City, UTThe pilot’s improper flare, which resulted in a hard landing following a reported loss of engine thrust for undetermined reasons.NTSB WPR23LA126Accident · Minor injuriesClass 4 · LimitedFinal reportTrendak Taurus · Strawberry Reservoir, UTThe pilot’s failure to maintain clearance from the snow-covered lake while flying at a low altitude.NTSB WPR23LA114Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Ephraim, UTThe pilot’s improper landing flare and loss of directional control.NTSB WPR23LA109Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Morgan, UTThe pilot’s failure to maintain directional control during landing.NTSB WPR23LA103Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Porterville, UTThe pilot’s failure to maintain clearance from snow covered terrain while maneuvering at low altitude.NTSB WPR23LA099Accident · No injuriesClass 4 · LimitedFinal reportBeech C23 · Rich County, UTThe pilot’s inability to maintain altitude following an encounter with turbulence and adverse wind conditions.NTSB WPR23FA083Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-34-220T · New Harmony, UTThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation.NTSB WPR23FA080Accident · 1 fatalClass 3 · FieldFinal reportEmbraer Executive EMB-505 · Provo, UTThe pilot’s failure to deice the airplane before takeoff in weather conditions conducive to ice accumulation, which resulted in an ice-contaminated wing and subsequent stall during takeoff.