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 CEN17LA284Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Reyno, ARThe pilot’s inadvertent use of the propeller control, which caused the propeller to feather while in flight with the engine still operating, resulting in a loss of thrust and a subsequent forced landing.NTSB CEN17LA275Accident · Minor injuriesLimited investigationFinal reportGolden Circle Air T-BIRD II · Dunn Center, NDThe pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.NTSB CEN17LA272Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Pierce, NEThe pilot’s failure to maintain clearance from trees during a low-level agricultural aerial application flight.NTSB WPR17FA155Accident · 2 fatalField investigationFinal reportEvolution 19 Lancair Evolution · Mesa, AZThe pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent stall/spin. Contributing to the accident was the pilot's distraction due to a failure…NTSB GAA17CA415Accident · No injuriesData collectionFinal reportCessna 195 · Leavenworth, KSThe pilot’s inadvertent toe brake application during the landing roll, which resulted in a runway excursion and a ground loop.NTSB ERA17LA247Accident · No injuriesLimited investigationFinal reportAeroprakt A 20 Vista Cruiser · Shirley, NYThe pilot's inadvertent activation of the engine's choke control during a downdraft encounter, which resulted in a total loss of engine power.NTSB GAA17CA446Accident · No injuriesData collectionFinal reportPiper PA46 · Franklin, VAA collision with a deer during the landing roll, which resulted in a runway excursion.NTSB GAA17CA417Accident · No injuriesData collectionFinal reportPerner/Pitts S1S · Brenham, TXThe pilot's failure to maintain lateral/bank and yaw control during a go-around.NTSB GAA17CA414Accident · No injuriesData collectionFinal reportCessna TU206 · Albuquerque, NMThe pilot’s improper landing flare in gusting wind conditions, which resulted in a porpoised landing.NTSB GAA17CA411Accident · No injuriesData collectionFinal reportSpani Wayne M Starduster TOO SA300 · San Diego, CAThe other pilot's failure to maintain separation from a stationary airplane during the taxi to the runway.NTSB ERA17WA271Accident · Serious injuriesForeign investigationCessna 172 · Khuzhir, RussiaOn July 16, 2017, at 1300 coordinated universal time, a Cessna 172M, Russian registration RA-2842G, ditched into Lake Baikal, near Khuzhir, Irkutskaya Oblast, Russia, after a total loss of engine power. The airplane incurred substantial damage during the…NTSB ERA17LA252Accident · No injuriesLimited investigationFinal reportCessna R172 · Naples, METhe pilot's failure to maintain airplane control during landing.NTSB CEN17FA270Accident · 2 fatalField investigationFinal reportNorth American/Aero Classics P 51 · Cummings, KSThe loss of airplane control while maneuvering at low altitude for reasons that could not be determined.NTSB ANC17LA037Accident · No injuriesClass 3 · LimitedFinal reportCessna A185 · Wasilla, AKThe pilot’s failure to manage fuel quantity in flight, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to follow manufacturer guidance for restoring engine power after emptying a fuel…NTSB WPR17LA157Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe failure of the No. 4 cylinder exhaust valve head, which resulted in a total loss of engine power due to oil starvation.NTSB WPR17LA156Accident · No injuriesClass 3 · LimitedFinal reportSimmons Gary F Stol CH 701 · Kenwood, CAFailure of the flywheel drive assembly, which resulted in a loss of engine power and subsequent forced landing to uneven terrain.NTSB GAA17CA422Accident · No injuriesData collectionFinal reportPiper PA32 · Marion, IAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA412Accident · No injuriesData collectionFinal reportMooney M20C · Washington Island, WIThe pilot's failure to maintain a proper approach path, which resulted in impact with trees.NTSB ERA17LA246Accident · No injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe fatigue failure of an exhaust valve spring retainer due to air trapped in the lubrication system, which resulted in a total loss of engine power.NTSB ERA17LA243Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B 15 · Murfreesboro, TNThe passenger's failure to let go of the balloon's gondola when the balloon began to ascend. Contributing to the accident was the pilot's failure to maintain control of the balloon after landing, which resulted in an inadvertent takeoff.NTSB DCA17WA166Incident · No injuriesForeign investigationBoeing 747-87UF · Narita, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 747-87UF airplane that occurred on July 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…NTSB CEN17WA276Accident · 2 fatalForeign investigationCessna T210 · Cerro Viejo, MexicoOn July 15, 2017, at 1616 coordinated universal time, a Cessna T210N, Mexican registration XB-LJK, collided with the terrain in Cerro Viejo, Mexico, following a loss of engine power. The pilot and passenger were fatally injured. The airplane was substantially…NTSB CEN17LA274Accident · No injuriesLimited investigationFinal reportEndler Glasair/Glasair 1-Td SH2 · Colorado Springs, COThe pilot's failure to lock the castering tailwheel in accordance with the airplane Owner's Manual and a checklist item and to abort the takeoff after the airplane exceeded its normal takeoff distance and/or reached the limit of the rudder control authority…NTSB ANC17FA035Accident · 1 fatalField investigationFinal reportAeronca 15AC · Big Lake, AKThe pilot's failure to maintain clearance from trees during low-altitude flight, which resulted in an in-flight collision and impact with terrain.NTSB WPR17LA154Accident · No injuriesClass 3 · LimitedFinal reportBeech D55 · Hailey, IDThe pilot’s loss of directional control during landing.NTSB WPR17LA153Accident · Minor injuriesClass 3 · LimitedFinal reportClark James T Vans RV8 · Spokane, WAAn inflight engine fire for reasons that could not be determined based on the available information, which melted the air filter element and obstructed the engine's air intakes, resulting in a total loss of engine power.NTSB WPR17FA152Accident · 1 fatalField investigationFinal reportJansen Pazmany PL 2 · El Monte, CAA total loss of engine power due to fuel starvation for reasons that could not be determined based on the available evidence. Also causal was the pilot's decision to return to the runway following the loss of engine power, and his failure to maintain airspeed…NTSB WPR17FA151Accident · 2 fatalField investigationFinal reportPiper PA 44-180 · Marineland, FLA loss of control in flight for reasons that could not be determined based on the available information, which resulted in an in-flight breakup.NTSB GAA17CA419Accident · No injuriesData collectionFinal reportPiper PA28 · Fort Worth, TXThe student pilot’s improper landing flare, which resulted in a bounced landing and a propeller strike.NTSB ERA17LA242Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Key Biscayne, FLThe nearly complete blockage of the right fuel tank strainer with organic material, which resulted in fuel starvation and the subsequent total loss of engine power. Contributing to the fuel starvation was the pilot receiving instruction’s and the flight…NTSB ERA17CA244Accident · No injuriesData collectionFinal reportMooney M20R · Venice, FLThe pilot’s failure to maintain directional control during landing in a gusting crosswind conditions.NTSB WPR17FA150Accident · 2 fatalField investigationFinal reportCirrus Design SR22T · Schellville, CAThe pilot's failure to maintain adequate airspeed after a loss of engine power, which resulted in an aerodynamic stall at a low altitude from which the pilot was unable to recover. The loss of engine power resulted from the pilot's improper selection for the…NTSB WPR17FA149Accident · 2 fatalField investigationFinal reportAviat A · Herriman, UTThe flight instructor's decision to conduct a low-altitude flight into a box canyon in high density altitude conditions and his failure to maintain airspeed while maneuvering to escape the canyon, which resulted in an exceedance of the airplane's critical…NTSB GAA17CA409Accident · No injuriesData collectionFinal reportProgressive Aerodyne Searey LSA · Spicewood, TXThe pilot’s failure to retract the landing gear before landing on water.NTSB GAA17CA408Accident · No injuriesData collectionFinal reportPiper PA 18 · Denali, AKThe pilot’s failure to maintain directional control while landing on a narrow, unimproved airstrip in gusting wind conditions.NTSB ERA17FA241Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau EA 300/L · Winchester, NHThe noninstrument-rated pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to complete…NTSB CEN17FA266Accident · 2 fatalField investigationFinal reportPiper PA31T · Tyler, TXThe loss of engine power and the subsequent pilot's loss of control for reasons that could not be determined because post-accident engine examination revealed no anomalies.NTSB GAA17CA407Accident · No injuriesData collectionFinal reportGerald Donovan Rans S-16 · Los Lunas, NMThe pilot's failure to maintain directional control during takeoff.NTSB ERA17LA266Accident · No injuriesLimited investigationFinal reportPiper PA28R · Pembroke Pines, FLThe loss of engine power for reasons that could not be determined postaccident engine test-runs revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR17LA162Accident · No injuriesLimited investigationFinal reportCessna A185E · Nampa, IDThe pilot’s failure to maintain directional control of the tailwheel airplane during the landing roll.NTSB GAA17CA426Accident · No injuriesData collectionFinal reportCessna 170 · Friday Harbor, WAThe pilot’s loss of directional control during landing.NTSB GAA17CA404Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · King Vale, CAThe pilot’s failure to maintain clearance from trees while landing in a dusty, unimproved landing zone.NTSB ERA17LA239Accident · No injuriesClass 3 · LimitedFinal reportCessna 210L · Wilkes-Barre/Scranton, PAFailure of the left landing gear door actuator, which resulted in a loss of all hydraulic pressure and subsequent gear collapse on landing.NTSB DCA17WA149Incident · No injuriesForeign investigationBoeing 737 · Helsinki, FinlandThe government of Finland has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on July 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Finland's investigation under the provisions of…NTSB WPR17LA148Accident · No injuriesLimited investigationFinal reportCharles J Norris Arion Lightning · New River, AZA partial loss of engine power for reasons that could not be determined due to a lack of available evidence.NTSB GAA17CA406Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 · Wilkes-Barre, PAThe flight instructor's delayed remedial action to maintain helicopter altitude during hover flight instruction, which resulted in the helicopter skid contacting a crack in the runway and a dynamic rollover.NTSB WPR17LA147Accident · No injuriesLimited investigationFinal reportCessna 180 · Baker City, ORThe loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel planning.NTSB GAA17CA448Accident · No injuriesData collectionFinal reportCessna 172 · Manassas, VAThe student pilot’s improper landing flare, which resulted in a porpoised landing.NTSB CEN17LA265Accident · Minor injuriesLimited investigationFinal reportCubcrafters CC11-160 · Milesville, SDFuel starvation and a subsequent loss of engine power for reasons that could not be determined because a postaccident examination and a test run of the engine did not reveal any anomalies. Contributing to the accident was the pilot’s failure to maintain…NTSB CEN17LA263Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Corydon, IAA total loss of engine power for reasons that could not be determined because postaccident examination of the engine and airframe did not reveal any anomalies that would have precluded normal operation.