NTSB investigations
620 cases where the sequence of events included 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 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."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 DCA12CA021Accident · No injuriesData collectionFinal reportBoeing 757-351 · Atlanta, GAthe failure of the captain of N303DQ to maintain a safe clearance from N583NW that was stopped on the taxiway.NTSB CEN12CA084Accident · No injuriesData collectionFinal reportCessna 550 · Moline, ILThe pilot's failure to maintain clearance from the parked, unoccupied airplane while taxiing. Contributing to the accident was the guidance provided by the marshaller.NTSB ERA12LA066Accident · No injuriesLimited investigationFinal reportCessna 172S · Fort Lauderdale, FLThe Cessna 172 flight instructor and student pilot's inadequate visual lookout and failure to maintain clearance from the stationary Cessna 182.NTSB ERA12LA048Accident · No injuriesLimited investigationFinal reportBeech C23 · Columbia, MSThe partial loss of engine power for undetermined reasons during takeoff.NTSB ERA12CA025Accident · No injuriesData collectionFinal reportCessna 177RG · Westerly, RIThe pilot's failure to maintain airplane control while starting the engine.NTSB WPR11LA477Accident · No injuriesLimited investigationFinal reportStarduster II SA-300 · West Jordan, UTThe pilot of the other airplane's inadequate visual lookout, which resulted in a collision with the standing airplane.NTSB CEN11CA664Accident · No injuriesData collectionFinal reportBoeing E75 · Houston, TXThe pilot of the other airplane’s failure to maintain visual contact while taxiing.NTSB WPR11CA456Accident · No injuriesData collectionFinal reportCub Crafters CC11-100 · San Jose, CAThe pilot's failure to maintain directional control while taxiing due to his distraction by a cockpit warning light.NTSB ANC11CA097Accident · No injuriesData collectionFinal reportPiper PA-12 · Anchorage, AKThe pilot's misidentification of the runway environment in dusk light conditions.NTSB DCA11CA084Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Boston, MAthe B767 Captain's failure to maintain a safe clearance between his wing and the tail of the CRJ900 that was stopped on a taxiway.NTSB ERA11CA387Accident · No injuriesData collectionFinal reportCessna 150C · Weirsdale, FLThe pilot's failure to maintain adequate clearance from the stopped trailer while taxiing.NTSB WPR11CA294Accident · No injuriesData collectionFinal reportCessna 172N · Olympia, WAThe pilot's failure to maintain clearance from obstacles.NTSB ERA11LA361Accident · No injuriesLimited investigationFinal reportBeech A60 · Pompano Beach, FLThe pilots of both airplanes did not maintain adequate visual lookout during taxi, which resulted in an on-ground collision.NTSB ERA11CA371Accident · No injuriesData collectionFinal reportCessna 172M · North Adams, MAThe pilot's inadequate visual lookout and subsequent failure to maintain clearance from a light pole while taxiing.NTSB CEN11CA400Accident · No injuriesData collectionFinal reportWaco Classic YMF-F5C · Charleston, ILThe pilot's selection of unsuitable terrain to take off after making a precautionary landing.NTSB ERA11CA341Accident · Minor injuriesData collectionFinal reportCessna 182K · Bentonia, MSThe pilot’s loss of control on the ground during engine start, which resulted in a collision with nearby equipment. Contributing to the accident was the pilot’s improper engine start procedure and improper securing of the seat.NTSB WPR11CA252Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Odessa, WAThe pilot's failure to maintain clearance from the other aircraft.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 ERA11CA311Accident · No injuriesData collectionFinal reportSouthern Airmotive SAC · Taccoa, GAThe pilot's inadequate compensation for crosswind conditions during landing, resulting in a runway excursion and collision with a hangar.NTSB CEN11CA343Accident · No injuriesData collectionFinal reportMooney M20J · Greenfield, INThe pilot's failure to maintain adequate clearance from a communications cart while taxiing.NTSB ERA11CA296Accident · No injuriesData collectionFinal reportBoeing 737-732 · Atlanta, GAThe B737-700 pilot did not maintain adequate wing tip clearance while taxiing around the stopped B-737-800.NTSB CEN11CA309Accident · No injuriesData collectionFinal reportCessna 208B · El Paso, TXThe pilot's loss of control as result of the gusting wind.NTSB ERA11CA261Accident · No injuriesData collectionFinal reportPiper J3C-65 · Westfield, MAThe pilot's sole reliance on the passenger for securing the airplane during the engine start and the passenger's inability to maintain braking after the engine started.NTSB DCA11WA048Incident · No injuriesForeign investigationBoeing 767 323 · Barcelona, SpainOn 14 April 2011, at about 08:30 local, a Ryanair Boeing 737-800 and an American Airlines Boeing 767-300 collided while taxiing to runway 25L for takeoff at Barcelona Airport, Barcelona, Spain. The collision was not noticed by either flight crew until after…NTSB DCA11LA045Accident · No injuriesLimited investigationFinal reportAirbus A380 · Jamaica, NYthe A380 flight crew's inability to identify that the wingtip path of their airplane would not maintain safe clearance from the CRJ701. Contributing to the accident was the failure of the CRJ701 flight crew to advise ATC that they were stopped with a portion…NTSB WPR11CA171Accident · No injuriesData collectionFinal reportRemos GX · Arlington, WAThe LSA pilots' failure to stop and to ensure that the taxiway was clear of conflicting traffic before entering.NTSB WPR11FA158Accident · No injuriesField investigationFinal reportCessna 208B · Bakersfield, CAThe malfunction of a master brake cylinder, which resulted in a loss of braking action and subsequent loss of directional control and collision with three vehicles during taxi. Contributing to the accident was the inappropriate design and manufacture of the…NTSB ERA11LA167Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Auburn, ALA loss of engine power due to an internal failure of the muffler that was not detected by maintenance personnel.NTSB CEN11IA198Incident · No injuriesIncident investigationFinal reportBoeing 737-823 · Southlake, TXThe tractor driver’s failure to confirm that the tow bar head/handle was secured correctly to the airplane.NTSB CEN11LA168Accident · No injuriesLimited investigationFinal reportErtz Mark G Zodiac 601XL · Burlington, IAThe Model 1 pilot's inadequate visual lookout and subsequent failure to see and avoid the Zodiac.NTSB ERA11CA108Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Thomaston, GAThe mechanic's failure to install a cotter retaining pin in the throttle arm retaining nut resulting in excessive throttle play and loss of engine power control.NTSB WPR11CA085Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Wickenburg, AZThe student pilot's failure to maintain clearance between the airplane's right wing and the pole.NTSB ERA11LA100Accident · No injuriesLimited investigationFinal reportCessna 172 · St. ThomasThe pilot's failure to maintain an adequate visual lookout while taxiing.NTSB WPR11CA084Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Phoenix, AZThe student pilot's failure to maintain clearance from obstacles while taxiing.NTSB CEN11LA099Accident · No injuriesLimited investigationFinal reportBoeing 747-47UF · Chicago, ILThe Boeing 747 first officer’s failure to maintain clearance from another airplane while taxiing due to his inadequate judgment of the distance between the airplanes.NTSB CEN11CA187Accident · No injuriesData collectionFinal reportCessna 182M · Lubbock, TXThe pilot's inadequate visual lookout resulting in a collision with an airport sign.NTSB WPR11LA044Accident · No injuriesLimited investigationFinal reportPiper PA30 · Tucson, AZThe pilot's impairment by an undiagnosed medical condition, which resulted in a loss of directional control and subsequent collision with a building during the landing roll. Contributing to the accident was the pilot's decision to fly when he was not feeling…NTSB CEN11LA051Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe pickup truck driver’s failure to follow airport and company policies regarding ground vehicle operations, which allowed for the unattended truck to collide with the airplane. Contributing to the accident were the truck's misadjusted shift lever and…NTSB ERA11LA043Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hilton Head Island, SCThe Pitts pilot's inadequate visual lookout and failure to maintain clearance from the Cirrus airplane.NTSB ERA10CA491Accident · No injuriesData collectionFinal reportMooney M20J · Hazard, KYThe pilot's failure to maintain clearance from a fuel pump while taxiing. Contributing to the accident was the pilot’s diverted attention.NTSB ERA10CA479Accident · No injuriesData collectionFinal reportCessna 182S · Toms River, NJThe pilot's failure to maintain an adequate visual lookout during a night taxi. Contributing to the accident was the improper parking of a ground vehicle partially onto the taxiway.NTSB WPR10CA451Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Paradise Lakes Estates, CAThe pilot's failure to maintain clearance from a fence during taxi.NTSB CEN10CA540Accident · No injuriesData collectionFinal reportBeech E-90 · Colorado Springs, COThe pilot’s failure to ensure that the airplane’s parking brake was properly set before diverting his attention to other tasks.NTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.NTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.NTSB CEN10LA478Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Justin, TXA loss of engine power due to fuel starvation as a result of the pilot's delay in transferring fuel from the gravity feed wing tanks to the main tank.NTSB CEN10LA475Accident · No injuriesLimited investigationFinal reportAeronca 11CC · Silver City, NMThe pilot's loss of directional control during takeoff and the certificated flight instructor’s delayed remedial action, which resulted in a ground loop.NTSB ERA10CA413Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Lancaster, PAThe student pilot’s failure to maintain directional control of the airplane during takeoff.NTSB ERA10CA411Accident · No injuriesData collectionFinal reportPiper PA28 · Marshfield, MAThe pilot's failure to maintain clearance from a vehicle while taxiing. Contributing to the accident was his inadequate visual lookout.NTSB CEN10CA468Accident · No injuriesData collectionFinal reportPiper J3C-85 · Auburn, INThe pilot of the other airplane failing to monitor the position this airplane.