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.

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.Jul 27, 2010 · N8159B · 2 aircraft · Minor damageNTSB 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.Jul 27, 2010 · N6JR · Substantial damageNTSB 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.Apr 15, 2010 · N421KF · Substantial damageNTSB 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.Sep 6, 2009 · N3549W · Substantial damageNTSB 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.Dec 17, 2008 · N4504B · Substantial damageNTSB 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.Nov 23, 2008 · N67TE · DestroyedNTSB 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…Sep 12, 2008 · N193BS · Substantial damageNTSB 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.Sep 3, 2008 · N597TB · Substantial damageNTSB 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.Jul 31, 2008 · N515RB · Substantial damageNTSB 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.Jul 26, 2008 · N620SR · DestroyedNTSB 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.Jun 29, 2008 · N701DW · Substantial damageNTSB CHI08LA123Accident · 1 fatalLimited investigationFinal reportDickenson Bathtub · Broadhead, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall.May 5, 2008 · N538 · DestroyedNTSB 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.Jul 23, 2007 · N22NA · Substantial damageNTSB 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.Aug 26, 2006 · N314MA · Substantial damageNTSB 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…Aug 5, 2006 · N658CD · Substantial damageNTSB CHI06FA196Accident · 2 fatalField investigationFinal reportShaw Europa XS · Oshkosh, WIThe pilot's failure to maintain adequate airspeed on final approach which resulted in a stall.Jul 23, 2006 · N229WC · Substantial damageNTSB 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.Jun 27, 2006 · N701US · Substantial damageNTSB 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.Jun 26, 2006 · N82223 · Substantial damageNTSB 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.Jun 25, 2006 · N1910T · Substantial damageNTSB 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.May 30, 2006 · N391T · Substantial damageNTSB 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.Oct 27, 2005 · N20KK · Substantial damageNTSB 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.Aug 20, 2005 · N2373P · Substantial damageNTSB 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.Jul 27, 2005 · N219CC · Substantial damageNTSB 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.Jul 27, 2005 · N105TW · DestroyedNTSB 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.May 30, 2005 · N9623X · Substantial damageNTSB 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.…May 26, 2005 · N346F · Substantial damageNTSB 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.May 21, 2005 · N65855 · Substantial damageNTSB 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.Sep 10, 2004 · N1223S · DestroyedNTSB 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.Jun 30, 2004 · N43MP · Substantial damageNTSB CHI04CA136Accident · No injuriesData collectionFinal reportCessna 172P · Milwaukee, WIThe CFI failed to maintain adequate airspeed during the go-around which resulted in an inadvertent stall.Jun 4, 2004 · N50923 · Substantial damageNTSB 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.Feb 7, 2004 · N5039S · Substantial damageNTSB CHI04LA014Accident · No injuriesLimited investigationFinal reportCroke Zenith CH 701 · Brussels, WIA partial loss of engine power for undetermined reasons.Oct 16, 2003 · N701US · Substantial damageNTSB 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.Aug 20, 2003 · N806RB · Substantial damageNTSB 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.May 15, 2003 · N2581A · Substantial damageNTSB 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.May 14, 2003 · N70971 · Substantial damageNTSB 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.Nov 4, 2002 · N6606P · DestroyedNTSB CHI03LA012Accident · No injuriesLimited investigationFinal reportMork Kitfox III · Evansville, WIThe loss of power for undetermined reasons. A contributing factor is the unsuitable terrain.Oct 27, 2002 · N192MB · Substantial damageNTSB 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.May 31, 2002 · N3027F · Substantial damageNTSB 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.May 19, 2002 · N8657J · Substantial damageNTSB 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.May 11, 2002 · N85258 · Substantial damageNTSB CHI02FA120Accident · 1 fatalField investigationFinal reportCessna 182S · Sheboygan, WIThe pilot failed to maintain control of the airplane during the go-around for undetermined reasons.May 3, 2002 · N293MA · DestroyedNTSB 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.Apr 30, 2002 · N6RP · Substantial damageNTSB CHI01FA247Accident · Minor injuriesField investigationFinal reportBeech C35 · Oshkosh, WIThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Jul 29, 2001 · N35BJ · Substantial damageNTSB CHI01FA244Accident · 1 fatalField investigationFinal reportSchuchart Stoddard HamiltonSH3 · Oshkosh, WIThe inadvertent stall/spin by the pilot.Jul 26, 2001 · N325HP · DestroyedNTSB 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.Jul 24, 2001 · N202RP · DestroyedNTSB 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.Jul 23, 2001 · N216ST · Substantial damageNTSB 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.Jul 18, 2001 · N1448Z · DestroyedNTSB 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.Apr 17, 2001 · N888SM · DestroyedNTSB 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…Sep 2, 2000 · N3076C · DestroyedNTSB 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.Jan 6, 2000 · N5918S · Destroyed