NTSB investigations
1,332 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 WPR18CA146Accident · No injuriesData collectionFinal reportAyres S2R G10 · Marysville, CAThe pilot’s failure to maintain clearance from a truck while on final approach after the airplane encountered a downdraft, which resulted in the subsequent failure of the right main landing gear and loss of directional control.NTSB CEN18LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Luling, TXThe pilot’s failure to secure the left-wing fuel cap after refueling the airplane, which resulted in a fuel leak on takeoff.NTSB GAA18CA284Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · Bayou La Batre, ALThe pilot’s improper planning for landing on a wet grass airstrip, which resulted in a runway overrun.NTSB GAA18CA263Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1 26 · Springfield, VTThe pilot’s inability to maintain sufficient altitude after the glider encountered downdrafts during the approach, which resulted in the glider striking trees.NTSB GAA18CA259Accident · Minor injuriesData collectionFinal reportCreech Jerry Creech Jerry CH 701 · Lusby, MDThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.NTSB GAA18CA244Accident · No injuriesData collectionFinal reportLuscombe 8 · Eunice, LAThe pilot’s failure to maintain clearance from a tree while on approach to land.NTSB CEN18LA148Accident · Serious injuriesLimited investigationFinal reportMaule M 5-235C · Roxbury, KSThe pilot's failure to maintain directional control during takeoff from a road, which resulted in impact with a sign.NTSB GAA18CA223Accident · No injuriesData collectionFinal reportKen Olson Scamp · Raymond, WAThe pilot's failure to maintain a proper landing flare, which resulted in an aerodynamic stall, bounced landing, and subsequent secondary stall during a go-around attempt.NTSB GAA18CA411Accident · No injuriesData collectionFinal reportEipper Quicksilver · Marietta, SCThe pilot's improper landing flare, which resulted in a loss of directional control.NTSB GAA18CA221Accident · No injuriesData collectionFinal reportCessna 120 · Iola, WIThe pilot’s decision to reject the takeoff from a snow-covered grass surface, which resulted in a nose-over.NTSB GAA18CA211Accident · No injuriesData collectionFinal reportCessna A185 · Sterling, AKThe pilot’s failure to maintain clearance from trees during the approach to land due to the sun glare.NTSB CEN18FA132Accident · 2 fatalField investigationFinal reportCessna 150 · Marion, INThe failure of both pilots to see and avoid the other airplane as they converged on intersecting runways. Contributing to the accident was the jet pilot's not monitoring the airport's traffic advisory frequency, known reduced visibility of the intersecting…NTSB GAA18CA185Accident · No injuriesData collectionFinal reportUltramagic N 300 · Cave Creek, AZThe balloon pilot’s decision to add heat to the envelope with a tree branch protruding into the envelope that caught fire.NTSB ERA18LA116Accident · Minor injuriesClass 3 · LimitedFinal reportLindstrand Balloons 105A · Wesley Chapel, FLThe pilot's failure to maintain adequate clearance from powerlines during landing approach, which resulted in an inflight collision with the powerlines.NTSB CEN18LA123Accident · 1 fatalLimited investigationFinal reportMills Michael S1L · Dewitt, MIThe pilot's failure to see and avoid power lines due to sun glare.NTSB ANC18LA027Accident · Serious injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Arctic OceanThe flight crew's improper decision to deliberately operate the airplane at low altitude and along a flightpath that resulted in a collision with a pedestrian after takeoff. Contributing to the accident was the pedestrian's proximity to the runway.NTSB GAA18CA197Accident · No injuriesData collectionFinal reportPiper PA28 · Cedar Key, FLThe pilot’s unstabilized approach, which resulted in a long landing and subsequent runway overrun.NTSB WPR18LA105Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-180 · Montague, CAImpact with powerlines and terrain after takeoff for reasons that could not be determined based on the available information.NTSB ERA18LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Edgewater, FLThe flight instructor's failure to maintain the appropriate glidepath to the runway, which resulted in a collision with trees and terrain during final approach.NTSB GAA18CA146Accident · Minor injuriesData collectionFinal reportCessna 172 · Gatesvile, TXThe pilot’s failure to maintain directional control during initial climb in a gusty condition.NTSB WPR18LA092Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Obyan, SarkThe pilot's inadequate preflight fuel planning and inadequate in-flight fuel monitoring which resulted in a total loss of engine power due to fuel exhaustion and an emergency landing and subsequent impact with a ditch.NTSB WPR18LA089Accident · No injuriesLimited investigationFinal reportShanks V Roger Vari EZE · Santa Monica, CAAn undetected fluid leak in the right brake line, which resulted in a reduction of braking effectiveness at the right wheel and a loss of directional control during the landing roll.NTSB GAA18CA125Accident · Serious injuriesData collectionFinal reportBaker Victor R Kitfox · Carson City, NVThe pilot-receiving-instruction’s failure to maintain directional control during takeoff.NTSB ERA18WA261Accident · Serious injuriesForeign investigationSkyrunner MK 3.2 · Margham, Dubai, United Arab EmiratesThe government of the United Arab Emirates has notified the NTSB of an accident involving a SkyRunner, MK-3.2 Powered Parachute that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of United Arab…NTSB GAA18CA107Accident · No injuriesData collectionFinal reportBell UH 1H · Van Nuys, CAThe pilot’s failure to maintain clearance from a stationary helicopter during landing. Contributing to the accident was the ground crew’s failure to ensure that the helicopter would clear the stationary helicopter.NTSB GAA18CA094Accident · No injuriesData collectionFinal reportPiper PA32 · Spearfish, SDThe pilot’s inadvertent landing in snow adjacent to the snow-covered runway resulting in a collision with runway signs.NTSB ENG18WA024Accident · No injuriesForeign investigationAntonov TVS-2MS · Naryan-Mar, RussiaA TVS-2MS airplane powered by a Honeywell TPE331-12UHR-702H and equipped with skids impacted unpaved runway after an aborted takeoff. The airplane was completed destroyed. The Russian Interstate Aviation Committee (MAK) is investigating.NTSB GAA18CA105Accident · No injuriesData collectionFinal reportGolden Circle Air T Bird II · Wiscassett, METhe pilot’s failure to maintain directional control during the takeoff roll.NTSB ERA18LA050Accident · No injuriesLimited investigationFinal reportCessna 152 · Everglades City, FLThe loose nut connecting the mixture control cable to the mixture control arm, which resulted in the pilot’s inability to control the mixture and the subsequent total loss of engine power.NTSB GAA18CA075Accident · Minor injuriesData collectionFinal reportJones Kent C Vans RV-10 · Limon, COThe pilot’s unstabilized approach and failure to go around at night, which resulted in the airplane impacting a power line and a subsequent hard landing.NTSB ANC18LA011Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Oloh, MSA partial loss of engine power due to the failure of the No. 3 valve key (exhaust).NTSB WPR18WA017Accident · 1 fatalForeign investigationCessna 210 · Albany, AustraliaOn October 24, 2017, at 1115 local time, a Cessna 210B, VH-DBU, was destroyed when it impacted the ground following a collision with terrain near Albany, Western Australia. The airplane was operated under the pertinent regulations of the Australian…NTSB GAA18CA017Accident · Serious injuriesData collectionFinal reportYoung David E Pitts S1 C · Farmville, VAThe pilot’s failure to see and avoid the other airplane landing in the opposite direction on the runway. Contributing to the accident was the pilot’s failure to use the correct runway call sign in his radio communications.NTSB ERA18LA011Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 402 · St. Petersburg, FLThe pilot's mismanagement of the onboard fuel, which resulted in fuel starvation, a total loss of power to both engines, and a subsequent forced landing.NTSB CEN18WA007Accident · 1 fatalForeign investigationRobinson R44 · Gramzda, LatviaOn October 8, 2017, about 1014 Coordinated Universal Time (UTC), a Robinson R44 helicopter, YL-HBH, impacted a powerline after takeoff near Gramzda, Latvia. One passenger was fatally injured and the pilot and two other passengers on board were seriously…NTSB GAA18CA007Accident · No injuriesData collectionFinal reportCessna T210 · Waterford, MIThe pilot's unstabilized approach at night, which resulted in collision with trees.NTSB GAA18CA016Accident · Serious injuriesData collectionFinal reportUltramagic T210 · Albuquerque, NMThe pilot's failure to maintain adequate clearance from a balloon on the ground during landing.NTSB CEN18LA002Accident · Serious injuriesLimited investigationFinal reportCharles A Brazil MTO Sport · McCoy, TXThe pilot’s failure to maintain clearance from a powerline during landing.NTSB GAA17CA546Accident · No injuriesData collectionFinal reportCessna 150 · Siler City, NCThe pilot's improper decision to take off with known electrical issues, which distracted him and led to a loss of directional control during the takeoff roll.NTSB ERA17LA337Accident · No injuriesClass 3 · LimitedFinal reportAirmax Construcoes Aeronautica SEAMAX-M22 · New Fairfield, CTCollision with a submerged object during a water landing.NTSB CEN17CA345Accident · No injuriesData collectionFinal reportShiner RV-4 · Ramah, NMThe pilot’s failure to maintain clearance from berms during landing in sun glare conditions.NTSB GAA17CA576Accident · Minor injuriesData collectionFinal reportHunter George RV 6 · Montgomery, NYThe pilot’s loss of directional control during the takeoff roll, which resulted in impact with visual approach slope indicator lights.NTSB ANC17LA046Accident · No injuriesLimited investigationFinal reportThrush S2R · Talkeetna, AKThe pilot's improper landing in the tailwheel-equipped airplane, which allowed an excessive load on the tailwheel and resulted in the subsequent component fracture, loss of control, runway excursion, and impact with terrain.NTSB DCA17WA165Accident · No injuriesForeign investigationBoeing 737 · Medan, IndonesiaThe KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…NTSB ANC17CA041Accident · No injuriesData collectionFinal reportAirbus AS350 · Delta Junction, AKThe pilot’s failure to maintain clearance from a steel frame attached to a tracked drilling unit. Contributing to the accident was the pilot’s failure to visually identify the steel frame during the reconnaissance process.NTSB GAA17CA450Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Dunlap, ILThe pilot’s failure to visually confirm that the helicopter was disconnected from hoses during refueling operations. Contributing to the accident was the pilot’s and ground crew’s misunderstanding of the hand signals.NTSB ERA17RA260Accident · 1 fatalForeign investigationBritten Norman BN2A · Eteringbang, GuyanaOn July 25, 2017, about 2153 coordinated universal time, a Britten Norman BN2A-26, Guyana Registration 8R-GRA, operated by Roraima Airways Ltd., was substantially damaged when it impacted wooded terrain while on approach to Eteringbang Airstrip (SYET),…NTSB ANC17CA038Accident · No injuriesData collectionFinal reportDehavilland DHC 2 · Dilllingham, AKThe pilot's failure to set the wing flaps to the "takeoff" position, which resulted in a longer-than-normal takeoff run and collision with terrain.NTSB ERA17CA251Accident · No injuriesData collectionFinal reportWeatherly 620 · Pemberton Twp, NJAn in-flight collision with a bird during takeoff, which resulted in a partial loss of engine power and subsequent collision with trees and terrain.NTSB CEN17WA279Accident · 1 fatalForeign investigationPiper Piper J3C-65 · Laukaa, FinlandOn July 19, 2017, about 0903 coordinated universal time, a Piper J3C-65 airplane, Finnish registration OH-PAD, was destroyed when it collided with the trees and terrain near Laukaa, Finland. The pilot was fatally injured. The airplane departed a private…