NTSB investigations
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 GAA26WA274Incident · No injuriesClass 5 · ForeignCessna 180 · El Cebruno, ColombiaNTSB GAA26WA243Accident · 2 fatalClass 5 · ForeignCessna 172 · Fujairah, United Arab EmiratesNTSB GAA26WA238Accident · No injuriesClass 5 · ForeignCirrus SR22 · Chichester, United KingdomNTSB GAA26WA237Accident · 2 fatalClass 5 · ForeignBeech V35 · San Miguel Pochuta, GuatemalaNTSB ANC26LA067Accident · No injuriesClass 4 · LimitedInvestigation openDehavilland DHC-3 · Denali National Park, AKNTSB ERA26LA257Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Lafayette, TNOn July 2, 2026, at 1032 central daylight time, a Cirrus Design Corp SR22, N127DC, was substantially damaged when it was involved in an accident near Lafayette, Tennessee. The pilot and passenger sustained no injuries. The airplane was operated as a Title 14…NTSB CEN26LA245Accident · Serious injuriesClass 4 · LimitedFinal reportXag P150 MAX · Wolcott, INThe pilot’s failure to maintain control of the UAS during takeoff.NTSB CEN26FA241Accident · Serious injuriesClass 3 · FieldPreliminary reportBeech 95-A55 · Lancaster, SCOn July 2, 2026, at 0052 eastern daylight time (EDT), a Beech model 95-A55 airplane, N7501S, was destroyed when it was involved in an accident near Lancaster, South Carolina. Both pilots received serious injuries. The accident flight was operated as a Title…NTSB ERA26LA256Accident · No injuriesClass 4 · LimitedInvestigation openEmbraer Executive EMB-500 · Morrisville, NCNTSB DCA26WA260Incident · No injuriesClass 5 · ForeignBoeing 767-34AF · Singapore, SingaporeNTSB WPR26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Paynesville, MNOn June 30, 2026, about 1745 central daylight time, a Beech A36, N8095F, was substantially damaged when it was involved in an accident at Paynesville Municipal Airport (PEX), Paynesville, Minnesota. The private pilot and one passenger were not injured. The…NTSB GAA26WA234Accident · 2 fatalClass 5 · ForeignCessna A152 · Ongar, United KingdomNTSB ERA26LA255Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172M · Lafayette, TNThe passenger’s abrupt manipulation of the flight controls during takeoff, which resulted in a loss of directional control and collision with a fence.NTSB ERA26LA254Accident · No injuriesClass 3 · LimitedPreliminary reportRath Michael J Sonerai 2 · Cynthiana, KYOn June 30, 2026, at about 1030 eastern daylight time, an experimental Sonerai 2 airplane, N1406, was substantially damaged when it was involved in an accident near Cynthiana, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code…NTSB DCA26WA283IncidentClass 5 · ForeignBoeing 737 · Tehran, IranNTSB DCA26WA268Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Catania, ItalyNTSB CEN26LA243Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Peyton, COThe flight instructor’s inadequate supervision of the student pilot, which resulted in the loss of control during a rejected takeoff.NTSB WPR26LA237Accident · Serious injuriesClass 3 · LimitedPreliminary reportAutogyro MT03 · San Jose, CAOn June 29, 2026, about 1148 Pacific daylight Time, a MTO Sport gyroplane, N423AG, was substantially damaged when it was involved in an accident at Reid-Hillview Airport (RHV), San Jose, California. The pilot was seriously injured, and the passenger received…NTSB GAA26WA240Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Moncoes, BrazilNTSB ERA26LA262Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-161 · Easton, MDNTSB ERA26FA253Accident · 2 fatalClass 3 · FieldPreliminary reportBellanca 14-19-2 · Goldsby, OKOn June 29, 2026, at about 1055 central daylight time, a Bellanca 14-19-2, N9846B, was destroyed when it was involved in an accident in Goldsby, Oklahoma. The two pilots were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB CEN26LA239Accident · No injuriesClass 4 · LimitedInvestigation openCessna T206H · Ava, MONTSB ANC26LA066Accident · Serious injuriesClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 NG · Petersburg, VAOn June 29, 2026, about 1945 eastern daylight time (EDT), a Diamond Aircraft Industries Inc. DA40 NG airplane, N602RF, was substantially damaged when it was involved in an accident near Petersburg, Virginia. The flight instructor sustained serious injuries,…NTSB GAA26WA241Accident · Minor injuriesClass 5 · ForeignCirrus SR22 · Neropolis, BrazilNTSB GAA26WA236Accident · 11 fatalClass 5 · ForeignPilatus PC6 · Tomblaine, FranceNTSB ERA26FA252Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA24 · Hazen, NDOn June 28, 2026, about 1317 central daylight time, a Piper PA-24-250, N6852P, was destroyed when it was involved in an accident near Hazen, North Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB WPR26LA240Accident · Serious injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Santa Paula, CAThe pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power.NTSB WPR26LA239Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170A · El Cajon, CANTSB WPR26LA238Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Angel Fire, NMThe pilot’s loss of directional control during landing with a crosswind.NTSB GAA26WA235Accident · 2 fatalClass 5 · ForeignPiper PA28 · Fochville, South AfricaNTSB ERA26LA265Accident · No injuriesClass 4 · LimitedFinal reportBeech E35 · Lincoln, ALThe pilot’s failure to ensure that the landing gear were extended prior to landing.NTSB ERA26LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, NCThe flight instructor’s improper decision to leave the airplane with the engine running, which resulted in the airplane rolling forward and impacting a hangar.NTSB DCA27WA008IncidentClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaNTSB GAA26WA242Accident · No injuriesClass 5 · ForeignCessna 172 · São Gabriel do Oeste, BrazilNTSB GAA26WA231Incident · No injuriesForeign investigationHonda HA420 · Yao, JapanNTSB ERA26LA251Accident · Minor injuriesClass 3 · LimitedPreliminary reportJones Peter M Boeing/Jones 75 · Cleveland, GAOn June 26, 2026, about 1045 eastern daylight time, a Boeing/Jones 75, N3993C, was substantially damaged when it was involved in an accident near Cleveland, Georgia. The pilot and passenger sustained minor injuries. The airplane was operated as a Title 14…NTSB DCA26WA254IncidentClass 5 · ForeignBoeing 787 · Ar Rumays, OmanNTSB DCA26LA285Accident · No injuriesClass 4 · LimitedFinal reportLeigh Aerosystems E100 · Douglas, AZDegraded engine and propeller performance during hot and high-density altitude operations, which resulted in a high descent rate and subsequent hard landing.NTSB CEN26LA238Accident · 1 fatalClass 3 · LimitedPreliminary reportAirborne Windsports PTY Edge XT-912-L · Winona, MNOn June 25, 2026, about 2000 central daylight time, an Airborne Windsports Pty Ltd Edge Xt-912-L weight-shift-control light sport aircraft, N912CV was substantially damaged when it was involved in an accident at Winona Municipal Airport (ONA) Winona,…NTSB WPR26LA236Accident · No injuriesClass 3 · LimitedPreliminary reportBeech S35 · Dome, AZOn June 25, 2026, about 1125 mountain standard time, a Beech S35, N6040F, sustained substantial damage when it was involved in an accident near Dome, Arizona. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA235Accident · No injuriesClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA20-C1 · Nephi, UTOn June 25, 2026, about 0905 mountain daylight time, a Diamond DA20-C1, N643DC, was substantially damaged when it was involved in an accident near Nephi, Utah. The flight instructor and the student pilot were not injured. The airplane was operated as a Title…NTSB GAA26WA233Accident · 3 fatalClass 5 · ForeignRockwell 690 · Fort Simpson, CanadaNTSB GAA26WA230Accident · 2 fatalClass 5 · ForeignCirrus SR22 · Warsaw, PolandNTSB GAA26WA228Accident · No injuriesClass 5 · ForeignCessna 401 · Ciudad del Carmen, MexicoNTSB ERA26LA260Accident · No injuriesClass 4 · LimitedFinal reportChampion 7EC · Highgate, VTThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB DCA26WA269Incident · No injuriesClass 5 · ForeignBoeing 767 · Callao, PeruNTSB WPR26FA233Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 195 · Pasco, WAOn June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title…NTSB WPR26FA232Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Willard, UTOn June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB GAA26WA239Accident · 1 fatalClass 5 · ForeignSupermarine Spitfire · Muluckine, AustraliaNTSB GAA26WA227Accident · No injuriesClass 5 · ForeignLake LA4 · Egelsbach, Germany