# NTSB investigations, PA: Enroute

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 17 · 824 cases

## Latest cases

- [NTSB ERA25LA204](https://openairdocs.org/ntsb/ERA25LA204.md): Eurocopter Deutschland MBB-BK 117 C-1 · Fort Washington, PA · Accident · Minor injuries · Class 3 · Limited · Final report · May 19, 2025 · N117NC · Substantial damage
  > Maintenance personnel’s failure to identify and replace damaged rivet nuts at the air conditioning louver assembly, which resulted in the separation of the louver assembly from the helicopter, the louver assembly’s impact with the tail rotor, and subsequent…
- [NTSB ERA24LA081](https://openairdocs.org/ntsb/ERA24LA081.md): Piper PA32 · Gordonville, PA · Accident · No injuries · Class 4 · Limited · Final report · Jan 1, 2024 · N722RM · Substantial damage
  > The pilot’s improper fuel management resulting in fuel starvation, a total loss of engine power, and subsequent off-airport forced landing.
- [NTSB ERA24FA077](https://openairdocs.org/ntsb/ERA24FA077.md): Zenith Stol CH701 · Marienville, PA · Accident · 1 fatal · Class 3 · Field · Final report · Dec 30, 2023 · N4209W · Destroyed
  > The pilot’s decision to continue visual flight into deteriorating visibility conditions at night, which resulted in spatial disorientation and subsequent descent that continued to ground contact.
- [NTSB ERA23FA252](https://openairdocs.org/ntsb/ERA23FA252.md): Cessna 180 · Harrisburg, PA · Accident · 1 fatal · Class 3 · Field · Final report · May 31, 2023 · N3178D · Substantial damage
  > The pilot’s inadequate preflight fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent collision with terrain and objects.
- [NTSB ERA23FA045](https://openairdocs.org/ntsb/ERA23FA045.md): Bearhawk Patrol · Hanover Township, PA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 29, 2022 · N964RS · Substantial damage
  > The pilot’s decision to unlatch his seatbelt during flight, which allowed him to exit the airplane and impact the tail, resulting in a loss of control and impact with terrain.
- [NTSB ERA23LA034](https://openairdocs.org/ntsb/ERA23LA034.md): Cessna A185E · York, PA · Accident · No injuries · Class 3 · Limited · Final report · Oct 22, 2022 · N36ZN · Substantial damage
  > Oil starvation of the number 1 connecting rod bearings, which resulted in a total loss of engine power.
- [NTSB ERA22LA347](https://openairdocs.org/ntsb/ERA22LA347.md): Bell 206L-3 · Franklin, PA · Accident · No injuries · Class 4 · Limited · Final report · Jul 19, 2022 · N203PA · Substantial damage
  > The pilot’s inadequate visual lookout while flying at a low level over a river, which resulted in a wire strike.
- [NTSB ERA22LA237](https://openairdocs.org/ntsb/ERA22LA237.md): Diamond DA42 · Lehighton, PA · Accident · Minor injuries · Class 3 · Limited · Final report · May 9, 2022 · N988JA · Substantial damage
  > The flight instructor’s inadequate supervision of the flight and his failure to secure the right engine following an unsuccessful engine restart attempt, which resulted in the airplane’s inability to maintain altitude and a subsequent off-airport landing.
- [NTSB ERA22FA105](https://openairdocs.org/ntsb/ERA22FA105.md): Eurocopter Deutschland EC135 P2+ · Drexel Hill, PA · Accident · Serious injuries · Class 3 · Field · Final report · Jan 11, 2022 · N531LN · Substantial damage
  > An 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 ERA22FA076](https://openairdocs.org/ntsb/ERA22FA076.md): Cessna T210R · Grove City, PA · Accident · 2 fatal · Class 3 · Field · Final report · Nov 24, 2021 · N6209U · Destroyed
  > A catastrophic engine failure due to oil starvation after the pilot’s failure to secure the oil filler cap before flight. Contributing to the accident was the pilots’ decision to continue the flight following the oil loss event and precautionary landing.
- [NTSB ERA22LA060](https://openairdocs.org/ntsb/ERA22LA060.md): Cessna 150 · Wilkes-Barre, PA · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 14, 2021 · N6714S · Substantial damage
  > The pilot’s decision to commence the flight in marginal visual flight rules conditions at night, and his failure to maintain a safe altitude once instrument conditions were encountered.
- [NTSB ERA22LA028](https://openairdocs.org/ntsb/ERA22LA028.md): Piper PA-24-250 · Sligo, PA · Accident · No injuries · Class 4 · Limited · Final report · Oct 23, 2021 · N7371P · Substantial damage
  > A total loss of engine power due to fuel exhaustion as a result of the pilots mismanagement of fuel.
- [NTSB ERA21LA391](https://openairdocs.org/ntsb/ERA21LA391.md): Boeing E75 · Nicholson, PA · Accident · No injuries · Class 3 · Limited · Final report · Sep 30, 2021 · N1654M · Substantial damage
  > A total loss of engine power as a result of damaged internal carburetor mixture control components.
- [NTSB ERA21FA253](https://openairdocs.org/ntsb/ERA21FA253.md): Vans RV6 · Buckingham, PA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 15, 2021 · N74MS · Substantial damage
  > An exhaust system leak that resulted in failure of the oil quick drain, a loss of oil lubrication, an in-flight fire, and the pilot’s subsequent loss of airplane control.
- [NTSB ERA21LA191](https://openairdocs.org/ntsb/ERA21LA191.md): Robinson Helicopter R44 · Forkston, PA · Accident · 1 fatal · Class 3 · Limited · Final report · Apr 23, 2021 · N4055N · Destroyed
  > The pilot’s inadequate preflight weather planning, which resulted in an inadvertent encounter with instrument meteorological conditions at night, spatial disorientation, and collision with terrain.
- [NTSB ERA20LA322](https://openairdocs.org/ntsb/ERA20LA322.md): Piper PA28R · Moosic, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 21, 2020 · N3790T · Substantial damage
  > The inadequate torquing of anchored-thru and free-thru studs during installation of the No. 2 cylinder, resulting in their fatigue fracture and subsequent total loss of engine power. Contributing to the undershoot landing was the pilot’s failure to divert to…
- [NTSB ERA20LA320](https://openairdocs.org/ntsb/ERA20LA320.md): Stinson 108 · Newport, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 17, 2020 · N336C · Substantial damage
  > A total loss of engine power during cruise flight due to a disconnected carburetor mixture control cable which allowed the carburetor mixture lever to migrate to the cut-off position during flight.
- [NTSB ERA20LA258](https://openairdocs.org/ntsb/ERA20LA258.md): Cessna 182 · Pottstown, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 21, 2020 · N4092D · Substantial damage
  > The pilot's failure to ensure that sufficient fuel was onboard for nonlevel flight, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA20FA074](https://openairdocs.org/ntsb/ERA20FA074.md): Robinson R66 · Mechanicsburg, PA · Accident · 2 fatal · Class 3 · Field · Final report · Jan 10, 2020 · N450MC · Destroyed
  > A severe left roll excursion after the onset of pitch and roll oscillations, which were not arrested by the pilot for undetermined reasons. This resulted in main rotor blade contact with the airframe and a subsequent inflight breakup of the helicopter.
- [NTSB ERA19LA252](https://openairdocs.org/ntsb/ERA19LA252.md): Piper PA 31P · East Brady, PA · Accident · No injuries · Class 3 · Limited · Final report · Aug 20, 2019 · N90AP · Substantial damage
  > A total loss of left engine power for undetermined reasons.
- [NTSB ERA19FA240](https://openairdocs.org/ntsb/ERA19FA240.md): Beech F33 · Hatboro, PA · Accident · 3 fatal · Class 3 · Field · Final report · Aug 8, 2019 · N4082S · Destroyed
  > The pilot's loss of airplane control due to spatial disorientation during the departure climb after entering instrument meteorological conditions.
- [NTSB ERA19FA161](https://openairdocs.org/ntsb/ERA19FA161.md): Cessna 172 · Tyrone, PA · Accident · 2 fatal · Class 3 · Field · Final report · May 1, 2019 · N733KZ · Substantial damage
  > The pilot’s continued visual flight rules flight into instrument meteorological conditions, resulting in controlled flight into trees and terrain.
- [NTSB ERA19LA063](https://openairdocs.org/ntsb/ERA19LA063.md): Lancair LC41 · Moscow, PA · Accident · No injuries · Class 3 · Limited · Final report · Dec 4, 2018 · N618G · Substantial damage
  > A total loss of engine power and catastrophic engine failure due to the failure of the left turbocharger, which resulted in oil loss and oil starvation. Contributing to the accident was the failure of maintenance personnel to overhaul the turbocharger in…
- [NTSB GAA19CA015](https://openairdocs.org/ntsb/GAA19CA015.md): Titan Titan Tornado 912 · Corry, PA · Accident · No injuries · Data collection · Final report · Oct 7, 2018 · N912R · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.
- [NTSB ERA18LA243](https://openairdocs.org/ntsb/ERA18LA243.md): Piper PA12 · Cochranton, PA · Accident · No injuries · Class 3 · Limited · Final report · Sep 1, 2018 · N3415M · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA18LA163](https://openairdocs.org/ntsb/ERA18LA163.md): Vans RV4 · Butler, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 2018 · N7765X · Substantial damage
  > The pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.
- [NTSB DCA18MA142](https://openairdocs.org/ntsb/DCA18MA142.md): Boeing 737 7H4 · Philadelphia, PA · Accident · 1 fatal · Class 1 · Major · Final report · Apr 17, 2018 · N772SW · Substantial damage
  > A low-cycle fatigue crack in the dovetail of fan blade No. 13, which resulted in the fan blade separating in flight and impacting the engine fan case at a location that was critical to the structural integrity and performance of the fan cowl structure. This…
- [NTSB ERA18LA072](https://openairdocs.org/ntsb/ERA18LA072.md): Cessna P210N · Farmington, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 29, 2018 · N34VF · Substantial damage
  > A total loss of engine power due to fatigue failure of the crankshaft drive gear teeth.
- [NTSB ERA17LA285](https://openairdocs.org/ntsb/ERA17LA285.md): Bell 47G · St Marys, PA · Accident · No injuries · Limited investigation · Final report · Aug 20, 2017 · N9526 · Substantial damage
  > The student pilot's inadequate prefight planning and en route fuel management, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA17LA185](https://openairdocs.org/ntsb/ERA17LA185.md): Cessna 182 · West Chester, PA · Accident · No injuries · Limited investigation · Final report · May 21, 2017 · N378ES · Substantial damage
  > An engine crankcase overpressurization and the subsequent loss of engine oil for reasons that could not be determined, which resulted in the failure of the No. 6 cylinder connecting rod due to a lack of lubrication.
- [NTSB GAA17CA196](https://openairdocs.org/ntsb/GAA17CA196.md): Schweizer SGS126 · Bangor, PA · Accident · No injuries · Data collection · Final report · Mar 11, 2017 · N17933 · Substantial damage
  > The glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in an off-airport landing.
- [NTSB ERA17LA098](https://openairdocs.org/ntsb/ERA17LA098.md): Cessna P210 · Pottsville, PA · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 2017 · N4796P · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examinations of the engine and airframe did not reveal any preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ERA17FA017](https://openairdocs.org/ntsb/ERA17FA017.md): Piper PA28 · Austin, PA · Accident · 3 fatal · Field investigation · Final report · Oct 16, 2016 · C-GYSN · Destroyed
  > The pilot's loss of control while maneuvering in night instrument conditions that included light-to-heavy rain with severe turbulence, updrafts and downdrafts, and hail. Contributing to the accident was the pilot experiencing spatial disorientation, his lack…
- [NTSB ERA17LA016](https://openairdocs.org/ntsb/ERA17LA016.md): Hatcher Roderick R CH701 · Albrightsville, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 15, 2016 · N3701M · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination revealed no anomalies that would have precluded normal operation.
- [NTSB ERA16LA265](https://openairdocs.org/ntsb/ERA16LA265.md): Eurocopter Deutschland MBB BK 117 C-2 · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Apr 26, 2016 · N145HN · Substantial damage
  > Maintenance personnel’s failure to properly secure the left vertical fin cowling during recent maintenance, which resulted in its separation and subsequent contact with the tail rotor system during flight.
- [NTSB ERA16LA166](https://openairdocs.org/ntsb/ERA16LA166.md): Champion 7ECA · Tannersville, PA · Accident · No injuries · Limited investigation · Final report · Apr 19, 2016 · N5094X · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA16FA143](https://openairdocs.org/ntsb/ERA16FA143.md): Robinson R44 · Canadensis, PA · Accident · 1 fatal · Field investigation · Final report · Mar 27, 2016 · N776JM · Destroyed
  > The pilot's loss of control due to spatial disorientation, which occurred after ascending in order to clear rising terrain and inadvertently entering the clouds.
- [NTSB ERA16CA105](https://openairdocs.org/ntsb/ERA16CA105.md): Piper PA34 · Williamsport, PA · Accident · No injuries · Data collection · Final report · Feb 9, 2016 · N234NC · Substantial damage
  > The pilot's failure to maintain altitude in cruise flight due to his diverted attention, which resulted in controlled flight into terrain.
- [NTSB DCA16CA023](https://openairdocs.org/ntsb/DCA16CA023.md): Airbus Industrie A319 112 · Philadelphia, PA · Accident · Serious injuries · Data collection · Final report · Nov 23, 2015 · N725UW · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB ERA15LA294](https://openairdocs.org/ntsb/ERA15LA294.md): Commander 114 · Reading, PA · Accident · No injuries · Limited investigation · Final report · Aug 1, 2015 · N6566D · Substantial damage
  > The improper installation of the fuel supply line fitting at the fuel manifold, which resulted in the line loosening in-flight, fuel leakage, and a subsequent total loss of engine power.
- [NTSB ERA14LA402](https://openairdocs.org/ntsb/ERA14LA402.md): Thibault Michael L RV4 · Polk Township, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 2014 · N62632 · Substantial damage
  > A total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.
- [NTSB ERA14FA077](https://openairdocs.org/ntsb/ERA14FA077.md): Piper PA-30 · Biglerville, PA · Accident · 2 fatal · Field investigation · Final report · Dec 26, 2013 · N8372Y · Destroyed
  > The noninstrument-rated pilot's spatial disorientation after inadvertently encountering instrument meteorological conditions at night and his subsequent loss of airplane control.
- [NTSB ERA14LA051](https://openairdocs.org/ntsb/ERA14LA051.md): Cessna 210L · Montrose, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 2013 · N777BK · Substantial damage
  > The pilot’s failure to check the fuel tanks for contaminants after fueling, which resulted in a total loss of engine power due to water contamination.
- [NTSB DCA14CA031](https://openairdocs.org/ntsb/DCA14CA031.md): De Havilland DHC8 - 102 · Philadelphia, PA · Accident · No injuries · Data collection · Final report · Nov 25, 2013 · N808EX · Substantial damage
  > an inadvertent encounter with several birds during approach that resulted in substantial damage to the airplane.
- [NTSB ERA13FA336](https://openairdocs.org/ntsb/ERA13FA336.md): Robinson R66 · Noxen, PA · Accident · 5 fatal · Field investigation · Final report · Jul 28, 2013 · N646AG · Destroyed
  > The pilot's decision to continue VFR flight into night instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.
- [NTSB ERA13LA268](https://openairdocs.org/ntsb/ERA13LA268.md): Maule M-4-220C · Fredericksburg, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 2013 · N40337 · Substantial damage
  > A total loss of engine power due to the fatigue failure of the No. 4 cylinder piston pin.
- [NTSB ERA13LA097](https://openairdocs.org/ntsb/ERA13LA097.md): Piper PA-28R-200 · Lock Haven, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2012 · N2074T · Substantial damage
  > The reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…
- [NTSB ERA13FA014](https://openairdocs.org/ntsb/ERA13FA014.md): Bell 407 · Coolbaugh Township, PA · Accident · 2 fatal · Field investigation · Final report · Oct 10, 2012 · N108MF · Substantial damage
  > The pilot’s decision to continue visual flight rules flight into instrument meteorological conditions due to self-imposed pressure to complete the trip, which resulted in impact with trees and terrain.
- [NTSB ERA13CA011](https://openairdocs.org/ntsb/ERA13CA011.md): Piper PA-28-140 · Beltzville, PA · Accident · No injuries · Data collection · Final report · Oct 6, 2012 · N44595 · Substantial damage
  > The flight instructor’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB ERA12LA539](https://openairdocs.org/ntsb/ERA12LA539.md): Cessna 172M · Canadensis, PA · Accident · No injuries · Limited investigation · Final report · Aug 31, 2012 · N391R · Substantial damage
  > The pilot’s failure to attain a proper glidepath.

Next page: https://openairdocs.org/ntsb-phases/400/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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/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.