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 LAX08CA167Accident · No injuriesData collectionFinal reportCessna 182 · Moab, UTThe pilot's inadequate compensation for the tailwind condition, and improper use of additional power while taxiing. Contributing to the accident was soft ground and a gusting tailwind.NTSB SEA08CA150Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Logan, UTThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control during the landing roll. Contributing to the accident was a crosswind wind gust.NTSB LAX08CA138Accident · Serious injuriesData collectionFinal reportSchweizer 300C · Ogden, UTThe pilot under instruction's encounter with a settling with power condition, and the flight instructor's failure to maintain adequate rotor rpm during the subsequent go-around. Also causal was the instructor pilot's delayed remedial action during the…NTSB SEA08CA148Accident · No injuriesData collectionFinal reportAviat A-1B · Ogden, UTThe pilot's failure to maintain directional control during landing. A contributing factor was the variable wind condition.NTSB LAX08CA159Accident · No injuriesData collectionFinal reportRobinson R22 · Salt Lake City, UTThe student's improper use of the anti torque pedals during a practice hover autorotation, which resulted in the helicopter rolling over. Additional causes of the accident were the certificated flight instructor's inadequate supervision of the maneuver and…NTSB SEA08FA146Accident · 2 fatalField investigationFinal reportCessna 172R · Monticello, UTThe in-flight collision with mountainous terrain for undetermined reasons. *This report was modified on December 10, 2009.NTSB LAX08LA135Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Oljato, UTThe pilot's failure to achieve a normal touchdown location and loss of directional control during landing roll out. Contributing to the accident were the runway's soft surface and short length.NTSB LAX08CA129Accident · No injuriesData collectionFinal reportCessna A185F · Mexican Hat, UTThe pilot's failure to maintain directional control.NTSB SEA08LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Blanding, UTThe fatigue failure of the right main landing gear leg during the landing roll.NTSB SEA08CA111Accident · Minor injuriesData collectionFinal reportAviat A-1C-200 · Bluff, UTThe pilot's inadequate short-field landing procedure and excessive airspeed that resulted in a landing overrun. Contributing to the accident were gusting unfavorable winds, the short runway, and rocks off the departure end of the strip.NTSB LAX08TA116Accident · No injuriesFinal reportHughes TH-55 · Logan, UTThe pilot's inadequate compensation for the wind conditions and failure to maintain control of the helicopter while hovering. Contributing to the accident were the wind gusts and the pilot's lack of recent experience in helicopters.NTSB LAX08CA100Accident · Minor injuriesData collectionFinal reportQuestair Venture · Salt Lake City, UTThe failure of the left side master brake cylinder that led to a loss of braking capability during landing rollout. A contributing factor was the presence of a ditch next to the runway's end.NTSB LAX08CA079Accident · No injuriesData collectionFinal reportCessna 180H · Moab, UTThe pilot's inadequate compensation for wind conditions and failure to maintain directional control. A contributing factor was the unexpected dust devil.NTSB LAX08CA074Accident · Minor injuriesData collectionFinal reportCessna 172M · Richfield, UTThe pilot's improper use of the flight controls and failure to maintain directional control.NTSB SEA08LA090Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Spanish Fork, UTThe fatigue failure of the nose wheel fork assembly attachment stud/bolt during takeoff initial climb, and the collapse of the nose gear during landing.NTSB SEA08CA092Accident · No injuriesData collectionFinal reportPiper PA-24 · Bountiful, UTThe pilot's failure to extend the landing gear.NTSB SEA08LA083Accident · No injuriesLimited investigationFinal reportCessna 180 · Moab, UTThe pilot's failure to maintain directional control of the tail wheel-equipped airplane during the flare/touchdown phase of a three-point landing.NTSB SEA08CA075Accident · No injuriesData collectionFinal reportCessna 140 · Logan, UTThe dual-student's excessive brake application, and the flight instructor's inadequate supervision of the flight.NTSB SEA08LA069Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Parowan, UTThe pilot's improper in-flight decision not to over fly/inspect the snow covered runway prior to landing, and his failure to align the airplane over the centerline of the runway. Contributing to the accident was the snow covered runway, the airport operator's…NTSB LAX08CA051Accident · No injuriesData collectionFinal reportLuscombe 8E · Brigham City, UTThe failure of the landing gear/ski attachment assembly due to inadequate maintenance.NTSB SEA08FA045Accident · 3 fatalField investigationFinal reportBeech A36TC · Minersville, UTThe flying pilot's continued flight into instrument meteorological conditions and failure to maintain adequate terrain clearance during cruise. Contributing to the accident were low clouds, reduced visibility and mountainous terrain.NTSB SEA08LA025Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Salt Lake City, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a written checklist.NTSB LAX08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident were the dark conditions.NTSB LAX08CA013Accident · No injuriesData collectionFinal reportPoser DM 582 Buckeye · Hurricane, UTThe pilot's inadequate compensation for the existing wind conditions and subsequent failure to maintain aircraft control.NTSB SEA08LA008Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Santaquin, UTA total loss of engine power for undetermined reasons. Factors include rough/uneven vegetation-covered terrain at the location where the pilot executed his emergency forced landing.NTSB SEA08LA007Accident · Minor injuriesLimited investigationFinal reportHaring Clay RV8A · Brigham City, UTFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. Factors include an inaccurate fuel quantity measuring system, and soft terrain encountered during the landing roll.NTSB SEA08CA004Accident · No injuriesData collectionFinal reportPiper PA 28-151 · Salt Lake City, UTThe leak at the fuel line fitting, which resulted in a fire during engine start.NTSB SEA08CA002Accident · Minor injuriesData collectionFinal reportRobinson R44 II · Lake Powell, UTThe pilot's inadequate preflight inspection and failure to remove a tie-down strap before departure.NTSB SEA07LA251Accident · No injuriesLimited investigationFinal reportCessna 172M · Thompson, UTThe pilot's failure to maintain terrain clearance while maneuvering in a box canyon.NTSB SEA07LA276Accident · No injuriesLimited investigationFinal reportWerner Vari-Eze · Tooele, UTThe loss of engine power for an undetermined reason. Contributing factors were the lack of suitable terrain for the forced landing and the wind shear conditions encountered during the forced landing attempt.NTSB SEA07LA250Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Morgan, UTThe pilot's failure to maintain control of the glider while maneuvering on final approach to landing, which resulted in an collision with a tree. A factor was the wind gust.NTSB SEA07FA240Accident · Serious injuriesField investigationFinal reportFlight Design Ctsw · St. George, UTThe loss of engine power during approach for an undetermined reason. Contributing to the accident was the lack of suitable terrain for the forced landing.NTSB LAX07LA257Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Heber, UTThe pilot's failure to maintain sufficient airspeed during landing, resulting in an inadvertent stall/spin, undershoot and collision with the ground.NTSB LAX07CA255Accident · No injuriesData collectionFinal reportBeech D55 · Heber, UTThe pilot's failure to lower the landing gear during landing.NTSB LAX07CA249Accident · No injuriesData collectionFinal reportAviat Husky A-1B · Moab, UTThe pilot's failure to maintain directional control that resulted in a ground loop.NTSB ENG07IA034Incident · No injuriesIncident investigationFinal reportLearjet · Salt Lake City, UTThe fatigue fracture of the fan blade due to the blade vendor's improper setup of the forging dies, which resulted in fan blades with airfoils that were below the minimum thickness in the highest stressed area of the airfoil and resulted in operating stresses…NTSB SEA07CA222Accident · No injuriesData collectionFinal reportPiper PA-18-150 · St. George, UTThe pilot's failure to maintain directional control and excessive braking during the landing roll.NTSB LAX07CA213Accident · Minor injuriesData collectionFinal reportDiamond DA40-G1000 · Strawberry Rese, UTThe pilot failed to maintain adequate terrain clearance. Contributing to the accident was the pilot's decision to turn into upsloping terrain at a low altitude.NTSB LAX07CA202Accident · No injuriesData collectionFinal reportCessna 172S · Spanish Fork, UTThe pilot's misjudged landing flare resulting in a porpoise and hard touchdown.NTSB LAX07CA201Accident · No injuriesData collectionFinal reportCessna 172K · Newcastle, UTThe pilot's inadequate compensation for the gusty and crosswind condition, and his failure to maintain control of the airplane during takeoff.NTSB SEA07LA177Accident · 2 fatalLimited investigationFinal reportMooney M20C · Price, UTThe pilot's failure to maintain clearance from power transmission lines while on a night straight-in visual flight rules approach. Factors include a power transmission line about one and three-tenths mile off the approach end of the runway, and the pilot's…NTSB SEA07CA171Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Park City, UTThe pilot's failure to maintain rotor RPM during hover taxi. A contributing factor was the high density altitude weather condition.NTSB SEA07CA167Accident · No injuriesData collectionFinal reportRallison Rotorway 162F · Logan, UTThe total loss of engine power due to the pilot inadvertently deactivating the rotor drive clutch assembly. A contributing factor was the downhill terrain condition where he landed, which exceeded the slope limitations of the helicopter.NTSB SEA07CA168Accident · No injuriesData collectionFinal reportCessna 172D · Halls Crossing, UTThe pilot's failure to select suitable terrain for landing. A contributing factor was the rough/uneven terrain.NTSB SEA07LA188Accident · Minor injuriesLimited investigationFinal reportVance Renegade Spirit · Blanding, UTThe loss of engine power during cruise due to oil starvation.NTSB LAX07LA184Accident · No injuriesLimited investigationFinal reportBrook Lancair IV-P · Parowan, UTA loss of engine power due to engine inlet icing. Contributing to the accident was the lack of engine inlet anti-icing capability.NTSB LAX07CA185Accident · Minor injuriesData collectionFinal reportCessna 172S · Wendover, UTThe pilot's failure to maintain directional control during the landing roll.NTSB SEA07GA142Accident · 2 fatalFinal reportChristen Industries A-1 · Loa, UTThe pilot's failure to maintain an adequate airspeed during low altitude maneuvering flight that resulted in a stall. The pilot's decision to operate the airplane at a center of gravity beyond the rear limit, the low altitude of the flight, and the high…NTSB SEA07LA137Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Moab, UTThe pilot's failure to maintain control of the airplane while maneuvering after takeoff.NTSB SEA07LA131Accident · No injuriesLimited investigationFinal reportCessna 150M · Spanish Fork, UTThe student pilot's inadequate compensation for gusty crosswind conditions, and his failure to maintain directional control during the landing roll. Factors include gusty crosswinds, and a ditch near the runway environment.