NTSB investigations: Glasflugel H 301 B LIBELLE
9 cases on aircraft the registry lists as Glasflugel H 301 B LIBELLE. 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
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1984 | 1 |
| 1998 | 1 |
| 2014 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3800339'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3800339'))
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 CEN14CA409Accident · Minor injuriesData collectionFinal reportGlasflugel H 301 B Libelle · Brenham, TXThe pilot's attempt to maneuver away from power lines during a forced landing, which resulted in a collision with a tree and a fence.NTSB LAX98LA289Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Tucson, AZFailure of the pilot to properly connect the aileron controls during reassembly of the glider, and, his inadequate preflight inspection of the glider.NTSB LAX84LA431Accident · Minor injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Carefree, AZThe acft veered off the rwy during takeoff and collided with a parked unoccupied Beech 35. According to the glider plt, the aero tow began normally. After about 50 ft of ground run his wing runner let go. The wings remained level for about another 50 ft then…NTSB DEN76DQG01Accident · No injuriesClosedGlasflugel H301B · Hobbs, NMNTSB IAD75AI027Accident · 1 fatalClosedGlasflugel H301B · Fredrick, MDNTSB IAD73DKM48Accident · Minor injuriesClosedGlasflugel H301B · Cherryville, NDNTSB NYC72DKM31Accident · No injuriesClosedGlasflugel H301B · Terrell, NCNTSB MIA70DLG11Accident · Minor injuriesClosedGlasflugel H-301B · Clover, SCNTSB DEN70D0052Accident · No injuriesClosedGlasfugel H301B · Edgewood, NM