OpenAirDocs.org

Powerplant sys/comp malf/fail

Open the Markdown

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

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

All 627 cases820 anywhere in the sequence
Defining event in
627 cases
In the sequence of
820 cases
Fatal cases
48
NTSB code
340

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\" = '340' 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-cruise145
  • Initial climb113
  • Enroute80
  • Enroute-climb to cruise59
  • Takeoff46
  • Maneuvering-low-alt flying31
  • Approach29
  • Maneuvering23
  • Takeoff-rejected takeoff18
  • Approach-VFR pattern downwind11
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\" = '340' 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 · 627

NTSB ENG27LA001Incident · No injuriesClass 4 · LimitedInvestigation openBoeing 777-222 · San Francisco, CAOct 6, 2026 · N796UANTSB WPR27LA002Accident · No injuriesClass 3 · LimitedInvestigation openCessna P210N · Stevensville, MTOct 4, 2026 · N94PSNTSB CEN27LA004Accident · No injuriesClass 3 · LimitedInvestigation openCessna 414A · Boerne, TXOct 2, 2026 · N1245ANTSB ENG26WA042Incident · No injuriesClass 5 · ForeignBoeing 737 · Naha, JapanSep 23, 2026 · JA86ANNTSB ENG26WA043Incident · No injuriesClass 5 · ForeignAirbus A321-271N · Parque Industrial Mazatlán, MexicoSep 12, 2026 · N542VLNTSB DCA26WA349Incident · No injuriesClass 5 · ForeignBoeing 747 · Sharjah, United Arab EmiratesSep 3, 2026 · ER-BYK · Minor damageNTSB ENG26WA039OccurrenceClass 5 · ForeignBoeing 737 · Cancun, MexicoAug 18, 2026 · XA-SSRNTSB ANC26LA088Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172L · Micanopy, FLOn August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code…Aug 18, 2026 · N3866Q · Substantial damageNTSB ENG26FA034Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 747 · Anchorage, AKOn August 15, 2026, 1755 Alaska Daylight Time, a China Airlines Flight Number CI-5265, Boeing 747-400F, registration B-18725, powered by four GE Aerospace CF6-80C2B1F turbofan engines, experienced an inflight fire indication during the initial climb from Ted…Aug 15, 2026 · B-18725 · Minor damageNTSB ENG26WA037IncidentClass 5 · ForeignAirbus A321 · Chiapa de Corzo, MexicoAug 14, 2026 · XA-VXI
See all 627 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\" = '340')
  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.