# Final NTSB investigations, 2018: Windshear or thunderstorm

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 ERA19LA073](https://openairdocs.org/ntsb/ERA19LA073.md): Learjet 35 · Key West, FL · Accident · No injuries · Class 3 · Limited · Final report · Dec 15, 2018 · N55FN · Substantial damage
  > The flight crew’s encounter with windshear during the landing flare, which resulted in a hard landing.
- [NTSB CEN18LA364](https://openairdocs.org/ntsb/CEN18LA364.md): Lindstrand 77A · Brookfield, MO · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2018 · N370LB · No damage
  > The pilot's inability to maintain control of the balloon after encountering high wind conditions and windshear during the landing, which resulted in his ejection from the basket and serious injury to the passenger during the balloon’s subsequent impact with…
- [NTSB GAA18CA488](https://openairdocs.org/ntsb/GAA18CA488.md): Cessna 185 · Brooks Range, AK · Accident · No injuries · Data collection · Final report · Aug 12, 2018 · N62882 · Substantial damage
  > The airplane's encounter with downdraft conditions during takeoff, which resulted in a subsequent loss of altitude and collision with terrain.
- [NTSB WPR18TA192](https://openairdocs.org/ntsb/WPR18TA192.md): Schempp Hirth Discus CS · Goldfield, NV · Accident · Serious injuries · Final report · Jul 11, 2018 · N104TH · Substantial damage
  > The glider’s encounter with atmospheric lift conditions that were not sufficient to maintain flight, which necessitated a forced landing on uneven terrain.
- [NTSB ERA18LA164](https://openairdocs.org/ntsb/ERA18LA164.md): Piper PA 44 · Daytona Beach, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 9, 2018 · N21161 · Substantial damage
  > The pilots’ improper in-flight weather evaluation and decision to continue the approach, which resulted in an encounter with a thunderstorm, a loss of airplane control, and collision with terrain. Contributing to the accident was the flight instructor’s…
- [NTSB ERA18LA157](https://openairdocs.org/ntsb/ERA18LA157.md): Piper PA 31 · Amagansett, NY · Accident · 4 fatal · Limited investigation · Final report · Jun 2, 2018 · N41173 · Destroyed
  > The pilot's decision to fly under a thunderstorm and a subsequent encounter with turbulence and restricted visibility in heavy rain, which resulted in a loss of control.

## 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 year(c."eventDate") = 2018
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '390' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/390/sequence?status=final&year=2018

---
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.
