# NTSB investigations, OK: Aircraft maintenance event

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 CEN24LA308](https://openairdocs.org/ntsb/CEN24LA308.md): Cirrus Design SR22T · Tulsa, OK · Incident · No injuries · Class 3 · Limited · Final report · Aug 3, 2024 · N825JC · Substantial damage
  > The mechanic’s improper installation of the alternator wiring connections, which resulted in electrical arcing and thermal damage to the airplane.
- [NTSB CEN21LA218](https://openairdocs.org/ntsb/CEN21LA218.md): Cessna R182 · Tulsa, OK · Accident · No injuries · Class 4 · Limited · Final report · May 13, 2021 · N8051B · Substantial damage
  > The pilot’s inability to extend the main landing gear due to incomplete maintenance, which resulted in a partial wheels-up landing and the mechanic’s failure to follow proper maintenance procedures that led to the loss of main landing gear system hydraulic…
- [NTSB CEN16LA184](https://openairdocs.org/ntsb/CEN16LA184.md): Cessna 150F · Ponca City, OK · Accident · Serious injuries · Limited investigation · Final report · May 1, 2016 · N8619G · Substantial damage
  > Maintenance personnel's improper installation of the elevator bolt, which resulted in a loss of elevator control during landing.
- [NTSB CEN12LA299](https://openairdocs.org/ntsb/CEN12LA299.md): Piper PA-24-250 · Shawnee, OK · Accident · No injuries · Limited investigation · Final report · May 14, 2012 · N7171P · Substantial damage
  > The improper installation of the mixture cable by maintenance personnel, which allowed the mixture cable to entangle with the landing gear during gear extension and led to the subsequent loss of engine power.

## 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" = 'OK' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '040' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/040/sequence?state=OK

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