NTSB investigations, 1995, 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\") = 1995
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") = 1995 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 LAX96IA065Incident · No injuriesIncident investigationFinal reportBeech 99 · Salt Lake City, UTimproper installation of the rudder control cable by company maintenance personnel, which resulted in chafing and/or fatigue and subsequent failure of the cable.NTSB SEA96FA022Accident · 1 fatalField investigationFinal reportCessna 152 · Provo, UTpilot suicide (intentional in-flight collision with rising terrain). A factor relating to the accident was: pilot anxiety/apprehension.NTSB SEA96LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Syracuse, UTFuel exhaustion due to the pilot's failure to refuel.NTSB SEA96LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Salt Lake City, UTa carburetor fire.NTSB SEA96LA013Accident · No injuriesLimited investigationFinal reportCessna TR182 · Salt Lake City, UTmaintenance personnel improperly installed a landing gear system hydraulic line and the throttle cable which resulted in chaffing and subsequent loss of hydraulic fluid disabling the landing gear extention systems.NTSB SEA96LA006Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control. A factor to the accident was inadequate remedial action.NTSB SEA95LA217Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26B · Morgan, UTFailure of the pilot to maintain adequate airspeed, while maneuvering to land after a low altitude tow release, which resulted in a stall/spin and collision with terrain.NTSB SEA95LA216Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Moab, UTThe pilot-in-command's landing long, precluding a go-around and not maintaining a proper descent rate. Factors were trees and the crosswind.NTSB SEA95LA207Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mt Pleasant, UTThe pilot in command's failure to maintain airspeed during climbout. Factors include wind shear and high density altitude.NTSB SEA95LA195Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Ogden, UTthe pilot's failure to use brakes to maintain directional control following a tailwheel steering malfunction. Partial failure of the tailwheel steering system contributed to the accident.NTSB SEA95LA185Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Thompson, UTthe pilot's continued flight into instrument meteorological conditions, and his failure to maintain altitude and clearance from the mountainous terrain. Factors contributing to the accident were the fog, low ceilings, and downdraft.NTSB SEA95LA178Accident · No injuriesLimited investigationFinal reportCessna 210E · Bullfrog, UTThe right brake locking for undetermined reasons.NTSB SEA95LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Panguitch, UTthe pilot's misjudgment of the distance from the sign post.NTSB SEA95LA166Accident · No injuriesLimited investigationFinal reportCessna 150J · West Jordan, UTThe pilot's failure to refuel the aircraft prior to initiating his cross-country flight resulting in a total power loss due to fuel exhaustion.NTSB SEA95LA163Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Wellsville, UTThe pilot's failure to maintain airspeed. Factors in the accident were the pilot's lack of experience with flying in mountainous terrain and the high density altitude.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 SEA95FA120Accident · 1 fatalField investigationFinal reportCessna 175A · Moab, UTThe pilot's failure to maintain proper altitude in the visual flight rules (VFR) traffic pattern. Contributing to the accident were the pilot's failure to follow dispatch procedures, the dark night conditions, and the unavailability of the airport's…NTSB SEA95FA095Accident · 6 fatalField investigationFinal reportCessna T210L · Milford, UTthe pilot's continued flight into known adverse weather (icing conditions), and his delay in executing a course reversal to exit those conditions, which resulted in airframe ice accumulation and loss of control. A factor was the icing conditions.NTSB SEA95LA085Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Richfield, UTIce ingestion. Factors to the accident were: aircraft protective coverings were unavailable, inadequate preflight inspection, and uneven terrain.NTSB SEA95LA067Accident · No injuriesLimited investigationFinal reportCessna 140 · Ogden, UTDirectional control was not maintained. Factors to the accident were a lack of total experience in type of aircraft and crosswind.NTSB SEA95LA070Accident · 2 fatalLimited investigationFinal reportQuicksilver MXL2 · Hildale, UTThe pilot's failure to maintain adequate airspeed while banking the airplane. This led to an unrecoverable aerodynamic stall in close proximity to the ground. Factors contributing to the accident are the pilot exceeding the airplane's weight and balance…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 SEA95FA048Accident · 2 fatalField investigationFinal reportPiper PA-601P · Tremonton, UTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with the mountainous terrain. Factors were the clouds, and the dark night.NTSB SEA95LA036Accident · No injuriesLimited investigationFinal reportCessna 172G · Salt Lake City, UTThe pilot's inadequate compensation for wind conditions during runup. The unfavorable wind was a factor.