# NTSB investigations: Evektor-Aerotechnik SPORTSTAR, MN

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB CEN14CA470](https://openairdocs.org/ntsb/CEN14CA470.md): Evektor-Aerotechnik Sportstar · Minneapolis, MN · Accident · No injuries · Data collection · Final report · Aug 31, 2014 · N821EV · Substantial damage
  > The pilot's loss of control while landing with a crosswind. Contributing to the accident was the pilot lack of experience flying in similar weather conditions.
- [NTSB CHI08LA228](https://openairdocs.org/ntsb/CHI08LA228.md): Evektor-Aerotechnik Sportstar · Maple Lake, MN · Accident · No injuries · Limited investigation · Final report · Jul 28, 2008 · N605EV · Substantial damage
  > The certified flight instructor's delayed remedial action to the encountered stall. Contributing to the accident was the student pilot's slow airspeed and inadvertent stall.
- [NTSB CHI07CA315](https://openairdocs.org/ntsb/CHI07CA315.md): Aerotechnik Sportstar-Evektor · Maple Lake, MN · Accident · Minor injuries · Data collection · Final report · Sep 30, 2007 · N806EV · Substantial damage
  > The student pilot's failure to relinquish the flight controls and the flight instructor's inadequate supervision which resulted in the certified flight instructor not being able to maintain directional control. Contributing factors included the student…

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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" = 'MN' 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 ('0600012', '05616UU'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=0600012&state=MN

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.
