NTSB investigations, 2015, PA

8 cases where the sequence of events included Loss of control on ground.

Cases per year

20082026
NTSB investigations, 2015, PA per year, 2008–2026: 85 cases
20082
20096
20105
20113
20126
20133
20144
20158
20161
20179
20185
20197
20206
20216
20224
20244
20253
20263

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\") = 2015
    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\" = '230' 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 GAA16CA084Accident · No injuriesData collectionFinal reportPiper PA22 · New Castle, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and a nose over.Dec 20, 2015 · N5667Z · Substantial damageNTSB GAA16CA038Accident · No injuriesData collectionFinal reportAeronca 7AC · Auburn, PAThe pilot's use of excessive brake pressure during the landing roll, which resulted in a nose over.Nov 2, 2015 · N84138 · Substantial damageNTSB GAA15CA263Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Doylestown, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane. Contributing to the accident was the pilot's fatigue during the flight.Sep 7, 2015 · N1125X · Substantial damageNTSB ERA15LA319Accident · Serious injuriesLimited investigationFinal reportHead AX9 118 · New Holland, PAThe pilot's failure to adequately secure the vent line, which resulted in the premature deflation of the balloon’s envelope and its subsequent contact with power lines. Contributing to the accident were the pilot's choice of an unsuitable landing area, which…Aug 16, 2015 · N40104 · Minor damageNTSB GAA15CA203Accident · No injuriesData collectionFinal reportWelch Floyd L Quickie Q 2 · Hazleton, PAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and nose over.Jul 23, 2015 · N518JW · Substantial damageNTSB GAA15CA095Accident · No injuriesData collectionFinal reportCessna 182Q · Honesdale, PAThe pilot's failure to land with sufficient runway remaining to safely stop the airplane.May 25, 2015 · N759EB · Substantial damageNTSB ERA15CA162Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · St Marys, PAThe pilot's failure to maintain directional control while landing in a gusty crosswind, which resulted in a runway excursion and a nose over.Mar 12, 2015 · N7772J · Substantial damageNTSB ERA15CA106Accident · No injuriesData collectionFinal reportCessna 172L · New Castle, PAPilot's inadequate control of the airplane during the landing roll, which resulted in a runway excursion.Jan 16, 2015 · N7079Q · Substantial damage