OpenAirDocs.org

NTSB investigations, ID

16 cases where the phase of flight was Unknown.

Cases per year

19682026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "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 = 990)
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB WPR26FA284Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Blackfoot, IDOn August 1, 2026, about 2301 mountain daylight time (MDT), a Cessna 172G, N1166F, was substantially damaged when it was involved in an accident near Blackfoot, Idaho. The pilot was fatally injured, and the two passengers sustained serious injuries. The…Aug 2, 2026 · N1166F · Substantial damageNTSB WPR19LA120Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 18 225 DD · McCall, IDA total loss of engine power for reasons that could not be determined based on the available information.Apr 23, 2019 · N727WW · Substantial damageNTSB WPR12TA445Accident · No injuriesFinal reportBeech C90 · Boise, IDExcessive loading on the left wing, which occurred over a period of time. Contributing to the accident was maintenance personnel’s failure to adequately inspect and document the left wing damage.May 10, 2012 · N14CP · Substantial damageNTSB SEA04LA110Accident · 1 fatalLimited investigationFinal reportQuicksilver MXL · Mountain Home, IDThe pilot's failure to maintain aircraft control during an undetermined in-flight operational phase resulting in an uncontrolled descent into the terrain. Factors include strong gusty winds in the area of the accident.Jun 18, 2004 · UNREG · Substantial damageNTSB SEA02FA011Accident · 1 fatalField investigationFinal reportCessna A185F · Lucile, IDThe pilot's failure to maintain adequate altitude above, and/or clearance with, mountainous terrain during night visual flight rules flight. Factors included mountainous terrain and dark night light conditions.Nov 6, 2001 · N61909 · DestroyedNTSB SEA01LA131Accident · 1 fatalLimited investigationFinal reportRockwell International S-2R · Nez Perce, IDThe pilot's failure to maintain terrain clearance for undetermined reasons.Jul 14, 2001 · N5011X · Substantial damageNTSB SEA01FA017Accident · 2 fatalField investigationFinal reportCessna 425 · Idaho Falls, IDThe pilot-in-command's failure to maintain adequate airspeed with an asymmetric thrust condition, resulting in a loss of aircraft control. A factor was an asymmetric engine thrust condition, which was present for undetermined reasons.Nov 10, 2000 · N41054 · Substantial damageNTSB SEA99LA063Accident · No injuriesLimited investigationFinal reportLake LA-4 · Coeur D'Alene, IDThe fatigue failure of a repair weld on one of the engine pylon mount straps and the resultant reduction in directional control. Factors include an inadequate repair of the strap, variable wind speeds and sudden wind shifts.May 15, 1999 · N152WB · Substantial damageNTSB SEA99LA043Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Rexburg, IDA loss of engine power for undetermined reasons.Mar 13, 1999 · N9578W · Substantial damageNTSB SEA89LA179Accident · 2 fatalLimited investigationFinal reportLuscombe 8A · Mackay, IDThe pilot failed to maintain an adequate airspeed for flight. High density altitude was a factor.Sep 24, 1989 · N71756 · Substantial damageNTSB SEA89LA187Accident · 1 fatalClass 3 · LimitedFinal reportEvans Wittman Tailwind W10 · McCall, IDA collision with terrain for undetermined reasons.Sep 1, 1989 · N62JE · DestroyedNTSB SEA89LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Idaho Falls, IDPlt reportedly stole acft and departed about midnight in snowstorm. For 3 hours he buzzed local residences vehicles until fuel exhaustion. Forced lndg made in rough field. Investigation revealed plt had long history of mental illness and had falsified medical…Nov 17, 1988 · N1963P · DestroyedNTSB SEA85FA142Accident · 3 fatalField investigationFinal reportMaule M-6-235 · Gibbonsville, IDThe plt and two passengers departed on a 2 hr flt for the purpose of conducting aerial observation of mine sites. The acft was operating in mountainous terrain during hot temp conditions resulting in a high density alt. There were no witnesses to the…Jun 18, 1985 · N121A · DestroyedNTSB SEA85FA110Accident · 1 fatalField investigationFinal reportCessna 402 · Pocatello, IDShortly after departure & level off, the plt reported an eng malfunction & initiated a return to the arpt. About 2 min later, he reported an eng fire & declared an emergency. Aprx 1 min thereafter, the rgt wing separated from the acft & the plane crashed. An…May 16, 1985 · N402CS · DestroyedNTSB SEA83FA162Accident · 1 fatalField investigationFinal reportPiper PA-36 · Firth, IDAccording to witnesses, the acft was overheard returning to the strip for a second load. Reportedly, it went into a steep bank at about 70 ft AGL & turned toward the strip. As the wings leveled, sounds of high eng power ceased & the acft descend to the…Aug 2, 1983 · N57588 · DestroyedNTSB SEA69F0106Accident · 1 fatalClosedPitts Spec · Arco, IDJul 21, 1968 · N86G · Destroyed