NTSB investigations
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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 DCA25WA193Occurrence · No injuriesClass 5 · ForeignBoeing 737 · Dushanbe, TajikistanNTSB CEN25LA154Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Temple, TXThe failure of the left main landing gear down lock to engage and subsequent collapse of the left main landing gear.NTSB CEN25FA151Accident · 1 fatalClass 3 · FieldPreliminary reportAeronca 7AC · Cape Fair, MOOn April 10, 2025, at 0904 central daylight time, an Aeronca 7AC airplane, N83952, was substantially damaged when it was involved in an accident near Cape Fair, Missouri. The pilot received serious injuries, and the passenger was fatally injured. The airplane…NTSB GAA25WA140Accident · Minor injuriesClass 5 · ForeignCessna 150 · Campina Grande, BrazilNTSB ERA25LA169Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A36 · Fredericksburg, VAOn April 9, 2025, about 1505 eastern daylight time, a Beech A36, N2Z, was substantially damaged when it was involved in an accident near Fredericksburg, Virginia. The pilot and the pilot rated passenger sustained minor injuries. The airplane was operated…NTSB CEN25LA152Accident · No injuriesClass 4 · LimitedFinal reportCorben Junior ACE · Jeanerette, LAThe pilot’s failure to maintain airplane control during the landing roll.NTSB ANC25LA033Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff when the airplane was not attaining sufficient airspeed for takeoff and subsequently departed the end of the lake and collided with terrain.NTSB WPR25LA135Accident · No injuriesClass 4 · LimitedFinal reportMartin Uav Vbat · Douglas, AZThe malfunction of the throttle servo which resulted in the complete loss of engine power.NTSB CEN25LA149Accident · Serious injuriesClass 3 · LimitedFinal reportPphu Ekolot KR-030 Topaz · Platteville, WIThe pilot’s failure to maintain clearance from terrain for reasons which could not be determined.NTSB CEN25LA147Accident · No injuriesClass 4 · LimitedFinal reportCessna 150F · Zeeland, MIThe flight instructor’s failure to maintain control of the airplane during the go-around which led to the airplane exceeding its critical angle-of-attack and entering an aerodynamic stall at a low altitude. Contributing to the accident was the flight…NTSB CEN25FA148Accident · 1 fatalClass 3 · FieldPreliminary reportAnusiewicz Cassutt III M · Haskell, OKOn April 8, 2025, about 1459 central daylight time, a Cassutt III M airplane, N5RR, was substantially damaged when it was involved in an accident near Haskell, Oklahoma. The pilot was fatally injured. The aircraft was operated as a Title 14 Code of Federal…NTSB WPR25LA124Accident · Serious injuriesClass 3 · LimitedPreliminary reportHonda HA-420 · North Bend, OROn April 7, 2025, at 0606 Pacific daylight time, a Honda Aircraft Company HA-420, N826E, was substantially damaged when it was involved in an accident in North Bend, Oregon. The pilot and three passengers sustained minor injuries; one passenger sustained…NTSB CEN25LA153Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Wausau, WIThe pilot’s failure to maintain directional control while landing in shifting wind conditions.NTSB CEN25LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Ault, COThe flight instructor’s failure to maintain terrain clearance during an attempted go-around, which resulted in a collision with a fence post.NTSB ERA25LA167Accident · Serious injuriesClass 3 · LimitedPreliminary reportHiller UH12E · Rockledge, FLOn April 6, 2025, about 1020 eastern daylight time, a Hiller UH-12E, N48263, was substantially damaged when it was involved in an accident near Rockledge, Florida. The private pilot and passenger sustained serious injuries. The helicopter was operated as a…NTSB DCA25WA177IncidentClass 5 · ForeignBoeing 737-800 · Bay of Biscay, FranceNTSB CEN25LA150Accident · No injuriesClass 4 · LimitedFinal reportSilvaire 8F · Fairbury, NEThe pilot’s failure to maintain directional control while landing and the flight instructors delayed remedial action.NTSB DCA25WA182IncidentClass 5 · ForeignBoeing 737 · Cairo, EgyptNTSB WPR25LA178Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Vancouver, WAA failure of the brake system during landing due to a hydraulic fluid leak, which resulted in a runway excursion.NTSB ERA25LA168Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200 · Vero Beach, FLSeparation of the lower nose landing gear down lock link bolt, which resulted in a collapse of the nose landing gear during landing.NTSB DCA25WA208Incident · No injuriesClass 5 · ForeignBoeing 737 · Muharraq Island, BahrainNTSB DCA25WA202IncidentClass 5 · ForeignBoeing 737-8 Max · Warsaw, PolandNTSB ERA25LA166Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 182 · Sanford, FLOn April 3, 2025, about 1222 eastern daylight time, a Cessna 182P, N1910M, was substantially damaged when it was involved in an accident near Sanford, Florida. The commercial pilot received minor injuries. The airplane was operated as a Title 14 Code of…NTSB CEN25FA144Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 210L · Raceland, LAOn April 2, 2025, at 2030 central daylight time, a Cessna 210L airplane, N1574P, was destroyed when it was involved in an accident near Raceland, Louisiana. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA133Accident · 1 fatalClass 4 · ForeignPiper PA32 · Rondonopolis, BrazilNTSB ERA25LA181Accident · Serious injuriesClass 4 · LimitedFinal reportSchleicher ASW-19 · Zephyrhills, FLThe pilot’s inadequate inflight planning and an encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing and collision with a fence.NTSB DCA25WA181IncidentClass 5 · ForeignBoeing 737 · Mexico City, MexicoNTSB GAA25WA132Accident · 2 fatalClass 5 · ForeignChampion 8KCAB · Bergen, NorwayNTSB ERA25LA164Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172N · Hickory, NCThe student pilot’s failure to maintain airplane control during an attempted go-around, which resulted in an aerodynamic stall/spin and collision with terrain.NTSB ERA25LA161Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 7AC · Martinsville, VAThe pilot inadvertently turned off the fuel selector valve on takeoff which resulted in a loss of engine power.NTSB ERA25FA163Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310Q · Midvale, OHOn April 1, 2025, about 1704 eastern daylight time, a Cessna 310Q, N8242Q, was substantially damaged when it was involved in an accident near Midvale, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB GAA25WA162Accident · Minor injuriesClass 5 · ForeignCessna 150 · Ucharpi, IndiaNTSB DCA25WA176Incident · No injuriesClass 5 · ForeignMcdonnell Douglas MD 83 · Havana, CubaNTSB GAA25WA130Accident · 2 fatalClass 5 · ForeignCessna 152 · Lingayen, PhilippinesNTSB ERA25FA158Accident · 1 fatalClass 3 · FieldPreliminary reportCirrus Design SR22 · Franklin Township, NJOn March 30, 2025, about 1034 eastern daylight time, a Cirrus SR22, N319TM, was substantially damaged when it was involved in an accident near Franklin Township, New Jersey. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR25LA123Accident · No injuriesClass 4 · LimitedFinal reportPark Roderic B Kitfox IV · Marana, AZThe pilot’s failure to maintain clearance from an obstacle while performing an off-airport landing.NTSB GAA25WA135Accident · No injuriesClass 5 · ForeignCessna 150 · 9 de Julio, ArgentinaNTSB ERA25LA207Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Winter Haven, FLThe pilot’s inadvertent movement of the fuel selector to a position that restricted fuel flow to the engine, which resulted in the loss of engine power during takeoff.NTSB CEN25FA141Accident · 1 fatalClass 3 · FieldPreliminary reportSocata TBM700A · Brooklyn Park, MNOn March 29, 2025, about 1221 central daylight time, a Socata TBM700A airplane, N721MB, was destroyed when it was involved in an accident near Brooklyn Park, Minnesota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…NTSB ANC25LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Manley Hot Springs, AKThe student pilot’s failure to maintain directional control during the landing roll on a snow and ice-covered runway, which resulted in a runway excursion and subsequent nose over.NTSB OPS25LA032IncidentClass 3 · LimitedPreliminary reportAirbus A319-114 · Arlington, VAOn March 28, 2025, about 1516 eastern daylight time (EDT), DRAGO61, a flight of four US Air Force Northrop T38s, enroute to conduct an aerial flyby at Arlington National Cemetery, and Delta (DAL) Air Lines flight 2983 (DAL2983), an Airbus 319-114, N342NB,…NTSB GAA25WA127AccidentClass 5 · ForeignCessna 152 · Antanhol, PortugalNTSB ERA25LA192Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Fort Myers, FLThe pilot’s failure to maintain directional control of the airplane while landing in gusting crosswind conditions, which resulted in the left wing impacting the runway.NTSB ERA25LA191Accident · No injuriesClass 4 · LimitedFinal reportVans RV-12 · Chesterfield, VAThe pilot’s improper landing flare, which resulted in a hard landing and the collapse of the nose landing gear.NTSB ERA25LA162Accident · Serious injuriesClass 4 · LimitedFinal reportRuys Nicholas G RV-8 · Bennettsville, SCThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing.NTSB ERA25LA160Accident · No injuriesClass 4 · LimitedFinal reportRotorway Exec · Chuluota, FLThe pilot’s failure to maintain lateral control of the helicopter during takeoff, which resulted in a dynamic rollover.NTSB DCA25LA174Accident · No injuriesClass 4 · LimitedFinal reportPyka Pelican · Dixon, CAThe flight control system’s unanticipated transition to takeoff abort mode due to a software error in the autonomous flight control system, which resulted in a premature throttle reduction and hard landing.NTSB CEN25LA140Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802A · Cash, ARThe pilot’s failure to maintain clearance from an excavator during low-altitude aerial application operations.NTSB GAA25WA232AccidentClass 5 · ForeignRobinson R22 Beta · Qld, AustraliaNTSB ERA25LA159Accident · No injuriesClass 3 · LimitedFinal reportSilvaire Luscombe 8A · New Port Richey, FLMaintenance personnel’s inadequate inspection of the exhaust system, which allowed exhaust gases to enter the induction system from cracks in the exhaust manifold, resulting in a total loss of engine power and a subsequent forced landing.