# NTSB investigations: Type/qual of instruct/training

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 CEN23FA125](https://openairdocs.org/ntsb/CEN23FA125.md): Robinson Helicopter R44 · Port O'Connor, TX · Accident · 2 fatal · Class 3 · Field · Final report · Mar 7, 2023 · N494SH · Destroyed
  > The pilot’s initiation of the visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of helicopter control. Contributing to the accident was the pilot’s flicker vertigo during the flight.
- [NTSB DCA21LA096](https://openairdocs.org/ntsb/DCA21LA096.md): Bombardier CL-600-2C10 · Los Angeles, CA · Accident · Serious injuries · Class 4 · Limited · Final report · Mar 16, 2021 · N706SK · No damage
  > the improper retraction of the main cabin door, which resulted in the flight attendant falling when she opened the door at the destination.
- [NTSB WPR19MA177](https://openairdocs.org/ntsb/WPR19MA177.md): Beech 65-A90 · Mokuleia, HI · Accident · 11 fatal · Class 2 · Major · Final report · Jun 22, 2019 · N256TA · Destroyed
  > The pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…
- [NTSB CEN14LA036](https://openairdocs.org/ntsb/CEN14LA036.md): Cessna 182L · Superior, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 2, 2013 · N70520 · 2 aircraft · Destroyed
  > The failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.
- [NTSB CEN13LA342](https://openairdocs.org/ntsb/CEN13LA342.md): Cessna 150K · Morrilton, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 10, 2013 · N6412G · Substantial damage
  > The flight instructor's inadequate training and oversight of the student pilot, which resulted in the noncertificated student pilot's loss of control during landing.
- [NTSB CEN12LA414](https://openairdocs.org/ntsb/CEN12LA414.md): Cessna 172S · Glenwood Springs, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 2012 · N917SA · Substantial damage
  > The pilot's decision to fly into a mountainous area where conditions were such that the airplane was unable to climb above rising terrain. Contributing to the accident was the pilot's insufficient pilot-in-command experience and inadequate training in…
- [NTSB OPS11IA653](https://openairdocs.org/ntsb/OPS11IA653.md): Beech 1900C · Fairbanks, AK · Incident · No injuries · Incident investigation · Final report · Jun 14, 2011 · N121WV · 2 aircraft · No damage
  > Inadequate air traffic control actions that failed to establish and maintain required separation between the two airplanes. Contributing to the incident was inexperience on the part of the local controller, inadequate oversight by the tower…
- [NTSB OPS09IA009](https://openairdocs.org/ntsb/OPS09IA009.md): Bombardier DHC-8-202 · Cleveland, OH · Incident · No injuries · Incident investigation · Final report · Jun 26, 2009 · N375PH · 2 aircraft · No damage
  > The local controller did not visually scan the runways and ensure that the E145 had crossed runway 24L prior to issuing a takeoff clearance to the DH8, did not ensure separation between the two airplanes, and did not cancel takeoff clearance for the DH8 in a…

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

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