NTSB investigations, 2010, MD

7 cases where the sequence of events included Collision with terr/obj (non-CFIT).

Cases per year

20082026
NTSB investigations, 2010, MD per year, 2008–2026: 102 cases
20088
20093
20107
20118
20126
20139
20144
201512
20165
20176
20185
20198
20204
20215
20223
20233
20242
20251
20263

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\") = 2010
    AND c.\"eventStateOrRegion\" = 'MD' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 ERA11CA087Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23D · Aberdeen, MDThe pilot's loss of control during an intentional aerobatic maneuver (spin) resulting in a collision with trees.Dec 11, 2010 · N91896 · Substantial damageNTSB ERA11CA045Accident · No injuriesData collectionFinal reportEvolution Revo · Gransonville, MDThe pilot's improper recovery from a bounced landing and the certificated flight instructor's inadequate remedial action, which resulted in an aerodynamic stall during a go-around.Oct 10, 2010 · N611TX · Substantial damageNTSB ERA10CA467Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Churchville, MDThe pilot’s failure to ensure that the fuel valve was in the "ON" position during his preflight inspection, resulting in the loss of engine power during takeoff.Sep 1, 2010 · N2156K · Substantial damageNTSB ERA10LA400Accident · No injuriesLimited investigationFinal reportDayton JD-2 · Hollywood, MDThe pilot's improper installation of the propeller hub to the engine crankshaft, which resulted in a loss of engine thrust.Aug 5, 2010 · N43015 · Substantial damageNTSB ERA10TA197Accident · Minor injuriesFinal reportCessna 182P · Frederick, MDA loss of engine power for undetermined reasons following a reported severe turbulence encounter.Mar 30, 2010 · N52790 · Substantial damageNTSB ERA10FA154Accident · 1 fatalField investigationFinal reportBeech P35 · Edgewater, MDThe pilot's failure to maintain adequate airspeed while on approach, which resulted in an inadvertent stall. Contributing to the accident was the pilot's likely impairment due to back pain, symptoms of opiate withdrawal, or both.Feb 27, 2010 · N1521S · Substantial damageNTSB ERA10CA109Accident · Serious injuriesData collectionFinal reportSchweizer 269C-1 · Grantsville, MDThe pilot's loss of aircraft control after encountering turbulence over a mountain range. Contributing to the accident was the pilot's failure to obtain an Airmet for turbulence along the route of flight prior to departure and while enroute.Jan 6, 2010 · N3275M · Substantial damage