NTSB investigations
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 ERA26LA147Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA24-180 · Leonardtown, MDThe pilot’s failure to maintain control during a crosswind takeoff, which resulted in a runway excursion and impact with a drainage ditch.NTSB DCA26WA156Accident · No injuriesClass 5 · ForeignBoeing 737 · Phuket, ThailandNTSB CEN26LA139Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Denton, TXThe pilot’s failure to maintain control of the airplane while in the run-up area in high wind conditions.NTSB WPR26LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Redington, AZThe pilot’s improper decision to continue the flight into icing conditions, which resulted in the accumulation of airframe icing and a subsequent aerodynamic stall.NTSB WPR26LA123Accident · Serious injuriesClass 4 · LimitedFinal reportBrunner Donald G Kitfox · Rock Crossing, AZAn encounter with a downdraft while maneuvering at a low altitude, which resulted in an impact with terrain.NTSB ERA26LA145Accident · Serious injuriesClass 3 · LimitedPreliminary reportRockwell International 114 · Whitmire, SCOn March 10, 2026, about 1915 eastern daylight time, a Rockwell International 114 airplane, N4832W, was substantially damaged when it was involved in an accident near Whitmire, South Carolina. The flight instructor received minor injuries. The pilot receiving…NTSB DCA26WA154Incident · No injuriesClass 5 · ForeignBoeing 747 · Almaty, KazakhstanNTSB WPR26FA121Accident · 1 fatalClass 3 · FieldPreliminary reportMD Helicopters 369FF · Mojave, CAOn March 9, 2026, about 1517 Pacific daylight time, an MD Helicopters 369FF, N530XX, was destroyed when it was involved in an accident near Mojave, California. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB GAA26WA146Incident · No injuriesClass 5 · ForeignBeech 95B55 · Salamanca, SpainNTSB DCA26WA157Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · Minatitlan, MexicoNTSB CEN26LA138Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Solon Springs, WIThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB GAA26WA124Accident · 1 fatalClass 5 · ForeignThrush S2R · La Lima, HondurasNTSB ERA26LA146Accident · No injuriesClass 4 · LimitedFinal reportSchroder David Lancair IV-P · Feather Sound, FLThe pilot's failure to extend the landing gear before landing.NTSB ERA26LA144Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Indian Trail, NCOn March 8, 2026, about 1100 eastern daylight time, a Piper PA-28-140, N98360, was substantially damaged when it was involved in an accident near Indian Trail, North Carolina. The pilot and passenger were seriously injured. The airplane was operated as a…NTSB ERA26LA140Accident · 2 fatalClass 3 · LimitedPreliminary reportBeech A36 · Gulf Shores, ALOn March 7, 2026, about 1900 central standard time, a Beechcraft A36, N66519 was destroyed when it was involved in an accident near Gulf Shores, Alabama. The pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA26WA152Incident · No injuriesClass 5 · ForeignAirbus A321 · Málaga, SpainNTSB CEN26LA135Accident · No injuriesClass 4 · LimitedInvestigation openBellanca 8KCAB · Trinidad, CONTSB ANC26LA018Accident · No injuriesClass 3 · LimitedPreliminary reportBell Textron Canada 505 · Fort Worth, TXOn March 7, 2026, at 2210 Central daylight time, a Bell Textron 505 helicopter, N911FW, was substantially damaged when it was involved in an accident near Fort Worth, Texas. The pilot and crew member were not injured. The helicopter was operated as a Title 14…NTSB DCA26LA151Accident · No injuriesClass 4 · LimitedInvestigation openFairchild SA227-AC · Denver, CONTSB CEN26LA137Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-12 · Lockhart, TXOn March 7, 2026, about 1323 central standard time, a Piper PA-12, N2511M, was substantially damaged when it was involved in an accident near Lockhart, Texas. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB WPR26LA122Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182M · Flagstaff, AZMaintenance personnel’s decision to conduct an engine run at takeoff power in front of an active taxiway, and their failure to notify ATC, which resulted in the accident pilot’s loss of control during taxi due to an encounter with a jet blast.NTSB WPR26FA120Accident · 2 fatalClass 3 · FieldPreliminary reportColumbia Aircraft Mfg LC41-550FG · Albuquerque, NMOn March 6, 2026, about 1136 mountain standard time (MST), a Columbia Aircraft LC41-550FG, N2516S, was substantially damaged when it was involved in an accident in Albuquerque, New Mexico. The airplane was on an instrument flight rules flight plan from…NTSB ERA26LA149Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Sanford, FLAn in-flight collision with a bird during initial climb.NTSB ERA26LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Chuluota, FLAn in-flight collision with a bird while enroute.NTSB DCA26LA150Accident · Minor injuriesClass 3 · LimitedInvestigation openBoeing 737-824 · Denver, CONTSB GAA26WA123IncidentClass 5 · ForeignSikorsky S92 · Aberdeen, United KingdomNTSB ERA26LA141Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Charleston, WVThe pilot’s inadequate visual lookout, which resulted in a collision with a helicopter dolly during taxi.NTSB ERA26LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · St. Augustine, FLThe pilot's failure to extend the landing gear before landing.NTSB ERA26LA138Accident · Minor injuriesClass 4 · LimitedFinal reportGlasflugel Kestrel · Little Switzerland, NCA loss of thermal lift during a glider flight, which resulted in a collision with trees during a landing approach to a diversionary airport.NTSB ENG26LA019IncidentClass 4 · LimitedInvestigation openAirbus A321 · Baltimore, MDNTSB DCA26WA174Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Karmelava, LithuaniaNTSB CEN26FA132Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T210M · Deerfield, ILOn March 4, 2026, about 2145 central standard time, a Cessna T210M airplane, N19FB sustained substantial damage when it was involved in an accident near Deerfield, Illinois. The pilot was fatally injured. The airplane was operated under Title 14 Code of…NTSB WPR26FA119Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-28-140 · Phoenix, AZOn March 4, 2026, about 0721 mountain standard time, a Piper PA-28-140, N7744T, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The flight instructor was seriously injured, and the student pilot and one person on the…NTSB ERA26LA136Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 551 · Opa-locka, FLOn March 4, 2026, about 1648 eastern standard time, a Cessna 551, N228MH, was substantially damaged when it was involved in an accident near Opa-locka, Florida. The two pilots and three passengers were not injured. The airplane was operated as a Title 14 Code…NTSB CEN26LA134Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Sonora, TXThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in a loss of control and hard landing.NTSB ERA26LA135Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Thonotosassa, FLThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA26LA134Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172N · Newburgh, NYOn March 2, 2026, at 1910 eastern standard time, a Cessna 172N, N1560E, was substantially damaged when it was involved in an accident near Newberg, New York. The flight instructor and student pilot incurred minor injuries. The airplane was operated as a Title…NTSB ANC26LA017Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 · Waialua, HINTSB WPR26LA118Accident · Minor injuriesClass 4 · LimitedFinal reportLindstrand 260A · Casa Grande, AZThe hot air balloon’s encounter with downdraft wind conditions in mountainous terrain and subsequent impact with terrain.NTSB WPR26LA115Accident · No injuriesClass 4 · LimitedFinal reportMightyfly MF-100 · Atwater, CAA control system anomaly, which resulted in the overload and failure of one of the propulsion motor systems during the transition from hover to forward flight.NTSB WPR26LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Carefree, AZThe pilot reported that he landed the tailwheel equipped airplane at a backcountry airstrip, and while taxiing on rough terrain, the tailwheel spring failed and the tailwheel assembly separated from the airplane. The pilot shut down the airplane and exited to…NTSB DCA26LA184Incident · No injuriesClass 3 · LimitedPreliminary reportBoeing 787-9 · Los Angeles, CAOn March 2, 2026, at 1100 Pacific Standard Time, United Airlines flight 2127, a Boeing 787-9, registration N24972, powered by two General Electric GEnx™-1B76A/P2 turbofan engines, experienced a No. 1 (left) engine surge during climb from Los Angeles…NTSB WPR26LA112Accident · No injuriesClass 4 · LimitedFinal reportBeech 76 · Snohomish, WAThe flight instructor’s inadequate supervision of a dual student who attempted a go-around using one engine which resulted in a loss of control and impact with the ground.NTSB ERA26LA143Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Carthage, NCThe pilot’s failure to maintain clearance from trees while on final approach for landing. Contributing to the accident were the flight instructor’s inadequate remedial actions.NTSB ERA26LA133Accident · Minor injuriesClass 4 · LimitedFinal reportMorris Bradley D Zenith Stol CH-701 · Hendersonville, NCThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with trees.NTSB ERA26LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Okeechobee, FLThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB DCA26WA147Incident · No injuriesClass 5 · ForeignBoeing 737-823 · San Salvador, El SalvadorNTSB CEN26LA128Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Larose, LAThe pilot’s improper fuel planning and his failure to adequately monitor the fuel level during flight, which resulted in fuel exhaustion, and a total loss of engine power. Contributing to the accident was the pilot’s lack of attention performing the task,…NTSB WPR26FA109Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · Oroville, CAOn February 28, 2026, about 0948 Pacific standard time, a Piper PA-22-150, N3170Z, was destroyed when it was involved in an accident near Oroville, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR26FA108Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-8 · Hurricane, UTOn February 28, 2026, at about 1005 mountain standard time, an experimental amateur-built, Vans Aircraft, RV-8, N80AR, was substantially damaged when it was involved in an accident near Hurricane, Utah. The pilot was fatally injured. The airplane was operated…