# NTSB investigations: Le Blanc Ronald L GLASAIR

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 LAX89DVG01](https://openairdocs.org/ntsb/LAX89DVG01.md): Glasair FT · Redding, CA · Accident · Serious injuries · Final report · Oct 6, 1988 · N197RL · Destroyed
  > On takeoff, plt's canopy came open. When plt diverted attention to close canopy, acft collided with a tree, then terrain. Investigation revealed no canopy latch malfunction. Post acc exam showed that the plts canopy latches were undamaged.
- [NTSB SEA84LA232](https://openairdocs.org/ntsb/SEA84LA232.md): Glasair None · Burns, OR · Accident · No injuries · Limited investigation · Final report · Sep 26, 1984 · N197RL · Substantial damage
  > During the takeoff ground run the aircraft drifted to right side of the rwy. Plt attempted to correct the drift using left rudder and he stated that he over corrected for the drift and the acft began to veer to the left. The acft veered left and departed the…

## 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 ('05655EY'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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