NTSB investigations, MD
29 cases where NTSB found Object/animal/substance.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2012 | 1 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 5 |
| 2018 | 3 |
| 2019 | 1 |
| 2020 | 2 |
| 2021 | 1 |
| 2022 | 3 |
Where
Open the mapLatest 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\", '030220'))
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" = '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", '030220')) 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 ERA23LA071Accident · Serious injuriesClass 3 · LimitedFinal reportMooney M20J · Gaithersburg, MDThe pilot’s visual flight below published altitude minimums, which resulted in collision with a powerline tower structure.NTSB ERA22LA429Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Ocean City, MDThe pilot’s failure to maintain directional control of the airplane while landing with a crosswind, resulting in the runway excursion and nose over.NTSB ERA22LA176Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177RG · Gaithersburg, MDThe pilot’s failure to maintain adequate airspeed while maneuvering on final approach which resulted in a high sink rate and subsequent collision with a fence.NTSB ERA22LA044Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Stevensville, MDAn in-flight collision with a bird during initial climb.NTSB ERA20CA260Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Whitehall, MDThe pilot's failure to maintain adequate clearance from a known obstacle while landing from a hover.NTSB ERA20CA095Accident · No injuriesData collectionFinal reportCessna 208 · Baltimore, MDThe pilot's failure to maintain clearance from the approach lights during an instrument approach.NTSB GAA19CA468Accident · No injuriesData collectionFinal reportCessna 172 · Gaithersburg, MDThe other pilot's failure to maintain clearance from the airplane while taxiing.NTSB ERA18LA269Accident · No injuriesLimited investigationFinal reportRobinson R44 · Westminster, MDThe pilot's attempt to move the helicopter from a sloped surface after an overspeed event, which resulted in a loss of helicopter control and impact with a car. The overspeed event resulted from misrouted and damaged wiring in the magneto, which subsequently…NTSB GAA18CA505Accident · No injuriesData collectionFinal reportCessna 172 · Churchville, MDThe pilot's failure to maintain directional control after landing left of the runway centerline, which resulted in a runway excursion and impact with a power box.NTSB ERA18LA098Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR20 · Churchville, MDThe pilot's improper landing flare, which resulted in the airplane ballooning on touchdown, and his subsequent failure to maintain directional control during the attempted landing and subsequent go-around.NTSB 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.NTSB GAA17CA443Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Berlin, MDThe ground crewman’s failure to visually check the runway before crossing it in a vehicle, which resulted in he and the vehicle being struck by the landing airplane.NTSB ERA17FA211Accident · 1 fatalField investigationFinal reportBuckeye Powered Parachutes Dream Machine 582 · Federalsburg, MDThe pilot's failure to maintain aircraft control during takeoff, which resulted in a collision with power lines. Contributing to the accident was the pilot's lack of experience in powered parachutes.NTSB ERA17CA162Accident · No injuriesData collectionFinal reportCub Crafters CC11 100 · Leonardtown, MDThe pilot's improper landing flare, which resulted in a bounced landing, and his subsequent failure to maintain directional control when he initiated a go-around.NTSB GAA17CA205Accident · No injuriesData collectionFinal reportCessna 172 · Baltimore, MDThe student pilot’s failure to maintain clearance from other airplanes in the run-up area.NTSB GAA16CA423Accident · No injuriesData collectionFinal reportBeech F33 · Bivalve, MDThe pilot's excessive airspeed during landing, which resulted in a runway overrun, and impact with a ditch.NTSB ERA15LA135Accident · No injuriesLimited investigationFinal reportCessna 208 · Baltimore, MDThe ground service vehicle operator's failure to yield right of way to the airplane due to distraction, which necessitated the pilot's use of reverse thrust and braking to avoid a collision and resulted in the airplane's empennage striking the ground.NTSB DCA15CA037Accident · No injuriesData collectionFinal reportBoeing 737 · Baltimore, MDan inadvertent encounter with birds during approach to land that resulted in substantial damage.NTSB ERA14CA258Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Stevensville, MDThe student pilot's failure to maintain directional control of the airplane during the takeoff roll.NTSB ERA14CA039Accident · No injuriesData collectionFinal reportTaylorcraft BC 65 · Fallston, MDThe pilot's failure to maintain directional control during landing resulting in collision with equipment off the side of the runway. Contributing to the accident was the pilot's intentional landing on a closed runway with a tailwind.NTSB ERA13CA425Accident · No injuriesData collectionFinal reportLennox Kenneth J Zodiac 601HDS · Salisbury, MDThe pilot's inadequate compensation for the wind conditions while landing.NTSB ERA13CA423Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Ridgely, MDThe flight instructor's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall and collision with terrain.NTSB ERA13CA122Accident · Minor injuriesData collectionFinal reportAmirkhanian Shahram Charl Commander · Westminster, MDImpact with power lines due to the pilot’s obscured vision due to the low angle of the sun, which prevented the pilot from seeing the lines.NTSB ERA12CA416Accident · No injuriesData collectionFinal reportCessna 172M · Churchville, MDThe tractor operator's failure to confirm the landing airplane's position before entering an active runway, which resulted in a ground collision.NTSB ERA09FA417Accident · 4 fatalField investigationFinal reportRobinson Helicopter R44 · Boonsboro, MDThe pilot’s improper decision to depart on a visual flight rules (VFR) flight at night in adverse weather conditions in close proximity to rising mountainous terrain in a helicopter that was only certified to be operated under VFR and his subsequent failure…NTSB ERA09LA187Accident · Minor injuriesLimited investigationFinal reportDoyle-Michael Sonerai-II · Leonardtown, MDThe pilot's continued operation of the airplane with a known mechanical deficiency. Contributing to the accident was the improper installation of the electronic ignition system.NTSB ERA09CA059Accident · No injuriesData collectionFinal reportMooney M20R · Indian Head, MDThe pilot's failure to maintain directional control while landing in gusting winds.NTSB NYC08CA248Accident · No injuriesData collectionFinal reportCessna 172N · Edgewater, MDThe pilot's misjudged distance/speed during landing.NTSB ANC08CA051Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Stevensville, MDThe pilot's misjudged speed/distance during landing.