Ongoing NTSB investigations, CA

26 cases where the phase of flight was Landing.

Cases per year

20242026
Ongoing NTSB investigations, CA per year, 2024–2026: 26 cases
20241
20256
202619

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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"completionStatus\" = 'Ongoing'
    AND c.\"mKey\" IN (SELECT case_mkey FROM case_phases WHERE main = 550)
  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 WPR27LA026Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 182N · Santa Maria, CAOn October 28, 2026, about 1210 Pacific daylight time, a Cessna 182N, N442RA was substantially damaged when it was involved in an accident near Santa Maria, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of…Oct 28, 2026 · N442RA · Substantial damageNTSB WPR27LA023Accident · Minor injuriesClass 4 · LimitedInvestigation openCessna 120 · Death Valley, CAOct 24, 2026 · N89885 · Substantial damageNTSB WPR27LA020Accident · No injuriesClass 3 · LimitedPreliminary reportMaule M-7-260 · Sea Ranch, CAOn October 17, 2026, about 1030 Pacific daylight time, a Maule M-7-260, N3217V, was substantially damaged during a runway excursion while landing at The Sea Ranch Airport (CA51), Sea Ranch, California. The airplane was operated as a Title 14 Code of Federal…Oct 17, 2026 · N3217V · Substantial damageNTSB WPR27LA003Accident · No injuriesClass 4 · LimitedInvestigation openMaule M-5-235C · Agua Dulce, CAOct 3, 2026 · N56328 · Substantial damageNTSB WPR27LA010Accident · No injuriesClass 4 · LimitedInvestigation openCessna A185F · Madera, CAOct 1, 2026 · N185TT · Substantial damageNTSB WPR27LA009Accident · Serious injuriesClass 4 · LimitedInvestigation openCessna 172N · Knights Landing, CAOct 1, 2026 · N75513 · Substantial damageNTSB WPR26LA349Accident · Minor injuriesClass 4 · LimitedInvestigation openCameron Balloons US A-400 · Angwin, CASep 19, 2026 · N65573 · Substantial damageNTSB WPR26LA340Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · San Luis Obispo, CAOn September 13, 2026, about 1515 Pacific daylight time, a Cessna P210N airplane, N4617W, was substantially damaged when it was involved in an accident near San Luis Obispo, California. The pilot, pilot-rated-passenger, and a passenger were not injured. The…Sep 13, 2026 · N4617W · Substantial damageNTSB WPR26LA332Accident · No injuriesClass 4 · LimitedInvestigation openCessna 152 · Carlsbad, CASep 4, 2026 · N5447L · Substantial damageNTSB WPR26LA326Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 560XL · Porterville, CAOn September 1, 2026, about 1142 Pacific daylight time, a Cessna 560XL airplane, N562JL, was substantially damaged when it was involved in an accident near Porterville, California. The two pilots sustained minor injuries, and the four passengers were not…Sep 1, 2026 · N562JL · Substantial damageNTSB WPR26LA318Accident · No injuriesClass 4 · LimitedInvestigation openCessna 170B · South Lake Tahoe, CAAug 26, 2026 · N2285D · Substantial damageNTSB WPR26LA303Accident · No injuriesClass 4 · LimitedInvestigation openCessna 172L · Upland, CAAug 16, 2026 · N7526G · Substantial damageNTSB WPR26LA293Accident · No injuriesClass 4 · LimitedInvestigation openP Z L -Warszawa-Cnpsl PZL-104 Wilga 35A · Ukiah, CAAug 7, 2026 · N113AS · Substantial damageNTSB WPR26LA260Accident · Minor injuriesClass 4 · LimitedInvestigation openBellanca 8KCAB · Auburn, CAJul 14, 2026 · N5051W · Substantial damageNTSB WPR26LA256Accident · No injuriesClass 3 · LimitedPreliminary reportCanadair CF-5D · Mojave, CAOn July 10, 2026, about 1103 Pacific daylight time, a Canadair CF-5D, N845PS, was substantially damaged when it was involved in an accident near Mojave, California. The two pilots onboard were not injured. The airplane was operated as a Title 14 Code of…Jul 10, 2026 · N845PS · Substantial damageNTSB WPR26LA226Accident · No injuriesClass 3 · LimitedPreliminary reportCessna TR182 · Los Angeles, CAOn June 21, 2026, about 1255 Pacific daylight time, a Cessna TR182, N2194S, sustained substantial damage when it was involved in an accident near Van Nuys, California. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Jun 21, 2026 · N2194S · Substantial damageNTSB WPR26LA228Accident · Minor injuriesClass 3 · LimitedPreliminary reportLancair Legacy 2000 · Los Angeles, CAOn June 16, 2026, about 0906 Pacific daylight time, an experimental amateur built Lancair Legacy 2000, N84BZ, was substantially damaged when it was involved in an accident near Los Angeles, California. The pilot sustained minor injuries. The airplane was…Jun 16, 2026 · N84BZ · Substantial damageNTSB DCA26LA184Incident · No injuriesClass 3 · LimitedPreliminary reportBoeing 787-9 · Los Angeles, CAOn March 2, 2026, at 1100 Pacific Standard Time, United Airlines flight 2127, a Boeing 787-9, registration N24972, powered by two General Electric GEnx™-1B76A/P2 turbofan engines, experienced a No. 1 (left) engine surge during climb from Los Angeles…Mar 2, 2026 · N24972 · No damageNTSB WPR26LA107Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-30 · Big Bear, CAOn February 23, 2026, at 1800 Pacific standard time, a Piper PA-30, N811LE, was substantially damaged when it was involved in an accident near Big Bear, California. The pilot and passenger were not injured. The airplane was operated as a 14 Code of Federal…Feb 24, 2026 · N811LE · Substantial damageNTSB WPR26LA047Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172S · Lancaster, CAOn November 9, 2025, about 1205 Pacific daylight time, a Cessna 172S, N5199J, sustained substantial damage when it was involved in an accident near Lancaster, California. The pilot and passengers were not injured. The airplane was operated as a Title 14 Code…Nov 9, 2025 · N5199J · Substantial damageNTSB CEN26FA015Accident · Serious injuriesClass 3 · FieldPreliminary reportBell 222 · Huntington Beach, CAOn October 11, 2025, at 1401 Pacific daylight time, a Bell 222 helicopter, N222EX, was substantially damaged when it was involved in an accident near Huntington Beach, California. The pilot and passenger received serious injuries. One person on the ground…Oct 11, 2025 · N222EX · Substantial damageNTSB WPR25LA282Accident · No injuriesClass 3 · LimitedPreliminary reportCessna P210N · Victorville, CAOn September 13, 2025, about 1300 Pacific daylight time, a Cessna P210N airplane, N25WD, was substantially damaged when it was involved in an accident near Victorville, California. The pilot and flight instructor were not injured. The airplane was operated as…Sep 13, 2025 · N25WD · Substantial damageNTSB WPR25LA255Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 180K · Anza, CAOn August 14, 2025, about 0830 Pacific daylight time, a Cessna 180K, N2691K, was substantially damaged when it was involved in an accident near Anza, California. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal Regulations…Aug 14, 2025 · N2691K · Substantial damageNTSB WPR25LA266Accident · No injuriesClass 3 · LimitedPreliminary reportCessna TR182 · San Diego, CAOn August 12, 2025, about 1330 Pacific daylight time, Cessna TR182 airplane, N619MW, was substantially damaged when it was involved in an accident near San Diego, California. The pilot and passenger were not injured. The airplane was operated as a Title 14…Aug 12, 2025 · N619MW · Substantial damageNTSB WPR25LA250Accident · No injuriesClass 3 · LimitedPreliminary reportDe Havilland DHC-6-300 · San Celmente, CAOn August 11, 2025, at 1130 Pacific daylight time, a De Havilland DHC-6-300, N344CS, was substantially damaged when it was involved in an accident at San Clemente Island, California. The 2 pilots and 16 passengers were not injured. The airplane was operated…Aug 11, 2025 · N344CS · Substantial damageNTSB OPS25LA005IncidentClass 3 · LimitedPreliminary reportBoeing 737-7H4 · Long Beach, CAOn October 19, 2024, at 1450 pacific daylight time (PDT), a Diamond DA40, N895AM, and a Boeing 737-7H4, N250WN, operated as SWA1671, were involved in a runway incursion in Long Beach, CA. There were no injuries reported and none of the aircraft were damaged.…Oct 19, 2024 · N250WN · 2 aircraft · No damage