# NTSB investigations: Pratt & Whitney JT8D-15: 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 NYC05LA043](https://openairdocs.org/ntsb/NYC05LA043.md): Boeing 737-247 · Covington, KY · Accident · No injuries · Limited investigation · Final report · Jan 17, 2005 · N373DL · Substantial damage
  > The catering truck driver's failure to maintain clearance of the parked airplane by his inadvertent depressing the accelerator. A factor in this accident was the catering truck driver's diverted attention.
- [NTSB ATL96LA028](https://openairdocs.org/ntsb/ATL96LA028.md): Boeing 737-232 · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1995 · N306DL · Substantial damage
  > Failure of the tug driver, who was towing the Lockheed L-1011, to ensure that clearance was maintained from the Boeing 737, which was standing.
- [NTSB MIA88LA075](https://openairdocs.org/ntsb/MIA88LA075.md): Boeing 727-200 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Dec 26, 1987 · N705AA · 2 aircraft · Substantial damage
  > N705AA was number two in position for takeoff behind N893AA. N705AA received takeoff clearance first and as it began to taxi to the runway it's left wing tip struck and passed under the right wing tip of N893AA.

## 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.engine_model_code IN ('52051')
    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?engine=52051&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.