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 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 ANC21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Birchwood, AKThe flight instructor’s inadequate supervision of the student pilot, and student pilot’s improper landing flare, resulting in a hard landing.NTSB ANC21LA092Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Homer, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.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 ENG22WA001Incident · No injuriesClass 5 · ForeignAirbus A320 · Silao, Guanajuato, MexicoNTSB 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 GAA22WA020Accident · 2 fatalClass 5 · ForeignBely lebed · Sovetsky, RussiaNTSB GAA21WA236Accident · No injuriesClass 5 · ForeignCessna 210 · Santa Izabel do Rio Negro, BrazilNTSB GAA21WA231Accident · 1 fatalClass 5 · ForeignMooney M20J · Sundridge, CanadaNTSB 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 GAA21WA230Accident · 1 fatalClass 5 · ForeignBell 206 · Hope Bay, Canada, CanadaNTSB GAA21WA229Accident · 7 fatalClass 3 · ForeignBeech B200GT · Piracicaba, BrazilNTSB 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 GAA21WA240Accident · 2 fatalClass 5 · ForeignCessna 182 · Samos Island, GreeceNTSB GAA21WA226Accident · Minor injuriesClass 5 · ForeignHelio HT-295 · Pista Del, GuatemalaNTSB 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 DCA21WA222IncidentClass 5 · ForeignBoeing 737 · Katowice, PolandNTSB 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 GAA21WA225Accident · 1 fatalClass 5 · ForeignPiper J3C · Mauricie, CanadaNTSB 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 ENG21WA041Accident · 4 fatalClass 5 · ForeignLet L410 · Kazachinskoye, RussiaNTSB 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.