NTSB investigations, 2018, PA

14 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2018, PA per year, 2008–2026: 206 cases
200810
200913
201010
201112
201223
201313
201410
201520
201615
201721
201814
201912
20203
20219
20227
20234
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\") = 2018
    AND c.\"eventStateOrRegion\" = 'PA' 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\" = '470' 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 ERA19LA024Accident · Minor injuriesLimited investigationFinal reportBeech 35 · State College, PAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.Oct 24, 2018 · N8319D · Substantial damageNTSB GAA19CA082Accident · No injuriesData collectionFinal reportPiper PA28 · Waynesburg, PAThe student pilot's improper decision to maneuver the airplane through an area of construction and his subsequent failure to maintain clearance from a concrete pole barrier while taxiing.Oct 19, 2018 · N8222N · Substantial damageNTSB GAA19CA022Accident · No injuriesData collectionFinal reportPiper PA 18-135 · Cherry Ridge, PAThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.Oct 14, 2018 · N6690D · Substantial damageNTSB ERA18LA243Accident · No injuriesClass 3 · LimitedFinal reportPiper PA12 · Cochranton, PAA total loss of engine power for reasons that could not be determined based on the available information.Sep 1, 2018 · N3415M · Substantial damageNTSB GAA18CA540Accident · No injuriesData collectionFinal reportYakovlev YAK 52 · East Stroudsburg, PAThe pilot's failure to extend the landing gear during landing, which resulted in a runway excursion and subsequent impact with terrain.Aug 25, 2018 · N3042W · Substantial damageNTSB GAA18CA456Accident · No injuriesData collectionFinal reportLuscombe 8 · Pottsville, PAThe pilot’s failure to maintain directional control during landing.Jul 30, 2018 · N2022K · Substantial damageNTSB ERA18LA192Accident · Minor injuriesClass 3 · LimitedFinal reportSchweizer 269D · Stewartstown, PAThe pilot's inability to maintain yaw control while transitioning to an out of ground effect hover due to a loss of tail rotor effectiveness.Jul 14, 2018 · N411HU · Substantial damageNTSB ERA18LA163Accident · Minor injuriesLimited investigationFinal reportVans RV4 · Butler, PAThe pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.Jun 7, 2018 · N7765X · Substantial damageNTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.May 12, 2018 · N2485D · Substantial damageNTSB CEN18FA144Accident · 2 fatalField investigationFinal reportCirrus Design SR22 · Williamsburg, PAThe pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after…Apr 19, 2018 · N451TD · DestroyedNTSB ERA18FA122Accident · 2 fatalField investigationFinal reportMD Helicopter 600 · Smethport, PAThe helicopter pilot's failure to maintain adequate clearance during power line construction work, which resulted in the helicopter's main rotor striking and becoming entangled with a wire and a subsequent dynamic rollover and collision with terrain.…Apr 8, 2018 · N602BP · DestroyedNTSB GAA18CA175Accident · Minor injuriesData collectionFinal reportCessna 172 · Beaver Falls, PAThe student pilot’s failure to maintain directional control during the landing roll.Mar 23, 2018 · N987AV · Substantial damageNTSB ERA18LA072Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Farmington, PAA total loss of engine power due to fatigue failure of the crankshaft drive gear teeth.Jan 29, 2018 · N34VF · Substantial damageNTSB GAA18CA116Accident · No injuriesData collectionFinal reportBeech B19 · Meadville, PAThe student pilot’s failure to maintain directional control during landing.Jan 10, 2018 · N24002 · Substantial damage