NTSB investigations, 2019, MD

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

Cases per year

20082026
NTSB investigations, 2019, 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\") = 2019
    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 ERA20FA060Accident · 1 fatalClass 3 · FieldFinal reportAmerican AA5 · College Park, MDThe pilot's loss of airplane control due to spatial disorientation after entering a climbing turn in instrument meteorological conditions.Dec 29, 2019 · N26455 · DestroyedNTSB ERA20LA038Accident · No injuriesClass 3 · LimitedFinal reportMooney M20M · College Park, MDThe pilot’s improper flare, which resulted in a bounced landing, his improper airplane configuration during the attempted go-around, which resulted in the airplane not climbing, and his subsequent landing off the side of the runway.Nov 18, 2019 · N1031M · Substantial damageNTSB GAA20CA026Accident · Minor injuriesData collectionFinal reportLlewellyn, Warwinc W Vans RV-4 · Lusby, MDThe pilot's failure to maintain lateral control during takeoff, which resulted in impact with terrain and a subsequent cartwheel.Oct 12, 2019 · N15WL · Substantial damageNTSB ERA19LA274Accident · Minor injuriesClass 3 · LimitedFinal reportSocata TB9 · Fort Meade, MDThe failure of the carburetor intake scat tubing, which resulted in a partial loss of engine power.Sep 17, 2019 · N2824R · Substantial damageNTSB ANC19LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Ocean City, MDA partial loss of power due to the liberation or failure of the No. 2 cylinder's exhaust valve.Jul 16, 2019 · N9715B · Substantial damageNTSB ERA19LA197Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Crisfield, MDThe pilot's sudden incapacitation from an undiagnosed cardiac arrhythmia while on final approach, which resulted in descent and collision with trees and terrain.Jun 15, 2019 · N2750Q · Substantial damageNTSB ERA19LA187Accident · Minor injuriesClass 3 · LimitedFinal reportAvid Avid Magnum · Frederick, MDThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s and instructor’s lack of experience in the make and model of the airplane.Jun 6, 2019 · N3062B · Substantial damageNTSB ERA19FA163Accident · 2 fatalClass 2 · FieldFinal reportGuimbal Cabri · Kent Island, MDThe noninstrument-rated pilot's continued visual flight into instrument meteorological conditions, which resulted in an inadvertent descent into the water. Contributing to the accident was the pilot's decision to conduct the flight at a low altitude without…May 4, 2019 · N572MD · Destroyed