NTSB investigations, MD

5 cases where NTSB found Perception/orientation/illusion.

Cases per year

20092026
NTSB investigations, MD per year, 2009–2026: 5 cases
20091
20131
20171
20191
20201

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 c.\"eventStateOrRegion\" = 'MD' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '020220'))
  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 ERA20CA300Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Millington, MDThe pilot’s misidentification of a corn field for the destination airport’s runway, and a subsequent aerodynamic stall at low altitude while attempting to land.Aug 30, 2020 · N3707U · Substantial damageNTSB 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 GAA18CA074Accident · No injuriesData collectionFinal reportCessna 172 · Bowie, MDThe pilot’s failure to maintain situational awareness during the approach to land. Contributing to the accident was the pilot’s distraction by the instrument panel during the approach.Nov 30, 2017 · N474SP · Substantial damageNTSB ERA13FA309Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Ocean City, MDThe pilot's failure to terminate the intentional aerobatic spin at an altitude adequate to prevent impacting the water. Contributing to the accident was the pilot's loss of situational awareness due to target fixation during the prolonged aerobatic maneuver.Jun 30, 2013 · N116RL · DestroyedNTSB ERA09LA200Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Gaithersburg, MDThe pilot’s spatial disorientation after the passenger door opened during flight in instrument meteorological conditions. Contributing to the accident was the pilot’s failure to properly secure the door latch.Mar 15, 2009 · N213CP · Substantial damage