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 DCA16CA208Accident · Serious injuriesData collectionFinal reportEmbraer ERJ 170 100 SE · Cleveland, OHan inadvertent encounter with turbulence.NTSB CEN16FA286Accident · Minor injuriesClass 3 · FieldFinal reportEmbraer EMB-505 · Sugar Land, TXThe airplane’s hydroplaning during the landing roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s continuation of an unstabilized approach, his decision to land in heavy rain conditions, and his improper use of the main…NTSB GAA16CA393Accident · No injuriesData collectionFinal reportCessna 188 · What Cheer, IAThe loss of engine power for undetermined reasons due to the pilot not making the airplane or engine available for examination, which resulted in a forced landing and an impact with terrain.NTSB ERA16FA269Accident · 1 fatalField investigationFinal reportYakovlev YAK11 · West Mifflin, PAA malfunction of the electrical system, which resulted in an electrical fire in the right wing root of the airplane, which compromised the fuel system and resulted in ignition of fuel. Contributing to the accident was the routing of the electrical wiring near…NTSB CEN16LA284Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH 13H/M74A · Minonk, ILFailure of the truck driver to ensure that he had adequate clearance to pass under the helicopter and the failure of the loader to park in a safer area for reloading operations.NTSB WPR16LA150Accident · No injuriesLimited investigationFinal reportBeech 65 A90 · Byron, CAThe pilot’s failure to maintain an adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and subsequent spin. Also causal to the accident was the pilot’s failure to follow prescribed spin…NTSB GAA16CA426Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Cordova, SCThe pilot's failure to maintain the runway heading, which resulted in the airplane not being aligned with the runway and a subsequent runway excursion.NTSB GAA16CA389Accident · Minor injuriesData collectionFinal reportCirrus Design SR22 · Hyannis, MAThe pilot's failure to maintain an appropriate descent rate during landing, which resulted in a hard landing, followed by a loss of directional control, runway excursion, and an impact with a security fence and vehicles during the subsequent attempt to abort…NTSB ERA16LA274Accident · Minor injuriesLimited investigationFinal reportAlisport Silent 2 Targa · London, KYThe pilot's failure to properly secure the right side of the canopy before takeoff, and an in-flight collision with trees while maneuvering with an open canopy. Contributing to the pilot's failure to properly secure the canopy was the lack of a visual…NTSB ERA16LA270Accident · No injuriesLimited investigationFinal reportCraig D Carter Stol CH 750 · Waynesburg, PAThe partial loss of engine power due to carburetor icing.NTSB CEN16LA283Accident · Serious injuriesLimited investigationFinal reportBristell E-LSA · Oshkosh, WIThe pilot’s exceedance of the airplane’s critical angle of attack on short final approach, which resulted in an inadvertent aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot’s distraction with other traffic in the…NTSB CEN16FA282Accident · 2 fatalField investigationFinal reportBeech 95 B55 (T42A) · Leshara, NEThe pilot's loss of airplane control during a practice stall maneuver, which resulted in a spin that continued to ground impact.NTSB WPR16LA149Accident · No injuriesLimited investigationFinal reportSwartz Gene Titan T 51 Mustang · Lancaster, CAA total loss of engine power due to the separation of a flywheel magnet, which impacted the attachment bracket for the primary and secondary ignition and disrupted the timing of the ignition system, rendering it inoperative.NTSB WPR16FA148Accident · 1 fatalField investigationFinal reportAir Tractor AT 502B · Zamora, CAThe failure of both pilots to maintain an adequate visual lookout, which resulted in a midair collision. Also causal was the other pilot's use of two sedating antihistamines and two impairing medication and the effect of sun glare on his visual lookout, which…NTSB GAA16CA395Accident · No injuriesData collectionFinal reportEngineering & Research 415 · Collinsville, OKThe pilot's failure to maintain directional control during takeoff in a high density altitude condition, which resulted in a runway excursion and impact with a tree.NTSB ERA16WA275Accident · Serious injuriesForeign investigationCessna TU206 · San Martin, ColombiaOn July 23, 2016, at 1910 coordinated universal time, a Cessna TU206G, Columbian registration HK2787, was substantially damaged following an in-flight loss of engine power and subsequent forced landing in the Municipality of San Martin, Colombia. The pilot…NTSB ERA16LA271Accident · No injuriesLimited investigationFinal reportCessna 310L · Linden, NJThe overtravel of the main landing gear (MLG) actuator, which resulted in the MLG partially collapsing upon landing. The reasons for the overtravel of the MLG actuator could not be determined due to the unavailability of the wreckage.NTSB ERA16LA268Accident · No injuriesLimited investigationFinal reportFrank Ware Velocity TXL · Sebastian, FLThe total loss of engine power due to maintenance personnel’s improper setting of the aneroid adjustment.NTSB ERA16LA267Accident · Serious injuriesLimited investigationFinal reportTemple Benjamin Freedom Master FM-2 · East Haddam, CTThe pilot’s loss of airplane control during the initial climb.NTSB GAA16CA390Accident · No injuriesData collectionFinal reportPiper PA46 · Claremore, OKThe pilot's failure to maintain directional control during takeoff after multiple climb attempts at insufficient airspeed, which resulted in a runway excursion, a landing gear collapse, and a collision with a ditch.NTSB GAA16CA387Accident · Minor injuriesData collectionFinal reportCessna 182 · Hogansville, GAThe pilot's failure to replace the left fuel cap following the preflight inspection, which resulted in fuel exhaustion, a loss of engine power, an emergency landing, and impact with terrain.NTSB ERA16LA266Accident · 1 fatalLimited investigationFinal reportRepublic RC 3 · Winter Haven, FLImproper installation of a fuel line by unknown personnel, which resulted in a total loss of engine power during initial climb due to fuel starvation.NTSB CEN16LA289Accident · Minor injuriesLimited investigationFinal reportBell OH 58A · Lake Mills, IAThe pilot's inadequate visual lookout, which resulted in a wire strike.NTSB CEN16LA287Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Dodge Center, MNA partial loss of engine power due to carburetor ice.NTSB CEN16LA281Accident · 2 fatalLimited investigationFinal reportVans RV9 · Springfield, OHThe pilot’s decision to fly into known thunderstorms, which resulted in an in-flight breakup.NTSB CEN16LA288Accident · No injuriesLimited investigationFinal reportCessna 208B · Baldwin, WIThe pilot's decision to land the fully loaded parachutist drop airplane on a wet grass runway that had insufficient length for the landing in high temperature conditions, which resulted in a runway overrun, when a more suitable longer runway was available at…NTSB CEN16FA278Accident · 2 fatalField investigationFinal reportHarris-Runyan Skybolt 300 · Fairmont, OKThe pilot's delay in recovering from an aerobatic maneuver resulting in collision with terrain.NTSB CEN16FA276Accident · 1 fatalField investigationFinal reportPiper PA 30 · Plainfield, ILThe pilot's failure to maintain airplane control during an en route climb near convective activity, which resulted in an aerodynamic stall, an uncontrolled descent, and a subsequent in-flight breakup due to an exceedance of the airplane's design load…NTSB CEN16CA277Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164A · Topeka, KSThe pilot’s failure to maintain clearance from a wire during an agricultural flight.NTSB WPR16RA151Accident · 5 fatalForeign investigationCessna 208 · Shanghai, ChinaOn July 20, 2016 about 0422 Coordinated Universal Time, a float equipped Cessna 208, B10-FW, collided with a bridge shortly after takeoff from Jinshan City Beach, Shanghai, P.R. China. The airplane was operated by Avic Joy General Aviation under the pertinent…NTSB GAA16CA391Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind HK 36 · Blanchester, OHThe pilot's failure to maintain directional control of the powered glider during the landing roll.NTSB ERA16CA302Accident · No injuriesData collectionFinal reportBeech B200 · Burnsville, NCA collision with a bush during landing.NTSB ERA16CA264Accident · Serious injuriesData collectionFinal reportAeronca 7BCM · Connellsville, PAThe pilot's failure to properly set the throttle and secure the airplane before hand-propping the engine for startup.NTSB CEN16LA275Accident · Minor injuriesClass 3 · LimitedFinal reportMeyers 200 · Huron, SDThe partial loss of engine power due an unsecured throttle cable. The reason for the unsecured throttle cable could not be determined.NTSB ANC16CA049Accident · No injuriesData collectionFinal reportCessna U206 · Cordova, AKThe pilot's improper landing flare, which resulted in a hard landing and subsequent landing gear separation and collapse.NTSB ERA16LA263Accident · No injuriesLimited investigationFinal reportTecnam P2008 · Warrenton, VAThe pilot’s decision to begin the takeoff roll with helicopter traffic on the runway, which led to a rejected takeoff. Contributing to the accident was the pilot’s improper use of the toe brakes, which he had limited experience using and resulted in a runway…NTSB CEN16LA274Accident · No injuriesLimited investigationFinal reportChance Vought F4U 5 · East Troy, WIA failure of the O-ring in the left brake master cylinder for reasons that could not be determined, which resulted in a loss of directional control during landing.NTSB CEN16LA273Accident · No injuriesLimited investigationFinal reportBrandt Sonex · Lodi, WIThe separated rocker arm assembly for undetermined reasons, which resulted in the partial loss of engine power and led to the landing gear collapsing during the subsequent forced landing.NTSB CEN16LA270Accident · Serious injuriesLimited investigationFinal reportCessna 182J · Weatherford, TXAn electrical system malfunction for reasons that could not be determined, and the subsequent loss of engine power due to the loss of the electrical boost pumps. Also causal was the pilot's improper emergency action following the loss of engine power due to…NTSB CEN16FA269Accident · 2 fatalField investigationFinal reportAeronca 11AC · Ishpeming, MIThe pilot's failure to maintain airspeed following a loss of engine power due to carburetor icing while turning from base to final at a low altitude, which resulted in the airplane's wing exceeding its critical angle of attack and a subsequent aerodynamic…NTSB ANC16LA047Accident · No injuriesLimited investigationFinal reportAeropro CZ A220 · McCarthy, AKThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a loss of control and impact with terrain. Contributing to the accident were engine power surges due to the bent carburetor throttle valve lever.NTSB ANC16LA046Accident · No injuriesLimited investigationFinal reportCessna A185 · Illiamna, AKThe overstress fracture of the left main landing (MLG) gear axle attachment bolts and the subsequent separation of the left MLG wheel, which resulted in the pilot’s inability to control the airplane.NTSB ANC16CA055Accident · No injuriesData collectionFinal reportKirbybilt Xcalibur · Valdez, AKThe pilot's failure to maintain an adequate glide path during landing, which resulted in the airplane landing short of the airstrip, a landing gear collapse, and subsequent substantial damage to the fuselage.NTSB WPR16FA144Accident · 1 fatalField investigationFinal reportDiamond Aircraft Ind DA40 F · Logan, UTThe pilot's exceedance of the airplane's critical angle of attack while maneuvering in turbulence and gusty wind conditions, which resulted in an aerodynamic stall/spin.NTSB WPR16CA145Accident · Minor injuriesData collectionFinal reportBeech 19A · Helena, MTThe pilot's failure to reposition the fuel selector valve to the on position prior to takeoff resulting in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.NTSB GAA16CA386Accident · No injuriesData collectionFinal reportCessna 172 · Chesterfield, MOThe student pilot's improper pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.NTSB GAA16CA383Accident · No injuriesData collectionFinal reportAeronca 7AC · Lenoir, NCThe pilot's encounter with instrument meteorological conditions, which resulted in an emergency descent through fog, a runway overrun on a wet grass runway, and a collision with a ditch and vegetation. Contributing to the accident was the pilot's failure to…NTSB CEN16LA271Accident · Serious injuriesLimited investigationFinal reportGerald Nelson Nelson Woody · Hope, ARThe loss of control upon landing for reasons that could not be determined.NTSB ANC16LA048Accident · No injuriesLimited investigationFinal reportStinson 108 · Haines, AKThe pilot’s failure to maintain directional control of the airplane during the landing roll with a quartering tailwind, which resulted in a ground loop and overstress failure of the left main landing gear wheel axle.NTSB WPR16LA146Accident · No injuriesLimited investigationFinal reportCessna 172 · Emmett, IDThe failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision.