NTSB investigations, 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, newest first
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 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 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 DEN01LA109Accident · Serious injuriesLimited investigationFinal report2001 Mcgirl Questair Venture · Ogden, UTan in-flight fire, which originated from a fuel leak of unknown origin.NTSB DEN01LA102Accident · No injuriesLimited investigationFinal reportCessna T207A · Kanab, UTthe pilot's inadequate fuel consumption planning, and the subsequent fuel starvation, which resulted in a loss of engine power.NTSB DEN01LA104Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · West Jordan, UTthe pilot inadvertently flaring the airplane too high above the ground, resulting in a hard landing that sheared a bolt in the tail wheel assembly. This rendered directional control impossible and induced an uncontrolled ground loop. A contributing factor was…NTSB DEN01LA093Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · St. George, UTthe pilot's failure to sump all the fuel drains during preflight and the subsequent loss of power in the right engine during takeoff, the pilot feathering the wrong engine's propeller during the forced landing, the pilot improperly raising the landing gear…NTSB DEN01LA087Accident · No injuriesLimited investigationFinal reportMooney M20K · Bountiful, UTthe failure of the airplane's electrical system for an undetermined reason, which resulted in the collapse of the left main gear on landing.NTSB DEN01LA085Accident · Minor injuriesLimited investigationFinal reportBoyd Young Kolb Mark III · Brigham City, UTthe pilot's misjudged landing flare, which resulted in a hard landing. A factor was the propeller tip separation due to foreign object damage.NTSB DEN01FA074Accident · 2 fatalField investigationFinal reportVangilder Christen Eagle II · Ogden, UTthe flight instructor's failure to maintain aircraft control while maneuvering and the subsequent inadvertent stall/spin. A contributing factor was the flight instructor's lack of familiarity with the airplane.NTSB DEN01LA072Accident · No injuriesLimited investigationFinal reportCessna 182A · Richfield, UTloss of engine power during cruise as a result of fuel exhaustion due to the pilots failure to refuel. Contributing factors were the pilots inadequate aircraft preflight and the unsuitable terrain for a forced landing.NTSB DEN01LA065Accident · No injuriesLimited investigationFinal reportErco 415-C · Ivins, UTThe unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.NTSB DEN01LA069Accident · No injuriesLimited investigationFinal reportBoeing Stearman E75 · Heber, UTUncommanded locking of the right brake, resulting in loss of control and nose over during landing.NTSB DEN01LA068Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Morgan, UTthe pilot's failure to maintain directional control during landing roll which resulted in a collision with a snow bank on the edge of the runway.NTSB DEN01LA061Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot's failure to maintain directional control of the airplane during landing.NTSB DEN01FA056Accident · 1 fatalField investigationFinal reportBeech V35B · Green River, UTthe pilot's failure to maintain aircraft control as a result of incapacitation (from hypoxia) due to the in-flight decision to fly at altitudes where oxygen is required, without oxygen available.NTSB DEN01FA064Accident · 3 fatalField investigationFinal reportBeech V35 · Wendover, UTThe pilot flying at an altitude insufficient to clear surrounding terrain. Contributing factors were the pilot becoming lost/disoriented, his subsequent spatial disorientation, and dark night conditions.NTSB DEN01FA041Accident · 9 fatalField investigationFinal reportBeech 65-A90 · Lake Point, UTthe pilot's exercise of poor judgment and his failure to maintain a safe altitude/clearance above the water. Contributing factors were the weather conditions that included low ceiling and visibility obscured by snow and mist, an inadequately equipped airplane…NTSB DEN01LA039Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Spanish Fork, UTImproper weather evaluation by both the pilot and pilot/passenger, and the pilot's inadvertent VFR flight into IMC resulting in his spatial disorientation. Factors were the pilot rated passenger's spatial disorientation, fog, and night conditions.NTSB DEN01LA038Accident · No injuriesLimited investigationFinal reportAviat A-1A · Eden, UTthe pilot's failure to maintain aircraft control during a landing attempt. A contributing factor was his failure to check the snow conditions in the field before the flight.NTSB DEN01IA036Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-90-30 · Salt Lake City, UTthe captain's failure to maintain the proper glide path. Contributing factors were the weather conditions that included low visibility and fog.NTSB DEN01LA029Accident · No injuriesLimited investigationFinal reportCessna 172E · Salt Lake City, UTthe lack of suitable terrain for a forced landing. A factor was a total power loss due to a connecting rod failure.NTSB DEN01FA027Accident · 1 fatalField investigationFinal reportMooney M20K · Ogden, UTthe pilot's inadvertent VFR flight into IMC, which resulted in a collision with mountainous terrain. Contributing factors were the blowing snow, turbulence, dark night light conditions, and pilot fatigue due to the long flight day.NTSB DEN01LA020Accident · Serious injuriesLimited investigationFinal reportThomas VP-1 · West Jordan, UTthe lack of suitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the pilot to adjust the manual propeller pitch to permit the engine to achieve sufficient rpm for sustained flight, and the…NTSB DEN01FA021Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Antimony, UTthe pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his VFR flight into IMC, lack of instrument certification, spatial disorientation, low ceiling, and snow.NTSB DEN01LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTa forced landing to unsuitable terrain due to a loss of engine power as a result of carburetor icing. Factors were insufficient weather information regarding carburetor icing in the pilot's operating handbook for the aircraft and delay by the pilot in…NTSB DEN01LA015Accident · No injuriesLimited investigationFinal reportMurdock RAF 2000 GTX · Ogden, UTThe pilot's improper touchdown which resulted in a hard landing. Factors were lack of familiarity with the aircraft and lack of total experience.NTSB DEN01FA013Accident · 1 fatalField investigationFinal reportCessna 175 · Hanksville, UTthe pilot's failure to maintain control of the airplane while maneuvering at low altitude, and his physical impairment due to alcohol and drugs. A contributing factor was the downdraft.NTSB DEN01LA004Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Jensen, UTan undershoot due to misjudging distance/altitude during an emergency landing. Factors were: inadequate preflight, failure to refuel, fuel exhaustion, operating with an inoperative fuel gauge, and failure to attain a proper glide path during approach.NTSB DEN01LA001Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Ogden, UTThe pilot's failure to maintain a proper descent rate during landing flare/touchdown. A factor was the tail wheel failure due to overload.NTSB DEN00LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Blanding, UTThe pilot's failure to follow the checklist and lower the landing gear for landing. A factor was diverted attention.NTSB DEN01LA006Accident · No injuriesLimited investigationFinal reportNorth American T-28D · Heber City, UTthe failure of the nose wheel landing gear shimmy damper, which resulted in failure and collapse of the nose wheel landing gear during landing roll.NTSB DEN00LA163Accident · 2 fatalLimited investigationFinal reportNicholson Thorp T-18CWS · Tooele, UTFailure by the pilot to maintain control of the airplane during aerobatic maneuvers as a result of his alcohol impairment. Factors were: The pilot's inadequate planning and decision making and the inadequate altitude he choose for maneuvering.NTSB DEN00LA154Accident · No injuriesLimited investigationFinal reportWaco AGC-8 · Ogden, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were a tail wind, inadequate weather evaluation by the pilot, and lack of experience in make and model.NTSB DEN00FA149Accident · 1 fatalField investigationFinal reportCessna 172N · Kamas, UTThe pilot's improper inflight decision to enter a valley at low altitude and attempt a climb towards rising terrain. A factor was exceeding the airplane's climb performance.NTSB DEN00LA145Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Duchesne, UTThe pilot's use of excessive braking on soft terrain. Factors included fuel starvation, the fuel selector valve not engaging properly, the pilot's incorrect positioning of the fuel selector valve, and the soft terrain on which the forced landing was made.NTSB DEN00FA136Accident · 2 fatalField investigationFinal reportGrumman American AA-5 · Moab, UTThe pilot in command exercising poor judgment and exceeding the aircraft's turning capability. Contributing factors were the pilots' attention being diverted, flying into a known blind canyon, high temperature, and high density altitude.NTSB DEN00LA131Accident · Minor injuriesLimited investigationFinal reportRotorway Executive 162F · Tooele, UTThe pilot's inadequate weather evaluation, which resulted in a downwind landing, and his failure to maintain aircraft control. A factor was the tailwind.NTSB DEN00LA128Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Spanish Fork, UTThe pilot in command's failure to maintain aircraft directional control.NTSB DEN00LA124Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Logan, UTin-flight collision with a jacket, which blew out of the helicopter because the left passenger door was not properly secured prior to takeoff. A contributing factor was the pilot's failure to ensure the door was properly closed prior to takeoff.NTSB DEN00LA121Accident · No injuriesLimited investigationFinal reportCessna 172P · Price, UTThe pilot's failure to maintain directional control of the aircraft during landing roll. Factors were strong and gusty winds.NTSB DEN00IA133Incident · No injuriesIncident investigationFinal reportDiamond Aircraft Industries 20C-1 · Spanish Fork, UTThe company maintenance personnel's inadequate torquing procedures of the propeller attachment bolts which resulted in the fatigue failure of the propeller attachment bolts and the in-flight separation of the propeller.NTSB DEN00LA120Accident · No injuriesLimited investigationFinal reportNew Piper PA-46-350P · Spanish Fork, UTFailure by the pilot to maintain control of the aircraft during initial climb following takeoff.NTSB DEN00LA111Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Dutch John, UTThe pilot's failure to compensate for wind conditions and control the aircraft while landing in gusting wind conditions.NTSB DEN00LA106Accident · No injuriesLimited investigationFinal reportCessna 170B · Dutch John, UTThe pilot's failure to maintain clearance with the trees. Factors were a high-density altitude and wind gusts.NTSB DEN00LA105Accident · Minor injuriesLimited investigationFinal reportFroelich Lancair IV · Bountiful, UTThe loss of power for undetermined reasons and the pilot's unsuccessful remedial action (dive to avoid the power line). Contributing factors were the power line, the tires and the fence.NTSB DEN00LA103Accident · No injuriesLimited investigationFinal reportCessna 185B · Moab, UTThe fire in the engine compartment for unknown reason.NTSB DEN00LA101Accident · Minor injuriesLimited investigationFinal reportSchumacher Swearingen SX-300 · Richfield, UTFuel starvation due to the unavailability of fuel to the engine for undetermined reasons and the pilot's misjudgment of distance/altitude on final approach. Contributing factors were the pilot's premature gear extension and the berm.NTSB DEN00LA100Accident · No injuriesLimited investigationFinal reportCulver LFA · Moab, UTOverheating of the left brake, causing the wheel to lock. Factors were the pilot not being able to maintain directional control, a dirt berm, and a drainage ditch.NTSB DEN00LA099Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Milford, UTThe failure of the turbocharger scavenging pump resulting in the total failure of the engine, and the pilot's failure to compensate for wind conditions that led him to over fly the runway during his forced landing. Factors were the pilot's diverted attention…NTSB DEN00LA096Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20E · Hurricane, UTThe complete loss of power due to the separation of the magneto ground lead and the rough and unsuitable terrain during the forced landing.NTSB DEN00LA098Accident · No injuriesLimited investigationFinal reportRosenvall Avid MK IV · Salina, UTThe pilot's failure to maintain aircraft control during landing roll. A factor was gusting winds from nearby thunderstorms.NTSB DEN00LA090Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Boulder, UTThe pilot's failure to take timely remedial action when he realized a low fuel state. Factors were fuel exhaustion and low airspeed.