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 CEN15LA439Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Alice, TXA loss of engine power during a practice power recovery autorotation for reasons that could not be determined based on the available information.NTSB WPR15WA271Accident · 4 fatalForeign investigationBell 407 · Chong Qing, China, ChinaOn September 13, 2015, at 0600 local time, a Bell 407 GX, B-7702, operated by Chong Qing General Aviation Corporation, collided with terrain during an aerial photo operation near Chong Qing, P. R. China. The helicopter was being operated under the pertinent…NTSB GAA15CA267Accident · No injuriesData collectionFinal reportCessna 180H · Delta Junction, AKThe pilot's failure to attain and maintain yaw control during the approach and attempted go around, which resulted in impact with trees and terrain.NTSB GAA15CA261Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lexington, NEThe pilot's improper fuel planning which resulted in fuel exhaustion, and loss of engine power. Additionally, the pilot's failure to maintain pitch control during the emergency landing, which resulted in an aerodynamic stall.NTSB ERA15LA354Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Moneta, VAThe pilot's premature retraction of the wing flaps and his subsequent failure to maintain pitch control during an attempted go-around, which resulted in the airplane exceeding its critical angle-of-attack and an aerodynamic stall. Contributing to the accident…NTSB ANC15LA070Accident · No injuriesLimited investigationFinal reportHelio H 295 · Delta Junction, AKA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA257Accident · No injuriesData collectionFinal reportGlenn Timothy C Skystar Series 5 · Green River, UTThe pilot's failure to maintain pitch attitude, which resulted in the airplane exceeding its critical angle of attack and a subsequent aerodynamic stall/spin.NTSB ERA15FA353Accident · 1 fatalField investigationFinal reportAero Vodochody L39 · Oneida, TNThe pilot's failure to maintain airplane control following a partial loss of engine power during initial climb. The reason for the partial loss of engine power could not be determined due to extensive postimpact damage.NTSB ERA15FA352Accident · 1 fatalField investigationFinal reportCessna 150 · Atco, NJThe student pilot's improper decision to intentionally maneuver at low altitude while waving to people on the ground, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.NTSB DCA15WA203Incident · No injuriesForeign investigationAirbus A320 · Perth, AustraliaThe Australian Transport Safety Board (ATSB) has notified the NTSB of an incident involving a AIRBUS A320 airplane, which occurred on September 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB CEN15LA412Accident · Minor injuriesLimited investigationFinal reportGuisinger Gary G Baby Belle · Stuart, IAThe failure of the tail rotor driveshaft for reasons that could not be determined due to the mechanically and thermally deformed fracture surface.NTSB GAA15CA297Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Spartanburg, SCThe pilot's failure to maintain pitch control during the landing which resulted in a bounced landing, and an aerodynamic stall during the attempted recovery.NTSB GAA15CA260Accident · No injuriesData collectionFinal reportRocci Martignoni JA30 Superstol · Santa Rosa, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and a ground loop.NTSB ERA15WA355Accident · 2 fatalForeign investigationSmith AEROSTAR600 · Santa Fé de Antioquia, ColombiaNTSB ERA15FA351Accident · 1 fatalField investigationFinal reportCessna 172 · Riegelwood, NCThe noncertificated pilot’s failure to maintain adequate clearance from terrain for reasons that could not be determined based on the available evidence.NTSB CEN15LA415Accident · No injuriesLimited investigationFinal reportBeech 58 · Gary, INThe pilot’s failure to ensure that the landing gear was down while on short final, his subsequent failure to conduct a go-around, and his loss of situational awareness of the airplane’s altitude above the runway while landing.NTSB CEN15LA407Accident · Serious injuriesLimited investigationFinal reportAlon A2 · Laramie, WYThe pilot’s failure to use carburetor heat in cruise flight while operating in an area conducive to serious carburetor icing, which resulted in a loss of engine power and an off-airport landing. Contributing to the accident was the pilot's decision to…NTSB GAA15CA269Accident · No injuriesData collectionFinal reportMooney M20TN · Myakka City, FLThe pilot's failure to maintain directional control during the landing roll in windy conditions, resulting in a runway excursion and collision with a fence.NTSB ERA15LA349Accident · 1 fatalLimited investigationFinal reportMooney M20TN · Atlantic City (Atlantic Ocean)A loose oxygen line, which was not detected by maintenance personnel during a recent annual inspection, that allowed oxygen to escape and drain the oxygen canister more quickly than the pilot expected. This reduced the pilot's availability of supplemental…NTSB CEN15WA406Accident · 1 fatalForeign investigationBeech Beech C 24R · Könnern, GermanyOn September 10, 2015 about 0830 UTC, a Beech C24R Sierra airplane, German registration D-EHZK, crashed into a field under unknown circumstances near Könnern, Germany. The pilot, who was the sole occupant, was fatally injured. The flight departed from the…NTSB GAA15CA258Accident · No injuriesData collectionFinal reportAirbus AS350 · Draper, UTThe ground recovery team member's failure to secure a rescue rope during the helicopter loading process in steep terrain, resulting in the rope fouling the helicopter's main rotor system.NTSB ERA15FA348Accident · 1 fatalField investigationFinal reportAerofab Lake LA-4-250 · Somerset, NJThe pilot's attempted 180-degree return to the runway immediately after takeoff in dark night conditions, which resulted in collision with trees and terrain. Also causal was the pilot's inadequate preflight inspection, which resulted in a takeoff with…NTSB CEN15WA454Accident · 2 fatalForeign investigationRobinson R44 · Foleyet, CanadaOn September 9, 2015, about 0015 Universal Time Coordinated, a Robinson R-44, C-GZFX, owned and operated by Apex Helicopters Inc. was found in a heavily wooded area about 17 nautical miles south of Foleyet, Ontario. The pilot and one passenger were fatally…NTSB CEN15LA411Accident · No injuriesLimited investigationFinal reportBrown Mark Space Walker · Cahokia, ILThe pilot's failure to maintain a proper descent rate during the attempted landing and the flight instructor's delayed attempt to execute a go-around, which resulted in a hard landing, failure of the left main landing gear, and subsequent loss of directional…NTSB CEN15LA405Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Elmwood, NEThe pilot’s decision to take off with the airplane near its maximum gross weight from a runway that did not have sufficient length for the airplane to achieve a normal takeoff and positive climb rate after liftoff.NTSB CEN15CA410Accident · No injuriesData collectionFinal reportPiper PA-17 · Delphi, INThe pilot's attempt to start the engine by himself without properly securing the airplane.NTSB WPR15WA259Accident · 1 fatalForeign investigationCessna 172 · Ballarat, Australia, AustraliaOn September 8, 2015, at 1542 local time, a Cessna 172S, VH-ZEW, collided with terrain near Ballarat, Australia. The airplane was being operated under the pertinent civil regulations of the Government of Australia. The airplane was destroyed and the pilot,…NTSB DCA15FA185Accident · Serious injuriesField investigationFinal reportBoeing Boeing 777-236 · Las Vegas, NVThe failure of the left engine high-pressure compressor (HPC) stage 8-10 spool, which caused the main fuel supply line to become detached from the engine main fuel pump and release fuel, resulting in a fire on the left side of the airplane. The HPC stage 8-10…NTSB CEN15LA402Accident · Serious injuriesLimited investigationFinal reportViking Dragonfly · Freeport, ILThe airplane’s degraded climb performance due to its being over its maximum gross weight and a hole in the engine exhaust.NTSB WPR15FA258Accident · 2 fatalField investigationFinal reportSilvaire Luscombe 8A · Creswell, ORThe pilot's decision to return to the runway shortly after takeoff, and his failure to maintain adequate airspeed during the turn, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall and spin.NTSB GAA15CA263Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Doylestown, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane. Contributing to the accident was the pilot's fatigue during the flight.NTSB ERA15LA356Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Stratford, CTThe pilot's failure to maintain directional control while landing in a crosswind.NTSB ERA15LA345Accident · No injuriesLimited investigationFinal reportPiper PA 28R-201T · Atmore, ALA total loss of engine power due to oil starvation caused by insufficiently torqued cylinder through bolt nuts, which caused bearings to shift and led to the subsequent failure of the No. 3 connecting rod.NTSB ERA15LA344Accident · Serious injuriesLimited investigationFinal reportEasterwood Mark W RV 6A · Rome, GAThe pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15FA340Accident · 3 fatalField investigationFinal reportBeech A36 · Kernersville, NCThe pilot's loss of airplane control due to spatial disorientation, which resulted in an aerodynamic stall/spin. Contributing to the accident was deficient Federal Aviation Administration air traffic control training on recognition and handling of…NTSB ANC15CA072Accident · No injuriesData collectionFinal reportCessna 150D · Delta Junction, AKThe pilots decision to land on an unfamiliar, unimproved airstrip which resulted in a loss of control and runway excursion.NTSB GAA15CA259Accident · No injuriesData collectionFinal reportCessna T210L · Soda Springs, IDThe pilot's failure to extend the landing gear prior to landing, which resulted in substantial damage to the fuselage during landing.NTSB ERA15LA343Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC-6 · Louisburg, NCThe propeller’s movement to the beta position during landing for reasons that could not be determined during postaccident examination and testing, which resulted in an attempted go-around and subsequent loss of airplane control.NTSB ERA15LA342Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilot's improper preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA15LA339Accident · 1 fatalLimited investigationFinal reportEvolution Revo · Laconia, NHThe sport pilot’s improper decision to operate the weight-shift-control aircraft at low altitude and his subsequent failure to maintain control of the aircraft, which resulted in a subsequent collision with terrain.NTSB DCA15WA188Accident · 7 fatalForeign investigationBoeing 737 · Tambacounda, SenegalNTSB CEN15LA417Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Pekin, INThe pilot's loss of directional control during the landing roll due to contact with a corn crop that extended into the runway area. Contributing to the accident were the lack of accurate available information to the pilot regarding the runway condition, the…NTSB CEN15LA413Accident · Minor injuriesLimited investigationFinal reportVenus CP328 Super Emeraude · Port Wing, WIThe pilot’s undershooting the landing area and the subsequent impact with a hay bale. Also causal to the accident was the operation of the airplane in conditions conducive to carburetor icing, which reduced the engine power during the landing.NTSB CEN15LA404Accident · 1 fatalLimited investigationFinal reportCessna TR182 · Midland, TXThe partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB CEN15FA400Accident · 4 fatalField investigationFinal reportCessna 310H · Silverton, COThe noninstrument-rated pilot's improper judgment and his failure to maintain situational awareness, which resulted in the flight's encounter with instrument meteorological conditions and controlled flight into terrain during cruise flight.NTSB GAA15CA251Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402A · Fort Pierre, SDThe pilot's failure to maintain obstacle clearance, which resulted in the airplane striking guy-wires during aerial application operations.NTSB ERA15LA357Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Wilmington, NCThe pilot's improper loading of the airplane, which resulted in a sudden pitch up during the attempted takeoff, the pilot’s subsequent loss of directional control, and an aerodynamic stall.NTSB ERA15LA341Accident · Minor injuriesClass 2 · LimitedFinal reportPiper PA 28RT-201 · Russell Springs, KYMaintenance personnel’s inadequate fuel injection servo maintenance due to an out-of-date AD list, which resulted in the fuel injection servo plug backing out of the threaded plug hole on the regulator cover of the fuel injection servo and subsequent total…NTSB CEN15WA401Accident · 1 fatalForeign investigationCessna 150F · Brackley, United KingdomOn September 4, 2015, about 1110 coordinated universal time, a Cessna 150F airplane, G-ATKF, impacted terrain during takeoff at the Hinton in the Hedges Airfield, near Brackley, United Kingdom. The pilot was fatally injured and the airplane sustained…NTSB WPR15LA257Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Manra Island, KiribatiA The loss of helicopter control for reasons that could not be determined asbecause the helicopter sank in the oceanwater and was not recovered.