Skip to content

NTSB investigations, DE

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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'
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 BFO85LA019Accident · No injuriesLimited investigationFinal reportCessna 177 · Delaware City, DEThe acft departed charleston, SC at about 1730 with 42 gals (5 hrs) of fuel on board for the planned 4 hr flt to smyrna, DE. Headwinds of 10 to 20 KTS were encountered en route, putting the flt in the smyrna area 45 mins late with only 15 mins of fuel…Mar 3, 1985 · N18038 · Substantial damage NTSB NYC85LA031Accident · No injuriesLimited investigationFinal reportCessna 182D · Woodside, DEThe plt reported that he refueled the acft on 11/12/84 & filled the tanks. Tach time was 1766.95. On 11/20/84, when he took off, he estimated 51 gals of fuel was on board. He flew to another location & landed, then was away from his acft about 1 hr. When he…Nov 20, 1984 · N8957X · Substantial damage NTSB NYC84LA312Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ellendale, DEDue to high oil temp the solo student plt elected to make a precautionary landing. During the rollout a x-wind from the right resulted in the acft drifting left off the rwy. The left wing struck soy bean plants causing the acft to spin to the right collapsing…Sep 8, 1984 · N2414L · Substantial damage NTSB NYC84LA298Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Eagle Crest, DEAfter landing the plt used power to continue taxiing to the end of the wet grass rwy. Stopping distance was misjudged when braking began and the acft overran the rwy colliding with a small ditch. One main gear and the nose gear collapsed.Sep 3, 1984 · N62AC · Substantial damage NTSB BFO84FA003Accident · 2 fatalField investigationFinal reportPiper L-21-A · Selbyville, DEAt the conclusion of towing banners with no pax on board, the acft was landed and topped off with fuel. The plt then reentered the acft and an additional employee got in the rear seat with the intension of flying to a nearby airport for a plt exchange. During…Aug 8, 1984 · N10468 · Destroyed NTSB NYC84LA256Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201 · Smyrna, DEAcft contacted a ditch and nosed over during a precautionary landing after plt noticed engine was running rough. Cause of engine roughness could not be determined through inspection of the engine.Jul 27, 1984 · N2936N · Substantial damage NTSB BFO84FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Selbyville, DEThe student pilot and one passenger departed on the flight without a wx briefing despite the existence of low ceilings and rain. Witnesses related hearing the engine accelerate and seeing the acft start a climb before it broke up and impacted the ground.…Jul 21, 1984 · N9014W · Destroyed NTSB NYC84LA199Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Rehoboth Beach, DEBased on erroneous information PIC assumed road construction was work to pave grass strip. He landed on a road being constructed in a housing expansion area. During landing roll the left main gear broke off after contacting a dirt mound.Jun 5, 1984 · N5870V · Substantial damage NTSB NYC84FA202Accident · Serious injuriesField investigationFinal reportBell 206B · Georgetown, DEAfter performing police patrol activities, the aircrew landed, refueled the helicopter, then took off to practice autorotative landings. Two autorotative landings were made on rwy 22, then 2 more were made on an adjacent grass area. After the 2nd landing on…May 20, 1984 · N75SP · Substantial damage NTSB NYC84FHD01Accident · Serious injuriesFinal reportBeech 58P · Cheswold, DEThe plt reported that the western 1/3 of rwy 9 consisted of rough chat rock & packed soil. The remaining rwy surface consisted of asphalt. The plt elected to make a no-flap takeoff, using all of the rwy. He stated that due to the rough rwy surface, up…Oct 22, 1983 · N2029Z · Destroyed NTSB NYC83LA250Accident · No injuriesLimited investigationFinal reportCessna C172M · Dover, DEThe acft ran off the end of the rwy, groundlooped, and collided with a tree during an effort to avoid a blast fence. The landing, made at night with touchdown occurring too FAR down the rwy. An approach had already been abandoned due to excessive airspeed,…Sep 20, 1983 · N64006 · Substantial damage NTSB NYC83FA214Accident · No injuriesField investigationFinal reportGates Learjet 25B · Wilmington, DEAfter lift-off a flock of birds approached from left to right at about 400 ft. the plt maneuvered the acft behind & above the birds in an attempt to avoid them. Both engs flamed out & the acft mde a forced landing on a road. Ground witnesses described the…Aug 17, 1983 · N108PA · Substantial damage NTSB NYC83LA065Accident · No injuriesLimited investigationFinal reportCessna 150K · Wilmington, DEA C-130 aircrew was cleared to taxi to the run-up area at the north end of the arpt for a run-up. At that time, the wind was reported from 360 deg at 8 KTS. The C-130 crew stopped on the run-up pad facing the wind & began a run-up. In the meantime, a Cessna…Feb 19, 1983 · N5898G · Substantial damage NTSB DCA83IA003Incident · No injuriesIncident investigationFinal reportBeech E90 · Wilmington, DEThe aircraft crashed shortly after taking off from the greater Wilmington airport, Wilmington, DE. The pilot stated that the left engine lost power at about 100 ft AGL, just as the landing gear was being retracted. He said the autofeather was armed, but the…Oct 28, 1982 · N213DS · Minor damage NTSB NYC82FA203Accident · 2 fatalField investigationFinal reportChampion 7ECA · Lewes, DEAbout 15 min after takeoff, the aircraft was observed to enter a maneuver from low altitude over a beach area. During the maneuver, the plane pulled up, entered a steep climb and then banked or rolled left and entered a nose down attitude. Before recovering,…Aug 17, 1982 · N1886G · Destroyed NTSB NYC82FHD15Accident · Minor injuriesFinal reportGregg KR-2 · Middletown, DEThe eng failed on the downwind leg after the plt applied carb heat. The plt attempted a power-off approach to the rwy but encountered turbulence from another acft passing below him on final causing him to lose control & enter a spin. After recovery the acft…Jun 11, 1982 · N38DR · Substantial damage NTSB NYC82FA012Accident · 1 fatalClosedBeech 35 · Wyoming, DENov 26, 1981 · N2732V · Destroyed NTSB NYC81FHD33Accident · Minor injuriesClosedGrum Amer AA-5B · Rehoboth Beach, DEJul 31, 1981 · N4553D · Destroyed NTSB NYC81FHD27Accident · Minor injuriesClosedCessna 172 · Lepsic, DEMay 31, 1981 · N739BF · Substantial damage NTSB NYC81FHD18Accident · No injuriesClosedPiper PA-28 · Wilmington, DEFeb 4, 1981 · N98247 · Substantial damage NTSB NYC81FHD12Accident · Serious injuriesClosedPiper PA-28 · Wilmington, DEFeb 1, 1981 · N6423J · Substantial damage NTSB NYC81DHD10Accident · No injuriesClosedBell 206L · Odessa, DENov 26, 1980 · N5748H · Substantial damage NTSB NYC80DHD20Accident · No injuriesClosedMillercraft A · Laurel, DEJul 4, 1980 · N5810N · Substantial damage NTSB NYC80DHD19Accident · No injuriesClosedPiper PA-12 · Rehoboth, DEJul 4, 1980 · N7576H · Substantial damage NTSB NYC80FHD10Accident · No injuriesClosedHawker-Sdly DH125 · Wilmington, DEApr 19, 1980 · N926LR · Substantial damage NTSB IAD80DHD01Accident · No injuriesClosedCessna 150 · Middletown, DEOct 12, 1979 · N11820 · Substantial damage NTSB IAD80DHD02Accident · No injuriesClosedCessna 172 · Dover, DEOct 7, 1979 · N739BF · Substantial damage NTSB IAD79FHD09Accident · Minor injuriesClosedBeech 58 · Wilmington, DEJan 16, 1979 · N4786M · Substantial damage NTSB IAD79FHD05Accident · No injuriesClosedCessna 150 · Rehobeth, DENov 25, 1978 · N5440Q · Substantial damage NTSB IAD78FHD25Accident · Minor injuriesClosedCessna 177 · Broadkil Beach, DESep 27, 1978 · N3471T · Destroyed NTSB IAD78FHD24Accident · No injuriesClosedBeech V35B · Cheswold, DESep 17, 1978 · N444KM · Substantial damage NTSB IAD78FHD22Accident · Minor injuriesClosedBellanca 7ECA · Selbyville, DEAug 15, 1978 · N88388 · Substantial damage NTSB IAD78IA091Incident · No injuriesClosedLockheed L-382G · Dover, DEAug 10, 1978 · N23ST · Minor damage NTSB IAD78FA051Accident · 3 fatalClosedPiper PA-28 · Wilmington, DEMar 18, 1978 · N55645 · Destroyed NTSB IAD78FA032Accident · Serious injuriesClosedBeech C45H · New Castle, DEJan 17, 1978 · N9801Z · Substantial damage NTSB IAD77FA047Accident · Serious injuriesClosedCessna 310H · Selbyville, DEJun 21, 1977 · N1004Q · Destroyed NTSB IAD77DHD14Accident · No injuriesClosedPiper PA-28 · Cheswold, DEMay 6, 1977 · N8244N · Substantial damage NTSB IAD77FHD05Accident · Serious injuriesClosedMooney 20 · Dover, DENov 30, 1976 · N6525B · Destroyed NTSB IAD76DHD42Accident · No injuriesClosedCessna 172 · Selbyville, DEAug 24, 1976 · N50983 · Substantial damage NTSB IAD76AI084Accident · Serious injuriesClosedPiper PA-22 · Rehoboth Beach, DEJul 19, 1976 · N4833Z · 2 aircraft · Destroyed NTSB IAD76FHD30Accident · No injuriesClosedBeech A23-24 · Laurel, DEJun 5, 1976 · N764AA · Substantial damage NTSB IAD76FHD23Accident · Serious injuriesClosedCessna 172 · Milford, DEApr 4, 1976 · N61992 · Substantial damage NTSB NYC76FHD22Accident · No injuriesClosedGrumman G-164 · Frederick, DEMar 29, 1976 · N7855 · Substantial damage NTSB IAD76II036Incident · No injuriesClosedGrumman G-159 · New Castle, DENov 25, 1975 · N80AC · Minor damage NTSB IAD76DHD11Accident · Minor injuriesClosedAmerican AA1 · Delmar, DEOct 24, 1975 · N5711L · Substantial damage NTSB IAD76DHD10Accident · No injuriesClosedAerocomdr 112 · Rehoboth Beach, DEOct 10, 1975 · N1064J · Substantial damage NTSB IAD76AI015Accident · 1 fatalClosedEmstrom F28A · Harrington, DESep 12, 1975 · N281Q · Destroyed NTSB NYC76AN032Accident · Serious injuriesClosedDouglas DC8-51 · Wilmington, DEAug 8, 1975 · N801E · No damage NTSB IAD75DHD55Accident · No injuriesClosedBeech A23A · Wyoming, DEJun 24, 1975 · N2310W · Substantial damage NTSB IAD75AI065Accident · 1 fatalClosedCessna 150 · Cheswold, DEJun 21, 1975 · N5778G · Substantial damage