# NTSB investigations: Experience/knowledge, general

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 DCA22LA175](https://openairdocs.org/ntsb/DCA22LA175.md): Boeing 777 · Chicago, IL · Accident · No injuries · Class 4 · Limited · Final report · Aug 6, 2022 · A7-BFH · Substantial damage
  > The ground controller’s inappropriate routing of the B777 through a non-movement area, resulting in the airplane’s right wingtip contacting a light pole. Contributing to the accident was the lack of an appropriate display of taxiway BB2 as a restricted…
- [NTSB ERA19FA210](https://openairdocs.org/ntsb/ERA19FA210.md): Agusta AW139 · Big Grand Cay, Bahamas · Accident · 7 fatal · Class 2 · Field · Final report · Jul 4, 2019 · N32CC · Substantial damage
  > The pilots’ decision to takeoff over water in dark night conditions with no external visual reference, which resulted in spatial disorientation and subsequent collision with the water. Also causal was the pilots’ failure to adequately monitor their…
- [NTSB DCA19MA086](https://openairdocs.org/ntsb/DCA19MA086.md): Boeing 767 · Trinity Bay, TX · Accident · 3 fatal · Class 1 · Major · Final report · Feb 23, 2019 · N1217A · Destroyed
  > The inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…
- [NTSB ERA16LA330](https://openairdocs.org/ntsb/ERA16LA330.md): Tatkovsky James G Safari · Andover, NH · Accident · Serious injuries · Limited investigation · Final report · Sep 27, 2016 · N330JT · Destroyed
  > The noncertificated pilot’s failure to maintain helicopter control during initial climb.
- [NTSB WPR13FA183](https://openairdocs.org/ntsb/WPR13FA183.md): Cessna 182C · Circle, MT · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2013 · N8721T · Destroyed
  > The pilot’s failure to maintain airplane control as a result of spatial disorientation. Contributing to the accident was the pilot’s decision to continue flight into low visibility conditions.
- [NTSB CEN10LA491](https://openairdocs.org/ntsb/CEN10LA491.md): Schneider Christen Eagle II · Clearwater, MN · Accident · 2 fatal · Limited investigation · Final report · Aug 22, 2010 · N222ET · Substantial damage
  > The pilot's failure to maintain aircraft control and his improper decision to perform aerobatic maneuvers without proper experience or training in aerobatic flight. Also causal was his conduct of aerobatic flight in an airplane loaded outside its weight and…
- [NTSB OPS10IA132](https://openairdocs.org/ntsb/OPS10IA132.md): Boeing 737-7H4 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Apr 28, 2010 · N242WN · 2 aircraft · No damage
  > The failure of the local controller to issue control instructions necessary to ensure positive control/standard separation of traffic operating within the Class B airspace.
- [NTSB CEN10FA113](https://openairdocs.org/ntsb/CEN10FA113.md): Aerospatiale AS350 · El Paso, TX · Accident · 3 fatal · Field investigation · Final report · Feb 6, 2010 · N157BC · Substantial damage
  > The pilot's loss of situational awareness resulting in controlled flight into terrain. Contributing to the accident was the pilot's unfamiliarity with the hazards of a low-contrast area while using night vision goggles.
- [NTSB CEN09CA432](https://openairdocs.org/ntsb/CEN09CA432.md): Remos Remos G-3/ · Erie, CO · Accident · No injuries · Data collection · Final report · Jul 12, 2009 · N408RA · Substantial damage
  > The student pilot's improper recovery from a bounced landing and the flight instructor's delayed reaction to take control and recover.
- [NTSB ERA09CA119](https://openairdocs.org/ntsb/ERA09CA119.md): Cessna 172SP · Lancaster, NY · Accident · No injuries · Data collection · Final report · Jan 1, 2009 · N2228L · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff. Contributing to the accident was the student pilot's lack of solo flight experience and the snow bank located off the left side of the runway.

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

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