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 GAA17CA248Accident · No injuriesData collectionFinal reportCessna 172S · Jean, NVThe pilot’s runway selection, which resulted in landing with a tailwind and an unstabilized approach and subsequent runway overrun.NTSB GAA17CA211Accident · No injuriesData collectionFinal reportMooney M20J · Cedar Key, FLThe pilot’s failure to follow the manufacturer’s go-around procedure, which resulted in an aerodynamic stall.NTSB ERA17WA179Accident · 2 fatalForeign investigationPiper PA30 · Sao Paulo, BrazilOn April 28, 2017, about 1930 coordinated universal time, a Piper PA30, Brazilian registration PT-CHT, was substantially damaged when it impacted terrain during an instructional flight near Sao Paulo, Brazil. The pilot and copilot were fatally injured. The…NTSB DCA17WA106Accident · No injuriesForeign investigationBoeing 737 · Keflavik, IcelandThe AAIB of Iceland has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on April 28, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB of Iceland's investigation under the provisions of ICAO Annex…NTSB CEN17FA170Accident · 1 fatalField investigationFinal reportAir Tractor AT 602 · Hollis, OKAn impact with terrain during final approach for reasons that could not be determined because no evidence of an in-flight failure or malfunction was observed.NTSB WPR17LA093Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Coolidge, AZA partial loss of engine power due to separation of the throttle cable.NTSB WPR17FA091Accident · 1 fatalField investigationFinal reportNanchang CJ6A · Keene, CAThe pilot's failure to maintain airplane control following a descent into clouds.NTSB ERA17LA168Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Newton, NCThe pilot's failure to maintain an adequate airspeed during out-of-ground-effect maneuvering at a low airspeed with a tailwind, which resulted in a loss of helicopter control due to a loss of tail rotor effectiveness.NTSB CEN17FA167Accident · 1 fatalField investigationFinal reportCessna 421C · Huntsville, TXThe pilot's failure to identify the alternate runway, to perform a timely precautionary landing, and to maintain airplane control. Contributing to the accident was the failure of the left engine due to oil starvation for reasons that could not be determined…NTSB WPR17LA090Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Banning, CAThe pilot's improper energy management during an emergency landing approach that was prompted by an engine power loss. The specific reason(s) for the power loss and the improper energy management could not be determined based on available evidence.NTSB GAA17CA246Accident · No injuriesData collectionFinal reportThomas B Mcgrath JA30 Superstol · Chesterfield, MOThe pilot’s failure to maintain directional control of the airplane during the landing roll in crosswind conditions.NTSB GAA17CA244Accident · No injuriesData collectionFinal reportBeech 99 · Waukesha, WIAn in-flight collision with a bird during the approach.NTSB ERA17FA167Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Wallingford, CTThe pilot's unstablilized approach and improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain control during a go-around. Contributing to the accident was the pilot's lack of experience in the accident airplane…NTSB CEN17FA164Accident · 2 fatalField investigationFinal reportBellanca 17 31ATC · Boonville, MOThe pilot's impairment, due to his use of a combination of psychoactive drugs and a vision deficiency in his left eye, which resulted in a failure to maintain adequate altitude during final approach to landing and subsequent collision with power lines.NTSB WPR17FA089Accident · 1 fatalField investigationFinal reportAppleby Nieuport 28 · Paso Robles, CAThe failure of unknown personnel to properly safety an elevator control cable turnbuckle, which disconnected in flight resulting in loss of pitch control. Contributing to the accident was the inadequate design of the experimental airplane, which did not…NTSB GAA17CA245Accident · No injuriesData collectionFinal reportCessna 185 · Marsing, IDThe pilot’s improper landing flare, which resulted in a bounced landing, the failure of the right main landing gear wheel, and a ground loop.NTSB ERA17LA166Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Ovid, NYThe mechanic's failure to inspect and clean the carburetor fuel inlet screen during the airplane’s annual inspection, which allowed undetected debris and dirt to obstruct the fuel supply and resulted in fuel starvation and the subsequent total loss of engine…NTSB CEN17LA178Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Manistee, MIThe failure of the airplane owner and maintenance personnel to follow the propeller manufacturer's recommend overhaul schedule, which resulted in a fatigue fracture of the propeller blade actuating pin and a loss of thrust in flight.NTSB CEN17LA166Accident · No injuriesLimited investigationFinal reportPiper PA 31-350 · Covington, LAThe pilot's improper fuel planning, which resulted in a total loss of power to both engines due to fuel exhaustion.NTSB GAA17CA262Accident · No injuriesData collectionFinal reportBalony Kubicek Spol Sro BB70Z · Park City, UTThe pilot’s failure to see and avoid power lines during landing.NTSB ERA17LA165Accident · No injuriesLimited investigationFinal reportGanjoo Amit Sonex · Leesburg, VAThe pilot's failure to use carburetor heat appropriately, which resulted in a total loss of engine power due to the formation of carburetor ice.NTSB WPR17LA088Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 22-150 · Kernville, CAThe pilot’s exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/mush.NTSB GAA17CA243Accident · No injuriesData collectionFinal reportCessna 182 · Killeen, TXThe pilot's incorrect landing flare in gusting wind conditions.NTSB GAA17CA240Accident · Minor injuriesData collectionFinal reportParlette Robert L Glastar · Wenatchee, WAThe pilot’s improper landing flare and subsequent failure to adequately compensate for gusting wind conditions during a go-around.NTSB ERA17FA164Accident · 1 fatalField investigationFinal reportBell-Carson 47G Super C 4 · Timmonsville, SCThe pilot's decision to maneuver the helicopter at a low altitude near trees, which resulted in collision with the trees.NTSB CEN17LA165Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Vidrine, LAThe total loss of engine power for reasons that could not be determined because an examination of the engine and a test run did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR17LA099Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Goodyear, AZLoss of engine power due to the installation of an improper air induction hose, which failed and prevented sufficient air intake to the turbocharger.NTSB GAA17CA242Accident · No injuriesData collectionFinal reportNorth American SNJ · Van Nuys, CAThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind.NTSB ERA17LA163Accident · No injuriesLimited investigationFinal reportRobinson R44 · Orlando, FLA partial failure of the helicopter's engine tachometer due to the separation of one of the magnet assemblies and engine roughness, which precipitated the pilot’s initiation of an off-airport autorotation, during which he applied improper aft cyclic flight…NTSB ERA17LA160Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankeetown, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA17CA162Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Leonardtown, MDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control when he initiated a go-around.NTSB DCA17WA113Incident · No injuriesForeign investigationBoeing 737 · Palma de Mallorca, SpainThe Comision de Investigacion de Accidenties E Incidentes de Aviacion Civil of Spain has notified the NTSB of an incident involving a CESSNA 510 airplane that occurred on April 20, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB CEN17LA162Accident · No injuriesLimited investigationFinal reportCessna 210 · Salida, COThe pilot’s inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA17CA349Accident · No injuriesData collectionFinal reportPiper PA44 · Tulsa, OKThe pilot receiving instruction’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA17CA239Accident · No injuriesData collectionFinal reportBeech C23 · Fallon, NVThe pilot's inaccurate takeoff performance calculations and failure to maintain directional control during an aborted takeoff.NTSB GAA17CA237Accident · No injuriesData collectionFinal reportBrantly B 2B · Earl Park, INThe pilot’s failure to recognize that he was operating in the weathercock stability flight regime of loss of tail rotor effectiveness, which resulted in a loss of directional control during the execution of a right pedal turn.NTSB ERA17LA158Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Euharlee, GAThe NTSB did not determine the probable cause of this event and does not plan to issue a report or open a public docket. The investigation of this event is being conducted under the jurisdiction of the Federal Bureau of Investigation.NTSB ERA17FA156Accident · 2 fatalField investigationFinal reportLuscombe 8 · East Windsor, CTThe flying pilot's excessive maneuvering of the airplane at a slow airspeed, which resulted in exceedance of the critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilots' operation of the airplane over its maximum…NTSB WPR17FA105Accident · 2 fatalField investigationFinal reportSocata TB 20 Trinidad · Sierraville, CAThe pilot's decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into mountainous terrain.NTSB GAA17CA238Accident · No injuriesData collectionFinal reportCheung David S Vans RV6 · Indianola, IAThe pilot’s failure to maintain an adequate approach path, which resulted in a long landing and subsequent runway overrun.NTSB DCA17WA107Incident · No injuriesForeign investigationAirbus A320 · New Delhi, IndiaThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an incident involving a AIRBUS A320 airplane that occurred on April 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…NTSB DCA17WA097Incident · No injuriesForeign investigationBoeing 777 · Amsterdam, NetherlandsThe government of Netherlands has notified the NTSB of an accident involving a BOEING 777 airplane that occurred on April 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Netherlands's investigation under the…NTSB CEN17RA158Accident · 5 fatalForeign investigationPiper PA31T · Cascais, PortugalOn April 17, 2017, about 1104 hours universal coordinated time, a Piper PA-31T, serial number 31T-8020091, Swiss registration HB-LTI, was destroyed during impact and a postimpact fire following a loss of control during initial climb from runway 17 at the…NTSB CEN17LA163Accident · No injuriesLimited investigationFinal reportGrumman Schweizer G-164 · Palmer, KSA crack in the cylinder of the radial engine, which resulted in a loss of engine power and a forced landing on unsuitable terrain.NTSB CEN17LA156Accident · No injuriesLimited investigationFinal reportLoomis Xenon 4 · Knoxville, IAA partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.NTSB ANC17LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Willow, AKThe partial loss of engine power for reasons that could not be determined based on the available information, which resulted in the forced landing attempt and impact with power lines.NTSB GAA17CA236Accident · Minor injuriesData collectionFinal reportZeiler Bakeng Duce 1976 CZ · Oliver Springs, TNThe pilot’s unstabilized approach and failure to go around, which resulted in impact with trees.NTSB GAA17CA235Accident · No injuriesData collectionFinal reportRaytheon B200 · Richfield, UTThe pilot’s failure to maintain separation from a fence post during taxi at night.NTSB ERA17FA155Accident · 4 fatalField investigationFinal reportCessna 170 · Williston, FLThe pilot's failure to maintain adequate airspeed during initial climb in gusty wind conditions, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin.NTSB ERA17CA157Accident · No injuriesData collectionFinal reportAeropro CZ Eurofox LSA · Kingsland, GAThe pilot's improper landing flare, which resulted in a hard landing and subsequent nose-over.