OpenAirDocs.org

Loss of engine power (partial)

Open the Markdown

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

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

All 1,421 cases
Defining event in
1,421 cases
In the sequence of
1,858 cases
Fatal cases
148
NTSB code
342

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

Cases per year

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

2008Defining eventElsewhere in the sequence2026
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\" = '342' 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
  • Initial climb400
  • Enroute-cruise232
  • Takeoff213
  • Enroute146
  • Maneuvering84
  • Maneuvering-low-alt flying73
  • Enroute-climb to cruise56
  • Approach39
  • Approach-VFR pattern final35
  • Enroute-descent23
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\" = '342' 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 · 1,421

NTSB CEN27LA029Accident · No injuriesLimited investigationInvestigation openPiper PA-28 · Claremore, OKOct 22, 2026 · N5393WNTSB ERA27LA007AccidentLimited investigationInvestigation openPiper PA-32-260 · Whiteville, NCOct 7, 2026 · N31RFNTSB WPR27LA008Accident · No injuriesClass 3 · LimitedInvestigation openHakala John Charles Lancair IV-P-T · Ontario, OROct 4, 2026 · N5UCNTSB CEN26LA330AccidentClass 3 · LimitedInvestigation openCessna 152 · Bolingbrook, ILSep 29, 2026 · N69009NTSB CEN26LA327Accident · Minor injuriesClass 3 · LimitedPreliminary reportHaberman Habercraft · Pelican Rapids, MNOn September 27, 2026, about 1720 central daylight time, a Haberman Habercraft airplane, N10516, was substantially damaged during an accident near Pelican Rapids, Minnesota. The pilot sustained a minor injury. The airplane was operated as a Title 14 Code of…Sep 27, 2026 · N10516 · Substantial damageNTSB ERA26LA348Accident · No injuriesClass 4 · LimitedInvestigation openHopwood Joseph R Zodiac · Stockton, ALSep 20, 2026 · N601LL · Substantial damageNTSB WPR26LA347Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B-III · Creswell, NCOn September 18, 2026, at 1018 eastern daylight time, a Bell 206B-III, N50141, was substantially damaged when it was involved in an accident near Creswell, North Carolina. The pilot was not injured. The helicopter was being operated as a Title 14 Code of…Sep 18, 2026 · N50141 · Substantial damageNTSB CEN26LA322Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172M · Hanover, INOn September 16, 2026, about 1905 eastern daylight time, a Cessna 172M airplane, N9909Q, was substantially damaged when it was involved in an accident near Hanover, Indiana. The pilot and passenger sustained minor injuries. The airplane was operated as a…Sep 16, 2026 · N9909Q · Substantial damageNTSB ANC26LA103Accident · No injuriesClass 3 · LimitedPreliminary reportRobinson Helicopter R44 II · Colquitt, GAOn September 11, 2026 about 0830 eastern daylight time, a Robinson R44 helicopter, N4026E, was substantially damaged when it was involved in an accident near Colquitt, Georgia. The pilot was not injured. The helicopter was operated as a Title 14 Code of…Sep 11, 2026 · N4026E · Substantial damageNTSB WPR26LA335Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 210 · Polson, MTOn September 10, 2026, about 1005 mountain daylight time, a Cessna 210, N9517T, was substantially damaged when it was involved in an accident near Polson Airport (8S1), Polson, Montana. The student pilot was not injured. The airplane was operated as a Title…Sep 10, 2026 · N9517T · Substantial damage
See all 1,421 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\" = '342')
  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.