NTSB investigations, 2022, PA

8 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2022, PA per year, 2008–2026: 100 cases
20085
20099
20103
20114
20127
20135
20145
20158
20166
20179
20186
20195
20205
20218
20228
20231
20243
20251
20262

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\" = '300' 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 ERA23LA030Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Factoryville, PAThe pilot's failure to maintain directional control while practicing a soft-field takeoff maneuver, which resulted in a runway excursion and impact with a hangar.Oct 21, 2022 · N658CP · Substantial damageNTSB ERA22LA377Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Lehighton, PAThe pilot failure to ensure the runway was clear before landing, resulting in a runway excursion and collision with runway lights.Aug 10, 2022 · N7695W · Substantial damageNTSB ERA22LA355Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7BCM · Cranberry Township, PAThe pilots’ failure to maintain directional control of the airplane while landing in gusting wind conditions.Aug 3, 2022 · N9325H · Substantial damageNTSB ERA22LA352Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Nixon, PAThe pilot’s failure to maintain directional control while landing, resulting in a runway excursion. Contributing to the outcome was the pilot’s failure to ensure that the airplane’s right side door was properly secured prior to departing on the accident…Aug 3, 2022 · N459BT · Substantial damageNTSB ERA22LA316Accident · No injuriesClass 4 · LimitedFinal reportCessna P337H · Monongahela, PAThe malfunction of the braking system fluid line, which resulted in an overrun of the runway.Jul 14, 2022 · N5GY · Substantial damageNTSB ERA22LA272Accident · No injuriesClass 3 · LimitedFinal reportCessna 414 · Monongahela, PALoss of braking authority due to a loosened brake line fitting for reasons that could not be determined, which resulted in a runway overrun.Jun 19, 2022 · N1996G · Substantial damageNTSB ERA22LA215Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 414 · Connellsville, PAThe pilot/mechanic’s failure to properly secure two airplane avionics units, which resulted in the trays supporting the units to sag downward and become lodged in the movement area of the elevator bellcrank during the accident takeoff.May 2, 2022 · N46TA · Substantial damageNTSB ERA22LA150Accident · No injuriesClass 3 · LimitedFinal reportHonda Jet HA-420 · Pittsburgh, PAThe flight crew's continuation of an unstable approach, which resulted in a long landing on a contaminated runway. Contributing to the outcome was the captain’s full application of the emergency brake, which resulted in hydroplaning and a runway excursion.Mar 9, 2022 · N903JT · Substantial damage