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 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 GAA26WA320Accident · 3 fatalClass 5 · ForeignCessna F172 · Fronderath, GermanyNTSB GAA26WA310Accident · No injuriesClass 5 · ForeignPiper PA17 · Viseu, PortugalNTSB DCA26WA364Incident · No injuriesClass 5 · ForeignBoeing 777-223 · Ezeiza, ArgentinaNTSB 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 GAA26WA315Accident · No injuriesClass 5 · ForeignPiper PA32RT · Pulcallpa, PeruNTSB GAA26WA313Accident · Serious injuriesClass 5 · ForeignCessna 550 · Parelhas, BrazilNTSB GAA26WA311Accident · 5 fatalForeign investigationCessna T206 · Tatama Massif, ColombiaNTSB 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 WPR26LA343Accident · No injuriesClass 4 · LimitedInvestigation openAerovodochody L-29 Delfin · Roswell, NMNTSB ENG26WA043Incident · No injuriesClass 5 · ForeignAirbus A321-271N · Parque Industrial Mazatlán, MexicoNTSB 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 GAA26WA322Accident · 3 fatalClass 4 · ForeignCessna 402 · Agua Boa, BrazilNTSB GAA26WA308Accident · No injuriesClass 5 · ForeignCessna 152 · Mapitac, PhilippinesNTSB DCA26WA362Incident · No injuriesClass 5 · ForeignBoeing 737 · Tiouilit, MauritaniaNTSB 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 CEN26LA315Accident · No injuriesClass 4 · LimitedFinal reportProgressive Aerodyne Searey · DeQuincy, LAThe pilot’s failure to maintain directional control during takeoff after encountering a wind gust. Contributing to the accident was nearby convective activity.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 GAA26WA321Accident · No injuriesClass 5 · ForeignTextron C680A · Misrata, LibyaNTSB GAA26WA305Accident · Serious injuriesClass 5 · ForeignCessna 172 · Midrand, South AfricaNTSB ERA26LA336Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · West Kingston, RIThe pilot’s failure to bring the airplane to a stop on the available runway, which resulted in a runway excursion.NTSB ERA26LA334Accident · Minor injuriesClass 4 · LimitedInvestigation openNorth American Harvard III · Sanatoga, PANTSB 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 GAA26WA309Incident · No injuriesClass 5 · ForeignBell 412 · Ciudad del Carmen, MexicoNTSB GAA26WA306Accident · No injuriesClass 5 · ForeignPiper PA28 · Mossel Bay, South AfricaNTSB GAA26WA302Accident · 1 fatalClass 5 · ForeignCanadian Home Rotors Safari · Eyrewell, New ZealandNTSB GAA26WA300Accident · 5 fatalClass 5 · ForeignBolkow BO105 · Long Lellang, MalaysiaNTSB DCA26WA353AccidentClass 5 · ForeignDouglas DC8 · Kinshasa, Congo - KinshasaNTSB 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 GAA26WA314Accident · Serious injuriesForeign investigationCessna 185 · Torbole, ItalyNTSB GAA26WA301Accident · 2 fatalClass 5 · ForeignBeech A36 · Archerfield, Australia