Ongoing NTSB investigations
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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 WHERE c.\"completionStatus\" = 'Ongoing' 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 WHERE c."completionStatus" = 'Ongoing' 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 CEN26LA312Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 337 · Brenham, TXOn September 7, 2026, about 1248 central daylight time, a Cessna 337C airplane, N2657S, sustained substantial damage when it was involved in an accident near Brenham, Texas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…NTSB CEN26FA311Accident · 2 fatalClass 3 · FieldPreliminary reportEXP Stol CH701 · Neosho, MOOn September 7, 2026, about 1337 central daylight time, an experimental STOL CH701 airplane, N101XV, sustained substantial damage when it was involved in an accident near Neosho, Missouri. The pilot and passenger sustained fatal injuries. The airplane was…NTSB CEN26FA310Accident · 1 fatalClass 3 · FieldPreliminary reportMooney M20F · Titusville, FLOn September 7, 2026, about 1015 eastern daylight time, a Mooney M20F airplane, N9546M, was destroyed when it was involved in an accident near Titusville, Florida. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC26LA098Accident · Serious injuriesClass 3 · LimitedPreliminary reportPitts Model 12 · Lake Stevens, WAOn September 6, 2026, about 1800 Pacific daylight time, an experimental Pitts Model 12 airplane, N491X, was substantially damaged when it was involved in an accident near Lake Stevens, Washington. The pilot sustained serious injuries. The airplane was…NTSB WPR26LA331Accident · Serious injuriesClass 4 · LimitedInvestigation openFilip Richard/Fakowee Avia Indus Thrp T211 SP E · Benson, AZNTSB ERA26LA331Accident · No injuriesClass 3 · LimitedPreliminary reportBell 47G-4A · Alcoma, FLOn September 5, 2026, at 1422 eastern daylight time, a Bell 47G-4A, N797WS, was substantially damaged when it was involved in an accident near Alcoma, Florida. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal Regulations…NTSB ERA26FA329Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Ludlow, MAOn September 5, 2026, about 2105 eastern daylight time, a Piper PA-28-181, N7653F, was destroyed when it was involved in an accident near Ludlow, Massachusetts. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…NTSB DCA26MA352Accident · 5 fatalClass 1 · MajorPreliminary reportBoeing 767 · Miami, FLOn September 6, 2026, about 1353 eastern daylight time (EDT), 21 Air flight 7598, a Boeing 767-33A, N1997A, overran runway 30 after landing at Miami International Airport (MIA), Miami, Florida and subsequently impacted two ground passenger vehicles. The two…NTSB WPR26FA329Accident · 4 fatalClass 3 · FieldPreliminary reportGrumman American Avn. AA-5 · Fresno, CAOn September 5, 2026, about 1345 Pacific daylight time, a Grumman AA-5, N6510L, was destroyed when it was involved in an accident near Fresno, California. The pilot and 3 passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA356Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172G · Shelby, NCNTSB WPR26LA332Accident · No injuriesClass 4 · LimitedInvestigation openCessna 152 · Carlsbad, CANTSB ERA26LA343Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR20 · California, MDNTSB ERA26LA328Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-180 · Dallas, GAOn September 3, 2026, at 2004 eastern daylight time, a Piper PA-28-180, N7635W, was substantially damaged when it was involved in an accident near Dallas, Georgia. The flight instructor and student pilot were seriously injured. The airplane was operated as a…NTSB WPR26LA328Accident · No injuriesClass 3 · LimitedPreliminary reportBell OH-58A · Phoenix, AZOn September 3, 2026, about 0932 mountain standard time, a Bell OH-58, N480FT, sustained substantial damage when it was involved in an accident near Deer Valley, Arizona. The pilots did not sustain any injuries. The helicopter was operated as a Title 14 Code…NTSB ERA26FA326Accident · 2 fatalClass 3 · FieldPreliminary reportMaclura Evolution · Tampa, FLOn September 3, 2026, about 0815 eastern daylight time, an experimental, amateur-built Evolution airplane, N305PV, was destroyed when it was involved in an accident near Tampa, Florida. The commercial pilot and passenger were fatally injured. The airplane was…NTSB CEN26LA308Accident · Serious injuriesClass 3 · LimitedPreliminary reportSix Chuter SR7 XL · Amery, WIOn September 2, 2026, about 2007 central daylight time, a Six Chuter SR7XL experimental light-sport powered parachute, N5617X, was involved in an accident near Amery, Wisconsin. The pilot was seriously injured. The powered parachute was operated as a Title 14…NTSB ANC26FA097Accident · 2 fatalClass 3 · FieldPreliminary reportCessna T206H · Dunton, COOn September 3, 2026, about 1518 mountain daylight time, a Cessna T206H airplane, N919CW, was destroyed when it was involved in an accident near Dunton, Colorado. The pilot and passenger were fatally injured. The flight was operated as a Title 14 Code of…NTSB ERA26LA325Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 210 · Dawson Springs, KYOn September 1, 2026, at 2225 central daylight time, a Cessna 210K, N9420M, was substantially damaged when it was involved in an accident near Dawson Springs, Kentucky. The private pilot and passenger were not injured. The airplane was operated as a Title 14…NTSB CEN26LA309Accident · No injuriesClass 4 · LimitedInvestigation openMooney M20E · West Branch, IANTSB WPR26LA327Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 150E · Siler, WAOn September 1, 2026, at 1220 Pacific daylight time, a Cessna 150E, N3037J, sustained substantial damage when it was involved in an accident near Siler, Washington. The pilot and pilot rated passenger were not injured. The airplane was operated as a Title 14…NTSB WPR26LA326Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 560XL · Porterville, CAOn September 1, 2026, about 1142 Pacific daylight time, a Cessna 560XL airplane, N562JL, was substantially damaged when it was involved in an accident near Porterville, California. The two pilots sustained minor injuries, and the four passengers were not…NTSB CEN26LA305Accident · No injuriesClass 4 · LimitedInvestigation openBoeing A75L300 · Taylor, TXNTSB ANC26LA096Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna R182 · Lebanon, TNOn September 1, 2026, about 1815 eastern daylight time, a Cessna R182 airplane was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ANC26LA095Accident · No injuriesClass 4 · LimitedInvestigation openChampion 7DC · Copper Center, AKNTSB WPR26FA320Accident · 2 fatalClass 3 · FieldPreliminary reportMooney M20C · Mount Hood, OROn August 31, 2026, about 1131 Pacific daylight time, a Mooney M20C, N2783W, was destroyed when it was involved in an accident near Hood River, Oregon. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA306Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR22T · Spicewood, TXNTSB ANC26LA099Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-210C · Venetie, AKNTSB WPR26LA367Accident · No injuriesClass 3 · LimitedInvestigation openHawker Beechcraft G36 · Murrieta, CANTSB WPR26LA324Accident · No injuriesClass 3 · LimitedPreliminary reportZenith CH701 · Byron, CAOn August 30, 2026, about 0905 Pacific daylight time, an experimental amateur-built Zenith CH701, N701WJ, was substantially damaged when it was involved in an accident at Byron Airport (C83), Byron, California. The pilot was not injured. The airplane was…NTSB WPR26LA323Accident · No injuriesClass 4 · LimitedInvestigation openBeech E-55 · Mecca, CANTSB ERA26LA324Accident · No injuriesClass 4 · LimitedInvestigation openCSP Leasing Cavalon · Ronkonkoma, NYNTSB ERA26LA321Accident · No injuriesClass 4 · LimitedInvestigation openCessna R182 · Clarksville, TNNTSB ERA26FA317Accident · 2 fatalClass 3 · FieldPreliminary reportConsolidated Aeronautics Lake LA-4-200 · Ithaca, NYOn August 30, 2026, about 1250 eastern daylight time, a Consolidated Aeronautics Inc., Lake LA-4-200, N6185V, was substantially damaged when it was involved in an accident near Ithaca, New York. The pilot and passenger were fatally injured. The airplane was…NTSB ANC26LA094Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna 180A · Cordova, AKNTSB ERA26LA319Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA22 · Pace, FLOn August 29, 2026, about 1030 central daylight time, a Piper PA-22-150, N5731D, was substantially damaged when it was involved in an accident near Pace, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ANC26LA093Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18 · Beluga, AKNTSB WPR26LA322Accident · Serious injuriesClass 4 · LimitedInvestigation openKrugh Patrick M Steen Skybolt · Big Bear, CANTSB WPR26LA321Accident · No injuriesClass 3 · LimitedPreliminary reportWestwind 1124A · Las Vegas, NVOn August 28, 2026, about 0145 Pacific daylight time, an IAI 1124A Westwind airplane, Canadian registration C-GIAW, was substantially damaged when it was involved in an accident at Harry Reid International Airport (LAS), Las Vegas, Nevada. The two pilots, and…NTSB CEN26LA303Accident · No injuriesClass 4 · LimitedInvestigation openAmerican Champion 8GCBC · Westminster, CONTSB WPR26LA342Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180E · Salem, ORNTSB ERA26LA320Accident · No injuriesClass 3 · LimitedPreliminary reportHawker Beechcraft 400A · Newark, NJOn August 27, 2026, about 1625 eastern daylight time, a Hawker Beechcraft Corporation 400A airplane, N199TT, was substantially damaged when it was involved in an accident near Newark, New Jersey. The airline transport pilot and commercial pilot were not…NTSB ERA26LA316Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-18A 150 · New Smyrna Beach, FLOn August 27, 2026, about 1051 eastern daylight time, a Piper PA-18A 150, N2368P, was substantially damaged when it was involved in an accident near New Smyrna Beach, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB DCA26LA340Accident · Serious injuriesClass 4 · LimitedInvestigation openAirbus A319-132 · Houston, TXNTSB ANC26LA092Accident · Minor injuriesClass 4 · LimitedInvestigation openAutogyro Cavalon · Conroe, TXNTSB WPR26LA318Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · South Lake Tahoe, CANTSB ANC26FA091Accident · 4 fatalClass 3 · FieldPreliminary reportPiper PA-24-260 · Seldovia, AKOn August 26, 2026 about 1317 Alaska daylight time, a Piper PA-24-260 airplane, N9485P, was substantially damaged when it was involved in an accident near Seldovia, Alaska. The pilot and three passengers were fatally injured. The airplane was operated as a…NTSB WPR26LA317Accident · No injuriesClass 4 · LimitedInvestigation openBoeing A75N1(PT17) · Cedar Rapids, IANTSB CEN26LA301Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 172M · Frankston, TXNTSB ANC26LA090Accident · No injuriesClass 4 · LimitedInvestigation openRepublic RC-3 · Evansville, INNTSB WPR26LA319Accident · No injuriesClass 4 · LimitedInvestigation openRotorsport UK Rotorsport UK Cavalo · Brenham, TX