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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB CHI99LA141Accident · Minor injuriesLimited investigationFinal reportBarrett Bensen B-8 · Mt. Pleasant, MIthe inadequate rotor rpm by the pilot.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX99LA167Accident · No injuriesLimited investigationFinal reportMassey Super Stallion · Shafter, CAThe pilot's decision to attempt a landing with insufficient runway remaining to stop the airplane.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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…NTSB ANC99WA055Accident · Minor injuriesForeign investigationCessna 170B · Tsirku Glacier, CanadaNTSB 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.NTSB 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.NTSB 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.NTSB CHI99LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Blair, NEThe pilot's misjudged landing flare.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB SEA99LA141Accident · No injuriesLimited investigationFinal reportBell 212 · Snoqualmie, WAClearance from an object was not maintained. A tree was a factor.NTSB 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.NTSB 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…NTSB CHI99LA134Accident · Minor injuriesLimited investigationFinal reportDawe Arnet Pereyra AV II · Fremont, MIthe seizure of the powerplant.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB IAD99WA071Accident · No injuriesForeign investigationCessna 172M · Georgetown/Guy, GuyanaNTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB ANC99LA049Accident · Minor injuriesLimited investigationFinal reportCessna 185E · Haines, AKThe pilot's inadequate compensation for the gusty crosswind conditions.