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 CEN22LA399Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Sullivan, INThe pilot’s failure to maintain directional control during landing.NTSB CEN22LA391Accident · No injuriesClass 3 · LimitedFinal reportBeech F33A · Baton Rouge, LAThe sudden and total loss of fuel flow to the engine for undetermined reasons.NTSB CEN22LA443Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Owasso, OKThe student pilot’s failure to maintain a proper descent rate during the short field landing.NTSB WPR22LA307Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Bountiful, UTThe pilot’s improper landing flare and subsequent loss of airplane control during a go-around when the airplane stalled and collided with the ground.NTSB ERA22LA374Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Westfield, MAThe pilot’s loss of directional control while taxiing for takeoff.NTSB CEN22LA387Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Millville, MNThe pilot’s inadequate inflight planning resulted in impact with a power line.NTSB WPR22LA305Accident · No injuriesClass 4 · LimitedFinal reportHughes Helicopters 369E · Ely, NVThe pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.NTSB WPR22FA304Accident · 2 fatalClass 3 · FieldFinal reportAviat A-1A · Yellow Pine, IDThe pilot's failure to maintain adequate airspeed during an initial climb, which resulted in the exceedance of the critical angle of attack, subsequent aerodynamic stall, and impact with terrain. Contributing was the pilot’s decision to operate the airplane…NTSB ERA22LA371Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Talladega, ALA collision with a deer during takeoff.NTSB CEN22LA388Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28 · Lucedale, MSThe pilot’s failure to maintain directional control while landing on the wet turf runway with a higher speed.NTSB WPR22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna L-19E · Moriarty, NMThe pilot’s failure to maintain directional control and the flight instructor's inadequate remedial action during the landing roll, which resulted in a ground loop.NTSB ERA22LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Gardiner, NYThe pilot’s failure to go-around in a timely manner which resulted in a collision with a fence.NTSB WPR22LA374Accident · No injuriesClass 4 · LimitedFinal reportIca Brasov IS-28B2 · Deer Park, WAThe pilot’s improper landing flare which resulted in a hard landing.NTSB WPR22LA302Accident · Minor injuriesClass 3 · LimitedFinal reportGoddard Dick Sim Bensen B-8M · Corona, CAThe fatigue failure of the engine mount resulting in a loss of engine power and directional control while maneuvering.NTSB WPR22FA303Accident · 2 fatalClass 3 · FieldFinal reportCessna T207A · Page, AZThe total loss of engine power for undetermined reasons during low altitude cruise flight, which resulted in a water ditching. Contributing to the severity of the accident was the pilot’s failure to extend the flaps during the ditching, which increased the…NTSB ERA22LA372Accident · Minor injuriesClass 3 · LimitedFinal reportThomas Wayne L THOMAS' Flyer · Searsmont, MEA total loss of engine power during the initial climb for reasons that could not be determined.NTSB CEN22LA390Accident · No injuriesClass 4 · LimitedFinal reportAero Commander 100-180 · Pueblo, COThe flight instructor’s failure to maintain adequate airspeed during the demonstrated soft-field takeoff, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.NTSB CEN22FA383Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · Hanna City, ILA total loss of engine power due to fuel exhaustion.NTSB ERA22LA369Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Jamestown, NYA partial loss of engine power for reasons that could not be definitively determined.NTSB CEN22LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Kearney, NEThe pilot’s inadequate in-flight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB ANC22LA068Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 180 · Sutton-Alpine, AKA total loss of engine power due to fuel exhaustion.NTSB ANC22LA065Accident · Minor injuriesClass 4 · LimitedFinal reportCessna R172K · Fairbanks, AKThe pilot’s failure to maintain control of the airplane during landing.NTSB WPR22LA301Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Laurel, MTThe loss of climb performance due to undetermined reasons.NTSB WPR22LA299Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Palmer, AKThe pilot’s failure to maintain lateral control during an off-field landing, which resulted in loss of control and an impact with terrain.NTSB ERA22FA368Accident · 3 fatalClass 3 · FieldFinal reportPiper PA32 · Metz, WVThe non-instrument-rated pilot’s intentional visual flight into instrument meteorological conditions based on latent weather information, which resulted in the airplane entering extreme precipitation, a loss of aircraft control, and in-flight break-up.NTSB ANC22FA066Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Arctic Village, AKThe pilot’s decision to depart in turbulent and gusting wind conditions, which resulted in a loss of control and impact with terrain.NTSB WPR22LA300Accident · No injuriesClass 4 · LimitedFinal reportHoffman David J Murphy Elite · Manley Hot Springs, AKThe pilot’s unstable approach to land, which resulted in a hard landing.NTSB WPR22FA298Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Blyn, WAThe pilot’s continued operation of the airplane with known mechanical malfunctions with the flight displays, and his continued flight into instrument meteorological conditions, which resulted in an inflight collision with terrain while maneuvering.NTSB ERA22LA377Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lehighton, PAThe pilot failure to ensure the runway was clear before landing, resulting in a runway excursion and collision with runway lights.NTSB CEN22LA389Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Appleton, MNThe pilot’s failure to maintain directional control during the takeoff roll with a quartering tailwind.NTSB CEN22LA385Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Sparta, MIThe pilot’s delayed decision to reject the takeoff, resulting in a runway excursion and impact with a fence.NTSB ANC22LA067Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain directional control of the airplane during the takeoff roll following a hard landing.NTSB WPR22LA296Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Corona, CAThe airplane’s partial loss of engine power during the landing for reasons that could not be determined based on the available evidence, which resulted in an off airport landing and subsequent fire.NTSB CEN22LA386Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Onalaska, TXThe pilot’s failure to maintain directional control during takeoff from a lake in gusting wind conditions.NTSB CEN22LA382Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Kahului, HIThe pilot’s inadequate compensation for gusting winds while maneuvering on the ground.NTSB CEN22LA378Accident · No injuriesClass 3 · LimitedFinal reportCessna 210B · Clinton, ARA fatigue crack in the hydraulic actuator, which resulted in the loss of hydraulic fluid and the pilot’s inability to fully extend the landing gear.NTSB CEN22FA376Accident · 1 fatalClass 3 · FieldFinal reportCessna 182Q · Centennial, COThe loss of engine power during a departure climb for undetermined reasons and the aerodynamic stall, which resulted in an uncontrolled descent and impact with terrain.NTSB CEN22FA375Accident · 1 fatalClass 3 · FieldFinal reportSonex Waiex · Maxwell, CAA loss of control in flight for undetermined reasons that resulted in an impact with terrain.NTSB WPR22LA293Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-301 · Circle, MTThe loss of engine power due to carburetor ice. Contributing to the accident was the pilot’s failure to use carburetor heat.NTSB ERA22LA363Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Ellenville, NYBoth pilots’ decision to perform the takeoff near maximum gross weight with 10° of flaps, contrary to the owner’s manual procedure, which resulted in the airplane’s degraded climb performance approaching high terrain.NTSB ERA22LA362Accident · 1 fatalClass 3 · LimitedFinal reportDiamond DA-40 · Bardstown, KYThe pilot’s failure to provide adequate instructions to remain seated until the engine was shut down, which resulted in the passenger’s decision to exit the cockpit while the engine was operating and subsequently being struck by the rotating propeller.NTSB DCA22LA178Accident · No injuriesClass 4 · LimitedFinal reportBoeing 757-251 · Atlanta, GAThe overpitch control of the airplane during landing resulting in a tail strike.NTSB CEN22LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · McCarthy, AKThe pilot’s failure to maintain control of the airplane during takeoff in turbulent weather conditions.NTSB CEN22LA363Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-20B · Waller, TXThe pilot’s failure to maintain the proper descent rate during an off-airport landing.NTSB ERA22LA364Accident · Minor injuriesClass 4 · LimitedFinal reportAerotek Pitts Special S-1S · Erwinna, PAThe inability of both pilots to see and avoid the collision. Contributing to the accident was the pilot of the red airplane’s decision to utilize the converging runway for takeoff, contrary to the guidance published in the airport facility directory. Also…NTSB DCA22LA175Accident · No injuriesClass 4 · LimitedFinal reportBoeing 777 · Chicago, ILThe ground controller’s inappropriate routing of the B777 through a non-movement area, resulting in the airplane’s right wingtip contacting a light pole. Contributing to the accident was the lack of an appropriate display of taxiway BB2 as a restricted…NTSB CEN22LA377Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Vernon Hills, ILThe pilot’s improper in-flight fuel management, which led to a loss of engine power due to fuel starvation. Contributing to the accident was the collapsed carburetor heat induction tube that restricted airflow to the engine preventing engine restart.NTSB CEN22LA370Accident · Serious injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB WPR22LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 182B · Yellow Pine, IDThe pilot's failure to maintain clearance from a tree while maneuvering.NTSB WPR22LA294Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · White Salmon, WAThe pilot’s failure to attain a proper touchdown point, and his delayed decision to go around which, resulted in a collision with trees.