# Major NTSB investigations: Undershoot

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 DCA97MA058](https://openairdocs.org/ntsb/DCA97MA058.md): Boeing 747-300 · Nimitz Hill · Accident · 228 fatal · Class 1 · Major · Final report · Aug 6, 1997 · H7468 · Destroyed
  > the captain's failure to adequately brief and execute the nonprecision approach and the first officer's and flight engineer's failure to effectively monitor and cross-check the captain's execution of the approach. Contributing to these failures were the…
- [NTSB DCA96MA008](https://openairdocs.org/ntsb/DCA96MA008.md): McDonnell Douglas MD-83 · East Granby, CT · Accident · Minor injuries · Class 1 · Major · Final report · Nov 12, 1995 · N566AA · Substantial damage
  > the flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…
- [NTSB ANC85MA183](https://openairdocs.org/ntsb/ANC85MA183.md): Boeing 737-2X6C · Unalaska, AK · Accident · Minor injuries · Major investigation · Final report · Sep 25, 1985 · N674MA · Substantial damage
  > Acft was dispatched to rstrctd arpt with a 3900' rwy & notamed: 3' stndg wtr on north end of rwy. SIGMET was in effect for mod to svr turbc blo 10,000' due to strong low lvl wnd & assoc wndshear. Capt made a shallow ovrwtr apch to rwy 12, which had a nr vert…

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

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

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