NTSB investigations
10,153 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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\" = '470' 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" = '470' 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 WPR25FA257Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 140 · Shelter Cove, CAOn August 17, 2025 about 1521 Pacific daylight time, a Cessna 140, N89447, was involved in an accident near Shelter Cove, California. The student pilot was fatally injured, and the passenger sustained serious injuries. The airplane was operated as a Title 14…NTSB GAA25WA260Accident · 1 fatalClass 4 · ForeignAerospool WT9 Dynamic LSA · Orbe, SwitzerlandNTSB ERA25LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCentrair 101A · Springfield, VTThe pilot’s failure to assemble the glider’s elevator control before takeoff.NTSB WPR25FA252Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-7A · West Glacier, MTOn August 12, 2025, about 1457 mountain daylight time, an experimental amateur-built Vans RV-7A N30SG, was substantially damaged when it was involved in an accident near West Glacier, Montana. The pilot was fatally injured. The airplane was operated as a…NTSB WPR25LA249Accident · No injuriesClass 3 · LimitedPreliminary reportAmerican Eurocopter AS350B3 · Las Cruces, NMOn August 8, 2025, about 1946 mountain daylight time, an Airbus AS350 B3, N279AM, was substantially damaged when it was involved in an accident near Las Cruces, New Mexico. The pilot, two crew members and a passenger were not injured. The helicopter was…NTSB ERA25LA294Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-151 · Chamblee, GAOn August 9, 2025, about 0033 eastern daylight time, a Piper PA-28-151, N1080H, was substantially damaged when it was involved in an accident near DeKalb-Peachtree Airport (PDK), Chamblee, Georgia. The flight instructor and student pilot were seriously…NTSB CEN25FA307Accident · 2 fatalClass 3 · FieldFinal reportHughes 369D · West Alton, MOThe pilot’s failure to maintain helicopter clearance from the powerline during the powerline maintenance operation for reasons that could not be determined.NTSB ANC25LA106Accident · No injuriesClass 4 · LimitedFinal reportBrian Turner Northern Explorer · Delta Junction, AKThe pilot’s failure to maintain obstacle clearance during landing, which resulted in an impact with trees.NTSB WPR25FA240Accident · 4 fatalClass 3 · FieldPreliminary reportBeech 300 · Chinle, AZOn August 5, 2025, about 1245 mountain daylight time, a Beech 300, N534AW, was destroyed when it was involved in an accident near Chinle, Arizona. The pilot, co-pilot and two medical crew members were fatally injured. The airplane was operated as a Title 14…NTSB ERA25LA290Accident · Serious injuriesClass 3 · LimitedPreliminary reportGary W Lewinski Sonex · Tellico Plains, TNOn August 5, 2025, about 1131 eastern daylight time, a Lewinski Sonex, N67BG, was substantially damaged when it was involved in an accident near Tellico Plains, Tennessee. The private pilot was seriously injured. The airplane was operated as a Title 14?Code…NTSB ANC25LA082Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Yakutat, AKThe pilot’s failure to maintain clearance during approach in gusting wind conditions to a remote airstrip, resulting in a collision with brush.NTSB WPR25LA235Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Kamiah, IDThe pilot’s loss of airplane control following an encounter with a microburst during takeoff.NTSB ERA25FA283Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J5C · Rochester, NYOn August 1, 2025, about 1330 eastern daylight time, a Piper J5C, NC 28151, was substantially damaged when it was involved in an accident near Rochester, New York. The passenger was fatally injured, and the pilot was seriously injured. The airplane was…NTSB ERA25LA319Accident · No injuriesClass 4 · LimitedFinal reportWaco UBF · Tampa, FLThe pilot’s failure to maintain directional control during landing roll, which resulted in a runway excursion and collision with an object.NTSB CEN25FA289Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-22-150 · New Underwood, SDOn July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…NTSB CEN25LA292Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · North Bend, NEThe pilot’s failure to maintain clearance from wires while maneuvering at a low altitude, and the ground crew failure to inform the pilot that the support truck had been moved.NTSB WPR25LA221Accident · Minor injuriesClass 4 · LimitedFinal reportBeech B35 · Helena, MTThe pilot’s failure to properly configure the airplane during a go-around which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall at a low altitude.NTSB CEN25LA299Accident · No injuriesClass 4 · LimitedFinal reportPiper J5A · Grenada, MSThe flight instructor’s inadequate supervision of the flight and improper decision to continue with a takeoff after the airplane swerved off the runway. Contributing to the accident was the student pilot’s failure to maintain directional control of the…NTSB CEN25FA281Accident · 1 fatalClass 3 · FieldFinal reportBell Helicopter Textron 206L-1 · Thibodaux, LAThe pilot’s failure to maintain clearance to powerlines during an agricultural application pass.NTSB WPR25LA227Accident · Minor injuriesClass 4 · LimitedFinal reportHartline J Bon Hartline Kitfox III · Logan, UTThe pilot’s failure to maintain airplane control during takeoff in variable wind and high density altitude conditions.NTSB CEN25FA273Accident · 1 fatalClass 3 · FieldPreliminary reportCessna T188C · Oregon, ILOn July 22, 2025, about 0930 central daylight time, a Cessna T188C, N2802J, was substantially damaged when it was involved in an accident near Oregon, Illinois. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB ERA25LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · San Juan, PRThe student pilot’s excessing pitch attitude during takeoff, which resulted in a loss of aircraft control and aerodynamic stall.NTSB WPR25LA216Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Concrete, WAThe pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.NTSB ERA25LA271Accident · No injuriesClass 4 · LimitedFinal reportRohrer Douglas D Vans RV-14A · Bowling Green, KYThe pilot’s failure to attain an appropriate touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB CEN25LA267Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-402B · Wyoming, ILThe pilot’s failure to attain a positive climb rate due to airplane’s improper takeoff configuration.NTSB ERA25LA266Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T337G · Pembroke Pines, FLThe pilot’s inadequate preflight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power to one of the airplane’s two engines. Contributing to the outcome was the pilot’s loading of the airplane beyond its maximum gross…NTSB ERA25LA265Accident · Serious injuriesClass 3 · LimitedPreliminary reportMoyes Liteflite PTY C Dragonfly · Charlestown, NHOn July 13, 2025, about 1915 eastern daylight time, a Moyes Liteflite Model C Dragonfly airplane, N4010E, was substantially damaged when it was involved in an accident near Charleston, New Hampshire. The pilot was seriously injured. The airplane was operated…NTSB CEN25LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Howard, WIThe pilot’s failure to maintain control of the airplane while on approach to land.NTSB WPR25LA231Accident · No injuriesClass 4 · LimitedFinal reportGary Weaver CCK-1865 · Wahsatch, UTThe pilot’s inability to maintain directional control following a collision with a boulder during an off airport precautionary landing.NTSB ERA25LA268Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Elysburg, PAFailure of the engine mount which resulted in a collapse of the nose landing gear.NTSB ERA25LA264Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · St. Augustine, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA25LA267Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Inlet, NYThe pilot’s failure to maintain control of the helicopter during the landing.NTSB CEN25LA244Accident · Minor injuriesClass 4 · LimitedFinal reportCessna LC41-550FG · Lambertville, MIThe pilot’s failure to land at the manufacturer’s recommended approach speed, which resulted in a runway excursion, and impact with trees.NTSB CEN25LA241Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Jenison, MIThe pilot’s failure to maintain airplane control and clearance from trees during takeoff.NTSB CEN25LA246Accident · No injuriesClass 4 · LimitedFinal reportThorp T18 · Lake Elmo, MNThe pilot’s failure to maintain obstacle clearance during the go-around, that resulted in the tailwheel impacting a taxiway sign, a subsequent loss of control due to the damaged tailwheel, and a runway excursion during the landing.NTSB GAA25WA205Accident · 4 fatalClass 5 · ForeignAvions Robin DR400 · Wald im Pinzgau, AustriaNTSB ERA25LA256Accident · Serious injuriesClass 4 · LimitedFinal reportKyle Koncak Aventura II · DeLand, FLThe uncertificated pilot’s failure to remove an improvised gust lock which resulted in a loss of aircraft control at an altitude too low to recover.NTSB ERA25LA254Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 208 · Monroe, NJOn July 2, 2025, about 1729 eastern daylight time, a Cessna 208B, N716MM, was substantially damaged when it was involved in an accident near Monroe, New Jersey. The two commercial pilots and 10 passengers were seriously injured, while three passengers…NTSB WPR25LA201Accident · Minor injuriesClass 4 · LimitedFinal reportLancair IV · Alpine, WYThe pilot’s loss of visual reference during the landing approach which resulted in a collision with water.NTSB ERA25LA250Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 95-B55 (T42A) · Eustis, FLThe pilot’s inadequate preflight fuel planning and his failure to maintain directional control of the airplane after a total loss of right engine power during takeoff due to fuel starvation.NTSB ERA25FA246Accident · 6 fatalClass 3 · FieldPreliminary reportCessna 441 · Warren, OHOn June 29, 2025, about 0654 eastern daylight time, a Cessna 441, N441LS, was destroyed when it was involved in an accident near Warren, Ohio. The airline transport pilot and five passengers were fatally injured. The airplane was operated as a Title 14 Code…NTSB WPR25LA198Accident · No injuriesClass 4 · LimitedFinal reportRepublic RC-3 · Coolin, IDThe pilot’s failure to maintain control of the airplane and exceedance of the critical angle of attack during takeoff in windy conditions which resulted in a subsequent hard landing.NTSB ANC25LA066Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Chenega, AKThe pilot’s failure to maintain directional control during landing in gusting and variable wind conditions.NTSB WPR25LA192Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASH 30 MI · Santa Barbara, CAThe pilot’s failure to maintain taxiway centerline while taxiing off the runway which resulted in a left-wing strike with a runway direction sign.NTSB ERA25LA245Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Kelleys Island, OHThe pilot’s failure to maintain control of the airplane while taking off in gusting crosswind conditions.NTSB ERA25LA243Accident · No injuriesClass 4 · LimitedFinal reportCessna T188C · Mount Gilead, OHThe pilot’s failure to maintain adequate airspeed while in a turn during initial climb and the exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at a low altitude.NTSB WPR25FA190Accident · 1 fatalClass 3 · FieldPreliminary reportMD Helicopters 369E · Meeker, COOn June 25, 2025, about 1001 mountain daylight time, an MD Helicopters 369E, N411WJ, was substantially damaged when it was involved in an accident near Meeker, Colorado. The pilot was fatally injured. The helicopter was operated as a Title 14 Code of Federal…NTSB ANC25LA058Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-8 · Alexander Creek, AKThe pilot’s failure to maintain airplane control during final approach. Contributing to the accident was the airplane’s encounter with a downdraft that led to a rapid loss of altitude.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.