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 CHI84LA131Accident · No injuriesLimited investigationFinal reportCessna 152 · Lone Rock, WIDuring the takeoff following a touch and go landing the acft swerved to the left and collided with a snowbank. The plt said he reached for the carburetor heat control and flap handle as the acft swerved. After the collision the acft nosed over.Jan 31, 1984 · N25216 · Substantial damageNTSB CHI84LA096Accident · No injuriesLimited investigationFinal reportCessna 150M · West Bend, WIThe acft went out of control during the takeoff roll after a touch and go landing. The plt stated that, as he applied power and went to raise the flaps the acft began to drift to the left. When he applied right rudder the acft began to skid to the right. He…Jan 26, 1984 · N63178 · Substantial damageNTSB CHI84FA022Accident · Minor injuriesField investigationFinal reportPiper PA-28-181 · Dodgeville, WIMomentarily after lifting off, the plt heard a pronounced decrease in eng noise & noted that the tachometer indication had dropped to 1950 RPM. He elected to abort, but was unable to stop on the remaining rwy. After departing the rwy, the acft hit an object &…Oct 16, 1983 · N8419G · DestroyedNTSB CHI83LA404Accident · Serious injuriesLimited investigationFinal reportMockrud Volksplane · Cottage Grove, WIThe owner of the new home built acft had given the plt permission to taxi the plane, but not to takeoff. The plt stated that he inadvertently became airborne while making a high speed taxi check, then the eng lost power. A witness stated that the acft became…Aug 31, 1983 · N4244R · DestroyedNTSB CHI83LA400Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Blair, WIThe acft collided with a fence during an aborted takeoff. The student was on a solo training flt when the accident occurred. This was the first takeoff of the flt. The field was soft and the pilot decided to abort the takeoff during the ground roll. He was…Aug 28, 1983 · N3576R · Substantial damageNTSB CHI83FU010Accident · 1 fatalFinal reportTeratorn Tierra · Pepin, WIThe plt had recently purchased & assembled the ultralight vehicle. The person who sold him the ultralight said that he saw the vehicle on the night before. According to him, it 'looked like he had it together all right.' He said it was his impression the plt…Aug 24, 1983 · UNREG · DestroyedNTSB CHI83LA176Accident · No injuriesLimited investigationFinal reportCessna 182 · Madison, WIThe aircraft groundlooped and rolled inverted during the takeoff roll. The student pilot stated that during the takeoff roll the sun broke through the clouds and blinded him. He reported, that this condition plus the crosswind interferred with his ability to…Apr 23, 1983 · N1683M · Substantial damageNTSB CHI82DA369Accident · No injuriesFinal reportPiper PA-25-180 · Baldwin, WIThe pilot attempted to takeoff from a 1200 ft alfalfa field with a load of seed but was unable to obtain flying speed. By the time he realized the situation, there was not enough room to stop. He reported that he released the back pressure until he was near…Sep 30, 1982 · N6140Z · Substantial damageNTSB CHI82DA309Accident · No injuriesFinal reportCessna 152 · Boyceville, WISolo student pilot on 2nd takeoff after a delay aborted the takeoff. During abort he lost control and ground- looped into a pile of logs. The aircraft then nosed over.Aug 12, 1982 · N25325 · Substantial damageNTSB CHI82DA205Accident · Minor injuriesFinal reportVolmer Sportsman · Pulaski, WIOn his first flight of the aircraft during this calendar year, the pilot aborted his takeoff. On the second attempt he started to abort but the engine surged and the aircraft became airborne. He stated that he continued to have a problem with the engine and…Jun 12, 1982 · N9011 · DestroyedNTSB CHI82DA083Accident · No injuriesFinal reportCessna 152 · Milwaukee, WIThe student was practicing touch and go landings on a snow covered runway. After applying power for takeoff during the third touch and go, the aircraft veered left and hit a snowbank.Mar 5, 1982 · N6125B · Substantial damageNTSB CHI82DA029Accident · No injuriesFinal reportMooney M-20 · Shell Lake, WIThe pilot initiated his takeoff roll on a runway covered with hard packed snow. As the nosewheel was lifted off of the runway, the aircraft started to drift left. The pilot stated that when he applied right rudder and slightly lowered the nose, the plane came…Jan 22, 1982 · N6029Q · Substantial damageNTSB CHI82FA016Accident · 2 fatalClosedCessna 182E · Platteville, WINov 26, 1981 · N2860Y · DestroyedNTSB CHI81DEP29Accident · Minor injuriesClosedGrumman AA-5 · Summit Lake, WIJul 5, 1981 · N9564L · Substantial damageNTSB CHI81DEP26Accident · No injuriesClosedGrumman AA-5A · Rio, WIJun 28, 1981 · N9820U · Substantial damageNTSB CHI81DEP13Accident · No injuriesClosedVolksplane VP-1 · Weston, WIMar 22, 1981 · N3875 · Substantial damageNTSB CHI81DEP11Accident · No injuriesClosedCessna 182 · Portage, WIMar 10, 1981 · N8415T · Substantial damageNTSB CHI81FA005Accident · 1 fatalClosedCessna 172 · Westfield, WINov 2, 1980 · N7686G · DestroyedNTSB CHI80FEP60Accident · No injuriesClosedPiper PA-28 · Cornucopia, WISep 1, 1980 · N33444 · Substantial damageNTSB CHI80DEP35Accident · No injuriesClosedCessna 172D · Delavan, WIJun 8, 1980 · N2413Y · Substantial damageNTSB CHI80DEP34Accident · No injuriesClosedCessna 152 · Watertown, WIMay 27, 1980 · N4809A · Substantial damageNTSB CHI80DEP32Accident · No injuriesClosedStearman A75-N1 · City Point, WIMay 23, 1980 · N63111 · Substantial damageNTSB CHI80DEP20Accident · Minor injuriesClosedVertol 42A · Neosho, WIMar 21, 1980 · N96244 · Substantial damageNTSB CHI79FEP77Accident · No injuriesClosedCessna 182 · Manitowish Wtr, WISep 4, 1979 · N3VH · Substantial damageNTSB CHI79FEP41Accident · No injuriesClosedAerofab LA4200 · Coloma, WIApr 10, 1979 · N65702 · Substantial damageNTSB CHI79DEP37Accident · No injuriesClosedCessna 150 · Watertown, WIMar 17, 1979 · N63586 · Substantial damageNTSB CHI79DEP32Accident · No injuriesClosedCessna 152 · Eau Claire, WIFeb 26, 1979 · N89048 · Substantial damageNTSB CHI79DEP33Accident · No injuriesClosedCessna 150K · Platteville, WIFeb 19, 1979 · N6206G · Substantial damageNTSB CHI79FEP22Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIJan 14, 1979 · N6695A · Substantial damageNTSB CHI79DEP14Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIDec 17, 1978 · N6858A · Substantial damageNTSB CHI78FEP63Accident · Minor injuriesClosedGrum Amer AA5A · Waterford, WIAug 28, 1978 · N1118A · Substantial damageNTSB CHI78DEP46Accident · No injuriesClosedCessna 150 · Kewaunee, WIJul 19, 1978 · N116DH · Substantial damageNTSB CHI78DEP44Accident · No injuriesClosedPiper PA-28 · Gleason, WIJul 10, 1978 · N541F1 · Substantial damageNTSB CHI78FEP41Accident · No injuriesClosedPiper PA-32 · Lakewood, WIJul 8, 1978 · N5524F · Substantial damageNTSB CHI78DEP35Accident · Minor injuriesClosedMustang II · Lancaster, WIMay 21, 1978 · N4790 · Substantial damageNTSB CHI78DEP34Accident · Minor injuriesClosedHughes 269 · B1rchwood, WIMay 21, 1978 · N7449F · Substantial damageNTSB CHI78FER01Accident · No injuriesClosedBeech D18S · Osceola, WIOct 30, 1977 · N273C · Substantial damageNTSB CHI77DEP27Accident · No injuriesClosedPiper PA-28 · Waupun, WIMar 20, 1977 · N56140 · Substantial damageNTSB CHI77DER02Accident · No injuriesClosedCessna 172F · Glenwood City, WIFeb 3, 1977 · N8121U · Substantial damageNTSB CHI77DER01Accident · No injuriesClosedCessna 170B · Rice Lake, WIJan 23, 1977 · N1782D · Substantial damageNTSB CHI77FEP10Accident · Serious injuriesClosedBeech C55 · Eau Claire, WIDec 9, 1976 · N551U · Substantial damageNTSB CHI77FEP07Accident · No injuriesClosedPiper PA-32R · Ashippun, WINov 27, 1976 · N6273J · Substantial damageNTSB CHI76DEP26Accident · No injuriesClosedPiper PA-18 · Milwaukee, WIFeb 23, 1976 · N326T · Substantial damageNTSB CHI76FER02Accident · No injuriesClosedPiper PA-18 · Cumberland, WIJul 28, 1975 · N5404Y · Substantial damageNTSB CHI75DEP56Accident · No injuriesClosedCessna 140 · Reedsville, WIMay 21, 1975 · N1893V · DestroyedNTSB CHI75DEP47Accident · No injuriesClosedMaule M4220C · Waupaca, WIMar 14, 1975 · N9874M · Substantial damageNTSB CHI75FEP37Accident · No injuriesClosedAeronca 11AC · Waupaca, WIJan 2, 1975 · N9428E · Substantial damageNTSB CHI74FEP40Accident · No injuriesClosedCessna 310Q · Park Falls, WIApr 1, 1974 · N69684 · Substantial damageNTSB CHI74DEP25Accident · No injuriesClosedCessna 172 · Sturgeon Bay, WIDec 29, 1973 · N3907Q · Substantial damageNTSB CHI74DEP21Accident · No injuriesClosedPiper PA-28 · Lake Geneva, WINov 22, 1973 · N1783T · Substantial damage