# Major NTSB investigations: Preflight or dispatch event

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 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 ERA14MA271](https://openairdocs.org/ntsb/ERA14MA271.md): Gulfstream Aerospace G IV · Bedford, MA · Accident · 7 fatal · Class 1 · Major · Final report · Jun 1, 2014 · N121JM · Destroyed
  > The flight crewmembers' failure to perform the flight control check before takeoff, their attempt to take off with the gust lock system engaged, and their delayed execution of a rejected takeoff after they became aware that the controls were locked.…
- [NTSB DCA13MA121](https://openairdocs.org/ntsb/DCA13MA121.md): Dehavilland DHC-3 · Soldotna, AK · Accident · 10 fatal · Major investigation · Final report · Jul 7, 2013 · N93PC · Destroyed
  > The operator's failure to determine the actual cargo weight, leading to the loading and operation of the airplane outside of the weight and center of gravity limits contained in the airplane flight manual, which resulted in an aerodynamic stall. Contributing…
- [NTSB DCA11MA076](https://openairdocs.org/ntsb/DCA11MA076.md): Gulfstream GVI · Roswell, NM · Accident · 4 fatal · Class 1 · Major · Final report · Apr 2, 2011 · N652GD · Substantial damage
  > The National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…
- [NTSB MIA08MA203](https://openairdocs.org/ntsb/MIA08MA203.md): Aerospatiale SA365N-1 D · District Heights, MD · Accident · 4 fatal · Class 1 · Major · Final report · Sep 28, 2008 · N92MD · Substantial damage
  > The pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '030' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/030/sequence?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.