NTSB investigations, 2012
38 cases where the defining event was Collision during takeoff/land.
Cases per year
| 2008 | 66 |
|---|---|
| 2009 | 67 |
| 2010 | 44 |
| 2011 | 41 |
| 2012 | 38 |
| 2013 | 27 |
| 2014 | 26 |
| 2015 | 32 |
| 2016 | 32 |
| 2017 | 38 |
| 2018 | 42 |
| 2019 | 50 |
| 2020 | 57 |
| 2021 | 47 |
| 2022 | 59 |
| 2023 | 53 |
| 2024 | 45 |
| 2025 | 28 |
| 2026 | 35 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 2012
AND 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 year(c."eventDate") = 2012 AND 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 CEN13CA114Accident · No injuriesData collectionFinal reportBell 407 · McAllen, TXThe pilot’s failure to maintain clearance with a parked helicopter during takeoff.NTSB CEN13CA031Accident · No injuriesData collectionFinal reportCessna 150 · Carrollton, OHThe airplane’s collision with two deer during the takeoff roll.NTSB CEN13CA022Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Loop, TXThe pilot’s inadequate performance calculations, which resulted in an overweight takeoff for the conditions and the subsequent hard impact with terrain.NTSB WPR13FA013Accident · 1 fatalField investigationFinal reportAeropro CZ A240 · Half Moon Bay, CAThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control.NTSB CEN13LA032Accident · Minor injuriesLimited investigationFinal reportAerostar International RX8 · Albuquerque, NMThe pilot’s failure to attain the desired touchdown point because of wind conditions and surrounding obstructions, which resulted in the balloon impacting a fence during the approach to landing.NTSB ERA12CA585Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Maryville, TNThe pilot’s failure to plan and execute a takeoff that assured obstacle clearance at the departure end of the runway, which resulted in a collision with trees.NTSB CEN12LA629Accident · No injuriesLimited investigationFinal reportVarga 2150A · Clinton, IAThe pilot of the other airplane failing to adequately monitor for other aircraft while landing.NTSB WPR12CA403Accident · Minor injuriesData collectionFinal reportAyres S2R-R1340 · Brawley, CAThe pilot's decision to attempt to takeoff in high temperatures with a tailwind. Contributing to the accident was the sun glare.NTSB CEN12LA584Accident · 1 fatalLimited investigationFinal reportTop Dog TD2 · Bemidji, MNThe pilot's failure to maintain aircraft control and his inadequate flare during landing. Contributing to the accident was the pilot’s failure to obtain training on the operation of the accident aircraft.NTSB WPR12FA369Accident · 5 fatalField investigationFinal reportPiper PA-32-301T · South Lake Tahoe, CAA partial loss of engine power for reasons that could not be determined because examinations revealed no evidence of mechanical anomalies with the airframe or engine that would have precluded normal operation and the pilots’ decision to continue the departure…NTSB CEN12LA569Accident · No injuriesLimited investigationFinal reportPiper PA28 · Leesburg, OHThe pilot's improper preflight planning and decision to attempt a takeoff from a runway that was too short for conditions, which resulted in the airplane settling into terrain.NTSB CEN12CA568Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Bogata, TXThe pilot’s inadequate preflight planning, which resulted in the airplane’s loading beyond its maximum gross weight.NTSB CEN12LA488Accident · 1 fatalLimited investigationFinal reportJoseph C. Andrews, Jr. Vans · Valentine, NEThe RV-6 pilot's failure to monitor the location of the RV-4, resulting in the on-ground collision. Contributing to the accident was the RV-6 pilot not ensuring proper separation from the RV-4 and his expectation that the pilot of RV-4 would roll out to the…NTSB CEN12LA459Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502B · Wisner, LAThe pilot’s inadequate takeoff planning that did not consider the reduced acceleration due to a rough, turf runway and his use of an improper flap setting, which resulted in a collision with terrain during takeoff.NTSB ANC12CA076Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Whittier, AKThe pilot's failure to maintain clearance from brush during landing, which resulted in a loss of control.NTSB CEN12LA443Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Red Oak, IAThe pilot's failure to maintain clearance from the ground-support vehicle during landing.NTSB CEN12LA428Accident · Serious injuriesLimited investigationFinal reportMchargue Buckeye Dream · Central City, NEThe pilot’s failure to maintain clearance with the powerlines during the initial takeoff climb.NTSB ANC12CA065Accident · No injuriesData collectionFinal reportPiper PA-22-160 · McGrath, AKThe pilot’s decision to load the airplane in excess of its takeoff capability given the runway conditions, which resulting in a collision with terrain during the initial climb.NTSB CEN12LA417Accident · Serious injuriesLimited investigationFinal reportBadeaux Challenger II · New Iberia, LAThe operation of an airplane by a noncertificated pilot and his failure to maintain clearance with the power lines during the landing approach.NTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.NTSB WPR12LA285Accident · No injuriesLimited investigationFinal reportSchweizer SGS233 · Truckee, CAThe pilot's failure to maintain control of the glider while taking off with a gusting wind, which resulted in the glider impacting a runway sign.NTSB WPR12CA254Accident · No injuriesData collectionFinal reportCessna 162 · Santa Ana, CAThe pilot’s failure to compensate for the gusting wind and failure to maintain airplane control during the approach to land.NTSB CEN12LA373Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Gardner, KSThe pilot's delay in aborting the takeoff when the airplane was not accelerating as expected. Contributing to the accident was a wind shift during takeoff.NTSB ERA12CA333Accident · Minor injuriesData collectionFinal reportLuttenbacher Kurt Bushby Mustang 2 · Kingstree, SCThe pilot’s failure to maintain airplane control during the approach to landing, which resulted in a collision with terrain short of the runway. Contributing to the accident was the pilot's lack of experience in the airplane.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.