NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 ANC06LA109Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK.1 · Anaktuvuk Pass, AKThe pilot's failure to abort the takeoff at his predetermined reference point, which resulted in a collision with the shore during takeoff-initial climb, and structural damage to the airplane.NTSB LAX06CA276Accident · No injuriesData collectionFinal reportInterstate S-1A · Buckeye, AZthe in-flight separation of the control stick. A contributing factor was the rough terrain for the forced landing, which resulted in a collapsed landing gear.NTSB ANC06LA105Accident · Serious injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Anchorage, AKThe flight instructor's failure to maintain sufficient airspeed to avoid a stall during a turn to reverse direction, which resulted in an inadvertent stall and a loss of control. Factors associated with the accident are the inadvertent stall, and the flight…NTSB CHI06CA221Accident · No injuriesData collectionFinal reportAir Tractor AT-400 · Springfield, MNThe pilot's inability to maintain directional control of the airplane as a result of the partial failure of the tail wheel assembly. A factor associated with the accident was the crop that the airplane contacted.NTSB ANC06LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Anchorage, AKThe possible loss of engine power during takeoff/initial climb for an unknown reason, which resulted in a forced landing in rough terrain and a nose over.NTSB ANC06LA103Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-3 · Juneau, AKThe pilot's failure to maintain altitude/clearance during approach, which resulted in the airplane impacting the surface of the water. Factors associated with the accident were the flat-light and glassy water conditions, which affected the pilot's ability to…NTSB ANC06LA102Accident · Serious injuriesLimited investigationFinal reportLiberty XL2 · Ormond Beach, FLThe pilot's improper recovery from a bounced landing, and failure to maintain minimum airspeed during the subsequent aborted landing, which resulted in an inadvertent stall and impact with terrain. A factor associated with the accident was the inadvertent…NTSB SEA06CA151Accident · No injuriesData collectionFinal reportCessna 180H · Hailey, IDThe pilot's failure to maintain directional control of the airplane during taxi, which resulted in a nose over. A factor was the wind gust condition.NTSB SEA06CA150Accident · No injuriesData collectionFinal reportCessna 180J · Hailey, IDThe pilot's failure to adequately compensate for wind conditions.NTSB NYC06LA187Accident · 1 fatalLimited investigationFinal reportBurleigh SeaRey · Ringoes, NJThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall. Factors included a partial loss of engine power for undetermined reasons.NTSB NYC06CA188Accident · No injuriesData collectionFinal reportCessna 120 · Ashland, KYThe pilot's improper fuel tank selection, which resulted in fuel starvation and a subsequent loss of engine power. A factor in the accident was the trees.NTSB DEN06FA107Accident · 2 fatalField investigationFinal reportAmerican Champion 7KCAB · Winter Park, COThe pilot's failure to maintain adequate airspeed to avoid a stall while maneuvering at a low altitude in mountainous terrain. Factors associated with the accident are the pilot's performance of a low altitude flight maneuver, an inadvertent stall/spin, and…NTSB CHI06FA224Accident · 1 fatalField investigationFinal reportAmerican Legend AL11C · Chicago, ILThe failure of both pilots to assure that the fuel cap was securely in place prior to takeoff which resulted in fuel siphoning and untimately fuel exhaustion. An additional cause was the decision to fly over the lake outside of gliding distance to shore along…NTSB CHI06FA206Accident · 1 fatalField investigationFinal reportGrumman TBM-3 · Oshkosh, WIThe Avenger pilot's visual lookout was inadequate and he failed to maintain clearance from the RV-6. Contributing factors were the Avenger's restricted visibility and the RV-6.NTSB CHI06CA222Accident · Minor injuriesData collectionFinal reportRockwell S2R · Park Rapids, MNA loss of engine power for undetermined reasons and the inadequate airspeed during the forced landing which resulted in a stall/mush. A factor was the low altitude at which the airplane was being operated.NTSB CHI06CA209Accident · No injuriesData collectionFinal reportCessna 180M · Chisholm, MNThe pilot's inadequate compensation for the wind condition. A factor associated with the accident was the gusty wind condition.NTSB SEA06CA148Accident · No injuriesData collectionFinal reportCessna 172F · American Falls, IDThe pilot's failure to maintain an airspeed above stall speed. Factors include his improper decision to takeoff with a tailwind, and the effects of the tailwind upon the aircraft's takeoff performance.NTSB NYC06CA189Accident · No injuriesData collectionFinal reportCessna 172P · Poughkeepsie, NYThe student pilot's improper flare and failure to recover from a bounced landing, which resulted in a hard landing.NTSB LAX06CA268Accident · No injuriesData collectionFinal reportCessna 414A · Ontario, CAthe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB LAX06CA250Accident · Minor injuriesData collectionFinal reportRobinson R-22B · Chino, CAthe certified flight instructor's inadequate supervision and incorrect remedial action. A factor was the student pilot's loss of control in a hovering turn.NTSB DFW06CA194Accident · Serious injuriesData collectionFinal reportCurtiss-Wright Travel Air 4000 · Jackson, MSThe pilot's failure to maintain airspeed on final approach resulting in an inadvertent stall and a subsequent loss of control.NTSB CHI06FA210Accident · 6 fatalClass 1 · FieldFinal reportde Havilland DHC-6-100 · Sullivan, MOthe pilot's failure to maintain airspeed following a loss of power in the right engine due to the fracturing of compressor turbine blades for undetermined reasons. Contributing to some parachutists' injuries was the lack of a more effective restraint system…NTSB ATL06CA113Accident · No injuriesData collectionFinal reportCessna 208 · Riceboro, GAThe pilot's failure to achieve the proper takeoff distance on a short water runway resulting in an in-flight collision with a berm and a marshy area on initial takeoff climb.NTSB ANC06FAMS1Accident · 3 fatalMissing aircraftFinal reportAero Commander 690A · Anchorage, AKUndetermined; the airplane and its occupants are missing.NTSB SEA06TA152Accident · No injuriesFinal reportCessna TU206G · Lowman, IDThe pilot's loss of aircraft control due to a downdraft on short final followed by an uncontrolled descent to a hard landing.NTSB LAX06LA249Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Independence, CAthe pilot's inadequate preflight and in-flight planning regarding the selection of the altitude and route of flight, which resulted in a collision with terrain in a box canyon after encountering mountain wave.NTSB LAX06LA247Accident · Minor injuriesLimited investigationFinal reportRobinson R44 · Flagstaff, AZthe pilot's inadequate preflight planning decision to take off under a low ceiling into an area of mountainous terrain that resulted in an encounter with lowering clouds and forced the pilot to land in unfavorable terrain.NTSB LAX06LA246Accident · 2 fatalLimited investigationFinal reportCessna 177B · Kalaupapa, HILoss of aircraft control during cruise flight for undetermined reasons. Clouds, rain, and dark night conditions were factors.NTSB DEN06CA106Accident · No injuriesData collectionFinal reportCessna 140 · Cunningham, KSthe pilot's failure to maintain directional control during the aborted takeoff. A contributing factor was the mud.NTSB DCA06FA058Accident · No injuriesField investigationFinal reportBoeing MD-10-10F · Memphis, TNthe failure of the left main landing gear due to fatigue cracking in the air filler valve hole on the aft side of the landing gear. The fatigue cracking occurred due to the presence of stray nickel plating in the air filler valve hole. Contributing to this…NTSB ANC06CA106Accident · No injuriesData collectionFinal reportTaylorcraft F19 · Hoonah, AKThe pilot's delayed go-around during an aborted landing, which resulted in an in-flight loss of control and impact with terrain. A factor associated with the accident was high vegetation.NTSB NYC06WA186Accident · 1 fatalForeign investigationPiper PA-28RT-201T · Guipuzcoa, SpainNTSB NYC06LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Blacksburg, VAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff, and subsequent collision with trees.NTSB NYC06FA184Accident · Minor injuriesField investigationFinal reportBoeing 737-300 · Pittsburgh, PAThe airplane tug driver's inadvertent movement of the tug gear shift lever from forward to reverse, which resulted in the nose landing gear collapse. Contributing to the accident was the defective gear shift lever.NTSB ENG06RA025Incident · No injuriesForeign investigationCanadair CL600-2B19-200 · Barcelona, Spain, SpainNTSB DFW06FA193Accident · 2 fatalField investigationFinal reportMooney M20J · Newellton, LAThe pilot's continued flight into adverse weather conditions. Contributing factors were the prevailing thunderstorms, the dark night conditions, and Air Traffic Control's failure to issue hazardous weather information to the pilot.NTSB DEN06CA108Accident · Serious injuriesData collectionFinal reportFirefly Balloons Galaxy 11B · Albuquerque, NMfuel exhaustion, resulting in the pilot's inability to relight one of two burners, and resulting in a hard landing.NTSB DEN06CA105Accident · No injuriesData collectionFinal reportSchweizer G-164B · Joes, COA loss of engine power due to the failure of the supercharger. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB CHI06LA220Accident · Serious injuriesLimited investigationFinal reportBeech 95-B55 · Harmon, ILThe exhaustion of the fuel supply due to the pilot's failure to ensure an adequate suppy of fuel for the flight.NTSB ANC06LA100Accident · Serious injuriesLimited investigationFinal reportEurocopter AS 350B2 · Skagway, AKThe pilot's failure to maintain adequate clearance from trees while hovering, which resulted in a main rotor strike with trees, an uncontrolled descent, and a collision with terrain.NTSB SEA06CA149Accident · No injuriesData collectionFinal reportMaule M-7-235C · Auburn, WAThe loss of directional control [not possible] during landing roll as a result of the disconnected tail wheel steering assembly [for undetermined reasons], which led to an inadvertent ground loop during the landing roll.NTSB LAX06CA245Accident · Minor injuriesData collectionFinal reportCessna 150J · Napa, CAa loss of engine power due to fuel starvation. The fuel starvation was the result of the pilot's inadequate preflight preparation (failure to refuel the airplane before taking off) and his inadequate in-flight decision (to make right turns while holding) that…NTSB DEN06CA104Accident · Serious injuriesData collectionFinal reportTop Dog 582 · Pleasanat View, COthe pilot's improper flare resulting in a hard landing.NTSB CHI06CA204Accident · Minor injuriesData collectionFinal reportCessna 172N · Wadsworth, OHThe pilot used an improper aborted takeoff procedure in that she failed to reduce the engine power. Factors associated with the accident were the tailwind, the wrong runway selection, the pilot's lack of experience, the guard rail, and the embankment.NTSB CHI06CA201Accident · Minor injuriesData collectionFinal reportBeech A36 · Mason, MIThe pilot's failure to maintain adequate airspeed which resulted in a stall/mush on takeoff. Factors associated with the accident were the building and vehicles that were contacted.NTSB SEA06FA146Accident · 2 fatalField investigationFinal reportSpectrum Aeronautical 33 · Spanish Fork, UTIncorrect installation by company maintenance personnel of the aft upper torque tube bell crank resulting in roll control that was opposite to that commanded in the cockpit. Contributing factors were the lack of maintenance documentation detailing the…NTSB LAX06CA244Accident · No injuriesData collectionFinal reportCessna 182D · Santa Clarita, CAA loss of engine power due to fuel exhaustion. The fuel exhaustion was the result of a split O-ring on the right fuel cap, which allowed fuel to siphon out of the right fuel tank during flight.NTSB DFW06LA191Accident · No injuriesLimited investigationFinal reportCessna R182 · McAlester, OKThe in-flight fuel leak and fire as result of electrical arcing of a fuel line connecting the engine driven fuel pump and the electric fuel pump.NTSB ANC06LA099Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Palatka, FLThe pilot's failure to maintain adequate airspeed to preclude a stall during the landing flare/touchdown, which resulted in a hard landing, a collapsed nose gear assembly, and a nose over. A factor associated with the accident was an inadvertent stall.NTSB SEA06CA176Accident · No injuriesData collectionFinal reportCessna 185 · Cove, ORThe pilot’s failure to maintain directional control during the takeoff roll. Factors include wet grass and trees.