NTSB investigations
180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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 GAA18CA163Accident · No injuriesData collectionFinal reportCessna 172 · Bedford, MAThe pilot’s improper landing flare, which resulted in substantial damage.NTSB GAA18CA158Accident · Minor injuriesData collectionFinal reportJohnson Gerald CR-1 · Altamont, NYThe pilot’s failure to maintain the runway heading during the approach in gusting crosswind conditions.NTSB GAA18CA156Accident · No injuriesData collectionFinal reportStinson 108 · Cedar Rapids, IAThe pilot’s improper landing flare, which resulted in a loss of directional control and a nose-over.NTSB ERA18MA099Accident · 5 fatalClass 1 · MajorFinal reportAmerican Eurocopter AS350B2 · New York, NYLiberty Helicopters Inc.'s use of a NYONair-provided passenger harness/tether system, which caught on and activated the floor-mounted engine fuel shutoff lever and resulted in the in-flight loss of engine power and the subsequent ditching. Contributing to…NTSB DCA18WA106Accident · 11 fatalForeign investigationCanadair CL600 2B16 · Shahr-e Kurd, IranThe Transportation Safety Board of Canada has informed the NTSB of an accident involving a Challenger 604, which occurred on March 11, 2018, in the Islamic Republic of Iran. All investigative information will be released by the government of Iran.NTSB GAA18CA181Accident · No injuriesData collectionFinal reportPiper PA22 · Hillsboro, ORThe pilot's failure to maintain directional control during the landing roll in tailwind conditions.NTSB GAA18CA165Accident · No injuriesData collectionFinal reportBellanca 1413 · Anacortes, WAThe pilot’s failure to maintain directional control during landing.NTSB GAA18CA159Accident · No injuriesData collectionFinal reportHughes 269 · Jacksonville, FLThe pilot’s failure to maintain rotor rpm during a practice autorotation, which resulted in ground contact and a dynamic rollover.NTSB GAA18CA155Accident · No injuriesData collectionFinal reportLearjet 31 · Mount Pleasant, MIThe airplane’s collision with deer during the landing roll.NTSB CEN18LA119Accident · Serious injuriesClass 2 · LimitedFinal reportCzech Sport Piper Sport · Addison, TXThe operator’s use of improper fuel, which resulted in partial loss of engine power due to vapor lock.NTSB GAA18CA171Accident · No injuriesData collectionFinal reportBeech 76 · Oshkosh, WIThe pilot’s failure to extend the landing gear and the flight instructor’s failure to ensure that the landing gear were extended during landing. Contributing to the accident were the pilot’s and the instructor’s improper use of checklist.NTSB GAA18CA164Accident · No injuriesData collectionFinal reportCessna 180 · Mount Vernon, WAThe pilot’s failure to maintain directional control of the airplane during landing.NTSB GAA18CA152Accident · Minor injuriesData collectionFinal reportPiper PA 32R · Big Spring, TXThe pilot’s failure to manage the airplane’s fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s decision to attempt the flight with an inoperative fuel gauge.NTSB GAA18CA153Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Many, LAThe pilot’s improper application of the brakes during landing, which resulted in a nose-over.NTSB CEN18LA118Accident · Minor injuriesLimited investigationFinal reportBereznak Lancair Legacy · Temple, TXThe failure of the fuel selector valve in a nearly closed position, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN18FA116Accident · 2 fatalField investigationFinal reportPiper PA 31P · Laredo, TXAn engine malfunction for undetermined reasons and the subsequent loss of control, due to the pilot's improper decision to maneuver the airplane below minimum controllable airspeed and his improper response to the loss of engine power.NTSB WPR18LA101Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Paso Robles, CAThe pilots' inadequate preflight inspection, which failed to ensure that the oil filler cap was secured and resulted in oil starvation and a total loss of engine power.NTSB GAA18CA160Accident · No injuriesData collectionFinal reportCessna 172 · England, ARThe pilot’s failure to detect water in the fuel system during the preflight inspection, which resulted in a loss of engine power during departure and a subsequent impact with terrain.NTSB GAA18CA151Accident · No injuriesData collectionFinal reportCessna 172 · Lakeland, FLThe student pilot’s improper landing flare in gusting crosswind conditions, which resulted in a bounced landing.NTSB GAA18CA150Accident · No injuriesData collectionFinal reportCessna 172 · Kent, OHA deer collided with aircraft during landing at night.NTSB ERA18LA098Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Churchville, MDThe pilot's improper landing flare, which resulted in the airplane ballooning on touchdown, and his subsequent failure to maintain directional control during the attempted landing and subsequent go-around.NTSB CEN18LA177Accident · No injuriesLimited investigationFinal reportCessna 150M · Sinton, TXThe inadequate service and repair of the airplane's carburetor, which led to a partial loss of engine power during takeoff and resulted in a forced landing.NTSB CEN18LA121Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Blair, WIThe pilot’s failure to recognize and compensate for hazards during the external load operation, which led to a collision between a lineman (external load) and a powerline.NTSB ERA18LA097Accident · Minor injuriesLimited investigationFinal reportReilly Charles W Escapade · Palatka, FLThe interruption of fuel to the engine during final approach, which resulted in a total loss of engine power due to fuel starvation, and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.NTSB WPR18LA102Accident · No injuriesClass 3 · LimitedFinal reportMacdonald Craig MAC CUB · Ogden, UTThe pilot’s failure to use carburetor heat during the flight, which resulted in a partial loss of engine power due to carburetor icing.NTSB ERA18LA095Accident · 1 fatalLimited investigationFinal reportRobert Snyder Autogyro Calidus · Beaufort, SCThe gyroplane pilot's failure to maintain rotor speed and aircraft control as he was attempting to return to the runway during a low-altitude simulated engine-out maneuver.NTSB CEN18LA115Accident · No injuriesLimited investigationFinal reportMesserschmitt-Bolkow-Blohm BK 117 B-2 · Sheboygan, WIThe restricted cyclic control movement for reasons that could not be determined because postaccident examination and testing of the cyclic control system did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal…NTSB WPR18WA240Accident · No injuriesForeign investigationCessna 206 · Southport, AustraliaOn March 4, 2018, about 1040 local time, a Cessna U206G airplane, VH-LHQ, was substantially damaged when it impacted water during takeoff near Southport, Queensland, Australia. The pilot and two passengers were not injured. The investigation is under the…NTSB WPR18LA098Accident · Serious injuriesClass 3 · LimitedFinal reportRaytheon A36 · Enumclaw, WAA total loss of engine power due to oil starvation as a result of a loose oil line B-nut.NTSB GAA18CA184Accident · No injuriesData collectionFinal reportPiper PA32 · Camas, WAThe pilot’s inadequate inflight fuel management and his failure to switch to a fuel tank with adequate fuel, which resulted in fuel starvation.NTSB DCA18WA103Incident · No injuriesForeign investigationBoeing 737 · Guayaquil, EcuadorThe Civil Aviation Authority of Ecuador has notified the NTSB of an incident involving a Boeing 737-400, which occurred on March 4, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13. All investigative…NTSB GAA18CA204Accident · No injuriesData collectionFinal reportPiper PA28 · Vero Beach, FLThe student pilot’s failure to maintain a stabilized approach, which resulted in overcorrection with the rudder during the landing, loss of control, and a runway excursion.NTSB ENG18RA018Incident · No injuriesForeign investigationCessna 441 · Broome, Australia, AustraliaThe Australian Transport Safety Bureau (ATSB) has notified the NTSB of an incident involving a Cessna 441 which occurred on March 2, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of ICAO…NTSB CEN18LA113Accident · Minor injuriesLimited investigationFinal reportAero Commander 100-180 · Deport, TXA total loss of engine power due to water contamination of the fuel system. Contributing to the accident was the pilot/owner's inadequate maintenance of the fuel caps.NTSB GAA18CA149Accident · Minor injuriesData collectionFinal reportBeech B · Ferris, TXThe pilot’s improper preflight inspection of the fuel level, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to lower the landing gear before the emergency landing.NTSB ERA18LA102Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 32-300 · Pompano Beach, FLThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, which resulted in an aerodynamic stall, loss of control, and impact with terrain. Contributing to the accident was the pilot’s failure to maintain a proper approach…NTSB ERA18LA094Accident · 2 fatalLimited investigationFinal reportCessna 172 · Ocean City, MDThe pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information.NTSB ENG18RA020Incident · No injuriesForeign investigationAvro RJ85 · Bishkek, KyrgyzstanOn March 1, 2018, a Tez Jet Airline Avro RJ85, powered by four Honeywell (formally Lycoming) LF507-1F turbofan engines experienced an uncontained No. 1 (left most) engine turbine failure during climb. The airplane returned to the Bishkek-Manas International…NTSB CEN18LA114Accident · Minor injuriesLimited investigationFinal reportBeech 77 · Odessa, TXThe pilot’s improper takeoff procedures and his failure to abort the takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of experience in the airplane.NTSB WPR18WA097Accident · 2 fatalForeign investigationRobinson Helicopter R44 II · Ogies, South AfricaOn February 28, 2018, at 0945 Universal Coordinated Time (UTC), a South African registered Robinson Helicopter Company R44 Raven II, ZS-HKZ, lost engine power while maneuvering near Truter Boerdery Farm, Ogies, Mpumalana Province, South Africa. The helicopter…NTSB WPR18CA096Accident · Serious injuriesData collectionFinal reportBell 47G · Pixley, CAA total loss of engine power due to fuel starvation, which resulted from the pilot’s failure to ensure that adequate fuel was on board for the flight. Contributing to the accident was the pilot’s self-induced pressure to complete the flight due to impending…NTSB GAA18CA146Accident · Minor injuriesData collectionFinal reportCessna 172 · Gatesvile, TXThe pilot’s failure to maintain directional control during initial climb in a gusty condition.NTSB GAA18CA145Accident · No injuriesData collectionFinal reportPiper PA28R · Milton-Freewater, ORThe pilot receiving instruction’s and flight instructor’s improper decision to enter a canyon surrounded by steep rising terrain and their subsequent failure to maintain clearance from terrain while maneuvering at a low altitude.NTSB ERA18FA092Accident · 2 fatalField investigationFinal reportQuest Kodiac 100 · Georgetown, FLThe pilots' spatial disorientation while maneuvering for landing in night conditions over unlighted terrain, which resulted in an uncontrolled descent and impact with water.NTSB DCA18WA315Accident · No injuriesForeign investigationAirbus A320 · Tallinn, EstoniaThe Estonian Safety Investigation Bureau (AIB) has notified the NTSB of an accident involving a Airbus 320, which occurred on February 28, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…NTSB CEN18WA133Incident · No injuriesForeign investigationCessna 182P · Abbeville, FranceOn February 28, 2018, about 0845 universal coordinated time (UTC), a Cessna 182P airplane, N609PC, had an inflight engine failure and subsequent forced landing near Abbeville, France. The pilot and passenger were uninjured, and the airplane sustained minor…NTSB ERA18WA100Accident · 1 fatalForeign investigationBeech V35B · Brasilandia, Mato Grosso do Sul, BrazilThe government of Brazil has notified the NTSB of an accident involving a Beech V35B airplane that occurred on February 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB ERA18FA088Accident · 1 fatalField investigationFinal reportAir Tractor AT-802 · Greenwood, MSThe pilot's failure to maintain clearance from a tree for reasons that could not be determined based on the available evidence.NTSB CEN18WA111Incident · No injuriesForeign investigationCirrus Design SF50 · Nuuk, GreenlandOn February 26, 2018, about 1804 coordinated universal time, a Cirrus Design Corporation SF50 Vision Jet, serial number 0034, United States registration N3AD, sustained minor damage during landing roll on runway 23 at Nuuk Airport (BGGH), Nuuk, Greenland. The…