NTSB investigations: Evektor-Aerotechnik SPORTSTAR, 2012
5 cases on aircraft the registry lists as Evektor-Aerotechnik SPORTSTAR. 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
| 2007 | 5 |
|---|---|
| 2008 | 4 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 5 |
| 2013 | 2 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 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\") = 2012
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0600012', '05616UU'))
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") = 2012
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0600012', '05616UU'))
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 CEN12CA600Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Columbus, OHThe failure of the right main landing gear strut due to a preexisting crack.NTSB ERA12CA506Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Myerstown, PAThe student pilot's decision to continue the takeoff roll while trying to secure an open canopy and his subsequent failure to maintain directional control. Contributing to the accident was the student pilot's failure to complete the pretakeoff checklist.NTSB CEN12CA356Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Indianapolis, INThe student pilot’s failure to maintain control of the airplane during takeoff.NTSB ERA12CA302Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Lancaster, PAThe pilot's loss of directional control during the takeoff, and her delayed remedial action in aborting the takeoff after the loss of directional control.NTSB WPR12CA077Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · San Diego, CAThe pilot's inadequate directional control during the landing roll.