NTSB investigations, 2009, PA

9 cases where the sequence of events included Runway excursion.

Cases per year

20082026
NTSB investigations, 2009, 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\") = 2009
    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 ERA09CA539Accident · Minor injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe flight instructor's delayed decision to take control of the airplane and execute a missed approach. Contributing to the accident was the lack of communication between the certificated flight instructor and the pilot receiving instruction.Sep 27, 2009 · N5123E · Substantial damageNTSB ERA09LA540Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Gettysburg, PAThe failure of the left main wheel attachment fitting due to overstress.Sep 13, 2009 · N466CT · Substantial damageNTSB ERA09CA504Accident · No injuriesData collectionFinal reportCessna 152 · Harrisburg, PAThe student pilot’s delayed decision to abort the takeoff, resulting in an overrun.Aug 31, 2009 · N69124 · Substantial damageNTSB ERA09CA465Accident · No injuriesData collectionFinal reportAeronca 7AC · Finleyville, PAThe pilot’s failure to maintain directional control during landing.Aug 17, 2009 · N83661 · Substantial damageNTSB ERA09CA425Accident · Minor injuriesData collectionFinal reportCessna 177 · Towanda, PAThe failure of the pilot to maintain control of the airplane during a go around following a bounced landing.Jul 27, 2009 · N2980X · Substantial damageNTSB ERA09CA402Accident · No injuriesData collectionFinal reportCessna T337 · Pittsburgh, PAThe pilot's failure to obtain the proper touchdown point during landing.Jul 14, 2009 · N21NC · Substantial damageNTSB ERA09CA364Accident · No injuriesData collectionFinal reportPiper L-21B · Big Beaver, PAThe pilot's failure to maintain directional control during a landing rollout with a crosswind.Jun 22, 2009 · N10365 · Substantial damageNTSB ERA09CA307Accident · No injuriesData collectionFinal reportAerotek Pitts Spec · Beaver Falls, PAThe pilot’s failure to maintain directional control of the airplane during the landing rollout.May 24, 2009 · N55MF · Substantial damageNTSB ERA09CA301Accident · No injuriesData collectionFinal reportCessna 172N · Tunkhannock, PAThe pilot's failure to attain the proper touchdown point while landing with a tailwind.May 21, 2009 · N9492E · Substantial damage