NTSB investigations: Burkhart Grob Flugzeugbau G103 TWIN ASTIR, 1998
2 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.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 2 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2005 | 3 |
| 2006 | 3 |
| 2007 | 2 |
| 2016 | 1 |
| 2024 | 3 |
| 2026 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 1998
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 year(c."eventDate") = 1998
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" DESCRun 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 DEN99LA028Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103 Twin Astir · Canon City, COThe glider pilot's failure to follow proper preflight procedures, and his failure to control the aircraft when the latch opened during flight. A factor was his failure to properly latch the canopy, and to utilize all available runway during the forced landing.NTSB FTW98LA244Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103 · Briggs, TXThe pilot's misjudgment of the distance and altitude. Factors were the lack of thermal lift and his diverted attention while on downwind.