# NTSB investigations: Rotax 912ULS2: Landing flare

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 WPR23LA209](https://openairdocs.org/ntsb/WPR23LA209.md): Pipistrel Doo Ajdovscina Virus SW · Santa Fe, NM · Accident · Minor injuries · Class 4 · Limited · Final report · May 30, 2023 · N69PV · Substantial damage
  > An encounter with a downdraft during landing that resulted in a hard landing and the pilot’s loss of control.
- [NTSB CEN22LA369](https://openairdocs.org/ntsb/CEN22LA369.md): ICP Savannah S · Evansville, IN · Accident · No injuries · Class 4 · Limited · Final report · Jul 29, 2022 · N5200S · Substantial damage
  > The pilot’s improper landing flare in gusting winds, which resulted in a hard landing and the nose gear collapsing.
- [NTSB ERA20CA215](https://openairdocs.org/ntsb/ERA20CA215.md): Pipistrel Pipistrel Sinus 912 · Brookline, NH · Accident · No injuries · Class 4 · Data collection · Final report · Jun 13, 2020 · N783TH · Substantial damage
  > The pilot's failure to maintain airspeed while landing with a quartering tailwind, which resulted in a loss of control and a hard landing.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('55599')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '01062041')))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/01062041/cases?engine=55599

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
