NTSB investigations
180,582 investigations by the National Transportation Safety Board since 1962: 174,566 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 CEN27LA007Accident · No injuriesClass 4 · LimitedInvestigation openKitfox III · Ward, ARNTSB CEN27FA006Accident · 1 fatalClass 3 · FieldPreliminary reportLancair IV · Haslet, TXOn October 7, 2026, at 0952 central daylight time, an Lancair IV-P airplane, N5SV, was destroyed when it was involved in an accident near Haslet, Texas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations (CFR)…NTSB GAA27WA003Accident · 1 fatalClass 5 · ForeignRutan Varieze · Worplesdon, United KingdomNTSB 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 GAA27WA002Accident · 2 fatalClass 5 · ForeignCessna 501 · Los Mezquites, MexicoNTSB 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 DCA27WA010IncidentClass 5 · ForeignBoeing 737 · Canberra, AustraliaNTSB WPR27LA004Accident · No injuriesClass 4 · LimitedInvestigation openHead Balloons AX8-88B · Albuquerque, NMNTSB WPR27LA003Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-235C · Agua Dulce, CANTSB GAA27WA001Accident · 6 fatalForeign investigationGulfstream Gulfstream G100 · International Waters, CanadaNTSB CEN27LA002Accident · Minor injuriesClass 4 · LimitedInvestigation openPost Thorp T-18 · Brazil, INNTSB GAA27WA004Accident · No injuriesClass 5 · ForeignFairchild UC61 · Wilhelmshaven, GermanyNTSB CEN27LA004Accident · No injuriesClass 3 · LimitedInvestigation openCessna 414A · Boerne, TXNTSB WPR27LA010Accident · No injuriesLimited investigationInvestigation 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 injuriesLimited investigationInvestigation openKinner Sportwing B-2 · Brunswick, MENTSB DCA27WA015Accident · Serious injuriesClass 5 · ForeignAirbus A330-302 · Cassano Magnago, ItalyNTSB ANC27LA001Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna U206F · Meadow Lakes, AKNTSB WPR26LA368Accident · No injuriesClass 4 · LimitedInvestigation openGronberger Sergio A Sportsman GS-2 · Lake Goodwin, WANTSB GAA26WA336Accident · 5 fatalClass 5 · ForeignBell 430 · Mendamu, ZimbabweNTSB ERA26LA359Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182P · Mount Pleasant, SCNTSB ERA26LA357Accident · No injuriesClass 4 · LimitedInvestigation openGrumman American Avn. GA-7 · Knoxville, TNNTSB DCA26WA368Incident · Minor injuriesClass 5 · ForeignBoeing 737 · Tabuk, Saudi ArabiaNTSB CEN26LA331Accident · No injuriesClass 3 · LimitedInvestigation openCessna 525 · Snyder, TXNTSB 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 CEN26LA330AccidentClass 3 · LimitedInvestigation openCessna 152 · Bolingbrook, ILNTSB DCA26WA369IncidentClass 5 · ForeignBoeing 737 · Aeropuerto de Lanzarote, SpainNTSB WPR26LA358Accident · Serious injuriesClass 3 · LimitedInvestigation openReynolds Dennis E Bearhawk Patrol · Cottage Grove, ORNTSB GAA26WA334Incident · No injuriesClass 5 · ForeignCessna 441 · Villavicencio, ColombiaNTSB 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 injuriesLimited investigationInvestigation openBeech 35-A33 · East Troy, WINTSB 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 GAA26WA329Accident · 4 fatalForeign investigationRobinson R44 · Farnham, CanadaNTSB 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, FL