NTSB investigations, 2022, PA

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

Cases per year

20082026
NTSB investigations, 2022, 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\") = 2022
    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 ERA23FA045Accident · 2 fatalClass 3 · FieldFinal reportBearhawk Patrol · Hanover Township, PAThe pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.Oct 29, 2022 · N964RS · Substantial damageNTSB ERA23LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna A185E · York, PAOil starvation of the number 1 connecting rod bearings, which resulted in a total loss of engine power.Oct 22, 2022 · N36ZN · Substantial damageNTSB ERA22LA411Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Clearfield, PAA sudden partial loss of engine power for undetermined reasons, which resulted in an off-airport landing.Sep 3, 2022 · N9619H · Substantial damageNTSB ERA22LA407Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · Mount Bethel, PAThe glider’s encounter with atmospheric conditions, where the lift was not sufficient to maintain flight resulting in an off-airport landing and collision with powerlines.Sep 3, 2022 · N17867 · Substantial damageNTSB ERA22LA304Accident · Serious injuriesClass 4 · LimitedFinal reportArion Lightning · Indiana, PAThe airplane pilot’s inadvertent encounter with rotor wash/turbulence during short final approach, which resulted in a loss of control in flight.Jul 10, 2022 · N326AL · Substantial damageNTSB ERA22LA289Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Palmyra, PAThe pilot’s failure to maintain a proper glide path to the runway.Jun 25, 2022 · N1476K · Substantial damageNTSB ERA22FA137Accident · 2 fatalClass 3 · FieldFinal reportBeech 35 · Hilltown Township, PAThe pilots’ exceedance of the airplane’s critical angle of attack while practicing maneuvers during an instructional flight, which resulted in an aerodynamic stall and and a loss of airplane control.Feb 24, 2022 · N6129V · Destroyed