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 CEN15WA447Accident · No injuriesForeign investigationBell 407 · San Agustine Guatemala, GuatemalaThe Direccion General de Aeronutica Civil (DGAC) of Guatemala has notified the NTSB of a non-fatal accident involving a Bell 407GX Helicopter, registration TG-PDF, that occurred on September 24, 2015. The NTSB has appointed a U.S. Accredited Representative to…NTSB CEN15LA423Accident · Serious injuriesLimited investigationFinal reportBell 206B · Woodville, TXThe loss of engine power due to water contamination in the fuel system. Contributing to the accident were the pilot’s inadequate preflight inspection of the fuel tanks and the operator’s inadequate inspection of the fuel supply truck that did not detect water…NTSB WPR15LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Elko, NVThe pilot's failure to sufficiently lean the engine’s fuel-to-air mixture for the given density altitude, which resulted in reduced engine power output and the airplane’s inability to climb.NTSB GAA15CA289Accident · Minor injuriesData collectionFinal reportCessna 195 · Merritt Island, FLThe pilot's excessive braking during the landing roll, resulting in a nose over.NTSB GAA15CA271Accident · No injuriesData collectionFinal reportCessna 305A · Show Low, AZThe pilot's failure to maintain directional control during landing in quartering tailwind conditions, which resulted in a runway excursion and a right main landing gear collapse.NTSB ERA15WA370Accident · 4 fatalForeign investigationBell 206 · Maceio, BrazilOn September 23, 2015, at 1350 universal coordinated time, a Bell 206L-3, Brazilian registration PP-ELA, was destroyed when it impacted terrain in Maceio, Brazil. The four occupants were fatally injured. The local police patrol flight originated at Zumbi dos…NTSB GAA15CA280Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · West Palm Beach, FLThe flight instructor's improper use of pitch control during a demonstrated 180 degree autorotation which resulted in damage to the tail boom.NTSB GAA15CA279Accident · No injuriesData collectionFinal reportBrunzlick Larry R Seawind 3000 Experim · Pelican Lake, WIAbnormal runway contact which precipitated a loss of directional control and impact with water.NTSB CEN15LA421Accident · Serious injuriesLimited investigationFinal reportLerch RV6A · Deckerville, MIThe in-flight loss of engine oil after the oil filter separated from the engine adapter assembly because of an incorrect modification of the oil filter adapter assembly, which resulted in a precautionary landing in a field.NTSB WPR15LA265Accident · Serious injuriesLimited investigationFinal reportAero Commander 680 E · Boise, IDThe pilot's failure to maintain airplane control following an engine problem for reasons that could not be determined because postaccident examination of both engines and the rudder revealed no malfunctions or anomalies that would have precluded normal…NTSB WPR15LA262Accident · No injuriesLimited investigationFinal reportGraves Bryon S Vans RV-7A · Byron, CAImproper overhaul of the right magneto, which eliminated system redundancy, and resulted in a loss of engine power when the left magneto failed during aerobatic flight maneuvers.NTSB WPR15IA263Incident · Minor injuriesIncident investigationFinal reportCessna T206H · Idaho Falls, IDAn in-flight fire during initial climb due to the separation of the engine's turbocharger wastegate overboard exhaust tailpipe. Contributing to the accident was the owner's decision to not comply with a service bulletin that addressed the tailpipe separation.NTSB GAA15LA284Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Talkeetna, AKThe pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight and his decision to continue the flight despite signs of an engine problem, which resulted in a total loss of engine power due to fuel…NTSB GAA15CA300Accident · No injuriesData collectionFinal reportCessna 177RG · Aztec, NMThe pilot's failure to maintain directional control during an aborted landing, which resulted in a runway excursion and an impact with shrubs.NTSB GAA15CA270Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Jackpot, NVThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a collision with a fence.NTSB ERA15LA366Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bally, PAThe pilot's failure to maintain altitude during low-level aerobatic maneuvers. Contributing to the accident were the pilot's improper decision to attempt the low-level aerobatic maneuvers and his impairment due to psychiatric conditions and the medications he…NTSB CEN15LA418Accident · Minor injuriesLimited investigationFinal reportCessna 421B · Platteville, WIThe partial loss of right engine power for undetermined reasons with insufficient runway remaining for the aborted takeoff.NTSB GAA15LA265Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Palmer, AKThe pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during final approach to landing, which resulted in an aerodynamic stall and impact with terrain.NTSB GAA15CA290Accident · No injuriesData collectionFinal reportCessna 172M · Shiocton, WIThe pilot's decision to continue to land at an unlighted airstrip, at night, after the landing light failed on approach, which resulted in a bounced landing, runway excursion, and collision with terrain.NTSB ERA15LA374Accident · No injuriesLimited investigationFinal reportBell 206 · Thomaston, GAThe loss of tail rotor control due to a fractured pin in the tail rotor control system; the reason the pin fractured could not be determined as the fractured pin was lost in shipping.NTSB ERA15FA362Accident · 2 fatalField investigationFinal reportCessna 150H · Morrisville, NYThe pilot's failure to maintain airspeed and her exceedance of the airplane's critical angle-of-attack, which led to an aerodynamic stall, following a total loss of engine power for reasons that could not be determined because postaccident examination of the…NTSB CEN15WA456Accident · 1 fatalForeign investigationAmateur Construction Glasair RG · Muhen, SwitzerlandOn September 20, 2015, about 1000 hours universal coordinated time, a Glassair RG airplane, Swiss registration HB-YEA was destroyed when it impacted an automobile and burst into flames during a forced landing following a loss of engine power near Muhen,…NTSB GAA15CA277Accident · No injuriesData collectionFinal reportMooney M20M · Manville, NJThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and collision with a fence.NTSB GAA15CA273Accident · No injuriesData collectionFinal reportPiper PA 20 · Marshfield, MAThe pilot's loss of directional control during the landing roll, which resulted in a ground loop and impact with terrain.NTSB GAA15CA272Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 20 C1 · Sanford, NCThe student pilots failure to maintain a climb after takeoff, which resulted in an impact with terrain.NTSB ERA15LA369Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Pittsburg, PAAn engine fire, which resulted from the overpriming of a hot engine.NTSB ERA15LA368Accident · No injuriesLimited investigationFinal reportCessna 150M · Mount Airy, MDThe in-flight fatigue failure of the No. 4 cylinder barrel, which resulted in a total loss of engine power.NTSB ERA15LA367Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW 19B · Saratoga Springs, NYThe pilot's failure to maintain glider control while attempting to land.NTSB ERA15LA365Accident · Minor injuriesLimited investigationFinal reportClark 1000 · Warehouse Point, CTThe pilot’s failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's decision to…NTSB ERA15LA363Accident · Serious injuriesLimited investigationFinal reportCessna 172E · Gettysburg, PAThe total loss of engine power due to carburetor icing. Contributing to the accident was the pilot's failure to maintain a proper approach speed during the forced landing, which resulted in impact with trees.NTSB ERA15CA364Accident · Minor injuriesData collectionFinal reportHughes 269B · Hartford, ALThe pilot's inadequate preflight planning, and his subsequent failure to attain adequate altitude during takeoff, which resulted in a collision with a wire fence.NTSB CEN15LA444Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · New Orleans, LAThe collapse of the landing gear for reasons that could not be determined based on the available information.NTSB ANC15LA073Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Fort Glenn, AKThe separation of the tail rotor gearbox from the tailboom attachment point due to overstress loads imposed by a tail rotor blade imbalance as the result of impact with an undetermined object during low-level flight operations.NTSB WPR15LA261Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Forest Grove, ORA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB GAA15CA268Accident · No injuriesData collectionFinal reportHelio H 395 · Bethel, AKThe pilot's failure to maintain a positive climb rate during takeoff initial climb, resulting in an uncontrolled descent and collision with trees and terrain.NTSB GAA15CA264Accident · No injuriesData collectionFinal reportAviat A1 · Rock Springs, WYThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA15FA361Accident · 1 fatalField investigationFinal reportCessna U206 · Spring Hill, FLThe pilot's failure to maintain a stabilized instrument approach, which resulted in a loss of control.NTSB WPR15LA264Accident · Minor injuriesLimited investigationFinal reportDouglas A4N · Phoenix, AZThe pilot’s failure to extend the landing gear before landing. Contributing to the accident were the pilot’s distraction during the downwind leg and his difficulty seeing the landing gear indicators due to the sun angle and shadows.NTSB GAA15CA299Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Wellington, OHThe pilot's failure to level the wings during the landing flare, which resulted in the left wing striking the runway.NTSB CEN15LA416Accident · Serious injuriesLimited investigationFinal reportCessna R172 · College Station, TXThe total loss of engine power due to the fatigue failure of the No. 1 connecting rod. Contributing to the accident was the manufacturer’s exclusion of the accident engine (by serial number) in a revision of a service bulletin.NTSB GAA15CA274Accident · No injuriesData collectionFinal reportCessna 172N · Herington, KSThe pilot's failure to maintain pitch control during the landing roll, which resulted in a porpoise.NTSB GAA15CA266Accident · Minor injuriesData collectionFinal reportSchweizer G 164B · Paxton, NEThe pilot's failure to maintain adequate distance from a power line during low altitude flight operations, which resulted in an impact with the power line, and subsequent impact with the ground.NTSB ERA15FA359Accident · 5 fatalField investigationFinal reportBoatright Waylon RV10 · Alma, GAThe noncertificated pilot's decision to perform aerobatic maneuvers in his overweight, improperly-loaded airplane in dark night conditions at low altitude, which resulted in a loss of airplane control and collision with terrain. Contributing to the accident…NTSB DCA15WA198Incident · No injuriesForeign investigationBoeing 777 · Miami, FLThe National Transportation Safety Board (NTSB) has delegated the investigation of an incident involving a Qatar Airways Boeing 777-300, that occurred on September 15, 2015, to the Civil Aviation Authority (CAA) of Qatar. The NTSB has appointed a U.S.…NTSB CEN15LA414Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Nutwood, ILA partial loss of engine power due to the undetected loosening of the four carburetor bolts that connect the throttle body to the bowl assembly.NTSB ERA15LA360Accident · No injuriesLimited investigationFinal reportJ. Schilling S-19 · East Falmouth, MAThe experimental airplane builder's failure to properly secure the stabilator trim tab push-pull tube’s connection, which resulted in the tube’s separation and a subsequent hard landing. Contributing to the accident was the pilot/owner's failure to detect the…NTSB ANC15FA071Accident · 3 fatalField investigationFinal reportDehavilland DHC 3T · Iliamna, AKThe pilot's decision to depart in dark night, visual meteorological conditions over water, which resulted in his subsequent spatial disorientation and loss of airplane control. Contributing to the accident was the pilot's failure to determine the airplane's…NTSB GAA15LA281Accident · No injuriesLimited investigationFinal reportDehavilland DHC 2 MK.I · Nikolai, AKA loss of directional control during a water takeoff for reasons that could not be determined because the airplane was not examined due to the remote accident location.NTSB ERA15LA358Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Manteo, NCThe inadvertent lodging of the banner-tow cable between the right elevator and horizontal stabilizer after the pilot threw the grapple hook out the window, which resulted in the loss of pitch control and the airplane’s subsequent impact with water.NTSB DCA15WA197Incident · No injuriesForeign investigationBoeing 737 · Frankfort, GermanyThe German Federal Bureau of Aircraft Accident Investigation (BFU) has notified the NTSB of an incident involving a Boeing 737-800 that occurred on September 14, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU investigation…