# NTSB investigations, ID: Standing

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 WPR13CA139](https://openairdocs.org/ntsb/WPR13CA139.md): Cessna 172F · Nampa, ID · Accident · No injuries · Data collection · Final report · Mar 2, 2013 · N8713U · Substantial damage
  > The failure of the pilot of another airplane, who was taxiing with no intent for flight, to maintain proper visual lookout.
- [NTSB WPR12CA137](https://openairdocs.org/ntsb/WPR12CA137.md): Cessna 182 · Caldwell, ID · Accident · No injuries · Data collection · Final report · Mar 14, 2012 · N5649B · Substantial damage
  > The pilot did not properly secure the airplane before starting the engine by manually rotating the propeller, which resulted in the inadvertent movement of the airplane.
- [NTSB WPR11LA136](https://openairdocs.org/ntsb/WPR11LA136.md): Piper PA18 · Twin Falls, ID · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 2011 · N7153Z · Substantial damage
  > The pilot’s failure to compensate for the wind, which resulted in the airplane being blown over after completion of the landing roll.
- [NTSB WPR10LA319](https://openairdocs.org/ntsb/WPR10LA319.md): Pridmore Lancair IV · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Jun 28, 2010 · N86PB · Substantial damage
  > The failure of maintenance personnel to ensure that a hydraulic line fitting was adequately secured during a conditional inspection, which resulted in a leak and subsequent on-ground fire.
- [NTSB WPR09CA041](https://openairdocs.org/ntsb/WPR09CA041.md): WSK PZL Mielec M-18A · Mountain Home, ID · Accident · No injuries · Data collection · Final report · Nov 8, 2008 · N81705 · Substantial damage
  > The pilot's inadequate preflight inspection, and, his failure to properly secure the aircraft as he left the cockpit with the engine operating, which resulted in the unoccupied airplane inadvertently becoming airborne and colliding with a fence and terrain.
- [NTSB SEA96LA165](https://openairdocs.org/ntsb/SEA96LA165.md): Bell 206B · Warren, ID · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 1996 · N750LT · Destroyed
  > the pilot's improper remedial action after helicopter's right skid became snagged by a log that was used in the construction of a temporary landing site. Factors relating to the accident were: the pilot's selection of an unsuitable landing area, inadequate…
- [NTSB SEA93LA209](https://openairdocs.org/ntsb/SEA93LA209.md): Aerospatiale SA 315B · Avery, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 24, 1993 · N351RM · Substantial damage
  > The pilot's improper use of the cyclic control.
- [NTSB SEA80FYP01](https://openairdocs.org/ntsb/SEA80FYP01.md): Cessna 182C · Lewiston, ID · Accident · No injuries · Closed · Oct 2, 1979 · N8489T · No damage
- [NTSB SEA77FYG04](https://openairdocs.org/ntsb/SEA77FYG04.md): Cessna 172 · Grangeville, ID · Accident · Serious injuries · Closed · Oct 2, 1976 · N1641F · No damage
- [NTSB SEA75DYA23](https://openairdocs.org/ntsb/SEA75DYA23.md): Beech 35 · Burley, ID · Accident · No injuries · Closed · Oct 11, 1974 · N3001V · Substantial damage
- [NTSB LAX74DYA29](https://openairdocs.org/ntsb/LAX74DYA29.md): Piper PA-28 · Twin Falls, ID · Accident · Serious injuries · Closed · Apr 19, 1974 · N7063R · Minor damage
- [NTSB SEA73DYA19](https://openairdocs.org/ntsb/SEA73DYA19.md): Dehavilland DH114 · Hailey, ID · Accident · No injuries · Closed · Feb 25, 1973 · N509FW · Substantial damage
- [NTSB SEA66D0232](https://openairdocs.org/ntsb/SEA66D0232.md): Cessna 175 · Grace, ID · Accident · No injuries · Closed · Mar 6, 1966 · N9204B · Minor damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 150)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/150/cases?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.