NTSB investigations, 2023
25 cases where the defining event was Ground collision.
Cases per year
| 2008 | 42 |
|---|---|
| 2009 | 30 |
| 2010 | 31 |
| 2011 | 25 |
| 2012 | 21 |
| 2013 | 21 |
| 2014 | 22 |
| 2015 | 28 |
| 2016 | 23 |
| 2017 | 23 |
| 2018 | 29 |
| 2019 | 23 |
| 2020 | 15 |
| 2021 | 21 |
| 2022 | 23 |
| 2023 | 25 |
| 2024 | 29 |
| 2025 | 41 |
| 2026 | 27 |
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\") = 2023
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '200')
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") = 2023 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '200') 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 DCA24LA034Incident · Minor injuriesClass 3 · LimitedFinal reportBoeing 717 · Kahului, HIThe captain did not verify that the tow tractor had exited the area in front of the airplane before taxiing for departure. Contributing factors were the dark conditions and the absence of an illuminated hazard beacon on the tow tractor, which reduced its…NTSB CEN24LA034Accident · No injuriesClass 4 · LimitedFinal reportGrumman American Avn. AA-5 · Fort Worth, TXThe distraction of the pilot during the taxi, resulting in a ground collision.NTSB ERA24LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Orangeburg, SCThe student pilot’s failure to maintain adequate clearance from a fuel truck while taxiing. Also contributing was the flight instructor’s inadequate monitoring of the student pilot.NTSB DCA24LA043Incident · No injuriesClass 4 · LimitedFinal reportBoeing 787 · Chicago, ILThe flight crew’s misperception of the distance required to safely pass the hangar and failure to request additional ground handling support while taxiing, which resulted in a collision with a hangar. Contributing to the accident was United Airlines…NTSB WPR24LA013Accident · No injuriesClass 3 · LimitedFinal reportCessna 340A · Boise, IDThe pilot’s failure to maintain directional control while taxiing, which resulted in impact with a fence.NTSB DCA24WA008IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoNTSB DCA24WA004OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomNTSB ERA23LA386Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, GAThe pilot’s failure to maintain clearance from a light pole during taxi.NTSB GAA23WA267AccidentClass 5 · ForeignBell 407 · Madang Province, Papua New GuineaNTSB DCA23WA461Incident · No injuriesClass 5 · ForeignEmbraer S A ERJ 190-200 IGW · Nairobi, KenyaNTSB DCA23WA431AccidentClass 5 · ForeignAirbus A330-941 · Paris, FranceNTSB GAA23WA266Accident · No injuriesClass 5 · ForeignBeecraft G58 · Oita airoprt, JapanNTSB WPR23LA298Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Long Beach, CAThe flight instructor’s inattention during ground operations, which resulted in unintentional movement of the airplane and ground collision with another airplane.NTSB ANC23LA058Accident · Minor injuriesClass 4 · LimitedFinal reportCort J Neuman Apex · Wasilla, AKThe pilot’s failure to maintain clearance during takeoff, which resulted in impact with trees.NTSB DCA23WA363AccidentClass 5 · ForeignBoeing 747 · Tel Aviv, IsraelNTSB WPR23LA221Accident · No injuriesClass 4 · LimitedFinal reportCessna 340A · Bend, ORThe pilot’s failure to maintain clearance from the fuel station, resulting in a ground collision and fire.NTSB ANC23LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · McGrath, AKThe pilot’s delayed decision to abort the takeoff, which resulted in a forced landing and impact with terrain.NTSB DCA23WA282IncidentClass 5 · ForeignBoeing 737 · Munster/Osnabruck, GermanyNTSB DCA23WA241IncidentClass 5 · ForeignBoeing 757-232 · Mexico City, MexicoNTSB ERA23LA171Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Cincinnati, OHThe pilot’s failure to maintain an adequate visual lookout during taxi, which resulted in a collision with a parked airplane. Contributing was the marshaller’s improper marshalling techniques.NTSB CEN23LA126Accident · No injuriesClass 4 · LimitedFinal reportBeech C90 · Bismark, NDThe ground vehicle driver’s failure to see and maintain clearance from the airplane while conducting ground operations.NTSB WPR23LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, ORThe student pilot’s failure to see and avoid another airplane during taxi.NTSB DCA23WA138Incident · No injuriesClass 5 · ForeignBoeing 737 · Merauke-Papua Island, IndonesiaNTSB DCA23WA137Accident · No injuriesClass 5 · ForeignBoeing 767 · Narita, JapanNTSB DCA23LA114Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · New York, NYITA Airways flight crew's incorrect evaluation of the clearance between their airplane and another airplane stopped on an adjoining taxiway.