OpenAirDocs.org

Sys/Comp malf/fail (non-power)

Open the Markdown

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

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

All 725 cases994 anywhere in the sequence
Defining event in
725 cases
In the sequence of
994 cases
Fatal cases
37
NTSB code
330

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\" = '330' 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
  • Landing-landing roll151
  • Takeoff78
  • Landing67
  • Enroute-cruise61
  • Approach58
  • Initial climb58
  • Enroute43
  • Landing-flare/touchdown26
  • Maneuvering26
  • Maneuvering-low-alt flying24
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\" = '330' 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 · 725

NTSB ERA27LA013Accident · No injuriesClass 3 · LimitedInvestigation openHughes 269C · Gastonia, NCOct 15, 2026 · N9655FNTSB DCA26WA365Incident · No injuriesClass 5 · ForeignBoeing 737 · Comalapa, El SalvadorSep 17, 2026 · XA-GNSNTSB DCA26WA353AccidentClass 5 · ForeignDouglas DC8 · Kinshasa, Congo - KinshasaSep 8, 2026 · 9S-AJONTSB WPR26LA367Accident · No injuriesClass 3 · LimitedInvestigation openHawker Beechcraft G36 · Murrieta, CAAug 30, 2026 · N646MMNTSB WPR26LA321Accident · No injuriesClass 3 · LimitedPreliminary reportWestwind 1124A · Las Vegas, NVOn August 28, 2026, about 0145 Pacific daylight time, an IAI 1124A Westwind airplane, Canadian registration C-GIAW, was substantially damaged when it was involved in an accident at Harry Reid International Airport (LAS), Las Vegas, Nevada. The two pilots, and…Aug 28, 2026 · C-GIAW · Substantial damageNTSB CEN26LA270Accident · No injuriesClass 4 · LimitedInvestigation openCessna P210R · Arkadelphia, ARJul 23, 2026 · N5258A · Substantial damageNTSB CEN26LA259Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 · Adair, IAOn July 18, 2026, about 1440 central daylight time, a Robinson Helicopter Company R44, N484AT, was substantially damaged when it was involved in an accident near Adair, Iowa. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…Jul 18, 2026 · N484AT · Substantial damageNTSB CEN26LA251Accident · No injuriesClass 3 · LimitedPreliminary reportVans RV-12 · Grand Junction, COOn July 10, 2026, about 1023 mountain daylight time, an experimental amateur-built Vans Aircraft Inc RV-12 airplane, N812MM, sustained substantial damage when it was involved in an accident near Grand Junction, Colorado. The pilot and a passenger were…Jul 10, 2026 · N812MM · Substantial damageNTSB WPR26LA227Accident · No injuriesClass 3 · LimitedPreliminary reportEmigh Trojan A2 · Healdsburg, CAOn June 21, 2026, about 1210 Pacific daylight time, an Emigh Trojan A-2, N8329H, was substantially damaged when it was involved in an accident near Healdsburg, California. The flight instructor and student pilot were not injured. The airplane was operated as…Jun 21, 2026 · N8329H · Substantial damageNTSB CEN26LA230Accident · Serious injuriesClass 3 · LimitedPreliminary reportZenith 601 XL · O'Donnell, TXOn June 20, 2026, about 1147 central daylight time, an experimental Zodiac 601XL airplane, N165TJ, was substantially damaged when it was involved in an accident near O’Donnell, Texas. The pilot sustained serious injuries. The airplane was operated as a Title…Jun 20, 2026 · N165TJ · Substantial damage
See all 725 cases
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\" = '330')
  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.