# Major NTSB investigations: Aerodynamic stall/spin

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 CEN17MA183](https://openairdocs.org/ntsb/CEN17MA183.md): Learjet 35A · Teterboro, NJ · Accident · 2 fatal · Class 1 · Major · Final report · May 15, 2017 · N452DA · Destroyed
  > The pilot-in-command's (PIC) attempt to salvage an unstabilized visual approach, which resulted in an aerodynamic stall at low altitude. Contributing to the accident was the PIC's decision to allow an unapproved second-in-command to act as pilot flying, the…
- [NTSB CEN16MA036](https://openairdocs.org/ntsb/CEN16MA036.md): British Aerospace HS 125 700A · Akron, OH · Accident · 9 fatal · Class 1 · Major · Final report · Nov 10, 2015 · N237WR · Destroyed
  > The flight crew's mismanagement of the approach and multiple deviations from company standard operating procedures, which placed the airplane in an unsafe situation and led to an unstabilized approach, a descent below minimum descent altitude without visual…
- [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 CEN09MA142](https://openairdocs.org/ntsb/CEN09MA142.md): Aerospatiale Alenia ATR 42-320 · Lubbock, TX · Accident · Serious injuries · Class 1 · Major · Final report · Jan 27, 2009 · N902FX · Substantial damage
  > The flight crew's failure to monitor and maintain a minimum safe airspeed while executing an instrument approach in icing conditions, which resulted in an aerodynamic stall at low altitude. Contributing to the accident were 1) the flight crew's failure to…
- [NTSB NYC08MA090](https://openairdocs.org/ntsb/NYC08MA090.md): Raytheon C90A · Mount Airy, NC · Accident · 6 fatal · Major investigation · Final report · Feb 1, 2008 · N57WR · Substantial damage
  > The pilot's failure to maintain control of the airplane in instrument meteorological conditions. Contributing to the accident were the pilot's improper decision to descend below the minimum descent altitude, and failure to follow the published missed approach…

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

This list as a web page: https://openairdocs.org/ntsb-events/241/cases?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, except the copies of manufacturers’ service documents, which belong to their rights holders.