# NTSB investigations: Lycoming AEIO-540 series, NE

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 DEN08FA100](https://openairdocs.org/ntsb/DEN08FA100.md): Extra Flugzeugbau EA 300/L · Gothenburg, NE · Accident · 1 fatal · Field investigation · Final report · Jun 5, 2008 · N12XT · Destroyed
  > The pilot's failure to maintain aircraft control after encountering instrument meteorological conditions. Contributing to the accident were the pilot's recent usage of Marihuana, his impaired judgement and decision making, and the low visibility weather…
- [NTSB CHI92LA190](https://openairdocs.org/ntsb/CHI92LA190.md): Pitts S2B · Aurora, NE · Accident · No injuries · Limited investigation · Final report · Jun 27, 1992 · N92BT · Destroyed
  > The pilot-in-command's restricted visual lookout from smoke entering the cockpit. Factors were smoke in the cockpit which resulted in the pilot becoming disoriented.

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41568'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41568&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.