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.

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.May 28, 1999 · N496DE · Substantial damageNTSB 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.May 28, 1999 · N282SC · Substantial damageNTSB 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.May 28, 1999 · N9270C · Substantial damageNTSB 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…May 28, 1999 · N38908 · Substantial damageNTSB 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.May 28, 1999 · N811CE · DestroyedNTSB FTW99LA184Accident · No injuriesLimited investigationFinal reportCessna T303 · Houston, TXThe collapse of the nose landing gear for an undetermined reason.May 28, 1999 · N400T · Substantial damageNTSB 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…May 28, 1999 · N7991Y · Substantial damageNTSB 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.May 28, 1999 · N4533H · Substantial damageNTSB 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.May 28, 1999 · N89586 · Substantial damageNTSB ATL99LA097Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sanford, FLThe pilot's failure to maintain directional control during landing.May 28, 1999 · N9561B · Substantial damageNTSB 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…May 27, 1999 · N5120D · Substantial damageNTSB SEA99LA075Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Jerome, IDFuel exhaustion. Carburetor contamination and rough terrain were factors.May 27, 1999 · N6024M · Substantial damageNTSB 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.May 27, 1999 · N9970 · Substantial damageNTSB 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.May 27, 1999 · N2660M · DestroyedNTSB DEN99LA087Accident · No injuriesLimited investigationFinal reportCessna 170B · Ogden, UTThe pilot's misjudgment of altitude during an intentional (practice) low altitude flight maneuver (landing approach).May 27, 1999 · N2716C · DestroyedNTSB 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.May 27, 1999 · N34TM · DestroyedNTSB 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.May 26, 1999 · N1371Q · Substantial damageNTSB 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.May 26, 1999 · N8285K · DestroyedNTSB 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.May 25, 1999 · N149BT · Substantial damageNTSB NYC99WA121Accident · 2 fatalForeign investigationMitsubishi MU-2B-40 · Perry Sound, CanadaMay 25, 1999 · N701K · DestroyedNTSB 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.May 25, 1999 · N16703 · No damageNTSB 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.May 25, 1999 · N79M · Substantial damageNTSB 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…May 25, 1999 · N711ZY · Substantial damageNTSB FTW99LA151Accident · No injuriesLimited investigationFinal reportCessna 152 · Marietta, OKThe pilot's loss of control due to his improper recovery from a bounced landing.May 25, 1999 · N89854 · Substantial damageNTSB 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.May 25, 1999 · N6305W · Substantial damageNTSB 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.May 25, 1999 · N172KB · Substantial damageNTSB 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.May 25, 1999 · N8199W · Substantial damageNTSB 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.May 25, 1999 · N6524K · Substantial damageNTSB 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…May 25, 1999 · N400MJ · DestroyedNTSB ANC99LA064Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Anchorage, AKAn in-flight collision with a bird.May 25, 1999 · N72GC · Substantial damageNTSB IAD99LA045Accident · No injuriesLimited investigationFinal reportGulfstream American 690C · Hot Springs, VAA hard landing due to the pilot's inadequate compensation for the wind conditions.May 24, 1999 · N840V · Substantial damageNTSB 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.May 24, 1999 · N9729H · DestroyedNTSB 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.May 24, 1999 · N2941Y · Substantial damageNTSB ANC99LA065Accident · 1 fatalLimited investigationFinal reportStinson 108 · Anchorage, AKUndetermined.May 24, 1999 · N793C · DestroyedNTSB 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.May 23, 1999 · N2567K · Substantial damageNTSB 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.May 23, 1999 · N6017P · Substantial damageNTSB 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.May 23, 1999 · N6216W · Substantial damageNTSB NYC99LA154Accident · No injuriesLimited investigationFinal reportCessna 172RG · Morristown, NJThe right main landing gear collapsed for undetermined reasons.May 23, 1999 · N9475B · Substantial damageNTSB NYC99LA118Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY-7 · Gasburg, VAThe unforecast high winds that required the pilot in command to make a precautionary landing.May 23, 1999 · N9070T · No damageNTSB 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.May 23, 1999 · N113JN · DestroyedNTSB 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.May 23, 1999 · N301DK · DestroyedNTSB 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.May 23, 1999 · N6144H · Substantial damageNTSB 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.May 23, 1999 · N59260 · Substantial damageNTSB 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.May 23, 1999 · N8252S · DestroyedNTSB SEA99LA078Accident · No injuriesLimited investigationFinal reportCessna 182K · Kalispell, MTA loss of engine power for undetermined reasons. Rough terrain was a factor.May 22, 1999 · N2656R · Substantial damageNTSB 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.May 22, 1999 · N5679E · Substantial damageNTSB 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.May 22, 1999 · N51641 · Substantial damageNTSB 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.May 22, 1999 · N185FM · Substantial damageNTSB 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.May 22, 1999 · N93J · Substantial damageNTSB 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.May 22, 1999 · N8217A · Substantial damage