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 ANC21LA091Accident · No injuriesClass 4 · LimitedFinal reportChampion 7GCBC · Nenana, AKThe pilots over application of the brakes during landing, which resulted in a nose-over.NTSB WPR21LA363Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Orcas Island, WAThe total loss of engine power due to the pilot’s mismanagement of the fuel system which resulted in fuel starvation.NTSB ERA21LA368Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Ash, NCA partial loss of engine power due to corrosion and erosion damage to the engine’s compressor section components.NTSB DCA21LA226Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2B19 · Asheville, NCThe fuel truck driver backing up in the direction of the airplane without the use of marshallers.NTSB CEN21LA453Accident · No injuriesClass 4 · LimitedFinal reportBeech M35 · Osage Beach, MOThe pilot and flight instructor’s failure to ensure that the landing gear were extended prior to landing.NTSB CEN21FA424Accident · 1 fatalClass 3 · FieldFinal reportBoeing A75 · Delta, COThe pilot’s loss of control during an aerobatic maneuver, resulting in the airplane impacting terrain.NTSB ANC21LA093Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Chandalar Shelf, AKA separation of the rudder cable from the rudder pedal due to the connecting bolt detaching for undetermined reasons, which resulted in a loss of directional control.NTSB ERA21FA362Accident · 3 fatalClass 3 · FieldFinal reportRobinson Helicopter R66 · Monticello, GAThe pilot’s decision to continue the visual flight rules flight into deteriorating weather conditions during a dark night and over unlit terrain, which resulted in spatial disorientation and a subsequent loss of helicopter control.NTSB CEN21LA474Accident · No injuriesClass 4 · LimitedFinal reportNavion Navion H · Burlington, WIThe pilot’s failure to maintain aircraft control during landing with a gusting crosswind that resulted in an aerodynamic stall and a hard impact on the runway.NTSB CEN21LA430Accident · No injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Battle Creek, MIThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing and the flight instructor’s inadequate remedial action.NTSB CEN21LA423Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Howell, MIThe pilot’s inadequate preflight inspection of the airplane’s fuel quantity, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN21LA422Accident · No injuriesClass 4 · LimitedFinal reportCessna 195 · Ypsilanti, MIThe pilot’s failure to maintain directional control during taxi, which resulted in a ground loop.NTSB WPR21LA347Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Stanley, IDThe pilot’s failure to maintain airplane control during landing with a gusting crosswind which, resulted in a hard landing and collision with terrain.NTSB WPR21LA346Accident · Serious injuriesClass 4 · LimitedFinal reportGordon Scot A RV-6A · Palouse, WAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB CEN21LA433Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Council Bluffs, IAThe student pilot’s failure to maintain directional control during a touch and go landing.NTSB CEN21LA431Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS350 · Romeo, MIThe flight instructor’s failure to reposition the fuel control to the flight detent during a practice autorotation, which resulted in insufficient engine power to arrest the helicopter’s decent and a hard landing.NTSB CEN21LA421Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Reynoldsville, ILThe pilot’s failure to maintain clearance from the wire during low altitude operations in windy conditions.NTSB ERA21LA379Accident · No injuriesClass 3 · LimitedFinal reportHawker Beechcraft 400A · Charleston, SCThe in-flight separation of the left engine’s four-panel cowling for reasons that could not be determined based on the available evidence.NTSB ERA21LA375Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Andover Township, NJThe student pilot's excessive asymmetrical application of the brakes, which resulted in a nose over.NTSB ERA21LA360Accident · No injuriesClass 3 · LimitedFinal reportZenith 750 Cruzer · New Smyrna, FLThe mechanic’s inadequate inspection of the flight control system, which resulted in a loss of airplane control.NTSB CEN21LA425Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Mark III · Steamboat Springs, COThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB WPR21LA342Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 58 · Palo Alto, CAThe fuelers addition of the incorrect fuel to the fuel tanks which resulted in a total loss of engine power.NTSB ERA21LA365Accident · No injuriesClass 4 · LimitedFinal reportVans Vans RV-8 · Atlanta, GAA loss of directional control and subsequent runway excursion resulting as a result of the inadvertent rudder input by the passenger.NTSB ERA21LA361Accident · Minor injuriesClass 3 · LimitedFinal reportBeech C24R · Augustine, FLImproperly installed fuel injection system components, which resulted in a partial loss of engine power shortly after takeoff.NTSB ERA21LA358Accident · Minor injuriesClass 4 · LimitedFinal reportAlon A2 · Abingdon, VAThe failure of a nosewheel steering actuator arm, which resulted in a loss of control during the landing rollout.NTSB ERA21LA356Accident · No injuriesClass 3 · LimitedFinal reportWaco GXE · Burt, NYThe improper magneto timing, which resulted in the engine’s inability to produce full power during the takeoff.NTSB WPR21FA340Accident · 1 fatalClass 3 · FieldFinal reportCessna 177RG · Lake Havasu City, AZA partial loss of engine power during the airplane's initial climb due to wear of internal engine components, which prevented the engine from developing full-rated power and resulted in a loss of altitude.NTSB ERA21LA366Accident · No injuriesClass 4 · LimitedFinal reportSproul Keith A 83K-16 · Ryegate, VTThe pilot's failure to secure himself to the balloon seat which resulted in a loss of control of the balloon.NTSB ERA21FA355Accident · 1 fatalClass 3 · FieldFinal reportAmerican Champion 8KCAB · Rhine, GAA collision with trees during a low-altitude aerobatic maneuver for unknown reasons.NTSB CEN21LA418Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-44-180 · Magnolia, TXA total loss of engine power due to fuel exhaustion, which resulted from the pilot’s inadequate preflight planning.NTSB CEN21LA415Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170B · Ozark, ARThe pilot’s inadequate takeoff performance planning that resulted in a climb gradient too low to clear trees on departure, and his failure to maintain aircraft control that resulted in an aerodynamic stall and impact with terrain.NTSB ANC21LA086Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Port Alsworth, AKA loss of directional control for reasons that could not be determined based on the available information.NTSB WPR21LA358Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Baker, NVA total loss of engine power during the initial climb due to the failure of the No. 5 connecting rod bearing.NTSB ERA22LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Kennesaw, GAThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB ERA21LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Ayer, MAThe pilot’ improper preflight and inflight planning which resulted in fuel exhaustion.NTSB CEN21LA420Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Ultralight Challenger II · Rogers City, MIThe separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…NTSB ANC21LA088Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a loss of directional control and nose over.NTSB CEN21LA416Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Hot Springs, SDThe tensile overload failure of the main landing gear attachment bolt, which resulted in separation of the left main landing gear and a loss of control during landing.NTSB CEN21LA414Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · LaSalle, COA loss of engine power for undetermined reasons.NTSB CEN21FA410Accident · 1 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 Beta · Mentone, TXThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB ANC21LA087Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · North Pole, AKThe pilot’s failure to ensure adequate obstacle clearance while maneuvering, which resulted in a collision with a tree and a loss of control.NTSB ERA21LA359Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Venice, FLMaintenance personnel’s failure to use the correct throttle linkage hardware when reinstalling the engine, resulting in a disconnection of the throttle during flight.NTSB ERA21FA354Accident · Serious injuriesClass 3 · FieldFinal reportCessna 402C · Provincetown, MAThe pilot’s delayed decision to perform an aborted landing late in the landing roll with insufficient runway remaining. Contributing to the accident was the pilot’s failure to execute a go-around once the approach became unstabilized, per the operator’s…NTSB CEN21LA419Accident · Minor injuriesClass 4 · LimitedFinal reportThatcher CX4 · Marshalltown, IAThe pilot’s failure to properly determine the correct fuel quantity during preflight inspection that resulted in a loss of engine power during approach due to fuel exhaustion.NTSB CEN21LA417Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Olive Branch, MSThe airplane’s impact with a bird while on approach.NTSB WPR21LA339Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Arlington, WAThe fatigue fracture of the tailwheel fitting spring, which resulted in the loss of directional control during the landing roll.NTSB WPR21LA338Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Tillamook, ORThe pilot's failure to maintain clearance from a powerline during a low reconnaissance, with sun glare.NTSB ERA21LA357Accident · No injuriesClass 4 · LimitedFinal reportEnstrom F28 · Toughkenamon, PAThe pilot’s failure to maintain control of the helicopter during an out-of-ground effect hover in a gusty wind, due to loss of tail rotor effectiveness.NTSB CEN21LA407Accident · No injuriesClass 4 · LimitedFinal reportAeromot AMT-100 · Menomonie, WIThe pilot’s failure to extend the landing gear.NTSB ANC21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Delta Junction, AKThe pilot’s inability to maintain lateral control during the takeoff, which resulted in dynamic rollover. Contributing to the accident was the pilot’s decision to utilize an unsuitable landing area for flight operations.