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 DCA19WA020AccidentClass 5 · ForeignAirbus A330 · Paris, FranceNTSB GAA19CA003Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot’s failure to maintain clearance from a vehicle while taxiing for departure.NTSB GAA18CA568Accident · No injuriesData collectionFinal reportCessna U206 · Millbrook, NYThe failure of the other pilot to yield to traffic established on the taxiway, which resulted in a ground collision.NTSB GAA18CA545Accident · Minor injuriesData collectionFinal reportCirrus SR22 · Mason City, IAThe pilot’s improper hand propping procedure, which resulted in a runaway airplane and subsequent impact with a hangar.NTSB GAA18CA528Accident · No injuriesData collectionFinal reportBeech 200 · Burbank, CAThe flight instructor's and pilot receiving instruction's failure to maintain clearance from a tree while taxiing.NTSB DCA18WA287Incident · No injuriesForeign investigationBoeing 747 · Hong Kong, Hong Kong SAR ChinaThe AAIA of Hong Kong has notified the NTSB of an accident involving a Boeing 747 airplane that occurred on August 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIA's investigation under the provisions of ICAO Annex 13 as…NTSB DCA21WA225AccidentClass 5 · ForeignBoeing 787 · Istanbul, TürkiyeNTSB CEN18LA315Accident · No injuriesLimited investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Dallas, TXThe pilot's inability to maintain directional control during taxi due to excessively worn brake pads and a deflated right main tire.NTSB GAA18CA445Accident · No injuriesData collectionFinal reportCirrus SR20 · Sanford, FLThe flight instructor's failure to maintain an appropriate approach speed in crosswind conditions, which resulted in the airplane landing long on the wet runway and his subsequent loss of directional control when he attempted to exit the runway at high speed…NTSB GAA18CA588Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe student pilot's failure to maintain clearance from a truck while taxiing.NTSB GAA18CA409Accident · No injuriesData collectionFinal reportCessna 208 · Chicago, ILThe service truck driver’s evasive maneuver to avoid a bag cart tug, which resulted in the truck impacting a parked airplane.NTSB GAA18CA417Accident · No injuriesData collectionFinal reportTravel Air 2000 · Shelter Island, NYThe pilot's failure to maintain clearance from a tree during taxi.NTSB GAA18CA374Accident · No injuriesData collectionFinal reportBeech V35B · Chester, CTThe pilot’s failure to maintain clearance from a hangar during taxi.NTSB GAA18CA360Accident · No injuriesData collectionFinal reportCessna 172 · Salem, ILThe student pilot’s failure to maintain clearance from a pole while taxiing the airplane on the ramp.NTSB GAA18CA319Accident · Minor injuriesData collectionFinal reportCessna 172 · San Diego, CAThe biplane pilot’s failure to see and avoid the stopped airplane.NTSB GAA18CA275Accident · No injuriesData collectionFinal reportAeropro CZ S R O A240 · Chandler, AZThe pilot’s failure to stop and yield to the airplane taxiing on the taxiway, which resulted in a ground collision.NTSB DCA18CA169Accident · No injuriesData collectionFinal reportBoeing 737-8H4 · Baltimore, MDThe maintenance truck driver's failure to give way to the airplane that resulted in the truck colliding with the taxiing aircraft.NTSB DCA18CA165Accident · No injuriesData collectionFinal reportBombardier CL600 2D24 · Queens, NYthe failure of the captain of Delta 212 to ensure adequate clearance while taxiing behind Endeavor 3413.NTSB GAA18CA208Accident · No injuriesData collectionFinal reportPiper PA 28 · Tucson, AZThe student pilot’s failure to maintain clearance from a stationary pole while parking.NTSB WPR18LA118Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 42 NG · Bozeman, MTThe student pilot and flight instructor's failure to see and avoid the stationary airplane during taxi, which resulted in a ground collision.NTSB CEN18FA132Accident · 2 fatalField investigationFinal reportCessna 150 · Marion, INThe failure of both pilots to see and avoid the other airplane as they converged on intersecting runways. Contributing to the accident was the jet pilot's not monitoring the airport's traffic advisory frequency, known reduced visibility of the intersecting…NTSB GAA18CA198Accident · No injuriesData collectionFinal reportCessna 172 · Brunswick, GAThe pilot receiving instruction’s failure to see and avoid an airplane holding short of the runway on the taxiway and the flight instructor’s lack of situational awareness.NTSB CEN18WA090Accident · No injuriesForeign investigationSikorsky S61 · Marchwood, New Hampshire, United KingdomOn February 1, 2018, a Sikorsky S-61N helicopter (G-ATBJ, s/n 6126930-439), pitched down and stuck the ground while hovering after takeoff near Marchwood, Hampshire in the United Kingdom. There was two persons on board, who were not injured. This…NTSB GAA18CA111Accident · Minor injuriesData collectionFinal reportMaule M 6 · Boerne, TXThe ground vehicle driver’s decision to drive on an active taxiway at night and failure to yield to taxiing aircraft, resulting in a collision with a taxiing aircraft.NTSB DCA18WA076Incident · No injuriesForeign investigationBoeing 737 · London, United KingdomThe Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving a Boeing 737, which occurred on January 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…NTSB DCA18WA075Accident · No injuriesForeign investigationBoeing 737 · Toronto, CanadaThe Transportation Safety Board (TSB) of Canada has notified the NTSB of an accident involving a Boeing 737, which occurred on January 5, 2018. The NTSB has appointed a U.S Accredited Representative to assist under the provisions of ICAO Annex 13, as the…NTSB GAA18CA094Accident · No injuriesData collectionFinal reportPiper PA32 · Spearfish, SDThe pilot’s inadvertent landing in snow adjacent to the snow-covered runway resulting in a collision with runway signs.NTSB WPR18CA059Accident · No injuriesData collectionFinal reportCessna 182 · Santa Ana, CAThe pilot’s failure to follow ground control instructions and to see and avoid ground obstacles while taxiing.NTSB GAA18CA087Accident · No injuriesData collectionFinal reportMaule MX7 · Willow, AKThe pilot’s failure to see and avoid another airplane stopped on the taxiway while taxiing in sun glare conditions.NTSB GAA18CA073Accident · No injuriesData collectionFinal reportBrock Steiner Sport Copter Vortex · Spanish Fork, UTThe pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.NTSB DCA18CA043Accident · No injuriesData collectionFinal reportAirbus A319 115 · Miami, FLThe failure of the flight crew of N9011P to maintain an appropriate clearance from N344PP, which was stopped on the taxiway.NTSB DCA18LA024AccidentClass 3 · LimitedFinal reportBoeing 777 · Jamaica, NYThe air traffic controller's improper instruction to the Egypt Air airplane flight crew to pass in an area where passing is prohibited, which led to a ground collision.NTSB GAA18CA057Accident · No injuriesData collectionFinal reportKarpayev Vladyslav V RV-9 · Moab, UTThe pilot’s selection of an unsuitable taxiway, which resulted in the wings striking hidden fence posts.NTSB GAA18CA051Accident · No injuriesData collectionFinal reportCessna 182H · Tucson, AZThe pilot’s failure to use taxiways shown on the airport diagrams and his subsequent failure to avoid a ditch.NTSB GAA18CA016Accident · Serious injuriesData collectionFinal reportUltramagic T210 · Albuquerque, NMThe pilot's failure to maintain adequate clearance from a balloon on the ground during landing.NTSB DCA17CA214Accident · No injuriesData collectionFinal reportBoeing 737 823 · Arlington, VAThe failure N841NNs captain to maintain appropriate clearance from N982VJ, which was stopped on the taxiway.NTSB GAA17CA564Accident · No injuriesData collectionFinal reportBoeing PT 13 · Skagit, WAThe pilot’s failure to maintain clearance from airport lighting during the landing roll.NTSB GAA17CA560Accident · Minor injuriesData collectionFinal reportPiper J5A · Geneseo, NYThe pilot's failure to properly secure the airplane before a hand propeller start, which resulted in the airplane moving forward and colliding with maintenance equipment.NTSB WPR17LA214Accident · No injuriesLimited investigationFinal reportSC Aerostar YAK 52W · El Cajon, CAThe pilot's failure to maintain directional control during taxi after a reduction in braking performance and steering capabilities due to his failure to reopen the air supply valve after the nonstandard engine start.NTSB DCA17CA197Accident · Serious injuriesData collectionFinal reportBombardier CL 600 2B19 · Charlotte, NCthe tug operator's initiation of a right turn onto the perpendicular terminal road in proximity to the airplane.NTSB DCA17CA195Accident · No injuriesData collectionFinal reportBoeing 737-924ER · Los Angeles, CAthe B737 flight crew's misjudgment of the clearance between their wingtip and the B767 horizontal stabilizer.NTSB DCA17WA218Accident · Minor injuriesForeign investigationBoeing 737 · Chochin, IndiaThe Aircraft Accident Investigation Bureau of India has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on September 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of India's…NTSB DCA17CA181Accident · No injuriesData collectionFinal reportBoeing 737 832 · Queens, NYthe Delta B737 captain's failure to maintain proper clearance between his airplane and the stopped American B757.NTSB GAA17CA458Accident · No injuriesData collectionFinal reportRandall Marvin L Vans RV 3A · Spokane, WAThe other pilot’s failure to maintain adequate clearance and visual lookout while taxiing, which resulted in his airplane colliding with the stationary airplane.NTSB GAA17CA411Accident · No injuriesData collectionFinal reportSpani Wayne M Starduster TOO SA300 · San Diego, CAThe other pilot's failure to maintain separation from a stationary airplane during the taxi to the runway.NTSB GAA17CA395Accident · No injuriesData collectionFinal reportCessna R182 · San Jose, CAThe other pilot’s failure to maintain separation from another airplane in the run-up area while taxiing.NTSB DCA17CA147Accident · No injuriesData collectionFinal reportAirbus A321 231 · Chicago, ILthe A321 flight crew's incorrect evaluation of the clearance between the aircraft, leading to the inadvertent collision with the horizontal stabilizer of the CRJ700. Contributing to the accident was traffic congestion that resulted in the CRJ700 having to…NTSB GAA17CA223Accident · No injuriesData collectionFinal reportPiper J3C · New Carlisle, OHThe other pilot’s decision to land on an occupied runway and his failure to see and avoid the airplane.NTSB DCA17WA084Incident · No injuriesForeign investigationAirbus A380 · Changi, SingaporeThe Transport Safety Investigation Bureau (TSIB) Ministry of Transport Singapore has notified the NTSB of an incident involving a AIRBUS A380 airplane that occurred on March 30, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB GAA17CA205Accident · No injuriesData collectionFinal reportCessna 172 · Baltimore, MDThe student pilot’s failure to maintain clearance from other airplanes in the run-up area.