NTSB investigations, 2001, WA
19 cases where the phase of flight was Landing.
Cases per year
| 1964 | 44 |
|---|---|
| 1965 | 51 |
| 1966 | 48 |
| 1967 | 70 |
| 1968 | 33 |
| 1969 | 30 |
| 1970 | 33 |
| 1971 | 17 |
| 1972 | 18 |
| 1973 | 33 |
| 1974 | 25 |
| 1975 | 31 |
| 1976 | 28 |
| 1977 | 19 |
| 1978 | 29 |
| 1979 | 32 |
| 1980 | 28 |
| 1981 | 25 |
| 1982 | 26 |
| 1983 | 22 |
| 1984 | 29 |
| 1985 | 17 |
| 1986 | 17 |
| 1987 | 27 |
| 1988 | 27 |
| 1989 | 19 |
| 1990 | 13 |
| 1991 | 25 |
| 1992 | 21 |
| 1993 | 25 |
| 1994 | 22 |
| 1995 | 15 |
| 1996 | 16 |
| 1997 | 19 |
| 1998 | 17 |
| 1999 | 21 |
| 2000 | 18 |
| 2001 | 19 |
| 2002 | 20 |
| 2003 | 23 |
| 2004 | 23 |
| 2005 | 19 |
| 2006 | 12 |
| 2007 | 15 |
| 2008 | 18 |
| 2009 | 23 |
| 2010 | 17 |
| 2011 | 23 |
| 2012 | 18 |
| 2013 | 18 |
| 2014 | 22 |
| 2015 | 9 |
| 2016 | 13 |
| 2017 | 13 |
| 2018 | 18 |
| 2019 | 13 |
| 2020 | 11 |
| 2021 | 19 |
| 2022 | 11 |
| 2023 | 15 |
| 2024 | 10 |
| 2025 | 12 |
| 2026 | 15 |
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\") = 2001
AND c.\"eventStateOrRegion\" = 'WA' 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"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") = 2001
AND c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
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 SEA02LA018Accident · No injuriesLimited investigationFinal reportLuscombe 8C · Olympia, WADirectional control not maintained during the landing roll. Factors include main gear overload and standing water on the runway.NTSB SEA02LA015Accident · No injuriesLimited investigationFinal reportCessna 402B · Pasco, WAthe pilot's failure to keep the aircraft from touching down short of the displaced threshold, and his failure to maintain directional control after the aircraft's left main gear tire deflated as a result of impacting the lip at the beginning of the subject…NTSB SEA01LA162Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Shelton, WAThe binding/grabbing of the right main gear braking system during the landing roll.NTSB SEA01LA150Accident · Minor injuriesLimited investigationFinal reportI.C.A. Brasov IS-28B2 · Wenatchee, WAFailure to maintain clearance from terrain during a low altitude turn. The second pilot overshooting the runway was a contributing factor to the accident.NTSB SEA01LA147Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26B · Rock Island, WAThe student pilot's improper inflight planning and decision (delay in establishing an approach to a suitable landing area) and his subsequent failure to attain the proper glidepath for the selected landing area, resulting in an overshoot of the selected…NTSB SEA01LA140Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Spokane, WAThe pilot landed with insufficient formation spacing behind the lead aircraft, resulting in an encounter with the lead aircraft's wake turbulence, and subsequently lost directional control during landing roll.NTSB SEA01LA136Accident · No injuriesLimited investigationFinal reportCessna 180K · Quincy, WAThe pilot's failure to maintain directional control during the landing roll. Factors include an encounter with a dust devil/whirlwind.NTSB SEA01LA132Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Friday Harbor, WAThe pilot's failure to maintain directional control during landing.NTSB SEA01LA129Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Fragaria, WAThe pilot's failure to maintain adequate directional control. Contributing factors were the embankment and the deer.NTSB SEA01LA119Accident · Minor injuriesLimited investigationFinal reportShaub EAA Biplane (P-2) · Zillah, WAThe pilot's failure to maintain directional control. A contributing factor was a tailwind.NTSB SEA01LA114Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mattawa, WAThe pilot's failure to maintain directional control of the aircraft during the landing roll. Contributing factors were the gusty crosswind condition and the high vegetation (sage brush) which the aircraft rolled into before nosing over.NTSB SEA01LA104Accident · No injuriesLimited investigationFinal reportCurtis Lionheart · Bremerton, WAthe pilot's failure to ensure the aircraft's longitudinal axis was aligned with the runway prior to touchdown, and his failure to maintain directional control during the landing roll. Factors include landing with a tailwind, and the pilot's lack of recent…NTSB SEA01LA096Accident · No injuriesLimited investigationFinal reportCessna 180A · Mercer Island, WAthe pilot's inadequate visual lookout during an approach and landing in open water. Factors include a large wave/swell at the location where the pilot elected to land his float-equipped airplane.NTSB SEA01LA091Accident · No injuriesLimited investigationFinal reportLet L-23 · Arlington, WAthe flight instructor's improper decision to partially retract the spoilers while the student was attempting to land. Factors include a tailwind, wet grass, and a taxiway sign off the end of the landing area.NTSB SEA01LA071Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Gig Harbor, WAThe pilot's failure to extend the airplane's landing gear while landing.NTSB SEA01LA061Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350 B2 Ecureuil · Mazama, WAThe pilot's failure to maintain aircraft control. Snow covered terrain, high and variable wind conditions, and failure of attaining the proper touchdown point were factors.NTSB SEA01LA054Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Seattle, WABoth pilots' exceedance of the proper descent rate during the autorotative descent. Factors included the helicopter's low altitude at maneuver initiation, the failure of both pilots to maintain the proper airspeed during the descent, and both pilots' delay in…NTSB SEA01TA050Accident · No injuriesFinal reportBeech 200 · Olympia, WAThe pilot's failure to attain the proper touchdown point for landing. A factor was weather conditions below published approach minimums.NTSB SEA01LA041Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Arlington, WAThe pilot's failure to maintain directional control during landing roll.