NTSB investigations, MD
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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 IAD96LA130Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Gaithersburg, MDthe unexpected appearance of a deer on the runway.NTSB IAD96LA123Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Union Bridge, MDloss of engine power for undetermined reason(s).NTSB IAD96LA118Accident · No injuriesLimited investigationFinal reportCessna 172 · Frederick, MDthe private pilot's inadvertently stalling the airplane immediately after takeoff. A related factor was the pilot's improper procedures during lift-off.NTSB IAD96LA116Accident · 1 fatalLimited investigationFinal reportQuicksilver Sprint · Mt Airy, MDThe pilot's improper planning/decision and exceeding the design stress limits of the aircraft, which resulted in overload failure of the wing and subsequent uncontrolled collision with the terrain. Factors related to the accident were: the pilot's failure to…NTSB IAD96LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Salisbury, MDthe student pilot's failure to maintain directional control during the takeoff roll.NTSB IAD96LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cambridge, MDthe pilot's failure to maintain control of the airplane during landing. The crosswind was a factor.NTSB IAD96LA104Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Mitchellville, MDthe pilot's failure to maintain directional control of the aircraft during the landing roll. Related factors were the gusty crosswind conditions.NTSB IAD96LA101Accident · No injuriesLimited investigationFinal reportCessna 182P · White Marsh, MDThe pilot's improper flare which resulted in a hard landing. A related factor was the pilot's improperly planned approach.NTSB IAD96LA097Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Ashton, MDthe pilot's inadequate fuel supply which resulted in a fuel exhaustion and a loss of engine power. A related factor was the pilot's inadequate fuel consumption calculations.NTSB IAD96LA092Accident · No injuriesLimited investigationFinal reportBeech V35B · Westminster, MDThe fracture of the engine crankshaft which had a subsurface origin and progressed in fatigue until overload and separation occurred.NTSB IAD96LA086Accident · Minor injuriesLimited investigationFinal reportChampion 7FC · Stevensville, MDThe pilot's misjudgment of the amount of fuel he had onboard the airplane which resulted in an engine failure due to fuel exhaustion. Contributing to the severity of the accident was the high vegetation encountered during the forced landing which resulted in…NTSB IAD96FA085Accident · Minor injuriesField investigationFinal reportPiper PA-31-310 · Stevensville, MDThe pilot's improper short field takeoff/procedure and selection of the wrong runway for takeoff.NTSB IAD96LA082Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Clinton, MDthe pilot's failure to assure that an adequate supply of fuel was available for the flight. Related factors were the pilot's inadequate airplane preflight inspection and the unsuitable terrain (horses, fence, house, barn, trees) encountered during the landing…NTSB IAD96LA093Accident · No injuriesLimited investigationFinal reportCessna 177RG · Westminster, MDThe pilot-in-command's failure to maintain control of the airplane during landing. A factor in this accident was the CFI-rated pilot/passenger's inattention.NTSB IAD96LA083Accident · No injuriesLimited investigationFinal reportLithuanian Factory of LAK-12 · Woodbine, MDThe pilot's decision to fly with inadequate research of forecast weather.NTSB IAD96LA065Accident · No injuriesLimited investigationFinal reportCessna 150H · Clinton, MDa loss of engine power for undetermined reasons.NTSB BFO96LA038Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Hurlock, MDinadequate inspection by maintenance personnel which failed to detect a fatigue crack, and resulted in an in-flight crankshaft fracture and propeller assembly separation. A related factor was the deep snow encountered during the subsequent forced landing.NTSB BFO96LA033Accident · No injuriesLimited investigationFinal reportCessna 210 · Baltimore, MDfailure of the pilot to ensure that the landing gear was fully down and locked before landing.NTSB BFO96LA025Accident · No injuriesLimited investigationFinal reportSellors Kitfox IV · Pasadena, MDThe pilot's improper (abrupt) application of brakes during the landing roll. Factors relating to the accicent were: the pilot's failure to attain the proper touchdown point during the landing, and his lack of experience in the make and model of airplane.NTSB BFO96LA017Accident · No injuriesLimited investigationFinal reportCessna 177RG · College Park, MDthe main landing gear retracted for undetermined reasons.NTSB BFO96LA019Accident · No injuriesLimited investigationFinal reportCessna T210L · College Park, MDthe pilot's improper recovery from a bounced landing and his failure to initiate a go-around. Related factors were the crosswind and the pilot's concern about being late for meetings he had scheduled.NTSB BFO96LA014Accident · No injuriesLimited investigationFinal reportMooney M20E · Shady Side, MDthe partial loss of engine power due to a leaking fuel line.NTSB BFO96LA002Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Annapolis, MDthe pilot's improper planning/decision, and/or failure to go around while there sufficient airspeed and runway remaining during the approach/landing. Factors relating to the accident were: standing water on the runway, and resultant hydroplaning conditions.NTSB BFO95LA098Accident · No injuriesLimited investigationFinal reportCessna 182 · Annapolis, MDThe pilot's failure to maintain control of the airplane during the landing roll. Related factors were the sudden thunderstorm, the high gusty winds, and the sudden windshift to a tailwind during the touchdown/landing roll.NTSB BFO95LA095Accident · No injuriesLimited investigationFinal reportSnow S2A · Pasadena, MDthe pilot's inability to maintain directional control due to the failure of the right brake during the landing roll.NTSB BFO95LA080Accident · No injuriesLimited investigationFinal reportCessna 182F · Mitchellville, MDthe pilot's delay in aborting the takeoff.NTSB NYC95TA190Accident · Minor injuriesFinal reportSchweizer 269C · Baltimore, MDThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the ground.NTSB NYC95LA174Accident · Minor injuriesLimited investigationFinal reportSocata TB-10 · Damascus, MDThe pilot's inadequate inflight planning and fuel mismanagement, which resulted in fuel exhaustion.NTSB NYC95LA157Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Queenstown, MDfailure of the fuselage longeron tubes due to fatigue, which resulted in partial separation (distortion) of the fuselage, partial loss of aircraft control, and a partial loss of engine power.NTSB BFO95FA071Accident · 1 fatalField investigationFinal reportCessna 182P · Frederick, MDthe pilot's continued flight into known adverse weather during descent, which resulted in in-flight collision with terrain. Related factors were the pilot's disregard of a hazardous weather advisory, and the low ceilings, fog and drizzle.NTSB BFO95LA063Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Ft Washington, MDA loss of engine power for an undetermined reason(s).NTSB NYC95LA111Accident · No injuriesLimited investigationFinal reportRockwell 112B · Edgewater, MDThe pilot's improper decision to continue his flight into the adverse weather conditions that existed at the destination airport. The weather contributed to the accident.NTSB NYC95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Westminister, MDthe failure of the flight instructor to take timely remedial action during an approach, resulting in an inadvertent stall, hard landing and subsequent collapse of the landing gear. A factor related to the accident was the flight instructor's lack of…NTSB BFO95FA045Accident · 3 fatalField investigationFinal reportCessna 172M · Eldersburg, MDThe pilot's failure to maintain proper airspeed. Factors in the accident were the pilot's failure to remove carburetor heat during the go-around and the presence of a tailwind.NTSB BFO95LA044Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Finksburg, MDloss of engine power for undetermined reasons. A related factor was the lack of suitable terrain.NTSB BFO95LA036Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Oakland, MDthe student pilot's abrupt remedial action during the aborted landing attempt. Related factors are the student pilot's lack of total experience, inadequate airspeed and the low altitude.NTSB NYC95LA081Accident · No injuriesLimited investigationFinal reportCessna 172 · Mitchellville, MDThe pilot's failure to maintain directional control and the instructor's inadequate supervision. Related factors: high winds, and a crosswind.NTSB BFO95LA035Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Middle River, MDthe pilot's inadequate recovery from a bounced landing, which resulted in the nosegear collapsing. The pilot's improper landing flare was a factor in the accident.NTSB NYC95LA075Accident · No injuriesLimited investigationFinal reportCumberland-Pitts Special S1C · New Windsor, MDthe failure of the fuel pump diagram which resulted in fuel starvation and a subsequent forced landing.NTSB BFO95FA033Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Cambridge, MDthe commercial/instrument rated pilot's failure to obtain/maintain adequate altitude/clearance during the initial climb after takeoff. Related factors are the pilot's poor planning/decision making, and the fog.NTSB BFO95LA031Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Frederick, MDthe helicopter pilot's inadequate control of the aircraft during the attempted takeoff.NTSB BFO95LA024Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Stevensville, MDSeparation of the steering linkages on the nosegear which resulted in the pilot being unable to maintain directional control during landing and subsequent on ground collision with a ditch.NTSB BFO95LA022Accident · Serious injuriesLimited investigationFinal reportCessna 172C · Laurel, MDThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel.NTSB NYC94LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oakland, MDthe pilot's inadequate preflight planning and preparation in which the pilot attempted a high density altitude takeoff, up-slope, with the airplane over the maximum allowable gross weight, utilizing a rolling takeoff technique with an improper flap setting.…NTSB BFO94FA160Accident · 1 fatalField investigationFinal reportBeech A36 · Barstow, MDThe pilot's failure to maintain clearance from the tower.NTSB BFO94LA128Accident · Serious injuriesLimited investigationFinal reportHankins/Dickerson Clipped Wings II · Laurel, MDThe failure of the engine ignition system capacitor discharge unit which caused loss of total engine power.NTSB BFO94LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Edgewater, MDThe pilot's inadequate preflight inspection which failed to detect water contaminated fuel which resulted in fuel starvation.NTSB NYC94LA129Accident · Minor injuriesLimited investigationFinal reportPitts S-1S · Stevensville, MDInadequate maintenance by which undertorquing of the accessory gear retaining bolt resulted in fatigue failure of the bolt and the subsequent loss of engine power.NTSB NYC94LA117Accident · Serious injuriesLimited investigationFinal reportWSK PZL Wilga 80 · Churchville, MDImproper starting procedure by the pilot.NTSB NYC94LA109Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Princess Anne, MDThe pilot's failure to do a go-around and her delay in the initiating of an aborted landing, which resulted in her failure to outclimb trees during the aborted landing.