NTSB investigations
832 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 CEN12CA301Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · El Campo, TXThe pilot's decision to rotate early, the airplane’s subsequent inability to climb, and the pilot’s delayed decision to abort the takeoff.NTSB CEN12CA279Accident · No injuriesData collectionFinal reportBalloon Works Firefly 7-15 · Hallsville, MOThe pilot’s failure to maintain clearance from power lines during landing.NTSB CEN12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Three Rivers, MICollision with a deer during the takeoff roll.NTSB CEN12WA268Accident · Minor injuriesForeign investigationRobinson · Wuppertal-Langerfeld, GermanyOn April 28, 2012, at 1650 coordinated universal time, a Robinson R44 helicopter, D-HARV, impacted terrain near Wuppertal-Langerfeld, Germany. The pilot and 3 passengers sustained minor injuries. Visual meteorological conditions prevailed for the flight. The…NTSB WPR12CA179Accident · Minor injuriesData collectionFinal reportCessna 182J · Delle, UTThe pilot’s failure to properly monitor the environment during the departure from a gravel parking area and runway, which resulted in the airplane’s collision with a mound of gravel.NTSB CEN12LA229Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · San Marcos, TXThe pilot's failure to ensure that he was aware of the NOTAM describing the runway closure, which resulted in a landing on the closed runway and subsequent collision with a barrier. Contributing to the accident was the failure of air traffic control personnel…NTSB ERA12LA250Accident · Serious injuriesLimited investigationFinal reportPiper PA46 · Wellington, FLThe pilot's failure to maintain directional control of the airplane during the takeoff roll, which resulted in a collision with a tree.NTSB ERA12WA243Accident · 1 fatalForeign investigationBell 407 · Podnovye, RussiaOn March 22, 2012, about 0615 coordinated universal time, a Bell 407, Russian registration RA-01931, was substantially damaged when it impacted electrical utility wires and the Volga River while on approach to a private landing area near Podnovye, Russia. The…NTSB WPR12LA138Accident · Minor injuriesLimited investigationFinal reportRaven Industries S-66A · Avra Valley, AZThe pilot's improper decision to partially open the balloon's vent before clearing a power line while landing, which resulted in the balloon descending too soon and contacting the power line.NTSB ANC12CA027Accident · No injuriesData collectionFinal reportCessna U206G · Naknek, AKThe pilot's decision to take off from an unsuitable off-airport site.NTSB WPR12CA117Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Randle, WAThe pilot exceeded the helicopter's performance, resulting in low rotor rpm and settling.NTSB ERA12CA204Accident · Serious injuriesData collectionFinal reportAmerican Champion 7GCAA · Bedminster, NJThe pilot receiving instruction’s inadvertent movement of the pitch trim control to the nose-down position while attempting a go-around.NTSB ERA12WA238Accident · 4 fatalForeign investigationBeech 95B55 · Cameta, BrazilOn February 16, 2012, about 1230 universal coordinated time, a Beech 95-B55, Brazilian registration PT-LOU, was destroyed when it impacted trees and terrain shortly after takeoff in Cameta Municipality, State of Mato Para, Brazil. The foreign certificated…NTSB CEN12TA122Accident · No injuriesFinal reportCessna 172P · Conroe, TXFailure of the rear crankshaft gear dowel pin due to improper installation, which resulted in a total loss of engine power.NTSB ERA12CA160Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Raleigh, NCThe pilot's loss of directional control while landing in gusting wind conditions.NTSB CEN12CA085Accident · Minor injuriesData collectionFinal reportGrumman American AA-5A · Bulverde, TXThe pilot's improper glidepath while on final approach.NTSB CEN12WA223Accident · 1 fatalForeign investigationPiper PA-31 · Cottens, SwitzerlandThe accident investigation is under the jurisdiction and control of the Swiss government. This report is for informational purposes only and contains only information released by or obtained from the Swiss government or the Swiss Accident Investigation Board.…NTSB ERA12LA100Accident · No injuriesLimited investigationFinal reportSigmon Harvey E Vans RV 6 · Abingdon, VAThe failure of the Pitts pilot to see and avoid the RV-6 that had landed ahead. Contributing to the accident was the Pitts pilot's inability to hear the RV-6 pilot's radio calls due to the lack of a radio in the Pitts.NTSB ANC12CA005Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Portage, AKThe pilot's selection of unsuitable terrain for landing.NTSB ERA12CA035Accident · Serious injuriesData collectionFinal reportAmerican Champion 7AC · Berkley, MAThe pilot did not maintain clearance from a tree during the final approach in solar glare conditions.NTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.NTSB ERA12CA022Accident · No injuriesData collectionFinal reportAeronca 0-58A · Westmoreland, TNThe pilot's inadequate visual lookout and failure to maintain clearance from an obstacle during takeoff.NTSB ANC11CA106Accident · No injuriesData collectionFinal reportPiper PA-12 · Beluga, AKThe pilot's decision to take off uphill into rising terrain.NTSB ERA11CA497Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Okeechobee, FLThe student pilot's failure to maintain the proper glidepath during a power-off landing and the flight instructor's delayed remedial action.NTSB ANC11CA105Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff.NTSB WPR11LA400Accident · No injuriesLimited investigationFinal reportCessna 182Q · Alton, UTThe pilot’s failure to abort the takeoff in a timely manner, which resulted in insufficient altitude to clear obstructions.NTSB CEN11WA587Accident · 2 fatalForeign investigationGardan GY80-160 · Mauterndorf, AustriaUnder the jurisdiction and control of the Austrian Government.NTSB WPR11WA393Accident · 3 fatalForeign investigationAerospatiale AS355 · Marree, Australia, AustraliaOn August 18, 2011, at 1008 universal coordinated time, an Aerospatiale AS 355F2, VH-NTV, operated by Australian Broadcasting Corporation, collided with terrain shortly after takeoff near Marree, Australia. The helicopter was substantially damaged and…NTSB ERA11LA454Accident · Serious injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 40 · Hodgenville, KYThe pilot's inadequate takeoff performance planning, which resulted in collision with an obstacle during takeoff from a turf runway that was not long enough for the given conditions.NTSB WPR11LA379Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Los Banos, CAThe pilot’s inadequate preflight, and contamination of both the engine compressor section and the main rotor blades, which resulted in reduced performance of the engine and rotor system.NTSB ERA11LA451Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Arcadia, FLThe pilot’s decision to take off in high density altitude conditions with the airplane over its maximum gross weight, due to the pilot’s improper weight and balance calculations, which resulted in the airplane’s inability to climb or maintain altitude.NTSB CEN11CA608Accident · Minor injuriesData collectionFinal reportAyres S2R-G10 · Hot Springs, ARThe pilot's improper decision not to fully jettison the entire load of water when he realized the airplane was not climbing after takeoff.NTSB WPR11CA394Accident · No injuriesData collectionFinal reportBell 47G · Porterville, CAThe pilot's decision to takeoff in a tailwind condition, and his subsequent failure to attain sufficient lift during the takeoff.NTSB CEN11CA501Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Bolivar, MOThe collision with a deer during landing at an airport with known wildlife activity.NTSB ERA11LA379Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Egremont, MAA partial loss of engine power due to the No. 4 intake and exhaust valves becoming lodged in the valve guides, which resulted from a lack of use, improper engine storage preparation, and improper return to service from indefinite storage.NTSB ERA11CA377Accident · Serious injuriesData collectionFinal reportCessna 150M · Ridgeway, VAThe pilot's decision to takeoff using a flap setting higher than the manufacturer's recommended setting for takeoff.NTSB CEN11LA451Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · New Carlisle, OHThe pilot's failure to conduct a go-around once he recognized he was going to land long on the runway.NTSB WPR11CA295Accident · No injuriesData collectionFinal reportCessna 172S · Price, UTThe pilot's decision to attempt a takeoff at a density altitude outside of the takeoff performance envelope of the aircraft along with using an aircraft flap setting higher than the manufacture's recommended setting for takeoff.NTSB ERA11CA353Accident · No injuriesData collectionFinal reportHead Balloons AX8-88 · Summerdale, ALThe balloon pilot's failure to maintain proper altitude/clearance from a tree line during the landing approach.NTSB CEN11CA389Accident · No injuriesData collectionFinal reportConner Leroy RV6A · Oakwood, OKThe pilot's improper decision to land on a road with obstacles.NTSB CEN11CA378Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Wagoner, OKThe airplane's collision with a deer during the landing flare and touchdown.NTSB CEN11CA377Accident · Minor injuriesData collectionFinal reportKamtz Russell H RV-6A · Dexter, NMThe pilot's failure to maintain clearance from a fence while landing at night.NTSB ERA11CA346Accident · No injuriesData collectionFinal reportCessna 177 · Boone, NCThe pilot's delay in executing a go-around.NTSB CEN11LA366Accident · No injuriesLimited investigationFinal reportCessna 150F · Sully, IAThe pilot's failure to attain an adequate climb rate during the initial takeoff, resulting in the airplane settling back down and departing the runway. Contributing to the accident was the pilot's inadequate preflight planning and preparation.NTSB WPR11CA224Accident · No injuriesData collectionFinal reportMaule M7 · Mammoth, AZThe pilot's failure to maintain clearance from a tree during the landing roll.NTSB ERA11LA300Accident · Serious injuriesLimited investigationFinal reportCarothers Zenith CH701 · Tidioute, PAThe pilot's impairment due to alcohol and failure to maintain altitude on approach to landing, resulting in an in-flight collision with a tree.NTSB CEN11LA317Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · New Columbia, ILThe pilot's failure to maintain adequate clearance from the wheat crop during takeoff.NTSB ERA11LA208Accident · 1 fatalLimited investigationFinal reportJennings John C Mini Max · Clinton, SCThe pilot's inadequate performance planning, which resulted in a collision with a tree during takeoff.NTSB CEN11CA232Accident · No injuriesData collectionFinal reportBell 230 · Gulf of Mexico, LAThe pilot's failure to maintain adequate clearance from the safety skirting during the repositioning landing.NTSB CEN11CA197Accident · No injuriesData collectionFinal reportPiper PA-32R-301 · Holdenville, OKThe pilot’s decision to land with a tailwind and his delay in executing a go around.