NTSB investigations, 2017

9 cases where NTSB found Debris/dirt/foreign object.

Cases per year

20082026
NTSB investigations, 2017 per year, 2008–2026: 101 cases
20084
20095
20103
20114
20124
20135
201416
201510
20165
20179
20184
20194
20206
20216
20225
20231
20246
20253
20261

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\", '03022055'))
  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 WPR18CA048Accident · Serious injuriesData collectionFinal reportCessna 172P · Valley Springs, CAThe pilot's failure to maintain clearance from trees while maneuvering for landing and his decision to land on a surface with obstructions.Dec 14, 2017 · N54873 · Substantial damageNTSB ERA18LA044Accident · No injuriesLimited investigationFinal reportPiper PA34 · Thomasville, GAA stone becoming lodged in a left main landing gear (MLG) drag link, which resulted in the failure of the left MLG to extend and lock.Dec 3, 2017 · N8328V · Substantial damageNTSB ERA18LA026Accident · No injuriesLimited investigationFinal reportPiper PA28 · Bladenboro, NCA loss of engine power due to carburetor icing and the presence of an insect nest in the carburetor heat control box that prevented the pilot’s application of carburetor heat from restoring engine power.Nov 18, 2017 · N8758N · Substantial damageNTSB GAA18CA034Accident · No injuriesData collectionFinal reportAirbus Helicopters EC 130 · La Paloma, TXThe separation of a weight from the gunner’s net, which struck the helicopter’s main rotor blade during flight.Oct 26, 2017 · N22TZ · Substantial damageNTSB ANC17LA042Accident · No injuriesLimited investigationFinal reportBeech 19A · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the right main landing (MLG) tire impacting a rock and the subsequent loss of directional control and collapse of the right MLG.Aug 5, 2017 · N6523T · Substantial damageNTSB GAA17CA359Accident · No injuriesData collectionFinal reportCessna A188 · Salem, ORThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in the airplane contacting tall grass.Jun 14, 2017 · N4877Q · Substantial damageNTSB GAA17CA323Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prosser, WAThe pilot’s abrupt maneuver to avoid hay bales during the takeoff roll, which resulted in a loss of directional control.Jun 5, 2017 · N802NB · Substantial damageNTSB WPR17LA094Accident · Minor injuriesLimited investigationFinal reportYakovlev YAK 52 · Porterville, CAA partial loss of engine power due to contaminants in the fuel system that decreased the fuel flow, the source of which could not be determined.Apr 29, 2017 · N132MD · Substantial damageNTSB GAA17CA166Accident · No injuriesData collectionFinal reportPiper PA28 · Phoenix, AZThe flight instructor’s incorrect control inputs while taking off with a known quartering tailwind, which resulted in a loss of directional control and runway excursion.Feb 27, 2017 · N309PA · Substantial damage