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 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 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 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 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 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 WPR25LA118Accident · Minor injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Hobbs, NMThe student pilot’s loss of directional control during a hover, which resulted in an impact with terrain.NTSB CEN25LA145Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra Mkii · Nacogdoches, TXThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB GAA25WA139Accident · 1 fatalClass 5 · ForeignCessna 150m · Northhampton, AustraliaNTSB ERA25FA151Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22 · LaFayette, GAThe pilot’s exceedance of the airplane’s critical angle of attack while landing and the flight instructor’s inadequate remedial action, which resulted in an aerodynamic stall/spin at an altitude too low for recovery.NTSB WPR25LA117Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Henderson, NVThe pilot’s failure to maintain directional control during the landing, in gusting crosswind conditions.NTSB WPR25FA114Accident · 1 fatalClass 3 · FieldPreliminary reportBell 206B II · Mountain Home Park, WAOn March 19, 2025, at 1228 Pacific daylight time, a Bell 206B II, N23SD, was substantially damaged when it impacted electrical cables and terrain near Mountain Home Park, Washington. The commercial pilot was fatally injured. The helicopter was operated as a…NTSB ERA25LA149Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Miami, FLThe student pilot’s failure to maintain control of the airplane during a go-around, which resulted in an aerodynamic stall.NTSB ERA25LA147Accident · Serious injuriesClass 4 · LimitedFinal reportChampion 7AC · Palmetto, FLThe flight instructor’s inability to overpower control inputs made by the student pilot during initial climb, which resulted in the airplane impacting powerlines and the ground.NTSB CEN25LA128Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Rusk, TXThe pilot's failure to maintain airplane control and adequate airspeed during the go-around, resulting in an aerodynamic stall and impact with terrain.NTSB CEN25LA129Accident · No injuriesClass 4 · LimitedFinal reportStemme S10-VT · Kiowa, COThe pilot’s inadequate preflight inspection and fuel planning which resulted in a total loss of engine power due to fuel exhaustion.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 CEN25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lincoln, NEA failure of the flight crew to ensure that the landing gear was properly extended before landing.NTSB CEN25LA118Accident · No injuriesClass 4 · LimitedFinal reportJust Superstol · Paonia, COThe pilot’s failure to maintain the airplane’s directional control during the takeoff roll.NTSB GAA25WA116Accident · 1 fatalClass 5 · ForeignCessna 152 · Voi, KenyaNTSB ERA25LA136Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · North Myrtle Beach, SCThe pilot’s failure to maintain directional control while attempting to land in a gusty crosswind, which resulted in a runway excursion.NTSB CEN25LA111Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Pearland, TXOn March 6, 2025, about 1145 central standard time, a Piper PA-28-140 airplane, N54479, was substantially damaged when it was involved in an accident near Pearland, Texas. One pilot sustained minor injuries, and the other pilot was not injured. The airplane…NTSB WPR25FA108Accident · 1 fatalClass 3 · FieldPreliminary reportCessna A150L · Renslow, WAOn March 4, 2025, at 1555 Pacific standard time, a Cessna A150L, N6167F, was destroyed when it was involved in an accident near Renslow, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91…NTSB CEN25FA106Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV7 · Matheson, COOn March 1, 2025, about 1215 mountain daylight time, a Vans RV7 experimental airplane, N902T, was destroyed when it was involved in an accident near Matheson, Colorado. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB ERA25LA380Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter UH-1D · DeLand, FLThe pilot’s loss of helicopter control during landing approach in strong wind conditions, which resulted in tail rotor contact with the ground during landing.NTSB ERA25LA130Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Manchester, VTThe pilot’s improper decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in the accumulation of airframe icing and a subsequent aerodynamic stall/spin.NTSB ERA25LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech E33 · Lenoir, NCThe mechanic’s inadequate annual inspection of the airplane and failure to comply with an applicable airworthiness directive, which resulted in a total loss of engine power due to oil starvation.NTSB ERA25LA128Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Alton Bay, NHThe pilot’s failure to maintain an appropriate glide path during the landing approach, which resulted in in the airplane contacting a snowbank short of the runway.NTSB WPR25LA103Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe unmanned aircraft system’s failure to maintain clearance from an obstacle, which resulted in a loss of control and impact with terrain.NTSB CEN25LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Breckenridge, TXThe mechanic’s failure to properly install the throttle cable hardware resulting in a separation of the cable and loss of engine throttle control.NTSB CEN25LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Pearland, TXThe pilot’s poor flight planning and decision making, which resulted in a loss of engine power due to fuel exhaustion.NTSB ERA25FA120Accident · 2 fatalClass 3 · FieldPreliminary reportRockwell 112 · Covington, GAOn February 15, 2025, about 2300, a Rockwell 112, N1423J, was destroyed when it was involved in an accident near Covington, Georgia. The private pilot and one passenger were fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR25LA093Accident · No injuriesClass 4 · LimitedFinal reportAirbus Helicopters EC 130 T2 · Moab, UTThe inflight collision with debris during takeoff.NTSB ERA25LA112Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Rock Hill, SCThe student pilot’s failure to maintain control of the airplane during an aborded crosswind landing.NTSB ANC25MA018Accident · 10 fatalClass 1 · MajorFinal reportTextron 208B · Nome, AKThe National Transportation Safety Board determines that the probable cause of this accident was the pilot’s inadequate airspeed management due to workload and degraded situation awareness and his improper inputs leading up to and during the aerodynamic…NTSB GAA25WA077Accident · 1 fatalClass 5 · ForeignRobinson R44 · Pacific Ocean, EcuadorNTSB GAA25WA098Accident · 3 fatalClass 5 · ForeignRobinson R44 · Cruzilia, BrazilNTSB ERA25FA103Accident · 1 fatalClass 3 · FieldPreliminary reportBeech V35B · Charlottesville, VAOn January 25, 2025, about 1235 eastern standard time, a Beech V35B, N2UZ, was destroyed when it was involved in an accident near Charlottesville, Virginia. The airline transport pilot was fatally injured. The airplane was operated as a Title 14 Code of…NTSB GAA25WA080Accident · 1 fatalClass 5 · ForeignCessna 188 · Canarana, BrazilNTSB CEN25LA085Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-235 · Mount Vernon, ILThe pilot's improper landing flare and subsequent improper recovery from a bounced landing, which resulted in a collision with terrain.NTSB GAA25WA064Accident · 3 fatalClass 4 · ForeignBell Textron Canada 407 · Paredones Commune, ChileNTSB ERA25LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Smyrna, TNThe pilot’s failure to maintain an appropriate approach path, resulting in the airplane contacting a tree during a landing approach at night.NTSB WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB GAA25WA074Accident · No injuriesClass 5 · ForeignAir Tractor AT502 · Paracatu, BrazilNTSB ERA25LA097Accident · No injuriesClass 4 · LimitedFinal reportJonathan C Eggers Challenger II · Conway, SCThe pilot's inadequate fuel planning, which resulted in a total total loss of engine power due to fuel exhaustion.NTSB GAA25WA057Accident · 1 fatalClass 5 · ForeignThrush S2R · Santa Ines, HondurasNTSB ERA25LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Newburyport, MAThe flight instructor’s delayed decision to initiate a go-around, which resulted in the airplane colliding with an obstacle during approach.NTSB CEN25LA068Accident · Minor injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Lubbock, TXThe loss of directional control during the takeoff roll for undermined reasons that resulted in an impact with trees.NTSB ERA25LA088Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Naples, FLOn January 1, 2025, at 0120 eastern standard time, a Beech A36, N8163F, was substantially damaged when it was involved in an accident at Naples Municipal Airport (APF), Naples, Florida. The private pilot and three passengers were not injured. The flight was…NTSB ERA25FA086Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310 · Peebles, OHOn December 30, 2024, about 1515 eastern standard time, a Cessna 310D, N6979T, was substantially damaged when it was involved in an accident near Peebles, Ohio. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…