# Major NTSB investigations: Altitude deviation,uncontrolled

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 DCA01MA031](https://openairdocs.org/ntsb/DCA01MA031.md): Embraer EMB-120 · West Palm Beach, FL · Accident · No injuries · Major investigation · Final report · Mar 19, 2001 · N266CA · Substantial damage
  > the failure of the flight crew to maintain airspeed during an encounter with severe icing conditions, which resulted in an inadvertent stall, loss of control, and structural damage to the airplane.
- [NTSB DCA98MA023](https://openairdocs.org/ntsb/DCA98MA023.md): Boeing 727-223 · Chicago, IL · Accident · Minor injuries · Class 1 · Major · Final report · Feb 9, 1998 · N845AA · Substantial damage
  > the failure of the flight crew to maintain a proper pitch attitude for a successful landing or go-around. Contributing to the accident were the divergent pitch oscillations of the airplane, which occurred during the final approach and were the result of an…
- [NTSB NYC86MA148](https://openairdocs.org/ntsb/NYC86MA148.md): Sikorsky S-76B · Sutton, MA · Accident · 4 fatal · Major investigation · Final report · Jun 6, 1986 · N5AZ · Destroyed
  > About 16 min after takeoff, while cruising at 6000' MSL in IMC, the plt transmitted 'Sikorsky 507' (call sign of acft hefrequently flew). The ATC ctlr was talking to another flt & did not respond. About 1 min later, rdo & radar contact werelost & the…
- [NTSB DCA83AA022](https://openairdocs.org/ntsb/DCA83AA022.md): Mitsubishi MU-2B-60 · Jeffersonville, GA · Accident · 4 fatal · Final report · Mar 24, 1983 · N72B · Destroyed
  > The acft was on the return portion of a round trip flt, hauling canceled bank checks. When they boarded before takeoff, the plt's wife, who was not a plt, occupied the r front seat & his 2 daughter's, ages 4 & 6, were in the passenger seats. Previous legs of…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 110)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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