Skip to content

NTSB investigations, 2014

25 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") = 2014 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\") = 2014
    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") = 2014
  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 DCA15WA043Accident · No injuriesForeign investigationBoeing 737-800 · London, United KingdomThe United Kingdom's Air Accidents Investigations Branch (AAIB), has notified the NTSB of an accident involving a Boeing 737-800 that occurred on December 17, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under…Dec 17, 2014 · EI-EBR · Substantial damage NTSB DCA15CA025Accident · No injuriesData collectionFinal reportBoeing 737 7H4 · Dallas, TXN263WN captain's failure to maintain a safe clearance from the parked N8314L resulting in a ground collision.Nov 21, 2014 · N263WN · 2 aircraft · Minor damage NTSB ERA15CA057Accident · No injuriesData collectionFinal reportCessna T182T · St. Petersburg, FLThe pilot's failure to properly set the throttle prior to engine start, which resulted in a loss of control and collision with a hangar.Nov 20, 2014 · N6004S · Substantial damage NTSB DCA15CA012Accident · No injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Minneapolis, MNthe B757 Captain's failure to maintain a safe clearance between his wing and the wingtip of the ERJ-170. Contributing to the accident was the positioning of the ERJ-170 by the Compass ground personnel.Oct 23, 2014 · N622CZ · 2 aircraft · Substantial damage NTSB WPR15CA017Accident · No injuriesData collectionFinal reportIndus T-211 Thorpedo · Mountain Home, IDThe pilot's failure to maintain clearance with a parked truck while taxiing for takeoff.Oct 20, 2014 · N211MY · Substantial damage NTSB WPR15CA007Accident · No injuriesData collectionFinal reportCessna T182T · Van Nuys, CAThe pilot's failure to monitor the distance between the left wing and blast fence while maneuvering behind another airplane.Oct 8, 2014 · N378MS · Substantial damage NTSB DCA15FA004Accident · No injuriesField investigationFinal reportEmbraer EMB 145LR · Jamaica, NYThe A340 captain's failure to maintain adequate clearance between his wing and the tail of the EMB-145.Oct 5, 2014 · N572RP · 2 aircraft · Substantial damage NTSB WPR14CA387Accident · No injuriesData collectionFinal reportBeech E33A · Las Vegas, NVThe pilot's incorrect engine start procedures, which included improper throttle position and failure to keep the brakes applied, which resulted in a loss of directional control and subsequent collision with a parked airplane.Sep 21, 2014 · N15RJ · Substantial damage NTSB DCA14CA170Accident · Minor injuriesData collectionFinal reportEmbraer EMB 145XR · Chicago, ILThe tractor driver's failure to give way to the taxiing airplane.Sep 13, 2014 · N16147 · Substantial damage NTSB CEN14LA430Accident · No injuriesLimited investigationFinal reportBombardier CL600 2D24 - 900 · San Antonio, TXFailure of the tow bar shear pin, which resulted in the tug operator’s loss of control of the airplane during pushback operations. Contributing to the accident was the tug operator’s inability to communicate to the flight crew to apply the airplane’s brakes.Aug 9, 2014 · N943LR · Substantial damage NTSB WPR14CA332Accident · Minor injuriesData collectionFinal reportAeronca 7AC · Apple Valley, CAThe pilot's failure to adequately secure the airplane while hand-starting the engine.Aug 8, 2014 · N12DF · Substantial damage NTSB WPR14LA313Accident · No injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Boulder City, NVThe airplane flight crew’s failure to exercise the necessary vigilance and precautions and yield the right of way to the landing helicopter, which resulted in the airplane colliding with the helicopter. Contributing to the accident was the helicopter pilot’s…Jul 25, 2014 · N154GC · 2 aircraft · Substantial damage NTSB ERA14LA341Accident · No injuriesLimited investigationFinal reportLet L 23 Super Blanik · Warm Springs, GAThe failure of the flight instructor to move his glider from an active runway in accordance with procedures due to his distraction by having a conversation with the air boss, which resulted in the landing glider colliding with the glider on the runway.Jul 14, 2014 · N400AZ · 2 aircraft · Substantial damage NTSB ERA14CA314Accident · No injuriesData collectionFinal reportCessna 172L · Danbury, CTThe pilot's use of a person unfamiliar with aviation and his failure to properly secure the airplane during hand starting of the engine.Jun 28, 2014 · N7867G · Substantial damage NTSB WPR14CA255Accident · No injuriesData collectionFinal reportCosmos Phase II Phase II 582 · Caldwell, IDThe pilot's failure to monitor the environment and to maintain sufficient altitude to clear power lines during low altitude flight.Jun 20, 2014 · N234BS · Substantial damage NTSB ANC14CA044Accident · No injuriesData collectionFinal reportCessna 208B · Egegik, AKThe pilot's loss of situational awareness during the takeoff roll resulting in a collision with a refrigeration trailer.Jun 20, 2014 · N208SM · Substantial damage NTSB WPR14LA199Accident · No injuriesLimited investigationFinal reportBeech H35 · Parker, AZThe improperly attached fuel line and cracked fuel diaphragm due to unknown personnel’s inadequate maintenance, which resulted in the loss of engine power during cruise flight and the subsequent forced landing onto rough terrain.May 22, 2014 · N4689D · Substantial damage NTSB ERA14LA257Accident · Serious injuriesLimited investigationFinal reportP&M Quikr · Gulf Shores, ALThe pilot’s failure to maintain aircraft control during engine startup, which resulted in a collision with a parked airplane. Contributing to the accident was the pilot’s failure to follow engine startup procedures and a sudden surge of engine power for…May 22, 2014 · N428PM · Minor damage NTSB WPR14LA198Accident · No injuriesLimited investigationFinal reportRockwell International S 2R · Medicine Lake, MTThe pilot’s failure to maintain airplane control and sufficient altitude to clear terrain during a low-altitude maneuver.May 21, 2014 · N702CB · Substantial damage NTSB ANC14CA036Accident · No injuriesData collectionFinal reportCessna 208B · Aniak, AKThe pilot's failure to maintain clearance from a forklift while taxiing.May 15, 2014 · N1275N · Substantial damage NTSB WPR14LA205Accident · No injuriesLimited investigationFinal reportCessna 180A · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.May 13, 2014 · N5281D · Substantial damage NTSB WPR14CA175Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar Plus · Monterey, CAThe sport pilot's failure to maintain aircraft control during taxi as a result of improperly manipulating the engine power.Apr 28, 2014 · N923LA · Substantial damage NTSB ERA14CA176Accident · No injuriesData collectionFinal reportCessna 172B · Mt Olive, NCThe pilot's failure to adequately secure the airplane before hand-propping the engine for startup.Mar 22, 2014 · N8988B · Substantial damage NTSB DCA14WA082Accident · No injuriesForeign investigationAirbus A320 · Buenos Aires, ArgentinaMar 5, 2014 · LV-BET · 2 aircraft NTSB WPR14LA099Accident · No injuriesLimited investigationFinal reportPiper PA 24-250 · San Jose, CAThe pilot’s failure to sump the fuel tanks, which resulted in water contamination, a partial loss of engine power during takeoff, and collision with a taxiing airplane during the subsequent forced landing.Jan 18, 2014 · N6570P · 2 aircraft · Substantial damage