NTSB investigations, 2023
15 cases where the defining event was Part(s) separation from AC.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 15 |
| 2010 | 14 |
| 2011 | 20 |
| 2012 | 15 |
| 2013 | 13 |
| 2014 | 13 |
| 2015 | 14 |
| 2016 | 22 |
| 2017 | 19 |
| 2018 | 18 |
| 2019 | 19 |
| 2020 | 12 |
| 2021 | 12 |
| 2022 | 13 |
| 2023 | 15 |
| 2024 | 19 |
| 2025 | 22 |
| 2026 | 9 |
Where
Open the mapLatest 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 year(c.\"eventDate\") = 2023
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '338')
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 year(c."eventDate") = 2023 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '338') 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.
NTSB ERA24FA075Accident · 1 fatalClass 3 · FieldFinal reportHughes Helicopters 369E · Miami, FLMain rotor contact with the tail boom for unknown reasons, resulting in the separation of the tail boom.NTSB DCA24WA059IncidentClass 5 · ForeignBoeing 737 · Brazzaville, Congo - KinshasaNTSB WPR24LA051Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Mesa, AZA failure of the engine cowling right side latch pin and fasteners, which resulted in the partial separation of the engine cowling during flight.NTSB CEN24LA038Accident · Minor injuriesClass 3 · LimitedFinal reportBede BD-4 · Lowell, INFatigue cracking of the propeller blade root, which resulted in the in-flight separation of the propeller blade from its root. Contributing to the accident was the improper machining of the blade root threads, which resulted in chatter/ratchet marks that…NTSB ENG24WA005Accident · No injuriesClass 5 · ForeignSikorsky S76 · Sidney, CanadaNTSB WPR23FA351Accident · 1 fatalClass 3 · FieldFinal reportGolden Circle T Bird · Arlington, WAA failure of the forward left wing spar due to an improper repair, which resulted in an inflight separation of the left wing. Contributing to the accident was improper maintenance by splicing the wing spar.NTSB DCA23WA479IncidentClass 5 · ForeignBoeing 777 · Ciaro, EgyptNTSB CEN23LA296Accident · Minor injuriesClass 3 · LimitedFinal reportMagni M24 · Mineral Point, MOThe inflight loss of the engine’s air filter which collided with the propeller which resulted in a vibration.NTSB DCA23WA301Incident · No injuriesClass 5 · ForeignBoeing 737 · Jeddah, Saudi ArabiaNTSB ERA23LA248Accident · No injuriesClass 4 · LimitedFinal reportRaytheon B300 · Melbourne, FLAn inflight separation of the airplane’s airstair door for undetermined reasons.NTSB CEN23LA218Incident · No injuriesClass 3 · LimitedFinal reportPiper J3C · Romeoville, ILThe inflight failure of the propeller blade due to fatigue cracking from corrosion pits, initiating at the midpoint of the cambered face.NTSB GAA23WA139Accident · 5 fatalClass 5 · ForeignCessna 206 · Santa Ana del Yucuma, BoliviaNTSB WPR23LA149Accident · No injuriesClass 3 · LimitedFinal reportStevens Kelly C RV-7 · Morgan, UTThe pilot/builder improperly torqued the propeller attachment bolts while reinstalling the propeller, which resulted in the fatigue failure of the bolts and the separation of the propeller assembly.NTSB ERA23FA174Accident · No injuriesClass 3 · FieldFinal reportCessna 525B · Gulf of Mexico (Gulf of Mexico)The separation of the left wing extension and winglet for reasons that could not be determined based on the available evidence.NTSB WPR23LA112Accident · 1 fatalClass 3 · LimitedFinal reportStar Lite SL1 · Corning, CAThe student pilot’s loss of airplane control during an intentional aerobatic maneuver, which resulted in an inflight separation of the left wing and subsequent impact with the terrain.