# NTSB investigations, IL: Fasteners

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 CEN26LA131](https://openairdocs.org/ntsb/CEN26LA131.md): Quad City Challenger · Van Burensburg, IL · Accident · No injuries · Class 4 · Limited · Final report · Feb 28, 2026 · UNREG · Substantial damage
  > Propeller separation due to failure of the propeller attachment bolts.
- [NTSB CEN09IA618](https://openairdocs.org/ntsb/CEN09IA618.md): Bell 230 · Peoria, IL · Incident · No injuries · Incident investigation · Final report · Jul 1, 2009 · N880SF · No damage
  > The loss of the number one hydraulic system fluid and hydraulic pressure during cruise due to the failure of the bolts that secure the hydraulic pump's cover.
- [NTSB CHI08IA200](https://openairdocs.org/ntsb/CHI08IA200.md): Eclipse EA500 · Rockford, IL · Incident · No injuries · Incident investigation · Final report · Jul 17, 2008 · N875NA · Minor damage
  > The improper installation of the forward edge of the left-hand wing-to-body panel, causing the fairing to separate from the airplane during an in-flight encounter with light turbulence. Contributing to the event was the use of small-head screws and grommets…

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01071430'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01071430/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.
