NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 ANC90FA117Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Farewell, AKAn internal engine failure due to a thermal fatigue failure of the 1st stage turbine wheel as a result of overtemperature. The high rough/uneven terrain prevented a successful autorotation.NTSB SEA90LA135Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Toutle, WAThe pilot's improper planning/decision by operating and maneuvering the heliocpter in a regime where he could not maintain rotor RPM. The high density altitude and rough terrain were related factors.NTSB SEA90LA134Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Yamhill, ORThe pilot's failure to retract the flaps during go-around.NTSB SEA90LA132Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bellingham, WACollision with a submerged object.NTSB MKC90LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Wichita, KSFuel exhaustion and refueling not performed by the pilot in command.NTSB MKC90LA145Accident · Minor injuriesLimited investigationFinal reportMonnett Sonerai II · Cherokee, IAAircraft control not maintained by the pilot in command.NTSB LAX90LA256Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Santa Catalina, CAThe engine failure due to carburetor ice and the pilots improper use of carburetor heat.NTSB FTW90LA145Accident · No injuriesLimited investigationFinal reportCessna 177RG · Arlington, TXThe pilot misjudged airplane attitude during the landing flare.NTSB DEN90FA161Accident · 2 fatalField investigationFinal reportCessna 150L · Hettinger, NDThe pilot's failure to maintain airspeed during climbout. Contributing factors were: the pilot's lack of recent experience, and the over maximum gross weight condition of the aircraft.NTSB ANC90FA116Accident · Minor injuriesField investigationFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's failure to maintain flying speed during climbout which resulted in a stall.NTSB SEA90LA130Accident · 1 fatalLimited investigationFinal reportLarsen Charles Bennett Phoenix Vendetta LS · Boulder City, NVPilot did not maintain an adequate airspeed while in the pattern for landing which resulted in the airplane entering spin.NTSB MKC90LA147Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egypt, ARThe pilot's failure to maintain directional control. A factor related to the accident was the soft/muddy area on the runway.NTSB MKC90LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D-1 · Fair Oaks, ARTail rotor cable disengagement due to inadequate maintenance.NTSB MIA90LA151Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Naples, FLImproper maintenance of the fuel system resulting in the loss of power due to internal contamination of the engine driven fuel pump.NTSB LAX90LA253Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Springerville, AZThe encounter with a downdraft beyond the climb capability of the aircraft.NTSB LAX90FA252Accident · 3 fatalField investigationFinal reportCessna T210N · Pinon, AZFailure of the pilot to attain the proper touchdown point during the landing, her delay in initiating a go-around (aborted landing), and her failure to remain clear of power lines on rising terrain during the aborted landing. Factors related to the accident…NTSB FTW90LA139Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31ATC · Denton, TXThe pilot failures to properly in stall a oil line which resulted in a complete loss of engine power after the oil supply was exhausted.NTSB DEN90LA162Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Logan, UTThe pilot's failure to maintain directional control and his improper use of the wheel brakes. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.NTSB DEN90LA160Accident · Minor injuriesLimited investigationFinal reportCessna 180B · Akron, COThe pilot's failure to correct a swerve during landing roll. A factor was wind gusts.NTSB DEN90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Clarkston, UTJammed ailerons resultant from the collision with crops.NTSB DEN90FA159Accident · 1 fatalField investigationFinal reportCessna P210R · Ogden, UTFailure of the #1 piston due to pre-ignition/detonation in the #1 cylinder, and inadequate visual lookout by the pilot (his failure to see-and-avoid the obstruction). The obstruction (power line) was a related factor.NTSB CHI90LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Pulaski, WIThe pilot's failure to maintain positive control of the airplane while landing. Factors related to the accident were the pilot's lack of total flight experience, and inadequate compensation for crosswind conditions.NTSB CHI90DER01Accident · No injuriesFinal reportPiper PA-28-140 · New Richmond, WIThe pilot's inadequate preflight inspection, which resulted in the gascolator drain being left open.NTSB BFO90FA063Accident · 1 fatalField investigationFinal reportBeech P35 · Disputanta, VAThe pilot's indequate inflight decision which resulted in flight into adverse weather condition. Contributing to the accident was thunderstorms and the pilot exceeding the design limits of the airplane.NTSB ATL90LA142Accident · No injuriesLimited investigationFinal reportCessna T210L · Memphis, TNFuel mismanagement by the pilot which resulted in fuel starvation during final approach.NTSB SEA90LA131Accident · No injuriesLimited investigationFinal reportCessna TU206G · Roche Harbor, WAThe pilot's failure to maintain directional control after encountering unstable atmospheric conditions during final approach to landing.NTSB SEA90LA127Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Renton, WALoss of engine power due to fuel starvation. The cause of the accident was the pilot displayed poor inflight planning by not adequately following procedures or directives associated with fuel consumption.NTSB NYC90LA183Accident · No injuriesLimited investigationFinal reportCessna 310R · Mansfield, OHAn unavoidable collision with a deer while taking off which bent the drag brace and prevented it from locking. Factors related to the accident were the night conditions which reduced the pilots visibility to the illuminated area of the landing lights.NTSB NYC90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Yarmouth, MAA power loss due to fuel starvation. Factors related to the accident were: improper emergency procedures by the pilot and an improperly reading fuel gauge.NTSB LAX90LA251Accident · No injuriesLimited investigationFinal reportBeech A36 · Los Banos, CAThe pilot's use of excessive airspeed during landing and his not attaining a proper touchdown point on the runway.NTSB LAX90FA250Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Pleasant Valley, AZAn inadvertent spin after failure to maintain airspeed. Factors include inadequate preflight, and an improperly maintained lap belt.NTSB DEN90LA156Accident · No injuriesLimited investigationFinal reportCessna 188 · Michigan, NDThe failure of the pilot to maintain proper alignment during landing.NTSB CHI90FA174Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Ashton, ILA loss of aircraft control for an unknown reason, while en route in instrument meteorological conditions (IMC) on a dark night, and the pilot exceeding the design stress limits of the aircraft while attempting to recover from uncontrolled flight. Factors…NTSB NYC90FA156Accident · No injuriesField investigationFinal reportBell 206 B3 · Teterboro, NJFailed power turbine shaft. Factors in the accident were corrosion on the power turbine shaft and inadequate manufacturer's service bulletins.NTSB MIA90LA150Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · ChristianstedThe failure of the pilot to evaluate weight, temperature, and power available prior to takeoff and then performing a left pedal turn after takeoff resulting in the helicopter desending even though full power was applied.NTSB LAX90T#A08Accident · No injuriesClass 3Final reportBell 206B · San Carlos, AZNTSB DEN90FA155Accident · Serious injuriesField investigationFinal reportCessna 170 · Fillmore, UTThe pilot's failure to maintain airspeed which resulted in inadvertent stall.NTSB CHI90LA173Accident · No injuriesLimited investigationFinal reportCessna C177B · Northport, MIPilot's delayed decision to abort the landing, and the aircraft's resultant inadequate clearance/altitude and impact with trees.NTSB CHI90DEP07Accident · No injuriesFinal reportBell 47-G2 · Hatley, WIThe partial loss of power due to sticking intake valves.NTSB SEA90LA141Accident · No injuriesLimited investigationFinal reportCessna TU206G · Sheridan, ORInadvertent engagement of the autopilot during the flare for landing.NTSB SEA90LA128Accident · No injuriesLimited investigationFinal reportCessna 150C · Sutherlin, ORLoss of engine power was due to fuel exhaustion. Because of inadequate fuel consumption calculations and poor preflight planning and preparation for the flight.NTSB SEA90LA126Accident · Minor injuriesLimited investigationFinal reportHardesty/Hays Quickie Q2 · Twisp, WAThe pilot's failure to maintain directional control during the landing roll. Factors related to the accident were: the high weeds on the sides of the grass/dirt strip and the dirt berm.NTSB SEA90FA129Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300T · Prineville, ORThe failure of the left intermediate exhaust pipe, in-flight engine fire and smoke in the cockpit, resulting in impairment of the pilot and his subsequent loss of control.NTSB NYC90LA150Accident · Serious injuriesLimited investigationFinal reportBeech BE-58 · St. Albans, VTFlight into trees while recovering from an inadvertent spin after a pilot used incorrect procedures during a simulated engine failure below VMC and the instructor pilot delayed the corrective actions.NTSB MIA90LA149Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Crowder, MSFatigue failure of a bolt which secures the mixture and throttle bellcranks to the bellcrank support assembly.NTSB LAX90LA249Accident · No injuriesLimited investigationFinal reportBeech V35B · Big Bear, CAThe fuel starvation due to the pilot's inadvertent selection of an empty fuel tank.NTSB LAX90FA248Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas 369HS · Modesto, CAIn-flight engine fire of undetermined origin.NTSB DEN90LA158Accident · No injuriesLimited investigationFinal reportCessna T-188 · Devils Lake, NDThe pilot's failure to refuel, resulting in fuel exhaustion. A forced landing in rough terrain is a factor.NTSB CHI90LA169Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Aurora, ILFuel exhaustion. A factor in the accident was inaccurate fuel consumption calculations by the pilot.NTSB ATL90FA141Accident · 1 fatalField investigationFinal reportCessna 150G · Lanett, ALFailure of the pilot to maintain adequate airspeed, which resulted in a stall.