NTSB investigations
829 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '490') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '490') 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 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 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 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 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 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.NTSB CEN23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Eagle River, WIThe pilot’s decision to takeoff from an unsuitable surface which resulted in collision with an object.NTSB CEN23LA090Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Hyannis, NEThe pilot’s failure to maintain clearance from a snowbank during landing, which resulted in a nose-over.NTSB WPR23LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180K · Agua Caliente Springs, CAThe pilot’s failure to maintain aircraft control during an aborted approach, which resulted in a collision with terrain.NTSB WPR23LA082Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Watsonville, CAThe pilot’s failure to maintain clearance from powerlines during a go around.NTSB GAA23WA084Accident · 1 fatalClass 5 · ForeignSocata TB21 · Saint-Pons, FranceNTSB GAA23WA076Accident · 2 fatalClass 5 · ForeignBanus Mark Glasair Super II FT · Wedderburn, AustraliaNTSB ERA23LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Franklin, VAThe pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…NTSB WPR23LA068Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC120B · Rancho Cordova, CAThe pilot receiving instruction’s loss of helicopter control during landing with a crosswind, and the flight instructor’s delayed remedial action.NTSB CEN23FA059Accident · 1 fatalClass 3 · FieldFinal reportEngineering & Research Ercoupe 415-C · Corning, IAThe pilot’s failure to maintain clearance from obstructions during a go-around, which resulted in impact with powerlines, a tree, and the ground.NTSB ERA23FA077Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Falmouth, MAThe pilot’s failure to maintain clearance from trees during the landing approach. Contributing to the accident was the sun glare, which impaired the pilot's visibility and situational awareness.NTSB WPR23LA052Accident · No injuriesClass 4 · LimitedFinal reportRutan Long-EZ · Mountain Green, UTThe pilot’s flight into a valley with rising terrain that the airplane was incapable of out-climbing.NTSB ERA23LA071Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Gaithersburg, MDThe pilot’s visual flight below published altitude minimums, which resulted in collision with a powerline tower structure.NTSB ERA23LA072Accident · Serious injuriesClass 4 · LimitedFinal reportDaniel Anthony Proctor M24 Orion Plus · Suches, GAThe pilot's decision to take off from the runway midpoint with a tailwind, which resulted in impact with terrain.NTSB CEN23FA046Accident · 1 fatalClass 3 · FieldFinal reportExtra EA300 · Wonder Lake, ILThe pilot’s failure to maintain a proper descent path to the runway after he became disorientated by sun glare while on final approach, which resulted in a collision with trees and terrain.NTSB WPR23LA045Accident · No injuriesClass 3 · LimitedFinal reportSikorsky UH-60A · San Diego, CAThe failure of the crewmembers of the second helicopter to maintain visual separation with the first helicopter while complying with the LC controller’s instruction to go around. Contributing to the accident were the nighttime conditions and the lack of a…NTSB WPR23LA030Accident · Minor injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s improper decision to takeoff from an unimproved airstrip with insufficient takeoff distance which, resulted in a runway overrun and collision with vegetation.NTSB CEN23LA024Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Hardin, TXThe pilot’s failure to maintain clearance from the powerlines while landing.NTSB GAA23WA017Accident · 2 fatalClass 5 · ForeignCessna T206G · Guayaquil, EcuadorNTSB GAA23WA015Accident · 1 fatalClass 3 · ForeignCessna 172 · Ulsan, South KoreaNTSB CEN23LA006Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International S53A · Albuquerque, NMThe pilot’s inability to find a suitable landing area in a critical fuel situation and his decision to land on a highway, which resulted in the balloon impacting a bridge railing and terrain.NTSB GAA23WA005Accident · 1 fatalClass 5 · ForeignBell 206 · Maitland, AustraliaNTSB ANC22LA078Accident · Minor injuriesClass 4 · LimitedFinal reportDehavilland DHC-2 · Egegik, AKThe pilot’s loss of control during takeoff in gusting wind conditions.NTSB CEN22LA412Accident · Serious injuriesClass 3 · LimitedFinal reportZenith 750 · Silex, MOThe pilot’s failure to maintain clearance from the powerlines during takeoff.NTSB ERA22FA399Accident · 2 fatalClass 3 · FieldFinal reportConway Philip J Glasair Super II SFT · Bay City, WIThe continuation of a poorly-flown, unstabilized approach and the flight instructor’s failure to direct a discontinuance of that approach, resulting in a collision with terrain during turn to final.NTSB ANC22LA070Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot’s failure to maintain centerline in dusk light conditions which resulted in impact with trees.NTSB GAA22WA283Accident · 5 fatalClass 5 · ForeignCessna 210 · Impalia, NamibiaNTSB WPR22LA320Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 152 · Ione, CAThe flight instructor’s delayed decision to abort the takeoff, which resulted in impact with a fence and a tree. Contributing to the accident was the instructor’s decision to land at the unfamiliar airstrip without determining whether it was within the…NTSB ERA22LA379Accident · Minor injuriesClass 4 · LimitedFinal reportBoeing A75N1 · Bealeton, VAThe pilot of the departing airplane’s failure to see and avoid the landing airplane before takeoff, resulting in a collision with the landing airplane. Contributing was the airport’s failure to encourage pilots to use radios for traffic deconfliction when…NTSB ERA22LA373Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Gardiner, NYThe pilot’s failure to go-around in a timely manner which resulted in a collision with a fence.NTSB WPR22LA294Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-160 · White Salmon, WAThe pilot’s failure to attain a proper touchdown point, and his delayed decision to go around which, resulted in a collision with trees.NTSB ERA22LA370Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Shirley, NYThe flight instructor’s failure to ensure clearance from an electrical junction box during takeoff, which resulted in a collision.NTSB WPR22LA288Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McCarthy, AKThe pilot’s improper decision to takeoff from an unimproved airstrip with a high density altitude which degraded its climb performance and led to a collision with vegetation off the end of the airstrip.NTSB ERA22LA334Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter AS365 · Hamilton, OHThe pilot’s decision to continue the landing without having visually identified wires that were known to be in the vicinity of the landing zone, which resulted in a collision with the wires while attempting an off-airport landing in dark night visual…NTSB CEN22LA336Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Ray, MIThe pilot’s early rotation on takeoff, which resulted in insufficient airspeed and an inability to gain sufficient altitude to clear the trees.NTSB CEN22LA310Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502B · Wyoming, ILThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN22LA307Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300T · Frankston, TXThe pilot’s delayed aborted takeoff that resulted in a runway overrun and impact with terrain.NTSB CEN22FA299Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-300 · Mount Pleasant, TXThe pilot’s failure to maintain the proper glidepath while on final approach in night visual conditions, which resulted in a collision with trees.NTSB ERA22LA292Accident · No injuriesClass 3 · LimitedFinal reportLuscombe 8 · New Market, VAImpact with a fence during an attempted takeoff from a short, uphill turf airstrip.NTSB CEN22LA262Accident · Serious injuriesClass 4 · LimitedFinal reportCessna P210N · Cresson, TXThe pilot's failure to complete proper preflight performance planning and his operation of the airplane outside of the manufacturer's specified weight and balance limitations, which resulted in the airplane’s inability to maintain altitude and an impact with…NTSB CEN22LA261Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Eden Prairie, MNThe student pilot not maintaining directional control during landing which resulted in a runway excursion.NTSB CEN22LA287Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Newport, ARThe pilot’s failure to maintain clearance from obstructed terrain during takeoff.NTSB GAA22WA197Accident · 1 fatalClass 3 · ForeignPiper PA31 · Deadman's Cay, BahamasNTSB CEN22LA221Accident · Serious injuriesClass 3 · LimitedFinal reportCameron Balloons Z-90 · Burlington, WIThe pilot’s selection of an inappropriate landing location and his failure to avoid an oncoming freight train, which resulted in the train colliding with and dragging the balloon.