NTSB investigations, 2000, FL

10 cases where the phase of flight was Takeoff.

Cases per year

19632026
NTSB investigations, 2000, 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\") = 2000
    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 MIA01LA047Accident · No injuriesLimited investigationFinal reportLarry Groover Eagle · Auburndale, FLthe pilot's failure to maintain adequate clearance during takeoff, which resulted in an inflight collision with a fence and substantial damage to the aircraft.Dec 22, 2000 · N8132L · Substantial damageNTSB MIA01LA036Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Clarksville, FLThe pilot's delay in aborting a takeoff after hitting a soft spot (sand) in the runway resulting in the airplane going off the end of the runway and colliding with trees. Contributing to the accident was the pilots decision to attempt the flight in an over…Dec 6, 2000 · N9046D · Substantial damageNTSB MIA01TA237Accident · No injuriesFinal reportAerofab Lake Seawolf · Frostproof, FLThe failure of the instructor pilot and dual student to begin the water takeoff with adequate clearance from the lake shore for the dual student to complete the takeoff and the failure of the instructor pilot to recognize in a timely manner during the takeoff…Nov 16, 2000 · N65RF · Substantial damageNTSB MIA01LA007Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Dellwood, FLthe pilot's failure to clear the area, and his attempted takeoff while the helicopter's right skid was entangled with vines, which resulted in inadvertent dynamic rollover and substantial damage to the aircraft.Oct 17, 2000 · N621DM · Substantial damageNTSB ATL00LA089Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · St. Augustine, FLThe loss of engine power due to fuel system contamination.Sep 10, 2000 · N26934 · Substantial damageNTSB MIA00LA238Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Gainesville, FLThe flight instructor's failure to identify a partial loss of engine power during takeoff roll, and his failure to maintain airspeed while attempting to return to the airport after takeoff resulting in the airplane stalling and descending uncontrolled until…Aug 15, 2000 · N93589 · Substantial damageNTSB ATL00LA049Accident · No injuriesLimited investigationFinal reportde Havilland DH-82C Tigermoth · Daytona Beach, FLThe pilot's inadequate pre-flight inspection of the fuel supply that resulted in the loss of engine power due to fuel contamination.May 1, 2000 · N819DH · Substantial damageNTSB MIA00LA109Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLSeparation of the right main landing gear tire recap during takeoff resulting in the pilot's loss of directional control, the aircraft departing the runway, collapse of the landing gear, and collision with the airport fence.Mar 16, 2000 · N251RS · Substantial damageNTSB MIA00FA103Accident · 4 fatalField investigationFinal reportCessna 172K · Sarasota, FLThe failure of the supervisor/ground controller and the local controller to provide effective separation between the accident airplanes on the runway, resulting in a collision during takeoff. Contributing to the accident was the failure of the pilot and…Mar 9, 2000 · N79960 · 2 aircraft · DestroyedNTSB MIA00LA087Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Englewood, FLThe failure of the pilot to retract the flaps from the fully extended position following the last landing resulting in the failure to maintain airspeed and subsequent descent for a forced landing. A contributing factor in the accident was the pilot's…Feb 8, 2000 · N6630F · Substantial damage