NTSB finding · Aircraft › Aircraft structures › Aircraft structures, general
- Cases
- 72
- In the probable cause
- 57 (79%)
- Fatal cases
- 40
- NTSB code
- 01030000
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
| 2008 | 6 |
|---|---|
| 2009 | 7 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 9 |
| 2013 | 6 |
| 2014 | 1 |
| 2015 | 4 |
| 2016 | 4 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 5 |
| 2024 | 6 |
| 2025 | 2 |
| 2026 | 1 |
Where
Open the mapQuery 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\", '01030000') 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.
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", '01030000') AND c."eventDate" >= DATE '2000-01-01' 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 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\", '01030000'))
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\", '01030000') 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.
WITH matched AS (SELECT DISTINCT case_mkey, aircrafts_position FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' WHERE starts_with("findingCode", '01030000'))
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", '01030000') 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 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 · 72
NTSB CEN26LA131Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Van Burensburg, ILPropeller separation due to failure of the propeller attachment bolts.NTSB CEN25LA105Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Edgemont, SDThe pilot’s failure to properly identify the proper anchor point for the supplemental harness and the crew’s incorrect use of the restraint system structure as an anchor point, which resulted in the separation of the structure.NTSB CEN25LA090Accident · No injuriesClass 4 · LimitedFinal reportRutan Long-EZ · Sparta, ILAn onboard fire for unknown reasons.NTSB CEN24LA317Accident · No injuriesClass 3 · LimitedFinal reportVans RV8 · Guthrie, OKA loss of engine power due to the separation and ingestion of an air filter retaining bracket into the engine cylinder.NTSB CEN24LA270Incident · No injuriesClass 3 · LimitedFinal reportCessna R172E · Hillrose, COThe binding of the left flap due to improper maintenance.NTSB ERA24FA283Accident · 5 fatalClass 3 · FieldFinal reportPiper PA46 · Trout Creek, NYThe pilot’s loss of airplane control in flight due to spatial disorientation during a climb to cruise altitude in instrument meteorological conditions and turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was…NTSB WPR24LA122Accident · No injuriesClass 3 · LimitedFinal reportCessna 180A · Nordman, IDMaintenance personnel's improper installation of the left main landing gear wheel assembly, which resulted in a loss of torque and subsequent separation of the wheel and axle assembly from the main landing gear leg during landing.NTSB ERA24LA109Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Louisville, KYThe failure of maintenance personnel to thoroughly inspect and repair the worn-out panel fasteners and fastener holes.NTSB ERA24LA094Incident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Dulles, VAThe pilot-in-command’s approach to the critical angle of attack during initial climb, which resulted in a vibration the flight crew improperly identified as an engine issue and resulted in the subsequent off-airport landing. Contributing to the accident was…NTSB ERA23FA382Accident · 1 fatalClass 3 · FieldFinal reportSmith William S Smith Cozy Mark IV · Cullman, ALThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to the accident was the pilot/owner’s improper installation of engine…
See all 72 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01030000')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01030000')) 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.