Skip to content

NTSB investigations, 2018

32 cases where the sequence of events included Ground collision.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 year(c."eventDate") = 2018 AND 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

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 year(c.\"eventDate\") = 2018
    AND 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 year(c."eventDate") = 2018
  AND 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 GAA19CA097Accident · No injuriesData collectionFinal reportCessna 180 · Moriarty, NMThe pilot's failure to see and avoid a parked glider while taxiing from the runway.Dec 15, 2018 · N188H · Substantial damage 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.Nov 28, 2018 · N552TC · 2 aircraft · Minor damage 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.Nov 23, 2018 · N7081Q · Substantial damage 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.Nov 20, 2018 · N607FT · 2 aircraft · Substantial damage 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.Nov 19, 2018 · N322JS · 2 aircraft · Substantial damage 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.Nov 5, 2018 · N9299B · 2 aircraft · Substantial damage NTSB DCA19WA020AccidentClass 5 · ForeignAirbus A330 · Paris, FranceOct 31, 2018 · N817NW · 2 aircraft · Minor damage NTSB GAA19CA003Accident · No injuriesData collectionFinal reportCessna 152 · Farmingdale, NJThe pilot’s failure to maintain clearance from a vehicle while taxiing for departure.Oct 1, 2018 · N94658 · Substantial damage 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.Sep 15, 2018 · N756FN · 2 aircraft · Substantial damage 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.Sep 8, 2018 · N669HT · Substantial damage 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.Sep 3, 2018 · N97WC · Substantial damage 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…Aug 30, 2018 · N415MC · Minor damage NTSB DCA21WA225AccidentClass 5 · ForeignBoeing 787 · Istanbul, TürkiyeAug 9, 2018 · CN-RGT · 2 aircraft · Substantial damage NTSB 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.Aug 3, 2018 · N2546B · Substantial damage 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…Jul 25, 2018 · N482DA · Substantial damage NTSB GAA18CA588Accident · No injuriesData collectionFinal reportCessna 172 · Chicago, ILThe student pilot's failure to maintain clearance from a truck while taxiing.Jul 17, 2018 · N969RR · Substantial damage 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.Jul 4, 2018 · N208EE · Substantial damage NTSB GAA18CA417Accident · No injuriesData collectionFinal reportTravel Air 2000 · Shelter Island, NYThe pilot's failure to maintain clearance from a tree during taxi.Jun 30, 2018 · N8870 · Substantial damage NTSB GAA18CA374Accident · No injuriesData collectionFinal reportBeech V35B · Chester, CTThe pilot’s failure to maintain clearance from a hangar during taxi.Jun 21, 2018 · N6KG · Substantial damage 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.Jun 14, 2018 · N98395 · Substantial damage NTSB GAA18CA319Accident · Minor injuriesData collectionFinal reportCessna 172 · San Diego, CAThe biplane pilot’s failure to see and avoid the stopped airplane.Jun 3, 2018 · N786SA · 2 aircraft · Substantial damage 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.May 11, 2018 · N481B · 2 aircraft · Substantial damage 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.May 7, 2018 · N8655D · Substantial damage 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.May 1, 2018 · N606LR · 2 aircraft · Substantial damage NTSB GAA18CA208Accident · No injuriesData collectionFinal reportPiper PA 28 · Tucson, AZThe student pilot’s failure to maintain clearance from a stationary pole while parking.Apr 8, 2018 · N4400W · Substantial damage 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.Apr 4, 2018 · N621ZC · 2 aircraft · Substantial damage 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…Apr 2, 2018 · N5614E · 2 aircraft · Destroyed 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.Feb 22, 2018 · N410ER · 2 aircraft · Substantial damage 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…Feb 1, 2018 · G-ATBJ · Substantial damage 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.Jan 25, 2018 · N56548 · Substantial damage 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…Jan 10, 2018 · 9H-BBJ · Minor damage 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…Jan 5, 2018 · C-FDMB · Substantial damage