NTSB investigations, 2005, 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\") = 2005
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") = 2005 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 SEA06TA028Accident · Serious injuriesFinal reportAerospatiale SA-319B · Escalante, UTThe pilot's inadequate remedial action when ground resonance was encountered during landing. Contributing factors were the rough/uneven terrain and company inadequate maintenance.NTSB SEA06CA020Accident · No injuriesData collectionFinal reportCessna 195A · Heber City, UTThe failure of the right brake, which resulted in a loss of directional control during the landing roll and a nose down.NTSB SEA06CA017Accident · No injuriesData collectionFinal reportCessna T210M · Salt Lake City, UTA loss of engine power due to fuel starvation as a result of the pilot's improper in-flight decision not to use the before landing checklist. A factor which contributed to the accident was the improper position of the mixture control.NTSB SEA06CA009Accident · No injuriesData collectionFinal reportCessna A185F · Lake Powell, UTThe pilot's failure to maintain clearance from terrain during an aborted water takeoff run which resulted in the airplane colliding with a canyon wall. A contributing factor was the submerged object that the airplane struck during the takeoff run.NTSB DEN05CA149Accident · No injuriesData collectionFinal reportCessna 206 · Brigham City, UTthe pilot's improper in-flight planning and decision making and failure to maintain aircraft control during the ground roll.. Contributing to the accident was the soft dirt.NTSB DEN05CA145Accident · No injuriesData collectionFinal reportCessna 172S · Cedar City, UTthe student pilot's failure to maintain aircraft control during the landing. Factors contributing to the accident were the improper flare and improper recovery from a bounced landing.NTSB DEN05CA144Accident · No injuriesData collectionFinal reportBradford Haines Glastar · Spanish Fork, UTthe pilot's failure to strain the fuel prior to flight resulting in fuel starvation. Contributing to the accident was the loss of engine power due to the plugged fuel filter.NTSB DEN05LA131Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Duchesne, UTthe loss of control during external load operations for undetermined reasons.NTSB DEN05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Ogden, UTthe flight instructor's failure to maintain adequate airspeed resulting in an inadvertent stall. Contributing factor's include the flight instructor's improper pre-flight planning and decision in accepting the intersection departure, and the flight…NTSB DEN05LA127Accident · No injuriesLimited investigationFinal reportCessna 172N · Cedar City, UTthe loss of engine power for reasons undetermined. Contributing factors include the lack of suitable terrain for a forced landing, and the soft dirt.NTSB DEN05FA114Accident · 3 fatalField investigationFinal reportBeech N35 · West Jordan, UTthe pilot's improper preflight planning, his attempted flight into adverse weather conditions, and the stall resulting in the loss of control and subsequent crash. Factors contributing to the accident were the pilot's inadequate evaluation of the weather…NTSB DEN05LA110Accident · Minor injuriesLimited investigationFinal reportCessna TU206F · Vernal, UTThe pilot's failure to maintain aircraft control during takeoff. Factors contributing to the accident were the soft dirt airstrip, the low airspeed and the stall/mush.NTSB DEN05LA106Accident · Serious injuriesLimited investigationFinal reportClarke YAK 3UR 2000 · Heber City, UTloss of engine power due to a leaking carburetor and an inoperative float, and the pilot's failure to maintain aircraft control during the restart attempt. Contributing factors were the sudden engine power surge during the attempted restart, and unsuitable…NTSB DEN05CA107Accident · No injuriesData collectionFinal reportTaylorcraft BC12-65 · Roosevelt, UTthe pilot's failure to maintain control of the aircraft during landing. A factor contributing to the accident was the crosswind.NTSB DEN05LA102Accident · No injuriesLimited investigationFinal reportEnstrom 480B · Scofield, UTthe pilot's failure to maintain control of the helicopter. Contributing factor's include the pilot's failure to maintain clearance from terrain.NTSB DEN05CA097Accident · No injuriesData collectionFinal reportRobinson R44 II · Indianola, UTThe pilot's failure to maintain adequate rotor rpm which resulted in a loss of control and a hard landing.NTSB DEN05CA105Accident · No injuriesData collectionFinal reportNavion Navion G · Parowan, UTThe jammed left main landing gear and the wheels up landing. Factors contributing to the accident were the misaligned left landing light and that landing gear extension was not possible.NTSB DEN05IA098Incident · No injuriesIncident investigationFinal reportBoeing 737-524 · Salt Lake City, UTthe left wing walker's failure to maintain an adequate visual lookout. Contributing factors were his inadequate initial training, and the failure of other ground personnel to follow company procedures/directives.NTSB DEN05CA085Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Wallsburg, UTthe flight instructor's inadequate in-flight planning and decision making and failure to maintain aircraft control. Contributing factor's include the flight instructor's inadequate supervision of the flight, the student pilot's failure to maintain rotor rpm,…NTSB DEN05LA082Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Provo, UTthe dual student’s failure to maintain adequate rotor rpm and the inadequate supervision by the instructor.NTSB DEN05LA081Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · St. George, UTthe pilot's improper autorotation. A contributing factor was the flight instructor's inadequate supervision of the pilot.NTSB DEN05LA061Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · Spanish Fork, UTthe student's failure to maintain control of the helicopter. Contributing factors were high airspeed, high rate of descent, the instructor's delay in taking remedial action, and the instructor's inadequate supervision of the flight.NTSB DEN05LA056Accident · No injuriesLimited investigationFinal reportHughes 369HS · Provo, UTthe pilot's improper in-flight planning and decision making, his failure to maintain terrain clearance, and the total failure of the tail rotor drive shaft as a result of the tail rotor strike.NTSB DEN05CA050Accident · No injuriesData collectionFinal reportGrumman G-1159 · Logan, UTthe pilot's improper IFR operation by which he failed to comply to the missed approach procedure, and his improper evaluation of the weather resulting in an encounter with fog and his loss of visual contact with the runway during the landing.NTSB SEA05FA037Accident · 2 fatalField investigationFinal reportAero Commander AC200D (Meyers) · Hatch, UTThe pilot's failure to maintain aircraft control while maneuvering. Inadequate airspeed, the pilot's diverted attention, and low altitude flight were factors.