NTSB investigations, 2002, FL

15 cases where the phase of flight was Takeoff.

Cases per year

19632026
NTSB investigations, 2002, FL per year, 1963–2026: 716 cases
19631
196416
196510
196610
196719
196813
196914
197014
197118
197212
197318
197420
197514
197614
197713
197817
197919
198015
198115
198219
198312
198412
198515
19866
19874
19885
19898
199011
199111
19922
19938
199411
19957
19966
19979
199812
199912
200010
20017
200215
200322
20047
200511
20066
20073
200813
20099
201010
201110
20128
20135
20144
20156
201614
20177
20189
201912
202021
202110
20228
202312
20247
202514
202614

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\" = 'FL' 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 MIA03CA063Accident · No injuriesData collectionFinal reportConsolidated Aeronautics LA-4-200 · Blountstown, FLThe failure of the certified flight instructor (CFI) to maintain clearance between the wingtip and a water marker bouy resulting in contact with the wingtip.Dec 2, 2002 · N6193V · Substantial damageNTSB MIA03LA008Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Sebring, FLThe student pilot's premature rotation and failure to maintain airspeed during the takeoff, which resulted in an inadvertent stall, an uncontrolled descent, and an impact with the ground.Oct 25, 2002 · N267EP · Substantial damageNTSB ATL03LA005Accident · No injuriesLimited investigationFinal reportCessna 172 · Opa Locka, FLThe pilot' inadequate evaluation of weather information, and the selection of the wrong runway that resulted in an attempted takeoff with a tailwind and the subsequent loss of control during takeoff.Oct 17, 2002 · N903WA · Substantial damageNTSB MIA03LA003Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Immokalee, FLA loss of engine power on takeoff for undetermined reasons.Oct 8, 2002 · N7014Y · Substantial damageNTSB MIA02LA163Accident · No injuriesLimited investigationFinal reportCessna 152 · Sanford, FLThe student pilot's failure to maintain control of the airplane during the takeoff roll/run which resulted in the airplane departing the runway and into a ditch where it nosed over incurring substantial damage.Sep 1, 2002 · N68414 · Substantial damageNTSB MIA02LA141Accident · No injuriesLimited investigationFinal reportCessna 152 · Hialeah, FLThe failure of the pilot to maintain directional control of the airplane during the takeoff roll resulting in the on-ground collision with a ditch and subsequent nose over of the airplane.Jul 26, 2002 · N4893H · Substantial damageNTSB MIA02LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Okeechobee, FLThe failure of the pilot to maintain directional control of the airplane during the takeoff roll following a short field approach and landing, resulting in the on-ground collision with a fence.Jul 24, 2002 · N9284H · Substantial damageNTSB MIA02LA122Accident · No injuriesLimited investigationFinal reportPiper PA-22-20 · Jacksonville, FLThe failure of the solo student/owner to maintain directional control of the airplane during takeoff in a crosswind, which resulted in the airplane veering off the runway, a collision with a runway light, and a ground loop.Jul 1, 2002 · N1693A · Substantial damageNTSB ATL02LA118Accident · No injuriesLimited investigationFinal reportCessna 152 · Immokalee, FLThe student pilot's failure to maintain directional control while attempting a touch and go landing resulted in an on-ground collision with a ditch. A factor in this accident was the student pilot's lack of experience.May 29, 2002 · N5224P · Substantial damageNTSB MIA02LA101Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Bunnell, FLThe failure of the student pilot to secure the rotorcraft floorboard mounted ballast, resulting in shifting of the ballast on liftoff, and the subsequent dynamic rollover.May 28, 2002 · N6746D · Substantial damageNTSB MIA02TA081Accident · No injuriesFinal reportBell OH-58C · Punta Gorda, FLDynamic rollover experienced by the pilot while attempting to lift off from a trailer after experiencing skid to trailer contact. A factor in the accident was the inadequate equipment (trailer) which had a 1.1875 inch high lip extending the length of the…Apr 8, 2002 · N107CS · Substantial damageNTSB MIA02LA076Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Crescent City, FLTfhe failure of the pilot to maintain directional control of the aircraft during takeoff roll, resulting in an excursion off the left side of the runway and collision with an adjacent hangar.Apr 2, 2002 · N43615 · Substantial damageNTSB ATL02LA055Accident · 1 fatalLimited investigationFinal reportKrejci S-51D · Port St. Lucie, FLThe pilots failure to maintain airspeed while maneuvering in an attempt to return to landing area (Emergency/ departure airport.) This resulted in an inadvertent stall and subsequent in-flight collision with terrain. Factor to the accident was a partial loss…Feb 26, 2002 · N51KK · Substantial damageNTSB ATL02LA042Accident · Minor injuriesLimited investigationFinal reportLouis Edmondson 162F · St. Petersburg, FLThe pilot's decision to continue flight with demonstrated inadequate takeoff performance capability, which resulted in an in-flight loss of control and subsequent hard landing.Jan 19, 2002 · N162LE · Substantial damageNTSB MIA02LA050Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Lake Placid, FLThe failure of the pilot to perform a proper preflight inspection and his improper fuel tank selection for takeoff, resulting in a loss of engine power on takeoff due to fuel starvation, and the pilot's failure to maintain directional control of the aircraft…Jan 17, 2002 · N201XL · Destroyed