Skip to content

NTSB investigations, DE

17 cases where the first occurrence was “Loss of control - in flight”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

Where

Latest cases

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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250) 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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250)
  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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)
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 NYC08LA024Accident · 2 fatalLimited investigationFinal reportBlondin 601HDS · Farmington, DEThe reason for this occurrence could not be determined.Nov 4, 2007 · N27S · Destroyed NTSB NYC03FA079Accident · 2 fatalField investigationFinal reportRaytheon V35A · Delaware City, DEThe pilot's failure to maintain aircraft control. A factor in the accident was instrument meteorological conditions.Apr 8, 2003 · N7144N · Substantial damage NTSB NYC01FA172Accident · 1 fatalField investigationFinal reportBeech A23-24 · Bridgeville, DEThe pilot's incapacitation, which resulted in a loss of aircraft control while maneuvering. A factor was the FAA Aeromedical Certification Division's inadequate certification/approval of the pilot's medical certificate. Findings were the pilot's inappropriate…Jul 15, 2001 · N5962S · Substantial damage NTSB IAD98LA067Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Selbyville, DEInadequate compensation for wind conditions by the pilot, and his failure to maintain control of the airplane. High, gusting winds were contributing factors.Jun 3, 1998 · N3731J · Substantial damage NTSB NYC98LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Georgetown, DEThe student pilot's improper recovery from the bounced landing and the flight instructor's delayed remedial action.Oct 2, 1997 · N63235 · Substantial damage NTSB NYC97LA093Accident · No injuriesLimited investigationFinal reportCessna 150H · New Castle, DEthe pilot's failure to maintain directional control of the airplane. A contributing factor was the gusty wind conditions.May 10, 1997 · N23471 · Substantial damage NTSB NYC95LA107Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Newark, DEThe pilot's improper use of throttle and collective controls, resulting in the loss of rotor rpm and the inflight loss of control.May 13, 1995 · N122HA · Substantial damage NTSB BFO95LA013Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Magnolia, DEthe pilot's failure to maintain adequate rotor rpm while hovering.Nov 19, 1994 · N40411 · Destroyed NTSB NYC93FA102Accident · 1 fatalField investigationFinal reportCessna 150E · Selbyville, DEThe pilot's failure to maintain proper airspeed resulting in an inadvertent stall/spin and collision with the terrain. A factor related to the accident was the pilot's lack of experience in the banner towing operation.Jun 7, 1993 · N3981U · Destroyed NTSB BFO92FA125Accident · 3 fatalField investigationFinal reportPiper PA-60-602P · Georgetown, DEThe pilot's failure to maintain airspeed, while circling to land, resulting in an inadvertent stall. Factors related to the accident were: the pilot's excessive maneuvering of the airplane and his insufficient altitude for recovery from the stall.Sep 5, 1992 · N3647T · Destroyed NTSB BFO92LA060Accident · Minor injuriesLimited investigationFinal reportCessna 172XP · Milton, DEThe pilot's failure to attain adequate airspeed for climb.May 11, 1992 · N4695K · Substantial damage NTSB BFO91FA048Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Odessa, DEThe pilot's failure to recover from a stall. Contributing was an intentional stall of the aircraft, pilot inexpereince and inadequate altitude.May 5, 1991 · N9285 · Destroyed NTSB BFO91LA023Accident · Serious injuriesLimited investigationFinal reportHolmes Special S2C · Ellendale, DEThe pilot's failure to recover from an aerobatic manuever in time to avoid inflight collision with the ground.Jan 15, 1991 · N484MH · Destroyed NTSB BFO89FA020Accident · 1 fatalField investigationFinal reportCessna 152 · Townsend, DELoss of aircraft control for unknown reasons.Mar 6, 1989 · N24236 · Destroyed NTSB BFO88LA070Accident · No injuriesLimited investigationFinal reportCessna 150K · Selbyville, DEThe plt was in the process of picking up a banner when the aircraft stalled and crashed into a wooded area. The banner was picked up at an airspeed of 80 mph and the acft altitude was increased to 250 ft AGL. The pilot reported that the wings of the acft…Aug 1, 1988 · N5682G · Substantial damage NTSB BFO86LHD01Accident · No injuriesFinal reportCessna 414 · Georgetown, DEThe acft impacted trees during a VOR apch and descended to ground impact. The plt flew the apch with the autopilot coupled. The alt hold and alert were set for the mda. When visual contact with the arpt enviroment was established, the plt disconnected the alt…Dec 13, 1985 · N13FH · Destroyed 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