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 SEA07CA128Accident · No injuriesData collectionFinal reportForney F-1 · Morgan, UTThe pilot's failure to maintain clearance of the hill on final approach to a landing. Contributing factors were the downdraft weather condition, the hilly terrain, and his lack of familiarity with the geographical area.NTSB LAX07LA163Accident · 1 fatalLimited investigationFinal reportPiper PA-25-235 · Delta, UTthe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in a stall and collision with terrain.NTSB LAX07CA169Accident · No injuriesData collectionFinal reportCessna 172M · St. George, UTthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB LAX07CA165Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Moab, UTThe pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush. Also causal was the pilot's failure to abort the takeoff in a timely way. A factor in the accident was the high density altitude.NTSB SEA07FA124Accident · 1 fatalField investigationFinal reportCessna P210N · Spanish Fork, UTAn engine oil line leak and subsequent engine compartment fire while in cruise flight.NTSB SEA07CA115Accident · Minor injuriesData collectionFinal reportCessna 180 · Brigham City, UTThe pilot's failure to maintain directional control during the landing roll. Factors include variable winds, and crosswinds, and an abrupt drop-off at the runway shoulder.NTSB LAX07CA131Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Spanish Fork, UTThe student pilot's improper use of the flight controls, which induced a dynamic rollover. Also causal was the certificated flight instructor's inadequate supervision and delayed remedial action.NTSB SEA07LA087Accident · Serious injuriesLimited investigationFinal reportBurdette RV-3 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll. Factors include an earthen berm near the point where the aircraft departed the side of the runway.NTSB SEA07CA083Accident · No injuriesData collectionFinal reportDuffy/Wagner Vans RV-4 · Ogden, UTThe pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA07CA080Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta 2 · Taylorsville, UTThe flight instructor's failure to maintain aircraft control during the flare/touchdown while practicing an autorotation which resulted in a hard landing. A factor which contributed to the accident was the downdraft wind condition.NTSB LAX07LA114Accident · No injuriesLimited investigationFinal reportMooney M20B · St. George, UTOil contamination of the right magneto. Factors were the airplane owner's failure to comply with manufacturer's service bulletins and overhaul porcedures.NTSB LAX07FA103Accident · 3 fatalField investigationFinal reportPiper PA-28-235 · Tooele, UTThe pilot exceeded the design stress limits of the airplane, which resulted in the in-flight separation of the wings and horizontal stabilizers. Contributing to the accident were the night lighting conditions, clouds, turbulence and icing conditions.NTSB SEA07CA064Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Glen Canyon Nat, UTThe pilot's intentional flight over water at low altitude and his subsequent failure to maintain adequate clearance from the water. A contributing factor was the glassy surface condition of the lake.NTSB SEA07IA058Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Parowan, UTThe inadequate design of the engine mount, which caused an uncommanded left turn during the landing roll, loss of directional control, and impact with snow-covered terrain.NTSB SEA07LA028Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Bountiful, UTThe pilot's improper decision to fly up a mountain canyon at low level without knowledge of the wind conditions. Factors associated with the accident are gusty winds, downdrafts, and rough/uneven terrain.NTSB SEA07CA027Accident · No injuriesData collectionFinal reportPiper PA-12 · Antelope Island, UTThe pilot's excessive braking during a precautionary landing at an off-airport landing area. A contributing factor was the pilot's non-standard modification of the oil cooler, which resulted in high engine oil temperature.NTSB SEA07LA023Accident · No injuriesLimited investigationFinal reportCessna 180K · Woods Cross, UTThe pilot's failure to maintain directional control during the takeoff roll. Factors include a ditch near the side of the runway.NTSB SEA07LA021Accident · 1 fatalLimited investigationFinal reportHughes 369E · Jensen, UTThe pilot's failure to maintain clearance with the transmission wires due to an inadquate visual lookout while maneuvering during a search and rescue flight.NTSB SEA07LA018Accident · No injuriesLimited investigationFinal reportAviat A-1B · Fruitland, UTThe pilot's improper in-flight decision to land on snow covered terrain. Deep snow on the terrain that the pilot chose to land on was a factor in this accident.NTSB SEA07LA013Accident · No injuriesLimited investigationFinal reportCessna 172S · Richfield, UTThe student pilot's inability to compensate for the gusty crosswinds during the initial part of the landing roll, which resulted in a loss of control and a noseover. Factors associated with the accident are gusty crosswinds, and a mound/berm of dirt alongside…NTSB SEA07FA012Accident · 1 fatalField investigationFinal reportCessna 172M · Escalante, UTThe pilot's failure to maintain aircraft control. Contributing factors were the pilot's lack of experience of flying on instruments on a dark night and in rainy weather.NTSB DEN07CA013Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Monticello, UTan airframe vibration for reasons undetermined, resulting in the pilot performing a precautionary landing, and obstacle clearance not possible.NTSB SEA06LA185Accident · Minor injuriesLimited investigationFinal reportCessna T210M · Delta, UTA loss of engine power for an undetermined reason during cruise flight.NTSB SEA06CA181Accident · No injuriesData collectionFinal reportCessna 172M · Moab, UTThe pilot's failure to obtain current NOTAMS which resulted in an on-ground collision with a construction berm while landing.NTSB SEA06CA180Accident · No injuriesData collectionFinal reportBeech B36TC · Cedar City, UTInadvertent collision with a deer during takeoff. A contributing factor was night conditions.NTSB SEA06CA179Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Kanab, UTThe pilot's failure to maintain aircraft control during the takeoff roll. Contributing factors were the rough/uneven conditions of the dirt runway, the wind gusts, and the berms and ditches on both sides of the runway.NTSB SEA06LA175Accident · Serious injuriesLimited investigationFinal reportStraw T-Bird II · Leamington, UTThe pilot's loss of aircraft control (control not possible) due to the failure of the left elevator control surface which was the result of a missing inboard bolt (for undetermined reason) which holds the left elevator bow in place.NTSB SEA06CA173Accident · No injuriesData collectionFinal reportCessna 182RG · Fairfield, UTThe failure of the pilot-rated-passenger to maintain adequate airspeed on final during a simulated engine-out approach, resulting in the aircraft descending into the terrain about 40 feet short of the runway, and the failure of the pilot-in-command to take…NTSB SEA06CA161Accident · No injuriesData collectionFinal reportBell 206L-3 · Salt Lake City, UTThe failure of the pilot to maintain clearance by allowing the helicopter to drift backwards, resulting in its tail rotor striking a hangar.NTSB SEA06FA146Accident · 2 fatalField investigationFinal reportSpectrum Aeronautical 33 · Spanish Fork, UTIncorrect installation by company maintenance personnel of the aft upper torque tube bell crank resulting in roll control that was opposite to that commanded in the cockpit. Contributing factors were the lack of maintenance documentation detailing the…NTSB SEA06LA141Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Grantsville, UTA lack of lubrication for undetermined reasons, which resulted in the failure of the Nos. 2, 3, 4, 5 and 6 connecting rods, a subsequent total loss of engine power during descent, which resulted in a forced landing. A factor in the accident was the soft sand.NTSB SEA06LA135Accident · No injuriesLimited investigationFinal reportHughes 369D · Moab, UTThe failure of the collective bungee support bracket due to non-compliance with a service information notice, which resulted in the pilot executing a precautionary autorotative landing. A contributing factor was the lack of suitable terrain for the landing.NTSB SEA06CA129Accident · Minor injuriesData collectionFinal reportMooney M-20F · Summit, UTThe pilot's failure to maintain clearance from the terrain during a climb. Encounter with a severe downdraft, and mountainous terrain were factors.NTSB SEA06LA124Accident · No injuriesLimited investigationFinal reportHughes 369D · Salt Lake City, UTA loss of rotor rpm for undetermined reasons, resulting in a hard landing on top of the commercial building over which the helicopter was working.NTSB SEA06LA121Accident · Minor injuriesLimited investigationFinal reportBell 206L · Vernal, UTThe loss of tail rotor effectiveness during an attempted precationary landing after a takeoff over uneven, sloping, brush-covered terrain. Factors include the pilot using the wrong performance chart while completing his preflight performance calculations, the…NTSB SEA06FA116Accident · 3 fatalField investigationFinal reportLciv Lancair IV-P Propjet · Provo, UTThe pilot's failure to maintain altitude/clearance during a VFR approach, which resulted in an in-flight collision with water. Contributing factors were the dark night light conditions and the low clouds.NTSB SEA06CA113Accident · No injuriesData collectionFinal reportPiper PA-20 · Salt Lake City, UTAn improper flare and the pilot's failure to maintain directional control during the landing which resulted in the aircraft nosing over. Delayed remedial action was a factor.NTSB SEA06LA110Accident · No injuriesLimited investigationFinal reportCessna A185E · Park Valley, UTIncapacitation of the pilot secondary to a myocardial infarction. A ditch was a contributing factor.NTSB SEA06CA108Accident · Minor injuriesData collectionFinal reportGrumman AA-1B · Bountiful, UTAn obstructed windshield which resulted in the pilot misjudging the distance/altitude during an emergency landing. An oil leak as a result of a leaking crankshaft seal was a factor.NTSB SEA06CA093Accident · No injuriesData collectionFinal reportZenair CH 2000 · Tooele, UTThe flight instructor's inadequate supervision of the student pilot during the landing flare, which resulted in a hard landing. A contributing factor was the student pilot's failure to maintain aircraft control during the landing flare.NTSB SEA06CA083Accident · No injuriesData collectionFinal reportCubCrafters CC-18-180 · Logan, UTThe pilot receiving instruction failed to maintain airplane directional control during the landing roll, and the flight instructor's inadequate supervision. An inadvertent ground loop was a factor.NTSB DEN06FA065Accident · 1 fatalField investigationFinal reportCessna T310R · Heber City, UTthe pilot's loss of aircraft control due to the loss of engine power due to induction icing. Contributing factors include the in-flight encounter with structural icing, the severe turbulence, and the pilot's increased workload.NTSB SEA06LA075Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Bullfrog Basin, UTA high airspeed at touchdown resulting in a high ground speed during the landing roll. Downhill sloping runway, a tailwind, the pilot's delayed remedial action and rough terrain off the end of the runway were factors.NTSB SEA06CA072Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Tooele, UTThe pilot's failure to maintain control of the helicopter during the takeoff initial climb, which resulted in an in-flight collision with the ground. A contributing factor was the gusty wind condition.NTSB SEA06CA069Accident · No injuriesData collectionFinal reportKearsley Exec 162F · Morgan, UTThe pilot's inadequate in-flight decision to attempt to hover out of ground effect above the kit manufacturers published recommendations. A factor was mountainous terrain.NTSB SEA06FA036Accident · 1 fatalField investigationFinal reportBeech 35-A33 · Heber City, UTThe pilot's continued VFR flight into IMC and his subsequent failure to maintain terrain clearance while maneuvering resulting in an in-flight collision with terrain. Contributing factors were low ceilings, snow, and mountainous terrain.NTSB SEA06TA028Accident · Serious injuriesFinal reportAerospatiale SA-319B · Escalante, UTThe pilot's inadequate remedial action when ground resonance was encountered during landing. Contributing factors were the rough/uneven terrain and company inadequate maintenance.NTSB SEA06CA020Accident · No injuriesData collectionFinal reportCessna 195A · Heber City, UTThe failure of the right brake, which resulted in a loss of directional control during the landing roll and a nose down.NTSB SEA06CA017Accident · No injuriesData collectionFinal reportCessna T210M · Salt Lake City, UTA loss of engine power due to fuel starvation as a result of the pilot's improper in-flight decision not to use the before landing checklist. A factor which contributed to the accident was the improper position of the mixture control.NTSB SEA06CA009Accident · No injuriesData collectionFinal reportCessna A185F · Lake Powell, UTThe pilot's failure to maintain clearance from terrain during an aborted water takeoff run which resulted in the airplane colliding with a canyon wall. A contributing factor was the submerged object that the airplane struck during the takeoff run.