# Major NTSB investigations, ID

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 SEA96MA043](https://openairdocs.org/ntsb/SEA96MA043.md): Mitsubishi MU-2B-36 · Malad City, ID · Accident · 8 fatal · Major investigation · Final report · Jan 15, 1996 · N693PA · Destroyed
  > continued flight by the flightcrew into icing conditions with known faulty deice equipment; structural (airframe) ice; and failure of the flight crew to maintain adequate airspeed, which resulted in the loss of aircraft control and collision with terrain. A…
- [NTSB SEA87MA192](https://openairdocs.org/ntsb/SEA87MA192.md): Fairchild SA227-AC · Twin Falls, ID · Accident · Serious injuries · Major investigation · Final report · Sep 25, 1987 · N2689E · Destroyed
  > Chk plt was conducting capt proficiency chk on another company plt (PIC) under dark ngt condtns. Subsequent to full stop ldg on rwy 25, takeoff chklst was recited. PIC commenced t/o on rwy 07. Chk plt simulated VI eng cut after liftoff. PIC was unable to…
- [NTSB SEA84MA016](https://openairdocs.org/ntsb/SEA84MA016.md): de Havilland DHC-2 · Challis, ID · Accident · 4 fatal · Major investigation · Final report · Nov 5, 1983 · N9006 · Destroyed
  > The plt took off from the simplot ranch airstrip which was located beside the middle fork of the salmon river, aprx 27 mi northwest of Challis, ID. He departed downriver toward the northeast, but the destination was a usfs strip about 7 mi upriver to the…
- [NTSB DCA83AA017](https://openairdocs.org/ntsb/DCA83AA017.md): de Havilland DHC-6-300 · Hailey, ID · Accident · Serious injuries · Final report · Feb 15, 1983 · N361V · Destroyed
  > The acft was less than 2 miles from the arpt of intended landing during the approach when the crew experienced a loss ofelevator control. The acft started diving toward the ground when the power was reduced. The plt applied full power to try and restore level…
- [NTSB DCA83AA010](https://openairdocs.org/ntsb/DCA83AA010.md): Canadair CL-600-1A11 · Hailey, ID · Accident · 2 fatal · Final report · Jan 3, 1983 · N805C · Destroyed
  > The acft crashed into the side of a mountain ridge during a VFR attempt to land at an arpt with no instrument approach. The mountain ridge was obscured by broken clounds. The plt had cancelled his IFR clearance, & during the descent to the arpt, he had…
- [NTSB SEA72AS033](https://openairdocs.org/ntsb/SEA72AS033.md): Beech 65-B80 · Fairfield, ID · Accident · 5 fatal · Closed · Feb 20, 1972 · N1027C · Destroyed

## 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."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
  AND (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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