NTSB investigations, 2008, MD

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

Cases per year

20082026
NTSB investigations, 2008, 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\") = 2008
    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 ERA09CA077Accident · No injuriesData collectionFinal reportCessna 172I · Frederick, MDThe student pilot's delayed decision to abort the landing.Nov 27, 2008 · N35540 · Substantial damageNTSB ERA09CA059Accident · No injuriesData collectionFinal reportMooney M20R · Indian Head, MDThe pilot's failure to maintain directional control while landing in gusting winds.Nov 16, 2008 · N4157 · Substantial damageNTSB NYC08LA310Accident · 1 fatalLimited investigationFinal reportDufault Mark V Pitts S-1D · Ridgely, MDThe pilot's inadequate preflight weather evaluation which resulted in an attempted landing in fog and subsequent impact with terrain.Sep 9, 2008 · N511MD · Substantial damageNTSB NYC08CA257Accident · Minor injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe flight instructor's inadequate remedial action following the student pilot's improper recovery from a bounced landing.Jul 26, 2008 · N331ME · Substantial damageNTSB NYC08CA248Accident · No injuriesData collectionFinal reportCessna 172N · Edgewater, MDThe pilot's misjudged distance/speed during landing.Jul 12, 2008 · N734AT · Substantial damageNTSB NYC08CA230Accident · No injuriesData collectionFinal reportCessna 172 SP · Stevensville, MDThe flight instructor's delayed decision to go around.Jun 25, 2008 · N3504X · Substantial damageNTSB ANC08CA051Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Stevensville, MDThe pilot's misjudged speed/distance during landing.Apr 12, 2008 · N403DS · Substantial damageNTSB NYC08LA075Accident · Minor injuriesLimited investigationFinal reportDean Patrick G Genesis · Laurel, MDThe reason for this occurrence was undetermined.Jan 5, 2008 · N969PZ · Substantial damage