# NTSB investigations: Time limits

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 CEN25LA013](https://openairdocs.org/ntsb/CEN25LA013.md): Rotorway Exec · Plymouth, IN · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 11, 2024 · N314AC · Substantial damage
  > A loss of control due to the failed forward tail rotor belt as a result of the owner’s failure to follow the helicopter manufacturer’s tail rotor belt replacement recommendations.
- [NTSB WPR24LA260](https://openairdocs.org/ntsb/WPR24LA260.md): Kitfox Series V · La Grande, OR · Accident · No injuries · Class 3 · Limited · Final report · Jul 23, 2024 · N53562 · Substantial damage
  > Separation of the propeller blades from progressive damage at the blade roots due to overtightening of the hub bolts.
- [NTSB WPR23LA160](https://openairdocs.org/ntsb/WPR23LA160.md): Remos Remos GX · Glendale, AZ · Accident · No injuries · Class 3 · Limited · Final report · Apr 18, 2023 · N21GX · Substantial damage
  > A total loss of engine power caused by fatigue cracking and fracture of the crankshaft. Contributing to the accident was the operator’s failure to properly maintain the airplane.
- [NTSB CEN23LA040](https://openairdocs.org/ntsb/CEN23LA040.md): Cessna 150L · Cypress, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 20, 2022 · N10612 · Substantial damage
  > Failure of the engine exhaust valve during cruise flight, which resulted in a loss of engine power and a forced landing.
- [NTSB ERA22LA139](https://openairdocs.org/ntsb/ERA22LA139.md): Cessna 152 · Madisonville, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 28, 2022 · N68218 · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB WPR19LA128](https://openairdocs.org/ntsb/WPR19LA128.md): Beech 35 · Sedona, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 1, 2019 · N6864Q · Substantial damage
  > The partial loss of engine power due to deteriorated O-rings in the throttle metering assembly. Contributing to the accident was non-compliance with the manufacturer's recommended throttle metering assembly overhaul schedule.
- [NTSB CEN18LA114](https://openairdocs.org/ntsb/CEN18LA114.md): Beech 77 · Odessa, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2018 · N6699B · Substantial damage
  > The pilot’s improper takeoff procedures and his failure to abort the takeoff, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of experience in the airplane.
- [NTSB CEN17LA351](https://openairdocs.org/ntsb/CEN17LA351.md): Cessna 340 · McKinney, TX · Accident · No injuries · Limited investigation · Final report · Sep 9, 2017 · N5870M · Substantial damage
  > The failure of the bell crank pivot bolt which resulted in the left main landing gear collapse. Contributing to the accident was the lack of landing gear inspections in accordance with the airplane manufacturer's maintenance manuals.
- [NTSB CEN17LA309](https://openairdocs.org/ntsb/CEN17LA309.md): Air Tractor AT-802A · Galesburg, IL · Accident · No injuries · Class 3 · Limited · Final report · Aug 9, 2017 · N528MB · Substantial damage
  > A total loss of engine power due to the fracture of a single 1st stage compressor rotor airfoil in high-cycle fatigue as a result of the erosion and thinning of the airfoil's leading edge. Contributing to the fractured airfoil and loss of engine power was the…
- [NTSB WPR15LA025](https://openairdocs.org/ntsb/WPR15LA025.md): Cessna 172S · Santa Monica, CA · Accident · No injuries · Limited investigation · Final report · Oct 26, 2014 · N353MV · Substantial damage
  > The separation of a section of a propeller blade due to fatigue cracking. Contributing to the accident was the operator’s failure to comply with the manufacturer’s maintenance and inspection instructions.
- [NTSB WPR14LA118](https://openairdocs.org/ntsb/WPR14LA118.md): Cessna P210N · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Feb 23, 2014 · N18DP · Substantial damage
  > Fuel starvation due to the in-flight loosening of the fuel lines attached to the fuel flow indicator as a result of inadequate maintenance.
- [NTSB ERA12LA574](https://openairdocs.org/ntsb/ERA12LA574.md): Cessna 150G · Corinth, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 2012 · N8465J · Substantial damage
  > The improper torque application on the crankshaft gear bolt by maintenance personnel during an engine overhaul, which resulted in the fatigue failure of the locking tab washer and gear alignment dowel and subsequent engine stoppage. Contributing to the…
- [NTSB ERA10LA486](https://openairdocs.org/ntsb/ERA10LA486.md): Piper PA-28R-200 · Barnwell, SC · Accident · No injuries · Limited investigation · Final report · Sep 19, 2010 · N799SQ · Substantial damage
  > The failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.
- [NTSB CEN10CA147](https://openairdocs.org/ntsb/CEN10CA147.md): Piper PA-28-140 · Martinsville, IN · Accident · No injuries · Data collection · Final report · Mar 6, 2010 · N6852W · Substantial damage
  > The pilot's inadequate preflight planning and his exceedance of the airplane's takeoff capability.
- [NTSB ERA09FA526](https://openairdocs.org/ntsb/ERA09FA526.md): Piper PA-32R-301T · Fort Lauderdale, FL · Accident · 4 fatal · Field investigation · Final report · Sep 20, 2009 · N2467Y · Substantial damage
  > Fatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…
- [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…
- [NTSB ERA09LA272](https://openairdocs.org/ntsb/ERA09LA272.md): Cessna 172 · Chesterfield, SC · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 2009 · N9884Q · Substantial damage
  > The partial loss of engine power due to a broken exhaust valve. Contributing to the accident was the operator's exceedance of the engine manufacturer's recommended time before overhaul.

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

This list as a web page: https://openairdocs.org/ntsb-findings/01010510/cases

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