Skip to content

NTSB investigations, 2013

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") = 2013 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\") = 2013
    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") = 2013
  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 DCA14WA023Accident · No injuriesForeign investigationBoeing 747 · Johannesburg, South AfricaDec 22, 2013 · G-BNLL · Substantial damage NTSB 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.Dec 8, 2013 · N3981C · Substantial damage 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.…Nov 7, 2013 · LV-CYO · 2 aircraft · Minor damage 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…Oct 20, 2013 · N15TA · 2 aircraft · Substantial damage NTSB CEN14CA041Accident · Minor injuriesData collectionFinal reportPiper PA 28-180 · Benton Harbor, MIThe pilot's failure to maintain aircraft control during engine start.Oct 2, 2013 · N8084W · Substantial damage NTSB CEN13CA564Accident · Serious injuriesData collectionFinal reportTreidel Mark/R F D Dominator · Watkins, COThe pilot's loss of control of the gyroplane during takeoff roll, following his inadvertent release of the cyclic control.Sep 26, 2013 · N728PJ · Substantial damage NTSB ERA14CA088Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Clermont, FLThe student pilot's failure to maintain directional control during the landing roll.Sep 15, 2013 · N321BA · Substantial damage 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…Sep 1, 2013 · A40-BB · 2 aircraft · Minor damage NTSB ERA13LA381Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe pilot’s incapacitation due to a seizure during taxi.Aug 26, 2013 · N5232D · Substantial damage NTSB WPR13CA371Accident · No injuriesData collectionFinal reportCessna 172H · Metaline Falls, WAThe pilot's failure to maintain clearance from a windsock pole while taxiing.Aug 14, 2013 · N8160L · Substantial damage NTSB CEN13CA452Accident · No injuriesData collectionFinal reportCessna 172N · Tell City, INThe pilot's failure to maintain adequate clearance from an obstruction while taxiing.Jul 25, 2013 · N3012E · Substantial damage 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.Jul 13, 2013 · N4111T · Substantial damage 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.Jun 24, 2013 · N411CP · 2 aircraft · Substantial damage 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.Jun 19, 2013 · N61947 · Substantial damage 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.Jun 19, 2013 · N5314Y · 2 aircraft · Minor damage NTSB DCA13CA106Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD-88 · Nashville, TNThe flight crews failure to maintain clearance from the light pole while taxiing.Jun 13, 2013 · N995DL · Substantial damage NTSB ERA13CA280Accident · No injuriesData collectionFinal reportPiper PA-25-260 · Hollywood, FLThe pilot's failure to maintain directional control during the landing roll.May 31, 2013 · N169AB · Substantial damage 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.May 10, 2013 · N913WN · Minor damage 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.May 1, 2013 · N17560 · 2 aircraft · Substantial damage NTSB WPR13FA208Accident · 1 fatalField investigationFinal reportBell 206B · Shepherd, MTThe pilot’s loss of control while maneuvering during low-altitude operations due to sudden neurological impairment or incapacitation and the helicopter’s subsequent collision with power lines.Apr 27, 2013 · N150SP · Substantial damage 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…Apr 22, 2013 · N119UA · Minor damage 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.Mar 20, 2013 · N421ER · Substantial damage 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.Mar 5, 2013 · N87172 · Substantial damage 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.Mar 2, 2013 · N8713U · Substantial damage NTSB ERA13CA182Accident · No injuriesData collectionFinal reportPiper PA-46-310P · Venice, FLThe pilot’s failure to secure the airplane before moving the propeller to assist the engine start.Feb 23, 2013 · C-GNEW · Substantial damage NTSB CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.Feb 17, 2013 · N4426C · Substantial damage 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.Jan 27, 2013 · N8385S · Substantial damage 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…Jan 17, 2013 · F-GZNI · 2 aircraft · Substantial damage