# NTSB investigations, 2018, ND: Environmental issues

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 CEN19LA039](https://openairdocs.org/ntsb/CEN19LA039.md): Cessna 550 · Fargo, ND · Accident · Minor injuries · Limited investigation · Final report · Nov 30, 2018 · N941JM · Substantial damage
  > The pilot's failure to lower the flaps during the approach and maintain sufficient airspeed while flying in instrument meteorological and icing conditions and the accumulation of ice on the wings’ leading edges, which resulted in the exceedance of the…
- [NTSB CEN19FA030](https://openairdocs.org/ntsb/CEN19FA030.md): Cessna 441 · Harmon, ND · Accident · 3 fatal · Class 2 · Field · Final report · Nov 18, 2018 · N441CX · Destroyed
  > The pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.
- [NTSB GAA18CA563](https://openairdocs.org/ntsb/GAA18CA563.md): Air Tractor AT802 · Napoleon, ND · Accident · Serious injuries · Data collection · Final report · Sep 21, 2018 · N968JB · Substantial damage
  > The pilot’s failure to maintain clearance from a power line pole during an agricultural application flight.
- [NTSB CEN18FA277](https://openairdocs.org/ntsb/CEN18FA277.md): Cessna 152 · Fort Rice, ND · Accident · 1 fatal · Class 2 · Field · Final report · Jul 17, 2018 · N24515 · Substantial damage
  > The pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…
- [NTSB GAA18CA241](https://openairdocs.org/ntsb/GAA18CA241.md): Aeronca 65 LB · Carrington, ND · Accident · No injuries · Data collection · Final report · Apr 28, 2018 · N34459 · Substantial damage
  > The pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.

## 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."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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