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 ANC11LA041Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Nome, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's decision to fly the airplane with an inoperative wing flap system.NTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.NTSB WPR11LA244Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Stockton, CAThe pilot's failure to maintain clearance from obstacles.NTSB WPR11FA242Accident · 4 fatalField investigationFinal reportCessna 172R · Wendover, UTThe pilot did not maintain adequate airspeed during the downwind turn resulting in an aerodynamic stall, in-flight loss of control, and spin. Contributing to the accident was the pilot’s inadequate preflight planning and exceedance of the approved weight and…NTSB ERA11CA323Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Wurstboro, NYThe flying pilot's failure to maintain aircraft control and the flight instructor's inadequate supervision while landing with a gusting wind. Contributing to the accident was the lack of communication between the flight instructor and pilot under evaluation…NTSB WPR11LA300Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Los Angeles, CAThe ground crewmembers’ failure to follow proper procedures for removing a stuck or jammed tow bar, which resulted in a ground crew injury.NTSB ERA11CA319Accident · Serious injuriesData collectionFinal reportAero AT SP Zoo AT-4 LSA · Concord, NHThe student pilot's loss of aircraft control during a go-around maneuver following a bounced landing.NTSB CEN11LA366Accident · No injuriesLimited investigationFinal reportCessna 150F · Sully, IAThe pilot's failure to attain an adequate climb rate during the initial takeoff, resulting in the airplane settling back down and departing the runway. Contributing to the accident was the pilot's inadequate preflight planning and preparation.NTSB ERA11FA321Accident · 4 fatalField investigationFinal reportBeech V35 · Ellijay, GAThe pilot’s failure to maintain adequate clearance from terrain while maneuvering in a mountainous area.NTSB CEN11LA367Accident · Minor injuriesLimited investigationFinal reportJones Cozy Mark IV · Sioux City, IAThe pilot's improper installation of the gascolator gasket during the airplane's last condition inspection, which resulted in a partial loss of engine power while maneuvering.NTSB WPR11FA241Accident · 3 fatalField investigationFinal reportCessna R172K · Cold Springs, NVThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in a controlled collision with terrain.NTSB ERA11TA318Accident · Minor injuriesFinal reportBell OH-58A · Ft. Pierce, FLThe pilot's failure to recognize and avoid a loss of tail rotor effectiveness, which resulted in a loss of control and hard landing.NTSB ERA11IA320Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Mariner · Redding, CTThe pilot's inadequate helicopter preflight inspection and the mechanic’s inadequate annual inspection, both of which failed to detect a worn bolt in the tail rotor teeter hinge prior to its fracture due to fatigue.NTSB CEN11FA359Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B2 · Fort Worth, TXThe pilot’s loss of control due to his not maintaining adequate airspeed and altitude during a simulated hydraulic flight control failure. Contributing to the accident was the flight instructor’s inadequate supervision and delayed remedial response.NTSB CEN11FA358Accident · 2 fatalField investigationFinal reportRockwell 112 · Bryan, TXThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…NTSB ANC11CA040Accident · No injuriesData collectionFinal reportCessna 140 · Chickaloon, AKThe pilot's improper decision to take off downwind from unsuitable terrain.NTSB WPR11LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hazelton, IDA total loss of engine power during low-level maneuvering due to an excessively worn carburetor.NTSB CEN11LA388Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Ironton, OHThe total loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ANC11LA048Accident · No injuriesLimited investigationFinal reportDehavilland DHC-3T · Bettles Field, AKThe pilot's selection of unsuitable terrain for the landing, which resulted in a loss of directional control.NTSB ANC11LA039Accident · No injuriesLimited investigationFinal reportCessna 170A · Wasilla, AKThe pilot's loss of directional control during landing, which resulted in a runway excursion. Contributing to the accident were the effects of multiple modifications to the main and tailwheel landing gear through the supplemental type certificate and FAA…NTSB WPR11FA239Accident · 1 fatalField investigationFinal reportBrantly B-2B · Weaverville, CAThe student pilot's decision to fly in windy conditions that exceeded his capabilities, which resulted in his subsequent loss of helicopter control. Contributing to the accident was his lack of flight experience in the accident helicopter.NTSB WPR11CA243Accident · No injuriesData collectionFinal reportBell 206B3 · Glendale, AZThe certified flight instructor's failure to maintain adequate main rotor RPM during the autorotation.NTSB ERA11TA317Accident · Minor injuriesFinal reportBell OH-58C · Panama City, FLThe drooping electrical conduit, which snagged the vertical fin and resulted in the pilot's inability to control the helicopter. Contributing to the accident was the operator's decision to have the pilot fly the helicopter out of the hangar.NTSB ERA11LA330Accident · No injuriesLimited investigationFinal reportBeech C90 · Camden, SCThe pilot's in-flight decision to continue toward his destination, through known significant weather, when safer alternatives were available.NTSB ERA11IA316Incident · No injuriesIncident investigationFinal reportIsrael Aircraft Industries Gulfstream 200 · Newburgh, NYThe flight crew did not ensure that the landing gear selector handle was in the full down (extend) position. Contributing to the incident was inadequate checklist information.NTSB ENG11WA038Accident · No injuriesForeign investigationAerospatiale AS350 · Big Trout Lake, Ontario, CanadaAn Expedition Helicopters Aerospatiale AS 350 B-2, registration C-GSSS, powered by a Honeywell LTS-101-700-D engine, was substantially damaged during an emergency autorotation landing following an in-flight engine shutdown. According to the Transportation…NTSB CEN11LA396Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Oak Ridge, LAThe flight instructor's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and subsequent impact with trees.NTSB CEN11LA365Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Freemont, MIThe pilot’s failure to attain a positive climb rate following takeoff for reasons that could not be determined because the propeller was not provided for further examination. Contributing to the accident was the pilot's impairment from alcohol.NTSB CEN11CA363Accident · No injuriesData collectionFinal reportCubCrafters CC11-160 · Goldthwaite, TXThe pilot's encounter with a berm during the landing roll, resulting in the airplane nosing over.NTSB ANC11LA038Accident · No injuriesLimited investigationFinal reportCessna P206C · Wasilla, AKThe pilot's failure to maintain directional control during takeoff from an unpaved airstrip, resulting in a collision with trees.NTSB ANC11FA037Accident · 5 fatalField investigationFinal reportCessna 180 · Chugiak, AKThe pilot's loss of control of the airplane during takeoff, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in make and model, his lack of currency in FAA required takeoffs and landings, and his…NTSB ANC11CA036Accident · No injuriesData collectionFinal reportPiper J5A · Palmer, AKThe pilot's inadequate compensation for wind conditions.NTSB WPR11CA237Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Sedona, AZThe pilot's failure to maintain directional control on the landing roll out. Contributing to the accident was the pilot's decision to attempt a landing in crosswind conditions that exceeded the maximum demonstrated capability of the airplane.NTSB ERA11CA322Accident · No injuriesData collectionFinal reportCessna 140A · Quincy, FLThe private pilot's inability to maintain directional control of the airplane during the takeoff roll.NTSB ENG11WA029Incident · No injuriesForeign investigationAirbus A330 · Seoul, Korea, South KoreaOn May 26, 2011 the crew of a Korean Air A330-300, registration number HL7553, while climbing through 11,500 feet altitude, reported that they heard a loud bang from the number 2 engine followed by a high vibration increase. Approximately 2 minutes later, the…NTSB DCA11WA064Accident · No injuriesForeign investigationBoeing 737 · Brussels, BelgiumThe Belgium Air Accident Investigation Unit (AAIU) has notified the NTSB of an accident involving a B737-45D that occurred on May 26, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the provisions of ICAO…NTSB CEN11LA356Accident · Minor injuriesLimited investigationFinal reportBell 206 · Walton, KSA loss of engine power for undetermined reasons because postaccident examination of the airframe and engine revealed no anomalies.NTSB WPR11FA236Accident · Serious injuriesField investigationFinal reportEmbraer-Empresa Brasileira De EMB-500 · Sedona, AZThe pilots’ unstabilized approach and excessive airspeed during approach, which resulted in an insufficient landing distance to stop the airplane before overrunning the runway.NTSB WPR11CA235Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Yakima, WAThe pilot’s failure to maintain directional control upon landing.NTSB ERA11FA312Accident · 4 fatalField investigationFinal reportBeech 58 · Murphy, NCAn in-flight fire that mostly likely occurred in the right front cockpit area behind the instrument panel and below the glare shield; the origin of the fire could not be determined because of the extensive fire damage.NTSB CEN11WA692Incident · No injuriesForeign investigationDassault 7X · Subang, MalaysiaOn May 25, 2011, about 0810 Coordinated Universal Time (UTC), a Dassault Falcon 7X airplane, with Swiss registration HB-JFN, operated by Jet Link AG, had its flight crew report a runaway trim during descent and they declared an emergency. The flight crew was…NTSB CEN11RA687Accident · 12 fatalForeign investigationPilatus PC-12 · Faridabad Parvatiya Colony, IndiaOn May 25, 2011, an Indian registered Pilatus PC-12/45 airplane, VT-ACF, operated by Air Chartered Services Pvt, as an emergency medical services (EMS) flight, sustained substantial damage when the airplane impacted terrain near Faridabad Parvatiya Colony,…NTSB CEN11LA370Accident · Serious injuriesLimited investigationFinal reportBell 47G-3B-1 · Lakeville, MNThe loss of engine power due to a loose B-nut on the compressor discharge pressure bleed line.NTSB CEN11LA368Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Ann Arbor, MIThe flight instructor’s failure to maintain clearance from the propeller when exiting the airplane. Contributing to the accident were the instructor’s decision not to shut down the engine before exiting the airplane and the operator’s lack of a policy…NTSB WPR11LA234Accident · Minor injuriesLimited investigationFinal reportHoskins Zenith · Puyallup, WAThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of experience in the accident airplane.NTSB DCA11WA113Accident · 2 fatalForeign investigationBeech C90 · Kaduna, NigeriaOn May 24, 2011 about 1300 UTC, N346UZ, a Beechcraft C90, collided with the ground during approach to Kaduna Airport (KAD), Kaduna, Nigeria. The pilot and passenger were fatally injured. The airplane was substantially damaged. The local flight originated at…NTSB WPR11FA232Accident · Serious injuriesField investigationFinal reportCessna T207A · Monument Valley, UTThe pilot's decision to initiate a go-around after a bounced landing at an airport where go-arounds were not advised and his failure to maintain adequate airspeed during the go-around.NTSB ERA11WA335Accident · Serious injuriesForeign investigationCessna 208 · Roraima, BrazilOn May 23, 2011, about 1130 universal coordinated time, a Cessna 208B, Brazilian registration PT-OSG, was substantially damaged from impact and fire following an aborted takeoff. The Brazilian certificated pilot was seriously injured. The flight departed…NTSB ERA11WA308Accident · 2 fatalForeign investigationBell 206L-3 · Norte de Santander, ColombiaOn May 23, 2011, about 2105 Universal Coordinated Time (UTC), a Bell 206L-3, Columbian registration HK4448, operated by Aviheco S.A., was destroyed following a collision with terrain near Norte de Santander, Columbia. The local flight originated in Bogota.…NTSB DCA11WA063Accident · No injuriesForeign investigationBoeing 777 · Tel Aviv, IsraelOn May 23, 2011 at 0230 local time, a Boeing 777-800, registration 4X-ECD, operated by El Al airlines, after takeoff on a regular scheduled passenger flight from Tel Aviv to Newark, returned to Tel Aviv Ben Gurion airport after the left main landing gear…