# NTSB investigations: Pratt & Whitney JT8D-17 series, WI

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 CEN09LA093](https://openairdocs.org/ntsb/CEN09LA093.md): Mcdonnell Douglas DC-9-50 · Madison, WI · Accident · No injuries · Limited investigation · Final report · Dec 3, 2008 · N782NC · Substantial damage
  > The collision between the tug and the airplane during towing as a result of sliding on the snow covered runway.
- [NTSB CHI01IA248](https://openairdocs.org/ntsb/CHI01IA248.md): Boeing 727-2Q6 · Oshkosh, WI · Incident · No injuries · Incident investigation · Final report · Jul 27, 2001 · N782AT · 2 aircraft · No damage
  > The unsafe condition caused when the pilot taxied onto the runway. Factors relating to this accident were the pilot not following the instructions given him by the ground marshaller, his wrong taxi route, and his not obtaining clearance to taxi onto the…
- [NTSB CHI87IA039](https://openairdocs.org/ntsb/CHI87IA039.md): Douglas DC-9-51 · Madison, WI · Incident · No injuries · Incident investigation · Final report · Dec 2, 1986 · N786NC · Minor damage
  > Aircraft slid off the right side the runway during the rollout from a cross wind landing and struck 6 runway edge lights causing minor damage to the inboard trailing edge of the right flap. At the time of the incident there was 1/2 inch of snow on the runway…

## 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."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('52049'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=52049&state=WI

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