NTSB investigations, PA
24 cases where the defining event was Hard landing.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 4 |
| 2011 | 1 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 1 |
| 2021 | 3 |
| 2022 | 2 |
| 2023 | 1 |
| 2024 | 2 |
| 2026 | 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\" = '092')
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" = '092') 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 ERA26LA353Accident · No injuriesClass 4 · LimitedInvestigation openRoberts GS-2 Sportsman · Kerrtown, PANTSB ERA24LA389Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Erie, PAThe student pilot’s improper landing flare and subsequent improper recovery from a bounced landing and the flight instructor’s inadequate remedial action.NTSB ERA24LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · Allentown, PAThe pilot’s failure to maintain a proper descent rate during the final approach, resulting in a hard landing and collision with a runway edge light.NTSB ERA23LA213Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · West Mifflin, PAThe student pilot’s improper landing flare, and the flight instructor’s delayed remedial action, which resulted in a hard landing.NTSB ERA22LA195Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32 · Carlisle, PAThe pilot’s improper landing flare, which resulted in the airplane’s empennage impacting the runway surface during landing.NTSB ERA22LA118Accident · No injuriesClass 4 · LimitedFinal reportHiller UH-12E4 · Shrewsbury, PAThe pilot’s failure to maintain control during the descent which resulted in a hard landing.NTSB ERA22LA072Accident · No injuriesClass 4 · LimitedFinal reportAeronca O58B · Jonestown, PAThe pilot’s incorrect glide path and landing flare, which resulted in a collision with obstacles on final approach and a hard landing.NTSB ERA21LA242Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Pittsfield, PAThe student pilot’s improper landing flare, which resulted in a hard landing and loss of directional control.NTSB ERA21LA268Accident · Minor injuriesClass 4 · LimitedFinal reportCessna T210 · Bloomsburg, PAThe pilot’s unstable approach and delayed go-around attempt, which resulted in a porpoised landing, a nose landing gear collapse, and runway excursion.NTSB GAA19CA514Accident · No injuriesData collectionFinal reportHughes 269A · Shamokin, PAThe pilot's improper landing flare during an autorotation, which resulted in a hard landing. Contributing to the accident was a loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of any…NTSB ERA17LA046Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 · West Chester, PAThe flight instructor's decision to continue the practice autorotation in known gusting wind conditions, which resulted in a hard landing and roll over.NTSB GAA15CA119Accident · No injuriesData collectionFinal reportCessna 172R · Beaver Falls, PAThe student pilot's failure to maintain airplane attitude control during the landing, resulting in a hard landing.NTSB ERA14CA273Accident · No injuriesData collectionFinal reportCessna 172S · Harrisburg, PAThe pilot's failure to compensate for wind conditions during landing, which resulted in a hard landing.NTSB ERA14CA031Accident · Serious injuriesData collectionFinal reportSchweizer SGS 1 26E · Eighty Four, PAThe pilot's failure to maintain proper airspeed and glide path, which resulted in an overshoot, a hard landing, and a subsequent collision with terrain. Contributing to the accident was the pilot's lack of total experience in make and model.NTSB ERA13CA357Accident · No injuriesData collectionFinal reportPiper PA-34-200T · West Mifflin, PAThe pilot's improper landing flare, which resulted in a hard landing.NTSB ERA13LA288Accident · Serious injuriesLimited investigationFinal reportHagerty RV-7A · Altoona, PAThe pilot's improper recovery from an encounter with a wind gust during landing, which resulted in a hard landing on, and displacement of, the nose landing gear and a subsequent runway excursion and noseover.NTSB ERA13LA212Accident · Serious injuriesLimited investigationFinal reportCameron Balloons US Z-225 · Chester Springs, PAThe pilot's failure to extinguish the burner pilot lights prior to a hard landing in windy conditions.NTSB ERA11CA227Accident · No injuriesData collectionFinal reportCessna 150A · Factoryville, PAThe pilot's inadequate flare during the gusty crosswind landing, which resulted in a hard landing.NTSB ERA10CA075Accident · No injuriesData collectionFinal reportSchweizer 269C-1 · Lebanon, PAThe pilot’s failure to arrest the helicopter descent during the simulated engine out maneuver resulting in a hard landing.NTSB ERA09FA414Accident · 1 fatalField investigationFinal reportHughes 369 · Franklin, PAA loss of engine power due to fuel exhaustion as a result of the pilot's fuel mismanagement.NTSB ERA09CA341Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · West Chester, PAThe student pilot’s improper recovery from a bounced landing. Contributing to the accident was the flight instructor’s inadequate remedial action.NTSB ERA09CA287Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Danville, PAThe student pilot's failure to maintain control during a landing.NTSB NYC08FA307Accident · 1 fatalField investigationFinal reportLindstrand Balloons 150A · Phoenixville, PAThe separation of a portion of a fuel fitting during a hard landing resulting in release of fuel and a fire in the balloons basket area. Contributing to the accident was the pilot's failure to follow the manufacturer's published procedures to shut down the…NTSB NYC08CA216Accident · Minor injuriesData collectionFinal reportSchweizer S6S 2-33 · Mercer, PAThe private pilot's improper aircraft handling.