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 DCA18WA047Incident · No injuriesForeign investigationBoeing 737 · Jauja, PeruThe Peruvian Board of Aviation Accidents Investigation (CIAA) has notified the NTSB of an incident involving a Boeing 737, which occurred on November 20, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex…NTSB CEN18LA034Accident · No injuriesLimited investigationFinal reportErcoupe 415 CD · Aurora, COThe failure of the engine-driven fuel pump and the pilot's failure to identify the pump's failure, which resulted in a loss of engine power due to fuel starvation and a forced landing on a road, during which the airplane hit obstacles.NTSB CEN18FA035Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Electra, TXThe pilot's failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB CEN18FA033Accident · 3 fatalField investigationFinal reportBell Helicopter Textron Canada 407 · Stuttgart, ARAn in-flight loss of control due to bird strikes.NTSB WPR18LA034Accident · Serious injuriesClass 2 · LimitedFinal reportCessna 172P · San Jose, CAThe pilot's delayed decision to execute an emergency landing and his attempt to return to the airport following a partial loss of power due to wear on internal engine components, which prevented the engine from developing full-rated power during the…NTSB GAA18CA054Accident · Minor injuriesData collectionFinal reportQuicksilver MXL Sport · Point Mugu, CAThe pilot’s failure to see and avoid power wires.NTSB GAA18CA050Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Rosamond, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA049Accident · Minor injuriesData collectionFinal reportJohn Roscoe Autogyro Cavalon · Casa Grande, AZThe pilot’s improper landing flare, which resulted in loss of directional control and a subsequent runway excursion.NTSB GAA18CA048Accident · Minor injuriesData collectionFinal reportCessna 172M · Chico, CAAn in-flight collision with a bird.NTSB DCA18WA023Incident · No injuriesForeign investigationBoeing 737 · Guayaquil, EcuadorThe government of Ecuador has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on November 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ecuador's investigation under the provisions…NTSB DCA18CA074Accident · Serious injuriesData collectionFinal reportBoeing 737 7H4 · Los Angeles, CAThe provisioning agent's lack of situational awareness while stepping from the airplane to the provisioning van. Contributing to the accident was the provisioning vans failed switch.NTSB ANC18LA010Accident · No injuriesLimited investigationFinal reportRockwell International 112A · Clearwater, FLA total loss of engine power for reasons that could not be determined based on the available information.NTSB WPR18WA038Accident · No injuriesForeign investigationBell Helicopter 206B · Emerald Aerodrome, AustraliaOn November 18, 2017, about 1430 local time, a Bell 206B helicopter, registration VH-SDZ, rolled over following a precautionary landing near Emerald Aerodrome, Middlemount, Queensland, Australia. The helicopter, which was equipped with a Rolls-Royce 250…NTSB ERA18LA026Accident · No injuriesLimited investigationFinal reportPiper PA28 · Bladenboro, NCA loss of engine power due to carburetor icing and the presence of an insect nest in the carburetor heat control box that prevented the pilot’s application of carburetor heat from restoring engine power.NTSB WPR18LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28R-201T · Nipton, CAA loss of engine power due to the detonation of the No. 5 cylinder due to excessive leaning at high power settings, which resulted in a forced landing and the subsequent hard touchdown.NTSB ERA18LA038Accident · No injuriesClass 3 · LimitedFinal reportBeech B 55 · Statesville, NCA total loss of left engine power during initial climb. Contributing to the accident was the pilot's failure to maintain control of the airplane following the loss of engine power.NTSB ERA18LA027Accident · No injuriesClass 3 · LimitedFinal reportHomer Autogyro Cavalon · Oak Island, NCA partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA18CA064Accident · No injuriesData collectionFinal reportCessna 172 · Pompano, FLThe pilot’s improper landing flare, which resulted in a porpoise.NTSB GAA18CA053Accident · No injuriesData collectionFinal reportPiper PA 28R · Melborne, FLThe pilot’s loss of directional control during the landing roll on the wet runway.NTSB DCA18WA025Incident · No injuriesForeign investigationBoeing 737 · Singapore, SingaporeThe TSIB of Singapore has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on November 16, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the TSIB's investigation under the provisions of ICAO Annex 13 as…NTSB ANC18LA009Accident · No injuriesLimited investigationFinal reportCessna 172RG · Opa Locka, FLA failure of the airplane 's electrical system, which led to the failure of the landing gear system, for reasons that could not be determined because postaccident examination and testing revealed no mechanical anomalies that would have precluded normal…NTSB ERA18WA028Accident · 11 fatalForeign investigationCessna 208 · Ngorongoro, TanzaniaOn November 15, 2017, about 0805 coordinated universal time, Cessna 208B, Tanzanian registration 5H-EGG, operated by Coastal Aviation LTD., was substantially damaged when it impacted terrain near Ngorongoro, Tanzania. The pilot and 10 passengers were fatally…NTSB CEN18LA032Accident · Serious injuriesLimited investigationFinal reportCessna T207A · Rock Springs, WYThe pilot's improper in-flight fuel management and reliance on a faulty fuel gauge, which resulted in fuel starvation during approach for landing, and his failure to follow the emergency checklist after losing engine power.NTSB GAA18CA046Accident · No injuriesData collectionFinal reportTextron 172 · Columbus, OHThe student pilot’s improper landing flare, which resulted in a porpoise.NTSB ERA18WA160Accident · 1 fatalForeign investigationPiper PA-25-235 · Itapolis, BrazilThe government of Brazil has notified the NTSB of an accident involving a PIPER AIRCRAFT PA-25-235 airplane that occurred on November 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…NTSB DCA18WA020Incident · No injuriesForeign investigationBoeing 777 · Oceanic, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 777 airplane that occurred on November 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB-UK's investigation under the provisions of ICAO…NTSB WPR18LA030Accident · No injuriesLimited investigationFinal reportVanderark RV-10 · Sun Lakes, AZThe fatigue fractures of the upper and lower alternator attachment bolts, which decreased the common drive belt tension and resulted in the subsequent in-flight separation of an alternator drive belt, the overheating of the engine, and the subsequent total…NTSB GAA18CA051Accident · No injuriesData collectionFinal reportCessna 182H · Tucson, AZThe pilot’s failure to use taxiways shown on the airport diagrams and his subsequent failure to avoid a ditch.NTSB ERA18FA022Accident · 4 fatalField investigationFinal reportPiper PA32 · Fountain Run, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing to the accident was the pilot's self-induced pressure to complete…NTSB CEN18LA031Accident · No injuriesLimited investigationFinal reportCessna T210N · Grayslake, ILThe failure of the No. 4 connecting rod due to inadequate oil lubrication for reasons that could not be determined because the postaccident engine examination did not reveal any anomalies that would have caused a lack of lubrication.NTSB WPR18LA031Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 · Page, AZThe pilot's failure to maintain pitch control of the helicopter while transitioning from a hover to forward flight.NTSB GAA18CA042Accident · No injuriesData collectionFinal reportStinson SR 5E · Burlington, WAThe pilot’s unstabilized approach, which resulted in a hard, bounced landing and nose-over. Also causal to the accident was the pilot’s improper decision to land on a closed alternate grass landing area.NTSB DCA18WA030Incident · No injuriesForeign investigationBoeing 747 · Maastricht, NetherlandsThe Dutch Safety Board has notified the NTSB of an incident involving a Boeing 747, which occurred on November 11, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State of Manufacture and…NTSB ANC18LA008Accident · No injuriesLimited investigationFinal reportCloud Jeffrey Ferrell Long EZ · Eufaula, ALThe in-flight separation of a portion of the propeller, which subsequently penetrated the right rudder, as a result of the failure of the bond line between two of the propeller’s wood layers. Contributing to the failure of the propeller was the manufacturer’s…NTSB GAA18CA039Accident · No injuriesData collectionFinal reportCessna 180 · Panama City, FLThe pilot's failure to maintain lateral/bank control during landing in gusting crosswind conditions.NTSB ERA18WA025Accident · Serious injuriesForeign investigationQuest Kodiac 100 · Goias, BrazilThe government of Brazil has notified the NTSB of an accident involving a QUEST AIRCRAFT COMPANY LLC KODIAC 100 airplane that occurred on November 10, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's…NTSB ERA18LA021Accident · No injuriesClass 2 · LimitedFinal reportSocata TB200 · Annapolis, MDA loss of engine power for undetermined reasons after the disconnection of the propeller governor control due to inadequate securenment during maintenance.NTSB CEN18FA030Accident · 1 fatalField investigationFinal reportTemco GC 1B · Pineville, LAThe loss of engine power due to fuel starvation, which resulted from the unporting of the fuel during a right turn due to the auxiliary fuel tanks' improper configuration.NTSB GAA18CA045Accident · No injuriesData collectionFinal reportCessna 172 · Trenton, NJThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA18CA047Accident · No injuriesData collectionFinal reportCessna 140 · Macon, GAThe pilot's incorrect pitch control during takeoff, which resulted in a nose-over.NTSB ERA18LA020Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Union City, TNThe pilot’s inadvertent slope landing and attempted recovery, which resulted in an incipient dynamic rollover, mast bumping, and separation of the main rotor.NTSB ERA18FA016Accident · 2 fatalField investigationFinal reportPiper PA 32 · Morrison, TNThe pilots' loss of control during a missed approach in night instrument meteorological conditions as a result of spatial disorientation.NTSB ENG18RA004Incident · No injuriesForeign investigationBritish Aerospace Avro 146 · Johannesburg, South AfricaOn November 8, 2017, at about 1750 UTC, South African Airlink flight 8103, a British Aerospace BAE-146 RJ85A, registered in South Africa as ZS-ASW, experienced an uncontained release of turbine material from the No. 2 engine, a Honeywell LF507-1F turbofan,…NTSB CEN18LA044Accident · No injuriesLimited investigationFinal reportCessna 170B · Harvard, ILThe failure of the universal joint in the pilot-side flight control yoke due to the fatigue fracture of a rivet within the universal joint. Contributing to the universal joint failure was the universal joint design, which was prone to galling wear and seizure.NTSB CEN18LA036Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Carroll, OHThe total loss of engine power due to carburetor icing.NTSB WPR18LA029Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Rolling Fork, MSAn uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.NTSB GAA18CA044Accident · No injuriesData collectionFinal reportCessna 172 · Bonners Ferry, IDThe pilot’s failure to see and avoid power lines while maneuvering at a low altitude.NTSB GAA17CA580Accident · No injuriesData collectionFinal reportMooney M20K · Los Lunas, NMThe pilot’s improper glidepath during a night approach, which resulted in impact with terrain short of the runway.NTSB ENG18IA003Incident · No injuriesClass 3 · IncidentFinal reportAirbus A330-243 · Seattle, WAThe loss of control of the left-hand engine and the subsequent thermal damage to the left wing on landing during engine reverse operation was due to a blockage of the variable stator vane torque motor filter that resulted in the engine’s electronic engine…NTSB CEN18LA026Accident · 2 fatalLimited investigationFinal reportHughes 369D · Sulphur, LAThe pilot's failure to maintain adequate separation between a long line being used to hoist linemen from a shield wire during an external load flight, which resulted in the long line being severed.