Final NTSB investigations
85 cases where the sequence of events included Ground handling event.
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '080' 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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '080' 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 DCA14CA051Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD 88 · Atlanta, GAInattention by ground crew personnel which resulted in the airplane being substantially damaged.NTSB ERA13LA183Accident · 1 fatalLimited investigationFinal reportAndrews Zodiac · Collegedale, TNThe pilot's failure to ensure that his seatbelt was fastened and the pilots' failure to ensure that the canopy was latched properly, which resulted in the pilot's ejection from the cockpit following the opening of the canopy and the subsequent in-flight upset.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.NTSB CEN13CA093Accident · No injuriesData collectionFinal reportCirrus SR22 · Eden Prairie, MNThe pilot's failure to ensure the airplane was secured prior to attempting an engine start by handpropping.NTSB WPR12CA137Accident · No injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe pilot did not properly secure the airplane before starting the engine by manually rotating the propeller, which resulted in the inadvertent movement of the airplane.NTSB ERA12LA147Accident · No injuriesLimited investigationFinal reportBoeing DHC-8-102 · Huntington, WVThe inadequate communication among ground crew personnel, which resulted in the airplane’s collision with a deice truck.NTSB CEN12CA032Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Radnor, OHThe pilot's failure to properly secure the engine controls prior to manually rotating the propeller, which led to an inadvertent engine start and runaway airplane.NTSB ERA12CA038Accident · No injuriesData collectionFinal reportMcdonnell Douglas MD-88 · Atlanta, GAThe tug driver's inadequate control of the tug while maneuvering the airplane during pushback.NTSB DCA11CA073Accident · No injuriesData collectionFinal reportBoeing 757-222 · San Fransico, CAThe ramp personnel's failure to visually verify the position of the jetway before beginning the airplane pushback.NTSB WPR11LA300Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Los Angeles, CAThe ground crewmembers’ failure to follow proper procedures for removing a stuck or jammed tow bar, which resulted in a ground crew injury.NTSB CEN11IA270Incident · No injuriesIncident investigationFinal reportEmbraer EMB-135KL · Dubuque, IAThe airport authorities' improper decision to deactivate the jet bridge braking system which created an unsafe condition by the gate agents not being able to stop the bridge from impacting the airplane during a wind gust.NTSB WPR11CA174Accident · Minor injuriesData collectionFinal reportCessna 182C · Stockton, CAThe pilot's failure to secure the airplane before pulling the propeller to start the engine.NTSB CEN11IA198Incident · No injuriesIncident investigationFinal reportBoeing 737-823 · Southlake, TXThe tractor driver’s failure to confirm that the tow bar head/handle was secured correctly to the airplane.NTSB WPR11CA123Accident · Minor injuriesData collectionFinal reportBeech 95-B55 (T42A) · Van Nuys, CAThe pilot's failure to turn off the engine magnetos and properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.NTSB WPR11CA118Accident · Serious injuriesData collectionFinal reportCessna 182 · Eastsound, WAThe pilot’s failure to properly secure the airplane prior to rotating the propeller by hand, resulting in inadvertent movement of the airplane and collision with a building.NTSB WPR11CA107Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Meadview, AZThe pilot's failure to properly secure the airplane while manually starting the engine with the propeller, resulting in inadvertent movement of the airplane and collision with the ground.NTSB DCA11CA014Accident · No injuriesData collectionFinal reportBoeing 737-7H4 · Philadelphia, PAthe failure of the ground operations personnel to maintain awareness of the relative position of the two airplanes.NTSB WPR11LA058Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Salt Lake City, UTThe tug driver’s loss of airplane control during pushback due to a loss of traction in slippery conditions on the ramp. Contributing to the accident was the ground crews’ and airline operators’ inadequate guidance with regard to pushback procedures during low…NTSB ERA11CA046Accident · No injuriesData collectionFinal reportBombardier CL-600-2B19 · Pittsburgh, PAThe ground crew’s failure to detach the air-starter hose from the airplane before moving the cart away resulting in structural damage to a skin panel.NTSB ERA11LA044Accident · No injuriesLimited investigationFinal reportBoeing 737 · Fort Lauderdale, FLThe ground service vehicle driver's depressing of the accelerator rather than the brake pedal, resulting in a collision with the airplane.NTSB WPR10LA352Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Las Vegas, NVThe passenger's failure to maintain clearance from a turning propeller. Contributing to the accident was the pilot's inadequate preflight inspection.NTSB DCA10CA075Accident · No injuriesData collectionFinal reportBoeing 737 · New York, NYa baggage cart impacting the airplane and causing substantial damage as a result of the jet blast from a passing airplane.NTSB CEN10CA300Accident · No injuriesData collectionFinal reportCessna 172K · Wellington, KSThe pilot's failure to properly secure the airplane while manually starting the engine with the propeller.NTSB WPR10FA199Accident · No injuriesField investigationFinal reportBoeing 737-3H4 · Los Angeles, CAThe tug operator’s failure to comply with company procedures when parking an unoccupied baggage tug, and the failure of the tug’s seat switch to disengage the electric motor when weight was removed from the driver’s seat.NTSB CEN10LA142Accident · No injuriesLimited investigationFinal reportBombardier BD-100-1A10 · Wheeling, ILThe deicing vehicle operator's not adhering to company procedures and not maintaining clearance between the vehicle's boom and the airplane's empennage during the airplane's deicing operation.NTSB WPR10LA091Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Camas, WAThe left magneto's broken p-lead, which led to the engine inadvertently starting while the pilot was turning the propeller by hand.NTSB ERA09CA482Accident · No injuriesData collectionFinal reportBell 206 · Gumboro Township, DEThe pilot’s failure to secure the flight controls before exiting the running helicopter. Contributing to the accident was the operator’s practice of exiting the helicopter while it was still running.NTSB CEN09CA469Accident · Serious injuriesData collectionFinal reportPiper PA-25-235 · Miller, MOThe failure of the operator to shut down aircraft while conducting servicing which resulted in a ground person being struck by the rotating aircraft propeller.NTSB WPR09LA211Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-8 · Phoenix, AZThe failure of ramp personnel and the flight crew to maintain clearance from ground equipment while taxiing. Contributing to the accident was the improper positioning of the ground equipment.NTSB CEN09LA107Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Palenstine, TXThe failure of the pilot to ensure security of the cockpit switches before rotating the propeller.NTSB WPR09IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-890 · Seattle, WAThe failure of the deicing crew to follow company procedures by not receiving confirmation from the flight crew before beginning to deice the airplane.NTSB CEN09LA093Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-50 · Madison, WIThe collision between the tug and the airplane during towing as a result of sliding on the snow covered runway.NTSB WPR09CA041Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Mountain Home, IDThe pilot's inadequate preflight inspection, and, his failure to properly secure the aircraft as he left the cockpit with the engine operating, which resulted in the unoccupied airplane inadvertently becoming airborne and colliding with a fence and terrain.NTSB SEA08LA182Accident · Serious injuriesLimited investigationFinal reportBoeing 777-300 · San Francisco, CAThe ground crewman's failure to follow the tow bar disconnect standard operating procedures.NTSB NYC08LA234Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2C10 · Charlotte, NCThe tugdriver and wing walker's lack of communication and the tugdriver's failure to properly monitor the wing walker. Contributing to the accident was the lightning in the vicinity of the airport, which resulted in the ground crewmembers not wearing headsets.