NTSB investigations, 2017
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 GAA17CA556Accident · No injuriesData collectionFinal reportCessna 172 · Gallatin, TNThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA17CA540Accident · No injuriesData collectionFinal reportCessna 172 · Lynchburg, VAThe pilot's unstabilized approach, which resulted in an aborted go-around, an aerodynamic stall, and a hard landing.NTSB ERA17LA347Accident · No injuriesLimited investigationFinal reportBeech 35 · Marathon, FLA total loss of engine power for reasons that could not be determined because saltwater corrosion precluded a complete examination.NTSB ERA17LA328Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Hanover Township, PAThe pilot's failure to maintain roll control while maneuvering, which resulted in a collision with trees and terrain.NTSB ERA17FA327Accident · 2 fatalField investigationFinal reportMooney M20C · North Branford, CTA total loss of engine power due to fuel starvation as the result of foreign object debris in the fuel selector valve. Contributing to the accident was the pilot's selection of a low cruising altitude, which reduced the available time to troubleshoot the loss…NTSB CEN17LA365Accident · No injuriesLimited investigationFinal reportGaddis Michael Exec 162 F · Plymouth, INA failure of the drive belt for reasons that could not be determined based on the available information.NTSB CEN17FA355Accident · 1 fatalField investigationFinal reportBell 206L 3 · Ancho, NMThe pilot's distraction by a cell phone during a low-altitude flight, which resulted in controlled flight into terrain.NTSB CEN17FA354Accident · 4 fatalField investigationFinal reportCirrus Design SR22 · Glenwood Springs, COThe non-instrument-rated pilot's inadequate preflight weather planning, his decision to depart into forecast instrument meteorological conditions along the route of flight, and his continued visual flight into instrument meteorological conditions, which…NTSB WPR17LA204Accident · No injuriesClass 3 · LimitedFinal reportCessna T210N · Watsonville, CAThe pilot’s improper landing flare, which resulted in a bounced landing and subsequent nose gear separation.NTSB ERA17WA345Accident · 1 fatalForeign investigationCessna U206F · Caracarai, BrazilOn September 15, 2017, about 1300 coordinated universal time, a Cessna U206F, Brazilian registration PT-JPW, was substantially damaged after ditching in the Rio Branco river, near Caracaraí, Brazil. The pilot was fatally injured. The flight was conducted…NTSB ERA17LA338Accident · No injuriesLimited investigationFinal reportParks Richard A Starduster SA 100 · Southfields, NYA loose oil line that allowed oil to drip on the exhaust system, which resulted in smoke during cruise flight and a subsequent precautionary landing.NTSB ERA17LA337Accident · No injuriesClass 3 · LimitedFinal reportAirmax Construcoes Aeronautica SEAMAX-M22 · New Fairfield, CTCollision with a submerged object during a water landing.NTSB ERA17LA326Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502 · Union City, TNThe catastrophic failure of the compressor turbine blades, which resulted in a total loss of engine power. Contributing to the accident was the installation of undocumented, time-limited engine components of indeterminate age.NTSB DCA17WA209Accident · No injuriesForeign investigationAirbus A321 231 · Christ Church, BarbadosThe Barbados Civil Aviation Department has notified the NTSB of an accident involving a AIRBUS A321 231 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Barbados's investigation…NTSB DCA17WA200Incident · No injuriesForeign investigationBoeing Boeing 737-8AS · London, United KingdomThe AAIB of the United Kingdom has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the provisions of ICAO…NTSB CEN17LA357Accident · Minor injuriesLimited investigationFinal reportBeech A36 · McAlester, OKA total loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA17CA579Accident · No injuriesData collectionFinal reportBeech 95 B55 · Statesville, NCThe pilot’s failure to maintain pitch control of the airplane during landing, which resulted in a bounced landing.NTSB GAA17CA544Accident · No injuriesData collectionFinal reportPiper PA 11 · Petersville, AKThe pilot’s overapplication of brakes, which resulted in a nose-over.NTSB ERA17LA325Accident · No injuriesLimited investigationFinal reportBeech C23 · Machias, METhe pilot's delay in applying carburetor heat, which resulted in a total loss of engine power due to carburetor icing.NTSB ERA17LA329Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Nantucket, MAThe separation of the pushrod from the elevator trim tab actuator, which rendered controlled flight impossible. Contributing to the separation of the pushrod was the failure of maintenance personnel to properly secure it to the elevator trim tab actuator.NTSB DCA17WA199Incident · No injuriesForeign investigationBoeing 737 · Caracas, VenezuelaThe DGAC of Venezuela has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on September 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB DCA17WA198Accident · Serious injuriesForeign investigationBoeing 737 · Adelaide, AustraliaThe ATSB of Australia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on September 13, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's investigation under the provisions…NTSB DCA17CA197Accident · Serious injuriesData collectionFinal reportBombardier CL 600 2B19 · Charlotte, NCthe tug operator's initiation of a right turn onto the perpendicular terminal road in proximity to the airplane.NTSB CEN17LA367Accident · Serious injuriesLimited investigationFinal reportMiller Steven M RV6 A · Elbert, COThe pilot’s improper landing flare in strong gusting wind conditions, which resulted in a bounced landing, and his loss of directional control during an attempted go-around, which resulted in a runway excursion and impact with objects.NTSB CEN17LA352Accident · No injuriesLimited investigationFinal reportCessna 210G · Hallsville, MOThe total loss of engine power due to a fatigue failure of the engine mixture control cable.NTSB CEN17LA350Accident · No injuriesLimited investigationFinal reportEmbraer EMB 120ER · Greeley, COThe bus driver's failure to maintain clearance from the standing airplane during dark night conditions. Contributing to the accident was the airport's lack of an escort for the bus.NTSB WPR17LA202Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Ogden, UTThe airplane's inability to maintain an initial takeoff climb for reasons that could not be determined based on available information.NTSB GAA17CA533Accident · No injuriesData collectionFinal reportCessna T182T · Silver Springs, NVThe flight instructor’s failure to maintain a proper descent rate during a simulated engine failure, which resulted in a bounced landing.NTSB GAA17CA532Accident · No injuriesData collectionFinal reportCessna 177 · Harrisonville, MOA collision with a deer on the runway during the takeoff roll.NTSB GAA17CA531Accident · No injuriesData collectionFinal reportCessna 210 · Kinsley, KSThe pilot's decision to continue an unstabilized approach for landing in tailwind conditions, which resulted in a runway overrun and a nose-over.NTSB DCA17CA195Accident · No injuriesData collectionFinal reportBoeing 737-924ER · Los Angeles, CAthe B737 flight crew's misjudgment of the clearance between their wingtip and the B767 horizontal stabilizer.NTSB CEN17WA353Accident · 2 fatalForeign investigationMooney M 20K · Braunwald, SwitzerlandNTSB CEN17LA356Accident · No injuriesLimited investigationFinal reportCessna R182 · Worland, WYThe pilot's decision to operate an airplane with unreliable fuel gauges and the worn fuel cap seal that allowed fuel to siphon from the left wing fuel tank, which ultimately resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN17LA348Accident · No injuriesLimited investigationFinal reportBeech N35 · South Bend, INThe improperly seated fuel cap, which resulted in an in-flight fuel leak and subsequent total loss of engine power due to fuel starvation.NTSB GAA17CA538Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Santa Ynez, CAThe pilot’s improper landing flare in gusting wind conditions, which resulted in a hard, bounced landing.NTSB GAA17CA530Accident · Minor injuriesData collectionFinal reportCessna 172 · Plainville, CTThe pilot’s failure to properly execute the go-around, which resulted in the airplane failing to maintain a climb, which resulted in collision with a tree.NTSB ERA17WA323Accident · 1 fatalForeign investigationBritten Norman BN2A · San Salvador de Paul, VenezuelaOn September 11, 2017 about 1400 coordinated universal time, a Britten Norman BN2-A, Venezuelan registration YV1441, was landing at San Salvador de Paul, Ciudad Bolivar, Venezuela, when it struck and fatally injured a child who was on the runway. The pilot…NTSB DCA17WA229Incident · No injuriesForeign investigationBoeing 737 · Conakry, GuineaThe government of Guinea has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 11, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guinea's investigation under the provisions…NTSB CEN17WA343Accident · 2 fatalForeign investigationPiper Piper PA-28RT-201 · Wolferton, United KingdomOn September 11, 2017, at 0956 universal coordinated time (UTC), a Piper PA-28RT-201 single-engine airplane, United Kingdom registration G-BHAY, serial number 28R-7918213, was substantially damaged during a forced landing following a loss of engine power and…NTSB CEN17LA375Accident · No injuriesLimited investigationFinal reportHiller UH 12A · Griffith, INThe loss of tail rotor thrust due to a failed tail rotor driveshaft, which resulted in a loss of tail rotor control and a hard landing.NTSB GAA17CA526Accident · Serious injuriesData collectionFinal reportCessna 172 · Coolin, IDThe pilot's decision to take off in high-density altitude and gusting quartering tailwind conditions, which resulted in a loss of lift and an inability to gain altitude during the initial climb.NTSB CEN17WA381Incident · No injuriesForeign investigationGulfstream GV · Le Bourget, FranceOn September 10, 2017, a Gulfstream GV SP 550 airplane, Monaco registration M-SAWO, experienced abnormal runway contact during landing at Le Bourget Airport, Le Bourget, France. A wingtip sustained minor damage during the landing, and the two pilots and four…NTSB CEN17FA342Accident · 2 fatalField investigationFinal reportRans S-6 · Stonewall, TXThe pilot's failure to maintain terrain clearance while conducting aerobatic flight maneuvers with insufficient altitude to recover.NTSB WPR17FA200Accident · 2 fatalField investigationFinal reportRaytheon G36 · Benicia, CAThe pilot's failure to maintain adequate airspeed which caused the airplane to exceed its critical angle of attack and led to an aerodynamic stall.NTSB GAA17CA535Accident · No injuriesData collectionFinal reportMooney M20J · Whitesburg, GAThe pilot’s unstabilized approach while landing with a tailwind and his subsequent failure to go around, which resulted in a hard landing.NTSB GAA17CA528Accident · No injuriesData collectionFinal reportCessna 152 · Broomfield, COThe student pilot’s failure to maintain directional control while landing in gusting crosswind conditions.NTSB ERA17WA321Accident · 1 fatalForeign investigationPiper Piper PA-34-200T · Cerrione, ItalyNTSB CEN17LA351Accident · No injuriesLimited investigationFinal reportCessna 340 · McKinney, TXThe failure of the bell crank pivot bolt which resulted in the left main landing gear collapse. Contributing to the accident was the lack of landing gear inspections in accordance with the airplane manufacturer's maintenance manuals.NTSB CEN17LA344Accident · No injuriesLimited investigationFinal reportAviat A 1B · Prairie du Chien, WIThe fatigue failure of the aileron hinge bracket tubing for reasons that could not be determined based on the available evidence.NTSB CEN17CA345Accident · No injuriesData collectionFinal reportShiner RV-4 · Ramah, NMThe pilot’s failure to maintain clearance from berms during landing in sun glare conditions.