NTSB investigations, 2000, MI

9 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 2000, MI per year, 1963–2026: 734 cases
19631
196412
196515
196620
196719
196826
196921
197033
197124
197226
197334
197426
197517
197626
197715
197821
197923
198019
198116
198211
198311
198414
198516
198616
198712
198811
19899
199013
199110
199215
199313
19949
199513
199612
199713
19988
19997
20009
200110
200214
20039
20045
200510
20068
20073
20086
20096
20107
20112
20121
20132
20142
20154
20162
20171
20181
20196
20201
20216
20224
20233
20242
20252
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\") = 2000
    AND c.\"eventStateOrRegion\" = 'MI' 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 CHI01LA009Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Lansing, MIthe pilot's inaccurate preflight planning. Factors were the fuel exhaustion, the trees, and the bright night condition.Oct 12, 2000 · N732FL · Substantial damageNTSB CHI01LA002Accident · 1 fatalLimited investigationFinal reportMoseler RAF 2000 GTX SE · Muskegon, MIThe main rotor contacting with the vertical stabilizer, the loss of the vertical stabilizer, and the aircraft control not possible by the pilot.Oct 4, 2000 · N1187Z · DestroyedNTSB CHI00MA256Accident · 2 fatalMajor investigationFinal reportNorth American NA-265-80 · Ironwood, MIthe pilot's improper in-flight decision, the pilot's continued flight into known adverse weather, the pilot's failure to turn on the continuous ignition in turbulence, and the pilot's failure to follow the procedures for an airstart. Factors included the…Aug 14, 2000 · N85DW · DestroyedNTSB CHI00LA253Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Coopersville, MIfuel starvation due to the blocked carburetor. Factors relating to the accident were the foreign object (tab), the improper maintenance performed on the carburetor, and the corn crop.Aug 12, 2000 · N2545N · Substantial damageNTSB CHI00LA215Accident · No injuriesLimited investigationFinal reportLutke Rotoway Exec 90 · Kalamazoo, MIthe loss of main rotor rpm due to the failure of the top engine mount and the subsequent loss of the main rotor drive belt tension. A factor was the confined area landing zone.Jul 22, 2000 · N1183M · Substantial damageNTSB CHI00LA188Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20L · Gregory, MIthe control stick movement being restricted by the pilot's seat-type parachute and the excessive descent rate and airspeed during landing. A factor to the accident was the pilot's lack of familiarity with the aircraft.Jul 4, 2000 · N4804W · Substantial damageNTSB CHI00LA135Accident · 1 fatalLimited investigationFinal reportRotorway Exec 162F · Ithaca, MIthe door separation for undetermined reasons and the foreign object damage due to the door impact to the tailboom and tail rotor drive system.May 13, 2000 · N962WM · DestroyedNTSB CHI00LA127Accident · Minor injuriesLimited investigationFinal reportFairchild PT-26B · Winn, MIthe pilot's inadequate fuel management. Factors to the accident were fuel starvation, the low altitude at the time of the loss of engine power, remedial action not possible by the pilot, and the unsuitable terrain for landing encountered by the pilot.Apr 30, 2000 · N53366 · Substantial damageNTSB CHI00LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Alma, MIthe pilot's inadequate fuel consumption calculation. Factors were the rough terrain, the fence and the exhaustion of the fuel supply.Feb 8, 2000 · N4276E · Substantial damage