NTSB investigations, 2017

5 cases where NTSB found Fuselage.

Cases per year

19792026
NTSB investigations, 2017 per year, 1979–2026: 125 cases
19791
20088
200916
201012
201111
20124
20138
20143
20155
20167
20175
20188
20198
20205
20214
20222
20236
20245
20254
20263

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\") = 2017
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010353'))
  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 DCA18CA056Accident · No injuriesData collectionFinal reportMcdonnell Douglas DC 9 33F · Bethel, AKfailure of a cargo tie-down fastener, resulting in unsecured cargo striking the pressure bulkhead.Dec 23, 2017 · N935CE · Substantial damageNTSB GAA17CA466Accident · No injuriesData collectionFinal reportAB Sportine Aviacija LAK 17 · Uvalde, TXThe ground crewmember’s failure to fully engage the tow hook release arm during preflight, which resulted in the premature release of the glider at insufficient altitude to complete a safe landing.Aug 2, 2017 · N128LA · DestroyedNTSB ERA17LA253Accident · No injuriesLimited investigationFinal reportWaco UPF 7 · Brunswick, GAThe failure of the right main landing gear strut brace for reasons that could not be determined based on the available evidence.Jul 3, 2017 · N134Q · Substantial damageNTSB WPR17FA089Accident · 1 fatalField investigationFinal reportAppleby Nieuport 28 · Paso Robles, CAThe failure of unknown personnel to properly safety an elevator control cable turnbuckle, which disconnected in flight resulting in loss of pitch control. Contributing to the accident was the inadequate design of the experimental airplane, which did not…Apr 23, 2017 · N6190 · Substantial damageNTSB WPR17FA074Accident · 1 fatalField investigationFinal reportQuicksilver MXL II · Hesperia, CAThe pilot's failure to identify and correct his construction error of a critical structural component, which resulted in a loss of airplane control during takeoff. Contributing to the accident was the pilot's impairment due to his combined use of multiple…Mar 7, 2017 · UNREG · Substantial damage