# NTSB investigations: Boeing 737-7H4: Ground handling event

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB DCA18CA074](https://openairdocs.org/ntsb/DCA18CA074.md): Boeing 737 7H4 · Los Angeles, CA · Accident · Serious injuries · Data collection · Final report · Nov 19, 2017 · N740SW · No damage
  > The provisioning agent's lack of situational awareness while stepping from the airplane to the provisioning van. Contributing to the accident was the provisioning vans failed switch.
- [NTSB DCA18CA001](https://openairdocs.org/ntsb/DCA18CA001.md): Boeing 737 7H4 · Chicago, IL · Accident · No injuries · Data collection · Final report · Oct 2, 2017 · N930WN · Substantial damage
  > the mechanical failure of the tugs fuel governor, which made it difficult for the ramp agent to stop the tug. Contributing to the accident was the lack of guidance on how ground personnel were to handle vehicle malfunctions.
- [NTSB WPR14LA346](https://openairdocs.org/ntsb/WPR14LA346.md): Boeing 737 7H4 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Aug 14, 2014 · N758SW · Substantial damage
  > The disconnection of baggage carts that subsequently collided with the parked airplane following the tug driving over a dip in the roadway.
- [NTSB DCA11CA014](https://openairdocs.org/ntsb/DCA11CA014.md): Boeing 737-7H4 · Philadelphia, PA · Accident · No injuries · Data collection · Final report · Dec 18, 2010 · N913WN · 2 aircraft · Substantial damage
  > the failure of the ground operations personnel to maintain awareness of the relative position of the two airplanes.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1384404')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND 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
```

This list as a web page: https://openairdocs.org/ntsb-events/080/sequence?model=1384404

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
