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 CEN26LA295Accident · Minor injuriesClass 3 · LimitedPreliminary reportAviat A-1B · Pilot Grove, MNOn August 17, 2026, about 1446 central daylight time, an Aviat Aircraft Inc A-1B airplane, N299CA, was substantially damaged when it was involved in an accident near Pilot Grove, Minnesota. The two pilots received minor injuries. The airplane was operated as…NTSB WPR26LA304Accident · No injuriesClass 4 · LimitedInvestigation openCessna 180 · McCall, IDNTSB WPR26LA303Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172L · Upland, CANTSB ERA26LA306Accident · Serious injuriesClass 4 · LimitedInvestigation openPowrachute Pegasus · Humboldt, TNNTSB DCA26WA344IncidentForeign investigationBoeing 737 · Mascot, AustraliaNTSB WPR26LA308Accident · No injuriesClass 4 · LimitedInvestigation openMitsubishi MU-2B-40 · Norton Shores, MINTSB WPR26LA306Accident · No injuriesClass 4 · LimitedInvestigation openAero Rampart Steen Skybolt · Roseburg, ORNTSB GAA26WA318Accident · No injuriesClass 5 · ForeignK1 S19 · Jurmala, LatviaNTSB GAA26WA284Accident · No injuriesForeign investigationBell 214 · Cache Creek, CanadaNTSB ERA26LA304Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Miramar, FLThe flight instructor’s failure to maintain control of the helicopter during a hover, which resulted in the left skid contacting ground and a subsequent dynamic rollover.NTSB ERA26LA303Accident · Serious injuriesClass 3 · LimitedPreliminary reportMcfarland Larry C Zenith 601 HDS · Ripley Landing, WVOn August 15, 2026, about 1300 eastern daylight time, an experimental, amateur-built Zenith 601 HDS airplane, N601EZ, was substantially damaged when it was involved in an accident near Ripley Landing, West Virginia. The private pilot was seriously injured.…NTSB ENG26FA034Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 747 · Anchorage, AKOn August 15, 2026, 1755 Alaska Daylight Time, a China Airlines Flight Number CI-5265, Boeing 747-400F, registration B-18725, powered by four GE Aerospace CF6-80C2B1F turbofan engines, experienced an inflight fire indication during the initial climb from Ted…NTSB DCA26WA335IncidentClass 5 · ForeignAirbus A320 · Guarulhos, BrazilNTSB DCA26WA312Incident · No injuriesClass 5 · ForeignBoeing 737 · Sepang, MalaysiaNTSB DCA26WA311IncidentClass 5 · ForeignBoeing 787 · Munich, GermanyNTSB CEN26LA298Accident · Minor injuriesClass 4 · LimitedFinal reportRotor Effects M24 Plus · Waelder, TXThe pilot’s improper execution of rejected takeoff procedures, which resulted in loss of control and subsequent runway excursion.NTSB CEN26LA294Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Taurus Electro G2.5 · Hempstead, TXThe pilot’s failure to properly stow the motor in preparation for approach and landing that resulted in a loss of airspeed and an inadvertent aerodynamic stall and spin.NTSB WPR26LA307Accident · Serious injuriesClass 4 · LimitedInvestigation openCirrus Design SF50 · Driggs, IDNTSB GAA26WA282Accident · 2 fatalClass 5 · ForeignPiper PA28 · Trawsfynydd, United KingdomNTSB ERA26LA307Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Altoona, PAThe pilot’s descent below the glidepath and collision with trees during a missed approach.NTSB ERA26LA305Accident · Minor injuriesClass 3 · LimitedPreliminary reportBarry Lynn Kromer Zenith Cruzer · Chatham, MAOn August 14, 2026, about 1040 eastern daylight time, an experimental amateur-built Zenith Cruzer, N673BK, was substantially damaged when it was involved in an accident near Chatham, Massachusetts. The pilot and the pilot-rated passenger received minor…NTSB ERA26LA300Accident · Serious injuriesClass 4 · LimitedFinal reportWaco Classic 2T-1A-2 · Clermont, FLThe pilot’s failure to maintain clearance from trees during the landing approach.NTSB ENG26WA037IncidentClass 5 · ForeignAirbus A321 · Chiapa de Corzo, MexicoNTSB DCA26WA334Incident · No injuriesClass 5 · ForeignAirbus A330 · Lubumbashi, Congo - KinshasaNTSB CEN26LA293Accident · No injuriesClass 3 · LimitedInvestigation openGildea William D Jabiru Calypso · Lake Isabella, MINTSB CEN26LA292Accident · Serious injuriesClass 3 · LimitedInvestigation openTaylorcraft DCO-65 · Copper City, MINTSB CEN26LA290Accident · No injuriesClass 3 · LimitedPreliminary reportGulfstream Aerospace G-IV · St. Louis, MOOn August 14, 2026, about 1459 central daylight time, a Gulfstream Aerospace G-IV airplane, N406JS, was substantially damaged when it was involved in an accident near St. Louis, Missouri. The three crew members and 7 passengers were not injured. The airplane…NTSB ERA26LA308Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28R-180 · Readington Township, NJNTSB DCA26WA337Incident · No injuriesClass 5 · ForeignBoeing 737 · El Prat de Llobregat, SpainNTSB CEN26LA287Accident · Minor injuriesClass 3 · LimitedPreliminary reportMooney M20G · Luling, TXOn August 13, 2026, about 1302 central daylight time, a Mooney M20G airplane, N6916N, sustained substantial damage when it was involved in an accident near Luling, Texas. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB ANC26LA084Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Anthony, FLOn August 12, 2026, at approximately 2305 eastern daylight time, a Robinson R44 Raven II helicopter, N861MP, was substantially damaged when it was involved in an accident near Anthony, Florida. The pilot and passenger sustained minor injuries. The helicopter…NTSB ERA26LA301Accident · Serious injuriesClass 4 · LimitedFinal reportSpirit Engineering SE-1 · Ossipee, NHThe pilot’s failure to maintain control of the airplane during an aborted landing, which resulted in a nose over on the grass runway.NTSB CEN26LA285Accident · Serious injuriesClass 3 · LimitedPreliminary reportStaudacher Jon ZZ 102 · Vicksburg, MIOn August 12, 2026, about 1906 eastern daylight time, a Staudacher ZZ 102 experimental airplane, N134ZZ, was substantially damaged when it was involved in an accident near Vicksburg, Michigan. The airline transport pilot and one passenger were seriously…NTSB WPR26FA301Accident · 2 fatalClass 3 · FieldPreliminary reportNew Glasair Sportsman 2 Plus 2 · Pine, AZOn August 10, 2026, at about 1835 mountain daylight time, an experimental amateur built Glasair Sportsman 2 Plus 2 airplane, N202AZ, was destroyed when it was involved in an accident near Pine, Arizona. The pilot and passenger were fatally injured. The…NTSB ERA26LA302Accident · No injuriesClass 4 · LimitedInvestigation openFrank J Salomone RV10 · Stevensville, MDNTSB WPR26LA296Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 180 · La Center, WAOn August 10, 2026, about 12:55 Pacific daylight time, a Cessna 180, N180DT, was substantially damaged when it was involved in an accident near La Center, Washington. The flight instructor and pilot receiving instruction were seriously injured. The flight was…NTSB ERA26LA358Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA24 · Union City, OHOn August 10, 2026, about 1800eastern daylight time, a Piper PA-24-250, N6985P, was substantially damaged when it was involved in an accident near Union City, Ohio. The flight instructor and the private pilot were not injured. The airplane was operated as a…NTSB ERA26LA298Accident · No injuriesClass 4 · LimitedInvestigation openPeckham Lloyd Zodiac CH-650B · Westerly, RINTSB DCA26WA379Accident · Serious injuriesClass 5 · ForeignBoeing 737 · Warsaw, PolandNTSB DCA26WA331IncidentClass 5 · ForeignAirbus A321 · Royal National Park, AustraliaNTSB CEN26LA283Accident · No injuriesClass 3 · LimitedPreliminary reportVelocity Velocity · Palmyra, ILOn August 10, 2026, about 1248 central daylight time, an experimental Velocity 173 FG Elite II airplane, N6954K, sustained substantial damage when it was involved in an accident near Palmyra, Illinois. The pilot and two passengers sustained no injuries. The…NTSB WPR26LA302Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 208B · Salmon, IDOn August 9, 2026, at 1420 mountain daylight time, a Cessna 208B airplane, N247JP, was substantially damaged when it was involved in an accident near Salmon, Idaho. The pilot and eight passengers were not injured. The airplane was operated as a Title 14 Code…NTSB WPR26LA297Accident · No injuriesClass 4 · LimitedInvestigation openCirrus Design SR22T · Sells, AZNTSB ERA26LA297Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Morgantown, WVThe fuel truck driver’s distraction and inadequate visual lookout, which resulted in a collision with an airplane.NTSB ERA26LA296Accident · Serious injuriesClass 3 · LimitedInvestigation openPiper PA32 · Dawsonville, GANTSB ERA26LA295Accident · No injuriesClass 3 · LimitedPreliminary reportMooney M20E · Conway, SCOn August 9, 2026 at 802 eastern daylight time, a Mooney M20E, N9257V, was substantially damaged when it was involved in an accident near Conway, South Carolina. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal Regulations Part…NTSB ERA26FA294Accident · 1 fatalClass 3 · FieldPreliminary reportBachem Fritz M Avid Mark IV · Arp, TXOn August 9, 2026, at about 1655 central daylight time, an experimental amateur-built Avid Mark IV, N77FB, was substantially damaged when it was involved in an accident near Arp, Texas. The private pilot was fatally injured. The airplane was operated as a…NTSB DCA26WA347IncidentClass 5 · ForeignBoeing 737-8 · Fresno, CANTSB DCA26WA332IncidentClass 5 · ForeignBoeing 737 · Mascot, AustraliaNTSB ANC26LA082Accident · Minor injuriesClass 4 · LimitedInvestigation openRobinson Helicopter R44 · Macedonia, IA