NTSB investigations, 2003, IA

7 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 2003, IA per year, 1963–2026: 408 cases
19632
196410
196511
19665
196719
196812
196918
197017
197116
197213
197312
197413
197515
197615
19779
197813
19798
19806
198110
198210
198313
19846
19856
19862
198713
198812
19899
19902
19914
19925
19937
19943
19954
19964
19974
19987
19995
20003
20011
20021
20037
20043
20053
20061
20073
20082
20091
20106
20115
20123
20133
20141
20152
20163
20171
20181
20191
20202
20212
20222
20236
20253
20262

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\") = 2003
    AND c.\"eventStateOrRegion\" = 'IA' 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 CHI04FA044Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Brooklyn, IAThe pilot's inadequate planning/decision resulting in VFR flight into IMC, and his failure to maintain terrain clearance resulting in in-flight collision with terrain. Contributing factors to the accident were the pilot's lack of an instrument rating, his…Dec 18, 2003 · N3733W · Substantial damageNTSB CHI04LA019Accident · No injuriesLimited investigationFinal reportBeech A36 · Davenport, IAA loss of engine power due to fuel starvation as a result of the improper installation of the fuel nozzle. Also causal was the engine manufacturer's improper installation instructions for the nozzle pressure port plug on the fuel manifold valve. A factor…Oct 16, 2003 · N25496 · Substantial damageNTSB CHI04LA001Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Shenandoah, IALoss of engine power for an undetermined reason during cruise and the unsuitable terrain for landing encountered by the pilot. The factors to the accident were the dark night, the corn crop, and the ditch.Oct 3, 2003 · N3772D · Substantial damageNTSB CHI03LA217Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Waverly, IAThe main rotor blade push-pull rods being corroded, sustaining fatigue, and separating in cruise and the main rotor blade contacting the tail boom during the emergency landing. Factors were the diminished aircraft control and the vibrations encountered during…Jul 20, 2003 · N51699 · Substantial damageNTSB CHI03FA094Accident · 3 fatalField investigationFinal reportBeech A36 · New Vienna, IAThe improper planning/decision by the pilot to fly into forecast icing conditions with an airplane not equipped with a certified deice system. The continued flight in known icing conditions and the flight to an alternate destination not performed by the pilot…Mar 28, 2003 · N1636W · DestroyedNTSB CHI03LA059Accident · No injuriesLimited investigationFinal reportCessna 210 · Clarence, IAA failure of the crankshaft for undetermined reasons. Factors associated with the accident were the rough terrain on which the forced landing was made and the night conditions.Jan 24, 2003 · N6572X · Substantial damageNTSB CHI03LA049Accident · No injuriesLimited investigationFinal reportCessna 150J · Garner, IAThe students pilots improper in-flight fuel planning resulting in exhaustion of the fuel supply, and the collapse of the nose gear during the forced landing. Factors were unsuitable landing are encountered by the pilot, the plowed field and the fuel…Jan 8, 2003 · N60834 · Substantial damage