# NTSB investigations: Boeing 727-232: On ground/water collision with object

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 NYC00LA040](https://openairdocs.org/ntsb/NYC00LA040.md): Boeing 727-232 · Flushing, NY · Accident · No injuries · Limited investigation · Final report · Nov 27, 1999 · N521DA · Substantial damage
  > was the use of a defective tow bar, due to the lack of an adequate inspection by contract personnel, the airlines lack of an adequate preventative maintenance program for the tow bars, and the lack of oversight by the airline on the contract personnel who…
- [NTSB MIA95LA135](https://openairdocs.org/ntsb/MIA95LA135.md): Boeing 727-232 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · May 24, 1995 · N489DA · Substantial damage
  > The failure of the ground pushback crew to follow delta airlines pushback procedures and place a signalman forward of the aircraft in view of the captain during pushback. This resulted in the captain not being aware that the tug tow bar had disconnected and…
- [NTSB CHI84IA052](https://openairdocs.org/ntsb/CHI84IA052.md): Cessna 421B · Columbus, OH · Incident · No injuries · Incident investigation · Final report · Nov 27, 1983 · N41097 · 2 aircraft · Minor damage
  > During approach to Columbus, the B-727 was vectored to a final for rwy 28L & the C-421 cleared for a visual to rwy 31 with instructions to 'land short of two eight left...' After contacting the tower the plt of the C-421 was twice clearedto land on rwy 31…

## 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 ('1384082')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=1384082&occurrence=310

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