NTSB investigations, WI

261 cases where the phase of flight was Takeoff.

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 = 300)
  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 CEN10LA145Accident · No injuriesLimited investigationFinal reportHawker Beechcraft A36 · Milwaukee, WIThe pilot's retraction of the landing gear prior to establishing a positive climb rate.Mar 6, 2010 · N1114X · Substantial damageNTSB CEN09CA522Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Evansville, WIA jam of the elevator flight control for undetermined reasons.Aug 12, 2009 · N9794 · Substantial damageNTSB CEN09LA486Accident · No injuriesLimited investigationFinal reportGallagher Junior ACE · Oshkosh, WIThe failure of a weld joint on the right rudder pedal leading to the loss of directional control during landing.Aug 2, 2009 · N413G · Substantial damageNTSB CEN09CA279Accident · Minor injuriesData collectionFinal reportAmerican AA-1 · Cumberland, WIThe pilot's failure to maintain control of the aircraft during takeoff in crosswind conditions.May 3, 2009 · N5905L · Substantial damageNTSB CEN09CA078Accident · No injuriesData collectionFinal reportCessna 172S · Waukesha, WIThe pilot's failure to maintain aircraft control during takeoff and his failure to ensure that the elevator trim was properly set before takeoff. Contributing to the accident was the pilot's lack of autopilot system knowledge.Nov 26, 2008 · N833SP · Substantial damageNTSB CHI08CA233Accident · Minor injuriesData collectionFinal reportErcoupe 415-C · Cedarburg, WIThe pilot not maintaining altitude/clearance from the tree during takeoff. Contributing to the accident were the windshear and the tree.Aug 2, 2008 · N93963 · Substantial damageNTSB CHI08LA197Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Sparta, WIThe pilot's inadequate preflight planning and the pilot's delay in aborting the takeoff. Contributing to the accident was the airplane's overgross weight condition.Jul 19, 2008 · N2133V · Substantial damageNTSB CHI08CA073Accident · Serious injuriesData collectionFinal reportSquier Pauper II · Stockbridge, WIThe pilot's spatial disorientation while maneuvering after takeoff and his subsequent failure to maintain clearance from the terrain. Contributing factors were the snow-covered lake and overcast clouds, which resulted in the pilot's spatial disorientation due…Feb 3, 2008 · N70727 · Substantial damageNTSB CHI07LA280Accident · Serious injuriesLimited investigationFinal reportMcFaul, Daniel D. Quicksilver GT500 · New London, WIThe pilot not maintaining airspeed during the unintentional takeoff and the pilot's inadvertent stall.Aug 27, 2007 · UNREG · Substantial damageNTSB CHI07LA249Accident · No injuriesLimited investigationFinal reportCessna C-177 · Webster, WIThe loss of engine power for an undetermined reason, and the pilot's misjudged flare during the subsequent forced landing.Jul 8, 2007 · N2292Y · Substantial damageNTSB CHI07LA168Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Lakewood, WIThe amphibian nose wheel strut assembly separated due to an overload fracture as a result of the manufacturer's inadequate design.Jun 13, 2007 · N736MV · Substantial damageNTSB CHI07CA112Accident · No injuriesData collectionFinal reportPZL Warzawa-CNPSL PZL-104 Wilga 35A · Waukesha, WIThe pilot's decision to attempt flight following the initial loss of engine power and successful forced landing to a cornfield. An additional cause was the loss of engine power for undetermined reasons. A contributing factor was the furrowed cornfield…Apr 21, 2007 · N231E · Substantial damageNTSB CHI07LA091Accident · Serious injuriesLimited investigationFinal reportHaddan Sonerai IIL · Fort Atkinson, WIThe pilot's failure to maintain airspeed following a loss of engine power for undetermined reasons. A low altitude and an inadvertent stall were factors.Mar 17, 2007 · N5200C · Substantial damageNTSB CHI06CA253Accident · No injuriesData collectionFinal reportHedeman Tailwind W8 · Platteville, WIThe loss of engine power as a result of the pilot's inadequate preflight which resulted in a blocked fuel vent that led to fuel starvation.Sep 3, 2006 · N4FD · Substantial damageNTSB CHI06FA128Accident · Serious injuriesField investigationFinal reportRobinson R44 · East Troy, WIThe pilot's failure to calculate the weight and balance of the helicopter prior to flight, his failure to recognize and correct the forward center of gravity condition and his failure to abort the takeoff. A factors was the pilot's improper decision to…May 13, 2006 · N442GS · Substantial damageNTSB CHI06FA110Accident · 1 fatalField investigationFinal reportMesserschmitt-Bolkow-Blohm BO 105LS A-3 · Green Bay, WIThe pilot's inadequate preflight check of the flight controls prior to takeoff and the directional contol not possible by the pilot. Additional causes were the improper installation of the anti-torque pedal cover by company personnel which blocked the flight…Apr 13, 2006 · N202LF · Substantial damageNTSB CHI05IA273Incident · No injuriesIncident investigationFinal reportConvair Div. of Gen. Dynamics 440 · Kenosha, WIThe flight crew failed to verify that the cargo was secured before takeoff.Sep 22, 2005 · N181FL · Minor damageNTSB CHI05CA266Accident · No injuriesData collectionFinal reportRyan Navion G · Lake Geneva, WIThe loss of engine power due to water contamination of the fuel and the pilot's inadequate preflight. A factor was the fence.Sep 14, 2005 · N2401T · Substantial damageNTSB CHI05LA237Accident · 1 fatalLimited investigationFinal reportKircher RV-8 · Menomonie, WIThe pilot's decision to perform an aerobatic roll during takeoff, the low altitude, and his failure to maintain clearance from the crops and terrain.Aug 21, 2005 · N505DF · DestroyedNTSB CHI05CA206Accident · No injuriesData collectionFinal reportLuscombe 8F · Sturtevant, WIThe pilot not obtaining/maintaining airplane control during the aborted takeoff. A factor was the berm.Jul 31, 2005 · N1841B · Substantial damageNTSB CHI05CA184Accident · Minor injuriesData collectionFinal reportHirsch RV-6A · Oshkosh, WIThe pilot's failure to maintain directional control during the takeoff. Contributing factors were the uneven (rough) runway surface and the fence.Jul 14, 2005 · N125WH · Substantial damageNTSB CHI05CA146Accident · No injuriesData collectionFinal reportCessna 172N · Madison, WIThe pilot's improper pre-flight which resulted in the control lock not being removed and his subsequent inability to control the airplane. The unmarked control lock and the FBO's failure to replace the unmarked control lock were factors in the accident.Jun 13, 2005 · N6454J · Substantial damageNTSB CHI04CA219Accident · No injuriesData collectionFinal reportLake LA4-200 · Oshkosh, WIThe unsuitable rough water conditions encountered during the attempted water takeoff.Aug 1, 2004 · N1056L · Substantial damageNTSB CHI04CA189Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Merrill, WIThe dual student's failure to maintain directional control during the initial climb after takeoff and the flight instructor's delayed remedial action. A contributing factor was that all available runway was not used for takeoff due to the touch-and-go…Jul 21, 2004 · N45628 · Substantial damageNTSB CHI04LA079Accident · No injuriesLimited investigationFinal reportRobinson R44 · Burlington, WIThe pilot's inadequate visual lookout and his failure to obtain/maintain clearance from the transmission wire during the takeoff. Factors contributing to the accident were the transmission wire and the pole.Feb 28, 2004 · N7184G · Substantial damageNTSB CHI03LA225Accident · No injuriesLimited investigationFinal reportBeech C23 · Madison, WIThe dual student's delay in executing the aborted takeoff. Also causal was the pilot-in-command's delayed remedial action.Jul 25, 2003 · N9361S · Substantial damageNTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.Jun 8, 2003 · N63319 · DestroyedNTSB CHI03LA136Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Minocqua, WIThe pilot's failure to attain a proper climb rate during takeoff. A factor to the accident was the tree.May 17, 2003 · N4711U · Substantial damageNTSB CHI03LA093Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Sturtevant, WIThe student pilot's abrupt liftoff resulting in his failure to maintain adequate airspeed followed by a stall. Also causal was the instructor's inadequate supervision.Mar 30, 2003 · N45799 · Substantial damageNTSB CHI02LA255Accident · No injuriesLimited investigationFinal reportCessna 172P · Buffalo City, WIThe malfunction of the seat positioning system for undetermined reasons, which resulted in the loss of directional control. A factor to the accident was the descending embankment.Aug 19, 2002 · N381J · Substantial damageNTSB CHI02LA229Accident · Minor injuriesLimited investigationFinal reportPiper PA22-135 · Lyons, WIFailure of the pilot to maintain a sufficient rate-of-climb and to obtain a safe altitude/clearance from the tree line at end of the runway. Contributing factors were the uphill runway gradient and the trees.Aug 2, 2002 · N3522A · Substantial damageNTSB CHI02LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Appleton, WIThe pilots failure to maintain directional control of the airplane during the takeoff roll resulting in the subsequent impact with terrain.Apr 10, 2002 · N733PX · Substantial damageNTSB CHI02LA020Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Middleton, WIthe pilot's improper rotation and failure to maintain directional control during takeoff. Additional factors were the crosswind and the soft terrain.Nov 6, 2001 · N108MS · Substantial damageNTSB CHI02LA019Accident · No injuriesLimited investigationFinal reportPiper PA-32-301T · Phillips, WIThe fuel starvation encountered on takeoff and unsuitable terrain the pilot encountered during the forced landing. A factor was the fuel selector valve malfunction.Nov 4, 2001 · N82813 · Substantial damageNTSB CHI01LA324Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · East Troy, WIThe inadvertent dynamic rollover the student pilot encountered following his excessive control inputs during the takeoff portion of the instructional flight and the instructor not performing the remedial action necessary to reduce the excessive control inputs…Sep 26, 2001 · N214WW · Substantial damageNTSB CHI01FA297Accident · 3 fatalField investigationFinal reportBeech A23 · Stevens Point, WIthe pilot not obtaining/maintaining aircraft control.Aug 30, 2001 · N3516R · DestroyedNTSB CHI01IA248Incident · No injuriesIncident investigationFinal reportBoeing 727-2Q6 · Oshkosh, WIThe unsafe condition caused when the pilot taxied onto the runway. Factors relating to this accident were the pilot not following the instructions given him by the ground marshaller, his wrong taxi route, and his not obtaining clearance to taxi onto the…Jul 27, 2001 · N782AT · 2 aircraft · No damageNTSB CHI01LA171Accident · No injuriesLimited investigationFinal reportLarson Murphy Rebel · Stratford, WIThe pilot's failure to abort the takeoff from the farm field. Factors were the tall grass, the rising terrain, the fence, and the inadequate planning/decision by the pilot.Jun 17, 2001 · N622GL · Substantial damageNTSB CHI01LA159Accident · No injuriesLimited investigationFinal reportCessna 172M · Middleton, WIThe pilot attempted a touch and go on unsuitable terrain. A factor associated with the accident was the tall wet grass airstrip on which the touch and go was attempted.Jun 9, 2001 · N191WW · Substantial damageNTSB CHI01IA124Incident · No injuriesIncident investigationFinal reportBoeing 717-231 · Milwaukee, WIThe failure of the operator to provide complete and comprehensive thrust reverser lock-out maintenance procedures and guidance to the contract maintenance personnel resulting in a partial and inadequate securing of the faulty thrust reverser and a subsequent…Feb 19, 2001 · N2410W · No damageNTSB CHI01FA089Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Webb Lake, WIthe pilot not maintaining altitude/clearance from the trees during takeoff. Factors were the trees, transmission wire, and the dark night.Feb 15, 2001 · N120CC · DestroyedNTSB CHI01LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Prairie Du Sac, WIthe improper trim setting and the pilot failed to maintain control of the airplane. A factor was the snowbank.Jan 21, 2001 · N53118 · Substantial damageNTSB CHI00LA213Accident · No injuriesLimited investigationFinal reportCessna 120 · Shawano, WIInadequate preflight planning and the pilot's delay in aborting the takeoff. A factor was the road embankment.Jul 21, 2000 · N2961N · Substantial damageNTSB CHI00LA074Accident · No injuriesLimited investigationFinal reportCessna 150H · Wisconsin Rapid, WIThe student pilot's failure to maintain directional control. Factors were the pilot's lack of total experience and the snowbank.Feb 21, 2000 · N22017 · Substantial damageNTSB CHI00LA060Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · East Troy, WIThe proper alignment not being maintained by the dual student during an attempted running takeoff and the inadequate supervision of the pilot-in-command (CFI).Jan 22, 2000 · N4047C · Substantial damageNTSB CHI00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Crandon, WIthe deer that ran out onto the runway and collided with the airplane. A factor associated with the accident was the night lighting conditions.Oct 25, 1999 · N4776E · Substantial damageNTSB CHI99LA316Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Osceola, WIthe pilot's improper preflight decision to attempt a takeoff with one engine inoperative.Aug 28, 1999 · N6592Y · Substantial damageNTSB CHI99FA276Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Lake Geneva, WIthe aborted takeoff not performed by the safety-pilot and airspeed not obtained/maintained by the safety-pilot. Factors to the accident were directional control and runway alignment not maintained by the pilot-in-command, the inadequate supervision of the…Aug 5, 1999 · N4337X · Substantial damageNTSB CHI99LA282Accident · No injuriesLimited investigationFinal reportCessna 152 · Superior, WIthe student pilot's failure to maintain directional control of the airplane. Factors associated with the accident were the gusty wind condition, the student's lack of experience, and the soft terrain encountered.Jul 26, 1999 · N68268 · Substantial damageNTSB CHI98LA357Accident · No injuriesLimited investigationFinal reportCessna 182K · Baldwin, WIThe pilot's inadequate preflight planning and preparation, and his failure to stop on the wet, grassy runway. A related factor was the wet grass.Sep 20, 1998 · N2689Q · Substantial damage