NTSB investigations, 1982, UT
12 cases where the phase of flight was Landing.
Cases per year
| 1964 | 30 |
|---|---|
| 1965 | 16 |
| 1966 | 27 |
| 1967 | 22 |
| 1968 | 15 |
| 1969 | 16 |
| 1970 | 11 |
| 1971 | 4 |
| 1972 | 10 |
| 1973 | 11 |
| 1974 | 4 |
| 1975 | 8 |
| 1976 | 18 |
| 1977 | 12 |
| 1978 | 7 |
| 1979 | 11 |
| 1980 | 17 |
| 1981 | 14 |
| 1982 | 12 |
| 1983 | 6 |
| 1984 | 11 |
| 1985 | 7 |
| 1986 | 10 |
| 1987 | 9 |
| 1988 | 6 |
| 1989 | 9 |
| 1990 | 9 |
| 1991 | 10 |
| 1992 | 3 |
| 1993 | 10 |
| 1994 | 8 |
| 1995 | 6 |
| 1996 | 8 |
| 1997 | 11 |
| 1998 | 10 |
| 1999 | 8 |
| 2000 | 11 |
| 2001 | 13 |
| 2002 | 12 |
| 2003 | 10 |
| 2004 | 13 |
| 2005 | 8 |
| 2006 | 9 |
| 2007 | 13 |
| 2008 | 17 |
| 2009 | 14 |
| 2010 | 8 |
| 2011 | 10 |
| 2012 | 6 |
| 2013 | 7 |
| 2014 | 6 |
| 2015 | 7 |
| 2016 | 5 |
| 2017 | 9 |
| 2018 | 9 |
| 2019 | 12 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 13 |
| 2023 | 13 |
| 2024 | 11 |
| 2025 | 8 |
| 2026 | 12 |
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\") = 1982
AND c.\"eventStateOrRegion\" = 'UT' 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") = 1982
AND c."eventStateOrRegion" = 'UT' 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 DEN83LA042Accident · No injuriesLimited investigationFinal reportBeech V35B · Kamis, UTThe plt stated he noticed a drop in oil pressure & a prop surge & decided to make a precautionary landing on a road. During the landing the acft struck several sign posts. Post accident tests showed no evidence of oil starvation or drop in oil pressure.NTSB DEN82DA186Accident · No injuriesFinal reportPiper PA-31T · Delta, UTAfter landing, the aircraft departed the right side of the runway. The pilot stated that left rudder and brake did not keep the aircraft on the runway. He believed that the right brake locked or the left reverser did not activate. An examination of the…NTSB DEN82DA160Accident · No injuriesFinal reportCessna 421C · Bountiful, UTThe pilot reported that the approach and landing to touchdown were normal. At touchdown, the aircraft shuttered and pulled to the right, but was kept on the runway through the use of left brake and nosewheel steering. After continuing down the runway for…NTSB DEN82DA104Accident · No injuriesFinal reportLuscombe 8A · Wendover, UTThe pilot reported that during the landing roll, he applied moderate braking to avoid a long taxi distance back to the parking area. He was wearing unfamiliar boots with higher than normal heels, and while using the small heel brake peddles, the aircraft…NTSB DEN82DA101Accident · No injuriesFinal reportCessna 188B · Central, UTPilot ran out of fuel and made a forced landing during which a wing collided with a fence.NTSB DEN82DA096Accident · No injuriesFinal reportCessna TU206G · Price, UTThe aircraft encountered a dust devil shortly after touchdown during a landing on an unimproved area. The pilot reported that the dust devil moved the aircraft to the right and into a ditch.NTSB DEN82DA084Accident · No injuriesFinal reportCessna 182Q · Provo, UTThe aircraft drifted off the side of the runway during landing. Power was applied for a go-around, however, the pilot stated the application of full flaps (40 degrees) prevented lift off and the aircraft nosed over.NTSB DEN82DA077Accident · No injuriesFinal reportMooney M20E · Hanksville, UTThe pilot stated that during the landing touchdown on runway 19, a gust of wind from about 270 degrees was encountered and the plane veered to the left. The pilot reported that he had applied corrective action, and the plane was tracking back to the runway,…NTSB DEN82DA053Accident · No injuriesFinal reportCessna T210G · Moab, UTThe aircraft was found on an abandoned dirt runway near deadhorse point. Investigation indicated that the aircraft touched down long on runway 21 and collided with an elevated dirt road that crosses the runway. Two impact marks were found on the instrument…NTSB DEN82DA030Accident · No injuriesFinal reportCessna 421B · Spanish Fork, UTThe aircraft tookoff from an airport with slush on the runway, about 10 minutes later, the pilot landed at another airport. The runway at the destination airport was covered with dry snow. During touchdown, the aircraft veered left and hit a snowbank beside…NTSB DEN82DTM10Accident · No injuriesFinal reportSmith Miniplane BK-1 · West Jordan, UTThe pilot had just purchased the aircraft and was making touch and go landings for familiarization. He was using a paved runway with patches of ice and was landing with about a 10 knot right crosswind. On about his eighth landing, the plane began to drift to…NTSB DEN82DA026Accident · No injuriesFinal reportCessna 172 · Bryce Canyon, UTAfter arriving from a cross-country flight, the pilot landed on an icy runway with calm wind conditions. During ground roll, the aircraft began sliding to the left. The left wheel hit snow and pulled the aircraft further left. The pilot applied right rudder…