NTSB investigations, 2014
26 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 | 48 |
| 2022 | 60 |
| 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\") = 2014
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") = 2014 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 ERA15CA081Accident · No injuriesData collectionFinal reportBell 430 · Miami Gardens, FLThe pilot's misjudgment of his helicopter's position relative to a parked helicopter during a pedal turn.NTSB ERA15WA070Accident · 10 fatalForeign investigationPiper PA-31-350 · Mariquita, ColombiaNTSB CEN15LA057Accident · No injuriesLimited investigationFinal reportEmbraer EMB-500 · Sugarland, TXThe pilot's engagement of the emergency parking brake during the landing roll, which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the pilot's decision to engage the emergency parking…NTSB WPR15CA044Accident · Serious injuriesData collectionFinal reportUltramagic N-250 · Wittman, AZThe pilot's failure to maintain control of the balloon when the wind unexpectedly increased which resulted in a collision with trees during the landing.NTSB ERA15LA022Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Warren, VTThe glider pilot’s failure to avoid the tow plane after the aborted takeoff due to both pilots’ failure to review the aborted takeoff procedure before the flight, which led to both pilots turning right after the aborted takeoff.NTSB ERA14CA407Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Taylorsville, KYThe pilot's decision to land on a wet runway and delayed go-around attempt, which resulted in a collision with terrain.NTSB ERA14CA413Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Hayesville, NCThe pilot's failure to maintain control of the helicopter, and adequate clearance, which resulted in a collision with a hangar.NTSB ERA14CA379Accident · No injuriesData collectionFinal reportAviat Pitts S2B · Lakeville, NYThe pilot's decision to favor the right side of the relatively narrow turf runway while landing, resulting in inadvertent contact with tall grass and a berm.NTSB ERA14CA365Accident · No injuriesData collectionFinal reportCessna 182B · Clayton, GAThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a tree and then obstacles during the subsequent aborted takeoff.NTSB CEN14LA346Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Ansley, NEThe powered parachute's reduced takeoff performance in tailwind conditions for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any preimpact anomalies that would have precluded normal…NTSB WPR14CA321Accident · Minor injuriesData collectionFinal reportCentrair 101A · Nephi, UTThe pilot's failure to identify the proper landing surface which resulted in an off airstrip landing and collision with rough terrain.NTSB WPR14CA279Accident · Serious injuriesData collectionFinal reportWiley Kitfox IV · Sprague, WAThe pilot's failure to maintain adequate clearance from powerlines during the landing approach resulting in a collision.NTSB CEN14LA299Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT 502 · Dell, ARThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight in high-density altitude and gusting crosswind conditions.NTSB WPR14CA223Accident · No injuriesData collectionFinal reportPiper J3C 65 · Bellingham, WAThe pilot's failure to maintain directional control during the landing on a narrow airstrip, which resulted in a collision with trees.NTSB CEN14CA258Accident · No injuriesData collectionFinal reportAir Tractor AT 802A · Hunter, ARThe pilot's downwind takeoff from a grass airstrip, which resulted in inadequate climb performance and the subsequent impact with terrain.NTSB WPR14WA191Accident · 1 fatalForeign investigationMaule M-5-235C · Lismore Aerodrome, Australia, AustraliaOn April 12, 2014, at 1230 universal coordinated time, a Maule M-5-235C, VH-HOG, struck a power line and subsequently impacted terrain near Lismore Aerodrome, Australia. The airplane was operated by the pilot under the pertinent civil regulation of the…NTSB CEN14WA169Accident · 2 fatalForeign investigationFritz Neumeyer Glasair II FT / 1865 · Turnau, AustriaOn 22 March 2014, approximately 1126 coordinated universal time, a Glasair II FT, airplane, registration D-EJFN crashed shortly after takeoff from the Lanzen-Turnau Airport, Turnau, Austria. The pilot and passage were fatally injured. The incident is being…NTSB CEN14CA166Accident · No injuriesData collectionFinal reportSkykits Savannah VGW · Hudson, COThe pilot's inadequate monitoring of his glide path resulting in a collision with a berm prior to landing.NTSB CEN14WA171Accident · 4 fatalForeign investigationAgustawestland Agusta AW139 · Gillingham, Norfolk, United KingdomOn March 13, 2014, about 1927 coordinated universal time, an Agusta/Westland model AW139 helicopter, United Kingdom registration G-LBAL, impacted terrain shortly after takeoff near Gillingham, Norfolk, United Kingdom. The four occupants were fatally injured.…NTSB WPR14CA129Accident · No injuriesData collectionFinal reportPartenavia P 68 Observer · Molokai, HIThe pilot's inadequate decision to continue an unstable approach in dark night conditions, which resulted in a collision with trees and hard landing.NTSB ERA14CA172Accident · No injuriesData collectionFinal reportPiper PA 28-140 · Saluda, SCAn inadvertent encounter with a deer during the takeoff roll.NTSB CEN14FA141Accident · 3 fatalField investigationFinal reportBeech 35/33 · Telluride, COThe airplane’s failure to obtain a positive climb rate, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s inadequate preflight planning.NTSB ERA14FA115Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 II · Panacea, FLThe pilot’s failure to maintain adequate clearance from trees during a takeoff at night. Contributing to the accident was the pilot’s lack of recent night flight experience.NTSB CEN14CA132Accident · No injuriesData collectionFinal reportTaylorcraft BC12 D · Hartford, WIThe pilot's inadequate preflight planning and failure to inspect the runway before departure.NTSB WPR14LA114Accident · No injuriesLimited investigationFinal reportPitts S2C · Roseburg, ORThe pilot’s loss of orientation while scanning for airport traffic during the turn from the base to final legs of the traffic pattern, which resulted in his failure to maintain clearance from a tree.NTSB CEN14CA114Accident · No injuriesData collectionFinal reportCessna 340 · Coldwater, MIAirport personnel did not remove the snow banks from the intersecting runway and/or close the intersection runway, which resulted in the airplane impacting the snow banks. Contributing to the accident was the reduced visibility inhibiting the pilot's ability…