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 WPR23FA289Accident · Serious injuriesClass 3 · FieldFinal reportCessna 177 · Gillette, WYThe pilot's decision to depart the high-density-altitude airport with the airplane at the maximum gross weight limit.NTSB GAA23WA224Accident · No injuriesClass 5 · ForeignPiper 25 · Caboolture, AustraliaNTSB ERA23LA316Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Maiden, NCThe flight instructor’s inadequate supervision of the landing approach and go-around, and his delayed remedial action.NTSB CEN23LA330Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 177 · Cortland, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing.NTSB ERA23LA314Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20R · Chattanooga, TNThe pilot’s failure to maintain the proper glidepath during final approach, which resulted in a collision with the approach lights short of the runway. Contributing was the pilot’s distraction due to the cabin door opening.NTSB ANC23LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 MK. I(L20A) · Point Baker, AKThe pilot’s failure to maintain directional control during takeoff with a quartering tailwind.NTSB ERA23LA304Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182 · Stow, MAThe pilot’s delayed decision to abort the landing, which resulted in a collision with trees.NTSB CEN23LA321Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Plains, KSThe pilot’s failure to maintain control during takeoff from a water-contaminated runway.NTSB WPR23LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Elko, NVThe pilot’s failure to ensure adequate airplane performance before taking off from a significantly shorter runway than originally planned for.NTSB WPR23LA281Accident · Serious injuriesClass 4 · LimitedFinal reportSix Chuter SR7 · Hamilton, MTThe pilot’s failure to maintain directional control during takeoff and subsequent impact with a tree.NTSB CEN23LA296Accident · Minor injuriesClass 3 · LimitedFinal reportMagni M24 · Mineral Point, MOThe inflight loss of the engine’s air filter which collided with the propeller which resulted in a vibration.NTSB WPR23LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Judith Gap, MTThe pilot's decision to take off on a soft field that exceeded the performance capabilities of the airplane, which resulted in an impact with a pole and terrain.NTSB WPR23LA261Accident · No injuriesClass 4 · LimitedFinal reportNorth American AT-6G · La Grande, ORThe pilot's failure to maintain clearance from trees during an airstrip overfly, which resulted in impact damage to the left wing.NTSB CEN23LA287Accident · No injuriesClass 4 · LimitedFinal reportAerofab LA-4 · Big Prairie, MIThe airplane’s collision with a submerged log during a water landing.NTSB GAA23WA189AccidentClass 5 · ForeignCygnet sea & Sky · Açores, PortugalNTSB GAA23WA188Accident · 2 fatalClass 5 · ForeignCessna 206 · Gracias A Dios, HondurasNTSB WPR23LA240Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Cedar Mountain, UTThe pilot’s decision to depart with a high density altitude, which degraded the airplane’s climb performance and resulted in an impact with trees.NTSB CEN23LA265Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Model 5 · Livingston, TXThe pilot’s failure to maintain directional control during the rollout, which resulted in a runway excursion, and a collision with a building. Contributing to the accident were the obstacles at the airstrip that prevented the pilot from performing a go-around.NTSB WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.NTSB ERA23LA271Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Seymore, TNThe flight instructor’s failure to properly configure the wing flaps for a soft-field takeoff on a short runway, which resulted in a runway overrun and collision with trees.NTSB CEN23LA244Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Sturgis, SDThe pilot’s improper timing to initiate beta mode with the propeller and his failure to maintain directional during the full load landing that resulted in a runway excursion. Contributing to the accident was the pilot’s lack of recent experience with…NTSB ANC23FA042Accident · 2 fatalClass 3 · FieldFinal reportCessna 180 · Shaktoolik, AKThe pilot’s encounter with gusting tailwind conditions during takeoff, which resulted in impact with a tree, a loss of control, and subsequent impact with terrain.NTSB CEN23LA243Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edna, TXThe pilot’s failure to maintain directional control during a precautionary off-field landing.NTSB WPR23FA225Accident · 1 fatalClass 3 · FieldFinal reportCessna R182 · McCall, IDMaintenance personnel's failure to properly torque and inspect the magneto hardware, which resulted in a partial loss of engine power.NTSB WPR23LA217Accident · Minor injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Bakersfield, CAThe pilot’s improper use of flaps during the takeoff sequence which resulted in a runway overrun and collision with trees.NTSB WPR23LA212Accident · Serious injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Colusa, CAThe pilot’s failure to maintain clearance from a power line during a low-level aerial application flight. Contributing to the accident was the pilot’s fatigue.NTSB CEN23LA214Accident · No injuriesClass 3 · LimitedFinal reportProgressive Aerodyne Searey LSA · Detroit, MIA loss of engine power due to fuel exhaustion that resulted from the pilots’ inadequate preflight planning.NTSB GAA23WA157Accident · No injuriesClass 5 · ForeignPiper PA46-500TP · Saint-Tropez, FranceNTSB WPR23LA205Accident · No injuriesClass 4 · LimitedFinal reportPiaggio Aero Industries P180 · Sugar Land, TXThe pilot’s failure to complete required preflight checklist items and properly configure the flaps for takeoff.NTSB ERA23LA243Accident · No injuriesClass 4 · LimitedFinal reportThompson Edward LM-5X-W · Limington, METhe pilot’s inadequate compensation for the gusty crosswind conditions, which resulted in a collision with a tree during landing.NTSB CEN23LA197Accident · No injuriesClass 4 · LimitedFinal reportGulfstream-Schweizer A/C Gulfstream AM G-164B · Gueydan, LAThe failure of both pilots to see and avoid each other resulting in a collision on the airstrip. Contributing was the pilots’ failure to announce their intentions over their radios as they were taking off and landing.NTSB CEN23LA184Accident · Serious injuriesClass 4 · LimitedFinal reportRans S7 · Gardner, KSThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.NTSB CEN23LA182Accident · No injuriesClass 3 · LimitedFinal reportLoehle Acft 5151 Mustang · Hector, MNA total loss of engine power due to fuel starvation as a result of the pilot’s modifications to the fuel system. Contributing to the accident was the pilot’s decision to continue the takeoff despite observing lower than anticipated propeller rpm, his decision…NTSB WPR23LA186Accident · Serious injuriesClass 3 · LimitedFinal reportAviat A-1C-180 Husky · Lakewood, WAAn erroneous landing gear warning that led to the pilot’s decision to abort the landing, which resulted in a collision with trees during a go-around.NTSB ERA23LA222Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150M · Hernando, FLThe pilot’s failure to maintain adequate clearance from obstacles during takeoff at night.NTSB CEN23LA169Accident · No injuriesClass 3 · LimitedFinal reportZenith Stol CH750 · Udall, KSThe pilot’s failure to maintain clearance from power lines. Contributing to the accident was the reported loss of engine power for reasons that could not be determined.NTSB WPR23LA169Accident · No injuriesClass 4 · LimitedFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Glendale, AZThe student pilot’s improper landing flare, which resulted in a hard landing and the flight instructor’s delayed remedial action.NTSB WPR23LA165Accident · No injuriesClass 4 · LimitedFinal reportOneal J R/Oneal R C EDI Express · Tracy, CAThe pilot’s failure to maintain directional control during the takeoff roll.NTSB CEN23FA160Accident · Serious injuriesClass 3 · FieldFinal reportAero Vodochody L-139 · Bridgeport, TXThe pilot’s failure to maintain a stabilized approach path while checking for possible bird strike damage that resulted in a delayed go-around attempt and a collision with terrain. Contributing to the accident was the flight instructor’s distraction while…NTSB ERA23LA207Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 1-26E · Wake Forest, NCThe student pilot’s failure to maintain airspeed during the landing approach, which resulted in an exceedance of the glider’s critical angle of attack, an aerodynamic stall, and a loss of control.NTSB ERA23LA199Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Somerset, KYThe pilot’s failure to maintain control of the airplane during the takeoff, which resulted in a runway excursion and collision with an airport navigation antenna.NTSB CEN23LA145Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA32 · Lincoln, ILA total loss of engine power during an approach for landing for undetermined reasons.NTSB ERA23LA161Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-46-350P · St. Augustine, FLThe pilot's inadequate preflight planning, which resulted in a takeoff above the airplane’s maximum gross weight, a CG forward of the limit, and a tailwind component that prevented the airplane from climbing above trees.NTSB ERA23LA198Accident · No injuriesClass 3 · LimitedFinal reportS C Aerostar S A YAK-52 · Toughkenamon, PAThe pilot’s failure to see and avoid powerlines while on approach to land.NTSB CEN23LA135Accident · No injuriesClass 3 · LimitedFinal reportBell Helicopter Textron APT70 · Mineral Wells, TXThe flight crew’s loss of control of the unmanned aircraft due to software limitations. Contributing to the accident was the overly restrictive low voltage threshold limits.NTSB CEN23LA121Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Oklahoma City, OKThe pilot’s failure to maintain directional control during the landing, that resulted in a runway excursion, and an impact with an obstacle.NTSB WPR23LA109Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Morgan, UTThe pilot’s failure to maintain directional control during landing.NTSB CEN23LA108Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172H · Crosby, TXThe pilot’s delayed soft-field takeoff procedure, which prevented the pilot from achieving adequate airspeed and a proper climb rate resulting in a collision with a moving train.NTSB WPR23LA106Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing and subsequent failure to maintain clearance from a snow berm during a go around.NTSB WPR23LA101Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Dallesport, WAThe flight instructor’s failure to see and avoid a channel marker during a step taxi in preparation for takeoff on the water.