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 SEA92LA111Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Pleasant, UTThe pilot in command's failure to maintain directional control. Factors contributing to the accident were: weather (gusts) and terrain (berm).NTSB SEA92LA082Accident · No injuriesLimited investigationFinal reportBeech B36TC · Mona, UTA fatigue failure to the crankshaft and a manufacturing material defect.NTSB SEA92LA076Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B · Magna, UTThe overheat of the engine combustion section, and the failure of the turbine blades.NTSB SEA92LA066Accident · No injuriesLimited investigationFinal reportAvid Mark IV · Soldier Summit, UTThe fuel pump delivering too low fuel pressure. A factor contributing to the accident was the snow covered terrain.NTSB SEA92LA051Accident · No injuriesLimited investigationFinal reportBeech A36TC · Salt Lake City, UTThe pilot's inadvertent activation of the fuel boost pump. Factors to the accident were: poor aircraft preflight. Diverted attention, and inadequate remedial action.NTSB SEA92LA050Accident · No injuriesLimited investigationFinal reportCessna 182D · Monroe, UTAn aborted takeoff was not performed. The wet, soft runway was a factor.NTSB SEA92FA045Accident · 2 fatalField investigationFinal reportBell 206B · Wellington, UTThe pilot's continued flight into adverse weather conditions and an excessive rate of descent. Factors contributing to the accident were fog, rain, low ceilings, night conditions, snow covered terrain and pilot disorientation.NTSB SEA92LA043Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Jordan, UTThe pilot in command's failure to maintain control of the aircraft. A factor contributing to the accident was gusty wind conditions.NTSB SEA92FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ogden, UTThe improper decision by the instructor pilot to perform maintenance in flight and his failure to maintain terrain clearance. Factors relating to the accident were the dark night light conditions, mountainous terrain in the area, and the instructor diverting…NTSB SEA92LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTDirectional control was not maintained. A factor to the accident was: the pilot's lack of total flight experience.NTSB SEA92LA023Accident · No injuriesLimited investigationFinal reportKitfox Ten Model 2 · West Jordan, UTThe loss of engine power when it overheated due to low coolant level, which resulted from the inadequate preflight inspection by the pilot. A factor relating to the accident was the obstruction in the landing area.NTSB SEA92FA016Accident · 1 fatalField investigationFinal reportBell 206B · Salt Lake City, UTThe pilot failed to maintain directional control. Factors to the accident were: inadeqaute remedial action, over confidence in personal ability, and lack of recent expereince.NTSB SEA92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Monticello, UTInadequate maintenance/overhaul of the engine, and subsequent failure of the #5 piston (hole burned in piston), due to pre-ignition and/or detonation. Rough/uneven terrain in the emergency landing area was a related factor.NTSB SEA92LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA28-161 · Duchesne, UTFuel exhaustion due to the pilot's inattention and becoming lost. A factor to the accident was the night conditions.NTSB SEA91TL#02Accident · No injuriesClass 3Final reportHiller-Soloy UH-12E · Vernal, UTNTSB SEA91LA241Accident · No injuriesLimited investigationFinal reportCessna 172N · St George, UTImproper planning/decision by the student pilot. The crosswind and the student's lack of experience were related factors.NTSB SEA91FA235Accident · 1 fatalField investigationFinal reportPiper PA32RT-300T · Mayfield, UTPoor in flight planning/decision. Factors to the accident were: flight into known adverse weather, inadvertent VFR flight into IMC and inadequate clearance.NTSB SEA91LA222Accident · No injuriesLimited investigationFinal reportCessna 170B · Heber City, UTThe pilot's failure to maintain directional control during landing ground roll. A factor relating to the accident was the crosswind weather conditions.NTSB SEA91LA194Accident · No injuriesLimited investigationFinal reportLet L-13 · Wallsburg, UTThe in flight encounter with downdraft winds and the lack of suitable terrain in the area for a landing.NTSB SEA91LA188Accident · No injuriesLimited investigationFinal reportWaco KNF · Wendover, UTPilot installed an improper 'o' ring which restricted normal landing gear extension and subsequent loss of control by the pilot.NTSB SEA91LA162Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · West Jordan, UTThe pilot's delayed switching of the fuel tank selector, the engine failure from fuel starvation and the unsuitable terrain for a forced landing.NTSB SEA91LA160Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Bryce Canyon, UTThe pilot's entry into a stall/mush condition shortly after take off. Contributing to the accident was the high density altitude.NTSB SEA91IA159Incident · No injuriesIncident investigationFinal reportGalaxy GLX-7 · Provo, UTThe pilot's diverted attention. Facotrs include on ground contact with a fence.NTSB SEA91LA155Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R · Milford, UTFuel exhaustion, and the pilot's misjudgment of proper descent rate. Factors include inadequate preflight planning, poor in-flight decision, becoming lost/disoriented, and a fence.NTSB SEA91LA149Accident · No injuriesLimited investigationFinal reportCessna 210 · Salt Lake City, UTThe pilot's poor inflight planning and decisions in that he failed to anticipate wake turbulence from the departing helicopter.NTSB SEA91LA133Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Pleasant Grove, UTThe pilot's failure to maintian proper airspeed while on final approach.NTSB SEA91LA132Accident · Minor injuriesLimited investigationFinal reportDuffy Smith Mini Plane · Ogden, UTA premature liftoff and subsequent stall.NTSB SEA91FA131Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Nephi, UTPoor inflight planning and decisions. Factors to the accident were: an uncontrolled stall/spin, and inadequate airspeed.NTSB SEA91LA115Accident · Serious injuriesLimited investigationFinal reportDave Ronneberg LONG-EZE · Kanab, UTLoss of aircraft control in flight which resulted from the pilot's diverted attention and his failure to maintain proper airspeed.NTSB SEA91LA118Accident · No injuriesLimited investigationFinal reportBeech A36TC · Ogden, UTLoss of control by the pilot due to inadequate preflight planning and preparation which resulted in over gross weight aircraft loading. A factor relating to the accident was the high density altitude weather conditions.NTSB SEA91LA113Accident · No injuriesLimited investigationFinal reportBeech B23 · Spanish Fork, UTThe pilot did not adequately recover from a bounced landing. Factors to the accident were: a poorly planned approach, and the pilot's lack of total flight experience.NTSB SEA91LA114Accident · No injuriesLimited investigationFinal reportCessna TR182 · Green River, UTWorn brakes. Contributing to the accident was: poor maintenance.NTSB SEA91LA098Accident · Serious injuriesLimited investigationFinal reportRichard Cheney Teratorn Tierra II · Morgan, UTThe inadvertant stall and the pilot's steep banked turn. Factors relating to the accident were the pilot's lack of qualification to conduct the flight and the strong tailwind conditions.NTSB SEA91LA094Accident · No injuriesLimited investigationFinal reportCessna 180 · Vernal, UTThe pilot's impairment due to alcohol consumption and his failue to control the airplane during landing.NTSB SEA91LA082Accident · No injuriesLimited investigationFinal reportCessna 172M · Ogden, UTThe pilot's poorly planned approached for landing. Factors to the accident were: an excessive airspeed, and the inadequacy of the pilot's recovery from a bounced landing.NTSB SEA91LA064Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Loa, UTThe pilot-in-command's failure to maintain airspeed on takeoff climb in a turn resulting in an inadvertnent stall and subsequent in flight collision with terrain. Contributing to the accident was a crosswind with gusts.NTSB SEA91LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe pilot did not maintain directional control of the airplane during the landing roll.NTSB SEA91LA050Accident · 4 fatalLimited investigationFinal reportBeech F33A · Ogden, UTThe pilot elected to fly into known adverse weather and encountered icing conditions. Contributing to the accident was the pilot's inadequate evaluation of the weather and a loss of engine power for undetermined reasons.NTSB SEA91LA048Accident · Minor injuriesLimited investigationFinal reportMaule M-5-235C · Draper, UTAn undetermined loss of engine power.NTSB SEA91LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Salt Lake City, UTAn undetermined loss of engine power.NTSB SEA91LA041Accident · Minor injuriesLimited investigationFinal reportAero Commander 200D · Tooele, UTEngine fuel system blockage due to ice formation in the fuel system during a period of weather temperature extremes. A factor was the lack of suitable terrain for a forced landing.NTSB SEA91LA037Accident · No injuriesLimited investigationFinal reportCessna 152 · Logan, UTThe certified flight instructor's inability to regain directional control after it was lost by his dual student on an icy, snowy runway.NTSB SEA91LA036Accident · No injuriesLimited investigationFinal reportBeech D35 · Cedar City, UTA loss of engine power due to induction system icing. Factors related to the accident were: the adverse weather condition, and a blocked induction air filter.NTSB SEA91FA120Accident · 1 fatalField investigationFinal reportCessna 182H · Thompson, UTThe pilot's misjudged descent. Contributing to the accident was the dark night conditions.NTSB SEA91LA028Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Vernal, UTA malfunction/failure of the helicopter's main rotor lead-lag damper.NTSB SEA91FA026Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Salt Lake City, UTThe pilot's intentional buzzing of uninhabited island in the great Salt lake and his misjudging the timing of a pull-up maneuver to clear rising terrain of a ridgeline.NTSB SEA91LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Brigham City, UTThe pilot did not maintain a proper climb rate.NTSB SEA90LA186Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Kamas, UTPoor inflight planning by the pilot. The airplane encountered a possible downdraft condition while maneuvering in mountainous terrain which resulted in an inflight collision with trees.NTSB SEA90LA187Accident · Serious injuriesLimited investigationFinal reportCessna 150D · Park City, UTThe pilot's lack of understanding of aircraft performance and meteorological conditions when flying at high density altitude in close proximity to mountainous terrain.NTSB SEA90LA176Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Ogden, UTThe failure of the pilot to correct the position of the fuel tank selector, causing erratic engine operation and loss of power.