NTSB investigations, 2000, MI

8 cases where the phase of flight was Takeoff.

Cases per year

19642026
NTSB investigations, 2000, MI per year, 1964–2026: 408 cases
19648
19654
196616
196713
19688
196917
197010
197114
19726
19736
197415
19757
197613
19779
19789
197910
198011
198111
198211
19835
198410
19854
19862
19879
19881
19898
199012
19917
19927
19935
19948
19954
19966
19976
19984
19994
20008
200110
20022
20035
20044
20052
20061
20075
20084
20098
20103
20114
20125
20133
20145
20155
20162
20172
20187
20192
20204
20214
20222
20256
20265

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\") = 2000
    AND c.\"eventStateOrRegion\" = 'MI' 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 CHI01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Kalkaska, MIThe student pilot's failure to maintain aircraft control on the ground. Factors relating to this accident were the student pilot's improper abort procedures, the sign, and the ditch.Nov 15, 2000 · N1706F · Substantial damageNTSB CHI01LA010Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Tecumseh, MIThe pilot was unable to rotate the aircraft during takeoff for undetermined reasons. A factor associated with the accident was the soft terrain, which the airplane encountered during the aborted takeoff.Oct 15, 2000 · N289JG · Substantial damageNTSB CHI00LA310Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Petersburg, MIthe pilots failure to abort the takeoff and obtain/maintain clearance from the corn crop. Factors were the tall, wet, grass runway, and the corn crop.Sep 29, 2000 · N33117 · DestroyedNTSB CHI00LA312Accident · No injuriesLimited investigationFinal reportCessna 208B · Belleville, MIthe pilot's improper securing of the cargo that led up to the cargo shift during takeoff roll. A factor was the cargo restraint failure.Sep 15, 2000 · N806BF · Substantial damageNTSB CHI00LA225Accident · Minor injuriesLimited investigationFinal reportComeau Avid Flyer · Gladstone, MIaircraft control not maintained by the pilot.Jul 26, 2000 · N646R · DestroyedNTSB CHI00LA206Accident · 1 fatalLimited investigationFinal reportMead Kolb Firestar II · Gwinn, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the tree and the high density altitude.Jul 17, 2000 · UNREG · DestroyedNTSB CHI00LA155Accident · No injuriesLimited investigationFinal reportEdgerly S-12 · Hartford, MIrestricted directional control. Factors relating to this accident were the rough, uneven runway, and the trees.Jun 9, 2000 · N3148E · Substantial damageNTSB CHI00LA124Accident · No injuriesLimited investigationFinal reportSaab-Scania SF-340B · Hancock, MIthe deer which ran onto the runway and were subsequently struck by the airplane.Apr 25, 2000 · N404XJ · Substantial damage