NTSB investigations, 1985, WI
23 cases where the phase of flight was Landing.
Cases per year
| 1964 | 28 |
|---|---|
| 1965 | 28 |
| 1966 | 31 |
| 1967 | 44 |
| 1968 | 32 |
| 1969 | 32 |
| 1970 | 25 |
| 1971 | 22 |
| 1972 | 25 |
| 1973 | 31 |
| 1974 | 29 |
| 1975 | 17 |
| 1976 | 19 |
| 1977 | 19 |
| 1978 | 31 |
| 1979 | 26 |
| 1980 | 22 |
| 1981 | 30 |
| 1982 | 11 |
| 1983 | 13 |
| 1984 | 13 |
| 1985 | 23 |
| 1986 | 21 |
| 1987 | 11 |
| 1988 | 11 |
| 1989 | 13 |
| 1990 | 8 |
| 1991 | 11 |
| 1992 | 9 |
| 1993 | 12 |
| 1994 | 13 |
| 1995 | 7 |
| 1996 | 8 |
| 1997 | 10 |
| 1998 | 11 |
| 1999 | 13 |
| 2000 | 10 |
| 2001 | 6 |
| 2002 | 8 |
| 2003 | 11 |
| 2004 | 8 |
| 2005 | 15 |
| 2006 | 6 |
| 2007 | 14 |
| 2008 | 10 |
| 2009 | 8 |
| 2010 | 8 |
| 2011 | 5 |
| 2012 | 16 |
| 2013 | 3 |
| 2014 | 7 |
| 2015 | 10 |
| 2016 | 8 |
| 2017 | 8 |
| 2018 | 6 |
| 2019 | 5 |
| 2020 | 8 |
| 2021 | 8 |
| 2022 | 9 |
| 2023 | 9 |
| 2024 | 12 |
| 2025 | 17 |
| 2026 | 6 |
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\" = 'WI' 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") = 1985
AND c."eventStateOrRegion" = 'WI' 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 CHI86LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dodgeville, WIAfter a x-country flt and during the landing roll the acft started to drift left on the snow covered rwy. The left main gear then encountered deeper snow causing the acft to swing to the left and run into a six-ft snowbank.NTSB CHI86LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Lake Geneva, WIAfter touchdown & about 600 ft from the approach end of runway 23 the aircraft collided with a moped crossing the runway. The 11 yr old operator of the moped was seriously injured.NTSB CHI86LA005Accident · No injuriesLimited investigationFinal reportTodd Pitts · Hartford, WIN2032 had taken off, remained in the traffic pattern, & landed. N14JK had taken off, obtained a radio check at altitude,descended and entered the traffic pattern. Immediately afterlanding N14JK ran into N2032. N14JK reportedly made two radio calls in the…NTSB CHI86LA002Accident · No injuriesLimited investigationFinal reportCessna 172 · Crivitz, WIThe plt lost directional control of the acft during the landing roll in x-wind conditions. As the acft veered to the left side of the rwy it struck a rwy light. The arpt owner stated the acft touched down in a crabbed position and the local winds were from…NTSB CHI85LA384Accident · No injuriesLimited investigationFinal reportCessna 150H · Racine, WIThe pilot reported a gust of wind resulted in a nose high left turn just prior to touchdown. Power was added & the left wing contacted the runway. The aircraft went off the left side of the runway and hit a ditch.NTSB CHI85IA359Incident · No injuriesIncident investigationFinal reportBritish Aerospace BAC 1-11-201AC · Green Bay, WIThe airplane landed & touched down in the first 1/3 of the runway. It veered to the left, then back to the center & went off the end the runway showed signs of steam cleaning where the tires were & the tires showed signs of rubber inversion. The pilot elected…NTSB CHI85LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Franklin, WIThe pilot used a shortfield takeoff and the acft would not fly. The plt aborted the takeoff and landed on the end of therwy, overrunning the rwy and striking a ditch. The plt reported engine RPM normal and the acft was under max gross takeoff weight.NTSB CHI85LA327Accident · No injuriesLimited investigationFinal reportHoward DGA-15P · Fond Du Lac, WIThe plt had accurued aprx 12 hrs of flying time on the day of the accident. During the final landing the acft touched down at the rwy mid-point and bounced. The acft then struck a rwy light and veered off the rwy paved surface into soft sod. The plt attempted…NTSB CHI85LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Appleton, WIAs the plt applied brakes during a full stop landing, the right brake failed. The plt then maneuvered the acft off the paved landing surface in an attempt to get it to roll to a stop. The right landing gear strut collapsed. The acft then slid into a fence and…NTSB CHI85LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Stoughton, WIUpon landing following a normal 70 knot final approach the aircraft initially touched down one-third of the way down the 2500 ft grass runway. A bounce carried the aircraft to a point halfway down the runway where the aircraft landed in a full stall. The…NTSB CHI85LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-200 · New Richmond, WIThe acft veered to the rt & hit a rwy marker during the attempted go-around. The wind was from 210 degrees at 19 KTS gusting to 27 KTS. The plt said that if the marker had been 'break-away' plastic the damage would have been negliable.NTSB CHI85LA252Accident · No injuriesLimited investigationFinal reportBeech BE-19A · Appleton, WIThe left main landing gear collapsed following a loss of directional control during landing. The landing was made on rwy 21 with winds from 240 degs at 18 KTS gusting to 30 KTS. The plt reported the acft drifted left during the landing and side loads on the…NTSB CHI85LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Mosinee, WIThe plt stated that he failed to flare properly following a 'fast and flat' final approach. The acft landed on its nosewheel resulting in substantial damage to the acft.NTSB CHI85LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Blair, WIThe plt attempted to land the acft in a farm field but was unable to stop before reaching the end of the field. The acft ran through a fence & a ditch before coming to rest. The plt stated that he overshot the rwy, landed long, & was unable to stop the acft…NTSB CHI85LA217Accident · No injuriesLimited investigationFinal reportCessna 150M · Merrill, WIThe plt was performing touch-and-go's when on the landing roll she allowed the acft to drift off the rwy into soft terrain. The acft nosed over. The plt stated that she was looking inside to raise the flaps.NTSB CHI85LA208Accident · No injuriesLimited investigationFinal reportCessna 150L · Necedah, WIAfter a flt with an instructor, the student took off on a solo flt. During a touch & go the student stated, '... I came in high & fast. I landed long and the aircraft bounced twice. I then panicked and pushed the control forward causing the nose to dive into…NTSB CHI85LA216Accident · No injuriesLimited investigationFinal reportPiper PA-32T-300 · Milwaukee, WIThe pilot stated that the approach was normal and flown at 90 KIAS. He flared high and the acft landed hard on the right main landing gear, due to the excessive rate of decent. The damage was limited to the right wing spar and ribs.NTSB CHI85LA194Accident · No injuriesLimited investigationFinal reportDassault-Breguet Falcon 50 · Lake Geneva, WIHigh sink rate developed on short final. Acft touched down 13 ft prior to runway before sink rate could be arrested. Landing gear collapsed after contacting edge of rwy which is 7 inches higher than surrounding terrain. Tail section of acft caught fire just…NTSB CHI85LA183Accident · No injuriesLimited investigationFinal reportCessna 152 · Broadhead, WIThe plt stated that during arrival, he entered a traffic pattern for what he thought, according to his directional gyro, was rwy 9. Rwy 9 was 2500 ft long; however, he landed on rwy 3, which was 1520 ft long. During the landing, the plt was unable to stop on…NTSB CHI85LA126Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Markesan, WIAlthough the pilot believed he had enough visibility to land at this unlighted airfield at dusk, he, in fact, aligned the aircraft up approximately 20 feet to the right of the runway. He landed in a shallow snowbank that paralleled the entire length of the…NTSB CHI85LA123Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Ephriam, WIThe aircraft began drifting to the right during the landing flare. As the aircraft touched down the right wheel entered an area of slush. The aircraft then slid off the runway to the right into a snowbank, damaging the landing gear and left wing tip. The…NTSB CHI85LA117Accident · No injuriesLimited investigationFinal reportCessna 177RG · Janesville, WIThe acft collided with a snowbank during lndg. An investigation by a qualified A&P mech found the lock-o-seal in the master cylinder had improper clearance. Lack of proper clearence restricted return flow of brake fluid to the reservoir. This led to locking…NTSB CHI85LA106Accident · No injuriesLimited investigationFinal reportCessna 150D · Siren, WIThe acft collided with a snow bank during landing. This was a solo student flt for the plt. The wind was 20 degrees off the rwy heading and varying bet 7-12 KTS in velocity. The student reported that either more brake & aileron or a running takeoff would have…