# NTSB investigations, 2018: Development

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 ENG19IA008](https://openairdocs.org/ntsb/ENG19IA008.md): Airbus A220 · Busan, South Korea · Incident · Class 3 · Incident · Final report · Dec 26, 2018 · HL8314 · No damage
  > The manufacturer’s inadequate cleaning of the crucible before melting the nickel alloy used in casting the low pressure turbine stage 3 blades that resulted in a casting anomaly from where an intergranular crack occurred became the origin of a fatigue crack…
- [NTSB ERA18LA134](https://openairdocs.org/ntsb/ERA18LA134.md): Stanley Ernie Sigurd Kolb Mark · Collegedale, TN · Accident · 1 fatal · Limited investigation · Final report · Apr 20, 2018 · N9123R · Destroyed
  > The pilot's loss of airplane control, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's improper decision to take off in the nonairworthy airplane in which he had no training and his lack of flight experience in the 17…
- [NTSB DCA18LA163](https://openairdocs.org/ntsb/DCA18LA163.md): Airbus A330 323 · Atlanta, GA · Accident · No injuries · Class 3 · Limited · Final report · Apr 18, 2018 · N806NW · Substantial damage
  > The flight crew’s delayed landing after an in-flight engine fire, which reignited after both fire bottles were discharged and resulted in substantial damage to an engine pylon. Contributing to the delayed landing was likely the flight crew’s perception that…
- [NTSB ERA18LA117](https://openairdocs.org/ntsb/ERA18LA117.md): Stanley Lancair · Sebring, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 28, 2018 · C-GSQQ · Substantial damage
  > The failure of ground personnel to obtain permission from airport management to conduct engine test runs; adequately monitor the area behind the B737 for traffic; and install barricades to prevent access behind the running airplane, which resulted in the…
- [NTSB ANC18LA018](https://openairdocs.org/ntsb/ANC18LA018.md): Costruzioni Aeronautiche Tecna P2006 · Lynchburg, VA · Accident · No injuries · Class 2 · Limited · Final report · Jan 1, 2018 · N594MA · Substantial damage
  > The failure of the left main landing gear assembly due to a fatigue fracture along the inside circumferential weld on the trailing arm’s attachment flange, which resulted from the manufacturer’s inadequate welding of the trailing arm connecting the lower arm…

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0401'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/0401/cases?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.
