NTSB investigations
498 cases where the defining event was Ground collision.
Cases, newest first
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.\"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 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 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.NTSB CEN23LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Brookshire, TXThe P51 pilot’s failure to see and avoid the PA46 during taxi operations.NTSB WPR23LA100Accident · No injuriesClass 4 · LimitedFinal reportAeronca 65-CA · Deming, NMThe occupant’s improper throttle movement during the start procedure, which resulted in forward movement and loss of airplane control.NTSB CEN23LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Denton, TXThe pilot’s failure to maintain clearance from another airplane while taxing in the run-up area.NTSB WPR23LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 441 · Liberal, KSThe pilot’s inadequate preflight inspection, failure to set the parking brake, and his decision to exit the airplane with engines running to remove a wheel chock, resulting in the airplane’s unintended movement and subsequent collision with a hangar.NTSB CEN23LA023Accident · Minor injuriesClass 4 · LimitedFinal reportStephen J Hoffman MS-500 · Houston, TXThe pilot’s failure to secure the magneto switch before attempting to hand rotate the engine which resulted in an inadvertent engine start, a runaway airplane, and subsequent impact with parked airplanes. Contributing to the accident was the failure to…NTSB CEN23LA015Accident · No injuriesClass 4 · LimitedFinal reportBeech B-60 · Ardmore, OKThe pilot did not ensure adequate clearance from construction vehicles during taxi.NTSB DCA22WA214Accident · No injuriesClass 5 · ForeignBoeing 777 · London, GabonNTSB GAA22WA305Accident · No injuriesClass 5 · ForeignCessna C172 · Yao, JapanNTSB DCA22LA201Accident · No injuriesClass 4 · LimitedFinal reportBoeing 737-7H4 · Chicago, ILSouthwest Airlines flight crew’s misjudgment of the distance required to safely pass the American Airlines airplane.NTSB DCA22WA206Incident · No injuriesClass 5 · ForeignBoeing 737 · Zurich, SwitzerlandNTSB WPR22LA325Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D1 · Hope, AKThe pilot’s failure to maintain clearance from a tree while taxiing.NTSB ERA22LA364Accident · Minor injuriesClass 4 · LimitedFinal reportAerotek Pitts Special S-1S · Erwinna, PAThe inability of both pilots to see and avoid the collision. Contributing to the accident was the pilot of the red airplane’s decision to utilize the converging runway for takeoff, contrary to the guidance published in the airport facility directory. Also…NTSB DCA22LA175Accident · No injuriesClass 4 · LimitedFinal reportBoeing 777 · Chicago, ILThe ground controller’s inappropriate routing of the B777 through a non-movement area, resulting in the airplane’s right wingtip contacting a light pole. Contributing to the accident was the lack of an appropriate display of taxiway BB2 as a restricted…NTSB CEN22LA346Accident · No injuriesClass 4 · LimitedFinal reportMeschler Gary R RV-4 · Oshkosh, WIThe failure of the pilot of N694V (RV-8) to maintain clearance from the preceding airplane, N79KM (RV-4), while taxiing for takeoff, which resulted in an on-ground collision.NTSB CEN22LA319Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-19B · Elbert, COThe pilot’s misidentification of the runway during the visual approach which resulted in an off runway landing and impact with a trailer.NTSB DCA22LA135AccidentClass 4 · LimitedFinal reportAirbus A330 · New York, NYThe ITA Airways flightcrew’s misperception of the distance to maintain separation and safely pass the stopped Air France airplane.NTSB WPR22LA201Accident · No injuriesClass 4 · LimitedFinal reportBombardier BD100 1A10 · Hawthorne, CAThe multi-engine pilot's failure to maintain clearance from another airplane during taxi.NTSB ERA22LA252Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-151 · Daytona Beach, FLPilot’s failure to maintain clearance from a forklift while taxiing.NTSB CEN22LA149Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Grapevine, TXThe failure of the pilot of the second aircraft to maintain a safe distance from the lead airplane while taxiing, which resulted in a ground collision.NTSB ERA22LA119Accident · No injuriesClass 4 · LimitedFinal reportGreat Lakes 2T-1A-2 · Naples, FLThe biplane pilot’s inadequate visual lookout, which resulted in an on-ground collision with another airplane while taxiing.NTSB DCA22WA222IncidentClass 4 · ForeignBoeing 737 · Ajuba, NigeriaNTSB GAA22WA075Accident · 1 fatalClass 5 · ForeignPiper PA-25-260 · Uchoa, BrazilNTSB ERA22LA103Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Knoxville, TNThe pilot of the Cessna 150’s failure to avoid the taxiing Cessna 172.NTSB DCA22LA053Accident · No injuriesClass 4 · LimitedFinal reportAirbus A330 · Newark, NJTurkish Airlines flightcrew’ s misperception of the distance to safely pass the stopped Republic Airways airplane.NTSB WPR22LA042Accident · No injuriesClass 4 · LimitedFinal reportPhoenix Air U-15 Phoenix · Carlsbad, CAThe pilot’s failure to maintain distance with an airport sign while taxiing.NTSB ERA22LA019Accident · No injuriesClass 3 · LimitedFinal reportBeech 200 · Mount Pleasant, SCThe pilot’s failure to maintain clearance with the parked fuel truck while taxiing for takeoff. Contributing to the outcome was the pilot’s decision to park the airplane in the congested ramp area and his excessive taxi speed.NTSB WPR22LA018Accident · No injuriesClass 4 · LimitedFinal reportAirbus A350 · Tucson, AZThe pilot's failure to maintain clearance from ground equipment during landing.NTSB DCA22LA005Accident · No injuriesClass 4 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Chicago, ILA ground collision by SkyWest flight 5845 that resulted in substantial damage to Republic Airlines flight 3594.NTSB CEN21LA456Accident · No injuriesClass 4 · LimitedFinal reportBell 407 · Patterson, LAThe pilot’s failure to maintain adequate clearance from a parked helicopter while hovering to reposition for takeoff.