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 GAA16CA202Accident · No injuriesData collectionFinal reportCessna 172 · Camarillo, CAThe student pilot's incorrect pitch control input, resulting in a porpoise during landing and substantial damage to the airplane's firewall.NTSB ERA16LA167Accident · No injuriesLimited investigationFinal reportBell 47D1 · Myerstown, PAA total loss of engine power for reasons that could not be determined because examination of the engine revealed no mechanical anomalies that would have precluded normal operation.NTSB ENG16WA022Accident · Minor injuriesForeign investigationBeech 1900 · Gander, CanadaThe Transportation Safety Board of Canada has notified the NTSB of an accident involving a Beechcraft 1900D, which occurred on April 20, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the Transportation Safety Board of Canada…NTSB CEN16WA174Accident · 1 fatalForeign investigationCessna 150 · Strakonice, CzechiaOn April 20, 2016, at 1253 universal coordinated time (UTC), a Cessna 150 airplane, Czech Republic registration OK-OKA, serial number 150741140, sustained substantial damage when it impacted terrain near the Strakonice Airport (LKST), Strakonice, Czech…NTSB CEN16FA158Accident · 2 fatalField investigationFinal reportBeech 65 A90 1 · Slidell, LAThe unstable approach in black-hole conditions, resulting in the airplane overshooting the runway extended centerline and descending well below a safe glidepath for the runway. Contributing to the accident was the lack of monitoring by the copilot allowing…NTSB ANC16FA019Accident · 4 fatalField investigationFinal reportCessna 172 · Chugiak, AKThe in-flight collision with one or more large birds (Bald Eagle), which resulted in a loss of airplane control.NTSB WPR16LA094Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Selma, CAThe total loss of engine power due to carburetor icing, which resulted from the flight instructor's failure to use carburetor heat during the descent.NTSB GAA16CA204Accident · No injuriesData collectionFinal reportPiper PA 18 · Palmer, AKThe pilot's decision to land on unsuitable terrain and incorrect brake application during the landing roll, which resulted in a nose over.NTSB GAA16CA193Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8A · Burlington, WAThe pilot's excessive application of the brakes during the landing roll, resulting in a loss of directional control, runway excursion, and ground loop.NTSB ERA16LA166Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Tannersville, PAA loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA16FA165Accident · 2 fatalField investigationFinal reportVans RV12 · Stevensville, MDThe pilot's failure to maintain airplane control during approach for landing in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.NTSB GAA16CA195Accident · Minor injuriesData collectionFinal reportGary A Jamieson JA30 Superstol · Palmer, AKThe pilot's failure to maintain pitch control of the airplane during the landing touchdown, which resulted in a nose over.NTSB ERA16WA163Accident · 3 fatalForeign investigationRobinson R66 · Bely Island, RussiaNTSB ERA16LA164Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Okeechobee, FLThe failure of the No. 3 piston due to fatigue cracking, which resulted in a total loss of engine power and subsequent forced landing, during which the airplane impacted obstacles.NTSB ERA16FA161Accident · 2 fatalField investigationFinal reportCessna 172 · Westmoreland, NYThe pilot's decision to takeoff on the grass runway given the conditions at the time; his excessive aft control input during the takeoff roll, which resulted in the aft fuselage contacting the runway surface; and his failure to attain sufficient airspeed and…NTSB CEN16LA156Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Arden Hills, MNA partial loss of engine power for reasons that could not be determined based on the available evidenceNTSB CEN16LA154Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT 502 · Kilbourne, LAThe failure of the operator to comply with the terminating action of the airworthiness directive, which resulted in the subsequent failure and separation of the vertical stabilizer due to fatigue.NTSB WPR16LA093Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Avalon, CAThe pilot's failure to maintain a proper approach path on landing because he failed to familiarize himself with the airport's unique approach hazards and recommended procedures before the flight. Also causal was the pilot's failure to recognize the airplane's…NTSB ENG16RA028Incident · No injuriesForeign investigationBombardier CL600 2C10 · Fukuoka, JapanThe Japan Transport Safety Board has notified the NTSB of an incident involving a Bombardier CL-600-2C10, JA06RJ, which took off from Fukuoka Airport at 07:48 local time to Komatsu Airport and during return back to Fukuoka Airport due to weather condition of…NTSB CEN16WA160Accident · 1 fatalForeign investigationExtra Flugzeugbau EA 300/L · Cozumel, MexicoOn April 17, 2016, at 1940 UTC, an Extra EA300, N13DK, impacted terrain at Cozumel International Airport (MMCZ) in Cozumel, Mexico. The aircraft was destroyed and the pilot, the sole occupant, was fatally injured. This investigation is under the jurisdiction…NTSB ERA16LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2008 · Burgaw, NCThe pilot’s failure to activate the airplane’s alternator, which resulted in an eventual loss of electrical power to the engine’s fuel pumps, fuel starvation, and a total loss of engine power. Contributing was the pilot’s use of an incomplete checklist.NTSB ERA16CA160Accident · No injuriesData collectionFinal reportBell 206 · Baltimore, MDThe pilot's inadequate compensation for the wind while hovering out of ground effect, which resulted in a loss of tail rotor effectiveness.NTSB GAA16CA194Accident · No injuriesData collectionFinal reportCessna 172 · Stillwater, OKThe student pilot's failure to maintain directional control during the landing roll in gusty crosswind conditions, which resulted in a runway excursion and collision with a runway distance remaining sign.NTSB ERA16LA159Accident · No injuriesLimited investigationFinal reportEurocopter France AS350 · Jasper, GAThe pilot's loss of helicopter control due to vortex ring state, which resulted in a hard landing. Contributing to the accident was the pilot’s decision to conduct the landing approach with a tailwind.NTSB ERA16LA158Accident · No injuriesLimited investigationFinal reportCessna U206 · Atlantic Ocean (Atlantic Ocean)A total loss of engine power for reason(s) that could not be determined because the airplane was not recovered.NTSB GAA16CA196Accident · Minor injuriesData collectionFinal reportCessna 182 · Moorestown, MIAn in-flight bird strike, which resulted in wind screen damage.NTSB ERA16LA157Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 175 · Wartburg, TNCatastrophic engine failure due to a fatigue fracture of the No. 6 connecting rod cap.NTSB DCA16CA133Accident · Serious injuriesData collectionFinal reportBoeing 737 76Q · San Diego, CAthe ramp agents failure to keep his right hand at a safe distance from the underside of the moving belt.NTSB CEN16LA157Accident · No injuriesLimited investigationFinal reportCzech Sport Piper Sport · Mansfield, OHThe pilot's failure to inspect the nose landing gear (NLG), which resulted in a crack going undetected and the subsequent separation of the NLG at the weld area during landing.NTSB WPR16LA092Accident · No injuriesLimited investigationFinal reportCessna 421C · Death Valley, CAA runway overrun for reasons that could not be determined based on the available information.NTSB ERA16LA156Accident · Minor injuriesLimited investigationFinal reportAtkinson Eaglet · Deland, FLA total loss of engine power during initial climb due to a separation of the ignition plug.NTSB DCA16WA131Accident · 12 fatalForeign investigationBritten Norman BN2 · Kiunga, Papua New GuineaThe government of Papua New Guinea has notified the NTSB of an accident involving a BRITTEN NORMAN BN2 airplane that occurred on April 13, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Papua New Guinea's…NTSB GAA16CA192Accident · No injuriesData collectionFinal reportCessna E162 · Lee's Summit, MOThe flight instructor's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and collision with a taxiway sign.NTSB GAA16CA190Accident · No injuriesData collectionFinal reportMonocoupe 110 · Chandler, AZThe pilot's incorrect installation of the tailwheel steering bungee, which resulted in a runway excursion and airplane nose over.NTSB CEN16WA152Accident · Minor injuriesForeign investigationPiper PA32R · Hampshire, United KingdomOn April 12, 2016, at 1300 coordinated universal time, a Piper PA-32R-301T airplane, G-MAIE, experienced a hard landing at the Daedalus Airfield (EGHF), Hampshire, United Kingdom. The pilot was not seriously injured, and the airplane sustained damage to the…NTSB ANC16WA018Accident · 2 fatalForeign investigationRockwell 112 · Revelstoke, CanadaOn April 11, 2016, about 2000 Coordinated Universal Time, a Rockwell Commander 112B airplane, CGQJN, impacted terrain near Revelstoke, British Columbia, Canada, under unknown circumstances. The pilot and passenger sustained fatal injuries. The Transportation…NTSB ERA16LA152Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Bayport, NYMaintenance personnel’s improper installation and maintenance of the fuel selector valve, which resulted in a total loss of engine power due to fuel starvation.NTSB DCA16WA138Incident · No injuriesForeign investigationBoeing 737 · Chiang Mai, ThailandMinistry of Transport of Thailand has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on April 10, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's investigation under the…NTSB CEN16LA151Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Caldwell, TXThe failure of the No. 5 cylinder's exhaust pipe for undetermined reasons, which resulted in a partial loss of engine power. Contributing to the accident was the pilot’s fast and long landing, which led to a runway overrun.NTSB GAA16CA217Accident · No injuriesData collectionFinal reportCessna A185 · Chesterfield, MOThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop and a wing strike.NTSB GAA16CA184Accident · No injuriesData collectionFinal reportDehavilland DHC 6 Twin Otter · Fentress, TXThe pilot's failure to maintain directional control during the aborted landing in gusty crosswind conditions, which resulted in a runway excursion and a collision with a tree.NTSB GAA16CA183Accident · Minor injuriesData collectionFinal reportPiper PA22 · Pantego, NCA loss of directional control during the takeoff roll in gusting wind conditions, which resulted in a runway excursion, a nose over, and an impact with terrain. Contributing to the accident was the pilot's decision to takeoff in gusting crosswind conditions.NTSB ERA16FA150Accident · 1 fatalField investigationFinal reportMooney M20K · Ocala, FLThe pilot's failure to maintain sufficient airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall. Contributing to the accident was the pilot's inadvertent placement of the…NTSB ENG16RA021Incident · No injuriesForeign investigationATR ATR72 · Trapani, ItalyThe Agenzia Nazionale per la Sicurrezza del Volo (ANSV) has notified the NTSB of an incident involving an ATR 72 that occurred April 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the ANSV investigation under the provisions of ICAO…NTSB CEN16WA159Incident · No injuriesForeign investigationCessna 550 · Geneva, SwitzerlandThe Swiss Accident Investigation Board (SAIB) of Switzerland has notified the National Transportation Safety Board (NTSB) of an incident involving a Cessna Aircraft Company S550 Citation S/2, EC-LQF, that occurred on April 9, 2016. The NTSB has appointed a…NTSB CEN16FA146Accident · 2 fatalField investigationFinal reportRockwell 690B · Taylor, TXA loss of control while maneuvering for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or anomalies with the airplane.NTSB GAA16LA182Accident · Serious injuriesLimited investigationFinal reportHughes 369 · Weatherford, TXThe pilot/mechanic's inadequate postmaintenance and preflight inspections, which resulted in his failure to remove the antitorque pedal lock and a subsequent loss of control during hover operations.NTSB GAA16CA189Accident · No injuriesData collectionFinal reportTL Ultralight Sro TL-3000 Sirius · South St. Paul, MNThe pilot's failure to maintain a proper landing flare in gusty wind conditions, which resulted in a hard landing and substantial damage to the firewall.NTSB ERA16LA151Accident · Serious injuriesLimited investigationFinal reportGranger Michael D Sonex · Jesup, GAThe pilot's improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN16FA145Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Midlothian, TXThe flight instructor's inability to move the control stick after takeoff for undetermined reasons, which resulted in an exceedance of the airplane's critical angle of attack and inadvertent aerodynamic stall. The reason for the inability to move the control…