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 LAX97LA260Accident · Serious injuriesLimited investigationFinal reportRobinson R22 Beta · Chandler, AZThe CFI's failure to recognize and correct for a vortex ring state, and his improper use of the flight controls, which resulted in the loss of control and uncontrolled descent.Jul 25, 1997 · N4008D · DestroyedNTSB LAX97LA258Accident · Serious injuriesLimited investigationFinal reportCentrair ASW20F · Minden, NVthe pilot's improper planning/decision and subsequent encounter with gusty winds and strong downdrafts, which precluded reaching the airport and induced an unrecoverable high sink rate during an off-airport landing.Jul 25, 1997 · N120MJ · Substantial damageNTSB FTW97FA280Accident · Serious injuriesField investigationFinal reportCessna 150D · Fort Collins, COInadequate preflight planning by loading the aircraft over the maximum certificated gross weight, failure to follow procedures and directives by using flaps for takeoff and failing to properly lean the engine for optimum power, and stalling the aircraft.…Jul 25, 1997 · N4228U · Substantial damageNTSB MIA97LA215Accident · No injuriesLimited investigationFinal reportBeech 65 · Atlantic Ocean (Atlantic Ocean)Failure of the aircraft to maintain altitude for undetermined reasons following loss of power in one engine.Jul 24, 1997 · N816Q · DestroyedNTSB MIA97LA212Accident · Minor injuriesLimited investigationFinal reportContinental Copters MK5A · Sylacauga, ALThe failure of the pilot to maintain main rotor rpm resulting in the helicopter descending and colliding with trees.Jul 24, 1997 · N62108 · Substantial damageNTSB LAX97LA265Accident · No injuriesLimited investigationFinal reportSchempp-Hirth DUO Discus · Minden, NVThe pilot's failure to ensure that the wings were maintained at a lateral level attitude during the initial landing rollout. A factor in the accident was the rough, uneven nature of the terrain chosen for the landing.Jul 24, 1997 · N125DD · Substantial damageNTSB LAX97LA255Accident · No injuriesLimited investigationFinal reportCessna T210L · Corona, CAthe pilot's improper landing flare. Contributing to the accident was the failure of the pilot to correct a landing induced porpoise, and go-around.Jul 24, 1997 · N732DD · DestroyedNTSB FTW97LA281Accident · No injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXfailure of the pilot in the Cessna 172 to maintain clearance from the Cessna 152 aircraft.Jul 24, 1997 · N94912 · 2 aircraft · Substantial damageNTSB CHI97LA224Accident · Serious injuriesLimited investigationFinal reportBeech B-23 · Watertown, WIa loss of engine power due to undetermined reason(s).Jul 24, 1997 · N9120T · DestroyedNTSB ANC97LA111Accident · No injuriesLimited investigationFinal reportCessna 180 · Umiat, AKThe collapse of the right main landing gear while taxiing to parking.Jul 24, 1997 · N2707X · Substantial damageNTSB NYC97LA152Accident · Serious injuriesLimited investigationFinal reportKenneson Merlin GT · Kensington, NHthe pilot's inability to obtain and/or maintain control of the airplane after takeoff.Jul 23, 1997 · N912AK · Substantial damageNTSB NYC97LA151Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Sussex, NJthe pilot's improper management of the fuel supply. A related factor was the inoperative low fuel quantity light for the rear tank.Jul 23, 1997 · N491AL · Substantial damageNTSB LAX97LA254Accident · No injuriesLimited investigationFinal reportBeech 77 · Lakeport, CAcarburetor ice, and the failure of both pilot's to use (or properly use) carburetor heat. Factors relating to the accident were: the weather (carburetor icing) conditions, and obstructions in the forced landing area (grape vineyard).Jul 23, 1997 · N1848F · Substantial damageNTSB LAX97FA334Accident · 2 fatalField investigationFinal reportNavion G · Gabbs, NVThe pilot's attempted visual flight into instrument meteorological conditions which resulted in his spatial disorientation and a loss of airplane control. A contributing factor was his overconfidence in his personal ability.Jul 23, 1997 · N2429T · DestroyedNTSB CHI97LA237Accident · No injuriesLimited investigationFinal reportCessna 182F · Haviland, KSthe pilot's improper planning/decision and failure to obtain and/or maintain proper runway alignment during a night landing. Factors relating to the accident were: the airplane's inoperative landing lights, the airport's inoperative runway edge lights, and…Jul 23, 1997 · N3265U · Substantial damageNTSB CHI97LA223Accident · No injuriesLimited investigationFinal reportCessna 188B · Adams, NEinadequate maintenance/annual inspection, and subsequent exhaustion of hydraulic (brake) fluid, which resulted in loss of braking action (right brake) and impact with a tree. The proximity of tree(s) was a related factor.Jul 23, 1997 · N4926R · Substantial damageNTSB CHI97LA221Accident · 1 fatalLimited investigationFinal reportGoble RV-4 · Rosemount, MNthe pilot's failure to maintain adequate airspeed after takeoff, which resulted in a stall/spin and collision with the terrain. His excessive climb rate after takeoff was a related factor.Jul 23, 1997 · N36JG · DestroyedNTSB ANC97LA110Accident · No injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilots failure to maintain terrain clearance during the downslope, downwind, high altitude, takeoff. Factors were the snow and lighting conditions, and the tailwind takeoff.Jul 23, 1997 · N9855X · Substantial damageNTSB SEA97LA176Accident · Minor injuriesLimited investigationFinal reportGarner RAF 2000 GTX-SE · Bandon, ORThe pilot's failure to maintain sufficient rotor RPM. A factor was the pilot's limited flight experience in gyroplanes.Jul 22, 1997 · N6281Y · Substantial damageNTSB SEA97LA175Accident · No injuriesLimited investigationFinal reportCessna T210H · Stehekin, WAThe pilot's misreading of the windsock and subsequent downwind landing. Factors in the accident were the sunglare and tailwind.Jul 22, 1997 · N6922R · Substantial damageNTSB SEA97LA174Accident · No injuriesLimited investigationFinal reportBell 47G-3B1 · Idaho Falls, IDThe pilot-in-command's failure to verify the proper chemical and fuel load aboard prior to takeoff. Factors contributing to the accident were: excessive fuel and chemical loading by ground personnel, tailwind conditions, and high density altitude.Jul 22, 1997 · N3069G · Substantial damageNTSB NYC97LA150Accident · No injuriesLimited investigationFinal reportCessna 172E · Fitchburg, MAA loss of engine power for undetermined reasons.Jul 22, 1997 · N3553S · Substantial damageNTSB FTW97LA279Accident · No injuriesLimited investigationFinal reportCessna 180 · Carlisle, ARthe pilot's failure to maintain directional control of the airplane during the takeoff roll (at night).Jul 22, 1997 · N9320C · Substantial damageNTSB ATL97LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Portland, TNThe pilot's attempt to perform a short field takeoff in unsuitable terrain. A related factor was the pilot's desire to impress his co-workers.Jul 22, 1997 · N10744 · Substantial damageNTSB ANC97LA109Accident · No injuriesLimited investigationFinal reportCessna 208 · Naknek, AKThe pilots decision to continue the landing into adverse weather conditions and failure to maintain runway alignmet. A factor was the rain shower which resulted in reduced forward visibility.Jul 22, 1997 · N9481F · Substantial damageNTSB LAX97LA250Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Elko, NVThe failure of maintenance personnel to correctly diagnose and correct a reoccurring nose gear steering problem, and the improperly tensioned nose wheel steering actuator cables which provided the pilot with an erroneous cockpit indication that the nose gear…Jul 21, 1997 · N776BF · Substantial damageNTSB LAX97LA248Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Buttonwillow, CAfailure of the pilot to maintain adequate clearance from a utility pole (obstruction) during aerial application. The obstruction was a related factor.Jul 21, 1997 · N919SF · DestroyedNTSB LAX97LA246Accident · No injuriesLimited investigationFinal reportMaule MX-7-180A · Long Beach, CAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during rollout.Jul 21, 1997 · N600XX · Substantial damageNTSB IAD97LA102Accident · 1 fatalLimited investigationFinal reportLardas Renegade Spirit · Boonsboro, MDThe pilot's failure to maintain control of his homebuilt airplane during a low level maneuver after a loss of engine power due to undetermined reasons. A factor in the accident was the pilot's alcohol impairment.Jul 21, 1997 · N416RS · DestroyedNTSB FTW97LA277Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Blackwell, OKpartial loss of engine power for undetermined reasons. Factors relating to the accident were: the high vegetation and ditch in the emergency landing area.Jul 21, 1997 · N8784L · Substantial damageNTSB FTW97LA276Accident · No injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Palestine, ARThe pilot's failure to maintain clearance with the wire transmission line due to his diverted attention.Jul 21, 1997 · N8031K · DestroyedNTSB DCA97WA054Accident · No injuriesForeign investigationLearjet LR-31 · Southern Thaila, ThailandJul 21, 1997 · DestroyedNTSB CHI97LA217Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Hill City, KSthe sustained partial loss of engine power due to low compression on one cylinder and the rough, uneven terrain.Jul 21, 1997 · N268JW · Substantial damageNTSB ATL97LA111Accident · No injuriesLimited investigationFinal reportAvid IV · Memphis, TNThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the repositioning of the control stick.Jul 21, 1997 · N913R · Substantial damageNTSB SEA97LA172Accident · 1 fatalLimited investigationFinal reportGrumman G-164A · Pingree, IDThe pilot-in-command's failure to maintain adequate clearance with the power lines. A contributing factor was the unmarked power lines.Jul 20, 1997 · N6550 · DestroyedNTSB SEA97LA171Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Yamhill, ORLoss of engine power for undetermined reasons.Jul 20, 1997 · N1105B · Substantial damageNTSB SEA97LA170Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Donnelly, IDThe pilot's failure to perform proper preflight planning for the flight, and his failure to obtain/maintain clearance from trees during takeoff. Factors contributing to the accident include the pilot's delayed remedial action, his improper use of flaps, and…Jul 20, 1997 · N1418U · Substantial damageNTSB FTW97LA275Accident · 1 fatalLimited investigationFinal reportEichman Aerobat III · Brownsville, TXinadequate design by the pilot/builder/designer. Related factors were: the porpoise that was encountered by the pilot during the takeoff, and the subsequent jammed rudder.Jul 20, 1997 · N17638 · Substantial damageNTSB FTW97FA274Accident · 1 fatalField investigationFinal reportHillam Rans S-9 · Mckinney, TXloss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with the terrain.Jul 20, 1997 · N1678N · DestroyedNTSB CHI97LA216Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-8 · Menominee Falls, WIthe slippage of the glider launch equipment (winch). Factors were the pilot's encounter with a stall/spin and the lack of possibility for remedial action to avoid impact with the terrain.Jul 20, 1997 · N79106 · Substantial damageNTSB CHI97LA215Accident · No injuriesLimited investigationFinal reportCessna 182 · Chippewa Falls, WIthe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.Jul 20, 1997 · N5820B · Substantial damageNTSB CHI97FA220Accident · 4 fatalField investigationFinal reportBeech B-60 · Springfield, MOThe pilot's fuel mismanagement and his failure to maintain adequate airspeed which resulted in fuel exhaustion followed by the loss of power in one engine and the loss of aircraft control. Contributing was the pilot's failure to refuel the aircraft, the…Jul 20, 1997 · N3359P · DestroyedNTSB ATL97LA109Accident · No injuriesLimited investigationFinal reportCessna 172M · Athens, TNthe pilot's failure to initiate a go-around. The pilot's misjudged approach was a factor.Jul 20, 1997 · N13428 · Substantial damageNTSB ATL97LA108Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadia, FLfailure of the right nose wheel steering linkage. The close proximity of the fence was a related factor.Jul 20, 1997 · N152DG · Substantial damageNTSB ATL97LA107Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Leesburg, FLthe pilot's inadvertent entry into a secondary stall and spin, as engine power faltered during application of power, while recovering from an intentional stall. The hesitation (faltering) of power and the pilot's diverted attention were related factors.Jul 20, 1997 · N98879 · Substantial damageNTSB ANC97LA108Accident · No injuriesLimited investigationFinal reportGoode Avid Flyer MK-IV · Nikiski, AKThe pilot's inadequate compensation for wind conditions. Factors were the sudden windshift, and the pilot's lack of seaplane certification.Jul 20, 1997 · N4356H · Substantial damageNTSB ANC97LA107Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Wasilla, AKThe pilot's failure to maintain aircraft control during takeoff. Factors were the intentional relinquishing of controls by the pilot, and interference with the rudder controls by the nonpilot passenger.Jul 20, 1997 · N6822L · DestroyedNTSB SEA97LA173Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Graham, WAInadequate aircraft preflight by the pilot-in-command, and water contamination in the fuel resulting in a loss of engine power. A factor was a power transmission line in the forced landing area.Jul 19, 1997 · N4292V · Substantial damageNTSB IAD97LA101Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Edgartown, MAThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. Related factors were the crosswind, wind gusts and high vegetation.Jul 19, 1997 · N4530J · Substantial damageNTSB FTW97LA272Accident · Minor injuriesLimited investigationFinal reportBeech C35 · Chickasha, OKthe pilot's improper positioning of the fuel selector, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's failure to follow the checklist, and the lack of suitable terrain for the forced landing.Jul 19, 1997 · N1878D · Substantial damage