NTSB investigations, DE

14 cases where NTSB found Aircraft oper/perf/capability.

Cases per year

20082026
NTSB investigations, DE per year, 2008–2026: 14 cases
20081
20092
20121
20132
20141
20172
20181
20202
20241
20251

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 c.\"eventStateOrRegion\" = 'DE' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0106'))
  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 ERA25LA342Accident · Minor injuriesClass 4 · LimitedFinal reportSchweizer G-164B · Dover, DEThe pilot’s exceedance of the critical angle of attack which resulted in an aerodynamic stall at an altitude too low to recover.Sep 9, 2025 · N8483K · Substantial damageNTSB ERA24LA299Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 8GCBC · Frankford, DEA partial loss of engine power resulting from cylinder detonation and a cracked spark plug, which resulted in a forced landing and impact with terrain.Jul 4, 2024 · N749SK · Substantial damageNTSB ERA21LA058Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Georgetown, DEThe pilot’s failure to maintain airplane control while on landing in gusting crosswind conditions.Nov 28, 2020 · N7596B · Substantial damageNTSB ERA20CA318Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Wilmington, DEThe student pilot’s improper landing flare, which resulted in a hard bounced landing.Sep 7, 2020 · N19813 · Substantial damageNTSB ERA19TA005Accident · No injuriesFinal reportEnstrom F28 · Bridgeville, DEThe pilot's mismanagement of collective pitch control during takeoff from an area with numerous obstacles, which resulted in the helicopter entering a low rotor rpm state and a forced hard landing.Oct 7, 2018 · N5691Y · Substantial damageNTSB ERA17LA249Accident · Serious injuriesLimited investigationFinal reportGrumman G 164 · Marydel, DEThe pilot's failure to maintain adequate clearance from power lines while conducting an aerial application flight.Jul 19, 2017 · N691Y · Substantial damageNTSB ERA17FA190Accident · 1 fatalField investigationFinal reportEurocopter Deutschland EC 135 · New Castle, DEThe pilot's loss of helicopter control during a missed approach in instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation.May 25, 2017 · N62UP · DestroyedNTSB ERA14LA321Accident · Minor injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Farmington, DEThe pilot's inadequate preflight planning for a takeoff in high-density altitude conditions and his decision to reduce power during the initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.Jun 18, 2014 · N891JC · Substantial damageNTSB ERA13CA384Accident · No injuriesData collectionFinal reportCessna 172S · Middletown, DEThe student pilot’s improper recovery from a bounced landing.Aug 18, 2013 · N647SP · Substantial damageNTSB ERA13LA111Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-200 · Dover, DEThe pilot's failure to land the airplane at multiple airports that were equipped with adequate instrument approach procedures while operating in low instrument meteorological conditions and his delay in declaring a fuel-related emergency, which resulted in a…Jan 13, 2013 · N4975S · Substantial damageNTSB ERA12CA393Accident · No injuriesData collectionFinal reportNorth American AT-6C · Delmar, DEThe pilot's failure to go around after not attaining the proper touchdown point, which resulted in a runway excursion and noseover.Jun 11, 2012 · N7055K · Substantial damageNTSB ERA10CA057Accident · No injuriesData collectionFinal reportCessna 172S · Summit, DEThe student pilot’s failure to maintain directional control during takeoff.Nov 7, 2009 · N134B · Substantial damageNTSB ERA09CA207Accident · No injuriesData collectionFinal reportPiper PA28-151 · Dover, DEThe pilot's failure to maintain directional control during landing.Mar 20, 2009 · N41568 · Substantial damageNTSB ERA09CA217Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Middletown, DEThe pilot's failure to maintain aircraft control while landing in gusty conditions.Dec 1, 2008 · N276 · Substantial damage