Skip to content

NTSB investigations, 2017

28 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") = 2017 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\") = 2017
    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") = 2017
  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 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.Dec 28, 2017 · N11KX · Substantial damage 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.Dec 26, 2017 · N698MC · Substantial damage 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.Dec 18, 2017 · N61SR · 2 aircraft · Substantial damage 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.Dec 8, 2017 · N395SC · Substantial damage 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.Dec 3, 2017 · N9011P · 2 aircraft · Minor damage 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.Nov 28, 2017 · SU-GDL · 2 aircraft · Substantial damage 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.Nov 24, 2017 · N666BK · Substantial damage 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.Nov 12, 2017 · N8515S · Substantial damage NTSB GAA18CA016Accident · Serious injuriesData collectionFinal reportUltramagic T210 · Albuquerque, NMThe pilot's failure to maintain adequate clearance from a balloon on the ground during landing.Oct 6, 2017 · N123UT · 2 aircraft · Substantial damage 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.Sep 30, 2017 · N841NN · 2 aircraft · Minor damage NTSB GAA17CA564Accident · No injuriesData collectionFinal reportBoeing PT 13 · Skagit, WAThe pilot’s failure to maintain clearance from airport lighting during the landing roll.Sep 28, 2017 · N43JM · Substantial damage 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.Sep 27, 2017 · N38633 · Substantial damage 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.Sep 23, 2017 · N52KF · Substantial damage 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.Sep 13, 2017 · N261PS · Substantial damage 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.Sep 12, 2017 · N69813 · 2 aircraft · Minor damage 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…Sep 5, 2017 · VT-AYB · Substantial damage 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.Aug 15, 2017 · N377DA · 2 aircraft · Minor damage 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.Jul 28, 2017 · N16MR · 2 aircraft · Substantial damage 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.Jul 16, 2017 · N506WS · 2 aircraft · Minor damage 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.Jul 8, 2017 · N1746R · 2 aircraft · Minor damage 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…Jul 1, 2017 · N991AU · 2 aircraft · Minor damage 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.Apr 8, 2017 · N88470 · 2 aircraft · Substantial damage 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…Mar 30, 2017 · A6-EUB · 2 aircraft · Minor damage NTSB GAA17CA205Accident · No injuriesData collectionFinal reportCessna 172 · Baltimore, MDThe student pilot’s failure to maintain clearance from other airplanes in the run-up area.Mar 24, 2017 · N13499 · Substantial damage NTSB DCA17WA075Incident · No injuriesForeign investigationBoeing 777 · Cancun, MexicoThe Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a BOEING 777 airplane that occurred on March 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's…Mar 5, 2017 · F-GZNO · Minor damage NTSB GAA17CA160Accident · No injuriesData collectionFinal reportCessna 152 · Madill, OKThe pilot’s failure to maintain clearance from a hangar while taxiing at night.Feb 26, 2017 · N6132Q · Substantial damage NTSB CEN17WA102Accident · 4 fatalForeign investigationMD Helicopter 600 · Guatemala City, GuatemalaOn February 7, 2017, about 1253 local time, a United States-registered MD 600N helicopter, N245SE, impacted terrain at the La Aurora International Airport, Guatemala City, Guatemala. The pilot and three passengers were fatally injured. The investigation is…Feb 7, 2017 · N245SE · Substantial damage NTSB GAA17CA119Accident · No injuriesData collectionFinal reportCessna 175 · Lakeport, CAThe pilot’s failure to secure the airplane before pulling the propeller through, which resulted in the airplane rolling and subsequently colliding with a parked airplane.Jan 6, 2017 · N8148T · Substantial damage