NTSB investigations, 2008, PA

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

Cases per year

20082026
NTSB investigations, 2008, 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\") = 2008
    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 ERA09LA098Accident · Minor injuriesLimited investigationFinal reportHess John L Spezio II · Newville, PAA loss of engine power due to carburetor ice as a result of the pilot's delayed use of carburetor heat.Dec 18, 2008 · N66JH · Substantial damageNTSB ERA09LA031Accident · Serious injuriesLimited investigationFinal reportHughes 369D · Carroll Township, PAA total loss of engine power due to the improper assembly of the compressor discharge tubes to the combustion liner.Oct 30, 2008 · N606AS · Substantial damageNTSB MIA08FA177Accident · 1 fatalField investigationFinal reportCessna T310R · Latrobe, PAThe pilot's impairment/incapacitation (cardiovascular) resulting in the pilot being unable to control the airplane.Aug 31, 2008 · N3180M · Substantial damageNTSB NYC08LA287Accident · Serious injuriesLimited investigationFinal reportBell 206A · Barnesville, PAThe pilot's failure to maintain control of the helicopter during the low-speed, low-altitude maneuver which resulted in a loss of tail rotor effectiveness.Aug 22, 2008 · N67AR · Substantial damageNTSB NYC08FA261Accident · No injuriesField investigationFinal reportEclipse EA500 · West Chester, PAThe pilot's failure to obtain the proper touchdown point, and his excessive airspeed on approach.Jul 30, 2008 · N333MY · Substantial damageNTSB NYC08CA220Accident · No injuriesData collectionFinal reportCessna 172P · Lancaster, PAThe student pilot's failure to maintain directional control during the landing rollout.Jun 19, 2008 · N52632 · Substantial damageNTSB NYC08CA210Accident · No injuriesData collectionFinal reportBell 206L-4 · Philadelphia, PAThe pilot's failure to maintain aircraft control during hover, which resulted in an inadvertent impact with the ground.Jun 8, 2008 · N94PD · Substantial damageNTSB NYC08FA198Accident · Minor injuriesField investigationFinal reportEurocopter Deutschland EC 135 P2+ · Pottsville, PAThe pilot’s failure to ensure that both engine switches were in the FLIGHT position for takeoff.May 31, 2008 · N238AM · Substantial damageNTSB NYC08FA189Accident · 2 fatalField investigationFinal reportGrumman American AA-1C · Philadelphia, PAThe flight instructor's failure to maintain airspeed which resulted in an inadvertent stall.May 22, 2008 · N9555U · DestroyedNTSB MIA08CA087Accident · No injuriesData collectionFinal reportAmerican Grumman AA 1B · State College, PAA partial loss of engine power for an undetermined reason.Apr 6, 2008 · N15FA · Substantial damage