NTSB investigations, WI
424 cases where the phase of flight was Approach.
Cases, newest first
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 c.\"eventStateOrRegion\" = 'WI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
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 c."eventStateOrRegion" = 'WI' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
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 CEN10IA447Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301 · Ripon, WIThe inability of either pilot to see the other airplane due to the blind spot created by their respective airplane's wings.NTSB CEN10FA443Accident · Serious injuriesField investigationFinal reportHawker Beechcraft 390 · Oshkosh, WIThe pilot's decision not to advance the engines to takeoff power during the go-around, as stipulated by the airplane flight manual, which resulted in an aerodynamic stall at a low altitude.NTSB CEN10LA208Accident · Serious injuriesLimited investigationFinal reportReed William A Kitfox 4 · Baraboo, WIThe pilot's failure to compensate for wind gusts and maintain sufficient airspeed, which resulted in a stall.NTSB CEN09CA566Accident · No injuriesData collectionFinal reportPiper J3C-65 · Mondovi, WIThe pilot's failure to maintain adequate airspeed while in the traffic pattern, which resulted in an aerodynamic stall.NTSB CEN09LA095Accident · No injuriesLimited investigationFinal reportCessna 402 · Madison, WIThe pilot’s improper fuel management, which resulted in a loss of engine power during an instrument landing due to fuel exhaustion.NTSB CEN09FA070Accident · 3 fatalField investigationFinal reportPiper PA46-500TP · Marshfield, WIThe pilot's failure to maintain control of the airplane during final approach for landing in night, visual meteorological conditions for undetermined reasons.NTSB CHI08FA282Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Woodruff, WIThe pilot’s failure to maintain airspeed during a missed approach leading to the inadvertent stall. Contributing to the accident were the pilot’s lack of experience in the type of operation conducted, the certificate holder’s loss of operational control, and…NTSB CHI08LA272Accident · 1 fatalLimited investigationFinal reportSocata TB-20 Trinidad · Cassville, WIThe left seat pilot's failure to maintain control of the airplane during a go-around and the inadvertent in-flight opening of the cabin door for undetermined reasons. Contributing to the accident was the distraction of the door opening.NTSB CHI08FA224Accident · 2 fatalField investigationFinal reportMoser Georg Lancair Legacy FG · Oshkosh, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall and subsequent loss of control.NTSB CHI08LA216Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR22 · Watertown, WIThe pilot's failure to maintain adequate airspeed during the go-around, resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed recovery from the bounced landing.NTSB CHI08CA173Accident · Minor injuriesData collectionFinal reportBeech A23A · Sheboygan, WIThe pilot's improper fuel management that led to fuel starvation and the loss of engine power. Contributing to the accident was the drainage ditch.NTSB CHI08LA123Accident · 1 fatalLimited investigationFinal reportDickenson Bathtub · Broadhead, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall.NTSB CHI07LA219Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Fond Du Lac, WIThe loss of engine power due to the failure of the engine's master connecting rod which resulted in the forced landing. The road sign was a factor.NTSB CHI06CA246Accident · No injuriesData collectionFinal reportAviat A-1B · Minocqua, WIThe inadvertent collision with power lines. A factor associated with the accident was the water which blended in with the power lines resulting in the pilot's inability to see them prior to contact.NTSB CHI06FA218Accident · Serious injuriesField investigationFinal reportCirrus Design SR22 · Boyceville, WIThe pilot's failure to maintain adequate airspeed and the certified flight instructor's delayed remedial action and inadequate supervision of the flight training, which resulted in an inadvertent stall during a base to final turn to the landing runway. An…NTSB CHI06FA196Accident · 2 fatalField investigationFinal reportShaw Europa XS · Oshkosh, WIThe pilot's failure to maintain adequate airspeed on final approach which resulted in a stall.NTSB CHI06CA171Accident · Serious injuriesData collectionFinal reportCroke Zenith CH 701 · Brussels, WIThe pilot not maintaining clearance from the trees during final approach. The trees located along the final approach course were a factor in the accident.NTSB CHI06CA172Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Minong, WIRestriction of the elevator control system due to the camera placed in the seat back pocket and the inadvertent stall/mush condition encountered during the go-around. The trees impacted after the stall were a contributing factor.NTSB CHI06CA166Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Walworth, WIThe pilot's delay in initiating a go-around and the resulting failure to maintain clearance to the vehicle on the adjacent roadway. The short length of the runway selected by the pilot and the vehicle were contributing factors.NTSB CHI06CA142Accident · No injuriesData collectionFinal reportStys T-Bird Sport · West Bend, WIThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed which resulted in a stall.NTSB CHI06CA022Accident · No injuriesData collectionFinal reportCessna 180 · Manitowish Wate, WIThe pilot's inadequate preflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor to the accident was the trees the airplane impacted during the forced landing.NTSB CHI05CA241Accident · Minor injuriesData collectionFinal reportPiper PA-22-150 · Brodhead, WIThe pilot's misjudged distance/altitude which resulted in an undershoot. A related factor was the vehicle the airplane contacted.NTSB CHI05LA200Accident · Minor injuriesLimited investigationFinal reportVans RV-9A · Neenah, WIThe pilot failed to maintain sufficient airspeed on final approach to avoid a stall, resulting in an inadvertent stall and uncontrolled descent to the terrain.NTSB CHI05FA199Accident · 1 fatalField investigationFinal reportGlasair GS-2 · Wautoma, WIthe abrupt maneuver that was performed while failing to maintain airpeed, resulting in a stall, and uncontrolled impact with the ground without sufficient altitude to recover.NTSB CHI05LA129Accident · No injuriesLimited investigationFinal reportCessna 210B · Friendship, WIThe loss of engine power for an undetermined reason. Contributing factors to the accident were the trees and the dark night light condition.NTSB CHI05LA130Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6 · Sturtevant, WIFailure of the jump plane pilot to maintain clearance from the parachutist descent area/drop zone until assured that all jumpers had landed, and the parachutist's failure to maintain an adequate visual lookout for the jump plane during all phases of the jump.…NTSB CHI05CA119Accident · No injuriesData collectionFinal reportSchweizer SGS 2-33A · Beloit, WIThe pilot's misjudgment of distance/altitude which resulted in an undershoot of the runway and collision with trees.NTSB CHI04FA255Accident · 1 fatalField investigationFinal reportCirrus Design SR-22 · Park Falls, WIThe flightcrew's failure to maintain airspeed which resulted in an inadvertent stall and subsequent impact with water during approach. The low altitude was a factor in the accident.NTSB CHI04CA168Accident · No injuriesData collectionFinal reportPeck Vans RV-4 · Palmyra, WIThe pilot's failure to maintain proper airspeed resulting in the inadvertent stall during the go-around. The overload failure of the left main landing gear was a contributing factor.NTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.NTSB CHI04LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Lone Rock, WIThe pilot's continued flight into icing conditions resulting in ice accretion on the wing and his failure to maintain airspeed resulting in a stall.NTSB CHI04LA014Accident · No injuriesLimited investigationFinal reportCroke Zenith CH 701 · Brussels, WIA partial loss of engine power for undetermined reasons.NTSB CHI03LA274Accident · No injuriesLimited investigationFinal reportBoeing A-75 · La Crosse, WIThe total loss of engine power due to a fatigue fracture of the engine's crankshaft. A factor was the corn crop.NTSB CHI03LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-135 · Prescott, WIThe pilot delaying the go-around and the maneuver to avoid the treeline. Factors to the accident were the treeline and the airplane's low altitude.NTSB CHI03LA125Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Wilmot, WIThe loss of engine power for an undetermined reason, and the unsuitable terrain encountered for the forced landing. A factor was the fence.NTSB CHI03FA018Accident · 2 fatalField investigationFinal reportPiper PA-24 · Fond du Lac, WIThe pilot failed to maintain obstacle clearance from the power lines while on a night VFR approach. Factors to the accident included the dark night and the power lines.NTSB CHI03LA012Accident · No injuriesLimited investigationFinal reportMork Kitfox III · Evansville, WIThe loss of power for undetermined reasons. A contributing factor is the unsuitable terrain.NTSB CHI02LA146Accident · No injuriesLimited investigationFinal reportCessna 182J · Galesville, WIThe pilot failed to maintain clearance with the wires while on final approach. Factors associated with the accident were the low altitude, the downdraft, and the wires which the airplane contacted.NTSB CHI02LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Kenosha, WIThe student pilot's failure to use carburetor heat, and the flight instructor's inadequate supervision of the flight.NTSB CHI02LA134Accident · Serious injuriesLimited investigationFinal reportAeronca 7FC · Neenah, WIThe pilot not maintaining control of the airplane during the landing approach, and his failure to maintain clearance from terrain.NTSB CHI02FA120Accident · 1 fatalField investigationFinal reportCessna 182S · Sheboygan, WIThe pilot failed to maintain control of the airplane during the go-around for undetermined reasons.NTSB CHI02LA118Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Racine, WIThe inadequate weather evaluation and delayed application of carburetor heat by the pilot, and the unsuitable terrain encountered during the forced landing. The carburetor icing conditions and the low altitude were factors.NTSB CHI01FA247Accident · Minor injuriesField investigationFinal reportBeech C35 · Oshkosh, WIThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB CHI01FA244Accident · 1 fatalField investigationFinal reportSchuchart Stoddard HamiltonSH3 · Oshkosh, WIThe inadvertent stall/spin by the pilot.NTSB CHI01FA235Accident · 1 fatalField investigationFinal reportPayne Giles G-202 · Oshkosh, WIThe pilot failed to maintain aircraft control which resulted in an inadvertant stall. Factors with the accident were the pilot misjudged the approach and the pilot's lack of total experience in the Giles G-202.NTSB CHI01LA227Accident · No injuriesLimited investigationFinal reportMcIlraith Searey Amphibian · La Crosse, WIThe pilot's inadequate compensation for wind conditions and turbulence which resulted in the encountered stall. Factors to the accident were turbulence and the high wind condition.NTSB CHI01FA218Accident · 1 fatalField investigationFinal reportCessna 310R · Oak Creek, WIThe pilot not maintaining clearance from objects during an ILS approach in low night IFR conditions and his descent below decision height. Factors were the dark night, mist, low ceiling, and the trees west of the approach.NTSB CHI01FA117Accident · 1 fatalField investigationFinal reportBeech F35 · Oshkosh, WIThe pilot's failure to maintain adequate airspeed which resulted in a stall. The low altitude was a contributing factor.NTSB CHI00FA284Accident · 2 fatalField investigationFinal reportBeech K35 · Manitowish Watr, WIthe pilot not maintaining altitude/clearance from the trees during an approach on a dark, low overcast night, the pilot's improper use of an IFR procedure without clearance, and the pilot's improper in-flight decision to attempt an IFR approach without…NTSB CHI00FA057Accident · 1 fatalField investigationFinal reportBeech D-95A Travelair · Dunbar, WIthe pilot failed to maintain a proper glidepath and obstacle clearance during an instrument approach. Additional factors to the accident included the dark night, icing conditions, flight into known adverse weather, and conditions conducive to pilot fatigue.