# NTSB investigations, NE: Dark

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 CEN23FA077](https://openairdocs.org/ntsb/CEN23FA077.md): Cessna 150H · Auburn, NE · Accident · 2 fatal · Class 3 · Field · Final report · Jan 12, 2023 · N22859 · Substantial damage
  > The flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.
- [NTSB CEN21FA150](https://openairdocs.org/ntsb/CEN21FA150.md): Aviat A-1B · Berwyn, NE · Accident · 1 fatal · Class 3 · Field · Final report · Mar 6, 2021 · N166WW · Destroyed
  > A loss of control and subsequent impact with terrain as a result of spatial disorientation during cruise in dark night conditions.
- [NTSB DEN08CA117](https://openairdocs.org/ntsb/DEN08CA117.md): Cessna T182T · Omaha, NE · Accident · No injuries · Data collection · Final report · Jun 13, 2008 · N2164Y · Substantial damage
  > The pilot's improper use of the elevator trim resulting in a nose low/hard landing.

## 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" = 'NE' 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", '03036020'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03036020/cases?state=NE

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