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 ERA26LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna T182T · Venice, FLThe pilot’s failure to maintain directional control while taxiing in gusty, quartering tailwind conditions.NTSB ERA26LA009Accident · No injuriesClass 4 · LimitedFinal reportCessna 182H · Smithfield, RIMaintenance personnel’s improper rigging of the elevator trim system, which resulted in a hard landing. Contributing was the maintenance personnel and pilot’s failure to perform adequate post maintenance/preflight inspections.NTSB ERA26LA005Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Reedville, VAThe pilot’s sudden incapacitation by an episode of abnormal heartbeat due to heart disease during a takeoff attempt, which resulted in a loss of directional control and runway excursion.NTSB ERA26LA002Accident · No injuriesClass 4 · LimitedFinal reportMaule M-7-260 · Parkland, FLThe pilot’s failure to retract the amphibious airplane’s landing gear before conducting a forced landing on the water, which resulted in a nose over.NTSB GAA26WA003Accident · 1 fatalClass 4 · ForeignRobinson R22 · Brogans Creek, AustraliaNTSB GAA26WA002Accident · No injuriesClass 3 · ForeignCirrus SR22 · Al-Maktoum, United Arab EmiratesNTSB ERA26LA016Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Bluffton, OHThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB DCA26WA003IncidentClass 5 · ForeignBoeing 737 · Manchester, United KingdomNTSB CEN26LA009Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182RG · Cottonville, IAOn October 3, 2025, about 1720 central daylight time, a Cessna 182RG airplane, N4609S, was substantially damaged when it was involved in an accident near Cottonville, Iowa. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA006Accident · No injuriesClass 3 · LimitedPreliminary reportSiai-Marchetti SM 1019 · Richland, WAOn October 2, 2025, about 1050 Pacific daylight time, a Siai-Marchetti SM 1019, N3172U, sustained substantial damage when it was involved in an accident near Richland, Washington. The pilot and passenger were not injured. The airplane was operated as a Title…NTSB ERA26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Talladega, ALOn October 2, 2025, at 1126 central daylight time, a Cirrus SR22, N812SE, was substantially damaged when it was involved in an accident near Talladega, Alabama. The commercial pilot sustained minor injuries, and the two passengers were not injured. The…NTSB DCA26FA001Accident · Minor injuriesClass 3 · FieldPreliminary reportBombardier CL-600-2D24 · New York, NYOn October 1, 2025, about 2156 eastern daylight time (EDT), Endeavor Air dba Delta Connection flight 5155, a Mitsubishi Heavy Industries (MHI) RJ CL-600-2D24 (CRJ-900), N902XJ, collided with Endeavor Air dba Delta Connection flight 5047, a MHI RJ CL-600-2D24…NTSB CEN26LA013Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Chaseley, NDThe pilot’s excessive braking during the landing roll, which resulted in a nose over.NTSB CEN26LA004Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · North La Junta, COThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB WPR26LA002Incident · No injuriesClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0958 mountain standard time, an Amazon.Com Services LLC, MK30, N791PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…NTSB WPR26LA001IncidentClass 3 · LimitedPreliminary reportAmazon.Com Services MK30 · Tolleson, AZOn October 1, 2025, about 0949 mountain standard time, an Amazon.Com Services LLC, MK30, N579PA, was substantially damaged when it was involved in an incident near Tolleson, Arizona. There were no injuries. The unmanned aircraft system (UAS) was operated as a…NTSB GAA26WA001Incident · No injuriesClass 5 · ForeignCessna F172 · Durup, DenmarkNTSB CEN26LA011Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Portage, WIThe student pilot’s failure to maintain proper airspeed and attitude for a short field landing. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB CEN26LA003Accident · No injuriesClass 4 · LimitedFinal reportQuartz Mountain Aerospace 11E · Earlham, IAThe flight instructor’s inadequate fuel management which resulted in the total loss of engine power due to fuel exhaustion.NTSB CEN26LA002Accident · Minor injuriesClass 4 · LimitedFinal reportChampion 7GC · Haskell, OKThe pilot’s excessive braking during the landing roll, which resulted in a nose over. Contributing to the accident was the pilot’s lack of experience with the recently installed brakes and tundra tires.NTSB CEN26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · Colorado Springs, COOn October 1, 2025, about 0412 mountain daylight time, a Piper PA-28R-200 airplane, N999AD, was substantially damaged during an accident near Colorado Springs, Colorado. The pilot sustained minor injuries, and the 2 passengers were not injured. The airplane…NTSB ANC25LA117Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-31 · Kotlik, AKThe pilot’s failure to extend the landing gear before landing.NTSB DCA25LA341Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A321 · Las Vegas, NVThe airplane’s encounter with turbulence during descent resulting in a serious injury to a flight attendant who was standing at the time of the encounter.NTSB CEN25LA405Accident · Minor injuriesClass 4 · LimitedFinal reportSukhoi SU-26MX · Longmont, COThe pilot's failure to maintain directional control during takeoff.NTSB CEN25LA404Accident · No injuriesClass 4 · LimitedFinal reportCirrus SR20 · Watertown, WIThe flight instructor’s failure to maintain control of the airplane following the student pilot’s bounced landing. Contributing to the accident was the flight instructor’s delayed remedial action which resulted in diminished airplane performance during the…NTSB WPR25LA304Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Avalon, CAThe pilot’s decision to land with a tailwind and a downslope to the runway.NTSB ERA25LA375Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Punxsutawney, PAThe airplane’s collision with a deer on a runway during landing roll.NTSB DCA25WA346IncidentClass 5 · ForeignBoeing 737 · Smuka, SloveniaNTSB CEN25LA403Accident · No injuriesClass 4 · LimitedFinal reportAeronca 11AC · Longmont, COThe pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and the pilot’s improper landing flare which resulted in a hard landing.NTSB ERA25LA379Accident · No injuriesClass 4 · LimitedFinal reportMccaa Robert T Avid/Kitfox Flyer · Oakland, PAThe pilot/owner’s failure to accurately determine the airplane’s weight and performance limitations before initiating the takeoff. Contributing to the outcome was the flight instructor’s improper engine power management and landing flare, which resulted in a…NTSB ERA25LA376Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · West Milford, NJThe pilot’s improper landing flare and subsequent failure to recover from a hard bounced landing, which resulted in a loss of directional control and runway excursion.NTSB ERA25LA371Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American T-6G · Rossville, TNThe pilot’s failure to adequately monitor the airplane’s path during takeoff toward the setting sun. Contributing was the undetected worn and fractured tailwheel locking pin.NTSB ERA25LA369Accident · No injuriesClass 3 · LimitedPreliminary reportGregory A Spicola AR-1 · Fort Myers, FLOn September 28, 2025, about 1000 EST, a Spicola AR-1 gyroplane, N107AR, was substantially damaged when it was involved in an accident at Buckingham Field Airport (FL59), Lehigh Acres, Florida. The commercial pilot and pilot-rated passenger were not injured.…NTSB ERA25LA368Accident · No injuriesClass 3 · LimitedPreliminary reportElmore Travis C Searey · Rotonda West, FLOn September 28, 2025, at 1126 eastern daylight time, an experimental, amateur-built Searey, N2090S, was substantially damaged when it was involved in an accident near Stump Pass, Florida. The private pilot sustained minor injuries. The airplane was operated…NTSB CEN25LA399Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV9 · Stephenville, TXThe pilot’s failure to ensure the canopy and the cockpit were properly secured during the hand prop sequence.NTSB CEN25FA395Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 340 · Klein, TXOn September 28, 2025, about 1212 central daylight time, a Cessna 340 airplane, N269WT, was destroyed when it was involved in an accident near Klein, Texas. The pilot and passenger were fatally injured. The airplane was operated as a Title Code of Federal…NTSB ANC25LA116Accident · No injuriesClass 4 · LimitedFinal reportSocata TBM 700 · Alpine, WYThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent off airport landing.NTSB WPR25LA299Accident · Serious injuriesClass 3 · LimitedPreliminary reportVans RV3-A · Torrington, WYOn September 27, 2025, about 1600 mountain daylight time, an experimental amateur-built Vans RV-3A, N16MR, sustained substantial damage when it was involved in an accident near Torrington, Wyoming. The pilot was seriously injured. The airplane was operated as…NTSB WPR25LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 185A · Ilwaco, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA25WA291Accident · 1 fatalClass 5 · ForeignPilatus PC6 · Moruya, AustraliaNTSB ERA25LA377Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Okeechobee, FLCollision with a bird during cruise flight.NTSB ERA25FA367Accident · 1 fatalClass 3 · FieldPreliminary reportToop Thomas A Glasair Super II FT · Wallkill, NYOn September 27, 2025, at 1418 eastern daylight time, an experimental, amateur-built Glasair Super II FT, N45BT, was destroyed when it was involved in an accident near Wallkill, New York. The pilot sustained fatal injuries. The airplane was operated as a…NTSB CEN25LA398Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-60-601P · Del Norte, COThe loss of directional control during landing roll due to a flat tire.NTSB CEN25LA397Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DH82 · Harvard, ILThe pilot’s failure of the pilot to maintain directional control during takeoff which resulted in a collision with cornstalks. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.NTSB CEN25LA396Accident · No injuriesClass 4 · LimitedFinal reportBell 206 · Archer City, TXThe pilot’s failure to maintain clearance from power lines while herding livestock.NTSB ANC25LA114Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Morgan, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB ANC25LA113Accident · No injuriesClass 4 · LimitedFinal reportCessna 140A · Los Banos, CAThe pilot’s failure to maintain directional control during the landing roll with a crosswind, resulting in a ground loop and nose over.NTSB WPR25LA305Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 150F · Lake Havasu City, AZOn September 26, 2025, at about 0915 mountain standard time, a Cessna 150F, N8171S, was substantially damaged when it was involved in an accident near Lake Havasu City, Arizona. The flight instructor and student pilot sustained minor injuries. The airplane…NTSB WPR25LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Hayden, IDThe student pilot’s inability to maintain control of the airplane during a sudden wind gust resulting in the airplane coming to rest inverted.NTSB WPR25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportSiai-Marchetti SF260B · Billings, MTOn September 26, 2025, about 1040 mountain daylight time, a SIAI-MARCHETTI SF 260B, N272C, was substantially damaged when it was involved in an accident near Billings, Montana. The pilot and passenger were not injured. The airplane was operated as a Title 14…