# NTSB investigations: Document/info production

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 ERA24LA099](https://openairdocs.org/ntsb/ERA24LA099.md): Swissdrones Operating SDO 50 V2 · Antioch, GA · Accident · No injuries · Class 3 · Limited · Final report · Jan 18, 2024 · N780PA · Substantial damage
  > A partial loss of engine power due to a reduction of fuel flow for undetermined reasons. Contributing to the accident was the UAS manufacturer’s lack of instructions for a partial loss of engine power landing.
- [NTSB DCA22MA193](https://openairdocs.org/ntsb/DCA22MA193.md): Dehavilland DHC-3 · Freeland, WA · Accident · 10 fatal · Class 1 · Major · Final report · Sep 4, 2022 · N725TH · Destroyed
  > The in-flight unthreading of the clamp nut from the horizontal stabilizer trim actuator barrel due to a missing lock ring, which resulted in the horizontal stabilizer moving to an extreme trailing-edge-down position rendering the airplane’s pitch…
- [NTSB ENG21LA011](https://openairdocs.org/ntsb/ENG21LA011.md): Cessna 501 · Opa Locka, FL · Incident · No injuries · Class 3 · Limited · Final report · Dec 31, 2020 · N75TL · Minor damage
  > An uncontained left engine failure caused by a low cycle fatigue crack that originated from a manufacturing machining groove on the high pressure compressor impeller aft face. Contributing to the incident was service bulletin borescope inspection criteria…
- [NTSB DCA18LA163](https://openairdocs.org/ntsb/DCA18LA163.md): Airbus A330 323 · Atlanta, GA · Accident · No injuries · Class 3 · Limited · Final report · Apr 18, 2018 · N806NW · Substantial damage
  > The flight crew’s delayed landing after an in-flight engine fire, which reignited after both fire bottles were discharged and resulted in substantial damage to an engine pylon. Contributing to the delayed landing was likely the flight crew’s perception that…
- [NTSB CEN17LA156](https://openairdocs.org/ntsb/CEN17LA156.md): Loomis Xenon 4 · Knoxville, IA · Accident · No injuries · Limited investigation · Final report · Apr 17, 2017 · N912XV · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information. Contributing to the accident was the failure of the owners to obtain proper materials regarding the operation and maintenance of the engine.
- [NTSB ANC17FA009](https://openairdocs.org/ntsb/ANC17FA009.md): Bellanca 7GCBC · Fairbanks, AK · Accident · 1 fatal · Class 3 · Field · Final report · Dec 7, 2016 · N88452 · Substantial damage
  > The pilot’s decision to operate the airplane at an altitude too low to allow for recovery from an intentional aerodynamic stall. Contributing to the accident was the pilot’s lack of knowledge of the stall performance characteristics of the airplane modified…
- [NTSB WPR11LA080](https://openairdocs.org/ntsb/WPR11LA080.md): Schaefer Kitfox 4 · Glendale, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2010 · N95FT · Substantial damage
  > The pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…
- [NTSB ERA10LA450](https://openairdocs.org/ntsb/ERA10LA450.md): Air Tractor AT402 · Pompano Beach, FL · Accident · No injuries · Limited investigation · Final report · Aug 28, 2010 · N4172U · Substantial damage
  > The pilot's delayed decision to abort the takeoff, which resulted in a runway overrun and a subsequent collision with obstacles and terrain. Contributing to the accident was the airplane's high gross weight.
- [NTSB ERA10LA357](https://openairdocs.org/ntsb/ERA10LA357.md): Beech 58 · LaGrange, GA · Accident · No injuries · Limited investigation · Final report · Jul 11, 2010 · N405RW · Substantial damage
  > The pilot not allowing sufficient time for fuel spill vapors to dissipate before starting the engine. Contributing to the accident was the inadequate maintenance of the fuel cap.
- [NTSB WPR10LA276](https://openairdocs.org/ntsb/WPR10LA276.md): Czech Aircraft Works Sportcruiser · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 2, 2010 · N334BB · Substantial damage
  > The inadvertent opening of the aircraft canopy during the takeoff climb, which distracted the pilot and resulted in his failure to maintain aircraft control. Contributing to the accident was a lack of guidance in the manufacturer's pilot operating handbook…
- [NTSB ANC09GA040](https://openairdocs.org/ntsb/ANC09GA040.md): Robinson Helicopter R44 · Iliamna, AK · Accident · No injuries · Final report · May 12, 2009 · N7196H · Substantial damage
  > The main rotor transmission mount design, which resulted in an in-flight vibration/oscillation, and damage to the helicopter during an emergency descent and hard landing. Contributing to the accident was the lack of information from the manufacturer regarding…
- [NTSB WPR09IA070](https://openairdocs.org/ntsb/WPR09IA070.md): MD Helicopter MD 900 · Kamuela, HI · Incident · No injuries · Incident investigation · Final report · Dec 28, 2008 · N902AF · Minor damage
  > The separation of the endplate bolts for undetermined reasons, resulting in an in-flight separation of the right endplate. Contributing to the accident was the manufacturer's failure to provide sufficient guidance for endplate bolt installation.
- [NTSB CEN09FA094](https://openairdocs.org/ntsb/CEN09FA094.md): Bombardier CL-600-2C10 · Chicago, IL · Incident · No injuries · Field investigation · Final report · Dec 16, 2008 · N511MJ · Minor damage
  > The failure of the left landing gear to extend due to improper maintenance when the landing gear door was replaced. Contributing to the incident was the manufacturer's inadequate maintenance manual instructions.
- [NTSB CHI08IA292](https://openairdocs.org/ntsb/CHI08IA292.md): Boeing 757-223 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 22, 2008 · N197AN · Minor damage
  > The failure of an electrical relay due to eroded contacts and the flight crew's decision to continue a flight that was operating on battery power.
- [NTSB DEN08FA140](https://openairdocs.org/ntsb/DEN08FA140.md): Aircraft Mfg & Dev. CH601XLi · Farmersville, TX · Accident · Serious injuries · Field investigation · Final report · Aug 14, 2008 · N451BB · Substantial damage
  > The inadvertent tail stall and subsequent loss of airplane control as a result of the open canopy. Contributing to the accident was the inadequate emergency procedures provided by the airplane manufacturer and the inadequate design of the canopy latching…

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

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