# Final NTSB investigations, ND: Temp/humidity/pressure

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 CEN23LA233](https://openairdocs.org/ntsb/CEN23LA233.md): Piper PA-25-235 · Carrington, ND · Accident · No injuries · Class 3 · Limited · Final report · Jun 3, 2023 · N8843L · Substantial damage
  > A total loss of engine power as a result of carburetor ice that formed while the engine was operating at a low power setting for an extended period of time before departure.
- [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 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 CEN14LA074](https://openairdocs.org/ntsb/CEN14LA074.md): Piper PA 28-181 · Rock Lake, ND · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2013 · N6780F · Substantial damage
  > The noninstrument-rated pilot’s failure to obtain weather briefings immediately before and during the flight and his continued flight into icing conditions, which resulted in the airplane’s loss of performance and the subsequent controlled descent into trees…

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

This list as a web page: https://openairdocs.org/ntsb-findings/030310/cases?state=ND&status=final

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