Fatal, Final NTSB investigations
106 cases where the sequence of events included Collision during takeoff/land.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 6 |
| 2010 | 5 |
| 2011 | 2 |
| 2012 | 8 |
| 2013 | 2 |
| 2014 | 6 |
| 2015 | 6 |
| 2016 | 6 |
| 2018 | 5 |
| 2019 | 6 |
| 2020 | 11 |
| 2021 | 11 |
| 2022 | 10 |
| 2023 | 6 |
| 2024 | 4 |
| 2025 | 1 |
| 2026 | 1 |
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 c.\"highestInjuryLevel\" = 'Fatal'
AND c.\"completionStatus\" = 'Completed'
AND 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."highestInjuryLevel" = 'Fatal' AND c."completionStatus" = 'Completed' AND 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 ERA26LA207Accident · 1 fatalClass 4 · LimitedFinal reportI.C.A.-Brasov IS-28B2 · Scotts Fork, VAThe photographer’s failure to remain clear of an active taxiway.NTSB WPR25FA145Accident · 2 fatalClass 3 · FieldFinal reportChampion 7ECA · Cottonwood, CAThe flight instructor’s delayed response to an improper landing approach and runway overshoot, which resulted in an impact with an airport perimeter fence and trees.NTSB WPR24FA290Accident · 1 fatalClass 3 · FieldFinal reportAero Commander 200D · Novato, CAThe pilot’s failure to abort takeoff or compensate for gusty crosswind conditions during takeoff, which resulted in a loss of control and subsequent runway excursion.NTSB WPR24FA215Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Big Creek, IDThe pilot’s delayed decision to go around after descending below the recommended abort altitude with a slight tailwind and an over-gross-weight airplane, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s failure to…NTSB ANC24FA038Accident · 1 fatalClass 3 · FieldFinal reportSchweizer G-164B · Richvale, CAThe pilot’s failure to maintain clearance from a trailer located on the edge of the runway during takeoff. Contributing to the accident was the location of the trailer on the side of the runway.NTSB CEN24FA083Accident · 2 fatalClass 3 · FieldFinal reportJust Highlander · Dolores, COThe pilot’s collision with a fence while taking off from a snow-covered dirt airstrip.NTSB CEN24FA073Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Canton, TXThe pilot’s failure to attain the runway while landing at night, which resulted in an impact with trees.NTSB WPR24FA057Accident · 3 fatalClass 3 · FieldFinal reportCessna 172G · Independence, ORThe pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in collision with an obstacle while landing.NTSB WPR24FA018Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Covelo, CAThe pilot’s failure to maintain clearance from trees after entering a steep banked turn for unknown reasons. Contributing to the accident was the pilot’s decision to take off toward rising terrain.NTSB WPR24FA001Accident · 1 fatalClass 3 · FieldFinal reportCubcrafters CCK-1865 · Twisp, WAThe pilot’s failure to see and avoid a rock during an aborted landing on a hillside, the collision with which resulted in damage to the aileron system that precluded subsequent control of the airplane.NTSB ANC23FA042Accident · 2 fatalClass 3 · FieldFinal reportCessna 180 · Shaktoolik, AKThe pilot’s encounter with gusting tailwind conditions during takeoff, which resulted in impact with a tree, a loss of control, and subsequent impact with terrain.NTSB WPR23FA225Accident · 1 fatalClass 3 · FieldFinal reportCessna R182 · McCall, IDMaintenance personnel's failure to properly torque and inspect the magneto hardware, which resulted in a partial loss of engine power.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 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 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 ERA22FA386Accident · 1 fatalClass 3 · FieldFinal reportBeech B35 · French Lick, INThe pilot’s failure to make a stabilized approach, which resulted in a loss of directional control during landing.NTSB CEN22FA383Accident · 2 fatalClass 3 · FieldFinal reportMooney M20K · Hanna City, ILA total loss of engine power due to fuel exhaustion.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 CEN22FA215Accident · 1 fatalClass 3 · FieldFinal reportGrumman American Avn. G-164 · Whiskerville, ARThe pilot misjudged the approach during the emergency landing, likely due to the full chemical load, and impacted a ditch, resulting in substantial damage and postimpact fire. Contributing to the pilot’s injuries was the lack of a crash-resistant fuel system…NTSB ERA22FA227Accident · 1 fatalClass 3 · FieldFinal reportSchweizer SGS 2-33A · Blairstown, NJThe student pilot’s failure to maintain proper alignment with the landing area during the approach, which resulted in the left wing impacting a tree.NTSB WPR22FA151Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Heyburn, IDThe pilot’s failure to maintain altitude during an instrument approach, which resulted in a descent below the approach path and impact with a vent stack. Also causal was the failure of the processing plant to correctly paint the vent stacks, which had been…NTSB ERA21FA346Accident · 4 fatalClass 2 · FieldFinal reportCessna 560 · Farmington, CTThe pilot-in-command’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane-nose-down pitching moment that prevented the airplane from becoming airborne within the takeoff…NTSB WPR21FA272Accident · 4 fatalClass 3 · FieldFinal reportMooney M20J · Dinsmore, CAThe airplane’s degraded engine performance due to wear to the intake cam lobes, which diminished the airplane’s takeoff and climb performance, resulting in a subsequent collision with trees.NTSB ERA21LA283Accident · 1 fatalClass 3 · LimitedFinal reportBailey N Moyes Dragonfly · Charlestown, NHThe passenger’s decision to continue an unstable approach while at low altitude and in proximity to a known obstacle, which resulted in a collision with power lines.NTSB WPR21FA242Accident · 5 fatalClass 3 · FieldFinal reportCameron Balloons US O-120 · Albuquerque, NMThe failure of the pilot to maintain adequate clearance from power lines while maneuvering for landing. Contributing to the accident was the pilot’s use of impairing, illicit drugs.NTSB WPR21FA232Accident · 1 fatalClass 3 · FieldFinal reportKitfox Series 6 · Likely, CAThe pilot’s poor decision making in attempting a takeoff from a field with high vegetation and a high-density altitude, which resulted in decreased takeoff performance and impact with terrain.NTSB CEN21FA272Accident · 2 fatalClass 3 · FieldFinal reportAntenor Velazco Lancair Evolution · Parker, COThe pilot’s diversion of attention following an asymmetric flap deployment, which resulted in a descent and collision with powerlines. Contributing to the accident was maintenance personnel’s failure to properly secure the flap control rod attachment bolts,…NTSB CEN21FA263Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Madisonville, TXThe pilot’s failure to maintain a proper glidepath during final approach for landing, which resulted in impact with trees and terrain.NTSB ERA21LA201Accident · 1 fatalClass 3 · LimitedFinal reportBeech A36 · Lakeland, FLThe total loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA21FA194Accident · 3 fatalClass 3 · FieldFinal reportBeech C23 · Middleburg, FLThe pilot's decision to depart from a soft grass runway with a tailwind, which resulted in an increased takeoff distance and subsequent impact with trees during the initial climb.NTSB CEN21LA151Accident · 1 fatalClass 3 · LimitedFinal reportBeech 35 · Palestine, TXA total loss of engine power due to the flight crew incorrectly placing the fuel selector between fuel tank detents, which resulted in fuel starvation. Contributing to the accident was the lack of a placard on the fuel selector, the lack of obvious fuel tank…NTSB CEN21LA107Accident · 2 fatalClass 3 · LimitedFinal reportHawker Beechcraft G58 · Credit, ARA loss of left engine power for undetermined reasons, which resulted in an emergency descent with one engine inoperative and inadvertent collision with transmission lines. Contributing to the accident was the pilot’s inability to respond appropriately to the…NTSB CEN21LA055Accident · 2 fatalClass 3 · LimitedFinal reportCessna 182R · Rockwall, TXThe pilot’s decision to continue an unstabilized approach and his delayed go-around decision, which resulted in the airplane’s impact with power lines and the ground. Contributing to the accident was the inaccurate wind direction reporting as a result of a…NTSB WPR21FA044Accident · 1 fatalClass 3 · FieldFinal reportPiper PA38 · Grass Valley, CAA total loss of engine power due to the pilot’s improper fuel management, which resulted in fuel starvation.NTSB CEN20LA401Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA32 · Kokomo, INThe pilot’s inadequate visual lookout, which resulted in a collision with a utility pole and the subsequent collision with terrain.NTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined based on the available evidence.NTSB CEN20LA305Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · San Antonio, TXThe pilot’s improper decision to take off in an airplane over maximum gross weight and with a tailwind, which prevented the airplane from climbing.NTSB CEN20LA271Accident · 1 fatalClass 3 · LimitedFinal reportCessna T188 · Dustin, OKThe pilot’s continued takeoff without ensuring obstacles could be avoided due to his use of a sedating medication, which likely diminished his reaction time and flying performance.NTSB ERA20LA234Accident · 1 fatalClass 3 · LimitedFinal reportEvektor Aerotechnik Sportstar · Ocala, FLThe pilot’s impairment or distraction due to an acute stroke, which resulted in an unstabilized approach and subsequent loss of airplane control during landing.NTSB CEN20LA256Accident · 1 fatalClass 3 · LimitedFinal reportCessna 320 · Round Rock, TXImproper maintenance that led to a loss of engine power due to a failed left engine magneto, the pilot’s improper application of single engine emergency procedures, and his failure to maintain control of the airplane which resulted in a collision with trees.NTSB CEN20LA227Accident · 1 fatalClass 2 · LimitedFinal reportVans RV8 · Mandan, NDThe pilot's failure to remove the seat belt used as a flight control lock from the aft cockpit control stick before takeoff, which resulted in a loss of control during takeoff and collision with terrain.NTSB ERA20LA183Accident · 1 fatalClass 3 · LimitedFinal reportErcoupe 415 · Rogersville, TNThe pilot's failure to maintain a proper glidepath on approach, which resulted in an inflight collision with trees and terrain. Contributing to the accident was the pilot’s use of an impairing medication.NTSB WPR20LA128Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA31T · Billings, MTThe degraded airplane performance after takeoff for reasons that could not be determined from available evidence.NTSB WPR20FA008Accident · 2 fatalClass 3 · FieldFinal reportPiper PA 24 · Angel Fire, NMThe airplane’s degraded performance due to high-density altitude and gusting wind conditions, which resulted in its inability to maintain altitude during the initial takeoff climb. Contributing to the accident was the pilot’s lack of experience with high…NTSB CEN20FA008Accident · 2 fatalClass 3 · FieldFinal reportAeronca 7AC · Green Bay, WIThe pilot’s low final approach path and his failure to see and avoid a truck traveling on a roadway, which resulted in a collision with the truck.NTSB WPR19FA244Accident · 2 fatalClass 3 · FieldFinal reportCessna 172 · McKenzie Bridge, ORThe pilot's delayed climb and misjudgment of the airplane’s performance and the runway distance needed to clear obstacles at the end of the runway, which resulted in a collision with trees and subsequent impact with terrain. Contributing to the accident was…NTSB CEN19FA211Accident · 1 fatalClass 2 · FieldFinal reportGrob G103 · Brandon, MSThe pilot's inadequate clearance from a tree during an attempted off-field landing.NTSB ANC19FA026Accident · 3 fatalField investigationFinal reportHelio H 250 · Seward, AKThe pilot's failure to maintain clearance from trees during takeoff, which resulted in an in-flight collision, a loss of control, and impact with terrain.NTSB ANC19FA021Accident · 1 fatalClass 2 · FieldFinal reportBradshaw / McCauley Giles G-202 · Wasilla, AKThe pilot's failure to maintain control after the partial loss of engine power. Contributing to the accident was a contamination of the fuel system, which likely seized the electric fuel pump and restricted fuel flow to the engine.