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 WPR24LA151Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman G164 · Maxwell, CAThe pilot’s failure to ascertain a proper touchdown point and late decision to initiate a go-around, which resulted in a subsequent collision with vegetation.NTSB CEN24LA185Accident · Serious injuriesClass 3 · LimitedFinal reportTitan T51 · Novi, MIA failure of the electrical system, resulting in a loss of fuel injection and subsequent loss of engine power.NTSB CEN24LA183Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV9 · Linn Grove, IAThe pilot’s mismanagement of the airplane’s approach resulting in a collision with terrain.NTSB CEN24LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Davis, OKThe pilot’s failure to maintain proper airspeed on approach which resulted in an extended touchdown, bounced landing, and runway overrun.NTSB WPR24LA146Accident · Minor injuriesClass 3 · LimitedFinal reportRobert Sterling 4P · Lake Havasu City, AZA loss of engine power during initial climb due to fuel vapor lock. Contributing to the accident was the incorrect installation of the ancillary fuel supply system components.NTSB WPR24LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna T206H · Halls Crossing, UTThe airplane’s collision with a tree during an aborted landing. Contributing to the accident was the airplane’s reported brake malfunction for undetermined reasons.NTSB CEN24LA177Accident · No injuriesClass 4 · LimitedFinal reportZenith CH-750 · Seymour, INThe flight instructor’s failure to maintain clearance from a fence during a takeoff attempt.NTSB ANC24LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Big Lake, AKThe pilot’s failure to maintain clearance from an obstacle during takeoff.NTSB ANC24LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Deer Park, WAThe pilot’s improper landing flare which resulted in the airplane contacting the ground short of the runway.NTSB CEN24LA139Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S53A · Rochester, MNThe pilot’s failure to maintain clearance from power lines while landing in a field.NTSB ERA24LA126Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Key Largo, FLThe pilot’s improper go-around technique, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB CEN24LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Clarion, IAThe pilot’s failure to maintain directional control during the landing flare in a crosswind with gusts.NTSB ERA24LA116Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Farmingdale, NYThe student pilot’s lack of fuel management during the flight and the flight instructor’s inadequate monitoring of his student’s fuel management, resulting in fuel starvation and a forced landing to a highway.NTSB CEN24LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · South Lyon, MIThe pilot’s failure to maintain clearance from trees during the landing approach.NTSB ERA24LA118Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLTail rotor contact with an unseen object while performing a precautionary landing to a closed helipad at night.NTSB CEN24LA102Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Terrell, TXThe total loss of engine power during the initial climb due to fuel exhaustion.NTSB GAA24WA078AccidentClass 5 · ForeignPiper 28 · Spa, BelgiumNTSB ANC24LA012Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Waialua, HIThe pilot's inability to maintain directional control after a skid got caught on a fence while he was maneuvering the helicopter for takeoff, which resulted in a dynamic roll-over.NTSB DCA24WA080Incident · No injuriesClass 5 · ForeignPilatus PC-12/45 · Gustavia, St. BarthélemyNTSB GAA24WA069Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cannes Mandelieu, FranceNTSB CEN24LA087Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Park Rapids, MNThe pilot’s failure to maintain directional control and terrain clearance during initial climb, that resulted in an impact with trees and terrain.NTSB CEN24FA083Accident · 2 fatalClass 3 · FieldFinal reportJust Highlander · Dolores, COThe pilot’s collision with a fence while taking off from a snow-covered dirt airstrip.NTSB CEN24FA073Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Canton, TXThe pilot’s failure to attain the runway while landing at night, which resulted in an impact with trees.NTSB WPR24FA057Accident · 3 fatalClass 3 · FieldFinal reportCessna 172G · Independence, ORThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in collision with an obstacle while landing.NTSB ERA24LA063Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Lajas, PRThe pilot’s failure to maintain adequate clearance from bushes alongside the runway, which resulted in a loss of directional control during the takeoff.NTSB CEN24LA047Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Barataria, LAA recreational boat crossed in front of the airplane’s path during landing on the water which resulted in the airplane colliding with the boat.NTSB WPR24LA044Accident · No injuriesClass 4 · LimitedFinal reportTheodore C Kalman ELA Eclipse 10 · Yuma, AZThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB CEN24LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C · Buffalo, MNThe pilot's failure to maintain directional control during the landing roll with a quartering headwind.NTSB CEN24LA039Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Ozark, MOA reported total loss of engine power for undetermined reasons.NTSB GAA24WA026Accident · No injuriesClass 5 · ForeignAerospatiale SA341G Gazelle · Spalding, United KingdomNTSB GAA24WA306Accident · No injuriesClass 5 · ForeignRaytheon Hawker · Ibadan, NigeriaNTSB WPR24FA018Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Covelo, CAThe pilot’s failure to maintain clearance from trees after entering a steep banked turn for unknown reasons. Contributing to the accident was the pilot’s decision to take off toward rising terrain.NTSB ERA24LA007Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Martinsville, VAThe pilot’s failure to maintain a positive climb rate after takeoff while distracted by primary flight display anomaly and terrain alerts. Contributing to the accident was the pilot’s decision to take off with the airplane over its maximum gross weight, which…NTSB CEN24LA009Accident · Serious injuriesClass 4 · LimitedFinal reportBallonbau Wörner NL-STU/1000 · Crandall, TXThe pilot-in-command’s inadequate descent planning that resulted in the balloon contacting power lines shortly after landing and an explosion of hydrogen gas.NTSB CEN24LA008Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Warrenton, MOThe pilot’s failure to maintain directional control during the touch-and-go landing. Contributing was the pilot’s decision to land with a quartering tailwind.NTSB WPR24FA001Accident · 1 fatalClass 3 · FieldFinal reportCubcrafters CCK-1865 · Twisp, WAThe pilot’s failure to see and avoid a rock during an aborted landing on a hillside, the collision with which resulted in damage to the aileron system that precluded subsequent control of the airplane.NTSB CEN24LA001Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Waupaca, WIThe pilot’s failure to maintain directional control during the go-around, that resulted in a runway excursion and an impact with terrain.NTSB WPR23LA358Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Salt Lake City, UTThe student pilot’s failure to maintain directional control during landing.NTSB GAA23WA271Accident · 1 fatalClass 5 · ForeignRobinson R44 · Garmen village, BulgariaNTSB GAA23WA256Accident · Serious injuriesClass 5 · ForeignLearjet 45XR · Mumbai, IndiaNTSB ERA23LA391Accident · Minor injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7 · Anderson, SCThe pilot’s failure to avoid trees during the descent for landing, resulting in substantial damage to the balloon.NTSB ERA23LA360Accident · No injuriesClass 3 · LimitedFinal reportBrown Benjamin C Challenger II · Moultonborough, NHA loss of engine power due to a loss of compression in one of the engine’s two cylinders.NTSB WPR23LA329Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Kanab, UTThe pilot's decision to take off in high density altitude conditions, which resulted in a loss of control and subsequent impact with terrain.NTSB CEN23LA385Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206 · Hibbing, MNThe ground crew’s failure to secure the backpack at the landing zone (LZ), that resulted in the tail rotor impacting the backpack during the landing. Contributing to the accident was the pilot’s inadequate selection of an area at the LZ, the lack of awareness…NTSB ANC23LA063Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · Skwentna, AKThe airplane’s float contacted an undetected submerged gravel bar during landing which resulted in a nose over.NTSB ERA23LA336Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · North Myrtle Beach, SCThe pilot’s failure to properly secure the left wing fuel cap, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN23FA360Accident · Serious injuriesClass 3 · FieldFinal reportPiper PA-24-250 · Oklahoma City, OKThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN23LA350Accident · No injuriesClass 3 · LimitedFinal reportBell 206 · Carthage, ILA collision with a fence during landing due to the crew’s reduced distance estimation and depth perception while using night vision goggles. Contributing to the accident was the low moon angle, which made viewing the fence more challenging.NTSB CEN23LA346Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Halstad, MNThe pilot’s attempt to rotate the airplane without sufficient airspeed which resulted in a lack of climb performance and impact with terrain. Contributing to the accident was the pilot’s decision to attempt the takeoff with a tailwind.NTSB WPR23LA290Accident · Serious injuriesClass 4 · LimitedFinal reportBeech 23 · Coolin, IDThe pilot’s failure to maintain clearance from trees after takeoff, during high density altitude weather conditions.