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 ERA16LA296Accident · No injuriesLimited investigationFinal reportMantell Allan T Kitfox 4 1200 · Canandaigua, NYThe failure of the right rudder pedal torque tube due to fatigue, which resulted in a loss of directional control during landing. Also causal to the accident was the airplane owner/builder's failure to install a rudder torque tube reinforcement or replacement…NTSB GAA16CA443Accident · No injuriesData collectionFinal reportCessna A185 · Klamath Falls, ORThe pilot's improper landing flare, which resulted in the airplane porpoising and the subsequent loss of directional control.NTSB GAA16CA440Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Palmer, AKThe pilot's excessive brake application during the landing roll resulting in a nose over.NTSB ERA16LA300Accident · No injuriesLimited investigationFinal reportCessna 150 · Littleton, MAA total loss of engine power during descent for reasons that could not be determined because postaccident examination of the airframe and engine revealed no anomalies that would have precluded normal operation.NTSB ERA16LA295Accident · No injuriesLimited investigationFinal reportPiper PA34 · Hollywood, FLMaintenance personnel’s failure to comply with an airworthiness directive for the propeller, which resulted in a propeller hub failure due to fatigue.NTSB CEN16LA326Accident · 1 fatalLimited investigationFinal reportThrush S2R T660 · Ruthton, MNThe pilot's failure to see and avoid the tower guy-wire during an agricultural spraying operation.NTSB CEN16FA328Accident · 1 fatalField investigationFinal reportAero Commander S2R · Center, COThe pilot's failure to maintain airplane control during a low-level maneuver, which resulted in an aerodynamic stall.NTSB WPR16FA166Accident · Minor injuriesField investigationFinal reportDouglas TA-4K · Las Vegas, NVForeign object debris in the engine's main fuel control unit, which restricted fuel flow and subsequently resulted in the loss of engine power. Contributing to the accident was the installation or addition of an extra seal during the main fuel control unit…NTSB GAA16CA439Accident · No injuriesData collectionFinal reportBell 206 L4 · Broussard, LAThe pilot's failure to attain a proper touchdown point, which resulted in the helicopter sliding off the aft end of the transport dolly.NTSB CEN16LA329Accident · Serious injuriesLimited investigationFinal reportCollins RV6A · Pekin, ILThe pilot's failure to latch the canopy before takeoff, and his subsequent distraction and failure to maintain control while attempting to close the open canopy, which resulted in an aerodynamic stall.NTSB GAA16CA455Accident · No injuriesData collectionFinal reportCessna U206 · Sleetmute, AKThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall and a hard landing.NTSB GAA16CA441Accident · No injuriesData collectionFinal reportValloric Carl Stephen Valloric Sport Trnr · Cadiz, OHThe pilot's failure to maintain directional control during landing and the unintentional right brake application, which resulted in a runway excursion and a nose over.NTSB GAA16CA437Accident · No injuriesData collectionFinal reportCessna 152 · Belle Plaine, MNThe student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.NTSB GAA16CA434Accident · No injuriesData collectionFinal reportCessna 182 · Anchorage, AKThe pilot's failure to maintain a controlled landing flare, which resulted in a hard landing. Contributing to the accident was the pilot's inattention and distraction.NTSB ERA16CA294Accident · No injuriesData collectionFinal reportCessna 152 · Newnan, GAThe student pilot's improper decision to land long and maintain excessive speed during the landing roll. Contributing to the accident was the student pilot's decision to maintain full flaps and aft yoke inputs at a higher speed, reducing his ability to stop…NTSB DCA16CA214Accident · Serious injuriesData collectionFinal reportBoeing 737 924 · Waco, TXan encounter with convective turbulence.NTSB GAA16CA436Accident · No injuriesData collectionFinal reportPiper PA18 · Anchor Point, AKThe pilot's failure to maintain clearance from obstacles while landing on a coastal beach.NTSB ERA16WA298Accident · 2 fatalClass 3 · ForeignCessna 550 · Charallave, VenezuelaNTSB DCA16WA240Accident · No injuriesForeign investigationCessna 401 · Antalaha, MadagascarNTSB CEN16WA345Accident · No injuriesForeign investigationRobinson R44 · Plasy, CzechiaNTSB GAA16CA432Accident · No injuriesData collectionFinal reportCessna 150 · North Conway, NHThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, a forced landing, and nose over.NTSB GAA16CA473Accident · No injuriesData collectionFinal reportCessna 172 · Fulton, MOThe pilot’s improper landing flare and subsequent improper recovery from a bounced landing, which resulted in the airplane porpoising.NTSB GAA16CA430Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 6U · Llano, CAThe pilot’s failure to properly secure the two aft canopy latches during the preflight inspection, which resulted in the canopy separating from the glider during the takeoff roll and substantial damage to the vertical stabilizer.NTSB ERA16WA292Accident · Serious injuriesForeign investigationEurocopter AS355 · Santo Domingo, Dominican RepublicOn August 14, 2016, about 2040 coordinated universal time, a Eurocopter AS355 F2, Dominican registration HI-861, was substantially damaged during a hard landing at the La Isabela International Airport (MDJB), Santo Domingo, Dominican Republic. The pilot was…NTSB ERA16FA289Accident · 6 fatalField investigationFinal reportPiper PA 31 · Northport, ALA total loss of power in both engines due to fuel starvation as a result of the pilot's fuel mismanagement, and his subsequent failure to follow the emergency checklist. Contributing to the pilot's failure to follow the emergency checklist was his lack of…NTSB CEN16LA324Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Lino Lakes, MNA partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with vegetation and terrain during takeoff.NTSB GAA16CA454Accident · No injuriesData collectionFinal reportPiper PA 34 · Fort Lauderdale, FLThe other pilot's failure to ensure that the brake was fully engaged and his subsequent failure to notice that his airplane was rolling forward, which resulted in it hitting another airplane.NTSB GAA16CA429Accident · No injuriesData collectionFinal reportConsolidated Vultee BT13 · Joseph, ORThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and damage to the left aileron and elevator.NTSB ERA16LA293Accident · No injuriesClass 3 · LimitedFinal reportCessna 150G · Shirley, NYMaintenance personnel’s inadequate maintenance and inspection of the airplane, which resulted in the left elevator attachment bolt backing out of the nutplate, and partial inflight separation and damage of the elevator.NTSB ERA16LA291Accident · Serious injuriesLimited investigationFinal reportLuscombe 8 · Marlboro, NJThe pilot's inadequate in-flight fuel management, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB CEN16LA323Accident · Minor injuriesLimited investigationFinal reportCessna TU206C · Skiatook, OKA total loss of engine power after takeoff for reasons that could not be determined based on the available information.NTSB CEN16LA320Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Des Moines, IAThe two separations in the induction system due to improper installation and/or maintenance, which resulted in a partial loss of engine power during initial climb.NTSB ANC16LA059Accident · No injuriesLimited investigationFinal reportWight Carbon CUB CCK-1865 · Wasilla, AKThe failure of the tailwheel suspension assembly during landing due to preexisting fatigue fractures in the suspension system, which resulted in a loss of directional control.NTSB ANC16FA057Accident · 1 fatalField investigationFinal reportChampion 7ECA · Chugiak, AKThe pilot's failure to maintain proper airspeed and his exceedance of the airplane's critical angle of attack during a steep low-altitude turn following a loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control at too low…NTSB WPR16LA165Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Gunnison, UTA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR16LA164Accident · Minor injuriesLimited investigationFinal reportZenith CH601 · Ocean Shores, WAA reduction in electrical power, which disabled both fuel pumps and resulted in fuel starvation and a loss of engine power.NTSB GAA16CA431Accident · No injuriesData collectionFinal reportCessna 152 · Hillsboro, ORThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the engine mount.NTSB GAA16CA428Accident · No injuriesData collectionFinal reportGrumman American Avn. AA 5A · Reno, NVThe pilot's failure to see and avoid fence posts during landing, which resulted in substantial damage to the wings.NTSB ERA16FA288Accident · 6 fatalField investigationFinal reportBeech 95 B55 (T42A) · Fredericksburg, VAThe pilot(s) failure to maintain adequate airspeed during an attempted go-around, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB ERA16CA290Accident · Serious injuriesData collectionFinal reportKessinger Roger L Rans Coyote · London, KYThe student pilot's improper recovery from a bounced landing and his subsequent failure to maintain clearance from trees during an attempted go-around.NTSB DCA16IA215Incident · Minor injuriesIncident investigationFinal reportAirbus A320 232 · Wood, SDan inadvertent encounter with convective turbulence while in cruise flight.NTSB CEN16WA395Accident · Serious injuriesForeign investigationBell 206 · Sayaxché, GuatemalaOn August 12, 2016, about 1500 universal coordinated time (UTC), a Guatemalan-registered Bell 206-L3 helicopter, TG-CHB, crashed near Sayaxche, Guatemala. The pilot was seriously injured, one passenger received minor injuries, and two passengers were…NTSB GAA16CA433Accident · No injuriesData collectionFinal reportMaule MXT7 · Quitman, ARThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over. Contributing to the accident was the pilot's limited forward visibility due to sun glare.NTSB GAA16CA427Accident · No injuriesData collectionFinal reportPiper PA28 · Hamburg, NYThe pilot's failure to perform a go-around, which resulted in a landing area overshoot, a runway overrun, a landing gear collapse, and a collision with a guard rail.NTSB CEN16WA325Accident · 1 fatalForeign investigationPiper PA38 · Peterborough, CanadaOn August 11, 2016, at 0520 coordinated universal time, a Piper PA-38-112, Canadian-registered C-FSYH, was damaged when it struck several metal poles during a forced landing near Peterborough, Ontario, Canada. Visual meteorological conditions prevailed at the…NTSB GAA16CA425Accident · No injuriesData collectionFinal reportAmerican Legend AL3 · San Diego, CAThe pilot's failure to maintain directional control during landing with a crosswind.NTSB DCA16CA211Accident · No injuriesData collectionFinal reportBoeing 737 832 · New York, NYinadvertent collision by ground service vehicle.NTSB CEN16LA322Accident · Serious injuriesLimited investigationFinal reportPiper J5C · Sandusky, MIThe pilot's improper landing flare, which resulted in a bounced landing, and a subsequent loss of control followed by a runway excursion.NTSB CEN16FA315Accident · 1 fatalField investigationFinal reportHughes 269C · Howe, TXThe improper execution of an autorotation following the loss of engine power, which resulted in an uncontrolled descent into terrain. Contributing to the accident was the flight instructor's lack of remedial action during the autorotation.NTSB ERA16WA287Accident · 2 fatalForeign investigationCessna 172 · Fredonia, ColombiaOn August 9, 2016, about 2156 universal coordinated time, a Cessna 172N, Colombian registration HK4822G, was substantially damaged when it impacted terrain near Fredonia, Antioquia, Colombia. The flight instructor and student pilot were fatally injured and…