# NTSB investigations, 2000, ID: Landing

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 SEA01LA006](https://openairdocs.org/ntsb/SEA01LA006.md): Cessna 185F · Driggs, ID · Accident · No injuries · Limited investigation · Final report · Oct 17, 2000 · N93981 · Substantial damage
  > The pilot's failure to maintain directional control. Factors include soft terrain adjacent to the runway.
- [NTSB SEA01LA003](https://openairdocs.org/ntsb/SEA01LA003.md): Enstrom F-28F · Twin Falls, ID · Accident · No injuries · Limited investigation · Final report · Oct 10, 2000 · N223RS · Substantial damage
  > The pilot's failure to maintain adequate rotor rpm. Unsuitable terrain was selected for the maintenance test flight operation.
- [NTSB SEA00LA164](https://openairdocs.org/ntsb/SEA00LA164.md): Cessna 170B · Nampa, ID · Accident · No injuries · Limited investigation · Final report · Aug 18, 2000 · N3007A · Substantial damage
  > The pilot's failure to maintain directional control during the balked landing.
- [NTSB SEA00LA153](https://openairdocs.org/ntsb/SEA00LA153.md): Cessna 180 · Challis, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2000 · N222AK · Substantial damage
  > The pilot's inadequate compensation for wind conditions. Factors include variable winds during landing.
- [NTSB SEA00LA152](https://openairdocs.org/ntsb/SEA00LA152.md): Cessna P210N · Stanley, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 2000 · N3882P · Substantial damage
  > An inadequately performed short field landing procedure and excessive ground speed. A delayed corrective response from the flight instructor, tailwind condition, and a fence were factors.
- [NTSB SEA00LA139](https://openairdocs.org/ntsb/SEA00LA139.md): Cessna 180H · Hailey, ID · Accident · No injuries · Limited investigation · Final report · Jul 22, 2000 · N2780X · Substantial damage
  > Failure to adequately compensate for wind conditions.
- [NTSB SEA00LA123](https://openairdocs.org/ntsb/SEA00LA123.md): Cessna 210E · Pocatello, ID · Accident · No injuries · Limited investigation · Final report · Jul 3, 2000 · N2331F · Substantial damage
  > Improper landing flare resulting in a hard landing. Factors include dark night environmental conditions and lack of recent experience for night landings.
- [NTSB SEA00LA120](https://openairdocs.org/ntsb/SEA00LA120.md): Cessna U206B · Yellow Pine, ID · Accident · No injuries · Limited investigation · Final report · Jul 2, 2000 · N3488L · Substantial damage
  > The locknut was not secured and backed off the bolt. An improper maintenance installation was a factor.
- [NTSB SEA00LA111](https://openairdocs.org/ntsb/SEA00LA111.md): Stinson 108-1 · Mountain Home, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 2000 · N8865K · Substantial damage
  > The pilot's decision to takeoff in unfavorable weather conditions without first calculating takeoff performance data. Factors include gusty winds, downdrafts, terrain-induced turbulence, and rough/uneven terrain where the pilot elected to make the…

## 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 year(c."eventDate") = 2000
  AND c."eventStateOrRegion" = 'ID' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?state=ID&year=2000

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