NTSB investigations, PA
20 cases where the defining event was Runway excursion.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 5 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '300')
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.
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 c."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '300') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB ERA23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · West Mifflin, PAThe student pilot’s decision to abort the takeoff and land on the runway without sufficient runway remaining, which resulted in a runway overrun.NTSB 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.NTSB ERA22LA316Accident · No injuriesClass 4 · LimitedFinal reportCessna P337H · Monongahela, PAThe malfunction of the braking system fluid line, which resulted in an overrun of the runway.NTSB 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.NTSB ERA21LA296Accident · No injuriesClass 4 · LimitedFinal reportCessna 560XL · Reading, PAThe captain’s improper decision to continue an unstabilized approach despite several go-around calls by the pilot monitoring, which resulted in a runway excursion and substantial damage to the pressure vessel.NTSB ERA21LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Mount Pocono, PAThe pilot’s loss of aircraft control following a bounced landing.NTSB ERA17CA250Accident · No injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe pilot's failure to attain the proper touchdown point, which resulted in a runway overrun.NTSB ERA17TA233Accident · No injuriesFinal reportLawrence O Nolte Zodiac CH650B · Dover, PAA total loss of engine power as a result of the loss of all electric fuel pumps due to a loss of electric power because of the installation of an improper battery on the airplane and the use of improper charging cables on the battery.NTSB ERA16CA237Accident · No injuriesData collectionFinal reportPiper PA 28-161 · Honesdale, PAThe pilot's inadequate preflight planning, which resulted in his attempt to take off near the airplane’s maximum gross weight in high-density altitude conditions that degraded the airplane’s takeoff and climb performance and resulted in an aborted takeoff and…NTSB GAA15CA055Accident · No injuriesData collectionFinal reportBeech C 50 · Honesdale, PAThe pilot's failure to stop the airplane on the runway during landing, resulting in an overrun, landing gear collapse and substantial damage to the airplane.NTSB ERA14CA278Accident · Minor injuriesData collectionFinal reportCessna 172F · Mount Pleasant, PAThe pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.NTSB ERA13CA315Accident · Minor injuriesData collectionFinal reportBeech A23-19 · Easton, PAThe pilot's improper touchdown point during landing, which resulted in a runway overrun. Contributing to the accident was the pilot’s decision to land with a tailwind condition and his lack of recent experience.NTSB ERA12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Pottstown, PAThe pilot’s inadequate recovery from a bounced landing, which resulted in a loss of control.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.NTSB ERA09CA504Accident · No injuriesData collectionFinal reportCessna 152 · Harrisburg, PAThe student pilot’s delayed decision to abort the takeoff, resulting in an overrun.NTSB ERA09CA402Accident · No injuriesData collectionFinal reportCessna T337 · Pittsburgh, PAThe pilot's failure to obtain the proper touchdown point during landing.NTSB ERA09CA364Accident · No injuriesData collectionFinal reportPiper L-21B · Big Beaver, PAThe pilot's failure to maintain directional control during a landing rollout with a crosswind.NTSB ERA09CA301Accident · No injuriesData collectionFinal reportCessna 172N · Tunkhannock, PAThe pilot's failure to attain the proper touchdown point while landing with a tailwind.NTSB MIA08CA182Accident · No injuriesData collectionFinal reportCessna 172K · Tunkhannock, PAThe pilot's improper airspeed while landing.NTSB NYC08LA124Accident · No injuriesLimited investigationFinal reportRockwell 112TCA · West Chester, PAThe pilot's failure to ensure that the pitch trim was properly set for takeoff.