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 WPR26LA353Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 182P · Warren, IDNTSB WPR26LA350Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-12 · Salem, ORNTSB WPR26FA346Accident · 2 fatalClass 3 · FieldPreliminary reportAirbus AS332 · Yosemite Valley, CAOn September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use…NTSB ERA26LA347Accident · No injuriesClass 4 · LimitedInvestigation openShaffer John Thomas KR-2 · Westminster, OHNTSB WPR26LA365Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172R · Ho'olehua, HINTSB WPR26LA357Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 182Q · Water Valley, MSNTSB WPR26LA351Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · Medford, ORNTSB WPR26LA349Accident · Minor injuriesClass 4 · LimitedInvestigation openCameron Balloons US A-400 · Angwin, CANTSB ERA26LA352Accident · No injuriesClass 4 · LimitedInvestigation openHart Frank RV-8A · Sanford, NCNTSB ERA26LA349Accident · No injuriesClass 4 · LimitedInvestigation openBeech 200 · Dothan, ALNTSB ERA26LA345Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR20 · Asheville, NCOn September 19, 2026, at 1045 eastern daylight time, a Cirrus SR-20, N189WM, sustained substantial damage when it was involved in an accident near Ashville, North Carolina. The flight instructor and the student pilot received minor injuries. The airplane was…NTSB WPR26LA347Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B-III · Creswell, NCOn September 18, 2026, at 1018 eastern daylight time, a Bell 206B-III, N50141, was substantially damaged when it was involved in an accident near Creswell, North Carolina. The pilot was not injured. The helicopter was being operated as a Title 14 Code of…NTSB ERA26LA346Accident · 1 fatalClass 3 · LimitedPreliminary reportSchleicher ASW-24 · Edinburg, NYOn September 18, 2026, about 1426 eastern daylight time, a Schempp-Hirth Ventus-2B glider, N61XC, and a Schleicher ASW-24 glider, N94CG, collided in flight near Edinburg, New York. The pilot of the Schempp-Hirth was fatally injured and the glider was…NTSB ERA26LA344Accident · No injuriesClass 3 · LimitedPreliminary reportAerospatiale SA 315 · Workmore, GAOn September 18, 2026, at 1604 eastern daylight time, an Aerospatiale SA315B helicopter, N238HA was substantially damaged when it was involved in an accident near Workmore, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…NTSB ANC26FA106Accident · 2 fatalClass 3 · FieldInvestigation openPiper PA-18-150 · Northway, AKNTSB ERA26FA341Accident · 1 fatalClass 3 · FieldPreliminary reportWeatherly 620 · Lynchburg, SCOn September 17, 2026, about 0720 eastern daylight time, a Weatherly Aviation Company Inc. 602B, N20003, was substantially damaged when it was involved in an accident near Lynchburg, South Carolina. The pilot was fatally injured. The airplane was operated as…NTSB CEN26LA332Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA18 · Karinen, SDOn September 17, 2026, about 0710 mountain daylight time, a Piper PA18-150 airplane, N3879Z, was substantially damaged when it was involved in an accident near Karinen, South Dakota. The pilot was seriously injured. The airplane was operated as a Title 14…NTSB WPR26FA345Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter AS 350 B2 · Chatsworth, CAOn September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground…NTSB CEN26LA322Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172M · Hanover, INOn September 16, 2026, about 1905 eastern daylight time, a Cessna 172M airplane, N9909Q, was substantially damaged when it was involved in an accident near Hanover, Indiana. The pilot and passenger sustained minor injuries. The airplane was operated as a…NTSB WPR26LA366Accident · No injuriesClass 4 · LimitedInvestigation openAbbott Dudley L Levitator · Skwentna, AKNTSB WPR26LA348Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18-150 · Roundup, MTNTSB ERA26FA338Accident · 1 fatalClass 3 · FieldPreliminary reportReed Julian Estill RV-4 · Albertville, ALOn September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title…NTSB ANC26FA105Accident · 2 fatalClass 3 · FieldInvestigation openCessna A185F · Stony River, AKNTSB WPR26LA344Accident · Serious injuriesClass 4 · LimitedInvestigation openTaylorcraft BC12D · Nibbe, MTNTSB WPR26LA341Accident · No injuriesClass 4 · LimitedInvestigation openRugg Ranches CCK-1865 · Ogden, UTNTSB WPR26LA340Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · San Luis Obispo, CAOn September 13, 2026, about 1515 Pacific daylight time, a Cessna P210N airplane, N4617W, was substantially damaged when it was involved in an accident near San Luis Obispo, California. The pilot, pilot-rated-passenger, and a passenger were not injured. The…NTSB ERA26LA337Accident · No injuriesClass 4 · LimitedInvestigation openAir Tractor AT-602 · Morven, GANTSB CEN26LA321Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · Pagosa Springs, CONTSB CEN26LA320Accident · No injuriesClass 4 · LimitedInvestigation openDiamond Aircraft Ind DA20-C1 · Howell, MINTSB CEN26LA319Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech K35 · Wausau, WIOn September 12, 2026, about 2049 central daylight time, a Beech K35 airplane, N6071E, was substantially damaged when it was involved in an accident near Wausau, Wisconsin. The pilot and passenger suffered minor injuries. The flight was operated as a Title 14…NTSB CEN26LA318Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV4 · Harrisonville, MOOn September 13, 2026, about 0930 central daylight time, a Vans Aircraft Inc, RV-4, N254MM, was substantially damaged when it was involved in an accident near Harrisonville, Missouri. The pilot and passenger were not injured. The airplane was operated as a…NTSB CEN26LA317Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 II · Natchez, MSNTSB ANC26LA104Accident · No injuriesClass 4 · LimitedInvestigation openTaylorcraft BL-65 · Ninilchik, AKNTSB ANC26LA103Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Colquitt, GAOn September 11, 2026 about 0830 eastern daylight time, a Robinson R44 helicopter, N4026E, was substantially damaged when it was involved in an accident near Colquitt, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…NTSB ANC26LA102Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · Willow, AKNTSB WPR26LA339Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR22T · Santa Teresa, NMNTSB WPR26LA338Accident · No injuriesClass 4 · LimitedInvestigation openCcx-2000-0007 CCX-2000 · Colorado City, AZNTSB WPR26LA336Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18-150 · Moses Lake, WANTSB WPR26LA335Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 210 · Polson, MTOn September 10, 2026, about 1005 mountain daylight time, a Cessna 210, N9517T, was substantially damaged when it was involved in an accident near Polson Airport (8S1), Polson, Montana. The student pilot was not injured. The airplane was operated as a Title…NTSB CEN26LA316Accident · No injuriesClass 3 · LimitedPreliminary reportBeech 99 · Belleville, MIOn September 10, 2026, about 1545 eastern daylight time, a Beech 99 airplane, N799CZ, and a Diamond DA20 airplane, N84VV were involved in a ground collision accident at the Willow Run Airport, Belleville, Michigan. N799CZ received minor damage and N84VV…NTSB ANC26LA101Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-18A 150 · Palmer, AKNTSB ANC26LA100Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA12 · Arctic Village, AKNTSB WPR26LA337Accident · No injuriesClass 4 · LimitedInvestigation openWawrzynski Vincent P RV-7 · Columbia, CANTSB WPR26LA334Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 200 · Roswell, NMOn September 8, 2026, about 0044 mountain daylight time, N393JW, a Beech 200, was substantially damaged when it was involved in an accident near Roswell, New Mexico. The two pilots and two of the medical crew members were not injured, a third medical crew…NTSB WPR26LA333Accident · No injuriesClass 4 · LimitedInvestigation openNord Stampe SV4C · Camas, WANTSB WPR26FA330Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · San Diego, CAOn September 7, 2026, about 1720 Pacific daylight time, a Cessna 172N, N734ZK, was destroyed when it was involved in an accident near San Diego, California. The flight instructor and student pilot were fatally injured. The airplane was being operated as a…NTSB CEN26LA314Accident · No injuriesClass 4 · LimitedInvestigation openCessna 150F · Weslaco, TXNTSB CEN26LA313Accident · Minor injuriesClass 3 · LimitedPreliminary reportStearman A75 · Bogue Chitto, MSOn September 8, 2026, about 1100 central daylight time, a Boeing-Stearman A75L300 airplane, N680HW, was substantially damaged when it was involved in an accident near Bogue Chitto, Mississippi. The pilot sustained minor injuries and the passenger was…NTSB ERA26LA342Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Panama City, FLOn September 7, 2026, about 1059 central daylight time, a Cessna 172N airplane, N734NM, was substantially damaged when it was involved in an accident near Panama City, Florida. The student pilot and flight instructor were not injured. The airplane was…NTSB ERA26LA333Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22 · Ashland, OHOn September 7, 2026, about 1255 eastern daylight time, a Cirrus Design Corp SR22, N521LM, was substantially damaged when it was involved in an accident near Ashland, Ohio. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…