# NTSB investigations, PA: Approach

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

Page 1 of 13 · 627 cases

## Latest cases

- [NTSB ERA26LA307](https://openairdocs.org/ntsb/ERA26LA307.md): Piper PA-28-181 · Altoona, PA · Accident · No injuries · Class 4 · Limited · Final report · Aug 14, 2026 · N586MA · Substantial damage
  > The pilot’s descent below the glidepath and collision with trees during a missed approach.
- [NTSB ERA26LA156](https://openairdocs.org/ntsb/ERA26LA156.md): Piper PA-28-181 · Philadelphia, PA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Apr 1, 2026 · N494LA · Substantial damage
  > On April 1, 2026, about 1541 eastern daylight time, a Piper PA-28-181, N494LA, was substantially damaged when it was involved in an accident near Philadelphia, Pennsylvania. The flight instructor received minor injuries, and the student pilot received serious…
- [NTSB ERA25LA129](https://openairdocs.org/ntsb/ERA25LA129.md): Eurocopter Deutschland EC135T2 · Philadelphia, PA · Accident · No injuries · Class 4 · Limited · Final report · Feb 17, 2025 · N405TJ · 2 aircraft · Substantial damage
  > The sUAS operator’s failure to see and avoid a helicopter, resulting in a midair collision between the helicopter and the sUAS.
- [NTSB ERA25LA053](https://openairdocs.org/ntsb/ERA25LA053.md): Beech A36 · Doylestown, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Nov 18, 2024 · N8152R · Substantial damage
  > The pilot’s failure to maintain control of the airplane during an attempted go-around, which resulted in an aerodynamic stall and impact with terrain and a parked airplane.
- [NTSB ERA24FA292](https://openairdocs.org/ntsb/ERA24FA292.md): Cessna 172N · Lock Haven, PA · Accident · 1 fatal · Class 3 · Field · Final report · Jul 4, 2024 · N739GV · Destroyed
  > The student pilot’s premature turn to the crosswind leg of the traffic pattern at low airspeed and altitude, resulting in a collision with trees and terrain.
- [NTSB ERA24LA101](https://openairdocs.org/ntsb/ERA24LA101.md): Cessna 150M · Franklin, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 15, 2024 · N7682U · Substantial damage
  > The pilots’ inadequate preflight fuel planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN23LA348](https://openairdocs.org/ntsb/CEN23LA348.md): Cessna 172 · Philadelphia, PA · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 3, 2023 · N860TW · Substantial damage
  > The pilot receiving instruction’s failure to maintain control during a go-around. Contributing to the accident was the flight instructor’s inadequate supervision of the flight.
- [NTSB ERA23LA198](https://openairdocs.org/ntsb/ERA23LA198.md): S C Aerostar S A YAK-52 · Toughkenamon, PA · Accident · No injuries · Class 3 · Limited · Final report · Mar 22, 2023 · N669YK · Substantial damage
  > The pilot’s failure to see and avoid powerlines while on approach to land.
- [NTSB ERA22LA403](https://openairdocs.org/ntsb/ERA22LA403.md): Piper PA28R · Toughkenamon, PA · Accident · No injuries · Class 4 · Limited · Final report · Sep 2, 2022 · N78QB · Substantial damage
  > The airplane’s impact with a bird while entering the traffic pattern.
- [NTSB ERA22LA304](https://openairdocs.org/ntsb/ERA22LA304.md): Arion Lightning · Indiana, PA · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 10, 2022 · N326AL · Substantial damage
  > The airplane pilot’s inadvertent encounter with rotor wash/turbulence during short final approach, which resulted in a loss of control in flight.
- [NTSB ERA22LA289](https://openairdocs.org/ntsb/ERA22LA289.md): Luscombe 8A · Palmyra, PA · Accident · No injuries · Class 4 · Limited · Final report · Jun 25, 2022 · N1476K · Substantial damage
  > The pilot’s failure to maintain a proper glide path to the runway.
- [NTSB ERA22LA254](https://openairdocs.org/ntsb/ERA22LA254.md): Cirrus Design SR22 · Tredyffin, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 1, 2022 · N432CP · Substantial damage
  > The loosening of the throttle arm from the throttle body, which resulted in the pilot’s inability to control the engine, and a subsequent forced landing.
- [NTSB ERA21LA025](https://openairdocs.org/ntsb/ERA21LA025.md): Aero Bristell Bristell LSA · Carlisle, PA · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 18, 2020 · N438BL · Substantial damage
  > The pilot’s failure to maintain adequate clearance from trees during an attempted go-around in gusty crosswinds.
- [NTSB ERA20CA135](https://openairdocs.org/ntsb/ERA20CA135.md): AugustaWestland AW119MKII · Philadelphia, PA · Accident · No injuries · Data collection · Final report · Mar 21, 2020 · N982SS · Substantial damage
  > The in-flight failure of the lower left side of the engine cowling due to the mechanic’s improper installation of the fasteners, which resulted in the cowling impacting all four main rotor blades.
- [NTSB ERA20CA120](https://openairdocs.org/ntsb/ERA20CA120.md): Learjet 35 · Altoona, PA · Accident · No injuries · Data collection · Final report · Feb 29, 2020 · N721EC · Substantial damage
  > The pilot flying's improper lateral bank control during a go-around in gusting wind conditions, which resulted in the left-wing tip tank striking the runway.
- [NTSB DCA20CA040](https://openairdocs.org/ntsb/DCA20CA040.md): Embraer EMB145 · Philadelphia, PA · Accident · Serious injuries · Class 4 · Data collection · Final report · Dec 15, 2019 · N648AE · No damage
  > An inadvertent encounter with convective turbulence.
- [NTSB GAA20CA090](https://openairdocs.org/ntsb/GAA20CA090.md): Luscombe 8 · Brogue, PA · Accident · Minor injuries · Data collection · Final report · Nov 19, 2019 · N71707 · Substantial damage
  > The pilot's failure to see and avoid wires during approach to landing.
- [NTSB GAA20CA057](https://openairdocs.org/ntsb/GAA20CA057.md): Cub Crafters CC11 · Palmyra, PA · Accident · No injuries · Data collection · Final report · Nov 2, 2019 · N718CC · Substantial damage
  > The pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain lateral control during a go-around, which resulted in impact with a tree.
- [NTSB ERA20LA011](https://openairdocs.org/ntsb/ERA20LA011.md): Piper PA46 · Harrisburg, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 4, 2019 · N4385K · Substantial damage
  > A total loss of engine power for reasons that could not be determined following a successful engine run.
- [NTSB ERA20LA052](https://openairdocs.org/ntsb/ERA20LA052.md): Beech 55 · Grove City, PA · Accident · No injuries · Class 3 · Limited · Final report · Oct 1, 2019 · N9404Q · Substantial damage
  > The pilot’s mismanagement of the airplane’s available fuel, which resulted in a partial loss of engine power to the left engine, and his subsequent failure to maintain directional control of the airplane while on final approach to the runway.
- [NTSB ERA19LA085](https://openairdocs.org/ntsb/ERA19LA085.md): Piper PA24 · Wilkes-Barre, PA · Accident · No injuries · Limited investigation · Final report · Jan 3, 2019 · N6872P · Substantial damage
  > The pilot/mechanic's improper installation and securing of the mixture control cable, which led to a simultaneous loss of total engine power and failure of the nose landing gear to fully extend when the cable caught on the nose landing gear assembly.
- [NTSB ERA19LA061](https://openairdocs.org/ntsb/ERA19LA061.md): Cessna P210 · Myerstown, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Dec 8, 2018 · N731LT · Substantial damage
  > A total loss of engine power due to fuel starvation.
- [NTSB ERA19LA024](https://openairdocs.org/ntsb/ERA19LA024.md): Beech 35 · State College, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 2018 · N8319D · Substantial damage
  > The pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB DCA18IA265](https://openairdocs.org/ntsb/DCA18IA265.md): Gulfstream G IV · Philadelphia, PA · Incident · No injuries · Class 3 · Incident · Final report · Aug 11, 2018 · N619A · No damage
  > The flight crew’s misalignment of the airplane with a taxiway instead of the assigned runway, resulting in a low-altitude go-around late in the final approach and reduced separation with the airplanes on the taxiway.
- [NTSB ERA18LA192](https://openairdocs.org/ntsb/ERA18LA192.md): Schweizer 269D · Stewartstown, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 14, 2018 · N411HU · Substantial damage
  > The pilot's inability to maintain yaw control while transitioning to an out of ground effect hover due to a loss of tail rotor effectiveness.
- [NTSB CEN18FA144](https://openairdocs.org/ntsb/CEN18FA144.md): Cirrus Design SR22 · Williamsburg, PA · Accident · 2 fatal · Field investigation · Final report · Apr 19, 2018 · N451TD · Destroyed
  > The pilot's failure to obtain an updated weather briefing before the flight and his subsequent loss of airplane control due to spatial disorientation while maneuvering in instrument meteorological conditions during a diversion to an alternate airport after…
- [NTSB ERA18LA032](https://openairdocs.org/ntsb/ERA18LA032.md): Piper PA 34-220T · Ebensburg, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 2017 · N263DM · Substantial damage
  > The pilot's improper decision to fly an airplane with a known oil leak, which led to a total loss of engine power due to oil starvation. Contributing to the accident was the pilot's decision to land with a tailwind, which led to his attempted go-around and…
- [NTSB ERA17FA153](https://openairdocs.org/ntsb/ERA17FA153.md): Howard DGA 15P · Monongahela, PA · Accident · 1 fatal · Field investigation · Final report · Apr 12, 2017 · N4476N · Destroyed
  > The pilot's failure to maintain airplane control during an attempted go-around in gusting crosswind conditions, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.
- [NTSB ERA16LA285](https://openairdocs.org/ntsb/ERA16LA285.md): Shaffer Donald Arion Lightning · Toughkenamon, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 2016 · N270J · Substantial damage
  > A total loss of engine power for reasons that could not be determined because examination of the engine did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA16FA215](https://openairdocs.org/ntsb/ERA16FA215.md): Piper PA31 · State College, PA · Accident · 2 fatal · Field investigation · Final report · Jun 16, 2016 · N3591P · Destroyed
  > The pilot's decision to continue an unstabilized instrument approach in instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB ERA16LA200](https://openairdocs.org/ntsb/ERA16LA200.md): Aeronca 7AC · Toughkenamon, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 1, 2016 · N83547 · Substantial damage
  > The student pilot’s inadvertent actuation of the fuel shutoff valve, which led to a total loss of engine power, forced landing, and impact with a hangar. Contributing to the outcome was maintenance personnel’s inadequate inspection of the fuel shutoff system…
- [NTSB DCA16CA153](https://openairdocs.org/ntsb/DCA16CA153.md): Airbus Industrie A320 214 · Philadelphia, PA · Accident · Serious injuries · Data collection · Final report · May 14, 2016 · N103US · No damage
  > an inadvertent encounter with clear air turbulence that resulted in a serious injury to a flight attendant.
- [NTSB ERA16FA064](https://openairdocs.org/ntsb/ERA16FA064.md): Beech A36 · Farmington, PA · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2015 · N72054 · Destroyed
  > The pilot's failure to maintain control of the airplane after a cabin door came open in flight, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's misuse of…
- [NTSB ERA16FA063](https://openairdocs.org/ntsb/ERA16FA063.md): Timothy C Williams CCK-1865 · Linesville, PA · Accident · 2 fatal · Field investigation · Final report · Dec 7, 2015 · N541TC · Substantial damage
  > The noninstrument-rated pilot's improper decision to attempt a flight under visual flight rules at night in instrument meteorological conditions to an unlit airstrip, which resulted in controlled flight into terrain.
- [NTSB ERA16LA010](https://openairdocs.org/ntsb/ERA16LA010.md): Murray Blair L Free Bird Classic · Kylertown, PA · Accident · 1 fatal · Limited investigation · Final report · Oct 12, 2015 · N176FB · Destroyed
  > The pilot's failure to maintain sufficient airspeed during approach for landing, which resulted in an inadvertent aerodynamic stall/spin. Contributing to the accident was the pilot’s lack of flight experience in the accident airplane make and model.
- [NTSB ERA15FA298](https://openairdocs.org/ntsb/ERA15FA298.md): Mchugh Tony Kitfox Model 1 · Montrose, PA · Accident · 1 fatal · Field investigation · Final report · Aug 7, 2015 · N428YT · Substantial damage
  > The pilot's failure to maintain control of the airplane during final approach, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall.
- [NTSB ERA15LA276](https://openairdocs.org/ntsb/ERA15LA276.md): Grumman American Avn. AA1B · Lititz, PA · Accident · No injuries · Limited investigation · Final report · Jul 19, 2015 · N8969L · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the engine found no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB GAA15CA099](https://openairdocs.org/ntsb/GAA15CA099.md): Cessna 172 - R · State College, PA · Accident · No injuries · Data collection · Final report · May 28, 2015 · N2254U · Substantial damage
  > The student pilot's failure to maintain adequate airspeed during the approach to landing which resulted in an aerodynamic stall and a hard landing.
- [NTSB ERA14LA358](https://openairdocs.org/ntsb/ERA14LA358.md): Winder Robert S VP1 · Grove City, PA · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 2014 · N3831W · Substantial damage
  > A collision with terrain during the landing approach for reasons that could not be determined based on available information.
- [NTSB ERA14CA171](https://openairdocs.org/ntsb/ERA14CA171.md): Cessna 172 · Carlisle, PA · Accident · Serious injuries · Data collection · Final report · Mar 24, 2014 · N4214F · Substantial damage
  > The pilot's decision to depart with a known mechanical malfunction and his improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion and subsequent impact with terrain during an off-airport landing.
- [NTSB ERA14FA153](https://openairdocs.org/ntsb/ERA14FA153.md): Waters Peter T Avid Bandit · Washington, PA · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2014 · N62PT · Destroyed
  > The pilot’s failure to maintain airspeed and angle of attack, which resulted in an aerodynamic stall and loss of aircraft control in gusty and turbulent wind conditions.
- [NTSB ERA13FA402](https://openairdocs.org/ntsb/ERA13FA402.md): Cessna T-50 · Lenox Twp., PA · Accident · 2 fatal · Field investigation · Final report · Sep 3, 2013 · N41759 · Destroyed
  > The pilot's intentional visual flight into night instrument meteorological conditions and thunderstorms and his improper decision to takeoff without getting updated weather information after a briefer cautioned him during a previous flight that visual flight…
- [NTSB ERA12CA418](https://openairdocs.org/ntsb/ERA12CA418.md): Grumman American Avn. AA-1C · West Chester, PA · Accident · Minor injuries · Data collection · Final report · Jun 27, 2012 · N9675U · Substantial damage
  > The pilot’s failure to maintain directional control during an attempted go-around, which resulted in a runway excursion.
- [NTSB ERA12CA389](https://openairdocs.org/ntsb/ERA12CA389.md): Buckeye Breeze · Lower Burrell, PA · Accident · Serious injuries · Data collection · Final report · Jun 10, 2012 · N786DS · Substantial damage
  > The pilot’s failure to maintain directional control of the powered parachute, which resulted in a collision with trees during final approach. Contributing to the accident was the pilot's lack of flight training.
- [NTSB ERA12CA357](https://openairdocs.org/ntsb/ERA12CA357.md): Hughes TH-55 · Pittsfield, PA · Accident · No injuries · Data collection · Final report · May 19, 2012 · N74914 · Substantial damage
  > The student pilot's failure to maintain helicopter control during an encounter with loss of tail rotor effectiveness.
- [NTSB ERA12LA246](https://openairdocs.org/ntsb/ERA12LA246.md): Diamond Aircraft Ind DA 20-C1 · Beaver Falls, PA · Accident · Serious injuries · Limited investigation · Final report · Mar 23, 2012 · N166SE · Substantial damage
  > The operator’s maintenance personnel’s improper adjustment of the engine's fuel system, which resulted in a total loss of engine power.
- [NTSB ERA12CA248](https://openairdocs.org/ntsb/ERA12CA248.md): JDT MiniMax · Gap, PA · Accident · No injuries · Data collection · Final report · Mar 21, 2012 · UNREG · Substantial damage
  > The student pilot's failure to maintain airspeed during a go-around, resulting in an aerodynamic stall.
- [NTSB ERA12FA163](https://openairdocs.org/ntsb/ERA12FA163.md): Piper PA-28-180 · Thomasville, PA · Accident · 1 fatal · Field investigation · Final report · Jan 29, 2012 · N1352T · Substantial damage
  > The pilot's failure to maintain airspeed during an approach in gusty crosswind conditions, which resulted in an inadvertent aerodynamic stall.
- [NTSB ERA12FA120](https://openairdocs.org/ntsb/ERA12FA120.md): Cessna 441 · Nashville, PA · Accident · 1 fatal · Field investigation · Final report · Dec 22, 2011 · N48BS · Substantial damage
  > The pilot's failure to maintain minimum control airspeed after a loss of power to the right engine, which resulted in an uncontrollable roll into an inadvertent stall/spin. Contributing to the accident was the failure of the airplane's right engine for…
- [NTSB ERA12CA053](https://openairdocs.org/ntsb/ERA12CA053.md): Cessna 172F · Smoketown, PA · Accident · Serious injuries · Data collection · Final report · Oct 28, 2011 · N5613R · Substantial damage
  > The pilot did not maintain a proper approach path, which resulted in a collision with a tree.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?state=PA&page=2

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
  crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
  current_codes AS (
    SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code,
      row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n
    FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
    WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*'
      AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982"))
  ),
  phases AS (
    SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
    FROM current_codes WHERE n = 1
    UNION ALL
    SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main
    FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode"
    WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
  ),
  case_phases AS (
    SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code
    FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey
    LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
    WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
  )
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 case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?state=PA

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.