# NTSB investigations, 2018: Medical event

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 WPR19IA030](https://openairdocs.org/ntsb/WPR19IA030.md): Cessna 208 · Bakersfield, CA · Incident · Minor injuries · Class 3 · Incident · Final report · Nov 24, 2018 · N781FE · No damage
  > The pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…
- [NTSB WPR19LA013](https://openairdocs.org/ntsb/WPR19LA013.md): Robinson R44 · Kaneohe, HI · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 23, 2018 · N4132H · Substantial damage
  > The pilot’s sudden incapacitation from an undiagnosed heart condition during flight, which resulted in a hard landing.
- [NTSB CEN18LA274](https://openairdocs.org/ntsb/CEN18LA274.md): Cessna 150 · Lakeview, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 2018 · N50183 · Substantial damage
  > The student pilot’s impairment by alcohol and multiple medications, which led to his failure to maintain obstacle clearance during takeoff and the subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and…
- [NTSB DCA18WA171](https://openairdocs.org/ntsb/DCA18WA171.md): Boeing 737 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · May 2, 2018 · HS-KMA · No damage
  > The Air Accident Investigation Committee of Thailand has notified the NTSB of a serious incident involving a BOEING 737 airplane that occurred on May 02, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Thailand's…

## 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" = '850' 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/850/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.