NTSB investigations, 2018
13 cases where the defining event was Aircraft structural failure.
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 21 |
| 2010 | 16 |
| 2011 | 14 |
| 2012 | 9 |
| 2013 | 10 |
| 2014 | 12 |
| 2015 | 9 |
| 2016 | 11 |
| 2017 | 5 |
| 2018 | 13 |
| 2019 | 4 |
| 2020 | 8 |
| 2021 | 6 |
| 2022 | 9 |
| 2023 | 8 |
| 2024 | 8 |
| 2025 | 1 |
| 2026 | 2 |
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\") = 2018
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '337')
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") = 2018 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '337') 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 ERA19FA068Accident · 1 fatalClass 2 · FieldFinal reportSaberwing Saberwing · Adel, GAThe in-flight failure of the fuselage, as a result of the pilot conducting maneuvers that exceeded the structural capabilities of the airplane.NTSB DCA19WA044Incident · No injuriesForeign investigationBoeing 737 · Tijuana, MexicoThe DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on December 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13 as…NTSB CEN19FA030Accident · 3 fatalClass 2 · FieldFinal reportCessna 441 · Harmon, NDThe pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.NTSB ERA19LA050Accident · Minor injuriesClass 3 · LimitedFinal reportUltralite Sro Stingsport · Clermont, FLAn inflight failure of the airplane’s horizontal stabilizer.NTSB ERA18FA240Accident · 1 fatalField investigationFinal reportLance M Hooley Jetez · Covington, TNThe improper manufacture of the left wing, which resulted in a left wing flutter event and failure at low altitude and high speed.NTSB ERA18FA221Accident · 2 fatalField investigationFinal reportQuicksilver MXL II Sport · Westminster, MDThe in-flight fracture of a stainless steel bolt that was used to secure the upper and lower wing cables to the outer attach point at the leading edge spar of the right wing due to stress corrosion cracking, which caused the right wing to fail and precluded…NTSB CEN18WA343Accident · 1 fatalForeign investigationPiper PA25 · Namiquipa, MexicoOn August 1, 2018, about 0956 hours mountain daylight time, a Piper PA-25-235 single-engine airplane, serial number 25-4177, Mexican registration XB-FMA, crashed in an agricultural field near Namiquipa, Mexico. The pilot was fatally injured. The local aerial…NTSB CEN18WA304Accident · 1 fatalForeign investigationQuad City Challenger · North Bay, CanadaOn July 30, 2018, about 1500 Coordinated Universal Time, a Quad City Challenger II airplane, Canadian registration C-IGKT, crashed near Talon Lake, North Bay, Ontario, Canada. The pilot was fatally injured. The flight departed North Bay (CYYB), Ontario, and…NTSB CEN18FA282Accident · 1 fatalField investigationFinal reportFisher Celebrity · Patriot, INAn in-flight separation of the right wing due to upward and rearward bending that led to an overstress fracture. The reason for the upward and rearward bending could not be determined based on the available information.NTSB ERA18FA120Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Daytona Beach, FLExtensive fatigue cracking in the left-wing main spar lower cap and doublers, which resulted in the in-flight separation of the left wing. The fatigue cracks initiated and grew to a critical size due to flight and ground loads associated with flight-training…NTSB WPR18FA091Accident · 1 fatalField investigationFinal reportPiper PA34 · Minden, NVThe pilot's loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing to the accident was the pilot's impairment from the use of a sedating antihistamine.NTSB ENG18RA012Incident · No injuriesForeign investigationEmbraer ERJ190 · Mar Del Plata, ArgentinaThe Junta de Investigacion de Accidentes de Avicion Civil (JIAAC) Republica Argentina has notified the NTSB of an incident involving an Embraer ERJ 190 which occurred on January 29, 2018. The NTSB has appointed a US Accredited Representative to assist the…NTSB ERA18FA064Accident · 1 fatalField investigationFinal reportVans RV-12 · Bonita Springs, FLThe pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.