NTSB investigations, 1985, OR
12 cases where the phase of flight was Enroute.
Cases per year
| 1964 | 11 |
|---|---|
| 1965 | 14 |
| 1966 | 16 |
| 1967 | 21 |
| 1968 | 17 |
| 1969 | 16 |
| 1970 | 14 |
| 1971 | 18 |
| 1972 | 20 |
| 1973 | 20 |
| 1974 | 14 |
| 1975 | 15 |
| 1976 | 25 |
| 1977 | 21 |
| 1978 | 26 |
| 1979 | 28 |
| 1980 | 22 |
| 1981 | 20 |
| 1982 | 12 |
| 1983 | 12 |
| 1984 | 19 |
| 1985 | 12 |
| 1986 | 21 |
| 1987 | 12 |
| 1988 | 16 |
| 1989 | 8 |
| 1990 | 11 |
| 1991 | 11 |
| 1992 | 13 |
| 1993 | 8 |
| 1994 | 8 |
| 1995 | 8 |
| 1996 | 8 |
| 1997 | 12 |
| 1998 | 10 |
| 1999 | 6 |
| 2000 | 13 |
| 2001 | 9 |
| 2002 | 13 |
| 2003 | 7 |
| 2004 | 6 |
| 2005 | 9 |
| 2006 | 4 |
| 2007 | 7 |
| 2008 | 6 |
| 2009 | 4 |
| 2010 | 6 |
| 2011 | 10 |
| 2012 | 4 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 6 |
| 2018 | 2 |
| 2019 | 5 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 6 |
| 2024 | 7 |
| 2025 | 2 |
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\") = 1985
AND c.\"eventStateOrRegion\" = 'OR' 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") = 1985
AND c."eventStateOrRegion" = 'OR' 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 SEA86LA026Accident · No injuriesLimited investigationFinal reportHughes 269C · Brooks, ORA total loss of power occurred due to the number 4 cylinder failing. A tail boom strike occurred during a hard landing in a parking lot, severing the tail boom.NTSB SEA86LA012Accident · No injuriesLimited investigationFinal reportCessna 152 · Ontario, ORA forced landing occurred due to a total loss of power. Landing was accomplished onto a freshly plowed potato field where substantial damage occurred. No reason for the loss of power could be determined.NTSB SEA86LA005Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Medford, ORThe acft collided with rocky terrain during an attempted forced landing following a loss of pwr. A witness reported seeing the acft in a steep descending left turn at an alt of aprx 100 ft AGL. The descent continued until the left wing contacted the terrain.…NTSB SEA85LA227Accident · No injuriesLimited investigationFinal reportBeech J35 · Ontario, ORThe plt was flying the acft at a low alt for the purpose of spotting game. The eng ceased operating shortly after switching fuel tanks. The plt stated during a telephone interview that he inadvertently switched the fuel selector to the off position. The acft…NTSB SEA85LA215Accident · No injuriesLimited investigationFinal reportVarga 2150A · Vale, ORThe acft nosed down after the nose gear collapsed during a forced landing on a dirt road following a loss of pwr. The plt reported that aprx 1 hr into the x-country flt he noted the fuel gages indicated 1/2 full on each tank. A state trooper reported he…NTSB SEA85LA216Accident · No injuriesLimited investigationFinal reportCessna 152 · Independence, ORThe plt descended to a low alt over a river to look for birds. While over the river the plt spotted pwr lines at an alt of aprx 75 ft AGL. An attempt was made to fly under the lines, but the tail contacted the wires severing aprx 6 inches off the top portion…NTSB SEA85FYM03Accident · 2 fatalFinal reportCessna 170B · Manzanita, ORAircraft was observed to enter a low overcast shortly after take off. The aircraft then hit a mountain about 4 miles north of the departure airport.NTSB SEA85LA123Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Wamic, ORA forced landing was made following a loss of pwr. The acft contacted two fences, a ditch then nosed over during the forced landing. Post accident inspection revealed no fuel in the carburetor float chamber or in the accelerator pump chambers.NTSB SEA85FA233Accident · 2 fatalField investigationFinal reportCessna 172N · Remote, ORDuring a wx briefing, the non-instrument plt was adzd that VFR flt was not recommended due to low clouds & adverse wx along the route. However, he filed a VFR flt plan & depd arcata, CA at 1240 PDT. At 1339, in the vcnty of wilderville, OR, the plt got a wx…NTSB SEA85LA097Accident · No injuriesLimited investigationFinal reportHiller 12E · Myrtle Point, ORDuring a CFR 137 flight a total loss of power occurred with an audible screech coming form the engine area. Autorotation was made and the acft was landed into a hevily treed area with steep terrain. During engine tear down a fractured impeller was found.…NTSB SEA85LA094Accident · No injuriesLimited investigationFinal reportHelio H-295 · John Day, ORReportedly, the acft encountered airframe icing conditions during flt, & subsequently, mushed into trees on wooded terrain. Elevation of the crash site was about 4500 ft. about 95 mi west at redmond, OR, the wx was in part: 800 ft overcast, 3 mi visibility,…NTSB SEA85LA054Accident · 4 fatalLimited investigationFinal reportCessna 182-F · Ashland, ORThe plt was briefed regarding weather and expected flt conditions btw medford and redding. The briefing included a forecast for improving conditions approaching the destination as well as possible icing en route. The acft departed medford carrying aprx 970…