Final NTSB investigations, 2021

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

Cases per year

20082026
Final NTSB investigations, 2021 per year, 2008–2026: 270 cases
200821
200933
201023
201121
201222
201318
201413
201514
201615
20179
201815
201912
20208
20217
202211
202312
202413
20251
20262

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\") = 2021
    AND c.\"completionStatus\" = 'Completed'
    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 DCA22LA038Accident · No injuriesClass 4 · LimitedFinal reportBoeing 747-4B5F · Miami, FLIncorrect lubrication of the foreflap fitting assembly.Nov 29, 2021 · N705CK · Substantial damageNTSB CEN21LA420Accident · Minor injuriesClass 3 · LimitedFinal reportQuad City Ultralight Challenger II · Rogers City, MIThe separation of the right wing’s forward lift strut from the fuselage due to a missing nylon-insert lock nut. Contributing to the accident was the noncertificated pilot’s decision to operate the airplane even though a condition inspection had not been…Sep 11, 2021 · N778H · Substantial damageNTSB WPR21LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Athol, IDThe failure of the windshield during spin recovery for reasons that were not determined.Aug 7, 2021 · N4110L · Substantial damageNTSB CEN21FA360Accident · 3 fatalClass 3 · FieldFinal reportMooney M20M · Victoria, MNThe pilot’s loss of airplane control due to spatial disorientation during final approach, which led to a spiral dive that overstressed the airplane and resulted in an in-flight breakup.Aug 7, 2021 · N9156Z · DestroyedNTSB CEN21FA314Accident · 1 fatalClass 3 · FieldFinal reportPZL Mielec M18 · Seiling, OKThe pilot’s in-flight loss of control due to the structural failure of a wing fitting and separation of the outboard wing section. Also causal were the inadequate wing fitting inspections, which failed to detect the initial corrosion and crack before it…Jul 12, 2021 · N9310R · DestroyedNTSB WPR21FA266Accident · 2 fatalClass 3 · FieldFinal reportBeech C90 · Wikieup, AZThe failure and separation of the left wing’s outboard section due to a fatigue crack in the lower spar cap. Contributing to the accident was the operator’s decision to repair the wing spar instead of replacing it as recommended by the aircraft manufacturer.…Jul 10, 2021 · N3688P · DestroyedNTSB ANC21FA015Accident · 2 fatalClass 3 · FieldFinal reportCessna 185 · Chitina, AKAn in-flight breakup during cruise flight for reasons that could not be determined based on available evidence.Feb 4, 2021 · N9725Z · Substantial damage