NTSB investigations, 2018

63 cases where the sequence of events included Part(s) separation from AC.

Cases, newest first

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '338' 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 DCA18WA155Incident · No injuriesForeign investigationBoeing 737 · MexicoThe government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…Apr 18, 2018 · XA-UQA · No damageNTSB GAA18CA228Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Ashland, VAThe student pilot’s improper landing flare and the flight instructor’s delayed remedial action, which resulted in a hard landing.Apr 17, 2018 · N404TA · Substantial damageNTSB ERA18WA132Accident · No injuriesForeign investigationBell 206 · Vereda Plateado, ColombiaThe government of Colombia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the provisions…Apr 11, 2018 · HK-4776 · Substantial damageNTSB GAA18CA203Accident · No injuriesData collectionFinal reportCarr B L RV 4 · Caldwell, IDThe failure of the weld on the airplane’s left main landing gear axle support strut during landing, which resulted in a loss of directional control.Apr 6, 2018 · N66PB · Substantial damageNTSB ANC18LA030Accident · No injuriesLimited investigationFinal reportChampion 7GC · Anchorage, AKThe pilot's failure to maintain directional control during landing with a crosswind, which resulted in a loss of control and failure of the main landing gear. Contributing to the accident was the pilot's self-induced pressure to land.Mar 26, 2018 · N4844E · Substantial damageNTSB GAA18CA176Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Ontario, ORThe flight instructor's failure to maintain directional control during landing, in cross wind conditions.Mar 18, 2018 · N234RA · Substantial damageNTSB GAA18CA158Accident · Minor injuriesData collectionFinal reportJohnson Gerald CR-1 · Altamont, NYThe pilot’s failure to maintain the runway heading during the approach in gusting crosswind conditions.Mar 11, 2018 · N142DT · Substantial damageNTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.Feb 26, 2018 · N1722J · Substantial damageNTSB WPR18FA088Accident · 4 fatalField investigationFinal reportHastings Thomas G Cirrus VK 30 · Agua Dulce, CAThe driveshaft fracture due to overstress loading and rotational bending as a result of the under-torqued nuts on the elastomeric couplings backing off and the subsequent in-flight separation of the horizontal fairing due to contact with the separated end of…Feb 11, 2018 · N52TH · Substantial damageNTSB GAA18CA108Accident · No injuriesData collectionFinal reportPiper J3L · Astoria, ORThe control stick handgrip separation from the control stick resulting in the airplane pitching forward, which resulted in hard landing.Jan 13, 2018 · N35226 · Substantial damageNTSB GAA18CA102Accident · No injuriesData collectionFinal reportPiper PA 28 · Corona, CAThe student pilot and flight instructor’s failure to see and avoid powerlines during a simulated emergency landing, which resulted in a wire strike during a go-around.Jan 13, 2018 · N7085R · Substantial damageNTSB CEN18CA072Accident · No injuriesData collectionFinal reportBell Helicopter Textron Canada 407 · Norfolk, NEMaintenance personnel’s failure to properly secure the tail rotor drive shaft cover, which resulted in the cover departing the helicopter in flight.Jan 5, 2018 · N214AM · Substantial damageNTSB ANC18LA018Accident · No injuriesClass 2 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2006 · Lynchburg, VAThe failure of the left main landing gear assembly due to a fatigue fracture along the inside circumferential weld on the trailing arm’s attachment flange, which resulted from the manufacturer’s inadequate welding of the trailing arm connecting the lower arm…Jan 1, 2018 · N594MA · Substantial damage