NTSB investigations, DE
24 cases where NTSB found Aircraft.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 3 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 1 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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\", '01'))
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.
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", '01')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB ERA22LA415Accident · No injuriesClass 4 · LimitedFinal reportCessna T210N · Georgetown, DEThe pilot's failure to extend the landing gear before landing. Contributing to the accident was an inoperative landing gear warning horn.NTSB ERA21LA058Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Georgetown, DEThe pilot’s failure to maintain airplane control while on landing in gusting crosswind conditions.NTSB ERA20CA318Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Wilmington, DEThe student pilot’s improper landing flare, which resulted in a hard bounced landing.NTSB ERA19FA250Accident · 2 fatalClass 3 · FieldFinal reportBeech 95B55 · Wilmington, DEThe pilots’ failure to place the left fuel selector into the proper position, which resulted in a total loss of the left engine’s power due to fuel starvation. Contributing was their failure to properly secure the left engine and their failure to maintain…NTSB 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.NTSB 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.NTSB 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.NTSB ERA17LA097Accident · Minor injuriesLimited investigationFinal reportPiper PA22 · Georgetown, DEAn in-flight fire for reasons that could not be determined due to extensive thermal damage to the airplane.NTSB ERA16LA253Accident · 1 fatalLimited investigationFinal reportBell 429 · Georgetown, DEThe emergency response team's failure to ensure that the system operator was secured to the helicopter, which resulted in his fall during the recurrent rescue hoist training operation.NTSB ERA16LA242Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164 · Laurel, DEA total loss of engine power due to an encounter with a bird, which collided with the spray pump fan assembly and subsequently sent blade fragments into the engine compartment, damaging the throttle linkage.NTSB 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.NTSB ERA14LA242Accident · Serious injuriesLimited investigationFinal reportMooney M20K · Georgetown, DEThe pilot’s improper preflight planning and in-flight fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal to the accident was the pilot’s failure to see and avoid the wires on the airport boundary.NTSB ERA13CA384Accident · No injuriesData collectionFinal reportCessna 172S · Middletown, DEThe student pilot’s improper recovery from a bounced landing.NTSB 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…NTSB ERA12LA493Accident · No injuriesLimited investigationFinal reportSikorsky S-58JT · Middletown, DEThe pilot's failure to recognize that the helicopter was experiencing tail rotor dynamic instability and to take immediate corrective actions during an external load lift, which resulted in the failure of a tail rotor blade.NTSB 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.NTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.NTSB ERA10CA057Accident · No injuriesData collectionFinal reportCessna 172S · Summit, DEThe student pilot’s failure to maintain directional control during takeoff.NTSB ERA09CA482Accident · No injuriesData collectionFinal reportBell 206 · Gumboro Township, DEThe pilot’s failure to secure the flight controls before exiting the running helicopter. Contributing to the accident was the operator’s practice of exiting the helicopter while it was still running.NTSB ERA09CA207Accident · No injuriesData collectionFinal reportPiper PA28-151 · Dover, DEThe pilot's failure to maintain directional control during landing.NTSB ERA09CA217Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Middletown, DEThe pilot's failure to maintain aircraft control while landing in gusty conditions.NTSB ERA09CA045Accident · No injuriesData collectionFinal reportRandall Amanda Rotorway · Middletown, DEThe student pilot’s excessive use of cyclic during the engine run-up. Contributing to the accident were the student pilot’s lack of overall experience and the gusting wind conditions.