Fatal NTSB investigations
17 cases where the sequence of events included Ground collision.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 5 |
| 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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '200' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '200' 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 ERA27FA004Accident · 1 fatalClass 3 · FieldInvestigation openHughes 269B · Lahmansville, WVNTSB GAA26WA033Accident · 1 fatalClass 5 · ForeignCirrus SR20 · Budawang, AustraliaNTSB WPR25FA214Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · West Yellowstone, MTOn July 17, 2025, about 2358 mountain daylight time, a Piper PA-28-180, N7186W, was substantially damaged when it was involved in an accident near West Yellowstone, Montana. The pilot and two pilot rated passengers were fatally injured. The airplane was…NTSB GAA25WA211Accident · 1 fatalClass 3 · ForeignBeech 35 · Khancoban, AustraliaNTSB GAA25WA207Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Porto Dos GaúChos, BrazilNTSB GAA25WA094Accident · 2 fatalClass 5 · ForeignBeecraft F90 · São Paulo city, BrazilNTSB CEN23LA413Incident · 1 fatalClass 3 · LimitedFinal reportPowrachute Airwolf · Erie, COThe pilot’s inadvertent manipulation of the throttle, which resulted in the aircraft traveling on the ground and the unsecured pilot being ejected from the aircraft and sustaining fatal injuries.NTSB GAA22WA075Accident · 1 fatalClass 5 · ForeignPiper PA-25-260 · Uchoa, BrazilNTSB WPR19FA241Accident · 1 fatalClass 3 · FieldFinal reportGlaser Dirks DG 300 Elan · Wilkeson, WAThe pilot’s delayed decision to land following a loss of thermal lift, which resulted in collision with trees during the landing approach.NTSB CEN18FA132Accident · 2 fatalField investigationFinal reportCessna 150 · Marion, INThe failure of both pilots to see and avoid the other airplane as they converged on intersecting runways. Contributing to the accident was the jet pilot's not monitoring the airport's traffic advisory frequency, known reduced visibility of the intersecting…NTSB CEN17WA102Accident · 4 fatalForeign investigationMD Helicopter 600 · Guatemala City, GuatemalaOn February 7, 2017, about 1253 local time, a United States-registered MD 600N helicopter, N245SE, impacted terrain at the La Aurora International Airport, Guatemala City, Guatemala. The pilot and three passengers were fatally injured. The investigation is…NTSB ERA16FA297Accident · 1 fatalField investigationFinal reportHeberlein Ronald Vans RV 9A · Sebring, FLThe pilot's failure to maintain clearance from terrain.NTSB WPR13FA208Accident · 1 fatalField investigationFinal reportBell 206B · Shepherd, MTThe pilot’s loss of control while maneuvering during low-altitude operations due to sudden neurological impairment or incapacitation and the helicopter’s subsequent collision with power lines.NTSB WPR13FA054Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Corona, CAThe pilot's failure to maintain clearance between the helicopter’s main rotor blades and the metal canopy of a fuel island.NTSB ERA11LA326Accident · 1 fatalLimited investigationFinal reportBuckeye Dream Machine · Russellville, TNThe pilot’s failure to switch fuel tanks when the fuel was exhausted, which resulted in fuel starvation and a total loss of engine power.NTSB ERA09LA152Accident · 2 fatalLimited investigationFinal reportPiper PA-18 -150 · Tallahassee, FLThe pilot's decision to initiate takeoff in close proximity to other vehicles which were operating on the runway resulting in collision with a vehicle during takeoff.NTSB MIA08FA070Accident · 3 fatalField investigationFinal reportUlrich Christen Velocity XL RG · Titusville, FLThe pilot of the Velocity’s failure to see and avoid the flight of four RV-8s that had landed and were in the process of clearing the runway.