NTSB defining event · CICTT: System/Component Failure (Powerplant)
CICTT occurrence categories (PDF)CICTT phases of flight (PDF)
- Defining event in
- 45 cases
- In the sequence of
- 47 cases
- Fatal cases
- 1
- NTSB code
- 343
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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 4 |
| 2017 | 6 |
| 2018 | 5 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 4 |
| 2026 | 2 |
Where
Open the mapQuery 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\" = '343' 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.
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" = '343' 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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
In these cases
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\" = '343' 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.
WITH defining AS (SELECT * FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "tier2Number" = '343' 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 DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
Newest cases · 45
NTSB ENG26LA026Incident · No injuriesClass 3 · LimitedPreliminary reportCirrus SF50 · Athens, GAOn June 2, 2026, at 0945 eastern daylight time, a Cirrus SF50, N129KA, powered by a Williams International FJ33-5A turbofan engine, experienced an uncontained engine failure during climb from Greene County Regional Airport (KCPP), Greensboro, Georgia. There…NTSB ENG26WA025Incident · No injuriesClass 3 · ForeignAirbus A330-323 · Sao Paulo, BrazilNTSB ERA25FA001Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 95 · Crystal River, FLOn October 1, 2024, about 1540 eastern daylight time, a Beech 95-B55, N5868S, was destroyed when it collided with terrain near Crystal River, Florida. The private pilot was fatally injured. The personal flight was conducted under the provisions of Title 14…NTSB ENG24LA028Incident · No injuriesClass 3 · LimitedFinal reportBell 407 · Oktaha, OKThe loss of engine power due to high cycle fatigue failure of a power turbine stage 3 turbine wheel blade. The resulting engine imbalance caused a decoupling of the gas producer stage 1 and stage 2 turbine wheels leading to a stage 1 turbine overspeed and…NTSB DCA24WA201Incident · No injuriesClass 3 · ForeignBoeing 777FZB · Narita, JapanNTSB ENG24LA014Incident · No injuriesClass 3 · LimitedFinal reportBoeing 787 · Singapore, SingaporeThe uncontained left engine failure was caused by the failure and liberation of the HPT stage 1 aft blade retainer as a result of a fatigue crack in the upper collet radius that originated from a surface connected cluster of Oxide/Carbonitride/Nitride/Carbide…NTSB ENG23WA041IncidentClass 3 · ForeignAirbus A320 · Almaty, KazakhstanNTSB ENG23LA034Incident · No injuriesClass 3 · LimitedFinal reportHall Lester R Legacy · Rochester, MNMechanically distressed reduction gears causing an engine overspeed and turbine blade tensile overload and subsequent uncontainment. Contributing to the uncontainment was the operator’s use of the engine after knowingly purchasing the engine in an…NTSB ENG23WA008IncidentClass 3 · ForeignAirbus A320 · Guadalajara, MexicoNTSB ENG21WA018IncidentClass 5 · ForeignAirbus A300 · Bogota, Colombia
See all 45 casesQuery 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\" = '343') 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.
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" = '343') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.