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 IAD01LA055Accident · No injuriesLimited investigationFinal reportCessna 152 · Easton, MDThe pilot's improper landing flare. A factor was the crosswind.NTSB IAD01LA052Accident · No injuriesLimited investigationFinal reportPiper J3-C65 · Annapolis, MDpilot's failure to maintain directional control during landing. A factor was the crosswind.NTSB NYC01LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hagerstown, MDThe pilot's failure to maintain runway alignment during the landing phase. A factor in the accident was a sudden change in wind direction and speed.NTSB NYC01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mitchellville, MDA loss of engine power for undetermined reasons.NTSB NYC01LA049Accident · No injuriesLimited investigationFinal reportCessna 182J · College Park, MDThe pilot's inadequate flare, which resulted in a hard landing. A factor related to the accident was the downdraft wind conditions.NTSB NYC01LA038Accident · No injuriesLimited investigationFinal reportCessna 172K · Hagerstown, MDThe pilot's failure to remove the gust lock from the control column before takeoff, and his failure to abort the takeoff.NTSB NYC01LA025Accident · No injuriesLimited investigationFinal reportCessna 172M · Camp Springs, MDThe pilot's improper in-flight decision to operate close behind a large airplane at the same altitude, which resulted in a wake turbulence encounter.NTSB NYC00LA235Accident · No injuriesLimited investigationFinal reportCessna 150F · Friendly, MDThe pilot's inability to locate the airport, which resulted in fuel exhaustion. A factor related to the accident was the night light conditions.NTSB NYC00LA233Accident · Serious injuriesLimited investigationFinal reportGrooms Titan Tornado · Libertytown, MDAn engine seizure due to improper reconditioning of piston/cylinder after a previous seizure. A factor was the unsuitable terrain, to which, the forced landing was made.NTSB NYC00LA204Accident · No injuriesLimited investigationFinal reportBoeing PT17 · Easton, MDThe pilot's failure to maintain aircraft control.NTSB NYC00LA198Accident · Serious injuriesLimited investigationFinal reportWarrington Surrel Guppy · Churchville, MDThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Factors in this accident were an open canopy and a decrease in engine power.NTSB NYC00LA192Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Westminster, MDthe delayed corrective action by the flight instructor. Factors were the failure of the private pilot to maintain directional control, his failure to use the brakes, and the lack of brakes on the right side for the flight instructor.NTSB IAD00LA058Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Annapolis, MDThe pilot's failure to attain the proper touchdown point, and his failure to perform a go-around.NTSB IAD00LA061Accident · No injuriesLimited investigationFinal reportCessna 172H · Friendly, MDthe student pilot's inadequate compensation for winds that resulted in his failure to maintain runway alignment and a hard landing.NTSB IAD00FA044Accident · 1 fatalField investigationFinal reportKurzenburger Stuka JU-87 · Urbana, MDThe pilot's failure to obtain/maintain aircraft control after takeoff.NTSB NYC00LA134Accident · 1 fatalLimited investigationFinal reportHing FLY Baby 1A · Keymar, MDAn overload failure of both flying wires, on the underside of the right wing, while the airplane was climbing, due to improper balance between the two flying wires, by unknown person(s).NTSB NYC00LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA18-150 · Forest Hill, MDThe pilot's failure to maintain directional control while landing. Factors in this accident were the tailwind condition, and the pilot's lack of flight experience in tail-wheeled airplanes.NTSB NYC00LA075Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Kennedyville, MDThe pilot inadvertently stalling the airplane while turning final.NTSB IAD00FA034Accident · No injuriesField investigationFinal reportTaylorcraft BC12D-4-85 · Dameron, MDThe failure of the float landing gear system due to non-standard repairs, improper modifications, and corrosion.NTSB IAD00IA026Incident · No injuriesIncident investigationFinal reportBoeing - Canada DHC-8-102 · Baltimore, MDthe missing elevator stop bumper that resulted in elevator over-travel and damage to the elevator. A factor in the incident was the abrupt release of the elevator control lock in windy conditions.NTSB IAD00FA024Accident · 1 fatalField investigationFinal reportCessna 337 · Prnce Frederick, MDwas the pilot's failure to maintain control of the airplane after a loss of engine power on one engine. Factors in the accident were the pilot/owner's failure to follow the published emergency procedure, his inadequate fuel management, and his intentional…NTSB NYC00LA045Accident · Minor injuriesLimited investigationFinal reportCessna TR 182 · Clarksville, MDDeer that entered the runway environment while the pilot was executing a takeoff.NTSB NYC00LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Annapolis, MDThe pilot's failure to adequately adjust engine power to compensate for the winds on final approach.NTSB NYC00LA034Accident · Serious injuriesLimited investigationFinal reportBates Kitfox · Westminster, MDThe pilot's failure to maintain aircraft control while maneuvering.NTSB NYC00LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Rising Sun, MDThe PIC CFI's improper planning/decision to perform a downwind takeoff. A factor in this accident was the tail wind condition.NTSB NYC00LA009Accident · Minor injuriesLimited investigationFinal reportGrumman G164 · Burkittsville, MDThe vehicle drivers inadequate lookout.NTSB NYC00LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, MDThe failure of the number 3-cylinder exhaust valve stem due to fatigue cracking.NTSB IAD99FA070Accident · Serious injuriesField investigationFinal reportCessna 310Q · Salisbury, MDThe improper installation of the #2 cylinder that resulted in a fractured crankshaft and a total loss of engine power. Factors in the accident were the premature deployment of the landing gear and flaps by the pilot.NTSB IAD99FA069Accident · Serious injuriesField investigationFinal reportCessna 150M · Ellicott City, MDthe flight instructor's failure to follow the balked landing procedure in the owner's manual by retracting the flaps from 40 degrees to zero degrees.NTSB IAD99LA068Accident · No injuriesLimited investigationFinal reportCessna 172P · Friendly, MDThe pilot's misjudgment of speed during the landing approach. The inoperative airspeed indicator was a contributing factor.NTSB NYC99LA232Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT17 · Westminister, MDThe pilot's failure to maintain control of the airplane while taxiing.NTSB NYC99LA192Accident · No injuriesLimited investigationFinal reportBeech A36 · Westminster, MDThe pilot-in-command's failure to maintain aircraft control while landing.NTSB NYC99LA191Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Frederick, MDThe pilot's failure to maintain directional control. Contributing factors were gusty wind conditions and the sign.NTSB IAD99FA051Accident · No injuriesField investigationFinal reportCessna 172P · Gaithersburg, MDwas the pilot's failure to obtain the proper rotation speed and his subsequent loss of directional control. A factor in the accident was the improper setting of the elevator trim.NTSB NYC99FA161Accident · 1 fatalField investigationFinal reportPiper J3C-85 · Dawson, MDThe pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, downdraft, and the pilot's decision to operate at a weight in excess of the maximum allowable gross weight.NTSB NYC99FA160Accident · Serious injuriesField investigationFinal reportPiper J3C-65 · Dawson, MDwas the pilot's improper decision to turn toward rising terrain with inadequate terrain clearance. Factors were the density altitude, and unfavorable winds.NTSB NYC99LA153Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Rising Sun, MDThe failure of the connecting rod end bolts, due to an overtemperature condition.NTSB IAD99LA049Accident · No injuriesLimited investigationFinal reportKucki Pitts S-1S · Mitchellville, MDwas the loss of braking action on the left side due to a broken brake caliper.NTSB NYC99LA134Accident · 1 fatalLimited investigationFinal reportSaliba Long EZ · Friendly, MDThe separation of the airplane canopy for undetermined reasons, the diminished controllability of the airplane, and the pilot's failure to maintain airspeed resulting in a stall/mush into trees short of the runway.NTSB IAD99LA047Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Ocean City, MDWas the pilot leaving the magneto switch in the on position while hand rotating the propeller.NTSB NYC99LA120Accident · No injuriesLimited investigationFinal reportCessna 172N · Churchville, MDThe pilot's failure to maintain directional control during the takeoff roll. Factors were the pilot's lack of recent experience, and the crosswind.NTSB IAD99LA042Accident · No injuriesLimited investigationFinal reportCessna 182K · Baltimore, MDwas the pilot's improper remedial action when he improperly used the elevator during the landing flare.NTSB NYC99LA101Accident · Serious injuriesLimited investigationFinal reportBeech BE-C23 · Annappolis, MDThe pilot's failure to perform a go-around and he landed long resulting in an overrun. A factor in the accident was the night light conditions.NTSB NYC99FA096Accident · 1 fatalField investigationFinal reportSellors Searey · Selby Beach, MDThe pilot's failure to maintain aircraft control during the landing sequence, which resulted in the airplane contacting the water in a nose low attitude.NTSB NYC99LA084Accident · No injuriesLimited investigationFinal reportCessna 150 · Leonardtown, MDThe pilot's failure to maintain control of the airplane during a crosswind landing.NTSB IAD99LA022Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Easton, MDThe failure of both the pilot-in-command (CFI) and dual student of the other aircraft (Pitts) to maintain adequate visual lookout.NTSB IAD99FA020Accident · 1 fatalField investigationFinal reportBurgess RV-6 · Edgewater, MDThe pilot's failure to maintain adequate altitude/clearance from the trees. Contributing to the accident was the pilot's unfamiliarity with the geographic location and dark night conditions.NTSB IAD99LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Essex, MDA loss of engine power for undetermined reasons. Factors were the lack of suitable terrain for a forced landing and dark night conditions.NTSB IAD99LA014Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Baltimore, MDAn inadvertent collision with a deer on the runway. A contributing factor was night conditions.NTSB IAD99GA013Accident · 1 fatalFinal reportSchweizer 269C · Baltimore, MDinadequate assembly instructions from the engine manufacturer which resulted in improper engine assembly, and subsequent power loss over unsuitable terrain, with insufficient altitude for a successful autorotation.