NTSB investigations, 2024
19 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\") = 2024
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") = 2024 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 GAA25WA041Accident · No injuriesClass 5 · ForeignCessna 188 · Barra Bonita, BrazilNTSB ERA25LA002Accident · 1 fatalClass 3 · LimitedPreliminary reportFokker D Viii Replica · Rhinebeck, NYOn October 5, 2024, about 1456 eastern daylight time, an experimental amateur-built Coughlin Fokker D-VIII Replica, N94100, was destroyed when it was involved in an accident near Old Rhinebeck Airport (NY94), Rhinebeck, New York. The commercial pilot was…NTSB DCA24WA315Incident · No injuriesClass 5 · ForeignBoeing 737 · Buenos Aires, ArgentinaNTSB DCA24WA272IncidentClass 5 · ForeignBoeing 747-400F · Narita, JapanNTSB ERA24LA325Accident · No injuriesClass 4 · LimitedFinal reportFlight Design Ctsw · Cuba, NYA separation of the left main landing gear wheel assembly during landing.NTSB ERA24LA303Accident · No injuriesClass 3 · LimitedFinal reportJones LONG-EZ · Thomasville, GAThe pilot reported that he was maneuvering around weather at 11,500 ft mean sea level (msl) when he made a rapid descent to 3,500 ft msl to remain clear of clouds. He reported that he did not exceed the airplane’s maneuvering speed during the descent, and…NTSB GAA24WA308Accident · No injuriesClass 5 · ForeignPiper PA28 · Leeds, United KingdomNTSB WPR24LA211Accident · No injuriesClass 3 · LimitedFinal reportBeech 58P · Escalante, UTThe failure of the windshield for undetermined reasons.NTSB DCA24LA210Accident · No injuriesClass 4 · LimitedFinal reportBoeing 767-316 ER · Milan, INOne or more latches were not fully re-engaged after a service check which resulted in the auxiliary power unit (APU) doors separating from the aircraft during climb out.NTSB DCA24WA168Incident · No injuriesClass 5 · ForeignBoeing 737 · Kempton Park, South AfricaNTSB 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 DCA24WA154IncidentClass 5 · ForeignBoeing 737 · Madrid, SpainNTSB DCA24WA123Incident · No injuriesClass 5 · ForeignBoeing 777 · West Sussex, United KingdomNTSB CEN24LA128Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland MBB-BK 117 C-2 · West Lafayette, INThe failure of maintenance personnel to properly install the tail rotor pitch change slider attachment hardware (T-bolt), which led to the disconnection of the pitch change slider, a loss of tail rotor control, and subsequent hard landing. Contributing to the…NTSB GAA24WA160AccidentClass 5 · ForeignRans S6 · Newtownards, United KingdomNTSB WPR24LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182A · Weippe, IDThe pilot’s failure to secure the oil filler cap during the preflight inspection, which resulted in a precautionary landing on the soft surface and subsequent nose over.NTSB GAA24WA119Incident · No injuriesClass 5 · ForeignAgusta AW139 · Kawajima, JapanNTSB 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 DCA24MA063Accident · Minor injuriesClass 1 · MajorFinal reportBoeing 737-9 · Portland, ORthe in-flight separation of the left mid exit door (MED) plug due to Boeing Commercial Airplanes’ failure to provide adequate training, guidance, and oversight necessary to ensure that manufacturing personnel could consistently and correctly comply with its…