NTSB finding · Aircraft › Aircraft power plant › Ignition system

Cases
13
In the probable cause
12 (92%)
Fatal cases
1
NTSB code
01057410

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 NTSB made it part of the probable cause; in gray, a factor or other finding. Findings are coded with the final report, often a year or more after the event, so the latest years are incomplete.

Cases per year

2008In the probable causeFactor only2026
Cases with Ignition power supply per year: 13 cases
20081
20093
20101
20131
20141
20161
20171
20181
20232
20241
Query with SQL
duckdb -csv -c "SELECT year(c.\"eventDate\") AS year, count(DISTINCT f.case_mkey) AS cases,
    count(DISTINCT f.case_mkey) FILTER (WHERE f.\"inProbableCause\") AS in_probable_cause
  FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = f.case_mkey
  WHERE starts_with(f.\"findingCode\", '01057410') AND c.\"eventDate\" >= DATE '2000-01-01'
  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 the same cases

Query with SQL
duckdb -csv -c "WITH matched AS (SELECT DISTINCT case_mkey, aircrafts_position FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' WHERE starts_with(\"findingCode\", '01057410'))
  SELECT * FROM (
  SELECT 'Defining event' AS kind, e.\"tier2Number\" AS code, max(e.\"eventTier2Name\") AS name, count(DISTINCT f.case_mkey) AS cases
  FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_events.parquet' e ON e.case_mkey = f.case_mkey AND e.aircrafts_position = f.aircrafts_position AND e.\"isDefiningEvent\"
  WHERE e.\"tier2Number\" <> ''
  GROUP BY ALL
  UNION ALL
  SELECT 'Aircraft model', a.aircraft_model_code, any_value(concat_ws(' ', m.manufacturer, m.model)), count(DISTINCT f.case_mkey)
  FROM matched f JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = f.case_mkey AND a.position = f.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
  UNION ALL
  SELECT 'Other finding', left(g.\"findingCode\", 8), max(g.\"tier4Name\"), count(DISTINCT g.case_mkey)
  FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' g
  WHERE g.case_mkey IN (SELECT case_mkey FROM matched) AND NOT starts_with(g.\"findingCode\", '01057410') AND g.\"findingCode\" GLOB '[0-9][0-9]*'
  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 · 13

NTSB ERA25LA056Accident · No injuriesClass 4 · LimitedFinal reportFinn Lassen RV-4 · O'Brien, FLA total loss of engine power and navigational equipment as a result of a faulty battery.Nov 9, 2024 · N214FL · Substantial damageNTSB CEN24LA012Accident · No injuriesClass 3 · LimitedFinal reportTvap 4 · Franksville, WIThe improper installation of the supplemental ignition system, which resulted in a total loss of engine power.Oct 15, 2023 · N42VZ · Substantial damageNTSB WPR23LA295Accident · Serious injuriesClass 3 · LimitedFinal reportFish Larry W Lancair 360 · Renton, WAA loss of electrical power due to low battery voltage, which resulted in an inflight shut down of the capacitor discharge ignition system and a loss of engine power. Contributing to the accident was the pilot’s failure to switch batteries after the electrical…Jul 31, 2023 · N68XA · Substantial damageNTSB WPR18LA209Accident · No injuriesClass 3 · LimitedFinal reportCessna 402 · Fort Lauderdale, FLThe failure of the left starter relay, which resulted in a loss of electrical power during the flight and the failure of the T-handle from the cable led to a forced landing with the landing gear retracted.Jun 14, 2018 · N322HA · Substantial damageNTSB ANC18LA002Accident · No injuriesLimited investigationFinal reportFleetwood Jack Team Airbike · Ocean Springs, MSAn intermittent failure of the power take-off cylinder ignition coil, which resulted in a partial loss of engine power.Oct 11, 2017 · N7566D · Substantial damageNTSB WPR17LA009Accident · No injuriesLimited investigationFinal reportGray Jim Robert Exec 90 · Caldwell, IDThe pilot's failure to properly tighten the tension bolts during the installation of the alternator belt, which resulted in inadequate voltage to sustain ignition and the subsequent partial loss of engine power.Oct 19, 2016 · N716JB · Substantial damageNTSB WPR15LA020Accident · Serious injuriesLimited investigationFinal reportWinston W Walker Thunder Mustang · Globe, AZThe separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…Oct 24, 2014 · N244SW · Substantial damageNTSB WPR13LA134Accident · No injuriesLimited investigationFinal reportBlumer Challenger II Spec · Peoria, AZA cracked cooling fan housing, which led to a malfunction of the ignition system and a loss of engine power during the landing approach.Feb 26, 2013 · N107BW · Substantial damageNTSB WPR10LA316Accident · No injuriesLimited investigationFinal reportMcGlashan T-51 Mustang · Columbia, CAA loss of engine power during approach due to thermal damage to the engine's electronic ignition module. Contributing to the accident was the builder’s placement of the ignition module near the engine’s exhaust.Jun 27, 2010 · N751RM · Substantial damageNTSB ERA10LA102Accident · 1 fatalLimited investigationFinal reportDavis Michael J Longez · Dexter, KYThe loss of engine power due to the chaffing and grounding of the single magneto's ignition lead.Dec 25, 2009 · N499CM · Destroyed
See all 13 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01057410'))
  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.