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 WPR21LA042Accident · Minor injuriesClass 4 · LimitedFinal reportDiamond DA40 · Mesa, AZThe pilot’s failure to maintain clearance with a vehicle while taxiing.NTSB WPR20LA322Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32-300 · Silver Springs, NVThe pilot’s failure to maintain directional control during a nighttime landing with a crosswind, which resulted in a runway excursion and impact with a sign.NTSB WPR20LA324Accident · No injuriesClass 4 · LimitedFinal reportPilatus PC-12/47E · Lake Abert, ORThe pilot’s failure to maintain clearance from an object during the takeoff ground roll due to inadequate monitoring of the environment.NTSB ERA20LA327Accident · No injuriesClass 3 · LimitedFinal reportMooney M20R · Weston, FLA total loss of engine power because of the overheating and failure of the connecting rod bearings due to a lack of lubrication for reasons that could not be determined.NTSB CEN20LA436Accident · No injuriesClass 4 · LimitedFinal reportPiper J3 · Hartford, WIThe pilot’s loss of situation awareness which resulted in landing in a grass area and the subsequent collision with a runway marker.NTSB CEN20CA358Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 8GCBC · Three Rivers, MIThe pilot's failure to maintain clearance from a taxiway sign after landing.NTSB ERA20LA247Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Fort Lauderdale, FLThe failure of both pilots to see and avoid each other while taxiing, which resulted in a ground collision. Contributing to the accident was the tower controller’s failure to provide information to each pilot regarding the position and intention of the other…NTSB ANC20CA067Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Naknek, AKThe PA-32 pilot's failure to see and avoid the other airplane.NTSB ERA20CA243Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Greenwood, SCThe pilot's failure to maintain adequate clearance from a parked airplane while taxiing. Contributing to the accident was the parked airplane's position over the double-yellow taxiway edge lines and into the taxiway object-free movement area.NTSB WPR20CA120Accident · No injuriesData collectionFinal reportPiper PA28R · Palm Springs, CAThe pilot's failure to see and avoid a parked vehicle near the taxiway edge.NTSB CEN20CA087Accident · No injuriesData collectionFinal reportVans RV8 · Columbus, MSThe inadvertent engine start of the unoccupied airplane, which resulted in it moving forward and impacting a hangar and an electrical box.NTSB DCA20CA077Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 747 412 · Los Angeles, CAAn unavoidable collision with a garbage dumpster that had blown into the path of the airplane during the takeoff roll.NTSB DCA20WA079Accident · No injuriesForeign investigationBoeing 767 · Ciampino, ItalyThe government of Italy has notified the NTSB of an accident involving a BOEING 767 airplane that occurred on January 20, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the provisions of…NTSB WPR20CA087Accident · No injuriesData collectionFinal reportPiper PA28 · Santa Barbara, CAThe pilot's failure to maintain clearance from a parked airplane during taxi operations at night.NTSB ERA20CA140Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Palm Coast, FLThe student pilot's failure to allow adequate separation when passing the parked airplane, which resulted in a ground collision.NTSB DCA20CA049Accident · No injuriesData collectionFinal reportBoeing 737 · New York, NYfailure of the deicing truck driver to maintain appropriate clearance from the airplane.NTSB CEN20CA047Accident · No injuriesData collectionFinal reportCessna 182 · Robstown, TXThe pilot's failure to set the friction lock on the throttle before hand propping the engine, which allowed the airplane to move forward and impact a credit card machine. Contributing to the accident was the malfunction of the parking brake for reasons that…NTSB ERA20LA070Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Concord, NCA malfunction of the left main landing gear brake during landing for undetermined reasons. Contributing was the pilot’s failure to attain a proper touchdown point and maintain an appropriate approach speed while landing on the wet turf runway.NTSB WPR20CA046Accident · No injuriesData collectionFinal reportBeech 350 · Visalia, CAThe single-engine pilot's failure to yield to traffic established on the taxiway, which resulted in a ground collision.NTSB GAA20CA094Accident · Minor injuriesData collectionFinal reportPiper PA28 · Simsbury, CTThe automobile driver's incursion onto an active runway, which resulted in a collision with a landing airplane.NTSB ANC20LA003Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Honolulu, HIThe pilot of the Cessna's failure to set the parking brake before diverting his attention inside the airplane, which resulted in his airplane colliding with the airplane ahead of it on the taxiway.NTSB DCA20CA003Accident · No injuriesData collectionFinal reportKitty Hawk Heaviside2 · Tres Pinos, CAa software timing error initiated by a battery charging script that was not properly terminated prior to the test flight due to operator error.NTSB GAA20CA021Accident · No injuriesData collectionFinal reportWingtip To Wingtip Panzl S-330 · Cedartown, GA***This report was modified on June 4, 2020. Please see the docket for this accident to view the original report.*** The departing pilot's failure to see and avoid the arriving airplane as it was turning off the runway from which the departing pilot was…NTSB DCA19CA223Accident · No injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2C10 · Chicago OHare, ILthe tug driver's inability to maintain visual contact with the wing walkers and lack of situational awareness during pushback.NTSB WPR19FA241Accident · 1 fatalClass 3 · FieldFinal reportGlaser Dirks DG 300 Elan · Wilkeson, WAThe pilot’s delayed decision to land following a loss of thermal lift, which resulted in collision with trees during the landing approach.NTSB GAA19CA498Accident · No injuriesData collectionFinal reportCessna 172 · Daytona Beach, FLThe pilot entering the taxiway's failure to see and avoid the airplane established on the taxiwayNTSB GAA19CA468Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe other pilot's failure to maintain clearance from the airplane while taxiing.NTSB CEN19TA196Accident · No injuriesFinal reportAeronca 65 C · Gilliam, LAThe pilot's failure to see and avoid a dark-colored utility pole while taxiing for takeoff.NTSB GAA19CA366Accident · No injuriesData collectionFinal reportTaylorcraft BC12 · Yerington, NVThe pilot's failure to properly secure the airplane before hand propping it, which resulted in the unmanned airplane moving and colliding with a fence.NTSB GAA19CA422Accident · No injuriesData collectionFinal reportDaryl Baker Bush Sport · Willimantic, CTThe pilot's failure to maintain directional control during taxi operations, which resulted in a collision with a fuel pump enclosure.NTSB GAA19CA298Accident · No injuriesData collectionFinal reportPiper PA18 · Sparta, ILThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB GAA19CA312Accident · No injuriesData collectionFinal reportCessna 172 · Nogalas, AZThe student pilot's failure to maintain adequate clearance from a parked fuel truck. Contributing to the accident were the student’s failure to follow company policy and the flight instructor’s delayed remedial action.NTSB GAA19CA239Accident · No injuriesData collectionFinal reportGippsland GA8 · Bethel, AKThe pilot's failure to maintain adequate clearance from a shipping container while taxiing.NTSB GAA19CA220Accident · No injuriesData collectionFinal reportCessna 172 · Prescott, AZThe student pilot's failure to maintain clearance from a fence post during taxi operations.NTSB GAA19CA207Accident · No injuriesData collectionFinal reportNorth American SNJ · Chino, CAThe other pilot's failure to maintain clearance from a stopped airplane while taxiing.NTSB DCA19CA146Accident · Minor injuriesData collectionFinal reportMcdonnell Douglas MD88 · Atlanta, GAfailure of the tug driver to give way to the taxiing airplane.NTSB GAA19CA196Accident · No injuriesData collectionFinal reportPiper PA32 · Lakeland, FLThe pilot's failure to maintain clearance from a fence post during taxi to parking.NTSB ERA19TA146Accident · No injuriesClass 3Final reportCessna 172 · Fort Myers, FLThe pilot's failure to remain clear of a light pole while taxiing.NTSB GAA19CA190Accident · No injuriesData collectionFinal reportCessna 172 · Hollywood, FLThe other pilot's failure to maintain adequate clearance from the stopped airplane while attempting to taxi around it.NTSB DCA19CA105Accident · No injuriesClass 4 · Data collectionFinal reportBoeing 737 · Atlanta, GAfailure of the B737 captain to maintain separation with the airplane stopped on the taxiway.NTSB DCA19CA102Accident · Minor injuriesClass 4 · Data collectionFinal reportBombardier CL 600 2C10 · Charlotte, NCfailure of the ground crew to maintain visual separation and avoid the holding aircraft.NTSB CEN19LA092Accident · Minor injuriesLimited investigationFinal reportBell 407 · Union Center, SDThe ambulance driver’s failure to see the helicopter’s rotating main rotor blades in dark night conditions, which resulted in the ambulance’s inadvertent collision with the helicopter. Contributing to the accident was the ambulance driver's failure to follow…NTSB GAA19CA136Accident · No injuriesData collectionFinal reportCessna 182 · Arlington, WAThe pilot's distraction during the engine warm-up, which resulted in the airplane's collision with a hangar. Contributing to the accident was the pilot's failure to set the brakes.NTSB WPR19TA068Accident · Minor injuriesClass 3Final reportPitts S1 · Torrance, CAThe biplane pilot’s inadequate visual lookout while taxing, which resulted in a ground collision.NTSB GAA19CA097Accident · No injuriesData collectionFinal reportCessna 180 · Moriarty, NMThe pilot's failure to see and avoid a parked glider while taxiing from the runway.NTSB GAA19CA079Accident · No injuriesData collectionFinal reportPilatus PC12 · Mesa, AZThe other pilot's failure to follow the air traffic controller’s instructions and his subsequent failure to maintain adequate lookout to see and avoid the other airplane on the taxiway.NTSB ERA19LA055Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · North Myrtle Beach, SCThe failure of the right brake while taxiing after landing, which resulted in a loss of directional control and collision with a parked airplane.NTSB GAA19CA071Accident · No injuriesData collectionFinal reportPiper PA28 · Miami, FLThe other pilot's improper decision to taxi past another airplane occupying a taxiway and her subsequent failure to maintain clearance from the airplane.NTSB GAA19CA068Accident · No injuriesData collectionFinal reportSilveira Jonathan A Sonex · Corona, CAThe pilot’s failure to see and avoid the airplane on the runway while landing and the pilot receiving instruction’s and flight instructor's failure to properly scan the approach before pulling onto the runway during the takeoff.NTSB WPR19TA031Accident · No injuriesClass 3Final reportPiper PA28 · Chandler, AZThe student pilot’s failure to maintain a safe distance from the other airplane while taxiing, resulting in a ground collision.