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 CEN26LA226Accident · No injuriesClass 4 · LimitedFinal reportBeech A36TC · Kingsford, MIThe pin on the nose gear brace assembly that engages with the cam on the nose landing gear door actuator shaft was not seated inside the cam, which rendered the nose landing gear inoperative.NTSB CEN26FA224Accident · 12 fatalClass 2 · FieldPreliminary reportPacific Aerospace 750XL · Butler, MOOn June 14, 2026, about 1125 central daylight time, a Pacific Aerospace Limited 750XL airplane, N221BN, was destroyed when it was involved in an accident near Butler, Missouri. The pilot and 11 passengers sustained fatal injuries. The airplane was operated as…NTSB ANC26LA053Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-235 · Key West, FLOn June 14, 2026, at 1035 eastern standard time, a Piper PA-28-235 airplane, N15564, was substantially damaged when it was involved in an accident near Key West, Florida. The pilot was not injured and the passenger sustained minor injuries. The airplane was…NTSB WPR26LA219Accident · 1 fatalClass 4 · LimitedInvestigation openCessna 208B · Marana, AZNTSB WPR26LA218Accident · Minor injuriesClass 4 · LimitedInvestigation openPiper PA-24-400 · Graham, TXNTSB ERA26LA278Accident · No injuriesClass 4 · LimitedFinal reportTextron 182T · Fredericksburg, VAThe pilot’s distraction during taxi, which resulted in a taxiway excursion.NTSB ERA26LA242Accident · No injuriesClass 3 · LimitedPreliminary reportScoda Aeronautica Ltda Super Petrel XP · New York, NYOn June 13, 2026, about 0924 eastern daylight time, a Scoda Aeronautica LTDA, Super Petrel XP airplane, N817PP, was substantially damaged when it was involved in an accident near New York, New York. The private pilot and a passenger were not injured. The…NTSB ENG26WA030IncidentClass 5 · ForeignAirbus A321 · Zapote del Valle, MexicoNTSB ANC26LA060Accident · No injuriesClass 4 · LimitedInvestigation openBeech E33 · Steamboat Springs, CONTSB ANC26LA051Accident · Minor injuriesClass 3 · LimitedPreliminary reportRobinson R44 · Pembroke Pines, FLOn June 13, 2026, about 1318 eastern daylight time, a Robinson R44 Raven I helicopter, N336SG, was substantially damaged when it was involved in an accident at the North Perry Airport (HWO), Hollywood, Florida. The pilot and three passengers sustained minor…NTSB WPR26FA217Accident · 1 fatalClass 3 · FieldPreliminary reportLancair 235 · Hillsboro, OROn June 12, 2026, at about 1508 Pacific daylight time, a Lancair 235, N10CF, was destroyed when it was involved in an accident near Hillsboro, Oregon. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB WPR26FA216Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-36-300 · Henderson, NEOn June 11, 2026, at 2103 central daylight time, a Piper PA-36-300, N57846, was substantially damaged when it impacted a rotating beacon tower and terrain near Henderson, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA223Accident · 1 fatalClass 5 · ForeignBell 206 · Lesa, ItalyNTSB GAA26WA217Accident · 1 fatalClass 5 · ForeignCessna 172 · 6th of October City, EgyptNTSB WPR26LA220Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Morgan Hill, CAAn in-flight collision with a bird.NTSB GAA26WA225Accident · No injuriesClass 5 · ForeignRobinson R44 · Nadi, FijiNTSB ERA26LA250Accident · No injuriesClass 4 · LimitedInvestigation openCessna 182 · Charlotte, VTNTSB CEN26LA223Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T206H · Bryant, AROn June 10, 2026, about 1223 central daylight time, a Cessna T206H airplane, N72RK, was substantially damaged when it was involved in an accident near Bryant, Arkansas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB CEN26FA222Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR20 · Wheelers Mill, OHOn June 11, 2026, about 1030 eastern daylight time, a Cirrus SR20 airplane, N858SD, was destroyed when it was involved in an accident near Wheelers Mill, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ANC26LA056Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-22-160 · Russian Mission, AKNTSB GAA26WA222Occurrence · No injuriesClass 5 · ForeignBombardier CL-600-2B16 · Asaba, NigeriaNTSB GAA26WA218Accident · 2 fatalClass 5 · ForeignBeech 58 · Marilia-Sao Paulo, BrazilNTSB ANC26LA052Accident · Serious injuriesClass 4 · LimitedInvestigation openTimothy G Tarris Early Bird Jenny · Lamar, CONTSB ANC26LA049Accident · Minor injuriesClass 4 · LimitedInvestigation openWilliam F Schoen RV-7 · Alpine, CONTSB WPR26LA215Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Cleburne, TXOn June 9, 2026 at about 1520 central daylight time a Cessna 172C, N1330Y, was substantially damaged when it crashed near Cleburne, Texas. The flight instructor and student pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB ERA26LA238Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P-MENTOR · Pompano Beach, FLThe student pilot’s improper landing flare, which resulted in a hard landing, and the flight instructor’s delayed remedial action.NTSB ERA26LA236Accident · Minor injuriesClass 4 · LimitedFinal reportCub Crafters CC19-215 · Plymouth, NHThe pilot’s failure to maintain control of the airplane during an aborted landing attempt which resulted in an aerodynamic stall.NTSB ERA26LA233Accident · No injuriesClass 4 · LimitedInvestigation openCessna 177 · Gilford, NHNTSB ERA26LA237Accident · No injuriesClass 4 · LimitedFinal reportSinclair Pete Lancair ES · Youngstown, OHThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with an approach lighting system.NTSB ERA26LA234Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Mayesville, SCThe pilot’s failure to remain clear of a power line during an aerial application flight.NTSB ANC26LA048Accident · No injuriesClass 4 · LimitedInvestigation openHelio H-295 · Fairbanks, AKNTSB WPR26LA211Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-44-180T · St. George, UTOn June 7, 2026, about 1012 mountain standard time, a Piper PA-44-180T, N8390K, was substantially damaged when it was involved in an accident near St. George, Utah. The pilot and two passengers were not injured. The airplane was operated as a Title 14 Code of…NTSB GAA26WA210Accident · 2 fatalClass 5 · ForeignGulfstream Gulfstream 200 · La Romana, Dominican RepublicNTSB ERA26LA245Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft DCO-65 · Renovo, PAThe pilot’s failure to maintain control during an off-airport landing.NTSB WPR26LA231Accident · No injuriesClass 4 · LimitedInvestigation openJoseph Donahue S-7 Rans · Wessington Springs, SDNTSB ERA26LA232Accident · No injuriesClass 3 · LimitedPreliminary reportNorth American SNJ-5C · Midland, VAOn June 6, 2026, about 0940 eastern daylight time, a North American SNJ-5C, N98RJ was substantially damaged when it was involved in an accident near Midland, Virginia. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB ERA26FA230Accident · Serious injuriesClass 3 · FieldPreliminary reportCessna 150 · Kissimmee, FLOn June 6, 2026, about 1458 eastern daylight time, a Cessna 150L, N156KA, was substantially damaged when it was involved in an accident near Kissimmee Gateway Airport (ISM), Kissimmee, Florida. The commercial pilot and student pilot were seriously injured.…NTSB CEN26LA220Accident · Minor injuriesClass 3 · LimitedPreliminary reportAero Commander 112 · Fabens, TXOn June 6, 2026, at 0900 central daylight time, an Aero Commander, N27007, sustained substantial damage when it was involved in an accident in Fabens, Texas. The private pilot received minor injuries. The airplane was operated as a Title 14 Code of Federal…NTSB WPR26LA212Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna P210N · Santa Teresa, NMOn June 5, 2026, about 1130 mountain daylight time, a Cessna P210N airplane, N54CC, was substantially damaged when it was involved in an accident at Dona Ana County International Jetport Airport (DNA), Santa Teresa, New Mexico. The pilot and 2 passengers were…NTSB GAA26WA224Accident · 1 fatalClass 5 · ForeignShort SC7 · Be'er Sheva, IsraelNTSB ERA26LA240Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-108 · Westminster, MDThe pilot’s failure to maintain airplane control during takeoff, which resulted in a runway excursion and collision with terrain.NTSB ERA26LA231Accident · Serious injuriesClass 3 · LimitedPreliminary reportOlson/Williams Sonex · Jaffrey, NHOn June 5, 2026, at 1100 eastern daylight time, an experimental amateur-built Sonex airplane, N28YD, was substantially damaged when it was involved in an accident near Jaffrey, New Hampshire. The private pilot was seriously injured. The flight was conducted…NTSB GAA26WA207Accident · 4 fatalClass 5 · ForeignBeech G36 · Medulin, CroatiaNTSB ERA26LA229Accident · No injuriesClass 4 · LimitedFinal reportHawker Beechcraft G36 · Danbury, CTThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway excursion.NTSB DCA26WA234Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · Connellan, AustraliaNTSB WPR26LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna P210 · Salem, ORThe pilot’s failure to extend the landing gear prior to landing.NTSB GAA26WA209Accident · 1 fatalClass 5 · ForeignRobinson R44 · Kasina Wielka, PolandNTSB DCA26WA235IncidentClass 5 · ForeignAirbus A321 · Horley, United KingdomNTSB CEN26LA233Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Gregory, MIThe flight instructor’s improper planning during the simulated aborted launch which resulted in a touchdown on unsuitable terrain.NTSB CEN26LA218Accident · No injuriesClass 3 · LimitedPreliminary reportAir Tractor AT-602 · Breaux Bridge, LAOn June 3, 2026, about 1320 central daylight time, an Air Tractor AT-602 airplane, N50050, was substantially damaged when it was involved in an accident near Breaux Bridge, Louisiana. The pilot was not injured. The airplane was operated as a Title 14 Code of…