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 FTW89LA092Accident · No injuriesLimited investigationFinal reportBell 47L · Tulsa, OKInadequate supervision of the student by the instructor in that he allowed the student to overpower his control inputs after an unexpected gust of wind moved the tail of the helicopter.May 6, 1989 · N6330D · Substantial damageNTSB FTW89DRG05Accident · No injuriesFinal reportGrumman-Schweizer G-164 · Edcouch, TXLoss of engine power for an undetermined reason. The corn crop was a contributing factor.May 6, 1989 · N4591 · Substantial damageNTSB CHI89LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Flint, MIThe pilot-in-command's failure to follow proper procedures and directives and his premature decision to initiate an emergency procedure. Contributing factors were the pilot's lack of total experience and his selection of unsuitable terrain for the emergency…May 6, 1989 · N25054 · Substantial damageNTSB ATL89LA143Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Lugoff, SCInadequate compensation for wind conditions by the pilot and his failure to maintain adequate speed for the wind conditions, which resulted in a stall on final approach. His excessive use of flaps and the wind conditions were considered to be contributing…May 6, 1989 · N4985D · Substantial damageNTSB ATL89FA144Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Augusta, GAFailure of the pilot to maintain adequate airspeed, while making a steep turn after takeoff, which resulted in an inadvertent stall and subsequent collision with the terrain.May 6, 1989 · N8693C · Substantial damageNTSB ATL89FA142Accident · 1 fatalField investigationFinal reportEmbraer EMB-110-P1 · Mt. Pleasant, TNPilot attempted to make a VFR landing in instrument conditions that were below minimums for the published instrument approach and collided with trees and the ground after allowing the airplane to descend below the proper altitude.May 6, 1989 · N95PB · DestroyedNTSB ANC89LA067Accident · No injuriesLimited investigationFinal reportCessna 170B · Kalskag, AKThe pilot's failure to maintain directional control of the airplane following a bounced landing.May 6, 1989 · N4074V · Substantial damageNTSB ANC89FA069Accident · Minor injuriesField investigationFinal reportBell 412 · Girdwood, AKA main rotor flight control bolt (part number 20-057-6-38D) came out of its rod end bearing while in flight due to the bolt being improperly torqued during maintenance.May 6, 1989 · N524EH · DestroyedNTSB DEN89LA119Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Durango, COInadequate inflight planning and inadequate compensation for wind conditions. Contributing to the accident were crosswind and turbulence encountered close to the ground and high density altitude conditions.May 5, 1989 · N9147Y · Substantial damageNTSB DEN89LA116Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Deming, NMThe pilot's failure to maintain directional control during the takeoff ground run, resulting in a loss of control and collision with the terrain. The lack of experience in this type of aircraft is considered to be a factor.May 5, 1989 · N3475D · Substantial damageNTSB SEA89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lacey, WAFailure of the pilot to maintain proper alignment during landing.May 4, 1989 · N24508 · Substantial damageNTSB SEA89LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Lynden, WAThe pilot delayed in aborting the landing and failed obtain or maintain sufficient airspeed to keep the aircraft from mushing after lift-off. Factors related to the accident were: obstructions near the approach end of the runway, failure of the pilot to…May 4, 1989 · N6064R · Substantial damageNTSB MKC89LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wentzville, MOThe pilot's delay in aborting the landing, and his failure to maintain clearance from the power lines. Factors related to the accident were: the pilot's selection of the wrong runway, the adverse weather conditions, the pilot's failure to attain the proper…May 4, 1989 · N5092D · Substantial damageNTSB MKC89FA102Accident · 2 fatalField investigationFinal reportCessna 150H · Carnegie, OKContinued VFR flight by the pilot into instrument meteorological conditions, which resulted in subsequent collision with rising/hilly terrain. Related factors were: inadequate preflight planning/preparation by the pilot, dark night, adverse weather…May 4, 1989 · N22875 · DestroyedNTSB LAX89LA179Accident · No injuriesLimited investigationFinal reportCessna 180 · Cottonwood, AZImproper flight planning/decision by the PIC when he decided to land with such a crosswind, and not maintaining compensation for the crosswind after he decided to attempt the landing.May 4, 1989 · N9924N · Substantial damageNTSB LAX89FA178Accident · 1 fatalField investigationFinal reportPiper PA-28-201T · Stockton, CAThe pilot's improper decision to perform aerobatics which resulted in the design stress limits of the airplane being exceeded due to excessive airspeed. Contributing factors to the accident were the pilot's overconfidence in his and the airplane's ability,…May 4, 1989 · N8133A · DestroyedNTSB FTW89FA091Accident · 2 fatalField investigationFinal reportAeronca 11AC · Paradise, TXLoss of engine power for an undetermined reason, and failure of the pilot to maintain sufficient airspeed during the forced landing, which resulted in an inadvertent stall.May 4, 1989 · N3226E · DestroyedNTSB FTW89FA089Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar 601 · New Iberia, LAThe pilot failed to maintain a proper climb immediately after takeoff. Contributing to the accident was excessive manifold pressure indications for the left engine. The pilot's diverted attention in dealing with that condition most probably resulted in the…May 4, 1989 · N90619 · DestroyedNTSB FTW89DQA04Accident · 1 fatalFinal reportCessna A188B · Dell City, TXThe pilot's failure to see and/or avoid the powerlines. Contributing factor(s) was: the early morning sunglare.May 4, 1989 · N731FR · DestroyedNTSB CHI89IA084Incident · No injuriesIncident investigationFinal reportFokker F-27 MK500 · Moline, ILMaterial failure of the landing gear retraction and extension assembly. Inadequate maintenance and troubleshooting procedures in company directives were factors in this incident.May 4, 1989 · N511AW · Minor damageNTSB ATL89LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Ravenna, OHPilot in command failed to maintain directional control of the aircraft while landing in a gusty crosswind. The crosswind component exceeded the published demonstrated crosswind capability of the airplane.May 4, 1989 · N47316 · Substantial damageNTSB ATL89LA140Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlotte, NCComplete loss of engine power due to fuel exhaustion. The fuel exhaustion was due to the pilot not assuring an adequate fuel supply for the flight by visual inspection during his preflight inspection. Contributing was the pilot's decision to continue flight…May 4, 1989 · CGCMT · DestroyedNTSB ANC89IA068Incident · No injuriesIncident investigationFinal reportPiper PA-34-200T · Cordova, AKFailure of the upper trunion bolt which normally holds the upper portion of the over center down link.May 4, 1989 · N47895 · Minor damageNTSB MIA89GA144Accident · 2 fatalFinal reportDouglas C-47 · Summerland Key, FLThe failure of the pilot-in-command to assure proper altitude and clearance was maintained above the terrain and trees. The trees and light condition at dusk were contributing factors.May 3, 1989 · N28889 · DestroyedNTSB LAX89LA177Accident · No injuriesLimited investigationFinal reportCessna 310C · Jackson, CAThe failure of the instructor pilot (pilot in command) to reject the takeoff after the loss of power on one engine when sufficient runway remained to stop the aircraft. Contributing to the accident was the disregard of the aircraft manual, failure to use the…May 3, 1989 · N1798H · Substantial damageNTSB FTW89FA090Accident · 2 fatalField investigationFinal reportCessna 172P · Burnet, TXContinued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions and the pilot's lack of…May 3, 1989 · N5253K · DestroyedNTSB DEN89LA115Accident · No injuriesLimited investigationFinal reportCessna 182G · St. Xavier, MTThe pilot's failure to maintain airspeed while maneuvering for a forced landing following a failure of the number two piston. Contributing to the accident was smoke in the cockpit.May 3, 1989 · N3410S · Substantial damageNTSB DEN89LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Bozeman, MTImproper in-flight planning/decision by the pilot which led to his failure to maintain directional control during the landing. Contributing factors were: use of an unfavorable runway, crosswind, and gusts.May 3, 1989 · N9858D · DestroyedNTSB MKC89LA101Accident · No injuriesLimited investigationFinal reportCessna 152 · Buffalo, MNThe pilot's failure to maintain directional control. Factors related to the accident were: the crosswind, the pilot's improper compensation for wind conditions, his improper use of the throttle, and the ditch.May 2, 1989 · N6436P · Substantial damageNTSB DEN89LA113Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Albuquerque, NMInadequate compensation for the wind conditions by the pilot, resulting in a loss of control during landing roll. Variable and gusting winds are considered a contributing factor.May 2, 1989 · N9121L · Substantial damageNTSB CHI89IA083Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-82 · Minneapolis, MNFailure of the hydraulic power transfer unit shut-off (ptu s/o) valve due to failed (fatigued) valve body attach screws.May 2, 1989 · N434AA · Minor damageNTSB SEA89LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gerlach, NVA delay by the pilot in aborting the landing and his failure to assure sufficient airspeed for the go-around (aborted landing). A factor related to the accident was: the unsuitable landing area that was selected by the pilot.May 1, 1989 · N4439E · Substantial damageNTSB NYC89LA128Accident · No injuriesLimited investigationFinal reportCessna 152 · Burlington, VTThe student pilot's failure to maintain directional control of the aircraft.May 1, 1989 · N45981 · Substantial damageNTSB MIA89LA143Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Palmetto, FLThe pilot's selection of the wrong runway for landing along with failure to attain a proper point of touchdown and the failure to perform a go-around.May 1, 1989 · N9306T · Substantial damageNTSB CHI89LA082Accident · Minor injuriesLimited investigationFinal reportCessna 320D · Wixom, MIPilot's inattention to the fuel system during preflight and inadequate fuel system monitoring throughout the flight.May 1, 1989 · N132BC · DestroyedNTSB NYC89LA127Accident · No injuriesLimited investigationFinal reportCessna 150G · Hudson, NYFatigue failure of the right main strut.Apr 30, 1989 · N4766X · Substantial damageNTSB LAX89LA176Accident · No injuriesLimited investigationFinal reportBeech 35 · Sierraville, CAThe pilot's attempt to land downwind on the runway and the inability to attain a climb after aborting the landing which resulted in a stall and uncontrolled descent into the ground.Apr 30, 1989 · N3169V · DestroyedNTSB LAX89LA175Accident · No injuriesLimited investigationFinal reportMooney M20E · Julian, CAThe inadequate preflight planning/preparation by the pilot. Contributing to the accident was the loose gravel runway and the fence which the airplane was unable to clear.Apr 30, 1989 · N9276V · Substantial damageNTSB CHI89DEP03Accident · No injuriesFinal reportTesmer Glassair SH-2 · Watertown, WILack fuel flow to the engine (fuel starvation) due to an undetermined fuel system problem.Apr 30, 1989 · N29HJ · Substantial damageNTSB ANC89LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Wasilla, AKFailure of the pilot to go-around when he did not attain the proper touchdown point, which required excessive use of brakes to stop on the short landing area.Apr 30, 1989 · N3902Z · Substantial damageNTSB SEA89LA076Accident · Minor injuriesLimited investigationFinal reportBell 47G3B2 · Milton-Freewtr, ORImproper planning/decision by the pilot, which resulted in fuel exhaustion from an inadequate supply of fuel.Apr 29, 1989 · N4072G · Substantial damageNTSB MIA89WA142Accident · No injuriesForeign investigationBeech 65 · Nassau, BahamasApr 29, 1989 · N824Q · DestroyedNTSB MIA89LA140Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Daytona Beach, FLA loss of engine power for undetermined reasons.Apr 29, 1989 · N447B · Substantial damageNTSB LAX89LA174Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Ramona, CAThe pilot of the other aircraft did not maintain an adequate visual lookout and collided with this Cessna that was parked in the runup area.Apr 29, 1989 · N6220L · 2 aircraft · Minor damageNTSB ATL89FA139Accident · 5 fatalField investigationFinal reportBeech B24R · Suches, GAThe pilot's flight into known adverse weather, and his failure to maintain clearance above the wooded terrain. The adverse weather condition, high terrain, and trees were related factors.Apr 29, 1989 · N2526W · DestroyedNTSB NYC89FA129Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Herkimer, NYA forced landing in unsuitable terrain due to an internal engine failure. The engine failure sequence was initiated by a failed oil pressure relief spring which had failed in fatigue due to improper plating of the spring. The spring failure caused oil…Apr 28, 1989 · N2113U · DestroyedNTSB MIA89WA139Accident · No injuriesForeign investigationBritten-Norman BN-2A MK-III · Walkers Cay, BahamasApr 28, 1989 · N164LG · Substantial damageNTSB MIA89LA141Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Smyrna Bch., FLThe failure of the pilot to adequately preflight the airplane. Contributing to the accident was the pilot's failure to use the brakes to maintain directional control and poor inspection of the airplane by company maintenance personnel.Apr 28, 1989 · N57946 · Substantial damageNTSB NYC89LA131Accident · Serious injuriesLimited investigationFinal reportAdams Unknown · Soleburg, PAThe pilot's inadequate weather evaluation which resulted in delaying the precautionary landing. Factors contributing to the accident included high winds and the lack of restraining devices inside the basket to help the occupants remain inside.Apr 27, 1989 · N4022Q · No damageNTSB NYC89LA130Accident · No injuriesLimited investigationFinal reportCessna C182Q · Beaver Falls, PAThe pilot failure to properly flare the airplane during landing and the improper recovery from a bounced landing.Apr 27, 1989 · N82AH · Substantial damage