# NTSB investigations: Cessna 402B, IL

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 CHI99IA351](https://openairdocs.org/ntsb/CHI99IA351.md): Cessna 402B · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 25, 1999 · N6362X · Minor damage
  > The failure of the pilot in command to maintain clearance with ground obstructions.
- [NTSB CHI87FA176](https://openairdocs.org/ntsb/CHI87FA176.md): Cessna 402B · Chicago, IL · Accident · 1 fatal · Field investigation · Final report · Jul 21, 1987 · N3742C · Destroyed
  > Failure of maintenance personnel to perform proper installation of the left throttle linkage.
- [NTSB CHI82IA113](https://openairdocs.org/ntsb/CHI82IA113.md): Cessna 402B · Waukegan, IL · Incident · No injuries · Incident investigation · Final report · Apr 5, 1982 · N69341 · Minor damage
  > Pilot reported an oil leak in the right engine to controller while on an instrument approach to Waukegan airport. Several minutes later, pilot reported that he had lost sight of the airport and due to loss of power in the right engine, elected to land in a…
- [NTSB CHI79FEE30](https://openairdocs.org/ntsb/CHI79FEE30.md): Cessna 402 · West Chicago, IL · Accident · No injuries · Closed · Jan 19, 1979 · N4191C · Substantial damage
- [NTSB CHI77FA027](https://openairdocs.org/ntsb/CHI77FA027.md): Cessna 402A · Peoria, IL · Accident · No injuries · Closed · Feb 7, 1977 · N87275 · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=207590P&state=IL

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