NTSB investigations
499 cases where the defining event was Ground collision.
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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '200') 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."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '200') 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 CEN11LA051Accident · No injuriesLimited investigationFinal reportBombardier CL-600-2B19 · Chicago, ILThe pickup truck driver’s failure to follow airport and company policies regarding ground vehicle operations, which allowed for the unattended truck to collide with the airplane. Contributing to the accident were the truck's misadjusted shift lever and…NTSB ERA11LA043Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hilton Head Island, SCThe Pitts pilot's inadequate visual lookout and failure to maintain clearance from the Cirrus airplane.NTSB ERA10CA491Accident · No injuriesData collectionFinal reportMooney M20J · Hazard, KYThe pilot's failure to maintain clearance from a fuel pump while taxiing. Contributing to the accident was the pilot’s diverted attention.NTSB ERA10CA479Accident · No injuriesData collectionFinal reportCessna 182S · Toms River, NJThe pilot's failure to maintain an adequate visual lookout during a night taxi. Contributing to the accident was the improper parking of a ground vehicle partially onto the taxiway.NTSB WPR10CA451Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Paradise Lakes Estates, CAThe pilot's failure to maintain clearance from a fence during taxi.NTSB CEN10CA540Accident · No injuriesData collectionFinal reportBeech E-90 · Colorado Springs, COThe pilot’s failure to ensure that the airplane’s parking brake was properly set before diverting his attention to other tasks.NTSB ERA10CA445Accident · No injuriesData collectionFinal reportColumbia Aircraft Mfg LC42-550FG · Tampa, FLThe pilot's failure to reduce engine power following a high-powered engine start.NTSB WPR10LA427Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Sequim, WAThe pilot’s failure to maintain the proper approach path and his delayed corrective actions, which resulted in an undershoot. Contributing to the accident was the pilot's distraction from other aircraft in the area.NTSB CEN10LA478Accident · No injuriesLimited investigationFinal reportAeronca 7CCM · Justin, TXA loss of engine power due to fuel starvation as a result of the pilot's delay in transferring fuel from the gravity feed wing tanks to the main tank.NTSB ERA10CA411Accident · No injuriesData collectionFinal reportPiper PA28 · Marshfield, MAThe pilot's failure to maintain clearance from a vehicle while taxiing. Contributing to the accident was his inadequate visual lookout.NTSB CEN10CA468Accident · No injuriesData collectionFinal reportPiper J3C-85 · Auburn, INThe pilot of the other airplane failing to monitor the position this airplane.NTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.NTSB ERA10CA402Accident · No injuriesData collectionFinal reportCessna 172N · Perry, GAThe pilot's failure to maintain clearance from a pole while taxiing.NTSB ERA10CA382Accident · No injuriesData collectionFinal reportGulfstream GIV · New York, NYThe flight crew’s failure to maintain adequate wing tip clearance from a light pole during taxi.NTSB WPR10CA367Accident · No injuriesData collectionFinal reportCessna 152 · Ephrata, WAThe pilot's failure to maintain clearance from a fire hydrant while taxiing to the runway.NTSB CEN10LA425Accident · Minor injuriesLimited investigationFinal reportSmith Aerostar · Cleburne, TXA total loss of engine power due to fuel starvation as a result of the pilot’s improper fuel management. Contributing to the accident were the critical fuel placards that were difficult to see due to the airplane's paint scheme.NTSB CEN10LA422Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · McCook, NEThe pilot's inadequate visual lookout during taxi, which resulted in a collision with a parked airplane.NTSB ERA10LA345Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Fairfield, PAThe pilot's improper touchdown point which resulted in an overrun.NTSB CEN10LA338Accident · No injuriesLimited investigationFinal reportPilatus P3-05 · Canby, MNThe North American's pilot's failure to maintain adequate visual lookout, which resulted in an on-ground collision with the Pilatus.NTSB ERA10LA299Accident · No injuriesLimited investigationFinal reportAirbus Industrie A330-323 · Charlotte, NCThe Airbus A330 flight crew's failure to maintain clearance from a standing airplane while taxiing.NTSB WPR10LA198Accident · Minor injuriesLimited investigationFinal reportGrumman American Avn. G-1159 · Seattle, WAThe failure of the pilot to maintain adequate clearance/distance from the fuel truck during taxi.NTSB WPR10LA189Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Honolulu, HIThe pilot's failure to maintain clearance from a parked airplane during taxi due to his inadequate visual lookout.NTSB ERA10CA165Accident · No injuriesData collectionFinal reportCessna P210N · Miami, FLThe pilot's failure to see and avoid an unlit and unmarked helicopter dolly while taxiing at night.NTSB WPR10LA155Accident · No injuriesLimited investigationFinal reportKeller FK1 Stol · Dixie, IDThe failure of the experimental FK1 pilot to maintain clearance from a parked airplane while landing.NTSB WPR10IA135Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120ER · Los Angeles, CAThe flight crew’s failure to maintain clearance from the jet bridge during taxi. Contributing to the incident was the ramp marshaller's diverted attention and failure to signal the flight crew to stop at the correct position.NTSB ERA10LA139Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Canon, GAThe Luscombe pilot's improper engine starting procedures.NTSB ANC10LA012Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Gulkana, AKThe pilot's selection of unsuitable terrain for landing, which resulted in structural damage to the airplane during landing.NTSB DCA10CA018Accident · Minor injuriesData collectionFinal reportBombardier CL600 2C10 · Dallas, TXThe fueler's falling asleep in the fueling truck with the truck in neutral and without the parking brake set, which allowed the truck to roll until it impacted the airplane.NTSB ERA10CA093Accident · No injuriesData collectionFinal reportRockwell International 114 · Birmingham, ALA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight fuel planning.NTSB WPR10CA079Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR 4000 · Torrance, CAThe Travel Air pilot's failure to maintain an adequate visual lookout during taxi.NTSB DCA10IA006Incident · No injuriesIncident investigationFinal reportBoeing 767 · Dulles International Airport, VAThe failure of the lead and left side marshallers to identify the B40 jetway obstacle and stop the airplane's taxi before the wingtip contacted the jetway. Contributing to the cause of this incident were inadequate marshalling procedures used by the ground…NTSB WPR10LA002Accident · No injuriesLimited investigationFinal reportCessna 421B · San Simeon, CAThe pilot's failure to follow the manufacturer’s checklist and set the parking brake.NTSB WPR09CA473Accident · No injuriesData collectionFinal reportAviat A-1B · Toledo, WAThe pilot's failure to maintain clearance from a tree while taxiing. Contributing to the accident was the pilot's distracted attention.NTSB CEN09CA600Accident · No injuriesData collectionFinal reportCessna 402B · Omaha, NEThe pilot’s improper decision to taxi with an obstructed windscreen and his failure to maintain clearance from the parked airplane.NTSB WPR09CA461Accident · No injuriesData collectionFinal reportCessna 172S · San Carlos, CAThe student pilot's failure to maintain clearance with a fence post during taxi.NTSB WPR09CA447Accident · No injuriesData collectionFinal reportCessna 172P · Long Beach, CAThe pilot’s failure to maintain clearance from a parked vehicle during taxi.NTSB WPR09CA438Accident · No injuriesData collectionFinal reportBeech S35 · Fallon, NVThe pilot's failure to maintain clearance from an obstacle during taxi.NTSB ERA09LA506Accident · No injuriesLimited investigationFinal reportCessna 140 · Louisa, VAThe Cessna pilot's inadequate visual lookout.NTSB ERA09CA508Accident · No injuriesData collectionFinal reportMooney 231 · Charlottesville, VAThe pilot’s inadequate preflight planning and lack of familiarity with the airport diagram, which resulted in a runway excursion onto a grassy area.NTSB ERA09CA489Accident · No injuriesData collectionFinal reportPiper J5A · Holland, MAA loss of engine power due to fuel exhaustion. A factor in the accident was the pilot's inadequate preflight inspection.NTSB WPR09CA416Accident · No injuriesData collectionFinal reportMorgan James E Morgan RV6 · Everett, WAThe pilot’s failure to maintain clearance from objects during taxi. Contributing to the accident was the inadequate marking of the taxiway and obstacles.NTSB ERA09TA466Accident · No injuriesFinal reportCessna 180 · Spartanburg, SCThe Cessna pilot's inadequate visual lookout.NTSB WPR09CA376Accident · No injuriesData collectionFinal reportSchweizer SGS 2-32 · Heber City, UTThe pilot's excessive speed as he turned off the runway.NTSB CEN09CA493Accident · Minor injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Cape Girardeau, MOThe airplane's inoperative brakes while taxiing. Contributing to the accident was the pilot's inadequate preflight.NTSB ERA09CA391Accident · No injuriesData collectionFinal reportCessna 172RG · Morristown, NJThe pilot's failure to maintain clearance from a parked aircraft during taxi operations.NTSB CEN09TA399Accident · No injuriesFinal reportCessna 182 · Cookson, OKThe pilot's failure to maintain clearance with the building while taxiing on a road.NTSB WPR09LA255Accident · No injuriesLimited investigationFinal reportEmbraer EMB-135 · Los Angeles, CAThe flight crew's failure to adequately monitor and maintain clearance from a parked aircraft while taxiing. Contributing to the accident was an improperly parked airplane that encroached upon the taxiway area.NTSB WPR09FA246Accident · Minor injuriesField investigationFinal reportCessna 172 · Burlington, WAThe failure of the pilot of another airplane to maintain adequate visual lookout during the approach.NTSB ANC09CA041Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain clearance from a tree while taxiing.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.