NTSB investigations, 2018, CA

6 cases where the sequence of events included Collision during takeoff/land.

Cases per year

20082026
NTSB investigations, 2018, CA per year, 2008–2026: 100 cases
20085
20097
20102
20115
20128
20134
20142
20156
20163
20172
20186
20194
20209
202110
20226
20236
20247
20253
20265

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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '490' 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 GAA19CA052Accident · No injuriesData collectionFinal reportPiper PA28 · Merced, CAThe pilot's improper glidepath during a landing at night, which resulted in a collision with approach lights.Nov 4, 2018 · N2956B · Substantial damageNTSB WPR19FA001Accident · 1 fatalClass 2 · FieldFinal reportBeech V35 · La Verne, CAThe pilot's failure to maintain clearance from trees during a visual approach for landing. Contributing to the accident was the pilot's distraction during the approach.Oct 1, 2018 · N7997M · DestroyedNTSB WPR18CA146Accident · No injuriesData collectionFinal reportAyres S2R G10 · Marysville, CAThe pilot’s failure to maintain clearance from a truck while on final approach after the airplane encountered a downdraft, which resulted in the subsequent failure of the right main landing gear and loss of directional control.May 22, 2018 · N32064 · Substantial damageNTSB WPR18LA105Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-180 · Montague, CAImpact with powerlines and terrain after takeoff for reasons that could not be determined based on the available information.Mar 11, 2018 · N6611J · Substantial damageNTSB WPR18LA089Accident · No injuriesLimited investigationFinal reportShanks V Roger Vari EZE · Santa Monica, CAAn undetected fluid leak in the right brake line, which resulted in a reduction of braking effectiveness at the right wheel and a loss of directional control during the landing roll.Feb 11, 2018 · N944X · Substantial damageNTSB GAA18CA107Accident · No injuriesData collectionFinal reportBell UH 1H · Van Nuys, CAThe pilot’s failure to maintain clearance from a stationary helicopter during landing. Contributing to the accident was the ground crew’s failure to ensure that the helicopter would clear the stationary helicopter.Jan 12, 2018 · N205KS · Substantial damage