NTSB investigations, 2024
45 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 | 55 |
| 2024 | 45 |
| 2025 | 28 |
| 2026 | 36 |
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\") = 2024
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") = 2024 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 CEN25LA064Accident · Serious injuriesClass 4 · LimitedFinal reportCozy Cub · Parsons, KSThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB ERA25LA085Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 15AC · Loganville, GAThe pilot’s failure to maintain clearance of trees during an attempted go-around in sun glare.NTSB ANC25LA012Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Palmer, AKThe pilot’s improper airspeed management which resulted in a bounced landing and insufficient airspeed to perform a go around procedure.NTSB ERA25LA081Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Lakewood, NJThe pilot’s delay in performing a go-around, which resulted in a collision with trees at the end of the runway.NTSB DCA25WA046Accident · 1 fatalClass 3 · ForeignBoeing 737 · Vilnius, LithuaniaNTSB DCA25WA032IncidentClass 5 · ForeignBoeing 727 · Bogotá, ColombiaNTSB WPR25LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Priest River, IDThe pilot's failure to attain a proper touchdown point and his inability to stop the landing roll on a wet gras runway, which resulted in a collision with a tree.NTSB WPR25LA021Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Rexburg, IDThe pilot’s failure to see and avoid transmission wires during the landing approach.NTSB WPR25LA023Accident · No injuriesClass 4 · LimitedFinal reportCameron Balloons US A-275 · Wittmann, AZThe pilot’s failure to maintain clearance from a power line during an approach.NTSB WPR25LA019Accident · No injuriesClass 4 · LimitedFinal reportJared Baker Rans DSG INC S21 OUT · Springer, NMThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with an obstacle.NTSB WPR25LA081Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US ZL-70 · Rio Rancho, NMThe pilot’s inability to maintain clearance from a tree during the landing approach due to a gusting wind shift.NTSB ERA24LA384Accident · No injuriesClass 4 · LimitedFinal reportCessna 172L · DeLand, FLThe parachutist’s failure to control his canopy which resulted in a downwind landing, an overshoot of the drop zone, and collision with a departing airplane.NTSB ERA24LA382Accident · No injuriesClass 4 · LimitedFinal reportAerostar International RX-7 · Amsterdam, NYThe pilot’s failure to maintain adequate clearance from powerlines during final approach for landing.NTSB WPR24LA302Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe operator’s failure to maintain separation between two drones during dual simulated engine out recoveries, which resulted in a midair collision.NTSB WPR24LA293Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Amboy, CAThe pilot's failure to maintain clearance from a street sign during takeoff from a road.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 CEN24LA323Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Cut and Shoot, TXThe pilot’s failure to maintain directional control during a go-around that resulted in an impact with a fence.NTSB GAA24WA246Accident · 1 fatalClass 5 · ForeignZodiac CH601XL · Tambon Khok Kham, ThailandNTSB WPR24LA254Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-34-220T · Roy, UTThe flight instructor’s decision to shut down an engine on an extended leg of the airport traffic pattern, which led to a loss of performance and inability to maintain altitude.NTSB CEN24LA279Accident · Serious injuriesClass 4 · LimitedFinal reportEvolution Revolt · Rochelle, ILThe pilot’s failure to maintain terrain clearance during a low-level turn, that resulted in an impact with the ground.NTSB CEN24LA265Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Le Roy, MIThe pilot’s failure to maintain control of the airplane while performing a go-around, which resulted in an inflight collision with trees.NTSB WPR24LA244Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lakeport, CAA collision with a deer during takeoff.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 WPR24LA214Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pleasant Grove, CAThe pilot’s delayed recognition of the extent of the airplane’s increased takeoff roll. Contributing to the accident was the pilot’s lack of experience operating the airplane at a high gross weight.NTSB WPR24LA204Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MXT-7-180 · Winifred, MTThe pilot’s inadvertent excessive application of brakes, which resulted in a nose over.NTSB CEN24LA235Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Crete, NEThe airplane’s collision with a deer on the runway during a touch-and-go landing.NTSB GAA24WA184Accident · No injuriesClass 5 · ForeignCessna 172 · Kagoshima, JapanNTSB WPR24LA186Accident · No injuriesClass 4 · LimitedFinal reportGrumman/Schweizer G-164D · Richvale, CAThe pilot’s decision to take off with a tailwind and their failure to maintain clearance from terrain.NTSB ANC24LA046Accident · No injuriesClass 4 · LimitedFinal reportCessna 206 · Fairbanks, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.NTSB ANC24LA040Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Soldotna, AKThe pilot’s failure to recognize and avoid an obstacle on the runway environment during takeoff roll. Contributing was flat light conditions.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 GAA24WA203IncidentClass 5 · ForeignCessna 210 · Bankstown, AustraliaNTSB WPR24LA158Accident · Serious injuriesClass 3 · LimitedFinal reportEngineering & Research Ercoupe 415-C · Ontario, ORThe non-certificated pilot’s unstable approach to landing, which resulted in a collision with approach lighting, hard landing, and postimpact fire.NTSB CEN24LA183Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV9 · Linn Grove, IAThe pilot’s mismanagement of the airplane’s approach resulting in a collision with terrain.NTSB WPR24LA141Accident · No injuriesClass 3 · LimitedFinal reportCessna T206H · Halls Crossing, UTThe airplane’s collision with a tree during an aborted landing. Contributing to the accident was the airplane’s reported brake malfunction for undetermined reasons.NTSB CEN24LA177Accident · No injuriesClass 4 · LimitedFinal reportZenith CH-750 · Seymour, INThe flight instructor’s failure to maintain clearance from a fence during a takeoff attempt.NTSB ANC24LA101Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Big Lake, AKThe pilot’s failure to maintain clearance from an obstacle during takeoff.NTSB ANC24LA023Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Deer Park, WAThe pilot’s improper landing flare which resulted in the airplane contacting the ground short of the runway.NTSB CEN24LA139Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S53A · Rochester, MNThe pilot’s failure to maintain clearance from power lines while landing in a field.NTSB CEN24LA113Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · South Lyon, MIThe pilot’s failure to maintain clearance from trees during the landing approach.NTSB ERA24LA118Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Miami, FLTail rotor contact with an unseen object while performing a precautionary landing to a closed helipad at night.NTSB GAA24WA078AccidentClass 5 · ForeignPiper 28 · Spa, BelgiumNTSB DCA24WA080Incident · No injuriesClass 5 · ForeignPilatus PC-12/45 · Gustavia, St. BarthélemyNTSB GAA24WA069Accident · 2 fatalClass 5 · ForeignRobinson R22 · Cannes Mandelieu, FranceNTSB CEN24FA083Accident · 2 fatalClass 3 · FieldFinal reportJust Highlander · Dolores, COThe pilot’s collision with a fence while taking off from a snow-covered dirt airstrip.