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 ANC20CA087Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Lake Louise, AKThe pilot’s decision to takeoff in shifting winds from a remote unimproved gravel bar, which resulted in a failure to attain an airspeed suitable for flight and a loss of control.NTSB CEN20LA357Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT802 · Dell, ARThe pilot’s failure to maintain airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall and collision with terrain.NTSB CEN20LA354Accident · 1 fatalClass 3 · LimitedFinal reportLancair Lancair Super ES · Ely, MNThe non-instrument rated pilot’s improper decision to attempt flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of control and subsequent impact with terrain.NTSB CEN20CA359Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Corsicana, TXThe student pilot did not maintain control of the airplane during the takeoff roll.NTSB WPR20LA290Accident · No injuriesClass 3 · LimitedFinal reportDiamond DA 40 · Benson, AZThe failure of the nose landing due to fatigue cracking.NTSB CEN20LA353Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT602 · Inverness, MSThe pilot’s decision to move the power control lever into beta during flight, which resulted in the power control lever and associated linkage becoming stuck in the beta position.NTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined based on the available evidence.NTSB CEN20CA358Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 8GCBC · Three Rivers, MIThe pilot's failure to maintain clearance from a taxiway sign after landing.NTSB CEN20CA355Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Odessa, TXThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR20LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Upland, CAThe failure of the right landing gear due to fatigue cracking.NTSB WPR20LA280Accident · 1 fatalClass 3 · LimitedFinal reportArrow-Falcon Exporters UH-1H · Coalinga, CAThe pilot’s inability to maintain control of the helicopter due to a hydraulic system failure for reasons that could not be fully determined due to the thermal destruction from the postimpact fire.NTSB WPR20LA279Accident · FatalClass 4 · LimitedFinal reportCessna 150 · Quillayute, WAThe airplane’s descent into trees and subsequent impact with terrain for undetermined reasons.NTSB WPR20CA276Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20C · Hillsboro, ORThe pilot’s failure to maintain altitude on short final due to an encounter with a down draft and the flight instructor's delayed remedial action.NTSB ERA20LA290Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Tallahassee, FLA partial loss of engine power on takeoff due to an intermittently blocked fuel injector on the number 3 cylinder.NTSB DCA20LA138Accident · Serious injuriesClass 3 · LimitedFinal reportBoeing 767 · Los Angeles, CAThe left main landing gear’s failure to extend due to the separation of the brake rod retaining hardware from the aft inboard wheel for reasons that could not be determined based on the available evidence.NTSB CEN20CA356Accident · No injuriesClass 4 · Data collectionFinal reportMaule M5 · Olathe, KSThe pilot's loss of directional control during landing.NTSB WPR20CA293Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Phoenix, AZThe pilot's improper pitch attitude and landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructors delayed remedial action.NTSB ERA20LA287Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA34 · Groton, CTThe reported partial loss of right engine power for reasons that could not be determined based on available evidence.NTSB ERA20CA291Accident · No injuriesClass 4 · Data collectionFinal reportTeam Rocket F1 Rocket · Finelyville, PAThe pilot's misjudgment of the airplane’s speed and altitude during the landing approach, and his failure to attain the proper touchdown point during landing, which resulted in a runway overrun. Contributing to the accident were his access to a limited set of…NTSB CEN20LA381Accident · No injuriesClass 3 · LimitedFinal reportPiper PA36 · Ord, NEThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.NTSB CEN20CA350Accident · No injuriesClass 4 · Data collectionFinal reportCessna 140 · Olustee, OKThe pilot's decision to attempt a takeoff from the middle of the runway in shifting wind conditions, which resulted in an aborted takeoff and runway excursion.NTSB CEN20CA347Accident · Minor injuriesClass 4 · Data collectionFinal reportGrumman G164 · Scottsbluff, NEThe pilot’s loss of visual reference during agricultural low-level flight, resulting in collision with power lines.NTSB ANC20CA082Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 20 · Talkeetna, AKThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB ERA20LA289Accident · No injuriesClass 3 · LimitedFinal reportCessna 150 · Surry, METhe pilot’s failure to use carburetor heat in conditions conducive to serious carburetor icing at glide power, which resulted in a loss of engine power and a forced ditching in water.NTSB ERA20CA301Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Savannah, GAThe pilot's inadequate flare, resulting in a hard landing.NTSB CEN20CA348Accident · No injuriesClass 4 · Data collectionFinal reportProgressive Aerodyne Searey · League City, TXThe pilot's failure to maintain airplane control during a water takeoff after an encounter with the wake from a boat.NTSB WPR20CA271Accident · No injuriesClass 4 · Data collectionFinal reportRyan ST3KR · Port Townsend, WAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and impact with vegetation.NTSB CEN20LA346Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 36 · San Benito, TXA loss of engine power for a reason that could not be determined.NTSB CEN20LA336Accident · 2 fatalClass 3 · LimitedFinal reportCirrus SR22 · Osage Beach, MOAn in-flight fire and subsequent loss of airplane control shortly after takeoff. The source of the in-flight fire or the reason for the loss of airplane control could not be determined based on the available information.NTSB CEN20CA344Accident · No injuriesClass 4 · Data collectionFinal reportBeech 35 · White Owl, SDThe pilot's failure to maintain directional control during the takeoff, which resulted in a runway excursion and subsequent impact with an obstacle and terrain.NTSB CEN20CA341Accident · No injuriesClass 4 · Data collectionFinal reportGrumman G164 · Rice, MNThe pilot did not maintain control of the airplane during the landing.NTSB CEN20CA337Accident · Serious injuriesClass 4 · Data collectionFinal reportEvektor Aerotechnik L13 · Frankenmuth, MIThe pilot's failure to stow the speed brake prior to attempting takeoff.NTSB WPR20LA270Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA 14 · Susanville, CAThe pilot’s decision to conduct a steep departure at a high-density altitude and the exceedance of the airplane’s critical angle of attack during a climb, which resulted in an accelerated stall and subsequent loss of control. Contributing to the accident was…NTSB WPR20CA272Accident · Serious injuriesClass 4 · Data collectionFinal reportAerostar International RX 8 · Albuquerque, NMThe pilot’s failure to maintain the proper descent rate during the balloon’s approach to a high-wind landing, which resulted in a hard landing and serious passenger injury.NTSB ERA20LA286Accident · Minor injuriesClass 3 · LimitedFinal reportJust JA 30 Superstol · Clover, SCThe separation of a spark plug lead, resulting in a partial loss of engine power and collision with trees.NTSB CEN20LA343Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Brandon, MNThe partial loss of engine power during takeoff due to carburetor icing.NTSB CEN20LA338Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185F · Sugar Land, TXA total loss of engine power after takeoff for undetermined reasons, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.NTSB WPR20LA278Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Harlowton, MTThe pilot’s failure to follow the appropriate takeoff procedures, which resulted in a collision with terrain.NTSB WPR20CA274Accident · Minor injuriesClass 4 · Data collectionFinal reportUskoski Ridge Runner IV · Vancouver, WAThe pilot’s failure to maintain airplane control while maneuvering to land which resulted in an aerodynamic stall at a low altitude, which the pilot was unable to recover from.NTSB WPR20CA273Accident · No injuriesClass 4 · Data collectionFinal reportSchweizer SGS233 · Warner Springs, CAThe pilot's inability to maintain altitude due to a loss of thermal lift, which resulted in an off-airport landing.NTSB ERA20LA285Accident · Serious injuriesClass 3 · LimitedFinal reportLake LA4 · West Palm Beach, FLAn on-ground engine fire, the source of which could not be determined based on the available evidence.NTSB CEN20LA342Accident · Minor injuriesClass 3 · LimitedFinal reportSiebel Auriga · Rockford, ILThe total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20LA339Accident · Serious injuriesClass 3 · LimitedFinal reportCzech Sport Sportcruiser · Gober, TXThe student pilot’s improper recovery from a power-off stall. Contributing to the accident was the flight instructor’s failure to properly monitor the student pilot during the stall recovery.NTSB WPR20CA269Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 182 · Cascade, IDThe pilot's decision to continue the unstable approach which resulted in an inadequate flare, bounced landing and collision with trees following a delayed go around.NTSB ERA20LA288Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 170 · Ardmore, TNThe pilot’s inadequate preflight planning and his decision to depart from a constrained, grass-covered field in elevated-density altitude conditions, which resulted in reduced takeoff and climb performance and a subsequent forced landing.NTSB CEN20LA345Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Glenwood Springs, COThe pilot’s loss of directional control upon landing due to a sheared tailwheel locking pin.NTSB ANC20CA081Accident · No injuriesClass 4 · Data collectionFinal reportPerformer High Performer · Chandalar Shelf, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing and a nose over.NTSB WPR20CA265Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Stanley, IDThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a ground loop.NTSB ERA20LA284Accident · No injuriesClass 3 · LimitedFinal reportRotorsport UK MTOsport 2017 · Springfield, TNThe pilot’s decision to continue the takeoff when the gyroplane’s actual performance failed to match that predicted in his performance planning. Contributing to the accident was the gyrocopter’s insufficient performance for reasons that could not be…NTSB CEN20CA387Accident · Serious injuriesClass 4 · Data collectionFinal reportPowrachute Airwolf · Casco, MIThe pilot's decision to takeoff towards known obstacles which resulted in an impact with a power line.