NTSB investigations, PA
9 cases where the defining event was Unknown or undetermined.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2014 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
| 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\" = '000')
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" = '000') 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 ERA27LA006Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 525 · Bedford, PAOn October 7, 2026, at 1021 eastern daylight time, a Cessna 525 airplane, N600AL, was substantially damaged when it was involved in an accident near Bedford, Pennsylvania. One airline transport pilot sustained minor injuries, and the other airline transport…NTSB ERA25MA106Accident · 7 fatalClass 2 · MajorPreliminary reportLearjet 55 · Philadelphia, PAOn January 31, 2025, at 1807 eastern standard time, a Learjet 55 airplane, Mexican registration XA-UCI (call sign MTS056) was destroyed when it was involved in an accident in Philadelphia, Pennsylvania. The two pilots, two medical crewmembers, and two…NTSB ERA25LA044Accident · No injuriesClass 3 · LimitedFinal reportSchweizer 269C-1 · Boalsburg, PAA loss of engine power for reasons that could not be determined.NTSB ERA23LA383Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Towanda, PAA total loss of engine power during initial climb for undetermined reasons.NTSB ERA22FA105Accident · Serious injuriesClass 3 · FieldFinal reportEurocopter Deutschland EC135 P2+ · Drexel Hill, PAAn inflight attitude upset for undetermined reasons that resulted in a rotor system overspeed, a reduction of power from both engines, and a subsequent hard landing.NTSB ERA22LA039Accident · No injuriesClass 3 · LimitedFinal reportBell 47D1 · Zelienople, PAA total loss of engine power for reasons that could not be determined.NTSB ERA15LA001Accident · 1 fatalLimited investigationFinal reportAir Command 582 · Monongahela, PAThe amateur-built gyroplane’s collision with terrain for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s decision to conduct the flight without obtaining additional training.NTSB ERA11FA293Accident · Serious injuriesField investigationFinal reportBeech F33A · Tarentum, PAThe pilot's delay in aborting the takeoff, which resulted in a runway overrun. Contributing to the accident was the pilot's inadequate preflight planning and excessive loading of the airplane.NTSB ERA09LA410Accident · No injuriesLimited investigationFinal reportRobinson R44 · Silver Spring, PAThe student pilot's inability to fully control the helicopter, during cruise and the resultant off-field hard landing.