NTSB investigations, MD
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
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' 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' 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 NYC04CA164Accident · No injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe pilot's improper flare during touch down, which resulted in a hard landing.NTSB IAD04FA021Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-60 · Ferndale, MDThe pilot's failure to maintain airspeed during a sharp turn, which resulted in an inadvertent stall and subsequent impact with terrain. Factors included the pilot's failure to fly to the intended point of landing, and his abrupt course reversal back towards…NTSB IAD04LA020Accident · No injuriesLimited investigationFinal reportTaylorcraft BC · Cumberland, MDThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall into transmission lines.NTSB NYC04LA082Accident · Minor injuriesLimited investigationFinal reportSocata TB-20 · Frederick, MDTotal loss of engine power for undetermined reasons.NTSB NYC04CA084Accident · No injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe student pilot's failure to maintain aircraft control while landing. A factor was the student pilot's lack of experience.NTSB NYC04CA073Accident · No injuriesData collectionFinal reportCessna 172N · Easton, MDThe student pilot's improper flare, which resulted in a hard landing.NTSB NYC04CA064Accident · No injuriesData collectionFinal reportCessna 172M · Cumberland, MDThe pilot's inadequate compensation for the crosswind while landing. A factor was the crosswind.NTSB IAD04CA009Accident · No injuriesData collectionFinal reportCessna 172R · Fredrick, MDThe student pilot's failure to maintain directional control during the landing. A factor was the snow bank.NTSB NYC04LA061Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · College Park, MDThe loss of hydraulic fluid due to chaffing of a brake line by a strut fairing rivet, resulting in the failure of the braking system.NTSB IAD04LA007Accident · No injuriesLimited investigationFinal reportPiper PA-25-180 · Baltimore, MDA loss of engine power for undetermined reasons. Factors included a low ambient temperature and a lack of suitable terrain for the forced landing.NTSB NYC04LA040Accident · No injuriesLimited investigationFinal reportBeech H-18 · Westminster, MDThe pilot's failure to maintain control of the airplane after a failure of one propeller system. Factors in the accident were the failure to perform maintenance inspection and the failure of a bolt in the left propeller blade system.NTSB NYC04CA022Accident · No injuriesData collectionFinal reportCessna 182M · Laytonsville, MDThe pilot's abrupt evasive maneuver to avoid the deer, which resulted in the loss of airspeed and an inadvertent stall.NTSB NYC04LA006Accident · 1 fatalLimited investigationFinal reportExtra Flugzeugbau EA-300L · Queen Anne, MDThe pilot's performance of aerobatic maneuvers with positive and negative Gs, which resulted in a G induced loss of control, and uncontrolled impact with the ground.NTSB NYC04CA005Accident · No injuriesData collectionFinal reportHoward DGA-15P · Leonardtown, MDThe pilot's failure to maintain directional control during an aborted landing.NTSB NYC03FA180Accident · 1 fatalField investigationFinal reportAero Vodochody L-39ZO · Forest Hill, MDThe pilot's in-flight decision to delay application of engine power to account for the engine's slow response to throttle input, which resulted in an inadvertent stall and subsequent collision with a residential area. A factor related to the accident was the…NTSB NYC03LA172Accident · Minor injuriesLimited investigationFinal reportMooney M20B · Leonardtown, MDA loss of engine power due to water contamination of the fuel. A factor was the fuel cap not being secured to the tank.NTSB NYC03LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Gaithersburg, MDThe student pilot's failure to maintain directional control during an aborted landing.NTSB NYC03LA139Accident · Minor injuriesLimited investigationFinal reportCessna 172K · White Marsh, MDThe pilot's in-flight decision to not land and refuel, which resulted in fuel exhaustion. A factor in the accident was the pilot's inadequate communications.NTSB NYC03LA128Accident · Minor injuriesLimited investigationFinal reportCessna 210L · Crisfield, MDThe pilot's inadequate recovery from a bounced landing and his improper flare which resulted in a hard landing. Contributing factors were the windshear and the crosswind.NTSB NYC03LA118Accident · No injuriesLimited investigationFinal reportAmerican Champion 7GCAA · Frederick, MDThe certified flight instructor's improper flare and his delayed remedial action. The pilot's failure to maintain directional control is a contributing factor.NTSB NYC03LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gaithersburg, MDThe pilot’s failure to maintain airspeed, resulting in an inadvertent stall.NTSB IAD03LA041Accident · Serious injuriesLimited investigationFinal reportAeronca CH-7A · Cumberland, MDThe pilot/mechanic's failure to ensure the proper installation of the left wing's aft strut-to-spar attachment bolt, which resulted in a loss of control and a subsequent impact with terrain.NTSB NYC03LA031Accident · No injuriesLimited investigationFinal reportBell 206B · Odenton, MDThe pilot's failure to monitor his fuel supply which resulted in a power loss due to fuel exhaustion, and the pilot's misjudged flare, which resulted in a hard landing.NTSB NYC03FA015Accident · 1 fatalField investigationFinal reportCessna 182S · Accident, MDThe pilots improper in-flight decision to continue flight into known adverse weather conditions. A factor related to the accident was the icing conditions.NTSB DCA03IA005Incident · No injuriesIncident investigationFinal reportBoeing 757-200 · Baltimore, MDThe captain's improper procedures regarding stall avoidance and recovery. Contributing to the incident were the partial blockage of the pitot static system, and the flight crew's improper decisions regarding their use of inaccurate airspeed indications.…NTSB NYC02LA191Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's delayed remedial action. A factor was the manufacturer's inadequate written guidance regarding simulated engine failures during takeoff.NTSB NYC02LA192Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Burtonsville, MDThe failure of the tailrotor gearbox for undetermined reasons.NTSB NYC02LA187Accident · No injuriesLimited investigationFinal reportBoeing 757-251 · Baltimore, MDThe captain's failure to follow existing company procedures for stabilized approach, and use of speed brakes.NTSB IAD02LA080Accident · Serious injuriesLimited investigationFinal reportCessna 172K · Patuxent River, MDThe pilot's inadequate fuel calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.NTSB IAD02FA075Accident · 1 fatalField investigationFinal reportBeech S-35 · Clear Spring, MDThe pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with rising terrain. Factors included dense fog and mountainous terrain.NTSB NYC02LA119Accident · Serious injuriesLimited investigationFinal reportMooney M20 · Hagerstown, MDThe pilot's failure to perform a go-around and obtain the proper touchdown point, which resulted in an overrun. A factor in the accident was the crosswind condition.NTSB IAD02FA052Accident · 1 fatalField investigationFinal reportAyres S-2R · Swanton, MDThe pilot's failure to maintain visual separation from a set of known, yet unmarked power lines.NTSB IAD02FA047Accident · No injuriesField investigationFinal reportBeech 400A · Baltimore, MDThe captain's failure to go around. Factors included the captain's preoccupation with the flight management system, the crew's failure to adhere to company standard operating procedures, and the lack of proper crew coordination.NTSB IAD02FA037Accident · 4 fatalField investigationFinal reportCessna 172P · Ocean City, MDThe pilot's spatial disorientation, which resulted in his subsequent loss of control of the airplane. A factor was the dark night, over water visual conditions.NTSB NYC02LA019Accident · 2 fatalLimited investigationFinal reportNorton/Cloeren Titan Tornado II · New Windsor, MDLoss of power for an undetermined reason.NTSB NYC01LA225Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Cumberland, MDThe pilot misjudged distance and altitude. A factor was the pilot's lack of familiarity with the glider.NTSB IAD01FA096Accident · 3 fatalField investigationFinal reportPiper PA-28RT-201 · Rohrersville, MDThe pilot's continued VFR flight into obscured, mountanous terrain. Factors included the rising terrain and weather obscuration.NTSB IAD01LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Odenton, MDImproper maintenance inspections, which resulted in a blocked carburetor.NTSB IAD01FA089Accident · 2 fatalField investigationFinal reportBell 206B · Baltimore, MDThe pilot's improper decision to maneuver in an environment conducive to a loss of tail rotor effectiveness, and his inadequate recovery from the resultant unanticipated right yaw.NTSB NYC01LA188Accident · No injuriesLimited investigationFinal reportCessna 172P · Odenton, MDA loss of engine power for undetermined reasons.NTSB NYC01LA186Accident · No injuriesLimited investigationFinal reportMooney M20J · Mitchellville, MDThe flight instructor's failure to maintain control of the airplane during an aborted landing, and her delay in remedial action. A factor related to the accident was the excessive trim setting.NTSB IAD01LA083Accident · No injuriesLimited investigationFinal reportCessna 150L · Lusby, MDThe student pilot's improper use of carburetor heat.NTSB NYC01LA177Accident · Serious injuriesLimited investigationFinal reportRaum Rans S-12 · Waldorf, MDFuel contamination. A factor related to the accident was the builder’s decision to not install fuel tank drains.NTSB NYC01LA164Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Friendly, MDA baffling failure within the exhaust system. Factors were an inadequate annual inspection and the pilot's operation of the airplane with known deficiencies in equipment.NTSB NYC01LA163Accident · No injuriesLimited investigationFinal reportCessna 172P · Stevensville, MDThe pilot's improper flare and his improper recovery from a bounced landing.NTSB NYC01FA158Accident · 1 fatalField investigationFinal reportMoravan Zlin 526F · Queen Anne, MDThe pilot's failure to maintain airspeed during an aerobatic maneuver, which resulted in an inadvertent inverted spin.NTSB NYC01LA160Accident · No injuriesLimited investigationFinal reportChek Avid Mark IV · Salisbury, MDThe pilot's failure to maintain airplane control. Factors were the quartering tailwind, and the improper rebuild of the left main landing gear with a reduced size brace.NTSB IAD01LA072Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Berlin, MDpilot's failure to maintain directional control during landing roll. A factor was the crosswind.NTSB IAD01LA062Accident · No injuriesLimited investigationFinal reportEaa Chapter 40 Cubby Sport Trainer · Elkton, MDThe Cubby pilot's inadequate visual lookout for the Bellanca on the runway, prior to landing.NTSB NYC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-22-135 · Clinton, MDThe pilot's failure to maintain directional control during landing rollout. Factors related to the accident were the pilot's lack of experience in tail-wheeled airplanes, and the wind gusts.