NTSB investigations, 1999, 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\") = 1999
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") = 1999 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 DEN00IA032Incident · No injuriesIncident investigationFinal reportBoeing 737-347 · Salt Lake City, UTImproper assembly of the wheel during build up in the operator's maintenance facilities.NTSB DEN00IA023Incident · No injuriesIncident investigationFinal reportBoeing 767-232 · Salt Lake City, UTTotal failure of the main landing gear retract actuator due to stress corrosion caused by the use of a faulty sealant by company maintenance personnel that allowed moisture to enter the joint. A factor was the use of an improper fillet seal.NTSB DEN00LA017Accident · No injuriesLimited investigationFinal reportCessna 172R · Logan, UTThe pilot's improper flare and improper recovery from a bounced landing.NTSB DEN00LA014Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bullfrog, UTThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the pilot's lack of total experience in type of aircraft and the fence.NTSB DEN00FA005Accident · 1 fatalField investigationFinal reportWatkins Christen Eagle · Brigham City, UTThe pilot's inability to maintain aircraft control due to an unknown physical impairment.NTSB DEN99LA171Accident · No injuriesLimited investigationFinal reportRobinson R22 · St. George, UTThe pilot's inadequate visual lookout. Factors included the pilot concentrating on the maneuver being practiced to such an extent that he was inattentive to outside surroundings, and the sun glare.NTSB DEN99LA170Accident · No injuriesLimited investigationFinal reportCessna 172 · Panguitch, UTInadequate preflight planning and preparation by the pilot in command. Factors were high velocity gusty winds, high-density altitude, and unsuitable terrain for a forced landing.NTSB DEN99LA168Accident · No injuriesLimited investigationFinal reportBell 47G3B2A · Tremonton, UTThe pilot's failure to maintain rotor rpm while attempting a precautionary autorotation landing. A factor was the loss of engine power for undetermined reasons.NTSB DEN99LA165Accident · No injuriesLimited investigationFinal reportCessna 152 · Murray, UTA forced landing on unsuitable terrain. Factors were fuel exhaustion and inaccurate preflight planning by the flight instructor.NTSB DEN99LA161Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Heber City, UTThe pilot's failure to maintain aircraft control during takeoff roll. Factors were the gusting crosswind conditions, and the airport sign.NTSB DEN99LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Heber City, UTThe stripped threads and subsequent separation of the left hydraulic brake line leading to fluid loss and the pilot's inability to maintain directional control.NTSB DEN99LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tooele, UTAn inadequate flare during landing touchdown, resulting in a fracture of the right main landing gear strut. A factor was the flight instructor's failure to properly supervise the student.NTSB DEN99LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTAn inadvertent collision with a bird.NTSB DEN99LA129Accident · No injuriesLimited investigationFinal reportBoeing A-75-N1 (Stearman) · Tooele, UTThe failure of the right main landing gear tire's inner tube, and the subsequent inadvertent ground loop by the pilot.NTSB DEN00LA033Accident · No injuriesLimited investigationFinal reportCessna T210M · Cedar City, UTThe pilot's failure to follow alternate landing gear extension procedures. Factors were the main landing gear failure to extend and a loss of electrical power.NTSB DEN99LA118Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Delta, UTThe pilot's delayed aborted takeoff. A factor was the high density altitude.NTSB DEN99FA120Accident · 4 fatalField investigationFinal reportPiper PA-22-150 · Roy, UTThe pilot inadvertently allowing the aircraft to enter a stall during initial climb following takeoff. Factors were high density altitude and gross weight which exceeded the maximum.NTSB DEN99LA110Accident · No injuriesLimited investigationFinal reportCessna 182A · Salt Lake City, UTA total loss of engine power (nonmechanical) for reasons undetermined. Factors were the existence of conditions conducive to carburetor icing, and unsuitable terrain on which to make a forced landing.NTSB DEN99LA100Accident · No injuriesLimited investigationFinal reportButler SX-300 · Hill Afb, UTA failure of the left main landing gear attachment for undetermined reasons.NTSB DEN99LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Salt Lake City, UTFailure of the nose landing gear scissors bolt for undetermined reasons.NTSB DEN99LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).NTSB DEN99LA082Accident · No injuriesLimited investigationFinal reportRich RV3-A · Bountiful, UTThe pilot's inadequate preflight planning, and the subsequent fuel exhaustion during the flight. Factor was the airplane's inaccurate fuel gauge.NTSB DEN99LA079Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Richfield, UTThe pilot's failure to maintain adequate altitude/clearance from the wires while maneuvering during an aerial application.NTSB DEN99FA071Accident · 3 fatalField investigationFinal reportMooney M20E · Cedar City, UTThe pilot's inadequate fuel consumption calculations. Factors were the loss of engine power due to fuel exhaustion and the obscuring weather conditions.NTSB DEN99LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Wendover, UTThe pilot's improper preflight/in-flight planning and decision making, resulting in fuel supply exhaustion. A factor was the closed runway condition.NTSB DEN99LA062Accident · No injuriesLimited investigationFinal reportSly RV-6A · Payson, UTThe development of carburetor ice resulting in a loss of engine power, and the inadequate carburetor heat shroud. Factors were the carburetor icing weather conditions, the kit manufacturer's inadequate carburetor heat shroud design, the FAA's inadequate…NTSB DEN99LA048Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Provo, UTThe pilot exercising poor judgment by ignoring proper procedures/directives, his intentional selection of the wrong runway for takeoff, and his failure to maintain an adequate visual lookout. Factors were his ostentatious display, the other airplane moving on…NTSB DEN99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · West Jordan, UTThe pilot's failure to maintain directional control of the aircraft. Factors were his lack of recent flight experience, and his lack of experience in the make and model of aircraft.NTSB DEN99TA031Accident · No injuriesFinal reportHughes 369D · Woodruff, UTA partial loss of engine power due to erosion in the compressor assembly module. Factors were a missing rotating labyrinth seal, the installation of which had not been performed by unknown maintenance personnel.