# NTSB investigations: Quad City Ultralight CHALLENGER II

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 CEN21LA420](https://openairdocs.org/ntsb/CEN21LA420.md): Quad City Ultralight Challenger II · Rogers City, MI · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 11, 2021 · N778H · Substantial damage
  > The separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…
- [NTSB ERA11FA463](https://openairdocs.org/ntsb/ERA11FA463.md): Quad City Ultralight Challenger II · Ransom Township, PA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 2011 · N6613Z · Substantial damage
  > The non-certificated pilot's failure to maintain aircraft control while maneuvering, which resulted in a collision with trees and terrain. Contributing to the accident was the pilot's lack of overall flight experience and lack of experience in the same make…
- [NTSB SEA07LA155](https://openairdocs.org/ntsb/SEA07LA155.md): Quad City Ultralight Challenger II · Lodi, CA · Accident · No injuries · Limited investigation · Final report · Jun 12, 2007 · N204DC · Substantial damage
  > The improper assembly of the rony bracket which attached the right wing forward lift strut to the fuselage, the subsequent failure of that bracket, and separation of the right wing from the aircraft.

## 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 ('059010P', '05902DV', '05603TQ', '05901A4', '059041I', '05902WK'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=059010P

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