Skip to content

NTSB investigations, 2023

33 cases where the sequence of events included Ground collision.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 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

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 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 year(c."eventDate") = 2023
  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 CEN24LA059Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lubbock, TXThe pilot’s failure to maintain directional control during the landing that resulted in a runway excursion, an impact with a runway sign, and a nose gear collapse.Dec 10, 2023 · N8538N · Substantial damage 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…Nov 30, 2023 · N494HA · Minor damage 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.Nov 8, 2023 · N9568U · Substantial damage 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.Oct 21, 2023 · N7607T · Substantial damage 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…Oct 19, 2023 · N30913 · Minor damage 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.Oct 12, 2023 · N682JS · Substantial damage NTSB DCA24WA008IncidentClass 5 · ForeignBoeing 737 · Casablanca, MoroccoOct 8, 2023 · CN-ROU · Minor damage NTSB DCA24WA004OccurrenceClass 5 · ForeignBoeing 737 · London, United KingdomOct 4, 2023 · EI-EGD NTSB ERA23LA386Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Greensboro, GAThe pilot’s failure to maintain clearance from a light pole during taxi.Sep 30, 2023 · N9522L · Substantial damage NTSB GAA23WA267AccidentClass 5 · ForeignBell 407 · Madang Province, Papua New GuineaSep 22, 2023 · P2-HSN · Destroyed NTSB 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.Sep 20, 2023 · N820PP · Substantial damage NTSB DCA23WA461Incident · No injuriesClass 5 · ForeignEmbraer S A ERJ 190-200 IGW · Nairobi, KenyaSep 17, 2023 · N255GE · Minor damage NTSB DCA23WA431AccidentClass 5 · ForeignAirbus A330-941 · Paris, FranceAug 30, 2023 · N411DX · 2 aircraft · Minor damage NTSB CEN23LA383Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12A · Mosby, MOThe pilot’s failure to maintain adequate rotor rpm which resulted in a loss of control and impact with terrain.Aug 27, 2023 · N8178H · Substantial damage NTSB GAA23WA266Accident · No injuriesClass 5 · ForeignBeecraft G58 · Oita airoprt, JapanAug 14, 2023 · JA51HA · Substantial damage NTSB 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.Aug 1, 2023 · N46393 · 2 aircraft · Minor damage 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.Aug 1, 2023 · N907AX · Substantial damage NTSB DCA23WA363AccidentClass 5 · ForeignBoeing 747 · Tel Aviv, IsraelJul 16, 2023 · OE-LRG · 2 aircraft · Minor damage NTSB 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.Jun 8, 2023 · N340SW · Substantial damage NTSB WPR23LA203Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · West Jordan, UTLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl.May 29, 2023 · N456Y · Substantial damage NTSB CEN23LA209Accident · No injuriesClass 4 · LimitedFinal reportKolb Firestar SS · Lodi, WIThe pilot’s failure to maintain control during takeoff.May 29, 2023 · N994TA · Substantial damage 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.May 29, 2023 · N7712H · Substantial damage NTSB DCA23WA282IncidentClass 5 · ForeignBoeing 737 · Munster/Osnabruck, GermanyApr 29, 2023 · TC-SOH · 2 aircraft · Minor damage NTSB DCA23WA241IncidentClass 5 · ForeignBoeing 757-232 · Mexico City, MexicoApr 17, 2023 · N694DL · Minor damage NTSB WPR23LA155Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · North Las Vegas, NVThe pilot's failure to maintain directional control of the airplane during the landing roll resulting in collision with taxiway sign.Apr 15, 2023 · N734NJ · Substantial damage NTSB WPR23LA152Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-44A · Los Alamos, NMThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion and ground collision.Apr 5, 2023 · N444M · Substantial damage NTSB 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.Mar 21, 2023 · N7772B · Substantial damage 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.Mar 9, 2023 · N46CV · Substantial damage NTSB WPR23LA123Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, ORThe student pilot’s failure to see and avoid another airplane during taxi.Mar 7, 2023 · N25233 · 2 aircraft · Substantial damage NTSB ANC23LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Chugiak, AKThe pilot’s failure to maintain directional control during takeoff in flat light conditions which resulted in a loss of control and impact with a snow berm.Feb 14, 2023 · N9572G · Substantial damage NTSB DCA23WA138Incident · No injuriesClass 5 · ForeignBoeing 737 · Merauke-Papua Island, IndonesiaJan 26, 2023 · PK-LFO · Minor damage NTSB DCA23WA137Accident · No injuriesClass 5 · ForeignBoeing 767 · Narita, JapanJan 25, 2023 · JA603A · Substantial damage NTSB 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.Jan 2, 2023 · N928XJ · 2 aircraft · Substantial damage