# Major NTSB investigations: NONE

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 DCA16MA204](https://openairdocs.org/ntsb/DCA16MA204.md): Kubicek BB85 · Lockhart, TX · Accident · 16 fatal · Class 1 · Major · Final report · Jul 30, 2016 · N2469L · Destroyed
  > The pilot's pattern of poor decision-making that led to the initial launch, continued flight in fog and above clouds, and descent near or through clouds that decreased the pilot's ability to see and avoid obstacles. Contributing to the accident were (1) the…
- [NTSB DCA15MA019](https://openairdocs.org/ntsb/DCA15MA019.md): Scaled Composites 339 · Koehn Dry Lake, CA · Accident · 1 fatal · Class 1 · Major · Final report · Oct 31, 2014 · N339SS · Destroyed
  > Scaled Composites' failure to consider and protect against the possibility that a single human error could result in a catastrophic hazard to the SpaceShipTwo vehicle. This failure set the stage for the copilot's premature unlocking of the feather system as a…
- [NTSB ATL88MA089](https://openairdocs.org/ntsb/ATL88MA089.md): British Aerospace 3101 · Springfield, OH · Accident · 3 fatal · Major investigation · Final report · Feb 9, 1988 · N823JS · Destroyed
  > A company designated instr and two f/o trainees were conducting a FAR 135 trng flt. The third apch was terminated with ago-around initiated over the rwy threshold at about 50 ft. after climbing to about 150 ft, the acft was observed to oscillate in yaw,…

## 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=00000&major=1

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