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 BFO94LA122Accident · No injuriesLimited investigationFinal reportBeech C23 · Easton, MDThe flight instructor's inadequate supervision, resulting in a hard landing and a subsequent collapse of the nose gear. Also causal to the accident, was the student pilot's improper raising of the wing flaps during the landing flare.NTSB BFO94LA107Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Forest Hill, MDThe loss of engine power during for undetermined reasons.NTSB NYC94LA097Accident · Serious injuriesLimited investigationFinal reportBell 47G3 Soloy · Friendsville, MDThe partial failure of the turbine engine for undetermined reasons, during an agriculture maneuver at low altitude, over terrain unsuitable for an autorotation.NTSB BFO94FA082Accident · No injuriesField investigationFinal reportCessna A150L · Leonardtown, MDImproper use of carburetor heat by the pilot, which resulted in loss of engine power due to carburetor ice. A contributing factor was the presence of carburetor icing conditions.NTSB BFO94LA077Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Westminster, MDThe pilot's failure to maintain adequate airspeed, which resulted in an aerodynamic stall and the inflight loss of control. A factor is the pilot's failure to do a go around.NTSB BFO94FA073Accident · 4 fatalField investigationFinal reportBeech B24R · College Park, MDthe pilot's improper flare and delayed recovery from the bounced landing. Factors contributing to the accident were the pilot's failure to retract the landing gear during the aborted landing; the exceeded allowable gross weight; and the unfavorable wind…NTSB BFO94LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hagerstown, MDThe loss of partial engine power for undetermined reasons.NTSB BFO94FA043Accident · Serious injuriesField investigationFinal reportBeech C35 · Rockville, MDThe pilot's inadequate aircraft preflight inspection which resulted in a loss of engine power due to fuel contamination.NTSB BFO94LA035Accident · No injuriesLimited investigationFinal reportRobinson R-22A · Gaithersburg, MDThe pilot's failure to maintain rotor RPM which led to an in flight loss of control resulting in a collision with the runway and the helicopter rolling over on its side. A factor in this accident was the pilot's lack of total experience flying helicopters.NTSB BFO94FA005Accident · 2 fatalField investigationFinal reportCessna 152 · Walkersville, MDImproper planning/decision by the instructor pilot (CFI) by teaching stalls and slow flight to a pre-solo student on a dark night, and the instructor's failure to maintain (or regain) control of the airplane, due to spatial disorientation. Factor's related to…NTSB NYC94LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Centreville, MDThe loss of engine power for undetermined reasons.NTSB NYC94LA006Accident · No injuriesLimited investigationFinal reportCessna T210F · Frederick, MDThe mechanic's inadequate inspection and the pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, resulting in a loss of engine power and a forced landing.NTSB BFO93FA169Accident · 2 fatalField investigationFinal reportCessna A150 · Greenbelt, MD1) The pilot's poor judgement in buzzing a residential area, 2) his failure to maintain an airspeed above the aerodynamic stalling speed, which led to a stall/spin, and 3) the inability of the pilot to take remedial action and recover from the stall/spin due…NTSB BFO93FA153Accident · Serious injuriesField investigationFinal reportMooney M20J · Mitchellville, MDCorrosion in the fuel control unit, which resulted in fuel starvation and loss of engine power. Related factors were: inadequate maintenance, and the lack of suitable terrain for an emergency landing.NTSB BFO93FA147Accident · No injuriesField investigationFinal reportMooney M20B · Landover, MDFatigue failure of a propeller blade, which resulted in severe engine vibration and subsequent damage to the airplane. The lack of suitable terrain for a forced landing was a related factor.NTSB BFO93FA119Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Berlin, MDFailure of the pilot to maintain airspeed during pullup from an attempted banner pickup, which resulted in a stall.NTSB BFO93FA129Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · California, MDThe pilot initiating VFR flight in instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, his lack of sleep, and the existing weather conditions.NTSB NYC93LA132Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Mitchellville, MDThe failure of the pilot to maintain a proper glide path during the final approach, which resulted in the airplane striking a moving vehicle.NTSB NYC93LA116Accident · No injuriesLimited investigationFinal reportGritter Quest AIR 20 · Baltimore, MDThe failure of the left main gear tire which resulted in a loss of directional control and collision with a taxiway sign.NTSB BFO93FA093Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201 · Hancock, MDImproper planning/decision by the pilot, his initiation of VFR flt into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation. Factors related to the accident were fog, rain, the pilot's self induced…NTSB BFO93LA078Accident · No injuriesLimited investigationFinal reportde Havilland DH-82A · Frederick, MDInadequate preflight by the pilot and fuel contamination, which resulted in loss of engine power.NTSB BFO93FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Edgewater, MDThe pilot's improper in-flight planning/decision after selecting the wrong runway for a precautionary landing , which resulted in an inadvertent descent into transmission lines, while attempting to maneuver back to the runway. Factors related to the accident…NTSB BFO93LA045Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Hillsboro, MDFailure of the pilot to maintain airspeed, while performing aerobatic maneuvers, which resulted in an inadvertent flat spin and an uncontrolled descent into terrain.NTSB BFO93LA024Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-5 · Lanham, MDThe blockage of the right and left fuel vent line which prevented the flow of fuel to the engine causing total power loss.NTSB NYC93LA057Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Hagerstown, MDThe failure of the flight instructor to adequately supervise the student pilot, and take control of the airplane in a timely manner which resulted in the airplane departing the runway and striking a tower. Factors related to the accident were the improper use…NTSB BFO93FA016Accident · 1 fatalField investigationFinal reportBeech C-45G · Elkridge, MDFailure of the pilot to properly secure the cargo, which allowed a shift in the center of gravity during a missed approach maneuver and resulted in subsequent loss of aircraft control and flying speed. A factor related to the accident was failure of the pilot…NTSB NYC93GA025Accident · Serious injuriesFinal reportSchweizer 269C · Baltimore, MDA power loss of undetermined origin. Factors related to the accident were the night conditions, the lack of a suitable landing area, and the inability of the pilot to maintain rotor RPM while maneuvering to avoid obstacles.NTSB BFO92LA142Accident · No injuriesLimited investigationFinal reportCessna 172N · Havre De Grace, MDThe pilot's improper use of carburetor heat control resulting in a total loss of engine power. Factors contributing to the accident include the existence of weather conditions conducive to carburetor icing and the rough terrain on which the aircraft was…NTSB BFO92LA134Accident · No injuriesLimited investigationFinal reportCessna 150G · New Market, MDThe pilot's in-flight planning/decision was inadequate resulting in fuel exhaustion.NTSB NYC92LA184Accident · Minor injuriesLimited investigationFinal reportWilliam C. Keiling Prober Pixie · Cumberland, MDAn inadvertent stall/spin, following a power loss due to fuel contamination. Factors related to the accident were the failure of the pilot to detect the rust particles and water in the fuel system prior to takeoff and his lack of total experience in the…NTSB NYC92LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Baltimore, MDA power loss due to fuel starvation from a faulty rubber seal in the mechanical fuel pump while operating over unsuitable terrain. An additional cause was the use of inadequate standards for the production of the rubber seal.NTSB NYC92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Farmington, MDThe pilot's improper level off which resulted in a hard landing. Contributing was an inadeuate recovery from a bounced landing, and the pilot's lack of total flight experience.NTSB BFO92LA092Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Chestertown, MDCarburetor ice, due to the pilot's improper use of carburetor heat. Factors related to the accident were: carburetor icing (weather) conditions, and obstructions (houses and utility pole) in the emergency landing area.NTSB BFO92LA087Accident · No injuriesLimited investigationFinal reportPiper J3C · Frederick, MDThe pilot's improper use of carburetor heat resulting in the formation of carburetor ice. Carburetor icing weather conditions was a factor.NTSB NYC92FIG01Accident · 1 fatalFinal reportTierra II · Williamsport, MDThe pilot's alcoholic impairment of efficiency and judgement resulting in a loss of control of the airplane during a forced landing following a power loss for an undetermined reason.NTSB NYC92LA132Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ocean City, MDThe pilot's inadequate visual look out for objects while taxing.NTSB NYC92LA114Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Elkton, MDThe pilot's failure to maintain the proper climb attitude which resulted in an aerodynamic stall. Factors in this accident were: the airplane weight and balance was exceeded, the pilot's lack of total experience in the type of airplane, and his lack of recent…NTSB NYC92LA112Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Indian Head, MDThe pilot improperly compensated for the wind conditions and lost control of the airplane after touchdown which resulted in the airplane departing the runway. An additional cause of the accident was, the delayed remedial action on the part of the flight…NTSB NYC92LA108Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Woodbine, MDThe student pilot's failure to maintain directional control of the glider during takeoff, which resulted in a ground loop. Factors related to the accident were the student's lack of total flight experience, the instructor's lack of flight experience in this…NTSB NYC92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Denton, MDThe failure of the pilot to detect the automobile gasoline in the tanks prior to departure, and intentional refueling with improper fuel by the pilot's brother which resulted in a lose of engine power due to detonation and loss of oil pressure.NTSB NYC92FA093Accident · 3 fatalField investigationFinal reportCessna 172N · Brookeville, MDImproper inflight planning/decision by the flight instructor (pic/cfi) in the Cessna 172, his misjudgement of distance between the two airplanes, and inadequate visual lookout by both pilots in the Cessna 172.NTSB BFO92FA058Accident · 3 fatalField investigationFinal reportCessna 177 · Lusby, MDA failure of the carburetor resulting in a loss of engine power.NTSB BFO92FA050Accident · 1 fatalField investigationFinal reportMooney M20E · Adamstown, MDFailure of the pilot to maintain control of the airplane.NTSB BFO92FA044Accident · 2 fatalField investigationFinal reportCessna 172P · Accokeek, MDThe pilot experienced spatial disorientation which resulted in loss of control of the airplane.NTSB BFO92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Stevensville, MDThe certificated flight instructor's (cfi's) inadequate supervision during the simulated emergency landing. Soft terrain in the touchdown area was a related factor.NTSB BFO92FA031Accident · 2 fatalField investigationFinal reportCessna 210K · Frederick, MDThe pilot's improper IFR operation and descent below the ILS glideslope and decision height, which resulted in an inflight collision with trees. The weather condition and lack of a recent weather briefing were related factors.NTSB NYC92LA066Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-12D · Gibson Island, MDThe pilot's failure to maintain proper altitude and clearance with water, which resulted in an in flight collision with water. Contributing to the accident was the pilot allowed the airplane to descend while making a right turn.NTSB BFO92TA#01Accident · No injuriesFinal reportMcdonnell Douglas 369E · Clinton, MDNTSB BFO92LA028Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Baltimore, MDThe failure of the fuel line, for undetermined reasons, resulting in a fuel leak causing an engine fire and total power loss.NTSB BFO92IA017Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Baltimore, MDImproper installation of the low fuel pressure warning switch snubber on the #1 engine, resulting in fatigue failure of the snubber, a fuel leak (spray), and subsequent explosion/fire damage. A factor related to the incident was: inadequate design of the…