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 ERA17WA191Accident · 2 fatalForeign investigationRobinson R44 · Heilbron, South AfricaThe South African Civil Aviation Authority (SACAA) has notified the NTSB of an accident involving a Robinson R44 II helicopter that occurred on May 19, 2017. The NTSB has appointed a U.S. Accredited Representative to assist SACAA's investigation under the…NTSB GAA17CA297Accident · Minor injuriesData collectionFinal reportCGS Hawk · Findlay, OHThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB GAA17CA293Accident · No injuriesData collectionFinal reportPiper PA 34 · Tunkhannock, PAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during landing in crosswind conditions, which resulted in an aerodynamic stall.NTSB ERA17WA206Incident · No injuriesForeign investigationCessna 182 · Poesoegroenoe, SurinameOn May 18, 2017, at 1840 coordinated universal time, a Cessna 182P, registered as PZ-VAC, experienced an uncontained engine failure, and sustained minor damage during a subsequent forced landing in Poespegroenoe, Suriname. The pilot and two passengers were…NTSB ERA17WA198Accident · 2 fatalForeign investigationCessna 206 · Cerro Azul, EcuadorOn May 18, 2017, at an unknown time, a Cessna 206H, Ecuadorian registration HC-CEG, was destroyed when it impacted terrain in Cerro Azul, Ecuador. The foreign certificated pilot and one passenger were fatally injured. The flight departed Jose Joaquin de…NTSB GAA17CA307Accident · No injuriesData collectionFinal reportCessna U206 · Diamond Point, NYThe pilot’s failure to maintain directional control during the takeoff roll with gusting wind conditions.NTSB ERA17WA200Accident · No injuriesForeign investigationPiper PA34 · San Lorenzon, PeruThe government of Peru has notified the NTSB of an accident involving a PIPER PA34 airplane that occurred on May 17, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of ICAO…NTSB ERA17LA182Accident · Minor injuriesLimited investigationFinal reportStinson 108 · West Creek, NJA total loss of engine power due to the No. 4 cylinder’s exhaust valve getting stuck and the subsequent fracturing of the valve face stem.NTSB CEN17WA187Accident · 2 fatalForeign investigationLearjet 25 · Toluca, MexicoOn May 17, 2017, at 2025 hours universal coordinated time, a Lear 25B airplane, Mexican registration XA-VMC, impacted terrain near Toluca, Mexico. The pilot-in-command and co-pilot were fatally injured. The airplane was destroyed by impact forces and a…NTSB CEN17WA215Accident · No injuriesForeign investigationAyres S2R · Candillargues, France, FranceOn May 16, 2017, about 0530 hours universal coordinated time, an Ayres S2R airplane, French registration F-GIEN, was substantially damaged during a forced landing following a loss of engine power near Candillargues, France. The pilot was not injured. The…NTSB WPR17LA104Accident · Minor injuriesClass 3 · LimitedFinal reportEvolution Air Lancair Evolution · Firebaugh, CAA failure in the windshield, frame, or windshield-to-frame bond, which resulted in a rapid decompression during cruise flight.NTSB GAA17CA288Accident · No injuriesData collectionFinal reportAeronca 7AC · Lebanon, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions.NTSB GAA17CA285Accident · Minor injuriesData collectionFinal reportAir Tractor AT 802 · Dumas, TXThe pilot’s failure to maintain lateral control while maneuvering at a low altitude.NTSB GAA17CA281Accident · No injuriesData collectionFinal reportPiper PA22 · South Boston, VAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA280Accident · Minor injuriesData collectionFinal reportWeaver Stanley R/Robinson Scot Vans RV-8 · Vacaville, CAThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB ERA17FA181Accident · 4 fatalField investigationFinal reportMitsubishi MU2B · Eleuthera, BahamasThe pilot's intentional flight into an area of known icing and convective thunderstorm activity, which resulted in a loss of control of the airplane.NTSB CEN17MA183Accident · 2 fatalClass 1 · MajorFinal reportLearjet 35A · Teterboro, NJThe pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…NTSB CEN17LA184Accident · No injuriesLimited investigationFinal reportMooney M20E · Dowling, MIInnacurate airspeed indications due to contamination of the pitot-static system with insect remains, which resulted in a high approach and landing speed and subsequent runway overrun.NTSB GAA17CA300Accident · No injuriesData collectionFinal reportCessna 172 · Clarksville, TNThe pilot’s unstabilized approach and improper landing flare, which resulted in a hard, porpoised landing.NTSB DCA17WA118Incident · No injuriesForeign investigationBoeing 737 · Munich, GermanyThe Germany Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on May 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of…NTSB CEN17WA221Accident · Serious injuriesForeign investigationSilence Twister · Abingdon, United KingdomOn May 14, 2017, at 1330 universal coordinated time (UTC), a Silence model Twister single-engine airplane, United Kingdom registration G-JINX, serial number LAA 329-15102, was substantially damaged during a forced landing following a loss of engine power…NTSB ANC17CA023Accident · No injuriesData collectionFinal reportWsk-Pzl Warzawa-Okecie PZL 104 Wilga 80 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident were the pilot's lack of training and experience in the accident make and model airplane.NTSB GAA17CA278Accident · Minor injuriesData collectionFinal reportReims Cessna FR172 · De Pere, WIThe pilot’s failure to maintain directional control during takeoff with a tailwind.NTSB CEN17WA189Accident · 1 fatalForeign investigationMonocoupe 90AF · Plattsville, CanadaOn May 13, 2017, a Monocoupe 90F-100 airplane, C-FJGA, impacted short of the threshold at Lubitz Flying Field (CLB2), Plattsville, Ontario. The pilot was fatally injured.This investigation is under the jurisdiction and control of the government of Canada. Any…NTSB CEN17LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-140 · Muskogee, OKThe pilot's improper in-flight fuel management, which resulted in a partial loss of engine power due to fuel starvation.NTSB CEN17LA185Accident · No injuriesLimited investigationFinal reportMooney M20TN · Grandby, COThe total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN17LA182Accident · Serious injuriesLimited investigationFinal reportPipistrel Doo Ajdovscina Virus SW · Weatherford, TXThe pilot's failure to obtain adequate airspeed during takeoff, which resulted in an aerodynamic stall/spin.NTSB CEN17LA181Accident · 1 fatalLimited investigationFinal reportAS+ AC 4 · Blair, NEThe pilot's loss of control due to his diverted attention as he attempted to close the canopy that opened during initial climb.NTSB GAA17WA582Accident · No injuriesClass 5 · ForeignPiper PA 46-350P · Nyíregyháza, HungaryNTSB GAA17CA287Accident · No injuriesData collectionFinal reportJohnson Kenneth W Super CUB Sport · Austin, NVThe pilot’s failure to maintain adequate airspeed during landing in gusting wind conditions, which resulted in a loss of directional control.NTSB GAA17CA277Accident · No injuriesData collectionFinal reportCessna 172 · Boca Raton, FLThe student pilot’s failure to maintain directional control of the airplane while landing with a tailwind.NTSB GAA17CA276Accident · No injuriesData collectionFinal reportCessna 172 · Monument Valley, UTThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA17FA180Accident · 2 fatalField investigationFinal reportBeech A36TC · Hopkinsville, KYThe noninstrument-rated pilot's intentional visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident were the pilot's overreliance on his…NTSB CEN17WA256Accident · No injuriesForeign investigationLancair IV · Grenaa, DenmarkOn May 12, 2017, about 0635 coordinated universal time, a Lancair IV P airplane, Swiss registration SE-XRU, was substantially damaged when it impacted terrain near Grenaa, Denmark. The airplane was registered to and operated by a private individual as a…NTSB CEN17LA180Accident · Serious injuriesLimited investigationFinal reportBrokaw Bergon F Zodiac · Orangeville, ILThe total loss of engine power due to fuel starvation.NTSB GAA17CA275Accident · Serious injuriesData collectionFinal reportPiper PA18 · Seward, AKThe flight instructor's incorrect brake application during a high-speed taxi with a tailwind, which resulted in a nose-over.NTSB GAA17CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Vevay, INThe pilot’s failure to see and avoid power lines during an agricultural application flight due to distraction when reading a map.NTSB GAA17CA274Accident · Minor injuriesData collectionFinal reportCessna 177 · Frankston, TXThe pilot’s loss of runway visibility during landing in rain, which resulted in the pilot’s loss of situational awareness and subsequent loss of airplane control.NTSB ERA17WA183Accident · 1 fatalForeign investigationEnstrom Helicopter 480B · Fundres, ItalyOn May 10, 2017, about 1143 universal coordinated time,an Enstrom 480B, N480W, was destroyed during an infight break-up near Fundres, Italy. The flight departed from Bolzano, Italy, and was destined for Linz, Italy. The pilot was fatally injured. This…NTSB ERA17CA177Accident · Serious injuriesData collectionFinal reportReupert Mark Avid Flyer · Reedsville, PAThe sport pilot's failure to maintain airplane control during takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB CEN17RA191Accident · 2 fatalForeign investigationBell 429 · Presov, SlovakiaOn May 10, 2017, about 1430 local time, a Bell 429 helicopter, Slovakia registration OM-BYM, impacted terrain shortly after takeoff near Presov, Slovakia. There were four people on board; two people received fatal injuries and two people received serious…NTSB OPS17IA021IncidentClass 3 · IncidentFinal reportCessna 172S · New Orleans, LAThe air traffic controller not following Federal Aviation Administration directives to establish sequencing and spacing between aircraft operating to the same runway.NTSB GAA17CA282Accident · No injuriesData collectionFinal reportPiper PA23 · Fremont, OHThe pilot’s failure to maintain an adequate glidepath during approach, which resulted in an impact with a semi-truck.NTSB GAA17CA270Accident · No injuriesData collectionFinal reportCessna A185 · Columbia, CAThe pilot’s failure to maintain directional control in tailwind and crosswind conditions.NTSB ERA17LA176Accident · No injuriesClass 3 · LimitedFinal reportCessna 150M · Homerville, GAA total loss of engine power due to inadequate maintenance and inspection of the engine, which resulted in a fatigue crack and subsequent failure of the No. 4 cylinder.NTSB ERA17LA175Accident · No injuriesLimited investigationFinal reportMooney M20R · Myrtle Beach, SCA total loss of engine power during initial climb for reasons that could not be determined because the airplane sank in the ocean and was not recovered.NTSB CEN17WA195Accident · Serious injuriesForeign investigationCessna P210N · San Vicente Tancoayalab, MexicoOn May 9, 2017, about 1430 universal coordinated time, a Cessna P210N airplane, N116DC, impacted trees and terrain during an emergency descent near San Vicente Tancoayalab, Mexico, following lightning strikes during cruise. The pilot was seriously injured and…NTSB WPR17LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA 18A · Coeur D'Alene, IDThe loss of yaw control due to an inadequately compressed rudder swage, which resulted from inadequate maintenance and led to the separation of the forward right rudder cable.NTSB WPR17FA101Accident · 2 fatalField investigationFinal reportIcon A5 · Lake Berryessa, CAThe pilot's failure to maintain clearance from terrain while maneuvering at a low altitude. Contributing to the accident was the pilot's mistaken entry into a canyon surrounded by steep rising terrain while at a low altitude for reasons that could not be…NTSB GAA17CA267Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164 · Walnut Ridge, ARThe pilot’s failure to maintain directional control during the go-around with a tailwind.