NTSB investigations: Airborne Windsports PTY EDGE XT-912-L
6 cases on aircraft the registry lists as Airborne Windsports PTY EDGE XT-912-L, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2018 | 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 ('060003A', '05902IC')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 ('060003A', '05902IC')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA18LA089Accident · 1 fatalClass 2 · LimitedFinal reportAirborne Windsports PTY Edge XT 912 L · Eustis, FLThe pilot's exceedance of the weight-shift-control aircraft's critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and collision with terrain. Contributing to the accident was the pilot's lack of experience in the…NTSB WPR17FA033Accident · 1 fatalField investigationFinal reportAirborne Windsports PTY Edge XT-912-L · Santa Barbara, CAThe pilot's failure to maintain aircraft control while maneuvering in the traffic pattern.NTSB GAA17CA004Accident · Serious injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 L · Fort Valley, GAThe failure of the aircraft’s right overcenter washout strut split ring, which resulted in the pilot’s inability to maintain lateral control of the aircraft and subsequent ground impact.NTSB ERA15CA020Accident · No injuriesData collectionFinal reportAirborne Windsports PTY Edge XT 912 L · Sebring, FLThe student pilot's inadvertent interference with the weight-shift capability of the airplane during the initial climb, resulting in a loss of airplane control and hard landing.NTSB WPR11FA138Accident · 2 fatalField investigationFinal reportAirBorne WindSport Edge XT-912-L · Hanapepe, HIThe flight instructor did not maintain aircraft control while maneuvering at low altitude. Contributing to the accident was the inadvertent application of the choke, which resulted in a momentary interruption of engine power.NTSB WPR09LA386Accident · Serious injuriesLimited investigationFinal reportAirborne Windsports PTY XT-912-L · Lihue, HIThe flight instructor's failure to maintain control of the airplane following an in-flight encounter with turbulence during descent.