# NTSB investigations, PA: Takeoff

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 7 · 303 cases

## Latest cases

- [NTSB ERA27LA006](https://openairdocs.org/ntsb/ERA27LA006.md): Cessna 525 · Bedford, PA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Oct 7, 2026 · N600AL · Substantial damage
  > On 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 ERA26LA187](https://openairdocs.org/ntsb/ERA26LA187.md): Cessna 172 · Quakertown, PA · Accident · No injuries · Class 4 · Limited · Final report · Apr 24, 2026 · N99467 · Substantial damage
  > The pilot receiving instruction’s failure to maintain aircraft directional control during the takeoff roll. Contributing was the flight crew’s failure to ensure a positive exchange of flight controls during the takeoff roll.
- [NTSB ERA26LA122](https://openairdocs.org/ntsb/ERA26LA122.md): Hughes 269A · Gettysburg, PA · Accident · Minor injuries · Class 4 · Limited · Final report · Feb 21, 2026 · N1020S · Substantial damage
  > The flight instructor’s failure to identify the excess power required to lift off from soft and muddy ground, which resulted in a loss of control and subsequent collision with a hangar during takeoff.
- [NTSB ERA25LA137](https://openairdocs.org/ntsb/ERA25LA137.md): Beech A36TC · Lititz, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 9, 2025 · N347M · Destroyed
  > The pilot’s failure to maintain adequate airspeed after takeoff due to his distraction by the opening of the cabin door, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall/mush condition at too low of an…
- [NTSB ERA25MA106](https://openairdocs.org/ntsb/ERA25MA106.md): Learjet 55 · Philadelphia, PA · Accident · 7 fatal · Class 2 · Major · Preliminary report · Jan 31, 2025 · XA-UCI · Destroyed
  > On 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 ERA24LA316](https://openairdocs.org/ntsb/ERA24LA316.md): Sheaffer Leroy B Kitfox Model IV · Palmyra, PA · Accident · 1 fatal · Class 3 · Limited · Final report · Jul 19, 2024 · N788KF · Substantial damage
  > The pilot’s failure to maintain directional control of the tailwheel airplane during takeoff from a narrow runway with a crosswind, which resulted in a runway excursion and collision with terrain.
- [NTSB ERA24LA302](https://openairdocs.org/ntsb/ERA24LA302.md): Piper PA-32RT-300T · Myerstown, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 4, 2024 · N184VA · Substantial damage
  > The failure of maintenance personnel to properly secure a B-nut on the No. 5 cylinder fuel injector line, resulting in a fuel leak and engine fire.
- [NTSB ERA23LA381](https://openairdocs.org/ntsb/ERA23LA381.md): Boeing B75 · Erwinna, PA · Accident · No injuries · Class 4 · Limited · Final report · Sep 19, 2023 · N46Y · Substantial damage
  > The pilot’s failure to maintain control of the airplane while taking off in a crosswind.
- [NTSB ERA23LA193](https://openairdocs.org/ntsb/ERA23LA193.md): Piper PA-28-181 · West Mifflin, PA · Accident · No injuries · Class 4 · Limited · Final report · Apr 10, 2023 · N476TA · Substantial damage
  > The student pilot’s decision to abort the takeoff and land on the runway without sufficient runway remaining, which resulted in a runway overrun.
- [NTSB ERA23LA030](https://openairdocs.org/ntsb/ERA23LA030.md): Cessna 182 · Factoryville, PA · Accident · No injuries · Class 4 · Limited · Final report · Oct 21, 2022 · N658CP · Substantial damage
  > The pilot's failure to maintain directional control while practicing a soft-field takeoff maneuver, which resulted in a runway excursion and impact with a hangar.
- [NTSB ERA22LA364](https://openairdocs.org/ntsb/ERA22LA364.md): Aerotek Pitts Special S-1S · Erwinna, PA · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 6, 2022 · N49310 · 2 aircraft · Substantial damage
  > The inability of both pilots to see and avoid the collision. Contributing to the accident was the pilot of the red airplane’s decision to utilize the converging runway for takeoff, contrary to the guidance published in the airport facility directory. Also…
- [NTSB ERA22LA269](https://openairdocs.org/ntsb/ERA22LA269.md): Walter S Johnson III AR-1 · Butler, PA · Accident · No injuries · Class 4 · Limited · Final report · Jun 11, 2022 · N688G · Substantial damage
  > The pilot’s failure to monitor rotor disk speed on takeoff, which resulted in blade flapping and the main rotor blades striking the gyroplane’s tail assembly.
- [NTSB ERA22LA215](https://openairdocs.org/ntsb/ERA22LA215.md): Cessna 414 · Connellsville, PA · Accident · Serious injuries · Class 3 · Limited · Final report · May 2, 2022 · N46TA · Substantial damage
  > The pilot/mechanic’s failure to properly secure two airplane avionics units, which resulted in the trays supporting the units to sag downward and become lodged in the movement area of the elevator bellcrank during the accident takeoff.
- [NTSB ERA21LA396](https://openairdocs.org/ntsb/ERA21LA396.md): Sonex Waiex · Doylestown, PA · Accident · No injuries · Class 4 · Limited · Final report · Mar 22, 2021 · N220JD · Substantial damage
  > The pilot’s failure to maintain a proper glidepath during landing. Contributing to the accident was his failure to ensure the canopy locks were properly configured prior to flight.
- [NTSB ERA21LA161](https://openairdocs.org/ntsb/ERA21LA161.md): Piper PA-28-180 · West Chester, PA · Accident · No injuries · Class 4 · Limited · Final report · Mar 21, 2021 · N24JN · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with airport lights and a hangar.
- [NTSB ERA21LA049](https://openairdocs.org/ntsb/ERA21LA049.md): Piper PA28 · Lititz, PA · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 20, 2020 · N9086W · Substantial damage
  > The pilot’s inadvertent attempt to takeoff on a taxiway, rather than a runway, which resulted in a collision with a fence during takeoff.
- [NTSB ERA20LA274](https://openairdocs.org/ntsb/ERA20LA274.md): Piper PA32RT · Honesdale, PA · Accident · No injuries · Class 3 · Limited · Final report · Aug 1, 2020 · N3025L · Substantial damage
  > The pilot’s premature rotation for takeoff, which resulted in a tail strike and subsequent runway excursion. Contributing to the accident was the pilot’s inadequate preflight planning, which failed to accurately determine and account for the effects of…
- [NTSB GAA19CA491](https://openairdocs.org/ntsb/GAA19CA491.md): Consolidated Vultee BT13 · Franklin, PA · Accident · No injuries · Data collection · Final report · Aug 10, 2019 · N62644 · Substantial damage
  > The pilot's failure to maintain directional control during takeoff in gusting crosswind conditions, which resulted in a runway excursion and the left main landing gear collapsing.
- [NTSB GAA19CA361](https://openairdocs.org/ntsb/GAA19CA361.md): Quicksilver Aircraft Northeast Sport · Ledgedale, PA · Accident · Minor injuries · Data collection · Final report · Jun 17, 2019 · N418RB · Substantial damage
  > The pilot's selection of unsuitable terrain for takeoff, which resulted a nose-over. Contributing to the accident was the pilot's improper in-flight fuel management, which resulted in the precautionary landing on unsuitable terrain.
- [NTSB GAA19CA266](https://openairdocs.org/ntsb/GAA19CA266.md): Ryan John Steffey Subsonex · Latrobe, PA · Accident · No injuries · Data collection · Final report · May 14, 2019 · N224P · Substantial damage
  > The pilot's failure to maintain pitch control while attempting to secure the canopy, which opened shortly after takeoff and resulted in the airplane impacting the ground and the main landing gear collapsing. Contributing to the accident was the pilot's…
- [NTSB ERA19CA148](https://openairdocs.org/ntsb/ERA19CA148.md): Cessna 152 · Lancaster, PA · Accident · Minor injuries · Data collection · Final report · Apr 8, 2019 · N68727 · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with a runway marker.
- [NTSB GAA19CA051](https://openairdocs.org/ntsb/GAA19CA051.md): RIchard Silva Seawind · Pocono Summit, PA · Accident · No injuries · Data collection · Final report · Oct 12, 2018 · N46SW · Substantial damage
  > The pilot's improper decision to attempt to take off from a lake in high crosswind conditions, which resulted in the right wing lifting, the left wing impacting the water, and the airplane bouncing and then impacting the water hard.
- [NTSB GAA18CA083](https://openairdocs.org/ntsb/GAA18CA083.md): Michael Adamczyk Zenith CH750 · Franklin, PA · Accident · No injuries · Data collection · Final report · Dec 9, 2017 · N750AD · Substantial damage
  > The pilot’s excessive application of aft stick during takeoff, which resulted in an aerodynamic stall. Contributing to this accident was the pilot’s inexperience in the airplane.
- [NTSB GAA17CA552](https://openairdocs.org/ntsb/GAA17CA552.md): Hencken William Pietenpol AIR Camper · Franklin, PA · Accident · No injuries · Data collection · Final report · Sep 21, 2017 · N40WH · Substantial damage
  > The failure of the weld that connects the left main landing gear and the axle during the takeoff roll.
- [NTSB ERA17LA288](https://openairdocs.org/ntsb/ERA17LA288.md): Smith AEROSTAR601 · Marietta, PA · Accident · No injuries · Limited investigation · Final report · Aug 19, 2017 · N7108 · Substantial damage
  > The pilot's failure to maintain directional control during takeoff with a quartering tailwind. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.
- [NTSB GAA17CA383](https://openairdocs.org/ntsb/GAA17CA383.md): Robinson Helicopter R44 · Easton, PA · Accident · No injuries · Data collection · Final report · Jul 4, 2017 · N3025J · Substantial damage
  > The pilot’s distraction during liftoff due to the tail rotor chip warning light illuminating, which resulted in the helicopter drifting right, the skid touching down, and a dynamic roll-over.
- [NTSB ERA17CA177](https://openairdocs.org/ntsb/ERA17CA177.md): Reupert Mark Avid Flyer · Reedsville, PA · Accident · Serious injuries · Data collection · Final report · May 10, 2017 · N532SE · Substantial damage
  > The sport pilot's failure to maintain airplane control during takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall.
- [NTSB GAA17CA154](https://openairdocs.org/ntsb/GAA17CA154.md): Cessna 180 · Bally, PA · Accident · No injuries · Data collection · Final report · Feb 19, 2017 · N123GT · Substantial damage
  > The pilot’s failure to maintain directional control during takeoff in crosswind conditions.
- [NTSB ERA16CA237](https://openairdocs.org/ntsb/ERA16CA237.md): Piper PA 28-161 · Honesdale, PA · Accident · No injuries · Data collection · Final report · Jun 29, 2016 · N8237Z · Substantial damage
  > The 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 ERA16LA224](https://openairdocs.org/ntsb/ERA16LA224.md): Cessna 172P · Honesdale, PA · Accident · No injuries · Limited investigation · Final report · Jun 20, 2016 · N54285 · Substantial damage
  > The pilot's failure to maintain adequate airspeed while departing in a heavily loaded airplane at high density altitude, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall, landing hard, and overrunning…
- [NTSB GAA16CA248](https://openairdocs.org/ntsb/GAA16CA248.md): Luscombe 8 · Blue Bell, PA · Accident · No injuries · Data collection · Final report · May 19, 2016 · N62925 · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll and the flight instructor's delayed remedial action, which resulted in runway excursion, and collision with a ditch.
- [NTSB ERA16CA060](https://openairdocs.org/ntsb/ERA16CA060.md): Eurocopter Deutschland EC 135 · Monongahela, PA · Accident · No injuries · Data collection · Final report · Nov 6, 2015 · N639ME · Substantial damage
  > The inadequate securing of the wheeled fire extinguisher's cover which resulted in it being blown off of the fire extinguisher and ingested into the helicopter's fenestron during takeoff, resulting in a loss of directional control.
- [NTSB GAA16CA045](https://openairdocs.org/ntsb/GAA16CA045.md): Schweizer 269C 1 · Mount Pocono, PA · Accident · No injuries · Data collection · Final report · Nov 4, 2015 · N21496 · Substantial damage
  > The student pilot's failure to remove the tension applied to the cyclic before takeoff, which resulted in a loss of directional control and the tail rotor striking the ground.
- [NTSB GAA15CA243](https://openairdocs.org/ntsb/GAA15CA243.md): Cessna 172 · New Enterprise, PA · Accident · No injuries · Data collection · Final report · Aug 30, 2015 · N8404X · Substantial damage
  > The pilot's exceedance of the critical angle of attack during takeoff, which resulted in an aerodynamic stall and impact with terrain.
- [NTSB GAA15CA075](https://openairdocs.org/ntsb/GAA15CA075.md): Head Balloons AX8 105 - NO Series · Intercourse, PA · Accident · Minor injuries · Data collection · Final report · Apr 12, 2015 · N3099F · Substantial damage
  > The pilot's selection of unsuitable terrain/location for takeoff in gusting wind conditions, resulting in a collision with a building, and substantial damage to the hot air balloon.
- [NTSB ERA15LA177](https://openairdocs.org/ntsb/ERA15LA177.md): Mooney M20J · Allentown, PA · Accident · No injuries · Limited investigation · Final report · Apr 6, 2015 · N4826H · Substantial damage
  > A total loss of engine power during takeoff due to an interruption of fuel flow to the engine. The reason for the interruption of the fuel flow could not be determined during postaccident examination and testing.
- [NTSB ERA15FA171](https://openairdocs.org/ntsb/ERA15FA171.md): Piper PA28 · West Chester, PA · Accident · 2 fatal · Field investigation · Final report · Mar 29, 2015 · N6842W · Destroyed
  > The failure of the flight instructor and the pilot to abort the takeoff after the airplane experienced a partial loss of engine power with adequate runway remaining, and their subsequent failure to maintain adequate airspeed, which led to the airplane…
- [NTSB DCA14CA147](https://openairdocs.org/ntsb/DCA14CA147.md): Dehavilland DHC 8 102 · Harrisburg, PA · Accident · No injuries · Data collection · Final report · Aug 10, 2014 · N815EX · Substantial damage
  > the airplanes collision with geese during the takeoff roll.
- [NTSB ERA14CA278](https://openairdocs.org/ntsb/ERA14CA278.md): Cessna 172F · Mount Pleasant, PA · Accident · Minor injuries · Data collection · Final report · May 31, 2014 · N8394U · Substantial damage
  > The pilot's incorrect takeoff procedures from the soft grass runway and his delay in aborting the takeoff after recognizing slow acceleration.
- [NTSB DCA14MA081](https://openairdocs.org/ntsb/DCA14MA081.md): Airbus A320 - 214 · Philadelphia, PA · Accident · No injuries · Class 2 · Major · Final report · Mar 13, 2014 · N113UW · Substantial damage
  > the captain's decision to reject the takeoff after the airplane had rotated. Contributing to the accident was the flight crew's failure to follow standard operating procedures by not verifying that the airplane's flight management computer was properly…
- [NTSB ERA14LA015](https://openairdocs.org/ntsb/ERA14LA015.md): Piper PA-22-135 · Selinsgrove, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 2013 · N170JH · Substantial damage
  > The incorrect (reverse) rigging of the elevator cables by maintenance personnel and their subsequent failure to verify that the rigging was correct during postmaintenance checks and the pilot's inadequate preflight check.
- [NTSB ERA13FA412](https://openairdocs.org/ntsb/ERA13FA412.md): Joseph Bender Mustang II · Smoketown, PA · Accident · Serious injuries · Field investigation · Final report · Sep 11, 2013 · N691LB · Destroyed
  > The pilot/owner/builder's failure to abort the takeoff and his subsequent failure to maintain airplane control. Contributing to the accident were the pilot's total lack of experience in the accident airplane and his lack of flying experience in the 3 1/2…
- [NTSB ERA13CA394](https://openairdocs.org/ntsb/ERA13CA394.md): Hoskins Samuel R Quickie Q2 · Zelienople, PA · Accident · No injuries · Data collection · Final report · Aug 30, 2013 · N202SH · Substantial damage
  > The pilot's loss of directional control during takeoff due to right main landing gear contact with a pool of standing water on the runway which resulted in a runway excursion.
- [NTSB ERA13LA263](https://openairdocs.org/ntsb/ERA13LA263.md): Wilson William M Cricket MC12 · Doylestown, PA · Accident · 1 fatal · Limited investigation · Final report · Jun 1, 2013 · N2SZ · Substantial damage
  > The pilot's failure to abort the takeoff after detecting the airplane’s degraded performance. Contributing to the accident were the likely loss of power from the left engine for reasons that could not be determined during the postaccident examination of the…
- [NTSB ERA13CA185](https://openairdocs.org/ntsb/ERA13CA185.md): Cessna 172N · Bally, PA · Accident · No injuries · Data collection · Final report · Mar 30, 2013 · N4601D · Substantial damage
  > The pilot's failure to maintain directional control during the takeoff roll.
- [NTSB ERA12CA506](https://openairdocs.org/ntsb/ERA12CA506.md): Evektor-Aerotechnik Sportstar · Myerstown, PA · Accident · No injuries · Data collection · Final report · Aug 12, 2012 · N633EV · Substantial damage
  > The student pilot's decision to continue the takeoff roll while trying to secure an open canopy and his subsequent failure to maintain directional control. Contributing to the accident was the student pilot's failure to complete the pretakeoff checklist.
- [NTSB ERA12LA445](https://openairdocs.org/ntsb/ERA12LA445.md): Cessna 172S · Allentown, PA · Accident · No injuries · Limited investigation · Final report · Jul 9, 2012 · N680MA · Substantial damage
  > The student pilot's failure to maintain directional control during a touch-and-go takeoff, which resulted in a runway excursion and a subsequent impact with a gopher hole, and the flight instructor's inadequate supervision of the student pilot and his delayed…
- [NTSB ERA12CA403](https://openairdocs.org/ntsb/ERA12CA403.md): Luscombe 8E · Selinsgrove, PA · Accident · No injuries · Data collection · Final report · Jun 9, 2012 · N2052K · Substantial damage
  > The pilot's failure to maintain airplane control during the takeoff.
- [NTSB ERA12LA335](https://openairdocs.org/ntsb/ERA12LA335.md): Piper J3C-65 · South Canaan, PA · Accident · Minor injuries · Limited investigation · Final report · May 13, 2012 · N98568 · Substantial damage
  > The pilot's delayed decision to abort the takeoff during shifting wind conditions.
- [NTSB ERA12CA302](https://openairdocs.org/ntsb/ERA12CA302.md): Evektor-Aerotechnik Sportstar · Lancaster, PA · Accident · No injuries · Data collection · Final report · Apr 25, 2012 · N505EV · Substantial damage
  > The pilot's loss of directional control during the takeoff, and her delayed remedial action in aborting the takeoff after the loss of directional control.

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

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