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 ERA27FA004Accident · 1 fatalClass 3 · FieldInvestigation openHughes 269B · Lahmansville, WVNTSB ENG27LA001Incident · No injuriesClass 4 · LimitedInvestigation openBoeing 777-222 · San Francisco, CANTSB WPR27LA018Accident · Serious injuriesClass 4 · LimitedInvestigation openChristen Industries Pitts S-2B · Yuma, AZNTSB ERA27LA016Accident · No injuriesLimited investigationInvestigation openPiper PA-31T2 · Dayton, OHNTSB CEN27LA005Accident · 2 fatalClass 3 · LimitedPreliminary reportDiamond Aircraft Ind DA 40 · Eldorado Springs, COOn October 4, 2026, about 2130 mountain daylight time, a Diamond Aircraft DA-40 airplane, N162GL, was destroyed when it was involved in an accident near Eldorado Springs, Colorado. The pilot and passenger were fatally injured. The airplane was operated as a…NTSB WPR27LA008Accident · No injuriesClass 3 · LimitedInvestigation openHakala John Charles Lancair IV-P-T · Ontario, ORNTSB WPR27LA002Accident · No injuriesClass 3 · LimitedInvestigation openCessna P210N · Stevensville, MTNTSB WPR27LA004Accident · No injuriesClass 4 · LimitedInvestigation openHead Balloons AX8-88B · Albuquerque, NMNTSB WPR27LA003Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-235C · Agua Dulce, CANTSB ERA27LA005Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182A · Lexington, OHNTSB CEN27LA003Accident · No injuriesClass 3 · LimitedPreliminary reportSocata TB 9 Tampico · Loveland, COOn October 13, 2026, at 1412 mountain daylight time, a Socata TB 9 Tampico, N167GT, sustained substantial damage when it was involved in an accident near Loveland, Colorado. The private pilot and a passenger were uninjured. The airplane was operated as a…NTSB CEN27LA002Accident · Minor injuriesClass 4 · LimitedInvestigation openPost Thorp T-18 · Brazil, INNTSB CEN27LA004Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 414A · Boerne, TXOn October 2, 2026, about 1352 central daylight time, a Cessna 414A airplane, N1245A, was destroyed when it was involved in an accident near Boerne, Texas. The pilot and pilot-rated passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB WPR27LA010Accident · No injuriesClass 4 · LimitedInvestigation openCessna A185F · Madera, CANTSB WPR27LA009Accident · Serious injuriesLimited investigationInvestigation openCessna 172N · Knights Landing, CANTSB WPR27FA001Accident · 1 fatalClass 3 · FieldInvestigation openRoesler Scott D Roesler Glasair · Everett, WANTSB WPR26FA363Accident · 3 fatalClass 3 · FieldPreliminary reportEurocopter Deutschland EC 135 P2+ · Avalon, CAOn September 30, 2026, about 1946 Pacific daylight time, a Eurocopter Deutschland GMBH EC-135 P2+, N313RX, was substantially damaged when it was involved in an accident near Avalon, California. The pilot, flight nurse, and patient were fatally injured; the…NTSB ERA27LA003Accident · No injuriesClass 4 · LimitedInvestigation openHawker Siddeley HS.125 Series 700A · Fort Lauderdale, FLNTSB ERA27LA001Accident · Minor injuriesClass 4 · LimitedInvestigation openKinner Sportwing B-2 · Brunswick, MENTSB ANC27LA001Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna U206F · Meadow Lakes, AKNTSB WPR27LA011Accident · No injuriesClass 4 · LimitedInvestigation openEnstrom Helicopter 480 · Chelan, WANTSB WPR26LA368Accident · No injuriesClass 4 · LimitedInvestigation openGronberger Sergio A Sportsman GS-2 · Lake Goodwin, WANTSB ERA26LA357Accident · No injuriesClass 4 · LimitedInvestigation openGrumman American Avn. GA-7 · Knoxville, TNNTSB CEN26LA331Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 525B · Snyder, TXOn September 30, 2026, about 1410 central daylight time, a Cessna 525B, Dominican Republic registration HI1127, was substantially damaged when it was involved in an accident at Winston Field Airport (SNK), Snyder, Texas. The two pilots and one passenger were…NTSB WPR26LA362Accident · Serious injuriesClass 3 · LimitedPreliminary reportSmith Pitts Special S-1 · Madison, GAOn September 29, 2026, at about 1347 eastern daylight time, a Smith Pitts Special S-1, N292Y, was substantially damaged when it was involved in an accident near Madison, Georgia. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…NTSB ERA26LA354Accident · No injuriesClass 3 · LimitedPreliminary reportCostruzioni Aeronautiche Tecnam P92 Tail Dragger · Toughkenamon, PAOn September 29, 2026, about 0945 eastern daylight time, a special light-sport Costruzioni Aeronautiche Tecnam P92 Tail Dragger, N575TA, was substantially damaged when it was involved in an accident near Toughkenamon, Pennsylvania. The pilot was not injured.…NTSB CEN26LA330Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 152 · Bolingbrook, ILOn September 29, 2026, about 1828 central daylight time, a Cessna 152 II airplane, N69009, sustained substantial damage when it was involved in an accident near Bolingbrook, Illinois. The flight instructor and the student pilot sustained minor injuries. The…NTSB WPR26LA358Accident · Serious injuriesClass 3 · LimitedInvestigation openReynolds Dennis E Bearhawk Patrol · Cottage Grove, ORNTSB CEN26LA327Accident · Minor injuriesClass 3 · LimitedPreliminary reportHaberman Habercraft · Pelican Rapids, MNOn September 27, 2026, about 1720 central daylight time, a Haberman Habercraft airplane, N10516, was substantially damaged during an accident near Pelican Rapids, Minnesota. The pilot sustained a minor injury. The airplane was operated as a Title 14 Code of…NTSB CEN26LA326Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 35-A33 · East Troy, WIOn September 27, 2026, about 1333 central daylight time, a Beech A33 airplane, N1288Z, was substantially damaged when it was involved in an accident near East Troy, Wisconsin. The pilot and three passengers sustained minor injuries. The airplane was operated…NTSB CEN26FA325Accident · 1 fatalClass 3 · FieldPreliminary reportEXP PA-18 Replica · Buffalo, MNOn September 27, 2026, about 1608 central daylight time, an experimental PA-18 Replica airplane, N43LK, sustained substantial damage when it was involved in an accident near Buffalo, Minnesota. The pilot was fatally injured, and the pilot-rated passenger was…NTSB WPR26LA360Accident · No injuriesClass 4 · LimitedInvestigation openCessna A185F · Livingston, MTNTSB ERA26LA361Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-161 · Sarasota, FLNTSB ERA26FA350Accident · 1 fatalClass 3 · FieldPreliminary reportAero Commander 112 · Chatsworth, GAOn September 26, 2026, about 1120 eastern daylight time, an Aero Commander 112, N1102J, was substantially damaged when it was involved in an accident near Chatsworth, Georgia. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB CEN26LA333Accident · No injuriesClass 3 · LimitedPreliminary reportFairchild 24H · Indianapolis, INOn September 26, 2026, about 1430 central daylight time, a Fairchild 24H, N16902, was substantially damaged when it was involved in an accident near Indianapolis, Indiana. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…NTSB CEN26LA329Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-181 · Mason, MINTSB CEN26LA328Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-210C · Ozark, ARNTSB ERA26LA360Accident · No injuriesClass 4 · LimitedInvestigation openCessna 421B · Nashville, TNNTSB ERA26LA351Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182S · St. Petersburg, FLNTSB WPR26LA356Accident · No injuriesClass 3 · LimitedPreliminary reportZenith CH 750 Stol · Spring Creek, NVOn September 24, 2026, about 0958 mountain daylight time, an experimental amateur-built Zenith CH750 STOL airplane, N750WZ, was substantially damaged when it was involved in an accident near Silver Creek, Nevada. The pilot was not injured. The airplane was…NTSB WPR26FA355Accident · 2 fatalClass 3 · FieldPreliminary reportAeronca 7AC · Hesperia, CAOn September 24, 2026, about 0945 Pacific daylight time, an Aeronca 7AC, N12DF, was substantially damaged when it was involved in an accident near Hesperia, California. The flight instructor and passenger were fatally injured. The airplane was operated as a…NTSB WPR26FA354Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172B · Royal City, WAOn September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA353Accident · No injuriesClass 4 · LimitedInvestigation openRoberts GS-2 Sportsman · Kerrtown, PANTSB CEN26LA324Accident · 2 fatalClass 3 · LimitedPreliminary reportMagni M16 · Annapolis, MOOn September 23, 2026, about 1755 central daylight time, an experimental Magni M16 gyroplane, N109MG, was substantially damaged when it was involved in an accident near Annapolis, Missouri. The pilot and passenger were both fatally injured. The gyroplane was…NTSB CEN26LA323Accident · No injuriesClass 4 · LimitedInvestigation openCessna 120 · Llano, TXNTSB WPR26LA359Accident · Minor injuriesClass 4 · LimitedInvestigation openHawker Hawker Hunter MK.58 · Morro Bay, CANTSB ERA26LA362Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-140 · Canon, GANTSB WPR26LA361Accident · No injuriesClass 4 · LimitedInvestigation openCessna U206G · Stony River, AKNTSB WPR26LA352Accident · 1 fatalClass 4 · LimitedInvestigation openBeech B95 · Newport, ORNTSB ANC26LA107Accident · Serious injuriesClass 3 · LimitedInvestigation openPiper PA-28-140 · Junction, TX