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 GAA18CA085Accident · No injuriesData collectionFinal reportCessna 172 · Park Rapids, MNThe student pilot’s improper landing flare, which resulted in the propeller striking the ground.NTSB GAA18CA069Accident · No injuriesData collectionFinal reportWeaver David A Pulsar 912XP · Plato Center, ILThe pilot’s decision to continue to land without visual reference to the airport in low light conditions. Contributing to the accident was the pilot’s inability to activate the private airport’s pilot-controlled lighting system due to its configuration.NTSB ERA18LA039Accident · 2 fatalLimited investigationFinal reportKevin Leue Sparrow Hawk · Hernando, MSImpact with trees and terrain for reasons that could not be determined based on available evidence.NTSB ANC18LA013Accident · No injuriesLimited investigationFinal reportCessna 172R · Huntingdon, TNA total loss of engine power for reasons that could not be determined because a postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA18CA067Accident · No injuriesData collectionFinal reportTodd Foley Zenith 701 · Mount Airy, NCThe pilot’s exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB ERA18LA040Accident · No injuriesLimited investigationFinal reportChampion 7EC · Ravenswood, WVThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.NTSB ANC18LA014Accident · No injuriesLimited investigationFinal reportCessna 172 · Miami, FLThe pilot's decision to continue the landing after a loss of visual cues during a night landing.NTSB WPR18LA041Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 · Truckee, CAThe flight instructor’s failure to execute a power recovery from a non-stabilized autorotative descent, which resulted in a hard landing.NTSB GAA18CA076Accident · No injuriesData collectionFinal reportCessna 152 · Fullerton, CAThe student pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.NTSB ERA18RA045Accident · 2 fatalForeign investigationPiper PA28 · Vereda El Mortillo, ColombiaimportNTSB GAA18CA066Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · New Orleans, LAThe pilot’s failure to land the helicopter with both skids on the trailer platform, which resulted in a loss of control.NTSB ERA18LA034Accident · No injuriesLimited investigationFinal reportAero Commander 112 · Westminister, MDThe student pilot's failure to maintain a proper glidepath during the approach due to his distraction by the failure of an avionics panel, which resulted in a runway undershoot.NTSB ERA18CA035Accident · No injuriesData collectionFinal reportDriggers Quillan E Titan Tornado · Mechanicsville, VAThe pilot’s inadequate preflight inspection and failure to detect water contamination in the fuel system, which resulted in a partial loss of engine power on takeoff.NTSB DCA18WA048Incident · No injuriesForeign investigationBoeing 777 · Singapore, SingaporeThe Transport Safety Investigation Bureau (TSIB) of Singapore has notified the NTSB of an incident involving a Boeing 777, which occurred on November 29, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex…NTSB DCA18WA027Accident · Serious injuriesForeign investigationBoeing 757 224 · Bogota, ColombiaThe Colombia Civil Aviation Authority (CAA) has notified the NTSB of an accident involving a Boeing 757, which occurred on November 28, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the State…NTSB DCA18IA026Incident · No injuriesClass 3 · IncidentFinal reportBoeing 737-932ER · Atlanta, GAThe flight crewmembers’ failure to properly monitor the airplane’s flightpath, which caused the approach to become unstabilized and resulted in the airplane’s descent below the decision altitude while misaligned with the localizer course. Contributing to the…NTSB ANC18CA017Accident · No injuriesData collectionFinal reportPiper PA 18-125 · Nikolai, AKThe pilot’s improper decision to contact an unsuitable landing surface, which resulted in a nose-over.NTSB DCA18LA024AccidentClass 3 · LimitedFinal reportBoeing 777 · Jamaica, NYThe air traffic controller's improper instruction to the Egypt Air airplane flight crew to pass in an area where passing is prohibited, which led to a ground collision.NTSB WPR18LA037Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC41 550FG · Oro Valley, AZThe inadequate cooling time between repeated heavy braking applications, which resulted in the brakes overheating and a subsequent brake fire during the aborted takeoff sequence.NTSB GAA18CA058Accident · No injuriesData collectionFinal reportCessna 182 · Black River Falls, WIThe student pilot’s failure to maintain lateral control of the high-performance airplane during the go-around in crosswind conditions.NTSB CEN18LA042Accident · No injuriesLimited investigationFinal reportMotley Gary W Zenith CH750 Cruzer · Louviers, COThe engine’s excessive cylinder head temperatures and the subsequent seizing of the engine, which resulted from an engine control unit that caused the engine’s fuel-air mixture to be too lean.NTSB GAA18CA080Accident · No injuriesData collectionFinal reportCessna 172 · Daytona Beach, FLThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB GAA18CA059Accident · No injuriesData collectionFinal reportMooney M20 · Tucson, AZThe pilot’s inadequate preflight and in-flight fuel management, which resulted in an intermittent loss of engine power due to fuel starvation.NTSB CEN18LA040Accident · No injuriesLimited investigationFinal reportCessna 150F · Midland, TXThe improper installation of the generator by unknown personnel, which resulted in a loss of oil and subsequent engine failure.NTSB CEN18LA038Accident · Serious injuriesLimited investigationFinal reportPiper / Laudeman J3C 65 · Palmyra, WIThe pilot’s inadvertent pulling of the fuel shutoff valve, which resulted in a total loss of engine power and a subsequent forced landing into trees. Contributing to the pilot’s inadvertent pulling of the fuel shutoff valve were habit patterns he had…NTSB WPR18LA040Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Odessa, FLA loss of engine power due to fuel starvation as a result of the pilot's inadequate planning and in-flight fuel management. Contributing to the accident was the pilot’s failure to follow proper procedures after the loss of engine power.NTSB WPR18LA036Accident · Minor injuriesClass 3 · LimitedFinal reportDoshier Wilbert A GT-500 · Willows, CAA loss of engine power during takeoff due a coolant leak and the subsequent overheating of the engine, and the student pilot's failure to maintain airspeed and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall…NTSB ERA18LA032Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Ebensburg, PAThe pilot's improper decision to fly an airplane with a known oil leak, which led to a total loss of engine power due to oil starvation. Contributing to the accident was the pilot's decision to land with a tailwind, which led to his attempted go-around and…NTSB ERA18LA031Accident · Minor injuriesLimited investigationFinal reportPiper PA46 · Clearwater, FLA partial loss of engine power for reasons that could not be determined based on the available information.NTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).NTSB GAA18CA065Accident · No injuriesData collectionFinal reportAveko Sro VL-3C-1 · Northampton, MAThe pilot’s improper landing flare, which resulted in a loss of directional control and subsequent impact with approach lighting.NTSB GAA18CA057Accident · No injuriesData collectionFinal reportKarpayev Vladyslav V RV-9 · Moab, UTThe pilot’s selection of an unsuitable taxiway, which resulted in the wings striking hidden fence posts.NTSB GAA18CA061Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Caldwell, TXThe pilot’s failure to maintain yaw control and the exceedance of the airplane’s critical angle of attack in the traffic pattern, which resulted in an aerodynamic stall/spin.NTSB GAA18CA056Accident · No injuriesData collectionFinal reportBuehlmann Peter Kitfox Model 4 1200 · Overgaard, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA18FA030Accident · 1 fatalField investigationFinal reportMooney M20C · Starke, FLThe pilot's loss of control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing was the pilot's lack of instrument currency and his self-induced pressure to complete the flight.NTSB DCA18WA028Incident · No injuriesForeign investigationBoeing 737 · Latvia, LatviaThe Transport Accident and Incident Investigation Bureau of Latvia has notified the NTSB of an incident involving a Boeing 737, which occurred on November 23, 2017. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO…NTSB WPR18WA086Incident · No injuriesForeign investigationHawker Beechcraft 390 · Germiston, South AfricaOn November 22, 2017, at 1423 coordinated universal time, a Hawker Premier Jet airplane, registration ZS-CBI, sustained minor damage during a runway excursion at Rand Airport (FAGM), Germiston, South Africa. The pilot and passenger were not injured. The…NTSB GAA18CA060Accident · No injuriesData collectionFinal reportHughes 300 · Woodlawn, VAThe pilot’s inappropriate descent profile during landing with a quartering gusting tailwind, which resulted in a loss of main rotor rpm.NTSB ERA18LA033Accident · Minor injuriesLimited investigationFinal reportCessna 421 · Presque Isle, METhe in-flight leakage of fuel from the fuel injection system's mixture shaft onto the hot turbocharger, which resulted in an in-flight fire, and the pilot's inability to see the runway due to reduced visibility conditions and conduct a successful landing.NTSB DCA18WA038Incident · No injuriesForeign investigationBoeing 737 · Foz do Iguacu County, BrazilThe government of Brazil has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on November 22, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…NTSB CEN18WA046Accident · 2 fatalForeign investigationMD Helicopter 369HS · La Morita, MexicoOn November 22, 2017, about 1437 pacific standard time, a MD Helicopters 369HS single-engine helicopter, serial number 920414S, Mexican registration XC-TIJ, crashed while providing aerial support for police activity near La Morita, Mexico. The pilot and his…NTSB CEN18LA056Accident · No injuriesLimited investigationFinal reportCessna 172N · Maple Lake, MNThe pilot’s failure to maintain directional control while landing, which resulted in a runway excursion.NTSB CEN18LA043Accident · No injuriesLimited investigationFinal reportRutten Phil J Pietenpol · De Kalb, ILThe pilot’s excessive rudder and brake applications during landing, which caused the airplane to nose over.NTSB CEN18LA041Accident · No injuriesLimited investigationFinal reportCessna 182S · Bolingbrook, ILThe pilot’s failure to maintain directional control during takeoff.NTSB CEN18LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA 12 · Dickinson, NDThe pilot’s failure to attain adequate airspeed during the short field takeoff, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB CEN18FA037Accident · 1 fatalField investigationFinal reportCessna 172G · Pittsford, VTThe pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation.NTSB GAA18CA055Accident · No injuriesData collectionFinal reportBellanca 8KCAB · El Dorado, MOThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR18FA035Accident · 1 fatalField investigationFinal reportCessna 152 · Tehachapi, CAThe pilot's loss of situational awareness shortly after takeoff over a sparsely lit area in dark night conditions, which resulted in a rapid descent to ground impact.NTSB GAA18CA063Accident · No injuriesData collectionFinal reportCessna 172N · San Diego, CAAn in-flight collision with a bird.