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 CHI99LA143Accident · No injuriesLimited investigationFinal reportNarzinski Avid Flyer Mark IV · West Alton, MOThe failure of the connecting rod bearing, and the rough/uneven terrain condition.May 1, 1999 · N313N · Substantial damageNTSB CHI99LA141Accident · Minor injuriesLimited investigationFinal reportBarrett Bensen B-8 · Mt. Pleasant, MIthe inadequate rotor rpm by the pilot.May 1, 1999 · N4659T · Substantial damageNTSB CHI99LA137Accident · 2 fatalLimited investigationFinal reportBerrick GP-4 · Plattsmouth, NEaircraft control and airspeed not maintained by the pilot-in-command. A factor to the accident was the inadvertent stall.May 1, 1999 · N54WB · DestroyedNTSB ATL99LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Seneca, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with trees.May 1, 1999 · N50943 · Substantial damageNTSB SEA99LA065Accident · No injuriesLimited investigationFinal reportBoeing Stearman 1B75A · Olympia, WAThe pilot's failure to adequately compensate for wind conditions. A factor contributing to the accident was a crosswind during the landing roll out.Apr 30, 1999 · N56208 · Substantial damageNTSB SEA99LA064Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Chehalis, WADirectional control was not maintained after the right brake locked up for undetermined reasons. An uncontrolled ground loop was a factor.Apr 30, 1999 · N275HP · Substantial damageNTSB LAX99LA167Accident · No injuriesLimited investigationFinal reportMassey Super Stallion · Shafter, CAThe pilot's decision to attempt a landing with insufficient runway remaining to stop the airplane.Apr 30, 1999 · N6143E · Substantial damageNTSB LAX99LA166Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Concord, CAThe inadequate supervision of the student pilot by the flight instructor during the practice autorotation, which resulted in a delayed flare and the tail rotor contacting the ground. A factor was a misinterpreted communication between the flight instructor…Apr 30, 1999 · N6148V · Substantial damageNTSB IAD99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Manassas, VAThe student pilot's failure to maintain the proper rate of descend on final approach followed by an improper flare which resulted on a hard landing.Apr 30, 1999 · N2338D · Substantial damageNTSB FTW99LA131Accident · Serious injuriesLimited investigationFinal reportBell 206B · Brazoria 440lThe failure of the platform worker to maintain clearance with the turning tail rotor blades. A factor was the inadequate coordination between the pilot and the passengers pertaining to procedures for disembarking from the helicopter.Apr 30, 1999 · N35WH · No damageNTSB FTW99LA130Accident · No injuriesLimited investigationFinal reportCessna 210A · Bay City, TXThe pilot's inadequate management of fuel and his failure to follow the pre-landing checklist resulting in the loss of engine power as a result of fuel starvation. Factors were the pilot's physiological condition and the lack of suitable terrain for the…Apr 30, 1999 · N9404X · Substantial damageNTSB DEN99LA070Accident · Minor injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe pilot's improper mixture control use and the engine's subsequent power loss due to fuel starvation, and the lack of suitable terrain for the pilot to perform a forced landing. Factors were the pilot's lack of recent experience in type of airplane, the…Apr 30, 1999 · N59235 · DestroyedNTSB ANC99WA055Accident · Minor injuriesForeign investigationCessna 170B · Tsirku Glacier, CanadaApr 30, 1999 · N2599C · Substantial damageNTSB MIA99LA147Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Lares, PRThe improper touchdown by the pilot resulting in dynamic rollover. Contributing to the accident was the pilot's diverted attention.Apr 29, 1999 · N2314T · Substantial damageNTSB FTW99LA126Accident · No injuriesLimited investigationFinal reportBeech J35 · Bass, ARThe pilot's failure to maintain aircraft directional control during landing roll on a gravel road. Factors were the clouds and low ceilings, the low fuel status, and the gravel road condition.Apr 29, 1999 · N735B · Substantial damageNTSB FTW99LA125Accident · Serious injuriesLimited investigationFinal reportOakes J3 CUB · Greenbriar, ARThe student pilot's failure to compensate for the gusty wind condition while maneuvering, which resulted in the inadvertent stall. A factor was the gusty wind condition.Apr 29, 1999 · N105LM · Substantial damageNTSB CHI99LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Blair, NEThe pilot's misjudged landing flare.Apr 29, 1999 · N5336R · Substantial damageNTSB ATL99FA078Accident · Serious injuriesField investigationFinal reportCessna 172N · Winter Haven, FLThe pilot of the other aircraft's failure to maintain visual lookout. A factor was the other pilot's disregard for VFR Traffic pattern procedures.Apr 29, 1999 · N739FX · 2 aircraft · Substantial damageNTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.Apr 28, 1999 · N8426J · Substantial damageNTSB MIA99FA142Accident · 4 fatalField investigationFinal reportCessna 210L · Vero Beach, FLA loss of engine power due to a disconnected throttle/power lever, cable. Also causal was the failure of the mechanic to install a cotter pin in the throttle control cable attach hardware at the throttle control arm, and failure of the company quality control…Apr 28, 1999 · N3458H · DestroyedNTSB FTW99LA124Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Hickory Ridge, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall/spin.Apr 28, 1999 · N22524 · Substantial damageNTSB DEN99LA068Accident · No injuriesLimited investigationFinal reportWeatherly 201-C · Two Buttes, COThe pilot's selection of an unsuitable landing area. Factors associated with the accident were an unknown object in the landing area, a failure of a main landing gear tire, and the pilot's inadvertent ground loop/swerve.Apr 28, 1999 · N9095W · Substantial damageNTSB DEN99LA067Accident · No injuriesLimited investigationFinal reportCessna 172I · Las Cruces, NMThe pilot of N46204's failure to maintain visual lookout and to identify the other aircraft visually during landing.Apr 28, 1999 · N46204 · 2 aircraft · Substantial damageNTSB ATL99LA077Accident · Serious injuriesLimited investigationFinal reportBeech 23-B24R · Boone, NCThe pilots failure to obtain/maintain proper climb rate during initial climbout. This resulted in the collision with the mountain/hilly terrain.Apr 28, 1999 · N12RF · DestroyedNTSB ATL99LA076Accident · Minor injuriesLimited investigationFinal reportSchempp-Hirth MINI-NIMBUS · Groveland, FLThe pilot's inability to locate a thermal and the in-flight encounter with a down draft.Apr 28, 1999 · N100GG · Substantial damageNTSB FTW99FA123Accident · 1 fatalField investigationFinal reportCessna 402C · Goldsby, OKThe fatigue failure of the right wing spar as a result of inadequate quality control during manufacture of the spar. A factor was the inadequate inspection of the right wing by maintenance personnel, which failed to detect the crack.Apr 27, 1999 · N819BW · DestroyedNTSB ANC99LA057Accident · No injuriesLimited investigationFinal reportde Havilland DHC-3 · Healy, AKThe pilot's selection of an unsafe/hazardous area for landing. Factors in the accident were the presence of a tail wind, the pilot's inadequate evaluation of the wind conditions, and a narrow airstrip.Apr 27, 1999 · N3125N · Substantial damageNTSB ANC99LA052Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Juneau, AKThe failure of the engine driven fuel pump for undetermined reasons. Factors associated with this accident were the low altitude at which the failure occurred resulting in task overload of the pilot, and landing the amphibious airplane in the swampy terrain…Apr 27, 1999 · N93311 · Substantial damageNTSB SEA99LA141Accident · No injuriesLimited investigationFinal reportBell 212 · Snoqualmie, WAClearance from an object was not maintained. A tree was a factor.Apr 26, 1999 · N98W · Substantial damageNTSB DEN99LA065Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Wendover, UTThe pilot's improper preflight/in-flight planning and decision making, resulting in fuel supply exhaustion. A factor was the closed runway condition.Apr 26, 1999 · N906DS · Substantial damageNTSB CHI99LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Mayview, MOthe pilot's selection of unsuitable terrain for the attempted precautionary landing. Factors to the accident were the overcast weather condition, inadequate preflight planning by the pilot, the inadvertent flight into instrument meteorological conditions, and…Apr 26, 1999 · N220NY · Substantial damageNTSB CHI99LA134Accident · Minor injuriesLimited investigationFinal reportDawe Arnet Pereyra AV II · Fremont, MIthe seizure of the powerplant.Apr 26, 1999 · N6123P · DestroyedNTSB CHI99IA144Incident · No injuriesIncident investigationFinal reportCessna 206H · Wheeling, ILimproper installation of the aileron control bellcrank stop bolts and lock nuts during the manufacturing process which resulted in a binding aileron control surface.Apr 26, 1999 · N42122 · No damageNTSB ATL99LA075Accident · No injuriesLimited investigationFinal reportBeech 36 · Williamston, NCThe pilot's inadequate evaluation of winds that resulted in the loss of directional control during an attempted takeoff with a tailwind. A factor was the tailwind condition.Apr 26, 1999 · N31291 · Substantial damageNTSB ANC99LA050Accident · Serious injuriesLimited investigationFinal reportLuscombe L-8F · Kodiak, AKThe pilot's inadequate terrain clearance during the initial climb, and the inadvertent stall/spin during the turn to avoid terrain. A factor in this accident was the pilot exceeding the allowable maximum gross weight of the airplane.Apr 26, 1999 · N45627 · Substantial damageNTSB NYC99FA097Accident · 1 fatalField investigationFinal reportIves Sonerai II-L · Eastford, CTInadequate welding of the airplane's spar-box by the owner/builder, which resulted in a total spar-box failure in-flight. A factor in the accident was the pilot's decision to perform aerobatics.Apr 25, 1999 · N56RA · DestroyedNTSB MIA99LA139Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Apex, NCthe pilot's failure to maintain control of the airplane resulting in the airplane drifting, and subsequently impacting with trees.Apr 25, 1999 · N9249S · Substantial damageNTSB LAX99LA164Accident · No injuriesLimited investigationFinal reportBeech 36TC · Lake Elsinore, CAFuel starvation due to the pilot's inadequate preflight inspection procedures and his failure to accurately determine the amount of fuel onboard prior to departure. A factor in the accident was the erratic fuel quantity sensor in the left fuel tank.Apr 25, 1999 · N36MN · Substantial damageNTSB LAX99FA162Accident · 2 fatalField investigationFinal reportGlobe GC-1B · Trona, CAThe pilot's failure to maintain an adequate terrain clearance altitude while performing intentional low altitude passes over a campground.Apr 25, 1999 · N80720 · DestroyedNTSB CHI99LA132Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lake Geneva, WIthe student pilot's failure to maintain directional control during the landing. Factors contributing to this accident were the variable winds and the ditch.Apr 25, 1999 · N64373 · Substantial damageNTSB LAX99FA161Accident · 2 fatalField investigationFinal reportCessna 210 · Hayward, CAThe pilot's inadequate preflight planning and his failure to verify fuel consumption during flight that resulted in fuel exhaustion and subsequent collision with obstacles and the ground.Apr 24, 1999 · N9512T · DestroyedNTSB IAD99WA071Accident · No injuriesForeign investigationCessna 172M · Georgetown/Guy, GuyanaApr 24, 1999 · 8RGHA · DestroyedNTSB CHI99LA133Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Morris, ILthe directional control not maintained by the pilot. Contributing factors were the wind gusts, crosswind and runway light.Apr 24, 1999 · N38968 · Substantial damageNTSB CHI99LA131Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greencastle, INthe pilot operating with known deficiencies in equipment and the fuel cap that disengaged. Factors were the wet grass, and muddy terrain conditions.Apr 24, 1999 · N3270T · Substantial damageNTSB ATL99FA074Accident · 1 fatalField investigationFinal reportCessna 172 · Savannah, GAThe pilot's selection of the wrong runway for landing and his delayed go-around, which resulted in the collision with trees. A factor was the tailwind on landing.Apr 24, 1999 · N6433B · DestroyedNTSB MIA99LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Picayune, MSThe failure of the pilot to recover from the bounced landing resulting in collapse of the nose landing gear. A finding in the accident was the crosswind weather condition that existed at the time of the accident.Apr 23, 1999 · N2699Q · Substantial damageNTSB MIA99FA140Accident · 1 fatalField investigationFinal reportBeech B95A · Fountain, FLThe pilot's inadequate preflight inspection of the airplane that resulted in a loss of engine power because of fuel vent blockage and his selection of unsuitable terrain for the forced landing.Apr 23, 1999 · N6600 · DestroyedNTSB LAX99LA163Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-200 · Fitiuta, Australiathe mechanical separation of the left engine beta control linkage during landing rollout, which resulted in asymmetrical decelerative action and the pilot's subsequent inability to maintain directional control. The separation of the linkage was due to the…Apr 23, 1999 · N719AS · Substantial damageNTSB DEN99FA066Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar 601P · Ruidoso, NMThe pilot's failure to maintain aircraft control for undetermined reason. A factor was the low ceiling IMC weather condition.Apr 23, 1999 · N48MD · DestroyedNTSB ANC99LA049Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Haines, AKThe pilot's inadequate compensation for the gusty crosswind conditions.Apr 23, 1999 · N3539F · Substantial damage