# NTSB investigations: Burkhart Grob Flugzeugbau G103 TWIN ASTIR, TN

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 ATL06CA006](https://openairdocs.org/ntsb/ATL06CA006.md): 1200 G103 · Benton, TN · Accident · Serious injuries · Data collection · Final report · Oct 14, 2005 · N381SL · Substantial damage
  > The pilot's misjudgment of distance and failure to maintain a visual look out during a forced landing resulting in an in flight collision with a guy wire and the ground.
- [NTSB MIA92LA153](https://openairdocs.org/ntsb/MIA92LA153.md): Burkhart Grob G103 · Knoxville, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 1992 · N2135R · Substantial damage
  > The pilot-in-command's failure to properly instruct the passenger on aircraft controls prior to takeoff, resulting in the passenger inadvertently releasing the tow cable as the glider was being towed through 150 feet.
- [NTSB ATL86LA164](https://openairdocs.org/ntsb/ATL86LA164.md): Burkhart Grob G103 · Benton, TN · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1986 · N2135R · Substantial damage
  > The glider landed short of the rwy. The plt had observed another acft on the rwy apch end and extended his base leg. During the turn to final, he deployed the spoilers. He reported that the acft experienced a high sink rate after the turn, and that he…

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

This list as a web page: https://openairdocs.org/ntsb?model=1660202&state=TN

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