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 ERA11CA178Accident · No injuriesData collectionFinal reportIniziative Industriali Italian SKY Arrow 600 Sport · Ridgely, MDThe pilot's failure to compensate for crosswind conditions and loss of directional control during landing, resulting in a runway excursion and nose over.NTSB ERA11LA141Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Baltimore, MDAn in-flight overload failure of the left elevator inboard balance weight rib for undetermined reasons.NTSB ERA11CA087Accident · Minor injuriesData collectionFinal reportSchweizer SGS 1-23D · Aberdeen, MDThe pilot's loss of control during an intentional aerobatic maneuver (spin) resulting in a collision with trees.NTSB ERA11CA061Accident · No injuriesData collectionFinal reportCessna 172N · Gaithersburg, MDThe student pilot's inadequate use of the rudder, and subsequent loss of directional control.NTSB ERA11CA052Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cambridge, MDThe commercial pilot’s inadequate flare during landing and the certificated flight instructor's delayed remedial action, which resulted in a hard landing.NTSB ERA11CA045Accident · No injuriesData collectionFinal reportEvolution Revo · Gransonville, MDThe pilot's improper recovery from a bounced landing and the certificated flight instructor's inadequate remedial action, which resulted in an aerodynamic stall during a go-around.NTSB ERA10CA467Accident · Minor injuriesData collectionFinal reportLuscombe 8A · Churchville, MDThe pilot’s failure to ensure that the fuel valve was in the "ON" position during his preflight inspection, resulting in the loss of engine power during takeoff.NTSB ERA10CA460Accident · No injuriesData collectionFinal reportCessna 177B · Ocean City, MDThe pilot's improper recovery from a bounced downwind landing.NTSB ERA10CA468Accident · No injuriesData collectionFinal reportCessna 172S · Frederick, MDUndetermined.NTSB ERA10CA441Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Oakland, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA10LA400Accident · No injuriesLimited investigationFinal reportDayton JD-2 · Hollywood, MDThe pilot's improper installation of the propeller hub to the engine crankshaft, which resulted in a loss of engine thrust.NTSB ERA10CA369Accident · No injuriesData collectionFinal reportCessna 152 · Indian Head, MDThe pilot's loss of control while landing in gusting crosswind conditions.NTSB ERA10LA375Accident · No injuriesLimited investigationFinal reportCessna 182 · Crisfield, MDThe pilot's delayed decision to abort the takeoff, which resulted in a runway excursion.NTSB ERA10CA350Accident · No injuriesData collectionFinal reportCessna 172S · Salisbury, MDThe student pilot's improper recovery from a bounced landing.NTSB ERA10CA305Accident · No injuriesData collectionFinal reportCessna 172S · Baltimore, MDThe pilot’s improper flare, which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to land during a thunderstorm.NTSB ERA10TA197Accident · Minor injuriesFinal reportCessna 182P · Frederick, MDA loss of engine power for undetermined reasons following a reported severe turbulence encounter.NTSB OPS10IA014Incident · No injuriesIncident investigationFinal reportBoeing 737 · Worton, MDThe R10/12 controller issued an improper vector and descent clearance to the GII that put the airplane on a coverging flight path with the B737. Contributing to the incident was the failure of the FAA's training program to correct ongoing controller…NTSB ERA10LA189Accident · No injuriesLimited investigationFinal reportCessna 120 · Annapolis, MDA loss of engine power for undetermined reasons.NTSB ERA10CA183Accident · No injuriesData collectionFinal reportPiper PA-30 · Baltimore, MDThe pilot's inadvertent retraction of the landing gear during a touch-and-go landing. Contributing to the accident was the pilot's lack of recent experience in the make and model airplane.NTSB ERA10CA155Accident · No injuriesData collectionFinal reportSocata TBM 700 · Gaithersburg, MDThe pilot’s failure to maintain aircraft control while performing a go-around.NTSB ERA10FA154Accident · 1 fatalField investigationFinal reportBeech P35 · Edgewater, MDThe pilot's failure to maintain adequate airspeed while on approach, which resulted in an inadvertent stall. Contributing to the accident was the pilot's likely impairment due to back pain, symptoms of opiate withdrawal, or both.NTSB ERA10TA142Accident · No injuriesFinal reportEurocopter AS 365 N2 Dauphin · Cheverly, MDIncomplete clearing of snow from the helipad and vicinity. Contributing to the accident was the lack of a NOTAM regarding the presence of snow banks and the pilot's failure to ensure that the helicopter was clear of a snow bank prior to departure.NTSB ERA10CA109Accident · Serious injuriesData collectionFinal reportSchweizer 269C-1 · Grantsville, MDThe pilot's loss of aircraft control after encountering turbulence over a mountain range. Contributing to the accident was the pilot's failure to obtain an Airmet for turbulence along the route of flight prior to departure and while enroute.NTSB ERA09LA491Accident · Minor injuriesLimited investigationFinal reportMyers Donald E Kitfox 4 · Flintstone, MDA total loss of engine power due to the lack of sufficient lubrication and the pilot/owner’s failure to adequately service the airplane’s engine.NTSB ERA09LA448Accident · 2 fatalLimited investigationFinal reportKociemba Robert H T-Bird II · Keymar, MDThe pilot's failure to maintain adequate airspeed following a total loss of engine power due to fuel contamination.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 ERA09CA386Accident · No injuriesData collectionFinal reportChampion 7AC · Westminster, MDThe pilot's failure to properly set the throttle for start.NTSB ERA09CA350Accident · No injuriesData collectionFinal reportBeech C17B · Stevensville, MDThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB ERA09CA300Accident · No injuriesData collectionFinal reportTecnam P2002 · Stevensville, MDThe pilot's failure to maintain proper airspeed on final approach, which resulted in an aerodynamic stall.NTSB ERA09CA297Accident · No injuriesData collectionFinal reportCessna 172 · Perryville, MDA total loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate preflight planning.NTSB OPS09IA004Incident · No injuriesIncident investigationFinal reportBE20 · Camp Springs, MDThe failure of the ground controller to coordinate the runway crossings with the local controller and her failure to scan the runway prior to issuing the crossing instructions. Contributing to the incident was the combination of the front line manager/tower…NTSB DCA09FA048Accident · Serious injuriesField investigationFinal reportBoeing DC-10 · Baltimore, MDthe captain’s inappropriate control inputs following a firm landing, resulting in two hard nose-gear impacts before executing a go-around. Contributing to the inappropriate control inputs was the captain’s fatigue and physical discomfort; and a possible lack…NTSB ERA09LA269Accident · No injuriesLimited investigationFinal reportCessna 208 · Frederick, MDA loss of engine power due to the failure of one or more compressor turbine blades for an undetermined reason.NTSB 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.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 ERA09CA172Accident · No injuriesData collectionFinal reportCessna 182S · Westminster, MDThe pilot's failure to stop the airplane within the available runway after touchdown.NTSB ERA09CA077Accident · No injuriesData collectionFinal reportCessna 172I · Frederick, MDThe student pilot's delayed decision to abort the landing.NTSB ERA09CA059Accident · No injuriesData collectionFinal reportMooney M20R · Indian Head, MDThe pilot's failure to maintain directional control while landing in gusting winds.NTSB ERA09CA041Accident · Serious injuriesData collectionFinal reportCessna 172 · Frederick, MDThe passenger’s failure to avoid the rotating propeller after exiting the airplane. Contributing to the accident was the pilot’s failure to include deplaning procedures as part of the passenger safety briefing.NTSB ERA09LA057Accident · No injuriesLimited investigationFinal reportCampbell Earl S JR RV-6A · Cambridge, MDThe failure of the RV-6A's right brake assembly o-ring due to excessive heat.NTSB MIA08MA203Accident · 4 fatalClass 1 · MajorFinal reportAerospatiale SA365N-1 D · District Heights, MDThe pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…NTSB NYC08CA313Accident · No injuriesData collectionFinal reportDiamond Aircraft Industry DA 20-C1 · Stevensville, MDThe student pilot's failure to maintain directional control during takeoff.NTSB NYC08LA310Accident · 1 fatalLimited investigationFinal reportDufault Mark V Pitts S-1D · Ridgely, MDThe pilot's inadequate preflight weather evaluation which resulted in an attempted landing in fog and subsequent impact with terrain.NTSB NYC08LA291Accident · No injuriesLimited investigationFinal reportCessna 441 · Baltimore, MDThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the pilot's attempted takeoff with a propeller start lock inadvertently engaged.NTSB NYC08CA284Accident · No injuriesData collectionFinal reportFerree Prostar B · Salisbury, MDThe pilot's improper flare which resulted in a hard landing.NTSB NYC08CA257Accident · Minor injuriesData collectionFinal reportCessna 172S · Stevensville, MDThe flight instructor's inadequate remedial action following the student pilot's improper recovery from a bounced landing.NTSB NYC08CA248Accident · No injuriesData collectionFinal reportCessna 172N · Edgewater, MDThe pilot's misjudged distance/speed during landing.NTSB NYC08CA230Accident · No injuriesData collectionFinal reportCessna 172 SP · Stevensville, MDThe flight instructor's delayed decision to go around.NTSB NYC08CA227Accident · No injuriesData collectionFinal reportNord Stampe SV4C · Taneytown, MDThe pilot's misjudgment of the airplane's altitude during the final approach.NTSB ANC08CA051Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Stevensville, MDThe pilot's misjudged speed/distance during landing.