Fatal NTSB investigations, 2018

12 cases where the sequence of events included Aircraft structural failure.

Cases per year

20082026
Fatal NTSB investigations, 2018 per year, 2008–2026: 155 cases
200812
200920
20109
201113
201212
201313
20144
20158
20168
20177
201812
20195
20206
20214
20226
20237
20248
20251

Latest 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '337' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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.

NTSB ERA19LA072Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA46 · Mayport, FLAn in-flight loss of control following an encounter with supercooled large droplet icing conditions, which ultimately resulted in an uncontrolled descent and subsequent inflight breakup. Also causal was the pilot’s failure to maintain an appropriate airspeed…Dec 20, 2018 · N307JM · DestroyedNTSB 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.Dec 18, 2018 · N203SW · Substantial damageNTSB 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.Nov 18, 2018 · N441CX · DestroyedNTSB CEN19FA004Accident · 2 fatalField investigationFinal reportPiper PA32RT · Poolville, TXThe pilot's loss of airplane control as a result of spatial disorientation and the exceedance of the structural capabilities of the airplane. Contributing to the accident was the pilot's limited experience in instrument conditions.Oct 12, 2018 · N221MC · DestroyedNTSB 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.Sep 1, 2018 · N815EY · DestroyedNTSB 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…Aug 18, 2018 · N105SE · Substantial damageNTSB 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…Aug 1, 2018 · XB-FMA · DestroyedNTSB 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…Jul 30, 2018 · C-IGKT · Substantial damageNTSB 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.Jul 19, 2018 · N228LC · DestroyedNTSB 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…Apr 4, 2018 · N106ER · DestroyedNTSB 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.Feb 19, 2018 · N14GQ · DestroyedNTSB 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.Jan 22, 2018 · N262WS · Destroyed