NTSB investigations, 2002, MN

11 cases where the phase of flight was Takeoff.

Cases per year

19642026
NTSB investigations, 2002, MN per year, 1964–2026: 298 cases
19646
19657
19666
19679
19687
196912
19707
19718
197211
19736
19745
19758
19766
19779
19787
19799
19805
198113
19839
19842
19853
19863
19875
19886
19893
19903
19916
19922
19933
19946
19954
19963
19971
19981
19993
20006
20016
200211
20032
20043
20054
20063
20072
20084
20095
20102
20114
20121
20132
20145
20155
20163
20173
20181
20192
20205
20211
20225
20234
20244
20261

Latest cases

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 year(c.\"eventDate\") = 2002
    AND c.\"eventStateOrRegion\" = 'MN' 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 CHI03LA015Accident · No injuriesLimited investigationFinal reportCessna 172 · St. Paul, MNThe student pilot failed to maintain directional control. A factor was the runway sign.Oct 29, 2002 · N848SP · Substantial damageNTSB CHI02LA276Accident · No injuriesLimited investigationFinal reportCessna T188C · Olivia, MNThe fouled spark plugs and the terrain condition encountered during the aborted takeoff.Sep 10, 2002 · N9432J · Substantial damageNTSB CHI02IA270Incident · No injuriesIncident investigationFinal reportFokker 100 · Minneapolis, MNThe improper installation of the #2 main landing gear wheel, including the axle nut not being properly torqued and safetied, which resulted in the wheel separation during takeoff.Sep 5, 2002 · N1473K · Minor damageNTSB CHI02LA261Accident · No injuriesLimited investigationFinal reportMooney M20C · Warroad, MNThe loss of engine power due to the failure of the muffler baffles which blocked the exhaust system. A factor to the accident was the treeline.Aug 25, 2002 · N9274V · Substantial damageNTSB CHI02LA235Accident · Minor injuriesLimited investigationFinal reportCessna 185B · Brainerd, MNThe pilot's evasive maneuver to avoid obstacle clearance, resulting in a premature lift off with inadequate airspeed followed by a stall. The presence of the boat was a factor.Aug 4, 2002 · N11LP · Substantial damageNTSB CHI02LA221Accident · Minor injuriesLimited investigationFinal reportAir Tractor 301 · Ulen, MNThe pilot not performing an aborted takeoff. A factor was the soybean crop.Jul 26, 2002 · N3167P · Substantial damageNTSB CHI02LA208Accident · No injuriesLimited investigationFinal reportSchweizer 269C-1 · Askov, MNDirectional control not obtained/maintained during the aborted takeoff.Jul 20, 2002 · N897TH · Substantial damageNTSB CHI02LA156Accident · No injuriesLimited investigationFinal reportHale Kitfox Model III · Fairmont, MNFailure by the pilot to obtain adequate clearance from the tree line, as well as a failure to abort the takeoff in a timely manner. A contributing factor was the tree line.Jul 4, 2002 · N76WH · Substantial damageNTSB CHI02LA141Accident · No injuriesLimited investigationFinal reportCessna A185E · Grand Marais, MNThe pilot displayed inadequate compensation for the wind conditions that existed at the time of the accident and directional control was not maintained. A factor associated with the accident was the crosswind weather condition.May 23, 2002 · N4747Q · Substantial damageNTSB CHI02LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Clear Lake, MNThe loss of engine power for undetermined reasons and the unsuitable terrain for the forced landing. Factors were the low altitude and the fences.Jan 20, 2002 · N7113K · Substantial damageNTSB CHI02LA062Accident · 1 fatalLimited investigationFinal reportWolter Avid Flyer · Rush City, MNThe unqualified pilot inadvertently stalled the airplane. A factor was the unqualified pilot's lack of total experience.Jan 12, 2002 · N4047M · Substantial damage