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 FTW97LA337Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Saratoga, WYThe pilot's failure to consult airplane performance data based upon the weather conditions that prevailed. Factors were terrain induced turbulence and high density altitude.Sep 3, 1997 · N8731C · Substantial damageNTSB CHI97LA278Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Larimore, NDthe pilot delaying the swath run turnaround maneuver at the end of the field boundary, and his failure to maintain clearance between the airplane and the high tension wires. A factor was the pilot's inattentiveness regarding the time to begin the swath run…Sep 3, 1997 · N8326K · DestroyedNTSB ANC97LA144Accident · No injuriesLimited investigationFinal reportCessna 185 · Kotzebue, AKThe collapse/deflation of the right main tire when the tire slipped on the tire wheel rim which resulted in the collapse of the right main landing gear due to overload.Sep 3, 1997 · N185QB · Substantial damageNTSB SEA97FA202Accident · Minor injuriesField investigationFinal reportMcDonnell Douglas DC-9-82 (MD-82) · Seattle, WAfatigue failure of the nose landing gear upper lock link, due in part to reduced strength after the manufacturing process was changed from forged to machined plate stock; and inadequate non-destructive inspection process for testing the link.Sep 2, 1997 · N951AS · Substantial damageNTSB DCA98WA006Incident · No injuriesForeign investigationde Havilland DHC-2 · Spa Belgium, BelgiumSep 2, 1997 · OYJRR · Minor damageNTSB ATL97LA131Accident · No injuriesLimited investigationFinal reportLearjet 31 · Aberdeen, MSThe flightcrew's failure to extend the landing gear.Sep 2, 1997 · N71JC · DestroyedNTSB ANC97LA141Accident · No injuriesLimited investigationFinal reportCessna 150H · Yakutat, AKA partial blockage of the main fuel supply line to the engine, caused by improper manufacture of the fuel line by unknown maintenance personnel.Sep 2, 1997 · N467SR · Substantial damageNTSB ANC97LA140Accident · Minor injuriesLimited investigationFinal reportCessna U206F · King Salmon, AKthe pilot's selection of an unsuitable takeoff area. Factors were the sand bar and the pilot's failure to use all available waterway for the takeoff.Sep 2, 1997 · N7032Q · DestroyedNTSB ANC97LA138Accident · Serious injuriesLimited investigationFinal reportCessna U206E · Mcgrath, AKthe pilot's improper flare and improper recovery from a bounced landing, which resulted in overload failure of the nose gear and a nose over. Factors associated with the accident were: the pilot's failure to follow procedures and directives by neglecting to…Sep 2, 1997 · N9129M · Substantial damageNTSB SEA97FA201Accident · 5 fatalField investigationFinal reportCessna 182C · Bremerton, WAThe pilot's failure to maintain adequate airspeed in a climbing turn at low altitude, resulting in a stall and impact with terrain. A factor was the pilot exceeding the aircraft's maximum takeoff gross weight limitation.Sep 1, 1997 · N9015T · DestroyedNTSB FTW97LA335Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Marksville, LAThe pilot's inadvertent stall during a turn to reverse direction during an aerial application flight. A factor was the pilot's chronic fatigue as result of cumulative long workdays.Sep 1, 1997 · N8075K · Substantial damageNTSB FTW97LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Zavalla, TXthe pilot's improper planning/decision, becoming lost/disoriented during the flight, and selection of unsuitable terrain for an emergency/precautionary landing. Factors relating to the accident were: the hazy weather condition, and rough terrain in the…Sep 1, 1997 · N89268 · Substantial damageNTSB CHI97LA280Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Monona, IAthe pilot's improper in-flight planning/decision, and subsequently, his not being able to attain remedial action to avoid impact with the terrain. A related factor was the downdraft.Sep 1, 1997 · N6566W · Substantial damageNTSB CHI97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Castlewood, SDThe pilot's failure to maintain adequate clearance from the trees.Sep 1, 1997 · N2743P · Substantial damageNTSB CHI97LA275Accident · Minor injuriesLimited investigationFinal reportBucker Flugzeugbau Jungmann · Blakesburg, IALoss of engine power for undetermined reasons.Sep 1, 1997 · N131G · Substantial damageNTSB ATL97LA130Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Murfreesboro, TNThe pilot's excessive airspeed, and improper touch down point during landing, that resulted in the runway end overun. Factors were the wet runway surface, and the embankment at the end of the runway.Sep 1, 1997 · N437CG · Substantial damageNTSB ANC97LA139Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Paxson, AKThe pilot's improper use of carburetor heat during a takeoff in carburetor icing conditions. Factors associated with the accident were the pilot's decision to operate the airplane with known deficiencies (a disabled stall warning horn), an inadvertent stall,…Sep 1, 1997 · N4520C · Substantial damageNTSB SEA97LA200Accident · Serious injuriesLimited investigationFinal reportCessna 170A · Elk City, IDA horse and children wandered onto the airstrip.Aug 31, 1997 · N1487D · DestroyedNTSB NYC97LA176Accident · Serious injuriesLimited investigationFinal reportThunder and Colt AX-10 · Akron, PAfailure of a passenger to hang onto the ropes, as directed; which allowed another passenger to be struck as the basket tipped over, broking her arm. A related factor was the wind, which was strong enough to tip the basket, while the envelope was deflating.Aug 31, 1997 · N834TC · No damageNTSB NYC97LA175Accident · Minor injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Fredericksburg, VAA loss of engine power for undetermined reasons.Aug 31, 1997 · N4376B · Substantial damageNTSB LAX97LA309Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Imperial, CAThe pilot's failure to maintain directional control during landing and to arrest porpoising after an improper recovery from a bounced landing. Factors in the accident were the misjudging of distance and speed during a downwind landing.Aug 31, 1997 · N65273 · Substantial damageNTSB LAX97LA308Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gerlach, NVThe pilot's failure to maintain an adequate airspeed while attempting a right slip, which resulted in an inadvertent stall.Aug 31, 1997 · N4459P · Substantial damageNTSB IAD97LA116Accident · Minor injuriesLimited investigationFinal reportBeech Musketeer 23 · Wauseon, OHThe pilot's fuel mismanagement by his failure to switch fuel tank positions, which resulted in the fuel starvation and the loss of engine power.Aug 31, 1997 · N2372L · Substantial damageNTSB IAD97LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Gardiner, NYThe pilot's failure to initiate a go-around. A related factor is the pilot's misjudgment of speed and altitude.Aug 31, 1997 · N557FL · DestroyedNTSB FTW97LA334Accident · No injuriesLimited investigationFinal reportBeech E90 · Albuquerque, NMFatigue failure of the right main landing gear retraction/extension torque tube.Aug 31, 1997 · N16NM · Substantial damageNTSB CHI97LA277Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Council Bluffs, IAinadequate supervision by the designated examiner by failing to ensure a timely autorotation recovery was initiated. A related factor was: the student pilot allowed the rotor rpm to diminish after the examiner simulated a loss of engine power.Aug 31, 1997 · N7058T · DestroyedNTSB CHI97LA276Accident · No injuriesLimited investigationFinal reportCessna 150J · Romeo, MIthe pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.Aug 31, 1997 · N60200 · Substantial damageNTSB ATL97LA128Accident · No injuriesLimited investigationFinal reportCessna 172M · Lawrenceville, GAThe student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.Aug 31, 1997 · N9625V · Substantial damageNTSB ANC97LA136Accident · No injuriesLimited investigationFinal reportCessna 185F · Kotzebue, AKThe pilot's selection of an unsuitable landing area. A factor was the short length of the off-airport site.Aug 31, 1997 · N93276 · Substantial damageNTSB SEA97LA199Accident · No injuriesLimited investigationFinal reportComeaux Kitfox 1 · Bend, ORThe private pilot-in-command's failure to ensure that directional control was maintained. A related factor was the private pilot's lack of total flight experience.Aug 30, 1997 · N594KF · Substantial damageNTSB NYC97LA174Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Slatington, PAThe pilot's failure to maintain control of the helicopter.Aug 30, 1997 · N5303V · Substantial damageNTSB NYC97GA177Accident · No injuriesFinal reportNavion G · Brooklyn, NYthe pilot's inadequate preflight by failing to ensure the fuel selector was properly positioned for takeoff, which resulted in fuel starvation, loss of engine power, and a forced landing after takeoff.Aug 30, 1997 · N2362T · Substantial damageNTSB FTW97LA336Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Muleshoe, TXfailure of the pilot to see the standpipe in time to avoid an accident (inadequate visual lookout), and his failure to maintain clearance with electrical wires, while maneuvering during an aerial application flight.Aug 30, 1997 · N9807 · Substantial damageNTSB SEA97LA198Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1B · Dayville, ORImproper installation of the transmission door by a company mechanic, resulting in inflight separation of the door (which then struck the tail rotor system) and consequent total loss of the tail rotor. Contributing to the accident were: inadequate…Aug 29, 1997 · N22753 · Substantial damageNTSB NYC97FA173Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Hancock, MAThe pilot's failure to maintain adequate terrain clearance and the proper altitude. Contributing was mountainous terrain.Aug 29, 1997 · N40AB · DestroyedNTSB NYC97FA172Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Baptistown, NJfailure of the pilot to maintain control of the airplane for undetermined reason(s), while operating it at low altitude.Aug 29, 1997 · N5464Y · DestroyedNTSB LAX97LA312Accident · No injuriesLimited investigationFinal reportCessna T210J · Avra Valley, AZThe pilot became lost/disoriented during his taxiing into the ramp area. Factors in the accident were the lack of taxiway lights, the pilot's lack of familiarity with the layout of the airport, and the airport operator's failure to either identify the…Aug 29, 1997 · N2280R · Substantial damageNTSB LAX97LA307Accident · No injuriesLimited investigationFinal reportCessna T210M · San Martin, CAInstallation of improper connecting hardware by maintenance personnel, and, the inadequate inspection of the installed hardware by inspection personnel resulting in separation of the engine throttle linkage.Aug 29, 1997 · N761HQ · Substantial damageNTSB ATL97LA127Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Clewiston, FLThe crack in the #8 cylinder head which led to the loss of power. A factor was the soft terrain.Aug 29, 1997 · N7307C · Substantial damageNTSB IAD97LA114Accident · Minor injuriesLimited investigationFinal reportSchleicher ASW19-B · Troy, PAPilot failed to maintain airspeed which resulted in an inadvertent stall.Aug 28, 1997 · N19LK · Substantial damageNTSB CHI97LA281Accident · No injuriesLimited investigationFinal reportCessna 150M · Benton, KSthe flight instructor's (CFI') improper in-flight planning/decision, which led to fuel exhaustion and loss of engine power before the airplane was safely landed.Aug 28, 1997 · N704TL · Substantial damageNTSB CHI97LA274Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Flushing, MIthe pilot's failure to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the tailwind, the pilot's runway selection, and the hangar.Aug 28, 1997 · N3065M · Substantial damageNTSB ATL97LA126Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164C · Beaufort, NCfailure of the pilot to ensure the tailwheel was properly locked, while taking off on an asphalt runway, which led to loss of directional control and a ground swerve.Aug 28, 1997 · N585CK · Substantial damageNTSB SEA97FA196Accident · 1 fatalField investigationFinal reportSouthern Aero UH-1B · Skykomish, WAA fatigue fracture in the main rotor mast, which resulted in an in flight separation of the main rotor from the helicopter. Contributing to the accident was insufficient Federal Aviation Administration airworthiness standards and requirements for the aircraft.Aug 27, 1997 · N896W · Substantial damageNTSB NYC97LA171Accident · 1 fatalLimited investigationFinal reportLorello Genesis · Columbia Statn, OHThe pilot's failure to maintain airspeed.Aug 27, 1997 · N9091B · DestroyedNTSB LAX97LA306Accident · No injuriesLimited investigationFinal reportCessna 182Q · Bullhead City, AZThe pilot's inadequate compensation for the crosswind,Aug 27, 1997 · N7586S · Substantial damageNTSB FTW97LA332Accident · No injuriesLimited investigationFinal reportPitts S-2B · Mountain View, ARFuel exhaustion due to the pilot's inadequate preflight planning. A factor was the lack of suitable terrain for the forced landing.Aug 27, 1997 · N9QT · Substantial damageNTSB FTW97LA331Accident · No injuriesLimited investigationFinal reportAir Tractor AT-802A · Pineland, TXfailure of the right main wheel brake, during the landing roll. A factor relating to the accident was: the pilot's failure (or inability) to maintain directional control of the airplane, after loss of right braking action.Aug 27, 1997 · N9197F · Substantial damageNTSB FTW97LA328Accident · No injuriesLimited investigationFinal reportFingerhut Revolution Mini 500 · Huffman, TXThe disengagement of the helicopter's collective control tube due to improper installation by the builder. Factors were the lack of sufficient information provided by the kit manufacturer and the pilot's inability to cushion the landing.Aug 27, 1997 · N570F · Substantial damageNTSB FTW97FA330Accident · 1 fatalField investigationFinal reportSouthwest Florida SW204 · Manila, ARFatigue failure of the main rotor blade resulting in the in-flight separation of the main rotor system due to the use of an unairworthy blade, and failure of the maintenance personnel who modified the rotor blade and the mechanic who complied with the…Aug 27, 1997 · N482SA · Destroyed