OpenAirDocs.org

Loss of engine power (total)

Open the Markdown

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

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

All 2,822 cases3,820 anywhere in the sequence
Defining event in
2,822 cases
In the sequence of
3,820 cases
Fatal cases
313
NTSB code
341

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\" = '341' 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-cruise613
  • Initial climb529
  • Enroute407
  • Maneuvering193
  • Maneuvering-low-alt flying173
  • Takeoff165
  • Approach137
  • Approach-VFR pattern final118
  • Enroute-climb to cruise100
  • Enroute-descent87
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\" = '341' 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 · 2,822

NTSB CEN27LA025AccidentLimited investigationInvestigation openHowell Mark R RV-8 · Geneseo, ILOct 21, 2026 · N818TCNTSB WPR27LA021Accident · No injuriesLimited investigationInvestigation openCessna 182A · Galveston, TXOct 19, 2026 · N5153DNTSB CEN27LA019Accident · Minor injuriesClass 3 · LimitedInvestigation openPiper PA-28-235 · Cedar Rapids, IAOct 18, 2026 · N8759WNTSB WPR27LA019Accident · Serious injuriesClass 3 · LimitedInvestigation openCessna 177A · San Jose, CAOct 17, 2026 · N30544NTSB CEN27LA013Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Abita Springs, LAOn October 12, 2026, at 1540 central daylight time, a Piper PA-28-140 airplane, N9859W, sustained substantial damage when it was involved in an accident near Abita Springs, Louisiana. The private pilot was uninjured. The airplane was operated as a Title 14…Oct 12, 2026 · N9859W · Substantial damageNTSB CEN27LA009Accident · Serious injuriesClass 3 · LimitedInvestigation openSimpson Arthur Monnett Sonerai Iilt · Sextonville, WIOct 12, 2026 · N473ASNTSB GAA27WA005Accident · No injuriesClass 5 · ForeignCessna R172 · Tarija, BoliviaOct 7, 2026 · CP-2646 · Substantial damageNTSB WPR26LA362Accident · Serious injuriesClass 3 · LimitedPreliminary reportSmith Pitts Special S-1 · Madison, GAOn September 29, 2026, at about 1347 eastern daylight time, a Smith Pitts Special S-1, N292Y, was substantially damaged when it was involved in an accident near Madison, Georgia. The pilot was seriously injured. The airplane was operated as a Title 14 Code of…Sep 29, 2026 · N292Y · Substantial damageNTSB WPR26LA358Accident · Serious injuriesClass 3 · LimitedInvestigation openReynolds Dennis E Bearhawk Patrol · Cottage Grove, ORSep 27, 2026 · N240BPNTSB CEN26LA326Accident · Minor injuriesLimited investigationInvestigation openBeech 35-A33 · East Troy, WISep 27, 2026 · N1288Z
See all 2,822 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\" = '341')
  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.