NTSB investigations, 2017
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 WHERE year(c.\"eventDate\") = 2017 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 WHERE year(c."eventDate") = 2017 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 WPR18FA013Accident · 2 fatalField investigationFinal reportFlugzeugproduktions-und Vertri EA 300/L · Four Corners, CACollision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…NTSB GAA18CA027Accident · No injuriesData collectionFinal reportCessna 120 · New Bern, NCThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB GAA18CA025Accident · No injuriesData collectionFinal reportChampion 7GC · Gerlach, NVThe pilot's incorrect pitch control during the landing roll in shifting wind conditions, which resulted in a nose-over.NTSB ANC18LA005Accident · No injuriesLimited investigationFinal reportRaytheon B200 · Anchorage, AKThe pilot's failure to extend the landing gear before landing, which resulted in a gear-up landing. Contributing to the accident was the pilot's fatigue and complacency.NTSB GAA18CA017Accident · Serious injuriesData collectionFinal reportYoung David E Pitts S1 C · Farmville, VAThe pilot’s failure to see and avoid the other airplane landing in the opposite direction on the runway. Contributing to the accident was the pilot’s failure to use the correct runway call sign in his radio communications.NTSB WPR18FA011Accident · 1 fatalField investigationFinal reportPeterson Lancair Legacy · Bowie, AZAn in-flight loss of control due to a bird strike.NTSB ERA18WA052Accident · Serious injuriesForeign investigationBeech B200 · Pucallpa, PeruThe government of Peru has notified the NTSB of an accident involving a Beech B200C airplane that occurred on October 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of…NTSB CEN18LA017Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Port Mansfield, TXThe pilot’s improper landing flare, which led to a hard landing and the subsequent collapse of the nosewheel landing gear due to the overstress failure of the nosewheel landing gear trunnion casting.NTSB GAA18CA015Accident · Minor injuriesData collectionFinal reportThomas G Parkhurst Kitfox IV · Sidney, NYThe pilot's exceedance of the airplane’s critical angle of attack following a loss of ground reference during landing in glaring sun conditions, which resulted in an aerodynamic stall/spin.NTSB ERA18LA011Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 402 · St. Petersburg, FLThe pilot's mismanagement of the onboard fuel, which resulted in fuel starvation, a total loss of power to both engines, and a subsequent forced landing.NTSB ERA18LA010Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A24 · Manteo, NCThe failure of maintenance personnel to properly secure wiring during an electrical component installation, which resulted in arcing and smoke in the cockpit. Contributing to the outcome was the flight instructor's failure to attain a proper descent rate…NTSB CEN18LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Willmar, MNThe pilot’s improper conduct of the soft-field takeoff, which led to his failure to attain adequate airspeed, and the flight instructor’s subsequent improper landing flare, which resulted in a hard, forced landing.NTSB WPR18LA010Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R44 · Molokai, HIA descent and subsequent impact with open ocean waters for reasons that could not be determined based on the available information.NTSB GAA18CA024Accident · No injuriesData collectionFinal reportCessna 172 · Old Bridge, NJThe student pilot’s failure to maintain directional control during the landing roll.NTSB ERA18WA013Accident · 1 fatalForeign investigationCessna 208 · Novo Airao, BrazilOn October 17, 2017, about 1540 universal coordinated time, an amphibious Cessna 208, Brazilian registration PR-MPE, was substantially damaged after it came to rest inverted while attempting to land on a river in Novo Airao county, State of Amazonas, Brazil.…NTSB CEN18LA014Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Gustavus, OHThe pilot’s geographic disorientation while maneuvering in the airport traffic pattern in dark night conditions, which resulted in the airplane descending below a normal approach path and a collision with trees. Contributing to the accident was the pilot's…NTSB ENG18WA038Incident · No injuriesForeign investigationEmbraer ERJ190 · Dublin, IrelandThe Air Accident Investigation Unit (AAIU) of Ireland has notified the NTSB of an incident involving an Embraer 190-200 LR, which occurred on October 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU investigation under the…NTSB CEN18WA016Accident · 1 fatalForeign investigationAvid Mark IV · Jüterborg, GermanyOn October 16, 2017, about 1123 UTC, an amateur-built Avid Mark IV airplane, French registration F-JAGB, owned and operated by a private individual, crashed during a test flight near Jüterborg, Germany. The pilot on board was fatally injured and the airplane…NTSB ANC18FA003Accident · 1 fatalField investigationFinal reportCessna 210 · Russian Mission, AKThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of control.NTSB WPR18LA009Accident · No injuriesLimited investigationFinal reportBarber Warren D Turbine Cubs P A 18 · Skull Valley, UTThe activation of the wheel brakes during landing, which resulted in a nose-over. The reason for the wheel brake activation could not be determined.NTSB GAA18CA013Accident · No injuriesData collectionFinal reportCessna 172RG · Auburn, WAThe failure of the right main landing gear for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB DCA18CA007Accident · Serious injuriesData collectionFinal reportBoeing 767 328 · Honolulu, HIan inadvertent encounter of clear air turbulence.NTSB ANC18LA004Accident · No injuriesLimited investigationFinal reportCirrus Design SR22T · Tuskegee, ALAn improperly adjusted slope controller and fuel pump that resulted in an excessively high fuel flow, an extremely rich mixture, a rough-running engine, and a subsequent partial loss of engine power.NTSB WPR18WA025Accident · 1 fatalForeign investigationQuicksilver GT500 · Melaka, MalaysiaOn October 14, 2017, about 1130 local time, a Quicksilver Aircraft GT-500, registration 9M-EAC, was destroyed after colliding with a river shortly after takeoff from Sungai Rambai Aerodrome, Melaka, Malaysia. The airplane was operated under the pertinent…NTSB GAA18CA014Accident · No injuriesData collectionFinal reportHimsl Vincent S Vans RV-8 · Othello, WAThe pilot's failure to maintain directional control during the takeoff roll in crosswind conditions.NTSB DCA18WA015Incident · No injuriesForeign investigationBoeing 777 · Adelaide, AustraliaThe government of Australia has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on October 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the…NTSB WPR18LA004Accident · No injuriesClass 3 · LimitedFinal reportWestern International Avia UH 1H · Arbuckle, CAA collective control malfunction for reasons that could not be determined.NTSB GAA18LA062Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Mesa, AZA coyote strike and the subsequent operation of the airplane, which led to internal composite wing structure damage.NTSB GAA18CA012Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB BK 117 · Canton, ILThe flight instructor's incorrect cyclic control during a hover, which resulted in a hard landing.NTSB DCA18WA016Incident · No injuriesForeign investigationBoeing 737 · Moscow, RussiaThe Federal Air Transport Agency (FATA) of Russia has notified the NTSB of an incident involving a Boeing 737, which occurred on October 13, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the…NTSB CEN18FA011Accident · 2 fatalField investigationFinal reportCessna 172M · Ramsey, MNThe pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…NTSB CEN18FA009Accident · 2 fatalField investigationFinal reportCessna 182H · Las Cruces, NMControlled flight into terrain in dark night conditions.NTSB GAA18CA011Accident · No injuriesData collectionFinal reportDehavilland DHC 1 · Cedartown, GAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN18LA013Accident · No injuriesLimited investigationFinal reportRussell E Oberg Murphy Rebel · Fort Collins, COA total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat.NTSB GAA18CA010Accident · No injuriesData collectionFinal reportAir Tractor AT 402B · Brawley, CAThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB ERA18WA015Accident · 1 fatalForeign investigationCessna U206 · Itaituba, BrazilOn October 11, 2017, about 1600 universal coordinated time, a Cessna U206G, Brazilian registration PT-LSC, was destroyed when it collided with a tree during takeoff near Itaituba, State of Para, Brazil. The pilot was fatally injured, and one passenger…NTSB ENG18RA009Accident · No injuriesForeign investigationDe Havilland DHC8 · Belfast, IrelandThe UK AAIB has notified the NTSB of an accident involving a Bombardier DHC-8-402, which occurred on October 11, 2017. The crew diverted to Belfast International Airport and landed with the nose landing gear retracted. The NTSB has appointed a U.S. Accredited…NTSB ANC18LA002Accident · No injuriesLimited investigationFinal reportFleetwood Jack Team Airbike · Ocean Springs, MSAn intermittent failure of the power take-off cylinder ignition coil, which resulted in a partial loss of engine power.NTSB WPR18LA006Accident · Serious injuriesClass 3 · LimitedFinal reportNanchang China CJ 6 · Buckeye, AZThe failure of the fuel pump’s diaphragm which resulted in fuel system contamination from air and or oil and caused the engine to lose power.NTSB ERA18WA014Accident · 3 fatalForeign investigationBeech E33A · São José do Rio Preto, BrazilOn September 10, 2017, about 1525 coordinated universal time, a Beechcraft E33-A, Brazilian registration PT-DDB, struck a residence while conducting a go around near São José do Rio Preto State Airport (SBSR), Brazil. The airplane was substantially damaged,…NTSB CEN18LA012Accident · 1 fatalLimited investigationFinal reportGlobe GC 1A · Los Lunas, NMThe loss of directional control during takeoff and impact with a steel culvert.NTSB GAA18CA008Accident · No injuriesData collectionFinal reportCessna 150 · Medina, OHThe student pilot’s improper landing flare, which resulted in a hard landing and porpoise.NTSB GAA18CA005Accident · No injuriesData collectionFinal reportCessna 172 · Black River Falls, WIThe pilot’s failure to maintain directional control during landing in gusting crosswind conditions.NTSB CEN18WA029Accident · Minor injuriesForeign investigationRobinson R44 · Namur, BelgiumNTSB CEN18WA007Accident · 1 fatalForeign investigationRobinson R44 · Gramzda, LatviaOn October 8, 2017, about 1014 Coordinated Universal Time (UTC), a Robinson R44 helicopter, YL-HBH, impacted a powerline after takeoff near Gramzda, Latvia. One passenger was fatally injured and the pilot and two other passengers on board were seriously…NTSB CEN18FA004Accident · 1 fatalField investigationFinal reportAero Vodochody L39C · Vernon, TXAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.NTSB WPR18LA003Accident · No injuriesClass 3 · LimitedFinal reportBorom Marcus P Long EZ · Tucson, AZThe failure of both pilots to see and avoid the other airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the controller's failure to provide adequate traffic information, issue necessary…NTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.NTSB GAA18CA006Accident · No injuriesData collectionFinal reportMaule M 7 · Manokatak, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.NTSB GAA18CA004Accident · Minor injuriesData collectionFinal reportMooney M20 · Topping, VAThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in a departure stall.