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 CHI00LA008Accident · No injuriesLimited investigationFinal reportCessna 150F · East Troy, WIthe pilot not maintaining directional control and not obtaining a proper climb rate. Factors were the gusts, and the ground loop that was encountered. A finding was the pilot atempted a go-around.Oct 13, 1999 · N7941F · Substantial damageNTSB CHI99FA252Accident · Minor injuriesField investigationFinal reportCessna 182D · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations and the subsequent fuel exhaustion. Factors associated with the accident were the crops and the soft field conditions.Jul 27, 1999 · N8878X · Substantial damageNTSB CHI99LA246Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Boscobel, WIthe pilot's improper approach to landing. Factors included the carburetor icing, the delayed use of carburetor heat, the unsuitable terrain for landing, and the ditch.Jul 20, 1999 · N6316P · Substantial damageNTSB CHI99LA189Accident · No injuriesLimited investigationFinal reportSchempp-Hirth Cirrus · Hartford, WIthe reason for the occurrence was undetermined. Factors were the pilot's deploying of the drogue chute, the drogue chute malfunctioning, a dirt embankment, and encountering unsuitable terrain during landing.Jun 19, 1999 · N8145 · Substantial damageNTSB CHI99LA099Accident · No injuriesLimited investigationFinal reportCalkins Kitfox 5 · Waunakee, WIthe fracture of the trim actuator.Mar 1, 1999 · N394GL · DestroyedNTSB CHI99LA085Accident · No injuriesLimited investigationFinal reportBeech 1900D · Milwaukee, WIthe in-flight collision with a bird.Feb 8, 1999 · N148SK · Substantial damageNTSB CHI98LA320Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Lac Du Flambeau, WIthe pilot's failure to maintain adequate airspeed and the subsequent inadvertant stall.Aug 9, 1998 · N9044D · Substantial damageNTSB CHI98FA288Accident · 1 fatalField investigationFinal reportHispano Aviacion A10B-37 · Oshkosh, WIthe pilot's failure to maintain adequate altitude which resulted in in-flight collision with trees and subsequent compressor stall for undetermined reasons.Aug 2, 1998 · N2741P · DestroyedNTSB CHI98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Eagle River, WIthe pilot failed to compensate for the wind conditions, improperly executed a go-around when he raised the flaps, and failed to maintain obstacle clearance with the trees.Apr 25, 1998 · N79006 · Substantial damageNTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.Dec 13, 1997 · N5454S · DestroyedNTSB CHI98LA057Accident · No injuriesLimited investigationFinal reportCessna 402A · Milwaukee, WIInadequate preflight planning/preparation, which resulted in fuel exhaustion.Dec 9, 1997 · N728QA · Substantial damageNTSB CHI97FA252Accident · 2 fatalField investigationFinal reportBeech 76 · New Richmond, WIThe certified flight instructor's inadequate supervision and delayed remedial action and the flight crew's lack of aircraft control. A factor was loss of control while maneuvering downwind by one of the pilot's.Aug 4, 1997 · N18960 · DestroyedNTSB CHI97LA230Accident · Minor injuriesLimited investigationFinal reportJenkins RV-6 · Middleton, WIthe pilot was too low on final approach and hit the high vegetation.Jul 28, 1997 · N126JM · Substantial damageNTSB CHI97LA215Accident · No injuriesLimited investigationFinal reportCessna 182 · Chippewa Falls, WIthe pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.Jul 20, 1997 · N5820B · Substantial damageNTSB CHI97FA047Accident · Minor injuriesField investigationFinal reportBeech C90 · Rhinelander, WIthe pilot-in-command's inadequate weather evaluation and continued flight into forecast severe icing conditions which exceeded the capabilty of the airplane's anti-ice/deice system. The icing conditions were a factor.Dec 28, 1996 · N998VB · Substantial damageNTSB CHI97LA005Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Neenah, WIthe local terrain conditions around the airport. A factor was the inadequate runway safety area.Oct 8, 1996 · N2398Z · DestroyedNTSB CHI96LA267Accident · No injuriesLimited investigationFinal reportYakovlev YAK-3UA · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.Aug 1, 1996 · N33UA · Substantial damageNTSB CHI96LA253Accident · No injuriesLimited investigationFinal reportYasecko LONG-EZE · Waukesha, WIFailure of the throttle cable.Jul 24, 1996 · N303Y · Substantial damageNTSB CHI96LA149Accident · 1 fatalLimited investigationFinal reportDeweese Bushby Mustang M-II · Lancaster, WIfailure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern, which resulted in an inadvertent stall/spin and collison with the terrain. The pilot's use of abrupt maneuvers was a related factor.May 4, 1996 · N16JD · Substantial damageNTSB CHI96FA067Accident · 2 fatalField investigationFinal reportCessna 560 · Eagle River, WIthe failure of the pilot to maintain airspeed while executing the circling approach. Factors were the descent below minimum descent altitude, the fog, the low ceiling and the icing conditions.Dec 30, 1995 · N991PC · DestroyedNTSB CHI95LA324Accident · No injuriesLimited investigationFinal reportCessna 177 · Camp Lake, WIthe pilot's inadequate compensation for wind conditions, and failure to maintain altitude/clearance from the power line, while on short final approach. The downdraft was a related factor.Sep 16, 1995 · N3497T · Substantial damageNTSB CHI95LA133Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Elk Creek, WIthe pilot's failure to maintain clearance with the trees. Factors in the accident include the trees, the tailwind condition, and the pilot's lack of proper certification.Apr 23, 1995 · N26991 · Substantial damageNTSB CHI95FA126Accident · 4 fatalField investigationFinal reportCessna 150M · Oshkosh, WIInadequate visual lookout by the pilot of the Beech V35B, resulting in his failure to see-and-avoid the Cessna 150, which was ahead and below him on final approach; and failure of the tower controller to provide adequate service (flight advisories and landing…Apr 14, 1995 · N45457 · 2 aircraft · DestroyedNTSB NYC95FA056Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Chippewa Falls, WIThe pilot's improper decision to depart into known adverse weather conditions, and the subsequent encounter with freezing drizzle, resulting in an inadvertent stall and collision with the terrain during an approach to land. Also causal to the accident was the…Feb 15, 1995 · N9YP · DestroyedNTSB CHI95LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Brookfield, WIThe instructor's failure to maintain clearance with trees. Factors associated with the accident were the trees and the night lighting conditions.Jan 16, 1995 · N39955 · DestroyedNTSB CHI94LA334Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Madison, WIThe pilot-in-command not maintaining a proper glidepath during his final approach to landing. A factor associated with the accident was the lack of recent experience in the type operation performed by the pilot.Sep 18, 1994 · N2283Q · Substantial damageNTSB CHI94LA237Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Butte Des Mort, WIA delayed remedial action by the instructor. A factor in this accident was a proper airspeed not being attained by the dual student.Jul 20, 1994 · N9843Q · Substantial damageNTSB CHI94LA221Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Land O'Lakes, WIthe pilot's failure to maintain clearance with trees. Factors in the accident were the trees, the pilot's operation with known deficiencies in equipment, and the pilot's diverted attention.Jul 6, 1994 · N625P · Substantial damageNTSB CHI94LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Wausaukee, WIthe pilot's inadequate preflight of the airplane.May 21, 1994 · N7867H · Substantial damageNTSB CHI94LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madison, WIThe pilot-in-command's poorly planned approach and failure to maintain the proper glidepath. The dark night was a factor.Mar 7, 1994 · N2145T · Substantial damageNTSB CHI94LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Burlington, WIThe student pilot's failure to maintain the proper glideslope.Feb 2, 1994 · N5094S · Substantial damageNTSB CHI94FA048Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Antigo, WIthe failure of the pilot in command to maintain proper altitude.Dec 10, 1993 · N550BC · Substantial damageNTSB CHI94DEP01Accident · No injuriesFinal reportKrotje Kolb Mark III · Oshkosh, WIThe lack of carburetor heat for the engine. A factor related to the accident was: the weather condition, which was favorable for formation of carburetor ice.Nov 28, 1993 · N393PK · Substantial damageNTSB CHI94LA021Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Byron, WIthe pilot's inaccurate fuel consumption calculations which resulted in his not refueling during the flight. A factor related to the accident was the pilot's failure to maintain proper airspeed during the forced landing.Oct 24, 1993 · N5390B · DestroyedNTSB CHI93DEP01Accident · No injuriesFinal reportBryant Mustang II · Kenosha, WIThe pilot-in-command's not maintaining control of the aircraft.May 16, 1993 · N90YP · DestroyedNTSB CHI93LA150Accident · Minor injuriesLimited investigationFinal reportCessna U206F · Oshkosh, WILoss of engine power for an undetermined reason.Apr 30, 1993 · N50963 · Substantial damageNTSB CHI93FA038Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Brookfield, WISpatial disorientation, and failure to maintain proper glidepath.Nov 21, 1992 · N1892J · DestroyedNTSB CHI92LA123Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brookfield, WIFailure of the pilot (CFI) to attain the proper touchdown point for landing. Factors related to the accident were: the unfavorable wind condition, the excessive descent rate that developed on final approach, and the cfi's delay in taking remedial action to…Apr 5, 1992 · N6350A · Substantial damageNTSB CHI92FA110Accident · 2 fatalField investigationFinal reportCessna 310R · Superior, WIInadequate airspeed, which resulted in an inadvertent stall/spin, and failure of the instructor pilot to take sufficient remedial action to prevent the loss of control.Mar 11, 1992 · N1328G · DestroyedNTSB CHI91LA299Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Boscobel, WIImproper remedial action by the pilot-in-command (PIC), and inadequate monitoring by the designated pilot examiner (DPE) during a simulated emergency procedure. Factors related to the accident were: the loss of power in one engine due to an undetermined…Sep 20, 1991 · N915PM · Substantial damageNTSB CHI91LA258Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Delavan, WIMisjudged fuel consumption calculations by the pilot which resulted in fuel exhaustion. A factor related to the accident was refueling not performed.Aug 9, 1991 · N6159F · Substantial damageNTSB CHI91DER03Accident · 1 fatalFinal reportVarieze 001 · Superior, WIThe pilot's poor planning and decision making which resulted in a loss of engine power due to fuel exhaustion.Apr 19, 1991 · N87VE · DestroyedNTSB CHI91LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Marshfield, WIImproper in-flight planning/decision by the pilot and his failure to maintain airspeed, which resulted in an inadvertent stall/mush onto snow covered terrain beside the runway. The adverse weather conditions and snow covered terrain were related factors.Feb 7, 1991 · N6205J · Substantial damageNTSB CHI91FA088Accident · 7 fatalField investigationFinal reportPiper PA-28-140 · Osceola, WIFailure of the pilots in both aircraft to seeing-and-avoid the other airplane.Feb 3, 1991 · N4676R · 2 aircraft · DestroyedNTSB CHI91DEP03Accident · 1 fatalFinal reportAir Command 503 · Tomahawk, WIThe pilot-in-command's abrupt movement of the flight controls which resulted in loss of rotor RPM and eventual departure from controlled flight. A factor contributing was ice accumulation on the pilot's face resulting in pilot incapacitation (visual…Jan 15, 1991 · UNREG · DestroyedNTSB CHI91LA042Accident · No injuriesLimited investigationFinal reportCessna 150 · Portage, WIDelayed go-around and stall encountered. Contributing factors were a snow bank, proper alignment not attained, and raising the flaps not performed by the PIC.Dec 6, 1990 · N11327 · Substantial damageNTSB CHI91DEP01Accident · No injuriesFinal reportDean Bartel Avid Flyer Stol · New London, WIThe pilot's failure to obtain a proper touchdown point and his delay in initiating a go-around.Nov 4, 1990 · N287AF · Substantial damageNTSB CHI90DEP08Accident · Minor injuriesFinal reportChristen Industries Eagle II · Milwaukee, WIThe pilot-in-command's failure to maintain aircraft control, his misjudgment of proper glidepath and his not performing a timely go-around.Aug 7, 1990 · N44ED · Substantial damageNTSB CHI90FA208Accident · Serious injuriesField investigationFinal reportLockheed 12A · Oshkosh, WIThe inadequate emergency procedure(s) by the pilot in command following a loss of engine power for undetermined reasons(s).Jul 31, 1990 · N12AT · DestroyedNTSB CHI90LA199Accident · No injuriesLimited investigationFinal reportFouga FOUGA-MAGISTER · Oshkosh, WIThe pilot-in-command's failure to maintain proper airspeed in turn from base to final.Jul 26, 1990 · N302FM · Substantial damage