NTSB investigations, 1994, 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\") = 1994
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") = 1994 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 SEA95LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Lehi, UTThe pilot's failure to maintain altitude/clearance above the terrain. Factors include the pilot inadvertently becoming lost/disoriented, his improper inflight decision to attempt to maneuver through unfamiliar mountainous terrain to his original destination,…NTSB SEA95FA031Accident · 4 fatalField investigationFinal reportPiper PA-32R-300 · Grantsville, UTThe VFR pilot's attempt to continue the flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with mountainous terrain.NTSB SEA95LA030Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Heber City, UTAn open connection clip. A factor to the accident was a locked tail wheel assembly.NTSB SEA95LA008Accident · Minor injuriesLimited investigationFinal reportCessna R172K · St. George, UTInadequate fuel consumption calculations. Factors to the accident were: fuel exhaustion and a parked aircraft in the landing path.NTSB SEA95LA006Accident · 2 fatalLimited investigationFinal reportGlines Acro Duster II SA750 · West Jordon, UTThe pilot-in-command's attempt to perform a low altitude flight maneuver, and his failure to maintain adequate airspeed during the maneuver. This led to an unrecoverable aerodynamic stall.NTSB FTW95FA008Accident · 3 fatalField investigationFinal reportCessna T337G · Milford, UTThe pilot's continued flight into adverse weather conditions, which resulted in airframe (structural) ice, a loss of control, and subsequent in-flight breakup of the airplane. A factor related to the accident was: the icing/weather condition.NTSB FTW95FA003Accident · 2 fatalField investigationFinal reportCessna T210M · Richmond, UTThe loss of engine oil pressure due to an oil leak from a loose oil line fitting. Factors were the obscuration, and the unsuitable terrain at the pilot's disposal.NTSB SEA94LA238Accident · No injuriesLimited investigationFinal reportCessna 172 · Bullfrog, UTThe pilot-in-command exceeded the airplane's maximum crosswind component capability. A factor related to the accident was the gusty crosswind.NTSB SEA94LA214Accident · No injuriesLimited investigationFinal reportCessna 180K · Hite, UTCompensation for wind conditions and weather evaluation were inadequate. Factors to the accident were: crosswind and gusts.NTSB SEA94GA203Accident · 1 fatalFinal reportHughes OH-6A · Duchesne, UTThe pilot's improper in-flight planning/decision and failure to maintain sufficient altitude/clearance from the surrounding terrain. Factors related to the accident were: thunderstorms in the area (requiring the pilot to deviate from the desired course), high…NTSB SEA94LA195Accident · No injuriesLimited investigationFinal reportPitts S-2B · Salt Lake City, UTThe inadequate visual lookout by the instructor and dual student. Factors include sunglare and the tug left on the taxiway.NTSB SEA94FA190Accident · 1 fatalField investigationFinal reportBell 206B III · Syracuse, UTUndeterminedNTSB SEA94LA172Accident · No injuriesLimited investigationFinal reportPitts S1 · Heber City, UTFailure of main landing gear axle hardware. Factors include collapse of main landing gear strut.NTSB SEA94FA167Accident · 2 fatalField investigationFinal reportBeech P35 · Cedar City, UTThe pilot's failure to maintain a proper climb rate and clearance from the terrain. Factors in the accident were the high density altitude and the aircraft being above the maximum certificated gross weight.NTSB SEA94LA166Accident · No injuriesLimited investigationFinal reportHughes 369HS · West Jordan, UTThe pilot not maintaining a proper descent rate and his delayed remedial action.NTSB SEA94LA142Accident · 1 fatalLimited investigationFinal report1ST FTR GP FOCKE-WULF 190 · Salt Lake City, UTImproper balancing of the ailerons resulting in aileron flutter.NTSB SEA94LA144Accident · No injuriesLimited investigationFinal reportCessna 182P · Salt Lake City, UTAn improper flare by the pilot, who was landing the aircraft, at the time it was damaged.NTSB SEA94LA126Accident · No injuriesLimited investigationFinal reportChristen Industries Husky · Ogden, UTThe pilot's inadequate compensation for wind condiitons. The wind gusts were a factor.NTSB SEA94LA125Accident · Serious injuriesLimited investigationFinal reportKelly Long EZ · Lindon, UTPiston failure and unsuitable terrain for a successful forced landing.NTSB SEA94LA119Accident · 1 fatalLimited investigationFinal reportHallstrom BD-5B · St. George, UTCarburetor contamination and low output, and the pilot's improper decision to attempt to continue the approach. A factor was the pilot's lack of recent flight experience.NTSB SEA94LA104Accident · No injuriesLimited investigationFinal reportCessna 182 · Hanksville, UTThe excess airspeed maintained by the pilot on final approach, and his failure to attain the proper touchdown point. Factors include loose gravel, and a berm off the end of the intended landing strip.NTSB SEA94LA099Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Coalville, UTThe failure of the connecting rod. Factors include the rough uneven terrain encountered during the forced landing.NTSB SEA94LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Hurricane, UTThe pilot in command's failure to refuel and excessive airspeed during the approach. Factor(s) were: fencepost(s) and the lack of recent experience in type of aircraft.NTSB SEA94LA092Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Levan, UTThe left main landing gear wheel bearing broke resulting in the wheel jamming and the airplane nosing over.NTSB SEA94LA087Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Dutch John, UTThe pilot's inadequate compensations for wind conditions. The gusty crosswind was a factor.NTSB SEA94FA084Accident · 4 fatalField investigationFinal reportBellanca 14-19-3A · Wendover, UTInadequate in flight planning/decision. Factors to the accident were: clearance was not maintained and dark night conditions.NTSB SEA94LA078Accident · No injuriesLimited investigationFinal reportSchweizer 2-33A · Heber City, UTThe flight instructor's delayed/inadequate remedial action. Factors include the student pilot's failure to maintain directional control, and unfavorable/variable, gusty winds during the takeoff roll.NTSB SEA94LA069Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Hanksville, UTThe pilot's delay in releasing his tow line when the line became entangled with wires.NTSB SEA94LA073Accident · Minor injuriesLimited investigationFinal reportBell 206 L-1 · Salt Lake City, UTThe pilot's selection of unsuitable terrain for a landing site. Factors include snow covered terrain.NTSB SEA94LA063Accident · No injuriesLimited investigationFinal reportCessna TU206 · Salt Lake City, UTThe pilot's improper aircraft handling during the aborted takeoff.NTSB SEA94LA046Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Manila, UTThe pilot's failure to maintain clearance. Factors include a tailwind, gusts, and a tree just off the departure end of the field used for takeoff.