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 NYC99LA129Accident · No injuriesLimited investigationFinal reportMooney M20R · Ravenna, OHThe pilot's improper flare which resulted in a hard landing, and his failure to maintain directional control after touchdown.NTSB NYC99LA127Accident · No injuriesLimited investigationFinal reportBoeing 727 · Sterling, VAInadequate visual lookout by the tug operator. A factor in this accident was inadequate pushback procedures by the airline which failed to provide proper assistance (wing walkers) to the tug operator.NTSB LAX99LA205Accident · No injuriesLimited investigationFinal reportCessna 180 · Sedona, AZFuel exhaustion due to an inadequate fuel supply, and the pilot's inadequate in-flight planning fuel consumption calculations.NTSB LAX99LA201Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Valley Springs, CAThe fatigue failure and separation of the No. 6 connecting rod end cap, which led to a catastrophic failure of the engine. The fatigue crack initiation was due to galling on the rod end cap, which was most likely caused by an undetermined factory…NTSB LAX99FA200Accident · 3 fatalField investigationFinal reportMBB BO 105LS A-3 · Huntington Bch, CAThe pilot's in-flight loss of control due to spatial disorientation while maneuvering to reverse direction after an inadvertent encounter with instrument meteorological conditions.NTSB FTW99LA184Accident · No injuriesLimited investigationFinal reportCessna T303 · Houston, TXThe collapse of the nose landing gear for an undetermined reason.NTSB FTW99LA154Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Mcalester, OKThe pilot inadvertently stalling the airplane while attempting to avoid power lines. Factors were the loss of power on both the left and right engines as a result of water contamination in the fuel system, the pilot's inadequate preflight procedures, and the…NTSB FTW99LA152Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Cherry Valley, ARThe pilot's inadvertent stall due to his evasive maneuver to avoid colliding with a truck on the runway. A factor was the runway incursion by the truck.NTSB DEN99LA088Accident · No injuriesLimited investigationFinal reportCessna 140 · Farmington, NMThe pilot's excessive use of rudder while attempting to correct for loss of directional control. Factors were the pilot's loss of directional control, and his lack of experience in the type of airplane.NTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.NTSB SEA99LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Covington, WAThe student pilot's inadequate recovery from a bounced landing, and his subsequent improper execution of the go-around procedure, resulting in collision with trees off the departure end of the runway. Factors included the student pilot's lack of total…NTSB SEA99LA075Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDFuel exhaustion. Carburetor contamination and rough terrain were factors.NTSB SEA99LA074Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Prescott, WAThe pilot-in-command's failure to maintain directional control during the takeoff roll and overloading of the right landing gear strut. Contributing factors were the soft takeoff surface, confined (narrow) takeoff surface, and high vegetation.NTSB LAX99FA199Accident · 1 fatalField investigationFinal reportCessna 180J · Wickenburg, AZThe pilot's failure to maintain altitude/clearance from ground obstacles. A factor was the pilot's diverted attention in this accident.NTSB DEN99LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).NTSB CHI99FA163Accident · 4 fatalField investigationFinal reportCessna 421B · Jefferson City, MOthe pilot failed to maintain control of the airplane. A factor was the partial loss of power due to the exhaust valve fatigue failure.NTSB LAX99LA198Accident · No injuriesLimited investigationFinal reportCessna 150L · Paso Robles, CAthe pilot's failure to maintain aircraft control and the resulting intentional off-airport landing. Inadequate recurrent training and recent flight experience were factors in this accident.NTSB FTW99FA150Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G164-B · Brinkley, ARThe pilot's inadvertent VFR flight into instrument meteorological conditions. Contributing factors were the pilots failure to maintain control of the aircraft, spatial disorientation, and the fog.NTSB SEA99LA071Accident · No injuriesLimited investigationFinal reportBen Travis Kitfox IV · Carnation, WALoss of engine power due to a cracked engine impulse line, which disabled the fuel pump. A factor was the intentional ground loop by the pilot.NTSB NYC99WA121Accident · 2 fatalForeign investigationMitsubishi MU-2B-40 · Perry Sound, CanadaNTSB NYC99LA122Accident · Serious injuriesLimited investigationFinal reportBoeing 737 · Newark, NJIn flight encounter with turbulence which caused a flight attendant to fall and break two bones in his right leg.NTSB NYC99LA119Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Covington, KYThe pilot's failure to maintain directional control during the takeoff/initial climb. A factor in the accident was the crosswind condition.NTSB MIA99LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Orlando, FLThe pilots misjudgment of altitude during an attempted banner tow pick-up. This resulted in the banner becoming entangled around the main landing gear. The pilot made a go-around. On landing rollout the banner became entangled around a runway light, and the…NTSB FTW99LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKThe pilot's loss of control due to his improper recovery from a bounced landing.NTSB FTW99LA149Accident · Serious injuriesLimited investigationFinal reportWeatherly 620B · Whiteface, TXThe pilot's selection of unsuitable terrain for takeoff. Contributing to the accident was the soft ground and the standing water on the runway.NTSB DEN99LA085Accident · No injuriesLimited investigationFinal reportCessna 172L · Gunnison, COThe pilot's inadvertent stall/mush immediately after takeoff. Factors were the high density altitude weather condition, and the pilot's total lack of experience in type of operation.NTSB DEN99FA086Accident · 1 fatalField investigationFinal reportPZL-Mielec M-18B · Altus, OKThe pilot's disregard of takeoff performance data and his failure to jettison the load. Contributing factors were high density altitude, exceeding the aircraft's maximum allowable gross weight, and the berm.NTSB CHI99LA162Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Buxton, NDthe number one cylinder's separation, the pilot's visual lookout not possible through the oil given off by the number one cylinder, and the embankment. A factor in the accident was the oil.NTSB CHI99FA165Accident · 1 fatalField investigationFinal reportAir Tractor AT-400 · Elkhart, KSThe pilot's inadequate in-flight planning/decision and his inadvertent flight into instrument meteorological conditions which resulted in spatial disorientation and subsequent loss of aircraft control. Contributing to the accident was the poor weather…NTSB ANC99LA064Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Anchorage, AKAn in-flight collision with a bird.NTSB IAD99LA045Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Hot Springs, VAA hard landing due to the pilot's inadequate compensation for the wind conditions.NTSB FTW99FA148Accident · 1 fatalField investigationFinal reportBeech C18S · Waldron, ARthe separation of a propeller blade in cruise flight as a result of fatigue cracking emanating from surface corrosion pitting.NTSB CHI99LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Mineral Point, WIthe inadequate planning and decision by the pilot and the exceeded crosswind capability of the airplane. Contributing factors were the crosswind and the gusts.NTSB ANC99LA065Accident · 1 fatalLimited investigationFinal reportStinson 108 · Anchorage, AKUndetermined.NTSB SEA99LA073Accident · No injuriesLimited investigationFinal reportCessna 180K · Bremerton, WAFailure of the landing gear attach bolt due to fatigue failure resulting in the left main landing gear collapsing.NTSB SEA99LA070Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Hillsboro, ORA loose alternator drive belt, and the flight crew's decision to continue flight with a known electrical system deficiency, resulting in disabling of the aircraft electrical system and landing with the gear not down-and-locked.NTSB SEA99LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lyman, WAThe pilot-in-command's improper execution of takeoff procedures, and his delay in aborting the takeoff. Contributing factors were the fence post and trees.NTSB NYC99LA154Accident · No injuriesLimited investigationFinal reportCessna 172RG · Morristown, NJThe right main landing gear collapsed for undetermined reasons.NTSB NYC99LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Gasburg, VAThe unforecast high winds that required the pilot in command to make a precautionary landing.NTSB NYC99LA116Accident · 1 fatalLimited investigationFinal reportNations Acro Sport II · Pence Springs, WVThe student pilot's improper decision to perform aerobatics, and his failure to maintain aircraft control, which resulted in an inadvertent spin. A factor in the accident was the pilot's lack of aerobatic experience.NTSB LAX99LA190Accident · 1 fatalLimited investigationFinal reportBeech B90 · Mokuleia, HIThe pilot's incapacitation due to the effects of hypoxia from repeated flights to altitudes above 18,000 feet msl without supplemental oxygen.NTSB CHI99LA159Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Poplar Bluff, MOthe pilot selecting the wrong runway direction on which to initiate the takeoff and his failure to maintain directional control. Factors associated with the accident were the quartering tailwind condition, the rough terrain encountered, and fatigue.NTSB CHI99LA158Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman PT-27 · Grainfield, KSThe pilot's improper in-flight decision and failure to maintain adequate clearance with the ground.NTSB CHI99FA164Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Great Bend, KSthe chafed through turbocharger oil supply hose, the failure of maintenance personnel to install a clamp on the turbocharger oil supply hose, and the inability of the pilot to maintain aircraft control.NTSB SEA99LA078Accident · No injuriesLimited investigationFinal reportCessna 182K · Kalispell, MTA loss of engine power for undetermined reasons. Rough terrain was a factor.NTSB NYC99LA120Accident · No injuriesLimited investigationFinal reportCessna 172N · Churchville, MDThe pilot's failure to maintain directional control during the takeoff roll. Factors were the pilot's lack of recent experience, and the crosswind.NTSB LAX99LA196Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Santa Ana, CAThe pilot's failure to maintain directional control and his excessive use of the rudder to regain runway alignment.NTSB LAX99LA194Accident · No injuriesLimited investigationFinal reportCessna A185F · Elko, NVThe failure of the pilot to adequately compensate for the variable and gusty winds, and, to maintain directional control of the aircraft while landing.NTSB LAX99LA193Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Merced, CAThe pilot's improper/inadequate use of the rudders during the attempted recovery from a bounced landing and his subsequent failure to maintain directional control of the aircraft.NTSB LAX99LA192Accident · No injuriesLimited investigationFinal reportI.C.A. Brasov IS-29D2 · Tehachapi, CAThe pilot's inability to maintain a proper glide path due to an inadvertent encounter with an area of high sink rate conditions. The mountainous/hilly nature of the terrain which limited the pilot's selection of a landing site is a factor.