# NTSB investigations, NE: Maintenance/inspections

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 CEN20LA041](https://openairdocs.org/ntsb/CEN20LA041.md): Cessna 525A · Scotts Bluff, NE · Accident · No injuries · Class 3 · Limited · Final report · Dec 18, 2019 · CGOJG · Substantial damage
  > The installation of incorrect mounting hardware to secure the right engine cowl, which resulted in an in-flight separation and impact with the horizontal stabilizer and elevator.
- [NTSB CEN18CA072](https://openairdocs.org/ntsb/CEN18CA072.md): Bell Helicopter Textron Canada 407 · Norfolk, NE · Accident · No injuries · Data collection · Final report · Jan 5, 2018 · N214AM · Substantial damage
  > Maintenance personnel’s failure to properly secure the tail rotor drive shaft cover, which resulted in the cover departing the helicopter in flight.
- [NTSB CEN09LA444](https://openairdocs.org/ntsb/CEN09LA444.md): Beech TC-45J · Verdel, NE · Accident · 1 fatal · Limited investigation · Final report · Jul 19, 2009 · N6688 · Destroyed
  > The pilot's improper decision to fly an airplane that was not airworthy and for which he was not properly rated to operate, and his failure to maintain control of the airplane during a forced landing to a field following an engine failure. Contributing to the…

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

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