NTSB investigations, 2002, WA
17 cases where the phase of flight was Enroute.
Cases per year
| 1963 | 1 |
|---|---|
| 1964 | 21 |
| 1965 | 20 |
| 1966 | 27 |
| 1967 | 16 |
| 1968 | 23 |
| 1969 | 27 |
| 1970 | 28 |
| 1971 | 9 |
| 1972 | 25 |
| 1973 | 15 |
| 1974 | 34 |
| 1975 | 33 |
| 1976 | 23 |
| 1977 | 31 |
| 1978 | 31 |
| 1979 | 36 |
| 1980 | 30 |
| 1981 | 28 |
| 1982 | 26 |
| 1983 | 29 |
| 1984 | 16 |
| 1985 | 15 |
| 1986 | 30 |
| 1987 | 19 |
| 1988 | 17 |
| 1989 | 19 |
| 1990 | 21 |
| 1991 | 19 |
| 1992 | 14 |
| 1993 | 8 |
| 1994 | 12 |
| 1995 | 23 |
| 1996 | 14 |
| 1997 | 9 |
| 1998 | 13 |
| 1999 | 9 |
| 2000 | 16 |
| 2001 | 9 |
| 2002 | 17 |
| 2003 | 15 |
| 2004 | 11 |
| 2005 | 10 |
| 2006 | 6 |
| 2007 | 9 |
| 2008 | 7 |
| 2009 | 9 |
| 2010 | 8 |
| 2011 | 7 |
| 2012 | 6 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 7 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 5 |
| 2019 | 6 |
| 2020 | 1 |
| 2021 | 9 |
| 2022 | 9 |
| 2023 | 5 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 5 |
Where
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 year(c.\"eventDate\") = 2002
AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
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.
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") = 2002
AND c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB SEA03LA019Accident · No injuriesLimited investigationFinal reportEurocopter Deutschland EC-135 P1 · Loon Lake, WAThe pilot's inadvertent flight into instrument meteorological conditions (IMC) while in cruise flight, and an excessive descent rate. Factors include falling snow, whiteout conditions and dark night conditions.NTSB SEA03LA016Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Tekoa, WAThe pilot's failure to maintain clearance from the terrain while attempting to fly a non-IFR equipped aircraft solely by reference to its instruments after the aircraft's windshield became coated with freezing rain in cruise flight. A factor was the pilot's…NTSB SEA03FA015Accident · 2 fatalField investigationFinal reportCaron Seawind · Bryant, WAA loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain.NTSB SEA03TA014Accident · No injuriesFinal reportHughes OH-6A · Snohomish, WALoss of engine power for undetermined reasons while in cruise flight. A tree was a factor.NTSB SEA03FA013Accident · 2 fatalField investigationFinal reportCessna 172P · Malaga, WAThe pilot's attempted VFR flight into IMC resulting in the aircraft colliding with trees and up sloping terrain. Contributing factors were clouds, trees, and uphill terrain. The pilot’s performance and judgment were likely impaired by the effects of…NTSB SEA03LA002Accident · Serious injuriesLimited investigationFinal reportGentry Vari-Eze · Shine, WALoss of engine power for undetermined reasons during cruise. Trees and objects near the roadway were factors.NTSB SEA02LA163Accident · Minor injuriesLimited investigationFinal reportPiper PA-14 · Eastsound, WALoss of engine power for undetermined reasons.NTSB SEA02LA133Accident · Serious injuriesLimited investigationFinal reportCessna 150J · Pe Ell, WAThe fatigue failure of the number two engine cylinder for undetermined reasons during cruise flight. Factors include high vegetation in the area where the pilot found it necessary to make a forced landing.NTSB SEA02LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kittitas, WAThe pilot's failure to conduct an adequate preflight inspection of the fuel resulting in fuel exhaustion and a subsequent forced landing. A contributing factor was the rocky terrain encountered during the forced landing.NTSB SEA02LA126Accident · Serious injuriesLimited investigationFinal reportCosmos Phase II · Deer Park, WALoss of control for undetermined reasons.NTSB SEA02LA117Accident · No injuriesLimited investigationFinal reportCessna 172 E · Battle Ground, WAImproper maintenance procedures by maintenance personnel, which resulted in an engine oil leak while in flight. A factor was the pilot's misjudgment of distance during the precautionary landing which led to a runway overrun.NTSB SEA02LA116Accident · No injuriesLimited investigationFinal reportBeech G35 · Yakima, WAEmpennage flutter which resulted in structural damage during descent for landing. Turbulence was a factor.NTSB SEA02LA087Accident · Serious injuriesLimited investigationFinal reportHanson Rans S6ES · Spanaway, WAThe loss of engine power for undetermined reasons during the climb-out after takeoff. Factors include no suitable terrain upon which to attempt a forced landing, and trees and cars alongside of the residential street that the pilot attempted to land on.NTSB SEA02LA051Accident · No injuriesLimited investigationFinal reportBell/Garlick UH-1H · Dayton, WAA loss of power for undetermined reason(s). Contributing factors were the pilot's delayed decision to jettison the empty bucket and the trees impacted during the auto-rotation landing.NTSB SEA02FA030Accident · Serious injuriesField investigationFinal reportAgusta A109A II · Baring, WAThe sequential non-mechanical total loss of power in both engines 1 and 2 for undetermined reasons and the pilot's failure to maintain adequate rotor RPM to prevent a hard landing. Contributing factors were the tripped "RPM WARN" circuit breaker which…NTSB SEA02LA028Accident · No injuriesLimited investigationFinal reportCessna 150M · Clinton, WAFuel exhaustion while in cruise flight resulting in a loss of engine power and the pilot's failure to refuel the aircraft. The pilot's inadequate preflight planning/preparation and a fence post were factors.NTSB SEA02FA027Accident · 1 fatalField investigationFinal reportCessna 150G · Ilwaco, WAA loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed during a low altitude turn.