NTSB investigations
499 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 GAA15CA043Accident · No injuriesData collectionFinal reportShort Bros SD 360-300 · Greer, SCThe fuel truck driver's inattention, which resulted in backing over a warning cone and into the horizontal stabilizer of the airplane.NTSB DCA15WA102Accident · No injuriesForeign investigationBoeing Boeing 737-8AS · Dublin, IrelandThe Air Accidents Investigation Unit f Ireland (AAIU-IE) has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on April 01, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU's investigation under…NTSB GAA15CA008Accident · No injuriesData collectionFinal reportCessna 170A · Palmetto, FLThe pilot's failure to use the proper hand propping procedures, resulting in a runaway airplane.NTSB ENG15WA016Incident · No injuriesForeign investigationFokker F28 - 0070 · Amsterdam, NetherlandsOn March 05, 2015, about 1215 LCL, a Fokker F28, PH-WXC, On March 5, 2015, a Fokker F28 experienced a braking failure while on the ramp and struck a ground power unit (GPU) at Schiphol Airport (EHAM), Amsterdam, the Netherlands.The incident is being…NTSB ERA15LA124Accident · No injuriesLimited investigationFinal reportDehavilland DHC 6 Twin Otter · Sebastian, FLThe pilot's failure to conduct all of the required items on the Before Starting Engines checklist, which resulted in her failure to detect an open hydraulic circuit breaker and led to insufficient hydraulic pressure to operate the airplane's brakes, her…NTSB ERA15CA113Accident · No injuriesData collectionFinal reportCessna 172I · Nashua, NHThe student pilot's lack of vigilance during taxi, which resulted in a collision with a parked truck. A factor in the accident was the truck operator's decision to park on the edge of an active taxiway.NTSB ERA15CA093Accident · No injuriesData collectionFinal reportPiper PA-46-350P · Apalachicola, FLThe pilot's inadequate visual lookout while taxiing, which resulted in the airplane striking a pole.NTSB DCA15WA043Accident · No injuriesForeign investigationBoeing 737-800 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an accident involving a Boeing 737-800 that occurred on December 17, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB DCA15CA025Accident · No injuriesData collectionFinal reportBoeing 737 7H4 · Dallas, TXN263WN captain's failure to maintain a safe clearance from the parked N8314L resulting in a ground collision.NTSB DCA15CA012Accident · No injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Minneapolis, MNthe B757 Captain's failure to maintain a safe clearance between his wing and the wingtip of the ERJ-170. Contributing to the accident was the positioning of the ERJ-170 by the Compass ground personnel.NTSB WPR15CA017Accident · No injuriesData collectionFinal reportIndus T-211 Thorpedo · Mountain Home, IDThe pilot's failure to maintain clearance with a parked truck while taxiing for takeoff.NTSB WPR15CA007Accident · No injuriesData collectionFinal reportCessna T182T · Van Nuys, CAThe pilot's failure to monitor the distance between the left wing and blast fence while maneuvering behind another airplane.NTSB DCA15FA004Accident · No injuriesField investigationFinal reportEmbraer EMB 145LR · Jamaica, NYThe A340 captain's failure to maintain adequate clearance between his wing and the tail of the EMB-145.NTSB WPR14CA387Accident · No injuriesData collectionFinal reportBeech E33A · Las Vegas, NVThe pilot's incorrect engine start procedures, which included improper throttle position and failure to keep the brakes applied, which resulted in a loss of directional control and subsequent collision with a parked airplane.NTSB DCA14CA170Accident · Minor injuriesData collectionFinal reportEmbraer EMB 145XR · Chicago, ILThe tractor driver's failure to give way to the taxiing airplane.NTSB CEN14LA430Accident · No injuriesLimited investigationFinal reportBombardier CL600 2D24 - 900 · San Antonio, TXFailure of the tow bar shear pin, which resulted in the tug operator’s loss of control of the airplane during pushback operations. Contributing to the accident was the tug operator’s inability to communicate to the flight crew to apply the airplane’s brakes.NTSB WPR14CA332Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Apple Valley, CAThe pilot's failure to adequately secure the airplane while hand-starting the engine.NTSB WPR14LA313Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVThe airplane flight crew’s failure to exercise the necessary vigilance and precautions and yield the right of way to the landing helicopter, which resulted in the airplane colliding with the helicopter. Contributing to the accident was the helicopter pilot’s…NTSB ERA14LA341Accident · No injuriesLimited investigationFinal reportLet L 23 Super Blanik · Warm Springs, GAThe failure of the flight instructor to move his glider from an active runway in accordance with procedures due to his distraction by having a conversation with the air boss, which resulted in the landing glider colliding with the glider on the runway.NTSB ERA14CA314Accident · No injuriesData collectionFinal reportCessna 172L · Danbury, CTThe pilot's use of a person unfamiliar with aviation and his failure to properly secure the airplane during hand starting of the engine.NTSB WPR14CA255Accident · No injuriesData collectionFinal reportCosmos Phase II Phase II 582 · Caldwell, IDThe pilot's failure to monitor the environment and to maintain sufficient altitude to clear power lines during low altitude flight.NTSB ANC14CA044Accident · No injuriesData collectionFinal reportCessna 208B · Egegik, AKThe pilot's loss of situational awareness during the takeoff roll resulting in a collision with a refrigeration trailer.NTSB WPR14LA199Accident · No injuriesLimited investigationFinal reportBeech H35 · Parker, AZThe improperly attached fuel line and cracked fuel diaphragm due to unknown personnel’s inadequate maintenance, which resulted in the loss of engine power during cruise flight and the subsequent forced landing onto rough terrain.NTSB WPR14LA198Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Medicine Lake, MTThe pilot’s failure to maintain airplane control and sufficient altitude to clear terrain during a low-altitude maneuver.NTSB ANC14CA036Accident · No injuriesData collectionFinal reportCessna 208B · Aniak, AKThe pilot's failure to maintain clearance from a forklift while taxiing.NTSB WPR14CA175Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Monterey, CAThe sport pilot's failure to maintain aircraft control during taxi as a result of improperly manipulating the engine power.NTSB ERA14CA176Accident · No injuriesData collectionFinal reportCessna 172B · Mt Olive, NCThe pilot's failure to adequately secure the airplane before hand-propping the engine for startup.NTSB DCA14WA082Accident · No injuriesForeign investigationAirbus A320 · Buenos Aires, ArgentinaNTSB WPR14LA099Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · San Jose, CAThe pilot’s failure to sump the fuel tanks, which resulted in water contamination, a partial loss of engine power during takeoff, and collision with a taxiing airplane during the subsequent forced landing.NTSB DCA14WA023Accident · No injuriesForeign investigationBoeing 747 · Johannesburg, South AfricaNTSB WPR14CA063Accident · No injuriesData collectionFinal reportBurkhart Grob G 103 Twin II · Bryon, CAThe pilot's failure to maintain adequate wing clearance from a runway sign while taxiing.NTSB DCA14WA010Incident · No injuriesForeign investigationBoeing 737 · Buenas Aires, ArgentinaThe Junta de Investigaciones de Accidentes de Aviacion Civil (JIAAC) of the Republic of Argentina has notified the NTSB of an accident involving a Boeing 757-700 and an Embraer E-190, which occurred on November 7, 2013. The NTSB has appointed a U.S.…NTSB WPR14LA025Accident · No injuriesLimited investigationFinal reportAviat S2 · Livermore, CAFailure of the pilots of the Pitts airplane to maneuver the airplane as necessary to observe the taxi route and avoid the Cessna airplane ahead. Contributing to the accident was the local controller's failure to provide the required warning of traffic ahead…NTSB CEN14CA041Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Benton Harbor, MIThe pilot's failure to maintain aircraft control during engine start.NTSB DCA13WA170Incident · No injuriesForeign investigationBoeing 737 · Dar Es Salaam, TanzaniaThe Tanzania Ministry of Transport (MoT) has notified the NTSB of an accident involving a Boing 737-800 airplane and a Boeing 767-300 airplane that occurred on September 01, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the MoT's…NTSB WPR13CA371Accident · No injuriesData collectionFinal reportCessna 172H · Metaline Falls, WAThe pilot's failure to maintain clearance from a windsock pole while taxiing.NTSB CEN13CA452Accident · No injuriesData collectionFinal reportCessna 172N · Tell City, INThe pilot's failure to maintain adequate clearance from an obstruction while taxiing.NTSB WPR13LA331Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-C1 · Mesa, AZThe student pilot’s failure to monitor and maintain clearance while taxiing, which resulted in collision with the parked airplane. Contributing to the accident was the parked airplane’s insufficient distance from the taxiway centerline.NTSB WPR13LA286Accident · No injuriesLimited investigationFinal reportCessna 182T · San Diego, CABoth pilots’ failure to maintain a proper visual lookout while taxiing during nighttime conditions, which resulted in an on-ground collision.NTSB ERA13LA311Accident · No injuriesLimited investigationFinal reportCessna 172M · Burlington, VTThe pilot's improper turn down an airport access road while attempting to taxi to a runway. Contributing to the accident was the airport management's failure to install proper signage indicating that an airport access road was prohibited to aircraft.NTSB ERA13LA299Accident · No injuriesLimited investigationFinal reportAerotek Pitts S-2B · Cleveland, GAThe taxiing pilot's inadequate visual lookout, which resulted in his airplane's collision with a stopped airplane.NTSB DCA13CA106Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD-88 · Nashville, TNThe flight crews failure to maintain clearance from the light pole while taxiing.NTSB WPR13IA226Incident · No injuriesIncident investigationFinal reportBoeing 737-7H4 · Phoenix, AZThe failure of the tug operator and wing walker to adequately monitor the environment during pushback of the airplane from the gate in preparation for flight, which led to the collision of the airplane with an adjacently parked airplane.NTSB DCA13FA082Accident · No injuriesField investigationFinal reportEmbraer EMB-145LR · Newark, NJthe failure of flight 908's captain to ensure adequate clearance between the wingtip of his airplane and flight 4226's empennage when he attempted to pass behind the other airplane.NTSB DCA13WA080Incident · No injuriesForeign investigationBoeing 747-400 · Melbourne, AustraliaThe Australian Transport Safety Bureau (ATSB), has notified the NTSB of an accident involving a Boeing 747-400 that occurred on April 22, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the provisions of…NTSB WPR13CA158Accident · No injuriesData collectionFinal reportCessna 172 · Gila Bend, AZThe student pilot’s failure to maintain clearance from an above-ground fuel tank while taxiing.NTSB ERA13CA155Accident · No injuriesData collectionFinal reportEngineering & Research Ercoupe 415-C · Newnan, GAThe pilot's failure to maintain proper visual lookout during taxi operations, which resulted in a collision with a parked airplane.NTSB WPR13CA139Accident · No injuriesData collectionFinal reportCessna 172F · Nampa, IDThe failure of the pilot of another airplane, who was taxiing with no intent for flight, to maintain proper visual lookout.NTSB ERA13CA123Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Lancaster, PAThe pilot’s failure to maintain clearance from a parked vehicle while taxiing from landing.NTSB DCA13LA039Accident · No injuriesLimited investigationFinal reportBoeing 777 - 300 · Miami, FLLV-BMT flight crew's incorrect evaluation of the clearance between the two aircraft, leading to the inadvertent collision of the left winglet with the horizontal stabilizer and elevator of F-GNZI. Contributing to the accident were the incorrect instructions…