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 ERA14CA259Accident · No injuriesData collectionFinal reportBrantly B 2B · Essex, MDThe pilot's failure to maintain helicopter control during landing resulting in a hard landing and a roll over.NTSB ERA14LA252Accident · No injuriesLimited investigationFinal reportCessna 182 · Elkton, MDThe pilot’s failure to attain the proper touchdown point during a no-flap landing to a wet, down-sloping runway, and the airplane's dynamic hydroplaning after touchdown, which resulted in a runway overrun. Contributing to the accident was a total loss of…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 ERA14CA217Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Frederick, MDThe student pilot's failure to maintain directional control during the hover, and the flight instructors lack of remedial action, resulting in a dynamic rollover and structural damage to the helicopter.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 ERA14LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Ridgely, MDA total loss of engine power for reasons that could not be determined based on the available evidence.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 ERA13LA391Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Mitchellville, MDThe pilot’s failure to ensure that the wing flaps were properly configured before takeoff.NTSB ERA13CA383Accident · No injuriesData collectionFinal reportCessna 150L · Chestertown, MDThe student pilot's improper control inputs which resulted in a loss of control and aerodynamic stall. Contributing to the accident was the flight instructor's delayed remedial action.NTSB ERA13CA377Accident · No injuriesData collectionFinal reportCessna 172P · Mitchellville, MDThe pilot’s decision to depart with a known deficiency following a hard landing. Contributing to the accident was an anomaly of the airplane’s nosewheel steering that could not be replicated during post-accident examination.NTSB ERA13LA379Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe use of an improper nose landing gear through bolt, which decreased the overall strength of the gear and resulted in overload failure during a hard landing. Contributing to the accident was the student pilot's inadequate landing flare, which resulted in…NTSB ERA13LA361Accident · No injuriesLimited investigationFinal reportBryant Frederick M Rans S-12 · Vienna, MDThe student pilot’s inadequate control of the airplane, which resulted in an aerodynamic stall and subsequent impact with water.NTSB ERA13LA342Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Leonardtown, MDThe improper installation and inspection of the throttle linkage by maintenance personnel, which resulted in the throttle linkage coming loose and a subsequent partial loss of engine power.NTSB ERA13FA325Accident · Serious injuriesField investigationFinal reportBeech 23 · Laurel, MDThe pilot's inadequate preflight preparation of the airplane, which resulted in a total loss of engine power during takeoff and his decision to operate the unairworthy airplane.NTSB 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.NTSB ERA13CA305Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Stevensville, MDThe pilot's failure to maintain directional control during the takeoff. Factors in the accident were the pilot's over-rotation at takeoff, and his failure to abort the takeoff prior to the runway excursion.NTSB ERA13TA261Accident · No injuriesFinal reportBell 407 · Columbia, MDThe short circuit failure of a tantalum capacitor, internal to the engine’s electronic control unit, resulting in an uncommanded shutdown of the engine in flight.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 ERA13CA079Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Easton, MDThe pilot's failure to maintain directional control while landing.NTSB ERA12LA555Accident · Serious injuriesLimited investigationFinal reportPitcairn PA-4 · Rawlings, MDA total loss of engine power due to fuel starvation, which resulted from a fuel outlet in the fuel tank that was blocked by peeled debris from a previously approved fuel tank sealer.NTSB ERA12LA518Accident · No injuriesLimited investigationFinal reportMeyers OTW-160 · Worton, MDThe student pilot's improper landing flare and the flight instructor's inadequate remedial action, which resulted in a hard landing.NTSB ERA12FA465Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Berlin, MDPilot incapacitation of unknown origin, which resulted in the airplane’s loss of control and an inadvertent aerodynamic stall/spin.NTSB ERA12FA458Accident · 1 fatalField investigationFinal reportBeech A23 · Laytonsville, MDThe pilot’s failure to ensure that the fuel selector handle was correctly positioned, which resulted in an interruption of fuel to the engine and a loss of engine power during the takeoff, which necessitated a turn away from the trees at the end of the runway…NTSB ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.NTSB ERA12CA439Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB ERA12FA395Accident · 1 fatalField investigationFinal reportRemos Acft Gmbh Flugzeugbau Remos GX · Westminster, MDThe pilot's inadequate preflight inspection, which failed to ensure that the elevator quick-fastener was properly secured, resulting in an inflight elevator control disconnect and subsequent loss of control during the ensuing emergency landing. Contributing…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 ERA12IA166Incident · No injuriesIncident investigationFinal reportGulfstream G150 · Baltimore, MDThe pilot-in-command's failure to obtain the proper touchdown point or landing reference speed and failure to initiate a go-around when it became evident that the airplane was landing long and fast. Contributing to the incident was a lack of effective flight…NTSB ERA12CA080Accident · Serious injuriesData collectionFinal reportBeech V35 · Lusby, MDThe pilot did not maintain clearance from trees during a night approach.NTSB ERA12LA061Accident · Minor injuriesLimited investigationFinal reportCessna 172R · Frederick, MDThe student pilot’s inadequate directional control during the landing roll.NTSB ERA12CA042Accident · Minor injuriesData collectionFinal reportMoyes Bailey Dragonfly · Massey, MDThe pilot did not maintain airspeed during approach to landing, which resulted in an aerodynamic stall.NTSB ERA12FA002Accident · 1 fatalField investigationFinal reportTemco GC-1B · Ewell, MDThe pilot's improper fuel management in that he did not verify the fuel selector position before beginning the flight or after the power loss, which resulted in a total loss of engine power due to fuel starvation and subsequent ditching.NTSB ERA11CA516Accident · No injuriesData collectionFinal reportCessna 172S · Westminster, MDThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control. Contributing to the accident was the pilot's improper approach airspeed for a short-field landing.NTSB ERA11CA514Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Gaitherburg, MDThe pilot's inadequate recovery from a bounced landing, which resulted in a loss of airplane control.NTSB ERA11LA491Accident · No injuriesLimited investigationFinal reportCessna TR182 · Stevensville, MDThe pilot did not maintain directional control during the landing roll.NTSB ERA11CA486Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Gaithersburg, MDThe pilot's decision to continue taxiing with restricted windshield visibility.NTSB ERA11LA428Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Darlington, MDInadequate maintenance of the helicopter's landing gear dampers, which resulted in a main rotor out-of-balance condition and ground resonance encounter.NTSB ERA11FA413Accident · 1 fatalField investigationFinal reportMoyes Dragonfly · Ridgely, MDAn in-flight loss of control for reasons that could not be determined during postaccident examinations.NTSB ERA11FA401Accident · 1 fatalField investigationFinal reportSlingsby Capstan Type 49B · Hollywood, MDThe glider pilot’s improper response to the “check spoilers” signal from the tow pilot. Contributing to the accident was the glider pilot’s failure to confirm that the spoilers were closed and locked before takeoff, and the glider copilot’s improper crew…NTSB ERA11CA385Accident · No injuriesData collectionFinal reportCessna 172P · Baltimore, MDThe student pilot's failure to maintain aircraft control following a bounced landing.NTSB ERA11CA408Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB ERA11LA399Accident · No injuriesLimited investigationFinal reportCessna 182K · Stevensville, MDA total loss of engine power during initial climb for undetermined reasons.NTSB ERA11CA315Accident · No injuriesData collectionFinal reportMorrisey 2150A · Cambridge, MDThe pilot's loss of directional control during landing on a soft, turf runway.NTSB DCA11CA070Accident · Serious injuriesData collectionFinal reportDe Havilland DHC8 · Baltimore, MDan inadvertent encounter with clear air turbulence.NTSB ERA11CA304Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Stevensville, MDThe student pilot's improper flare which resulted in a hard landing, and the flight instructor's lack of remedial action.NTSB OPS11IA499Incident · No injuriesIncident investigationFinal reportBoeing 737 · Camp Springs, MDThe misapplication of wake turbulence and instrument flight rules (IFR) separation criteria by air traffic controllers.NTSB ERA11CA247Accident · Serious injuriesData collectionFinal reportBoeing 757-2B7 · Cheltenham, MDThe in-flight encounter with turbulence, resulting in an injury to a cabin attendant.NTSB ERA11CA248Accident · No injuriesData collectionFinal reportWalker J C Lancair 320 · Baltimore, MDThe pilot's improper recovery from a bounced landing.NTSB ERA11LA229Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Ridgely, MDThe pilot receiving instruction's inadequate compensation for the wind during landing and delay in executing a go-around, which resulted in a loss of airspeed, low final approach, and subsequent collision with the ground short of the runway. Contributing to…