NTSB investigations
1,330 cases where the sequence of events included Collision during takeoff/land.
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 WHERE c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")) 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 WHERE c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '490' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 DCA26MA024Accident · 14 fatalClass 1 · MajorPreliminary reportMcdonnell Douglas MD-11F · Louisville, KYOn November 4, 2025, about 1714 eastern standard time (EST), United Parcel Service (UPS) flight 2976, a Boeing (McDonnell-Douglas) MD-11F airplane, N259UP, was destroyed after it impacted the ground shortly after takeoff from runway 17R at Louisville Muhammad…NTSB ERA26LA024Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Somerville, TNOn October 24, 2025, about 1815 central daylight time, a Piper PA-28-140, N3905F, was substantially damaged when it was involved in an accident at Fayette County Airport (FYE), Somerville, Tennessee. The pilot sustained minor injuries. The airplane was…NTSB ERA26LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Plymouth, CTThe plot’s failure to account sufficiently for the decrease in the airplane’s takeoff performance due to the wet turf runway, which resulted in a collision with a log barrier and subsequent nose over after aborting the takeoff.NTSB CEN25LA397Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DH82 · Harvard, ILThe pilot’s failure of the pilot to maintain directional control during takeoff which resulted in a collision with cornstalks. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.NTSB ANC25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Healy, AKThe pilot’s failure to maintain directional control during the departure roll resulting in a collision with a tractor/loader.NTSB ANC25LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain clearance from an object during takeoff, which resulted in a collision and ground loop. Contributing was the pilot’s selection of an unsuitable takeoff area.NTSB ANC25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · St Mary's, AKThe pilot’s improper decision to takeoff with a tailwind, from a short off-airport strip, which degraded the climb performance of the airplane and led to impact with trees at the end of the strip.NTSB ANC25LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Eagle, AKThe pilot’s failure to maintain clearance from brush during landing.NTSB WPR25LA274Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-23-160 · Santa Teresa, NMOn September 6, 2025, about 1925 mountain daylight time, a Piper PA-23-160, N4085P, was substantially damaged when it was involved in an accident near Santa Teresa, New Mexico. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code…NTSB CEN25LA401Accident · No injuriesClass 3 · LimitedFinal reportCubCrafters CCK-2000 · Thompsonville, MIA total loss of engine power due to a lack of ignition resulting from a fractured alternator ring terminal and the builder’s incorrect installation of the wire connecting to the alternator. Contributing to the total loss of engine power was the failure of the…NTSB CEN25LA356Accident · Serious injuriesClass 3 · LimitedFinal reportSikorsky S-76 · Round Mountain, TXThe flight crew’s failure to properly identify the heliport in dark night conditions, which resulted in the flight crew attempting to land and a subsequent impact with trees and terrain.NTSB WPR25LA271Accident · Minor injuriesClass 4 · LimitedFinal reportNaval Aircraft Factory N3N-3 · Red Lodge, MTThe pilot’s failure to maintain clearance from obstacles during an aborted landing. Contributing to the accident was the high density altitude weather condition.NTSB WPR25LA260Accident · No injuriesClass 3 · LimitedPreliminary reportBell Textron Canada 407 · Lincoln, MTOn August 26, 2025, at about 0100 mountain daylight time, a Bell 407 GTX, N38AJ, was substantially damaged when it was involved in an accident near Lincoln, Montana. The pilot and two passengers were not injured. The helicopter was operated as a Title 14,…NTSB ANC25LA095Accident · No injuriesClass 4 · LimitedFinal reportHelio H-395 · Pilot Point, AKThe pilot's inadequate takeoff performance planning, which resulted in a runway excursion and collision with terrain.NTSB ANC25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Delta Junction, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with tree-covered terrain.NTSB GAA25WA248Accident · 1 fatalClass 5 · ForeignQuicksilver MX II · Phuket, ThailandNTSB CEN25LA322Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-18-150 · Joliet, ILThe failure of the No. 2 cylinder exhaust valve, which resulted in a total loss of engine power.NTSB ERA25LA296Accident · No injuriesClass 4 · LimitedFinal reportMaule MX-7-180A · Muskeget Island, MAThe pilot’s failure to obtain a proper touchdown point while attempting to land on a very short and rough turf runway, which resulted in a runway overrun and collision with vegetation and terrain.NTSB WPR25LA234Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · Cashmere, WAThe pilot’s failure to maintain clearance from obstacles during an aborted landing, while flying in tailwind conditions. Contributing to the accident was the high density altitude weather condition.NTSB ERA25FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Block Island, RIOn July 30, 2025, about 1210 eastern daylight time, a Piper PA-28-181, N961DA, was substantially damaged when it was involved in an accident near Block Island, Rhode Island. The pilot sustained serious injuries, one passenger received minor injuries, and one…NTSB WPR25LA219Accident · Serious injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · Hollister, CAThe departing pilot’s failure to see and avoid the landing airplane during the takeoff, which resulted in a mid-air collision.NTSB CEN25LA271Accident · No injuriesClass 4 · LimitedFinal reportPZL Swidnik PW-5 · Kerrick, TXThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB WPR25LA217Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna TR182 · Tuba City, AZOn July 17, 2025, about 1447 mountain standard time, a Cessna TR182, N182KC, was substantially damaged when it was involved in an accident near Tuba City, Arizona. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…NTSB CEN25LA250Accident · No injuriesClass 3 · LimitedPreliminary reportGame Composites GB1 Gamebird · Tarkio, MOOn July 12, 2025, about 0830 central daylight time, a Game Composites GB-1 Gamebird airplane, N588AF, was substantially damaged, and a Vans RV-8, N931KZ, sustained minor damage, when they were involved in an accident near the Gould Peterson Municipal Airport…NTSB ANC25LA074Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Nelson Lagoon, AKThe pilot’s failure to maintain clearance from a creek bank while maneuvering to land.NTSB WPR25LA204Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A36 · Coolin, IDOn July 8, 2025, about 1840 Pacific daylight time, a Beech A36, N41VH, was substantially damaged when it was involved in an accident near Coolin, Idaho. The pilot and passenger sustained minor injuries. The airplane was operated under Title 14 Code of Federal…NTSB CEN25LA230Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Wichita, KSThe student pilot’s failure to maintain directional control during the takeoff that resulted in a runway excursion.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 ANC25LA051Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s failure to maintain clearance from trees during a go-around with a tailwind.NTSB WPR25LA173Accident · Minor injuriesClass 4 · LimitedFinal reportBell 407 · Bountiful, UTThe pilot’s improper decision to depart with inadequate clearance from a hangar door.NTSB ERA25LA222Accident · Serious injuriesClass 3 · LimitedPreliminary reportDehavilland DHC-6 Twin Otter · Tullahoma, TNOn June 8, 2025, about 1220 central daylight time, a DeHavilland DHC-6 Twin Otter, N166DH, was involved in an accident near Tullahoma, Tennessee. The commercial pilot and five passengers were seriously injured, and 15 passengers were not injured. The flight…NTSB CEN25LA188Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18 · Vega, TXThe airplane’s inadvertent encounter with a localized low boundary layer, which caused a wind shift, and a gusting tailwind during final approach, that resulted in the pilot deciding to impact a wind cone and a subsequent impact with terrain. Contributing was…NTSB GAA25WA170Accident · No injuriesClass 5 · ForeignPiper PA 46-350P · Kilkeel, United KingdomNTSB WPR25FA145Accident · 2 fatalClass 3 · FieldFinal reportChampion 7ECA · Cottonwood, CAThe flight instructor’s delayed response to an improper landing approach and runway overshoot, which resulted in an impact with an airport perimeter fence and trees.NTSB CEN25LA176Accident · Serious injuriesClass 4 · LimitedFinal reportBeech C90 · Lancaster, TXThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of power to both engines.NTSB CEN25LA163Accident · Serious injuriesClass 4 · LimitedFinal reportMesserschmitt-Bolkow-Blohm BK 117 · Hartford, ILThe pilot’s failure to maintain directional control during the initial climb at night from a confined area landing zone, that resulted in an impact with a tree, a loss of control, and a subsequent impact with terrain.NTSB CEN25LA160Accident · No injuriesClass 4 · LimitedFinal reportGrumman G164 · Louise, TXThe reported loss of engine power for undetermined reasons.NTSB WPR25LA142Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · West Jordan, UTThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was the pilot inadvertently using a runway that resulted in a tailwind condition and the flight instructors delayed remedial action.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 CEN25LA131Accident · No injuriesClass 4 · LimitedFinal reportCessna P206 · Frankston, TXThe pilot’s failure to maintain directional control during the landing with a gusting crosswind.NTSB ERA25LA145Accident · 1 fatalClass 3 · LimitedPreliminary reportWild Sky Goat · Chester, CTOn March 14, 2025, about 1515 eastern daylight time, an experimental amateur-built Wild Sky Goat light-sport aircraft, N372WS, was substantially damaged when it was involved in an accident near Chester, Connecticut. The commercial pilot sustained fatal…NTSB CEN25LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · Iron River, MIThe airplane’s collision with runway lights during takeoff due to reduced airplane climb performance. Contributing to the accident was the shifting winds during takeoff which likely developed into a tailwind.NTSB ERA25LA127Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Mayo, MDA total loss of engine power at low altitude due to an accumulation of carburetor ice while in a cruise-power descent, which resulted in a forced landing.NTSB WPR25LA095Accident · No injuriesClass 4 · LimitedFinal reportQuicksilver Aeronautics L-S2S · Geyserville, CAThe pilot’s failure to secure the coolant cap during the preflight inspection, which resulted in a total loss of engine power due to overheating and a subsequent forced landing.NTSB CEN25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Llano, TXThe flight instructor’s failure to maintain directional control during the landing roll, that resulted in a ground loop, and a susbquent runway excursion.NTSB CEN25LA067Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 · Galveston, TXThe pilot’s failure to maintain terrain clearance during the takeoff from the helipad in high and gusting wind conditions, that resulted in the right skid extension embedding in the artificial turf, and a subsequent dynamic rollover sequence.NTSB CEN25LA064Accident · Serious injuriesClass 4 · LimitedFinal reportCozy Cub · Parsons, KSThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB ERA25LA085Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · Loganville, GAThe pilot’s failure to maintain clearance of trees during an attempted go-around in sun glare.NTSB ANC25LA012Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s improper airspeed management which resulted in a bounced landing and insufficient airspeed to perform a go around procedure.NTSB ERA25LA081Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Lakewood, NJThe pilot’s delay in performing a go-around, which resulted in a collision with trees at the end of the runway.