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 ERA26LA275Accident · No injuriesClass 4 · LimitedFinal reportJeremy Price Smith Super CUB · Allisonia, VAThe pilot’s inadequate lookout, which resulted in a collision with ground equipment during taxi.NTSB ENG26WA031Incident · No injuriesClass 5 · ForeignAirbus A321 · Hermosillo, MexicoNTSB DCA26LA329Accident · Serious injuriesClass 4 · LimitedInvestigation openBoeing 777 · Boston, MANTSB ANC26LA073Accident · No injuriesClass 4 · LimitedInvestigation openAviat A-1C-200 · Springfield, MONTSB ANC26LA072Accident · No injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-2 MK.I · Nondalton, AKOn July 19, 2026 about 1440 Alaska daylight time, a DeHavilland DHC-2 airplane, N791PW was substantially damaged when it was involved in an accident near Nondalton, Alaska. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA271Accident · No injuriesClass 4 · LimitedInvestigation openLet L-23 Super Blanik · North Plains, ORNTSB WPR26LA269Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-161 · San Bernardino, CAOn July 18, 2026, about 1530 Pacific daylight time, a Piper PA-28-161, N8249B, was substantially damaged when it was involved in an accident near San Bernardino, California. The pilot and pilot rated passenger were not injured. The airplane was operated as a…NTSB WPR26LA268Accident · Serious injuriesClass 4 · LimitedInvestigation openPiper PA-18 · Colusa, CANTSB WPR26LA267Accident · Minor injuriesClass 4 · LimitedInvestigation openRans S7 · Kemmerer, WYNTSB WPR26LA266Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-4-180V · Sapinero, CONTSB ERA26LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Mooresville, NCThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN26LA289Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Raven 1 · Scribner, NEThe pilot's failure to maintain clearance from power lines while maneuvering at low-level altitude during an agricultural operation.NTSB CEN26LA261Accident · No injuriesClass 4 · LimitedInvestigation openBeech 35-B33 · Alton, ILNTSB CEN26LA259Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 · Adair, IAOn July 18, 2026, about 1440 central daylight time, a Robinson Helicopter Company R44, N484AT, was substantially damaged when it was involved in an accident near Adair, Iowa. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…NTSB WPR26LA265Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7A · Covington, WAThe pilot’s improper pitch control during landing, which resulted in a bounced landing, nose landing gear collapse, and nose over.NTSB ERA26LA276Accident · Minor injuriesClass 4 · LimitedFinal reportChristen Industries Pitts S-2 · Porter Center, NYThe pilot’s failure to maintain directional control during the landing roll.NTSB DCA26WA374IncidentClass 5 · ForeignBoeing 737 · Lisbon, PortugalNTSB DCA26WA309Incident · No injuriesClass 5 · ForeignAirbus A320 · Balmaceda, ChileNTSB CEN26LA264Accident · Serious injuriesClass 4 · LimitedInvestigation openBell 206B · Saint Joseph, ILNTSB CEN26LA258Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV-8A · Mineral Point, WIOn July 17, 2026, at 1748 central daylight time, an experimental amateur-built Vans Aircraft Inc RV-8A, N22SZ, sustained substantial damage when it was involved in an accident in Mineral Point, Wisconsin. The commercial pilot was uninjured. The airplane was…NTSB WPR26LA264Accident · Serious injuriesClass 4 · LimitedInvestigation openTag Aviation PTY Titanium Explorer · Cashmere, WANTSB WPR26FA262Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-4 · Yuba City, CAOn July 16, 2026, at 0701 Pacific daylight time, an experimental amateur built Vans RV-4, N98GB, was substantially damaged when it was involved in an accident near Yuba City, California. The pilot was fatally injured. The airplane was operated as a Title 14…NTSB DCA26LA286Accident · Serious injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LL · Sanford, FLAn encounter with convectively induced turbulence during cruise flight in an area of forecast thunderstorm activity.NTSB CEN26LA263Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Baraboo, WIOn July 16, 2026, about 1508 central daylight time, a Piper PA-24-260 airplane, N8606P, sustained substantial damage when it was involved in an accident near Baraboo, Wisconsin. The pilot sustained serious injuries. The airplane was operated as a Title 14…NTSB CEN26LA256Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Coralville, IAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight.NTSB CEN26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportDakota Cub Super 18 · Plymouth, MAOn July 16, 2026, about 0740 eastern daylight time, a Dakota Cub Super 18 airplane, N84AJ, was substantially damaged when it was involved in an accident near Plymouth, Massachusetts. The pilot was fatally injured. The airplane operated under the provisions of…NTSB ANC26LA074Accident · Minor injuriesClass 4 · LimitedInvestigation openMooney M20E · Englewood, CONTSB WPR26LA279Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-24 · Medford, OROn July 14, 2026, about 1725 Pacific daylight time, a Piper PA-24 airplane, N5002P, was substantially damaged when it was involved in an accident at Rogue Valley International/Medford Airport (MFR), Medford. Oregon. The two pilots were not injured. The…NTSB WPR26LA263Accident · No injuriesClass 4 · LimitedInvestigation openSchleicher ASW-27 · Montague, CANTSB GAA26WA258Accident · 2 fatalClass 5 · ForeignCessna 335 · Barinas, VenezuelaNTSB GAA26WA255Accident · No injuriesClass 5 · ForeignCessna TU206 · Gachancipa, ColombiaNTSB ERA26LA273Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Linneus, METhe pilot’s inadequate preflight and in-flight monitoring of the fuel quantity, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR26LA261Accident · No injuriesClass 4 · LimitedInvestigation openJames Ausbun Kitfox S7 STI · Greenwater, WANTSB WPR26LA260Accident · Minor injuriesClass 4 · LimitedInvestigation openBellanca 8KCAB · Auburn, CANTSB WPR26FA257Accident · 1 fatalClass 3 · FieldPreliminary reportLuscombe 8A · Canton, TXOn July 14, 2026, sometime between 1252 and 1356 CDT, a Luscombe 8A, N1164K, was substantially damaged when it crashed in a field near Canton, Texas. The pilot, who was the sole occupant, was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA261Incident · 1 fatalClass 5 · ForeignCessna 152 · Mengeringhausen, GermanyNTSB GAA26WA251Accident · 2 fatalClass 5 · ForeignHughes 369 · British Columbia, CanadaNTSB ERA26LA274Accident · No injuriesClass 4 · LimitedInvestigation openRobinson R22 · Monroe, NCNTSB ERA26FA271Accident · 3 fatalClass 3 · FieldPreliminary reportSmith Aerostar 601 · Lake Clear, NYOn July 13, 2026, about 2236 eastern daylight time, a Smith Aerostar 601P, N800AA was destroyed when it was involved in an accident near Lake Clear, New York. The private pilot and two passengers were fatally injured. The airplane was operated as a Title 14…NTSB DCA26LA282Accident · No injuriesClass 4 · LimitedFinal reportAirbus A321-211 · New York, NYThe first officer’s excessive aft sidestick input following a bounced landing, and the line check pilot’s delayed remedial action, which resulted in an increase in the airplane’s pitch attitude and a subsequent tailstrike.NTSB CEN26FA253Accident · 1 fatalClass 3 · FieldPreliminary reportMontana Coyote · Fredericksburg, VAOn July 14, 2026, about 1105 eastern daylight time, an experimental Montana Coyote airplane, N448VQ, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot was fatally injured. The airplane was operated as a…NTSB GAA26WA273Accident · No injuriesClass 5 · ForeignCessna 208 · Monterrey, MexicoNTSB ERA26FA270Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Metter, GAOn July 13, 2026, about 1114 eastern daylight time, a Beechcraft 95-B55, twin-engine airplane, N55FD, was destroyed when it was involved in an accident near Metter, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14…NTSB CEN26LA254Accident · 1 fatalClass 3 · LimitedPreliminary reportTag Aviation PTY Titanium Explorer · Larkspur, COOn July 13, 2026, about 800 mountain daylight time, a Tag Aviation Pty Ltd Titanium Explorer gyrocopter, N665TE was substantially damaged when it was involved in an accident near Larkspur, Colorado. The pilot passed away in the hospital five days after the…NTSB CEN26LA252Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT802 · Whiting, KSThe pilot's failure to maintain clearance from an antenna while maneuvering during a low-level aerial application flight.NTSB WPR26LA258Accident · No injuriesClass 3 · LimitedPreliminary reportRemos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZOn July 12, 2026, at 1018 mountain standard time, a Remos GX airplane, N126GX, was substantially damaged when it was involved in an accident near Glendale, Arizona. The flight instructor and student pilot were uninjured. The airplane was operated as a Title…NTSB GAA26WA254Incident · No injuriesForeign investigationBritish Aerospace HS-125-700 · Santa Lucia, MexicoNTSB GAA26WA250Accident · 2 fatalClass 5 · ForeignPiper PA28 · Seitenstetten, AustriaNTSB ERA26FA269Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 182 · Piseco, NYOn July 12, 2026, about 1909 eastern daylight time, a Cessna 182J, N43TB, was destroyed when it was involved in an accident near Piseco, New York. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB DCA26WA280Incident · No injuriesClass 5 · ForeignBoeing 767 · Manta, Ecuador