# 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 DCA18RA253](https://openairdocs.org/ntsb/DCA18RA253.md): Embraer ERJ190 · Durango, Mexico · Accident · Serious injuries · Foreign investigation · Jul 31, 2018 · XA-GAL · Destroyed
  > The Director General of Civil Aviation (DGAC) of Mexico has notified the NTSB of an accident involving an Embraer E-190, which occurred on July 31, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC investigation under the…
- [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 DCA18WA223](https://openairdocs.org/ntsb/DCA18WA223.md): Mcdonnell Douglas MD80 · Zhuliany, Ukraine · Accident · No injuries · Foreign investigation · Jun 14, 2018 · UR-CPR · Substantial damage
  > The government of Ukraine has notified the NTSB of an accident involving a MCDONNELL DOUGLAS MD80 airplane that occurred on June 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Ukraine's investigation under the…
- [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."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?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.