# NTSB investigations: Design of document/info

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 WPR19FA230](https://openairdocs.org/ntsb/WPR19FA230.md): Cessna 560XL · Oroville, CA · Accident · No injuries · Class 3 · Field · Final report · Aug 21, 2019 · N91GY · Destroyed
  > The pilot’s failure to release the parking brake before attempting to initiate the takeoff, which produced an unexpected retarding force and airplane nose down pitching moment. Also causal was the flight crew’s delayed decision to abort the takeoff, which…
- [NTSB CEN15MA290](https://openairdocs.org/ntsb/CEN15MA290.md): Airbus Helicopters AS350B3E · Frisco, CO · Accident · 1 fatal · Class 1 · Major · Final report · Jul 3, 2015 · N390LG · Destroyed
  > Airbus Helicopters' dual-hydraulic AS350 B3e helicopter's (1) preflight hydraulic check, which depleted hydraulic pressure in the tail rotor hydraulic circuit, and (2) lack of salient alerting to the pilot that hydraulic pressure was not restored before…
- [NTSB WPR13LA396](https://openairdocs.org/ntsb/WPR13LA396.md): Flight Design Ctsw · Sisters, OR · Accident · No injuries · Limited investigation · Final report · Sep 2, 2013 · N102HA · Substantial damage
  > The pilot's inadequate preflight fuel planning and poor decision-making, which resulted in fuel exhaustion and the subsequent loss of engine power. Contributing to the accident was the lack of documentation describing the limitations of the airplane’s fuel…
- [NTSB DCA13CA035](https://openairdocs.org/ntsb/DCA13CA035.md): Mcdonnell Douglas MD-11F · Memphis, TN · Accident · Minor injuries · Data collection · Final report · Dec 26, 2012 · N612FE · Substantial damage
  > the operator's failure to provide appropriate training and documentation for ground personnel, leading the marshaller to inadvertently guide the airplane into the collision.
- [NTSB ENG12IA004](https://openairdocs.org/ntsb/ENG12IA004.md): Bombardier CL600 2C10 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Oct 23, 2011 · N751EV · No damage
  > The Start Operability Bleed Valve (OBV) fuel return adapter-fitting fractured and separated in cyclic fatigue, which allowed fuel to spill onto a hot engine case that ignited the undercowl fire. The OBV fuel adapter-fitting was dropped and the damage reduced…
- [NTSB ERA11LA507](https://openairdocs.org/ntsb/ERA11LA507.md): Mitsubishi MU-2B-25 · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Sep 28, 2011 · N344KL · Substantial damage
  > The improper installation of the nose landing gear strut and subsequent collapse of the nose landing gear during landing.
- [NTSB ENG11IA035](https://openairdocs.org/ntsb/ENG11IA035.md): Boeing 757-232 · Atlanta, GA · Incident · Minor injuries · Incident investigation · Final report · Jun 21, 2011 · N6714Q · No damage
  > Fuel leaking from the fuel flow transmitter that ignited on contact with the engine’s hot cases which resulted in an engine undercowl fire. The fuel leak resulted from the fuel flow transmitter end housing backing off from the main housing, creating a gap…
- [NTSB WPR10FA384](https://openairdocs.org/ntsb/WPR10FA384.md): Cessna 172 · Roche Harbor, WA · Accident · Minor injuries · Field investigation · Final report · Aug 6, 2010 · N9730H · Substantial damage
  > The pilot’s failure to attain an adequate climb airspeed due to his use of flaps for takeoff, and his selection of a runway, which resulted in an uphill, and possibly downwind, takeoff and subsequent collision with a known obstacle. Contributing to the…
- [NTSB WPR10CA224](https://openairdocs.org/ntsb/WPR10CA224.md): Evolution Trikes Revo · Eleele, HI · Accident · No injuries · Data collection · Final report · Apr 19, 2010 · N98EV · Substantial damage
  > A loss of engine power as a result of fuel exhaustion due to the pilot's improper decision to continue the flight after the low fuel warning. Contributing to the accident was the typographical error in the flight manual concerning the unusable fuel quantity.
- [NTSB DCA10IA021](https://openairdocs.org/ntsb/DCA10IA021.md): Airbus Industrie A319-131 · Newark, NJ · Incident · Minor injuries · Incident investigation · Final report · Jan 10, 2010 · N816UA · Minor damage
  > A mechanical failure of internal components of the right main landing gear door actuator resulting in the flight crew being unable to fully extend the right main landing gear using the normal and alternate procedures. Contributing to this incident was a…
- [NTSB WPR09LA075](https://openairdocs.org/ntsb/WPR09LA075.md): Czech Aircraft Works Sport Cruiser · Casa Grande, AZ · Accident · No injuries · Limited investigation · Final report · Jan 6, 2009 · N797BS · Substantial damage
  > The pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.

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

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