# NTSB investigations, PA: Initial climb

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 10 · 492 cases

## Latest cases

- [NTSB ERA25FA272](https://openairdocs.org/ntsb/ERA25FA272.md): Piper PA46-500TP · Lititz, PA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 20, 2025 · N819MA · Substantial damage
  > On July 20, 2025, about 0800 eastern daylight time, a Piper PA-46-500TP Meridian airplane, N819MA, was substantially damaged when it was involved in an accident in Lititz, Pennsylvania. The pilot was the sole person on board and was fatally injured. The…
- [NTSB ERA25LA122](https://openairdocs.org/ntsb/ERA25LA122.md): Allyn Kaste Rans S-19 (KIT) · Doylestown, PA · Accident · No injuries · Class 4 · Limited · Final report · Feb 10, 2025 · N258DK · Substantial damage
  > The pilot’s inadequate maintenance and preflight inspection.
- [NTSB ERA25LA041](https://openairdocs.org/ntsb/ERA25LA041.md): Anderson Kitfox 4 · New Castle, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 2, 2024 · N620GA · Substantial damage
  > A partial loss of engine power due to a split fuel line that resulted in a fuel leak and reduced fuel supply to the aft carburetor.
- [NTSB ERA25LA030](https://openairdocs.org/ntsb/ERA25LA030.md): Zenith Zodiac 601 HDS · Altoona, PA · Accident · No injuries · Class 3 · Limited · Final report · Oct 17, 2024 · N511JG · Substantial damage
  > The total loss of engine power due to fuel starvation as a result of a deteriorated gascolator gasket. Contributing was the failure of the mechanic to replace the gasket during the most recent condition inspection.
- [NTSB ERA24FA103](https://openairdocs.org/ntsb/ERA24FA103.md): Grumman American Avn. GA-7 · Coatesville, PA · Accident · 1 fatal · Class 3 · Field · Final report · Feb 1, 2024 · N887CC · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a loss of engine power due to water-contaminated fuel, and his subsequent loss of control. Contributing to the accident was an inadequate annual maintenance inspection, during which maintenance…
- [NTSB ERA23LA383](https://openairdocs.org/ntsb/ERA23LA383.md): Cessna 182 · Towanda, PA · Accident · No injuries · Class 3 · Limited · Final report · Sep 30, 2023 · N747UC · Substantial damage
  > A total loss of engine power during initial climb for undetermined reasons.
- [NTSB ERA23FA270](https://openairdocs.org/ntsb/ERA23FA270.md): Piper PA-30 · Ebensburg, PA · Accident · 2 fatal · Class 3 · Field · Final report · Jun 17, 2023 · N7628Y · Destroyed
  > The pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.
- [NTSB CEN22FA436](https://openairdocs.org/ntsb/CEN22FA436.md): Piper PA-28-140 · Allentown, PA · Accident · 1 fatal · Class 3 · Field · Final report · Sep 28, 2022 · N7329F · Destroyed
  > A partial loss of engine power for undetermined reasons.
- [NTSB ERA22LA411](https://openairdocs.org/ntsb/ERA22LA411.md): Cessna 172 · Clearfield, PA · Accident · No injuries · Class 3 · Limited · Final report · Sep 3, 2022 · N9619H · Substantial damage
  > A sudden partial loss of engine power for undetermined reasons, which resulted in an off-airport landing.
- [NTSB ERA22LA312](https://openairdocs.org/ntsb/ERA22LA312.md): Flightstar Flightstar II SC · Russell, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 14, 2022 · N6116U · Substantial damage
  > The pilot failed to maintain adequate airspeed and exceeded the airplane’s critical angle of attack while attempting to climb over trees, which resulted in an aerodynamic stall and loss of airplane control.
- [NTSB ERA22LA244](https://openairdocs.org/ntsb/ERA22LA244.md): Aeronca 7AC · Monongahela, PA · Accident · Serious injuries · Class 3 · Limited · Final report · May 27, 2022 · N84583 · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall.
- [NTSB ERA22LA018](https://openairdocs.org/ntsb/ERA22LA018.md): Z-Hi-Max 1400 · Benton, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 16, 2021 · N668CL · Substantial damage
  > The pilot’s loss of control and encounter with an aerodynamic stall during a planned low-altitude turn toward the airport after takeoff.
- [NTSB ERA21FA334](https://openairdocs.org/ntsb/ERA21FA334.md): North American SNJ-2 · Wilkes-Barre, PA · Accident · 1 fatal · Class 3 · Field · Final report · Aug 20, 2021 · N52900 · Destroyed
  > A partial loss of engine power for undetermined reasons. Also causal was the pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for a forced landing following the loss of engine power, which resulted in an aerodynamic stall and…
- [NTSB ERA21LA277](https://openairdocs.org/ntsb/ERA21LA277.md): Vans RV7 · Pottstown, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 4, 2021 · N654C · Destroyed
  > A total loss of power for reasons that could not be determined based on the available information.
- [NTSB ERA21LA271](https://openairdocs.org/ntsb/ERA21LA271.md): Cessna 150 · Bentleyville, PA · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 28, 2021 · N22307 · Substantial damage
  > The flight instructor and student pilot’s inadequate preflight performance planning which resulted in a takeoff attempt with insufficient available runway, a loss of control, and impact with terrain.
- [NTSB ERA19LA245](https://openairdocs.org/ntsb/ERA19LA245.md): Schweizer 269C · Allentown, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 11, 2019 · N1831A · Substantial damage
  > Inadequate maintenance of the helicopter’s magnetos, which resulted in a partial loss of engine power during the initial climb due to a failure of the left magneto and malfunction of the right magneto.
- [NTSB ERA19LA224](https://openairdocs.org/ntsb/ERA19LA224.md): Zenith CH601 · Carlisle, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 13, 2019 · N601MR · Substantial damage
  > Water contamination of the fuel system, which resulted in a total loss of engine power. Contributing to the accident was the pilot's inadequate preflight inspection, which failed to remove all the water from the airplane's fuel system.
- [NTSB CEN19LA202](https://openairdocs.org/ntsb/CEN19LA202.md): Aeronca L16A · Zelienople, PA · Accident · No injuries · Class 3 · Limited · Final report · Jun 29, 2019 · N9325H · Substantial damage
  > A total loss of engine power due to obstruction of the carburetor air intake by a piece of the air filter gasket that had become detached.
- [NTSB ERA18LA242](https://openairdocs.org/ntsb/ERA18LA242.md): Stinson 108 · Indiana, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 2, 2018 · N4059C · Substantial damage
  > A total loss of engine power as a result of debris contamination of the fuel, which resulted in fuel starvation.
- [NTSB ERA18LA007](https://openairdocs.org/ntsb/ERA18LA007.md): Ercoupe 415 · Centre Hall, PA · Accident · No injuries · Limited investigation · Final report · Oct 6, 2017 · N3538H · Substantial damage
  > The partial loss of engine power due to the No. 2 cylinder exhaust valve being stuck.
- [NTSB ERA17LA269](https://openairdocs.org/ntsb/ERA17LA269.md): Rose Herbert D Pietenpol AIR Camper · Tower City, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2017 · N709HR · Substantial damage
  > The pilot's incapacitation due to fainting as a result of complications from a previously undiagnosed heart condition.
- [NTSB ERA17FA248](https://openairdocs.org/ntsb/ERA17FA248.md): Aircraft Mfg & Dvlpmt CH601XLi Slsa · Towanda, PA · Accident · 1 fatal · Field investigation · Final report · Jul 19, 2017 · N601PH · Destroyed
  > A partial loss of engine power for reasons that could not be determined based on the available information, and the pilot's exceedance of the airplane's critical angle of attack during an attempted return to the airport, which resulted in an aerodynamic stall…
- [NTSB ERA17LA239](https://openairdocs.org/ntsb/ERA17LA239.md): Cessna 210L · Wilkes-Barre/Scranton, PA · Accident · No injuries · Class 3 · Limited · Final report · Jul 11, 2017 · N732FJ · Substantial damage
  > Failure of the left landing gear door actuator, which resulted in a loss of all hydraulic pressure and subsequent gear collapse on landing.
- [NTSB ERA17FA232](https://openairdocs.org/ntsb/ERA17FA232.md): Morrisey 2150A · Honesdale, PA · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2017 · N917JL · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's use of two psychoactive substances, which led to his impaired decision to attempt to takeoff after engine issues became evident.
- [NTSB ERA17FA223](https://openairdocs.org/ntsb/ERA17FA223.md): Slip Stream Genesis · Linesville, PA · Accident · 1 fatal · Field investigation · Final report · Jul 2, 2017 · N3449 · Substantial damage
  > The pilot's failure to maintain airspeed during a climbing turn after takeoff and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall/spin at an altitude too low for recovery. Contributing to the accident was the…
- [NTSB ERA17CA152](https://openairdocs.org/ntsb/ERA17CA152.md): Lazear John T Zenair Stol CH 701 · Windsor Twp, PA · Accident · Minor injuries · Data collection · Final report · Apr 11, 2017 · N3846T · Substantial damage
  > The pilot's improper pretakeoff planning, his failure to maintain adequate airspeed, and his exceedance of the airplane's critical angle of attack during a short-field takeoff with a tailwind, which resulted in an aerodynamic stall.
- [NTSB ERA16LA270](https://openairdocs.org/ntsb/ERA16LA270.md): Craig D Carter Stol CH 750 · Waynesburg, PA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2016 · N750AZ · Substantial damage
  > The partial loss of engine power due to carburetor icing.
- [NTSB ERA16LA126](https://openairdocs.org/ntsb/ERA16LA126.md): Mooney M20 · Pottstown, PA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 9, 2016 · N242TS · Substantial damage
  > The pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel contamination and a subsequent off-airport landing.
- [NTSB ERA16LA116](https://openairdocs.org/ntsb/ERA16LA116.md): Cessna 150L · Gettysburg, PA · Accident · No injuries · Limited investigation · Final report · Feb 27, 2016 · N976HB · Substantial damage
  > A partial loss of engine power during initial climb for undetermined reasons because examination of the engine and a successful test-run did not reveal any anomalies that would preclude normal operation.
- [NTSB ERA16LA077](https://openairdocs.org/ntsb/ERA16LA077.md): Beech A36 · Myerstown, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 22, 2015 · N4314S · Substantial damage
  > The pilot's failure to maintain control of the airplane during climbout due to his distraction with raising the landing gear.
- [NTSB ERA15LA311](https://openairdocs.org/ntsb/ERA15LA311.md): Thomas A Siminski Zenith CH 750 · Allentown, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 14, 2015 · N1750Z · Substantial damage
  > A partial loss of engine power due to the No. 1 spark plug being liberated from the cylinder head due to the stripped threads in the cylinder head. Contributing to the accident was the pilot’s decision to attempt to return to the airport while at a low…
- [NTSB ERA15LA279](https://openairdocs.org/ntsb/ERA15LA279.md): Kinner Sportster B · Eagles Mere, PA · Accident · No injuries · Limited investigation · Final report · Jul 23, 2015 · NC13776 · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA15LA239](https://openairdocs.org/ntsb/ERA15LA239.md): Stinson 108 · Dushore, PA · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 2015 · N97505 · Substantial damage
  > The total loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.
- [NTSB ERA15LA238](https://openairdocs.org/ntsb/ERA15LA238.md): Cessna T210 · Palmyra, PA · Accident · No injuries · Limited investigation · Final report · Jun 14, 2015 · N732VN · Substantial damage
  > The pilot's delay in conducting an aborted landing and his subsequent failure to establish a proper airspeed during the attempted go-around on a hot day, which resulted in the airplane’s inability to climb and a subsequent stall/mush.
- [NTSB ERA14LA450](https://openairdocs.org/ntsb/ERA14LA450.md): Barger Jerry L Challenger II · Clarion, PA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2014 · N4017C · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in a takeoff with the airplane's center of gravity aft of its limit and led the airplane to exceed its critical angle of attack and experience an aerodynamic stall during the initial climb.…
- [NTSB ERA14CA385](https://openairdocs.org/ntsb/ERA14CA385.md): Cote James Rans S 6S · New Berlin, PA · Accident · No injuries · Data collection · Final report · Aug 4, 2014 · N502CW · Substantial damage
  > The passenger's inadvertent interference with the rudder controls during the takeoff.
- [NTSB ERA14LA351](https://openairdocs.org/ntsb/ERA14LA351.md): Siler Ronald E Ultrastar · Halifax, PA · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 2014 · N4425W · Substantial damage
  > A total loss of engine power for reasons that could not be determined because the engine was not recovered. Contributing to the accident was the pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during…
- [NTSB ERA14LA308](https://openairdocs.org/ntsb/ERA14LA308.md): Taylor J-2 · Lock Haven, PA · Accident · No injuries · Limited investigation · Final report · Jun 20, 2014 · N16667 · Substantial damage
  > The airplane owner’s failure to clean and lubricate the engine valve guides and stems, which resulted in a partial loss of engine power during the initial climb due to an exhaust valve failure.
- [NTSB ERA13LA406](https://openairdocs.org/ntsb/ERA13LA406.md): Engineering & Research 415-D · Beaver Falls, PA · Accident · No injuries · Limited investigation · Final report · Sep 6, 2013 · N3940H · Substantial damage
  > The owner/pilot’s failure to follow engine manufacturer recommendations for engine oil changes and spark plug cleaning and rotating when operating the airplane with 100 low lead fuel, which resulted in carbon buildup in the engine and the total loss of engine…
- [NTSB ERA13LA366](https://openairdocs.org/ntsb/ERA13LA366.md): Interstate S-1B1 · Lititz, PA · Accident · No injuries · Limited investigation · Final report · Aug 17, 2013 · N46336 · Substantial damage
  > The pilot’s failure to control the airplane’s pitch attitude, which resulted in an aerodynamic stall during the initial takeoff climb. Contributing to the accident was the pilot’s failure to set the trim in accordance with the pretakeoff checklist and the…
- [NTSB ERA13LA229](https://openairdocs.org/ntsb/ERA13LA229.md): Schweizer SGS 2-33A · Erwinna, PA · Accident · Serious injuries · Limited investigation · Final report · May 4, 2013 · N2045T · Substantial damage
  > The pilot’s loss of glider control due to improper rigging of the rudder control cables, the mechanic’s inadequate flight control checks following the glider’s most recent annual inspection, and the pilot’s failure to perform a thorough preflight inspection.
- [NTSB ERA13CA228](https://openairdocs.org/ntsb/ERA13CA228.md): Piper PA-28-140 · Brogue, PA · Accident · Serious injuries · Data collection · Final report · May 2, 2013 · N33677 · Substantial damage
  > The flight instructor's inadequate supervision of the student pilot during takeoff, which resulted in a collision with a power line.
- [NTSB ERA13FA026](https://openairdocs.org/ntsb/ERA13FA026.md): Aerospatiale AS 355 · Erwinna, PA · Accident · 1 fatal · Field investigation · Final report · Oct 17, 2012 · C-FXGM · Substantial damage
  > The pilot’s decision to depart under visual flight rules in dark night instrument meteorological conditions, which resulted in subsequent spatial disorientation, uncontrolled descent, and impact with trees and terrain.
- [NTSB ERA13LA025](https://openairdocs.org/ntsb/ERA13LA025.md): Piper PA-28-140 · Allentown, PA · Accident · No injuries · Limited investigation · Final report · Oct 12, 2012 · N15037 · Substantial damage
  > The operator's failure to perform magneto inspections per the manufacturer's recommendations and failure to comply with the engine manufacturer's recommended time interval for engine overhaul, which resulted in defects in the magnetos going undetected and the…
- [NTSB ERA12LA557](https://openairdocs.org/ntsb/ERA12LA557.md): Piper PA-31-325 · Washington, PA · Accident · No injuries · Limited investigation · Final report · Sep 9, 2012 · N3591P · Substantial damage
  > The airplane’s encounter with a flock of geese during takeoff, which resulted in the airplane’s hard impact with the runway while the pilot maneuvered in an attempt to avoid the geese.
- [NTSB ERA12CA548](https://openairdocs.org/ntsb/ERA12CA548.md): Handy James L Buckeye Dream Mach · West Caln, PA · Accident · Serious injuries · Data collection · Final report · Sep 1, 2012 · N4258M · Substantial damage
  > The pilot’s inadequate compensation for the wind during the initial climb, which resulted in collision with a tree and terrain.
- [NTSB ERA12CA523](https://openairdocs.org/ntsb/ERA12CA523.md): Grumman American Avn. AA-1B · Bedford, PA · Accident · No injuries · Data collection · Final report · Aug 22, 2012 · N9858L · Substantial damage
  > The pilot's failure to maintain control of the airplane during the landing and subsequent go-around. Contributing to the accident was the pilot's failure to shutoff the carburetor heat during the attempted go-around and the weight at which the airplane was…
- [NTSB ERA12LA455](https://openairdocs.org/ntsb/ERA12LA455.md): Burkhart Grob G 103 Twin II · Hilltown, PA · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 2012 · N5448G · Substantial damage
  > The improper decision of the flight instructor receiving instruction to attempt a course reversal rather than land straight ahead following a simulated low-level rope break, and the inadequate remedial action of the flight instructor-in-command for allowing…
- [NTSB ERA12CA443](https://openairdocs.org/ntsb/ERA12CA443.md): Evektor-Aerotechnik Sportstar Plus · Lancaster, PA · Accident · No injuries · Data collection · Final report · Jul 2, 2012 · N182EV · Substantial damage
  > The pilot's attempt to secure an open canopy during takeoff, which resulted in a loss of control and subsequent hard landing.
- [NTSB ERA12FA327](https://openairdocs.org/ntsb/ERA12FA327.md): Mooney M20J · Sterling, PA · Accident · 2 fatal · Field investigation · Final report · May 10, 2012 · N9154K · Substantial damage
  > The pilot’s decision to take off on an uphill slope without utilizing the entire available runway, and his failure to abort the takeoff when he realized he wasn’t going to liftoff in time to clear the trees at the end of the runway.

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

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