NTSB investigations, 2003, GA

17 cases where the phase of flight was Enroute.

Cases per year

19632026
NTSB investigations, 2003, GA per year, 1963–2026: 865 cases
19631
19648
196518
196614
196722
196820
196924
197022
197131
197229
197315
197426
197518
197616
197730
197822
197922
198024
198121
198227
198312
198418
198518
198616
198712
198811
198912
199019
199116
199213
19936
19949
199511
199610
199716
199814
19997
200012
200117
200210
200317
20048
20058
200616
200718
20086
200911
20107
20118
20126
20138
20145
20155
20167
20175
20184
20196
20207
20219
202210
20237
202411
20253
20264

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\" = 'GA' 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 ATL04LA017Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Carrollton, GAA loss of engine power for undetermined reasons.Oct 13, 2003 · N4085H · Substantial damageNTSB ATL04LA009Accident · No injuriesLimited investigationFinal reportCessna 150G · Jeykll Island, GAThe pilot's preflight planning and the mismanagement of the fuel supply that resulted in fuel exhaustion.Oct 6, 2003 · N4662X · Substantial damageNTSB ATL03FA142Accident · 1 fatalField investigationFinal reportCessna 172M · Perry, GAThe pilot inadequate preflight inspection of the airplane, and also causal was his failure to detect water-contaminated fuel which resulted in a loss of engine power and his failure to maintain adequate airspeed which resulted in an stall.Sep 18, 2003 · N13375 · Substantial damageNTSB ATL03FA140Accident · 1 fatalField investigationFinal reportBeechcraft A36 · Stone Mountain, GAThe pilot's intentional flight into the ground for the purpose of suicide while impaired by alcohol.Sep 16, 2003 · N1980K · DestroyedNTSB ATL03FA137Accident · 1 fatalField investigationFinal reportMooney M-20C · Monticello, GAThe pilot's continued VFR flight into IMC conditions, and his failure to maintain obstacle clearance and collision with trees. A factor was low ceiling.Sep 13, 2003 · N2764W · Substantial damageNTSB ATL03FA128Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Rome, GAA loss of engine power due to fuel system contamination (water). Also causal was the pilot's loss of control for undetermined reasons.Aug 17, 2003 · N99748 · DestroyedNTSB ATL03LA120Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5A · Canon, GAThe loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.Jul 26, 2003 · N727FT · Substantial damageNTSB ATL03LA106Accident · No injuriesLimited investigationFinal reportPolstra Zodiac CH 601 HDS · Thomson, GAThe total loss of engine power due to the fatigue fracture of the No. 3 cylinder intake valve, which resulted in a forced landing to rough terrain and subsequent collision with small trees and a tree stump.Jun 16, 2003 · N721PT · Substantial damageNTSB ATL03FA089Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Calhoun, GAThe pilot's failure to obtain a preflight weather briefing, which would have indicated that MVFR to IFR conditions prevailed over the route with embedded thunderstorms and rain, and his decision to continue VFR flight into instrument meteorological…May 5, 2003 · N32038 · DestroyedNTSB CHI03LA113Accident · Serious injuriesLimited investigationFinal reportBoeing 757-222 · Lithonia, GAThe flight into adverse weather encountered by the flight crew, and the flight attendant's restraint not available when she was informed to take her seat. The convective associated turbulence was a contributing factor.Apr 21, 2003 · N504UA · No damageNTSB ATL03FA077Accident · 1 fatalField investigationFinal reportCessna 414 · Waleska, GAThe pilot's failure to maintain clearance from terrain.Apr 10, 2003 · N822DB · DestroyedNTSB ATL03FA068Accident · 2 fatalField investigationFinal reportRockwell 690B · Homerville, GAAn in-flight encounter with unforecasted severe turbulence in cruise flight resulting in the design limits of the airplane being exceeded due to an overload failure of the airframe, and collision with a swampy area.Mar 27, 2003 · N53LG · DestroyedNTSB ATL03LA051Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Atlanta, GAThe flight's encounter with severe turbulence that resulted in serious injury to a flight attendant.Mar 1, 2003 · N642AS · No damageNTSB ATL03FA049Accident · 1 fatalField investigationFinal reportPiper PA-32-300 · Sylvania, GAThe pilot's decision to conduct VFR flight into instrument meteorological conditions, and his failure to maintain obstacle clearance. Related factors were the guy wire and the fog.Feb 26, 2003 · N54406 · DestroyedNTSB ATL03LA036Accident · No injuriesLimited investigationFinal reportBeech 65 · Fitzgerald, GAThe pilot's mismanagement of the fuel supply that resulted in fuel starvation and the loss of engine power in both engines. A factor was a tree.Jan 18, 2003 · N115HF · Substantial damageNTSB MIA03LA044Accident · No injuriesLimited investigationFinal reportCessna 150K · Jessup, GAThe loss of engine power for undetermined reasons. A contributing factor was unsuitable terrain.Jan 3, 2003 · N6098G · Substantial damageNTSB MIA03LA035Accident · Minor injuriesLimited investigationFinal reportLonnie Johnson RV6A · Peachtree City, GAThe failure of the pilot to activate carburetor heat control during cruise flight after experiencing a loss of engine rpm, inadequate carburetor heat system by the builder, and the unsuitable terrain encountered by the pilot-in-command during the forced…Jan 1, 2003 · N559LJ · Substantial damage