Final NTSB investigations
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 WHERE c.\"completionStatus\" = 'Completed' 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 WHERE c."completionStatus" = 'Completed' 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 ERA21LA048Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Milton, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB ERA21LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Ellenville, NYThe failure of the right brake master cylinder lock seal spring washer.NTSB ERA21LA043Accident · No injuriesClass 4 · LimitedFinal reportAerospatiale AS355 · Hammonton, NJThe pilot's decision to continue the takeoff with a perceived mechanical deficiency.NTSB DCA21LA024Accident · Serious injuriesClass 4 · LimitedFinal reportBombardier CL600 2C10 · Phoenix, AZThe flight attendant’s use of improper procedures when opening the main cabin door.NTSB WPR21LA054AccidentClass 4 · LimitedFinal reportGeneral Atomics MQ-9 · Sierra Vista, AZThe pilot’s incorrect automated landing profile selection, which resulted in an impact with a runway trench. Contributing to the accident was the pilot receiving instruction's and instructor's failure to spot the incorrect landing profile selection during…NTSB WPR21LA053Accident · No injuriesClass 4 · LimitedFinal reportAir Creation Buggy · Benson, AZThe non-rated pilot’s unstable approach and failure to maintain aircraft control, which resulted in a hard landing and collision with terrain.NTSB WPR21LA051Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MX7 · Moab, UTThe pilot's failure to maintain airplane control during takeoff from an unimproved airstrip, which resulted in a nose-over.NTSB WPR21FA048Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Los Angeles, CAMaintenance personnel’s failure to properly secure the throttle control hardware during recent maintenance, which resulted in its disconnection and a subsequent loss of engine power on approach for landing.NTSB CEN21LA060Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Salem, INThe pilot’s failure to avoid an obstacle during his approach to land.NTSB CEN21LA055Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182R · Rockwall, TXThe pilot’s decision to continue an unstabilized approach and his delayed go-around decision, which resulted in the airplane’s impact with power lines and the ground. Contributing to the accident was the inaccurate wind direction reporting as a result of a…NTSB WPR21LA052Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Fallbrook, CAA partial loss of engine power for reasons that could not be determined with the available evidence.NTSB WPR21FA045Accident · 2 fatalClass 3 · FieldFinal reportCessna 177 · Langley, WAThe flight instructor’s failure to maintain airspeed, which resulted in an aerodynamic stall and subsequent loss of control while attempting to conduct an emergency landing. Contributing to the accident was a total loss of engine power as a result of…NTSB CEN21LA053Accident · 1 fatalClass 3 · LimitedFinal reportTrick Trikes Stss · Holden, MOThe noncertificated pilot’s failure to maintain aircraft control during takeoff.NTSB WPR21FA044Accident · 1 fatalClass 3 · FieldFinal reportPiper PA38 · Grass Valley, CAA total loss of engine power due to the pilot’s improper fuel management, which resulted in fuel starvation.NTSB WPR21LA061Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Arch Cape, ORThe pilot’s descent into the ocean for reasons that could not be determined.NTSB WPR21LA042Accident · Minor injuriesClass 4 · LimitedFinal reportDiamond DA40 · Mesa, AZThe pilot’s failure to maintain clearance with a vehicle while taxiing.NTSB ERA21LA041Accident · Minor injuriesClass 4 · LimitedFinal reportMooney M20C · Laconia, NHThe pilot’s failure to maintain adequate clearance from trees during an approach in sun glare and hazy conditions.NTSB ERA21LA150Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Montgomery, NYThe pilot’s failure to maintain directional control during landing, resulting in a ground loop and structural damage to the airframe.NTSB ERA21LA040Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Raleigh, NCThe pilot's loss of helicopter control after entry into vortex ring state, which resulted in main rotor blade contact with the tailboom, and impact with the ground.NTSB CEN21LA058Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Waukegan, ILThe pilot’s failure to maintain directional control during takeoff with a crosswind that resulted in a ground loop and impact with terrain.NTSB CEN21LA049Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32 · Circleville, OHThe total loss of engine power due to an accessory drive gear that backed out impeding the other gears.NTSB CEN21LA044Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-22-135 · Dunn Center, NDThe noninstrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in a loss of control.NTSB WPR21LA040Accident · Serious injuriesClass 4 · LimitedFinal reportSchleicher ASW20C · Clayton, CAThe failure of both pilots of each glider to see an avoid one another while maneuvering, which resulted in a mid-air collision.NTSB CEN21LA081Accident · No injuriesClass 4 · LimitedFinal reportSchweizer 269C · Rhame, NDThe pilot landed the helicopter on unsuitable terrain, which resulted in a rollover.NTSB CEN21LA048Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Greenville, MIThe loss of engine power due to fuel starvation during a low approach over the airport, which resulted in a forced landing and impact with terrain.NTSB CEN21LA047Accident · Serious injuriesClass 3 · LimitedFinal reportErcoupe 415 · Ardmore, OKThe pilot’s improper decision to takeoff with 3 persons in a 2-place airplane and over maximum gross weight, and his failure to apply carburetor heat when the airplane’s engine experienced carburetor ice and a partial loss of power.NTSB WPR21LA049Accident · No injuriesClass 3 · LimitedFinal reportRonald A Gawer RV-12 · Byron, CAThe total loss of engine power due to a fatigue fracture of the crankshaft.NTSB WPR21LA039Accident · Serious injuriesClass 3 · LimitedFinal reportAgusta A109 · Los Angeles, CAThe loss of tail rotor control due to the separation of the tail rotor duplex bearing ring nut from the thrust sleeve, which resulted in the loss of helicopter control.NTSB WPR21LA038Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Chandler, AZThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA21LA039Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA40 · Winder, GAThe pilot's loss of directional control while landing, which resulted in a runway excursion.NTSB CEN21LA108Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Fort Worth, TXA failure of the nose wheel landing strut for reasons that could not be determined based on available information.NTSB CEN21LA051Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR22 · Denver, COThe student pilot’s failure to maintain control of the airplane during landing with a gusting crosswind and his failure to go around and relinquish control of the airplane when directed by the instructor pilot.NTSB CEN21FA043Accident · 1 fatalClass 3 · FieldFinal reportBeech J35 · Fredericksburg, TXThe pilot of the J35’s failure to maintain clearance from the M35, which resulted in a midair collision and the J35 pilot’s subsequent loss of control and impact with terrain.NTSB ANC21LA006Accident · No injuriesClass 3 · LimitedFinal reportPilatus PC12 · Pacific Ocean (Pacific Ocean)A total loss of engine power due to fuel starvation for reasons that could not be determined based on the available evidence.NTSB CEN21LA046Accident · Minor injuriesClass 4 · LimitedFinal reportNavion A · Fremont, MIThe pilot’s improper positioning of the fuel selector during takeoff, which was not in accordance with the preflight checklist and resulted in fuel starvation, a subsequent total loss of engine power, and an aerodynamic stall during an attempted forced…NTSB CEN21LA045Accident · No injuriesClass 3 · LimitedFinal reportJust SuperSTOL · Edgard, LAThe loss of engine power for reasons that could not be determined with the available information.NTSB WPR21LA037Accident · No injuriesClass 3 · LimitedFinal reportRemos Aircraft Gmbh Flugzeugbau GX · Glendale, AZThe material overstress failure of the airframe’s aluminum carry-through of the main landing gear.NTSB WPR21LA064Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · El Monte, CAA loss of directional control during the landing roll due to an undetermined failure of the tailwheel assembly.NTSB ERA21LA037Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 180 · Warrenton, GAThe pilot’s failure to attain the proper touchdown point which resulted in a runway overrun and collision with trees.NTSB CEN21LA040Accident · Serious injuriesClass 3 · LimitedFinal reportPiper J3C · Weslaco, TXThe pilot of N87715 inadvertently allowed his airplane to drift right of the runway during the climb after a touch-and-go landing, and the pilot of N6463H did not maintain adequate separation from the other airplane during his go-around. Contributing to the…NTSB ANC21LA004Accident · 2 fatalClass 3 · LimitedFinal reportAutoGyro MTO Sport · Whitewater, KSA loss of control for reasons that could not be determined based on the available evidence.NTSB WPR21LA035Accident · Minor injuriesClass 4 · LimitedFinal reportCarbon Cub · Camano, WAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall while maneuvering to final approach.NTSB WPR21LA034Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Legend AL-3 Cub · Minden, NVThe pilot's failure to maintain directional control during landing, which resulted in the airplane nosing over.NTSB ERA21LA038Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA22 · Warner Robins, GAThe pilot’s improper compensation for shifting wind conditions, which resulted in a runway excursion and a subsequent nose over.NTSB ERA21LA036Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon 400A · Fernandina Beach, FLThe flight crew's improper decision to land with a tailwind on a wet runway, which resulted in a runway overrun. Contributing to the accident was the copilot’s early retraction of the speed brakes and the pilot’s decision to turn off the anti-skid system.NTSB ERA21LA035Accident · 3 fatalClass 3 · LimitedFinal reportGrumman GA7 · Ellicott, NYThe pilot’s continued descent below the minimum descent altitude while conducting an instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR21LA032Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · Billings, MTThe pilot’s failure to maintain the proper descent glide path while on final approach for reasons that could not be determined from available evidence.NTSB CEN21LA233Accident · No injuriesClass 3 · LimitedFinal reportCessna 140 · Edinburg, TXThe collapse of the airplane’s left main landing gear for a reason that could not be determined based upon the available evidence.NTSB WPR21LA031Accident · No injuriesClass 4 · LimitedFinal reportPearson Starduster · Cedar City, UTA loss of directional control for reasons that were not determined due to lack of available evidence.NTSB WPR21LA030Accident · 2 fatalClass 3 · LimitedFinal reportCessna 310 · Las Vegas, NVThe pilot’s failure to maintain the airplane’s minimum controllable airspeed while maneuvering with one engine inoperative. Also causal was the loss of power in the left engine due to oil starvation. Contributing to the accident were inadequate maintenance…