OpenAirDocs.org

Nav system malfunction/failure

Open the Markdown

NTSB defining event · CICTT: System/Component Failure (Non-Powerplant)

CICTT occurrence categories (PDF)CICTT phases of flight (PDF)

All 7 cases8 anywhere in the sequence
Defining event in
7 cases
In the sequence of
8 cases
Fatal cases
0
NTSB code
335

NTSB has coded findings and defining events since 2008. Earlier cases used its older occurrence and cause codes, so they aren’t counted here.

When and where

In green, cases where it was the defining event; in gray, cases where it came elsewhere in the sequence. The map shows the cases where it was the defining event. Events are coded with the final report, so the latest years are incomplete.

Cases per year

2008Defining eventElsewhere in the sequence2026

Where

Open the map
Query with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT e.case_mkey) AS cases,
    count(DISTINCT e.case_mkey) FILTER (WHERE e.\"isDefiningEvent\") AS defining
  FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = e.case_mkey
  WHERE e.\"tier2Number\" = '335' AND e.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")
  GROUP BY 1
  ORDER BY 1"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

In these cases

Phase of flight
  • Enroute-cruise2
  • Enroute2
  • Approach1
  • Enroute-descent1
  • Initial climb1
In the probable cause
Aircraft models

Aircraft matched to the registry by N-number and date.

Query with SQL
duckdb -csv -c "WITH defining AS (SELECT * FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"tier2Number\" = '335' AND \"isDefiningEvent\")
  SELECT * FROM (
  SELECT 'Phase of flight' AS kind, e.\"tier1Number\" AS code, max(e.\"eventTier1Name\") AS name, count(DISTINCT e.case_mkey) AS cases
  FROM defining e
  GROUP BY ALL
  UNION ALL
  SELECT 'Finding in the probable cause', left(f.\"findingCode\", 8), max(f.\"tier4Name\"), count(DISTINCT f.case_mkey)
  FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f ON f.case_mkey = e.case_mkey AND f.aircrafts_position = e.aircrafts_position AND f.\"inProbableCause\"
  WHERE f.\"findingCode\" GLOB '[0-9][0-9]*'
  GROUP BY ALL
  UNION ALL
  SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT e.case_mkey)
  FROM defining e JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = e.case_mkey AND a.position = e.aircrafts_position
  LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = a.aircraft_model_code
  WHERE a.aircraft_model_code IS NOT NULL
  GROUP BY ALL
  )
  QUALIFY row_number() OVER (PARTITION BY kind ORDER BY cases DESC) <= 10
  ORDER BY kind, cases DESC"

Prints the counts as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

Newest cases · 7

NTSB DCA26WA069OccurrenceClass 5 · ForeignSaab 340 · Garbutt, AustraliaNov 18, 2025 · Not provided · No damageNTSB DCA25WA348IncidentClass 5 · ForeignAirbus A320 · Karachi, PakistanMay 22, 2025 · AP-BLB · No damageNTSB DCA19CA170Accident · No injuriesData collectionFinal reportBoeing CV2 · Beeville, TXA higher than expected and accounted for crosswind which initiated a lateral deviation, and resulted in the aircraft reaching the limits of the geo-fence area triggering a contingency forced landing.Jun 21, 2019 · N243XT · Substantial damageNTSB DCA18WA151Incident · No injuriesForeign investigationBoeing 737 · Mexico City, MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Apr 12, 2018 · XA-UZW · No damageNTSB CEN17WA195Accident · Serious injuriesForeign investigationCessna P210N · San Vicente Tancoayalab, MexicoOn May 9, 2017, about 1430 universal coordinated time, a Cessna P210N airplane, N116DC, impacted trees and terrain during an emergency descent near San Vicente Tancoayalab, Mexico, following lightning strikes during cruise. The pilot was seriously injured and…May 9, 2017 · N116DC · DestroyedNTSB ENG15WA019Incident · No injuriesForeign investigationAirbus A330 - 201 · Athens, Greece, GreeceOn 12/26/2014 an Airbus A330 operated by XL Airways took off from La Réunion (Indian Ocean) to Marseille (France). The information provided by the three inertial reference systems became successively unavailable, leading autopilot + auto-thrust to disconnect,…Dec 26, 2014 · F-GRSQ · No damageNTSB DCA13WA103Incident · No injuriesForeign investigationBoeing 737-800 · Eindhoven, NetherlandsThe Dutch Safety Board (DSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on May 31, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the DSB investigation under the provisions of ICAO Annex 13 as the…May 31, 2013 · EI-ENL · No damage
Query with SQL
duckdb -csv -c "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.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '335')
  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.