NTSB investigations
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 ERA26LA017Accident · Serious injuriesClass 4 · LimitedFinal reportTricks Trike Storm · Gaffney, SCThe pilot’s failure to maintain aircraft control during the initial climb, which resulted in an impact with terrain.NTSB ERA26LA014Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · North Lauderdale, FLA total loss of engine power due to a fuel delivery system leak, which allowed air to enter the fuel system. The source of the leak could not be determined based on the available evidence.NTSB ERA26FA011Accident · 2 fatalClass 3 · FieldPreliminary reportSocata TBM 700 · Dartmouth, MAOn October 13, 2025, at about 0815 eastern daylight time, a Socata TBM 700C2, N111RF, was substantially damaged when it was involved in an accident near Dartmouth, Massachusetts. The private pilot and the passenger were fatally injured and an automobile…NTSB DCA26WA010Incident · No injuriesClass 5 · ForeignBoeing 767 · Ezeiza, ArgentinaNTSB CEN26LA016Accident · No injuriesClass 3 · LimitedPreliminary reportRotorway AG162 · Valley View, TXOn October 13, 2025, at 1229 central daylight time, a Rotorway AG162 helicopter, N162AD, sustained substantial damage when it was involved in an accident near Valley View, Texas. The pilot and passenger were uninjured. The helicopter was operated under Title…NTSB WPR26LA016Accident · No injuriesClass 4 · LimitedFinal reportBeech S35 · Olympia, WAThe pilot’s inadvertent retraction of the landing gear after landing.NTSB ERA26FA010Accident · 2 fatalClass 3 · FieldPreliminary reportBeech C90 · Fort Worth, TXOn October 12, 2025, about 1334 central daylight time, a Beech C90, N291CC, was destroyed when it was involved in an accident near Fort Worth, Texas. The private pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title 14…NTSB DCA26WA007Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Balice, PolandNTSB CEN26LA017Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Springfield, COThe pilot's failure to maintain directional control during the takeoff with a right crosswind.NTSB ERA26LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Plymouth, CTThe plot’s failure to account sufficiently for the decrease in the airplane’s takeoff performance due to the wet turf runway, which resulted in a collision with a log barrier and subsequent nose over after aborting the takeoff.NTSB ERA26LA012Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Sandersville, GAOn October 10, 2025, about 2015 eastern daylight time, a Cessna 172G, N4390L, was substantially damaged when it was involved in an accident near Sandersville, Geogia. The pilot was not injured and the passenger sustained minor injuries. The airplane was…NTSB CEN26LA018Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Astir CS · Wallis, TXThe pilot’s failure to maintain control during landing roll that resulted in an impact with terrain.NTSB CEN26FA015Accident · Serious injuriesClass 3 · FieldPreliminary reportBell 222 · Huntington Beach, CAOn October 11, 2025, at 1401 Pacific daylight time, a Bell 222 helicopter, N222EX, was substantially damaged when it was involved in an accident near Huntington Beach, California. The pilot and passenger received serious injuries. One person on the ground…NTSB WPR26LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 185C · Phoenix, AZThe pilot's failure to maintain directional control during the landing roll with a left crosswind.NTSB GAA26WA008Accident · 1 fatalClass 5 · ForeignPiper PA28 · Pilanesberg, South AfricaNTSB GAA26WA006Accident · 3 fatalClass 5 · ForeignPiper PA32 · Shell Harbor, AustraliaNTSB ERA26LA015Accident · No injuriesClass 4 · LimitedFinal reportSocata TB 10 · New Milford, CTThe pilot’s decision to depart from an unlit turf runway at night, which resulted in a loss of directional control, and subsequent runway excursion.NTSB DCA26WA004IncidentClass 5 · ForeignBoeing 777 · Nassau, BahamasNTSB CEN26LA019Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Bonilla, SDThe pilot’s inadequate flight planning and his failure to maintain aircraft control during the precautionary off-airport landing.NTSB WPR26LA018Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Imnaha, ORThe pilot’s continued application of brakes during an aborted takeoff in a tailwind on down-sloping terrain, which resulted in a nose-over.NTSB GAA26WA054Accident · No injuriesClass 4 · ForeignCessna 185 · Rafaela, ArgentinaNTSB GAA26WA007Accident · 1 fatalClass 5 · ForeignRobinson R22 · Rutland Plains, AustraliaNTSB GAA25WA278AccidentClass 5 · ForeignBeechraft C90A · Sakwai, IndiaNTSB DCA26WA011Incident · No injuriesClass 5 · ForeignBoeing 767 · Ochiltree, United KingdomNTSB WPR26LA012Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Vineyard, UTOn October 7, 2025, about 1825 mountain daylight time, a Piper PA24 airplane, N7946P, was substantially damaged in an accident near Vineyard, Utah. The pilot and pilot-rated passenger were not injured. The flight was conducted under Title 14 Code of Federal…NTSB GAA26WA005AccidentClass 5 · ForeignRobinson R44 · Horn Island, AustraliaNTSB ENG26WA001IncidentClass 5 · ForeignSaab 340 · Adelaide Aerodrome, AustraliaNTSB WPR26LA009Accident · No injuriesClass 4 · LimitedFinal reportMooney M20C · Watsonville, CAThe pilot’s decision to program avionics during taxi, resulting in an inadvertent throttle input and collision with a hangar.NTSB WPR26FA008Accident · 1 fatalClass 3 · FieldPreliminary reportAirbus Helicopters EC 130 T2 · Sacramento, CAOn October 6, 2025, about 1905 Pacific daylight time, an Airbus Helicopters EC-130 T2, N414RX, was substantially damaged when it was involved in an accident in Sacramento, California. The pilot and flight paramedic sustained serious injuries; the flight nurse…NTSB GAA26WA009Accident · Serious injuriesClass 4 · ForeignBell 214B-1 · Squamish, CanadaNTSB ERA26LA008Accident · No injuriesClass 4 · LimitedFinal reportChampion 7ECA · East Rockingham, NCThe pilot’s failure to maintain control of the airplane during initial climb, resulting in an aerodynamic stall and impact with terrain.NTSB ERA26LA007Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Miami, FLOn October 07, 2025, at 1440 eastern daylight time, a Cessna 172M, N433PT, was substantially damaged when it was involved in an accident near Miami, Florida. The private pilot and the flight instructor were uninjured. The airplane was operated as a Title 14…NTSB ENG26WA002AccidentClass 5 · ForeignThrush S2R · San Ramón de la Nueva Orán, ArgentinaNTSB CEN26FA012Accident · 1 fatalClass 3 · FieldPreliminary reportBeech A35 · Skidmore, TXOn October 7, 2025, at 1223 central daylight time, a Beech A35 airplane, N577B, was destroyed when it was involved in an accident near Skidmore, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…NTSB ANC26LA001Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Petersburg, AKOn October 7, 2025, at 1456 Alaska daylight time, a Cessna 172 airplane, N80628, was substantially damaged when it was involved in an accident near Petersburg, Alaska. The student pilot and flight instructor were not injured. The airplane was operated as a…NTSB WPR26LA021Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · Albuquerque, NMThe pilot's failure to maintain clearance from a power line during a descent for landing.NTSB WPR26LA007Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Gila Bend, AZThe pilot’s improper throttle input and failure to maintain aircraft control during landing.NTSB ERA26LA004Accident · No injuriesClass 3 · LimitedPreliminary reportPitts S1C · Mount Washington, KYOn October 6, 2025, about 1415 eastern daylight time, a Pitts S-1C Special, C-FAZJ, was substantially damaged when it was involved in an accident in Mt. Washington, Kentucky. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA003Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · West Milford, NJThe pilot’s failure to adequate clearance from obstacles while maneuvering during the landing approach and the instructor pilot’s delayed remedial action, which resulted in the airplane contacting a tree and terrain.NTSB CEN26FA010Accident · 3 fatalClass 3 · FieldPreliminary reportCessna 210B · Parkin, AROn October 6, 2025, about 1514 central daylight time, a Cessna 210B airplane, N9627X, was destroyed when it was involved in an accident near Parkin, Arkansas. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA010Accident · No injuriesClass 4 · LimitedFinal reportGlasflugel STD Libelle 201B · Moriarty, NMThe glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.NTSB CEN26LA008Accident · Serious injuriesClass 3 · LimitedPreliminary reportLancair 320 · Huron, INOn October 4, 2025, about 2130 central daylight time, a Lancair 320 airplane, N431M, was destroyed when it was involved in an accident near Huron, Indiana. The pilot was seriously injured. The airplane was operated under Title 14 Code of Federal Regulations…NTSB CEN26LA007Accident · Serious injuriesClass 4 · LimitedFinal reportCessna R172 · Mount Carroll, ILThe pilot’s failure to maintain aircraft control during a go around in gusty wind conditions.NTSB CEN26LA006Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · McGregor, MNOn October 5, 2025, about 1310 central daylight time, a Piper PA-28-140, N4218T was substantially damaged when it was involved in an accident near McGregor, Minnesota. The pilot and two passengers were seriously injured. The airplane was operated under the…NTSB CEN26FA005Accident · 3 fatalClass 3 · FieldPreliminary reportBeech 58P · Williston, FLOn October 5, 2025, at 1610 eastern daylight time, a Beech 58P airplane, N121GJ, was destroyed when it was involved in an accident near Williston, Florida. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of…NTSB WPR26LA048Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A1 · Evanston, WYThe airplane’s encounter with downdrafts in mountainous terrain, which resulted in a collision with terrain. Contributing to the accident was the pilot’s decision to continue the flight through mountainous terrain in marginal weather conditions.NTSB WPR26LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Lathrop, CAAn inflight collision with a bird.NTSB WPR26LA014Accident · No injuriesClass 4 · LimitedFinal reportMaye James A Just Aircraft Escapade · Flanigan, NVThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR26LA003Accident · No injuriesClass 4 · LimitedFinal reportWilley Frank C Jr. Avid Mark 4 · Boulder City, NVThe pilot’s failure to maintain directional control while landing.NTSB GAA26WA004Accident · 2 fatalClass 5 · ForeignCessna 172 · Santa Ana del Yacuma, Bolivia