# NTSB investigations: Boeing 737-3H4: 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 DCA16CA207](https://openairdocs.org/ntsb/DCA16CA207.md): Boeing 737 3H4 · Baltimore, MD · Accident · No injuries · Data collection · Final report · Aug 5, 2016 · N368SW · Substantial damage
  > the tug operators excessive speed during pushback.
- [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.
- [NTSB WPR10FA199](https://openairdocs.org/ntsb/WPR10FA199.md): Boeing 737-3H4 · Los Angeles, CA · Accident · No injuries · Field investigation · Final report · Apr 10, 2010 · N624SW · Substantial damage
  > The 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.

## 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 ('138447K')
    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=138447K

---
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.