NTSB investigations: Burkhart Grob Flugzeugbau G103 TWIN ASTIR, CA

8 cases on aircraft the registry lists as Burkhart Grob Flugzeugbau G103 TWIN ASTIR. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations: Burkhart Grob Flugzeugbau G103 TWIN ASTIR, CA per year, 1985–2026: 8 cases
1985	1
1990	2
1991	1
1992	2
1994	1
2006	1

Where

Open the map

Latest cases

Query with 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" = 'CA' 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

duckdb -csv -c "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\" = 'CA' 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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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" = 'CA' 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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB LAX06CA189Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Llano, CAthe student pilot's failure to recover from a porpoise/pilot induced oscillation, which resulted in a hard landing.Jun 3, 2006 · N4464P · Substantial damage NTSB LAX94LA293Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Tehachapi, CAthe pilot's failure to secure the canopy before takeoff, and his failure to maintain directional control during landing rollout.Jul 19, 1994 · N38366 · Substantial damage NTSB LAX92LA352Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Flugzeugbau · Truckee, CAThe pilot's poorly planned approach. Lack of supervision in the type of aircraft was a factor.Aug 17, 1992 · N3872H · Substantial damage NTSB LAX92LA275Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Olancha, CA1) The tow pilot's intentional premature release of the glider, which had become airborne, when the tow plane failed to achieve sufficient airspeed during its takeoff ground roll, and, 2) the glider having insufficient altitude at the time of release to…Jul 3, 1992 · N173SS · Substantial damage NTSB LAX91LA408Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Fremont, CAThe pilot failed to adequately compensate for the prevailing wind conditions.Sep 26, 1991 · N4113G · Substantial damage NTSB LAX90LA282Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Liano, CAThe pilot's inflight decision was improper. Contributing to this accident was the pilot's self-induced pressure.Aug 10, 1990 · N4426B · Substantial damage NTSB LAX90LA130Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Byron, CAThe pilot's inadequate visual lookout for objects along the landing runway.Mar 31, 1990 · N3837J · Substantial damage NTSB LAX85LA209Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Hemet, CAThe plt attempted to land the glider near the rwy threshold in order to be ready for an immediate relaunch. He reported that he was aware of vegetation, located along the edge of the rwy, but said that he misjudged its height. The right wing contacted the…Apr 17, 1985 · N20HS · Substantial damage