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 ERA25FA239Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Dunlap, TNOn June 24, 2025, about 18:23 central daylight time, a Piper J3C-65, N28DR, was substantially damaged when it was involved in an accident near Dunlap, Tennessee. The commercial pilot was fatally injured and the passenger was seriously injured. The airplane…NTSB CEN25LA221Accident · Serious injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Pierre, SDThe pilot’s failure to maintain clearance with the power lines while maneuvering that resulted in an in-flight collision with the power lines and impact with terrain.NTSB CEN25LA220Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-260 · Ashland, WIThe pilot’s failure to extend the landing gear before landing and his failure to conduct the before landing checklist.NTSB ANC25LA055Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-32R-300 · Big Lake, AKOn June 24, 2025, about 0934 Alaska daylight time, a Piper PA-32R-300 airplane, N3609Q, was substantially damaged when it was involved in an accident near Big Lake, Alaska. The pilot and flight instructor were seriously injured. The airplane was operated as a…NTSB WPR25LA188Accident · Minor injuriesClass 3 · LimitedPreliminary reportFilby Gerry RV-9 · Morgan Hill, CAOn June 23, 2025, about 1217 Pacific daylight time, an experimental amateur-built Vans Aircraft Inc RV-9 airplane, N696WG, was substantially damaged when it was involved in an accident near Morgan Hill, California. The pilot sustained minor injuries. The…NTSB ERA25LA237Accident · Minor injuriesClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Swanzey, NHThe pilot’s failure to maintain rotor rpm of the gyroplane during a low approach, while distracted by other aircraft in the airport traffic pattern, which resulted in the pilot’s decision to perform an off-runway landing.NTSB ERA25LA235Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Milton, FLSeparation of the throttle cable sleeve during takeoff, which resulted an uncommanded engine power reduction and the pilot’s inability to control the engine throttle, and resulted in a forced landing.NTSB CEN25LA219Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Charleston, MOThe pilot’s loss of control during the spray pass, which resulted in impact with vegetation and terrain.NTSB CEN25FA216Accident · 2 fatalClass 3 · FieldPreliminary reportMurphy Aircraft Manufacturing Moose · Montrose, COOn June 23, 2025, about 1021 mountain daylight time, a Murphy Aircraft Manufacturing Limited Moose airplane, N250MK, was destroyed when it was involved in an accident near Montrose, Colorado. The pilot and the pilot-rated passenger sustained fatal injuries.…NTSB ANC25LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna P206C · Port Graham, AKThe pilot's improper landing flare and failure to maintain pitch control, which resulted in a tail strike. Contributing to the accident was the pilot’s failure to initiate a go around after the abnormal runway contact.NTSB WPR25LA183Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300T · Winchester, IDThe pilot’s improper fuel management resulting in fuel starvation, a total loss of engine power, and a subsequent off-airport forced landing. Contributing to the accident was the pilot’s reduced fuel level monitoring due to an inflight distraction.NTSB GAA25WA191Accident · 1 fatalClass 4 · ForeignRobinson R44 · Naboonspruit, South AfricaNTSB DCA25LA240Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus Industrie A321-211 · Miami, FLThe unexpected encounter with a rapidly developing convective cell during climb resulting in convectively induced turbulence on a dark moon-less evening.NTSB DCA25LA239Accident · Serious injuriesClass 4 · LimitedFinal reportAirbus A320 · Nashville, TNThe airplane’s encounter with moderate convective turbulence during descent.NTSB CEN25LA213Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC130 · Clay Township, MIThe pilot’s failure to maintain control of the helicopter during landing.NTSB GAA25WA193AccidentClass 5 · ForeignMesserschmitt-Bölkow-Blohm BK117 · Havre St-Pierre, CanadaNTSB GAA25WA189Accident · Minor injuriesClass 5 · ForeignBensen B8M · Taghmon, IrelandNTSB CEN25LA227Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob G-103A Twin II Acro · Midlothian, TXThe student pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR25LA185Accident · No injuriesClass 4 · LimitedFinal reportSilvaire Luscombe 8A · San Andreas, CAThe pilot’s loss of directional control during landing roll following an encounter with a dust devil.NTSB WPR25LA184Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180E · Rockford, WAThe pilot's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent landing on rough terrain.NTSB GAA25WA190AccidentClass 5 · ForeignBeech C90 · Nagqu City, ChinaNTSB ERA25LA236Accident · No injuriesClass 4 · LimitedFinal reportSting Sport TL-2000 · Dunavant, VAThe inflight failure of the propeller due to its exceedance of the manufacturer’s overhaul requirement.NTSB ERA25FA231Accident · 2 fatalClass 3 · FieldPreliminary reportPitts S2 · Broadway, NCOn June 20, 2025, at 0900 eastern daylight time, a Pitts Aerobatics S-2B, N79AV, was destroyed when it was involved in an accident near Broadway, North Carolina. The private pilot and the commercial pilot-rated passenger were fatally injured. The airplane was…NTSB WPR25LA187Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Kayenta, AZThe pilots’ failure to maintain airplane control during takeoff in gusting crosswind conditions, which resulted in a runway excursion.NTSB WPR25FA182Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Billings, MTOn June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25FA230Accident · 2 fatalClass 3 · FieldFinal reportMooney M20F · Beverly, MAThe pilot’s failure to maintain control of the airplane while maneuvering to return to the airport which resulted in an aerodynamic stall. Contributing to the accident was the improperly installed No. 2 cylinder bottom spark plug by maintenance personnel,…NTSB CEN25LA218Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-36-375 · Huron, SDThe pilot’s exceedance of the airplane’s critical angle of attack during a low-level aerial application, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB CEN25LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Brookshire, TXThe pilot’s improper landing flare, which resulted in a hard, bounced landing and the nose landing gear collapsing.NTSB WPR25LA186Accident · No injuriesClass 4 · LimitedFinal reportKohut Mark A Murphy SR 2500 · Challis, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA25WA231AccidentClass 5 · ForeignPiper PA-28-181 · Gloucestershire, United KingdomNTSB GAA25WA199AccidentClass 5 · ForeignBeech 200 · Bankstown, AustraliaNTSB GAA25WA194Accident · No injuriesClass 5 · ForeignCessna 402 · Salvador, BrazilNTSB DCA25WA305Accident · Serious injuriesClass 5 · ForeignBoeing 737 · SeychellesNTSB DCA25WA247IncidentClass 5 · ForeignBoeing 737 · Brisbane, AustraliaNTSB DCA25LA241Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-8H4 · Barlow Bend, ALThe airplane’s encounter with unanticipated turbulence during descent, resulting in a serious injury to a flight attendant.NTSB CEN25LA211Accident · No injuriesClass 4 · LimitedFinal reportCessna U206 · Falun, WIThe pilot experiencing the featureless terrain illusion during the approach which gave the perception that the airplane was at a higher altitude over the glassy water surface than it was, resulting in the airplane impacting the water.NTSB CEN25FA212Accident · 2 fatalClass 3 · FieldPreliminary reportCessna A150L · Three Points, AZOn June 18, 2025, about 0922 mountain standard time, a Cessna A150L airplane, N6436F, was substantially damaged when it was involved in an accident near Three Points, Arizona. The student pilot and flight instructor were fatally injured. The airplane was…NTSB WPR25LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Heber City, UTThe student pilot’s improper recovery from a bounced landing, which resulted in a nose over.NTSB CEN25LA209Accident · No injuriesClass 4 · LimitedFinal reportVans RV-14 · Sealy, TXThe pilot’s improper use of airplane’s wheel brakes during the landing roll-out.NTSB GAA25WA198Accident · No injuriesClass 5 · ForeignCessna 182 · Mount Surprise, AustraliaNTSB GAA25WA188Accident · 1 fatalClass 5 · ForeignRand Robinson KR2 · Klint, GermanyNTSB DCA25WA237Incident · No injuriesClass 5 · ForeignBoeing 737 · Dubai, United Arab EmiratesNTSB DCA25LA238Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-924ER · Fort Myers, FLThe airplane’s inadvertent encounter with convective turbulence during descent, which resulted in serious injuries to two flight attendants.NTSB CEN25LA208Accident · Minor injuriesClass 4 · LimitedFinal reportBeech E90 · New Century, KSThe flight instructor’s inadequate fuel planning that resulted in a loss of engine power to the left engine due to fuel exhaustion. Contributing to the accident was the flight instructor’s inadequate supervision of the flight that resulted in diminished…NTSB WPR25LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Willow Creek, MTThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR25LA172Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Spokane Valley, WAThe pilot’s failure to maintain directional control during a takeoff roll in quartering tailwind conditions.NTSB GAA25WA185AccidentClass 5 · ForeignBell 407 · Guptkashi, IndiaNTSB CEN25LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Fort Morgan, COThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a gusty crosswind landing.NTSB WPR25LA174Accident · Serious injuriesClass 3 · LimitedPreliminary reportQuitter John F MXL II · Acampo, CAOn June 14, 2025, about 1511 Pacific daylight time, an experimental MXL II, N375ME, was substantially damaged when it was involved in an accident near Acampo, California. The pilot was uninjured, and the passenger was seriously injured. The airplane was…NTSB ERA25FA228Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 58 · Tabor City, NCOn June 14, 2025, at 1245 eastern daylight time, a Beech 58 airplane, N82UC, was destroyed when it was involved in an accident near Tabor City, North Carolina. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…