NTSB investigations, 2023, PA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19632026
NTSB investigations, 2023, PA per year, 1963–2026: 4,232 cases
19632
1964157
1965149
1966172
1967192
1968154
1969132
1970136
1971153
1972104
1973118
1974143
1975131
1976123
1977116
1978124
1979109
198089
198192
198296
198381
198484
198575
198664
198764
198865
198945
199065
199147
199247
199348
199441
199555
199638
199756
199840
199941
200047
200134
200235
200329
200437
200533
200636
200735
200833
200930
201019
201127
201239
201327
201424
201535
201632
201733
201828
201930
202019
202128
202235
202311
202419
202517
202612

Latest cases

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE year(c.\"eventDate\") = 2023
    AND c.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB ERA24FA077Accident · 1 fatalClass 3 · FieldFinal reportZenith Stol CH701 · Marienville, PAThe 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.Dec 30, 2023 · N4209W · DestroyedNTSB ERA23LA383Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Towanda, PAA total loss of engine power during initial climb for undetermined reasons.Sep 30, 2023 · N747UC · Substantial damageNTSB ERA23LA381Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75 · Erwinna, PAThe pilot’s failure to maintain control of the airplane while taking off in a crosswind.Sep 19, 2023 · N46Y · Substantial damageNTSB ERA23LA332Accident · 1 fatalClass 3 · LimitedFinal reportBell 47G-5 · Mifflinville, PAThe pilot’s failure to see and avoid powerlines during an aerial application flight.Aug 12, 2023 · N1503L · DestroyedNTSB CEN23LA348Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Philadelphia, PAThe 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.Aug 3, 2023 · N860TW · Substantial damageNTSB ERA23FA270Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-30 · Ebensburg, PAThe pilot’s spatial disorientation and subsequent loss of airplane control, which resulted in an uncontrolled descent and collision with terrain.Jun 17, 2023 · N7628Y · DestroyedNTSB ERA23LA277Accident · No injuriesClass 3 · LimitedFinal reportRockwell International 695 · Philadelphia, PAFailure of the nose gear support structure for unknown reasons, which resulted in the nose landing gear collapsing during landing.May 31, 2023 · N515AM · Substantial damageNTSB ERA23FA252Accident · 1 fatalClass 3 · FieldFinal reportCessna 180 · Harrisburg, PAThe 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.May 31, 2023 · N3178D · Substantial damageNTSB ERA23LA213Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · West Mifflin, PAThe student pilot’s improper landing flare, and the flight instructor’s delayed remedial action, which resulted in a hard landing.Apr 13, 2023 · N544TH · Substantial damageNTSB ERA23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · West Mifflin, PAThe student pilot’s decision to abort the takeoff and land on the runway without sufficient runway remaining, which resulted in a runway overrun.Apr 10, 2023 · N476TA · Substantial damageNTSB ERA23LA198Accident · No injuriesClass 3 · LimitedFinal reportS C Aerostar S A YAK-52 · Toughkenamon, PAThe pilot’s failure to see and avoid powerlines while on approach to land.Mar 22, 2023 · N669YK · Substantial damage