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 ANC26LA081Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna A185F · Hope, AKNTSB WPR26LA299Accident · No injuriesClass 4 · LimitedInvestigation openJonker Sailplanes JS3 · Tehachapi, CANTSB WPR26LA298Accident · No injuriesClass 4 · LimitedInvestigation openCessna A185F · Reno, NVNTSB GAA26WA279Accident · 4 fatalForeign investigationRobinson R44 · Rio de Janeiro, BrazilNTSB GAA26WA278Accident · 1 fatalClass 5 · ForeignCessna 150 · Portimao, PortugalNTSB ENG26WA033OccurrenceClass 5 · ForeignBoeing 737 · Cancun, MexicoNTSB DCA26WA330Accident · Serious injuriesClass 5 · ForeignAirbus A321 · Mascot, AustraliaNTSB WPR26LA300Accident · No injuriesClass 4 · LimitedInvestigation openZaklad Szybowcowy Jezow PW-6U · Floriston, CANTSB WPR26LA293Accident · No injuriesClass 4 · LimitedInvestigation openP Z L -Warszawa-Cnpsl PZL-104 Wilga 35A · Ukiah, CANTSB WPR26FA294Accident · 1 fatalClass 3 · FieldPreliminary reportTextron 172S · Provo, UTOn August 7, 2026, about 1549 mountain daylight time, a Textron Aviation Inc. 172S, N1842E, was substantially damaged when it was involved in an accident near Provo, Utah. The flight instructor sustained serious injuries, and the pilot undergoing instruction…NTSB GAA26WA280IncidentClass 5 · ForeignRaytheon B200 · Darwin, AustraliaNTSB ANC26LA086Accident · No injuriesClass 4 · LimitedInvestigation openDehavilland DHC-2 · Igiugig, AKNTSB ANC26FA079Accident · 2 fatalClass 3 · FieldPreliminary reportHelicopter Transport Services CH-54A · Cove Fort, UTOn August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The…NTSB ERA26LA339Accident · No injuriesClass 4 · LimitedInvestigation openCessna 680 · Statesville, NCNTSB ERA26FA291Accident · 2 fatalClass 3 · FieldPreliminary reportBeech H35 · Bogalusa, LAOn August 6, 2026, about 1030 central daylight time, a Beech H35, N5409D, was destroyed when it was involved in an accident near Bogalusa, Louisiana. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26LA282Accident · 1 fatalClass 3 · LimitedPreliminary reportPzl-Bielsko B1-PW-5 · Briggs, TXOn August 6, 2026, about 1538 central daylight time, a PZL-Bielsko B1-PW-5 glider, N105WS, was substantially damaged when it was involved in an accident near Briggs, Texas. The pilot was fatally injured. The glider was operated as a Title 14 Code of Federal…NTSB ANC26LA085Accident · No injuriesClass 4 · LimitedInvestigation openBeech 36 · Port Alsworth, AKNTSB ANC26LA083Accident · No injuriesClass 4 · LimitedInvestigation openLegend Air Alaska AK-18-4PX · Butte, AKNTSB ANC26LA080Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-32-260 · Pinetown, NCOn August 6, 2026, about 1355 eastern daylight time, a Piper Aircraft PA-32-260 airplane, N8791E, was substantially damaged when it was involved in an accident near Pinetown, North Carolina. The private pilot and two passengers sustained minor injuries. The…NTSB WPR26LA295Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV8 · Great Falls, MTOn August 5, 2026, at about 1034 mountain daylight time, a Van’s Aircraft RV-8, C-GFWR, was substantially damaged when it was involved in an accident near Great Falls, Montana. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA292Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-24-260 · Albuquerque, NMNTSB WPR26LA291Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 177B · Perris, CAOn August 5, 2026, at 1117 mountain daylight time, a Cessna 177B, N34852, was substantially damaged when it was involved in an accident near Perris, California. The flight instructor and student pilot were not injured. The airplane was being operated as a…NTSB WPR26FA289Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22T · Bend, OROn August 4, 2026, at about 1845 Pacific daylight time, a Cirrus Design Corporation SR22T airplane, N625LK, was substantially damaged when it was involved in an accident near Bend, Oregon. The pilot was fatally injured. The airplane was operated as Title 14…NTSB ERA26LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Carlisle, PAA collision with a deer during landing.NTSB ANC26LA087Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna 172P · Inalåhan, GUNTSB OPS26LA063IncidentClass 3 · LimitedPreliminary reportSikorsky VH3D · Washington, DCOn August 4, 2026, about 1434 eastern daylight time (EDT), Marine One (VM1) a Sikorsky VH-3D, and Envoy Air flight 3742 (ENY3742), an Embraer E-170, were involved in a loss of separation about 2 miles north of Ronald Reagan Washington National Airport (DCA),…NTSB GAA26WA277Accident · 1 fatalForeign investigationCessna 172L · Chilliwack, CanadaNTSB GAA26WA275Occurrence · No injuriesClass 5 · ForeignCessna U206 · Iquique, ChileNTSB ERA26LA292Accident · No injuriesClass 4 · LimitedFinal reportExtra Flugzeugproduktions-Und EA 300/LT · Whitehouse, OHThe pilot’s failure to ensure the canopy was properly locked before flight, which resulted in the canopy opening during takeoff.NTSB ENG26WA038Incident · No injuriesClass 5 · ForeignEmbraer EMB145 · Luanda, AngolaNTSB CEN26LA281Accident · No injuriesClass 4 · LimitedInvestigation openMooney M20E · Longmont, CONTSB CEN26FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Bethany, MOOn August 4, 2026, about 1839 central daylight time, a Piper PA-24-250 airplane, N8422P, was destroyed when it was involved in an accident near Bethany, Missouri. The pilot received fatal injuries. The airplane was operated under Title 14 Code of Federal…NTSB WPR26LA290Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA22 · Goldendale, WANTSB CEN26LA291Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Linden, MIThe collision with a deer during touch-and-go landings.NTSB WPR26LA288Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-20 · Reno, NVNTSB WPR26LA287Occurrence · 1 fatalClass 3 · LimitedPreliminary reportCameron Balloons A-315 · Menifee, CAOn August 2, 2026, about 0710 Pacific daylight time, a Cameron Balloons A-315, N315U, was not damaged when it was involved in an accident near Menifee, California. The pilot and one passenger were not injured, and one passenger was fatally injured. The…NTSB WPR26FA284Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Blackfoot, IDOn August 1, 2026, about 2301 mountain daylight time (MDT), a Cessna 172G, N1166F, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was fatally injured, and the two passengers sustained serious injuries. The…NTSB GAA26WA270Accident · 2 fatalClass 5 · ForeignBell 214ST · West Attica, GreeceNTSB GAA26WA269Accident · No injuriesForeign investigationCirrus SR22 · Fulda, GermanyNTSB DCA26WA341IncidentClass 5 · ForeignBoeing 747 · Changzhi, ChinaNTSB CEN26LA277Accident · Serious injuriesClass 3 · LimitedPreliminary reportTaylorcraft BC12-D · Boyceville, WIOn August 2, 2026, about 1223 central daylight time, a Taylorcraft BC12-D airplane, N43665 was substantially damaged when it was involved in an accident near Boyceville, Wisconsin. Both the pilot and passenger were seriously injured. The airplane was operated…NTSB CEN26LA276Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Bennett, IAOn August 2, 2026, about 1318 central daylight time, a Robinson Helicopter Company R44 II helicopter, N26KL, was substantially damaged when it was involved in an accident near Bennett, Iowa. The pilot was not injured. The helicopter was operated as a Title 14…NTSB CEN26FA275Accident · 1 fatalClass 3 · FieldPreliminary reportBeech E18S · Guymon, OKOn August 2, 2026, about 1608 central daylight time (CDT), a Beech E18S airplane, N210Q, was destroyed when it was involved in an accident near Guymon, Oklahoma. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA286Accident · No injuriesClass 4 · LimitedInvestigation openInterstate S-1A · Blackfoot, IDNTSB WPR26LA283Accident · No injuriesClass 4 · LimitedInvestigation openCub Crafters CCX-2000 · Tooele, UTNTSB GAA26WA272Occurrence · No injuriesClass 5 · ForeignCessna 208B · Bimini, BahamasNTSB GAA26WA268Accident · 13 fatalClass 5 · ForeignCessna 208 · Nazca, PeruNTSB CEN26LA286Accident · No injuriesClass 4 · LimitedFinal reportCessna T188C · Randolph, NEThe pilot’s failure to maintain clearance from a tree during a low-level aerial application flight.NTSB CEN26LA278Accident · No injuriesClass 4 · LimitedFinal reportCessna 310 · North Little Rock, ARThe flight instructor and pilot receiving instruction’s failure to verify that the landing gear was extended before landing, which resulted in a gear-up landing.NTSB WPR26LA285Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172 · Layton, UTOn July 30, 2026, at 2356 mountain daylight time, a Cessna 172M airplane, N9650V, was substantially damaged when it was involved in an accident near Layton, Utah. The flight instructor was seriously injured, and the private pilot sustained minor injuries. The…