NTSB investigations, WI

580 cases where the phase of flight was Enroute.

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 = 400)
  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 CHI84LA329Accident · Minor injuriesLimited investigationFinal reportGulfstream AA-5A · Wausau, WIDrg a x-country flt at 4500 ft, eng began sputtering. Plt adusted the mix; then applied carb heat, but rprtdly for only a short time. Eng contd operg, but at reduced pwr. Acft lost alt & dscndd into clds, but the plt was able to lvl at APRX500' AGL. He…Aug 4, 1984 · N26883 · DestroyedNTSB CHI84FA374Accident · 2 fatalField investigationFinal reportPiper PA-28-180F · Cable, WIThe acft collided with trees & ground during IMC wx at night. The plt obtained a wx briefing at 1731 hrs CDT by phone from hibbing fss. He was advised that VFR flt was not recommended. No other wx briefing for this flt was recorded. Witnesses at the arpt of…Aug 4, 1984 · N3963R · DestroyedNTSB CHI84FA303Accident · 3 fatalField investigationFinal reportCessna 421 · Birchwood, WIDuring flt, the plt transmitted to ARTCC 'we've got a problem, we're losing altitude.' The controller provided a vector to the nearest arpt, but shortly after that, the plt stated that he would not be able to reach the arpt. The plt did not inform ARTCC of…Jul 20, 1984 · N14TC · DestroyedNTSB CHI84LA204Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Middleton, WIPwr loss experienced during normal cruise flt. Plt received vector to nearest airport. There was no evidence of attempt to regain power. On approach to airport, plt extended lndg gear. Resultant drag factor increased glide angle to extent plt felt clearance…May 25, 1984 · N93009 · Substantial damageNTSB CHI84LA166Accident · Minor injuriesLimited investigationFinal reportGrumman AA5A · Cudahy, WIThe acft struck a storage shed while attempting to reach a golf course during an emergency landing in gusty wind conditions. There were no visible signs or odor of fuel at the accident site. When the acft was inspected the carburetor and fuel sumps were…Apr 28, 1984 · N26404 · Substantial damageNTSB CHI84LA164Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Bloomer, WIPlt failed to visually check fuel tanks after they were refueled. On the second leg of a x-country fuel exhaustion occurred. The acft nosed over during the forced landing on soft terrain.Apr 27, 1984 · N30609 · Substantial damageNTSB CHI84IA155Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Milwaukee, WIA gear up landing was performed after the crew was unable to extend the rgt main gear thru normal & emerg procedures. An exam of the acft disclosed the rgt main gear door aft hinge bolt was slightly bent & difficult to rotate in its bushing. The bushing &…Apr 16, 1984 · N163MA · Minor damageNTSB CHI84LA132Accident · Minor injuriesLimited investigationFinal reportCessna 337A · Genesee, WIThe acft made a forced landing after the engine lost power. The acft was inspected after the accident and found to contain no usable fuel. When the fuel was drained from the auxiliary tanks, the fuel quantity indicators showed five gallons in each tank.Mar 17, 1984 · N6271F · Substantial damageNTSB CHI84LA032Accident · No injuriesLimited investigationFinal reportCessna 150 · La Crosse, WIThe acft was ditched in lake onalaska after the engine quit about 1 mile short of destination. After the accident the acft was pulled from the lake and examined. The 3 FAA inspectors who examined the acft verified that there was not enough fuel in the acft to…Oct 30, 1983 · N23183 · Substantial damageNTSB CHI84LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Waupaca, WIPlt had made missed approaches at wausau & mosinee. Plt informed artc that he had a fuel problem. While receiving vectors to Waupaca arpt the eng quit & the acft crashed into trees. Total time of flt was 4+33. The right tank fuel filler cap was loose & the…Oct 7, 1983 · N7695J · Substantial damageNTSB CHI83IA442Incident · No injuriesIncident investigationFinal reportCessna 172RG · Shell Lake, WIThe number 4 exhaust pushrod failed in flight for an undetermined reason.Sep 24, 1983 · N4963V · No damageNTSB CHI83LA349Accident · No injuriesLimited investigationFinal reportBeech A24R · Verona, WIThe acft lost power during cruise and was damaged in an off arpt forced landing. During the landing roll in a field, acft contacted a fence and collapsed the nose gear. Examination of the bendix fuel injector SN30479, model RSA-5AD1 revealed that the fuel…Aug 2, 1983 · N8016R · Substantial damageNTSB CHI83LA341Accident · No injuriesLimited investigationFinal reportSnow 600-S2C · Plainfield, WIThe acft caught fire in the air after a power loss. A forced landing was accomplished and the pilot escaped without injury but the acft was destroyed by the fire. It was reported that the fire was so intense that all evidence of cause was destroyed. The acft…Jul 30, 1983 · N1678S · DestroyedNTSB CHI83FAMS1Accident · 1 fatalMissing aircraftFinal reportGrumman AA-1 · Manitowoc, WIThe acft disappeared from radar contact while over lake Michigan. This acft had departed baltimore MD at 1142 CDT to flyto Manitowoc, WI. The last enroute stop for fuel was at muskegon mi at 2040 CDT. The weather was VMC but the night was dark. No flt plan…Jul 9, 1983 · N6214L · DestroyedNTSB CHI83LA282Accident · No injuriesLimited investigationFinal reportLombard Dilley 68 · Camp Douglas, WIThe experimental acft lost a blade of its propeller during cruise flt. The propeller had been modified to obtain more RPM. About 18 inches of one blade separated during cruise at 6000 ft with 2900 RPM at 200 KTS airspeed. The engine remained attached to the…Jun 13, 1983 · N301LS · Substantial damageNTSB CHI83LA150Accident · No injuriesLimited investigationFinal reportConsolidated-Vultee 28-5ACF · Neilsville, WIThe aircraft was crash landed in an open field after it had a power loss on #1 engine during cruise flight. The aircraft was on a geodetic survey flight which called for flight at 500 feet AGL. The pilot elected to land because the aircraft could not maintain…Mar 22, 1983 · N4760C · Substantial damageNTSB CHI83IA103Incident · No injuriesIncident investigationFinal reportEmbraer EMB-110 · Milwaukee, WIThe acft experienced extreme oscillations about the pitch axis with the control column moving fore & aft from 1 to 3 inches. The oscillations varied directly with airspeed. No out of limit conditions were found until after a second occurrence when the…Feb 4, 1983 · N1356P · Minor damageNTSB CHI83FA090Accident · 2 fatalField investigationFinal reportPiper PA-22-20 · Siren, WIWitnesses heard a sound of an acft eng, but because of low clouds & fog they could not see the acft. They heard the sound of the eng, a loud roar, the breaking of trees, & thena 'bang.' They then found the acft which had penetrated a wooded area at a 70 deg…Jan 23, 1983 · N3925P · DestroyedNTSB CHI83FA086Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Monroe, WIWhile cruising at 4,000 ft MSL the eng quit. During a forced landing on rolling farm terrain both main landing gear separated. The acft then slid through a barbed wire fence & caught fire. Metallurgical examination revealed a fatigue failure of the idle set…Jan 19, 1983 · N5818F · DestroyedNTSB CHI83LA081Accident · Serious injuriesLimited investigationFinal reportCessna 172 RG · Green Bay, WIThe acft collided with the ground during an ILS approach. The weather was IMC at the time and an IFR flt plan was filed. The pilot was instrument rated and had received a weather briefing which forecast icing and freezing drizzle. The pilot told the weather…Jan 14, 1983 · N9916B · Substantial damageNTSB CHI83LA067Accident · No injuriesLimited investigationFinal reportCessna T210N · Cassville, WIThe pilot stated that he refueled at mobile but did not visually check the fuel tanks. The pilot thought he had 15 gallons of fuel remaining at the time the engine loss power. Fuel tanks were switched from left to right and held on "hi" boost (auxiliary boost…Jan 1, 1983 · N6594N · DestroyedNTSB CHI82DA295Accident · No injuriesFinal reportBoeing Stearman A75-300N1 · Whitehall, WIThe pilot received a weather briefing before takeoff, and reportedly, was advised that VFR flight was not recommended. During the flight, the ceiling and visibility began to decrease. The pilot decided to make a precautionary landing in a field. He stated…Aug 5, 1982 · N802RB · Substantial damageNTSB CHI82DA294Accident · No injuriesFinal reportBreezy RLU1 · Milwaukee, WIThe pilot stated that he got a weather briefing before departing oshkosh, WI. While en route, he encountered fog and rain. The pilot attempted to continue to find timmerman or rainbow airport. The engine lost power due to fuel exhaustion. While landing on a…Aug 5, 1982 · N59Y · Substantial damageNTSB CHI82DA230Accident · No injuriesFinal reportPiper PA-28-161 · Ladysmith, WIThe student pilot collided with a fence and rough terrain during a forced landing on a cross-country flight. The student heard a loud knocking from the engine after about 35 minutes of flight. He reduced power which helped but the engine was still noisy. The…Jul 1, 1982 · N40037 · Substantial damageNTSB CHI82FA157Accident · Minor injuriesField investigationFinal reportPiper PA-32-300 · Milwaukee, WIEngine failure forced pilot to land in an open plowed field. Aircraft collided with wires but a successful landing was made. Oil pump gear tooth had failed.May 9, 1982 · N6837J · Substantial damageNTSB CHI82DA140Accident · No injuriesFinal reportBeech BE-19 · Ridgeville, WIThe student pilot departed oshkosh, WI on a round robin cross country flight. The flight was destined for rockford, IL, lacrosse, WI and oshkosh. The aircraft departed oshkosh with full fuel tanks and was not refueled en route. The total duration of the…Apr 28, 1982 · N5204M · Substantial damageNTSB CHI82FEP13Accident · No injuriesClosedCessna 210C · Baraboo, WIDec 11, 1981 · N3677Y · DestroyedNTSB CHI82DEP12Accident · No injuriesClosedCessna 140 · Hayward, WINov 27, 1981 · N3174N · Substantial damageNTSB CHI81DEP47Accident · No injuriesClosedBensen B-8M · Manitowoc, WISep 12, 1981 · N513DE · Substantial damageNTSB CHI81FA091Accident · 3 fatalClosedMooney M20J · La Pointe, WIAug 20, 1981 · N1098Y · DestroyedNTSB CHI81FEP41Accident · No injuriesClosedDehavilland DHC-1 · Mequon, WIAug 6, 1981 · N1114V · Substantial damageNTSB CHI81DEP22Accident · No injuriesClosedBell 47G-5 · Coloma, WIJun 12, 1981 · N1315X · Substantial damageNTSB CHI81FEP19Accident · No injuriesClosedPiper PA-12 · Spring Green, WIMay 25, 1981 · N78459 · Substantial damageNTSB CHI81FA039Accident · 2 fatalClosedCessna A185F · Patzau, WIMar 26, 1981 · N4862C · DestroyedNTSB CHI81FEP10Accident · Minor injuriesClosedBeech A23-24 · Fitchburg, WIMar 7, 1981 · N3660Q · Substantial damageNTSB CHI81FEP09Accident · Minor injuriesClosedCessna 150M · Montfort, WIFeb 26, 1981 · N63547 · Substantial damageNTSB CHI81DA017Accident · No injuriesClosedBeech 58TC · Elkhart Lake, WIJan 2, 1981 · N319CA · Substantial damageNTSB CHI80FEP53Accident · Serious injuriesClosedBell 206 · Grafton, WISep 8, 1980 · N256DE · Substantial damageNTSB CHI80FEP52Accident · No injuriesClosedCessna 180 · Bevent, WISep 2, 1980 · N180FS · Substantial damageNTSB CHI80FA066Accident · 1 fatalClosedPiper PA-28 · Antigo, WIAug 29, 1980 · N1807J · DestroyedNTSB CHI80FEP44Accident · Minor injuriesClosedPiper PA-28 · Collins, WIAug 7, 1980 · N6796W · Substantial damageNTSB CHI80FEP38Accident · Minor injuriesClosedCessna 177RG · New Lisbon, WIJul 7, 1980 · N34365 · Substantial damageNTSB CHI80FEP31Accident · Serious injuriesClosedTomcat MARK5A · Stockbridge, WIMay 23, 1980 · N19JM · Substantial damageNTSB CHI80FEP17Accident · Minor injuriesClosedCessna 172 · Bruce, WIFeb 6, 1980 · N1167V · Substantial damageNTSB CHI80FEP15Accident · No injuriesClosedBellanca 17-30 · Darlington, WIFeb 3, 1980 · N7369V · Substantial damageNTSB CHI80FEP14Accident · No injuriesClosedCessna 150K · Wonewoc, WIJan 20, 1980 · N566GS · Substantial damageNTSB CHI80DEP12Accident · No injuriesClosedM.B.B. BO-209 · Johnson Creek, WIDec 29, 1979 · N209SF · Substantial damageNTSB CHI80IEP10Accident · No injuriesClosedMooney M20J · Waterloo, WIDec 21, 1979 · N201UW · Substantial damageNTSB CHI80FEP02Accident · Minor injuriesClosedBeech 56TC · Middleton, WIOct 15, 1979 · N7115N · Substantial damageNTSB CHI80DEP01Accident · No injuriesClosedBeech 19 · Big Bend, WIOct 8, 1979 · N5431M · Substantial damage