# Final NTSB investigations: Mcewen Dick GLASAIR III

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 LAX92LA235](https://openairdocs.org/ntsb/LAX92LA235.md): Mcquen Glassair III · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · May 10, 1992 · N115DM · Substantial damage
  > Fuel starvation due to the pilot's misreading of a newly installed fuel selector panel with placards and a position pointer which were confusing. Factors in the accident were the confusing nature of the fuel panel and placard design and the school bus which…
- [NTSB LAX92LA176](https://openairdocs.org/ntsb/LAX92LA176.md): Mcewen Dick Glasair III · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · Apr 10, 1992 · N115DM · Substantial damage
  > A failure of the pilot to select the proper fuel tank and subsequent fuel starvation. Contributing to the accident was an inadequate design by the manufacturer that permitted the fuel selector to be rotated 360 degrees, and the pilot's lack of familiarity…

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

This list as a web page: https://openairdocs.org/ntsb?model=056559M&status=final

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