NTSB investigations, 2010, PA

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

Cases per year

20082026
NTSB investigations, 2010, 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\") = 2010
    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 ERA10LA458Accident · No injuriesLimited investigationFinal reportBird CK · Eagles Mere, PAThe loss of engine power due to fuel starvation as a result of degradation of the fuel tank coating which blocked the fuel supply.Aug 31, 2010 · N765N · Substantial damageNTSB ERA10LA439Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tunkhannock, PAA total loss of engine power during the initial climb due to the pilots' inadequate in-flight fuel management.Aug 20, 2010 · N4850A · Substantial damageNTSB ERA10FA404Accident · 2 fatalField investigationFinal reportBeech 58 · Saltsburg, PAThe pilot’s loss of control of the airplane during low-airspeed airwork and his failure to promptly recover the airplane from the aerodynamic stall, which resulted in a spin. Contributing to the accident were the pilot and certified flight instructor’s…Aug 7, 2010 · N28MR · Substantial damageNTSB ERA10CA397Accident · No injuriesData collectionFinal reportLuscombe 8C · Zelienople, PAThe pilot's loss of directional control while taking off with a gusting wind.Aug 1, 2010 · N4113M · Substantial damageNTSB ERA10GA320Accident · 3 fatalFinal reportCessna T210L · Lock Haven, PAThe total loss of engine power resulting from the fatigue failure of the engine's number 2 cylinder exhaust valve. The fatigue failure was due to valve guide wear that led to excessive clearance between the valve and valve guide. Contributing to the accident…Jun 21, 2010 · N30266 · Substantial damageNTSB ERA10CA260Accident · Serious injuriesData collectionFinal reportSchleicher ASW-20C · Unionville, PAThe pilot's lack of remedial action in response to a loss of altitude, which led to a forced landing in unsuitable terrain.May 9, 2010 · N6BF · Substantial damageNTSB ERA10CA245Accident · No injuriesData collectionFinal reportPiper PA-22-135 · Hoensdale, PAThe pilot's improper final approach, resulting in a bounced landing and ground loop. Contributing to the accident was the pilot's lack of experience in tailwheel airplanes.Apr 24, 2010 · N170JH · Substantial damageNTSB ERA10CA181Accident · No injuriesData collectionFinal reportCessna 172M · Connelsville, PAA total loss of engine power due to fuel exhaustion due to the pilot's failure to refuel.Mar 21, 2010 · N8921V · Substantial damageNTSB ERA10CA231Accident · Minor injuriesData collectionFinal reportCessna 340A · Grove City, PAThe pilot's failure to maintain directional control after electing to land on a snow-covered runway.Feb 27, 2010 · N1952E · Substantial damageNTSB ERA10LA104Accident · No injuriesLimited investigationFinal reportCessna 150G · Doylestown, PAA partial loss of engine power due to carburetor icing.Jan 1, 2010 · N4026J · Substantial damage