Ongoing NTSB investigations

158 cases where the phase of flight was Takeoff.

Cases, newest first

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 c.\"completionStatus\" = 'Ongoing'
    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 ERA25LA088Accident · No injuriesClass 3 · LimitedPreliminary reportBeech A36 · Naples, FLOn January 1, 2025, at 0120 eastern standard time, a Beech A36, N8163F, was substantially damaged when it was involved in an accident at Naples Municipal Airport (APF), Naples, Florida. The private pilot and three passengers were not injured. The flight was…Jan 1, 2025 · N8163F · Substantial damageNTSB WPR25FA031Accident · 5 fatalClass 3 · FieldPreliminary reportHonda HA420 · Mesa, AZOn November 5, 2024, at 1639 mountain daylight time, a Honda HA-420, N57HP, was destroyed when it was involved in an accident near Mesa, AZ. The pilot and three passengers were fatally injured, one passenger was seriously injured, and the single occupant of…Nov 5, 2024 · N57HP · DestroyedNTSB CEN24LA361Accident · 1 fatalClass 3 · LimitedPreliminary reportRans S14 · Teague, TXOn September 20, 2024, about 1648 central daylight time, an unregistered Rans S-14 Airaile light sport airplane, was substantially damaged when it was involved in an accident near Teague, Texas. The pilot was fatally injured. The airplane was operated as a…Sep 20, 2024 · UNREG · Substantial damageNTSB DCA24FA300Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 737-9 · Nashville, TNOn September 12, 2024, about 0914 central daylight time (CDT), Alaska Airlines flight 369 (ASA369), a Boeing 737-900, N919AK, rejected their take-off on runway 13 at Nashville International Airport (BNA), Nashville, Tennessee, when Southwest Airlines flight…Sep 12, 2024 · N919AK · 2 aircraft · Minor damageNTSB WPR24FA295Accident · Serious injuriesClass 3 · FieldPreliminary reportPiper PA-24-250 · Hawthorne, CAOn September 6, 2024, at 0036 Pacific daylight time, a Piper PA-24-250, N588CP, was destroyed when it was involved in an accident near Hawthorne, California. The pilot and pilot rated passenger sustained serious injuries. The airplane was operated as a Title…Sep 6, 2024 · N588CP · DestroyedNTSB CEN24FA320Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 550 · Odessa, TXOn August 20, 2024, about 0700 central daylight time, a Cessna 550 airplane, N689VP, was destroyed when it was involved in an accident near Odessa, Texas. The pilot and passenger were fatally injured. A person on the ground was seriously injured. The airplane…Aug 20, 2024 · N689VP · DestroyedNTSB CEN24FA304Accident · 4 fatalClass 3 · FieldPreliminary reportBeech F33 · Oklahoma City, OKOn August 6, 2024, about 1326 central daylight time, a Beechcraft F33A airplane, N8095U, was destroyed when it was involved in an accident near Oklahoma City, Oklahoma. The private pilot and the three passengers sustained fatal injuries. The airplane was…Aug 6, 2024 · N8095U · DestroyedNTSB OPS24FA031IncidentClass 3 · FieldPreliminary reportAirbus Industrie A319-132 · Arlington, VAOn May 29, 2024, at about 1021 eastern daylight time (EDT), American Airlines (AAL) flight 2134 (AAL2134), an Airbus Industries A319-132, and N250AA a Hawker Beechcraft Corporation B300C were involved in a runway incursion that resulted in a loss of…May 29, 2024 · N812AW · 2 aircraft · No damage