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 NYC99LA021Accident · No injuriesLimited investigationFinal reportCessna 172M · Cumberland, MDThe pilot's decision to land, instead of performing a go-around.NTSB IAD99FA005Accident · 1 fatalField investigationFinal reportCessna R172K · Bowie, MDThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Also causal was the pilot's poor in-flight planning/decision, and his continued VFR flight into instrument meteorological conditions. A related factor was the fog.NTSB IAD99LA009Accident · No injuriesLimited investigationFinal reportCessna 150L · Clinton, MDThe student pilot's improper flare and improper recovery from a bounced landing.NTSB NYC98LA186Accident · No injuriesLimited investigationFinal reportCessna 180 · Lakeshore, MDFailures of the right float's nose wheel do to a preexisting fatigue crack.NTSB IAD98LA099Accident · No injuriesLimited investigationFinal reportMooney M-20C · Kent Island, MDthe pilot's improper takeoff technique and his failure to abort the takeoff.NTSB IAD98LA098Accident · No injuriesLimited investigationFinal reportCessna 150L · Cumberland, MDThe pilot in command's improper recovery from a bounced landing.NTSB IAD98FA086Accident · 2 fatalField investigationFinal reportConsolidated-Vultee BT-13A · Stevensville, MDThe pilot-in-command's failure to maintain aircraft control while buzzing a building.NTSB NYC98LA141Accident · Minor injuriesLimited investigationFinal reportChampion 7GCG · Neavitt, MDThe pilot's failure to maintain control of the airplane.NTSB NYC98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Westminster, MDthe pilot's misjudgment of distance and speed during the approach/landing, and his delay in initiating a go-around. The quartering tailwind was a related factor.NTSB IAD98FA070Accident · 1 fatalField investigationFinal reportCessna 172N · Ocean City, MDThe pilot's failure to maintain control of the aircraft due to spatial disorientation. Contributing factors wer fog, dark night conditions, lack of recent experience, inadequate preflight planning, and flight into known adverse weather.NTSB IAD98LA071Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Edgemere, MDThe pilot's inadequate in-flight planning/decision which led to fuel exhaustion.NTSB IAD98FA059Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Fort Washington, MDThe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with trees.NTSB NYC98LA109Accident · Minor injuriesLimited investigationFinal reportDeberry Marquart MA-5 · Westminster, MDFailure of a fuel line fitting which led to an engine failure and fire. A factor was the lack of suitable terrain for the forced landing.NTSB IAD98FA049Accident · 2 fatalField investigationFinal reportFairchild Hiller FH-1100 · Stevensville, MDThe pilot's abrupt, low-g maneuver, which resulted in mast bumping and separation of the main rotor system.NTSB IAD98LA045Accident · No injuriesLimited investigationFinal reportCessna 172N · Stevensville, MDthe pilot's improper flare, improper recover from a bounced landing, and failure to maintain directional control.NTSB NYC98FA041Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Pittsville, MDthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision and flight in instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude while flying over wooded terrain. Factors…NTSB NYC98LA040Accident · No injuriesLimited investigationFinal reportCessna 172P · Mitchellville, MDThe pilot's improper recovery from a bounced landing.NTSB NYC98LA029Accident · Serious injuriesLimited investigationFinal reportBeech E33A · Westminster, MDthe pilot's improper in-flight planning/decision, his misjudgment of speed and distance while on final approach to land, and his delay in aborting the landing after failing to attain a proper touchdown point for landing.NTSB NYC98LA026Accident · No injuriesLimited investigationFinal reportCessna 172M · Salisbury, MDThe student pilot's improper flare which resulted in a hard landing.NTSB NYC98LA008Accident · No injuriesLimited investigationFinal reportBoeing Stearman PT-17 · Elkton, MDThe inadequate lookout by the pilot of the Cessna and his failure to maintain adequate clearance between his airplane and the active runway. A factor in the accident was the lack of taxiway hold signs or lines.NTSB IAD98FA001Accident · Serious injuriesField investigationFinal reportPiper PA-32-260 · College Park, MDThe pilot failed to maintain control of the airplane during landing rollout and his delayed decision to abort the landing.NTSB IAD97LA121Accident · Minor injuriesLimited investigationFinal reportPohlman/Pohlman Rotorway Exec 90 · Westminster, MDThe loss of power due to carburetor icing. A factor to this accident was the carburetor heat was not accessible from within the cockpit.NTSB IAD97FA112Accident · 3 fatalField investigationFinal reportClassic YMF-5 · Ocean City, MDThe pilot performed an aerobatic maneuver at a low altitude, which resulted in an inadvertent stall/spin.NTSB NYC97LA157Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Easton, MDan inadequate weld repair, which resulted in insufficient structural strength of the left main gear.NTSB IAD97LA102Accident · 1 fatalLimited investigationFinal reportLardas Renegade Spirit · Boonsboro, MDThe pilot's failure to maintain control of his homebuilt airplane during a low level maneuver after a loss of engine power due to undetermined reasons. A factor in the accident was the pilot's alcohol impairment.NTSB NYC97GA148Accident · Serious injuriesFinal reportSchweizer 269C · Baltimore, MDA total loss of engine power which was a result of incomplete and improper engine overhaul by company maintenance personnel. A factor in the accident was the unsuitable forced landing area terrain.NTSB NYC97FA118Accident · 2 fatalField investigationFinal reportCessna 152 · Edgewater, MDThe pilot's excessive maneuver at a low altitude, and the flight instructor's inadequate supervision of the pilot, which resulted in an inadvertent stall/spin.NTSB IAD97LA087Accident · No injuriesLimited investigationFinal reportCessna 152 · Cambridge, MDThe student pilot's failure to properly recover from a bounced landing.NTSB NYC97LA113Accident · No injuriesLimited investigationFinal reportCessna 182N · Frederick, MDThe private pilot's improper flare, and the certificated flight instructor's delayed decision to add power, which resulted in the subsequent hard landing.NTSB IAD97LA086Accident · Minor injuriesLimited investigationFinal reportLuscombe LL-8-A · Annapolis, MDthe pilot's failure to use carburetor heat, which resulted in accumulation of carburetor ice and subsequent loss of engine power. Related factors were: carburetor icing conditions, and trees in the emergency landing area.NTSB NYC97LA110Accident · No injuriesLimited investigationFinal reportWaco YMF · Ocean City, MDThe pilot's failure to maintain directional control and his improper compensation for the wind conditions. Contributing factors were the lack of recent experience in the airplane, and gusty wind conditions.NTSB NYC97LA102Accident · No injuriesLimited investigationFinal reportCessna 150 · Elkton, MDThe pilot's failure to maintain directional control, which resulted in the airplane veering right, and striking trees.NTSB NYC97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Preston, MDThe pilot's improper flare during a precautionary landing, which resulted in a hard landing. A factor in the accident was the failure of the left magneto, which resulted in a partial loss of engine power.NTSB NYC97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Baltimore, MDthe pilot's inadequate preflight of the airplane which failed to detect water in the fuel, and resulted in a power loss after departure due to fuel contamination.NTSB IAD97LA072Accident · No injuriesLimited investigationFinal reportCessna 172H · Westminister, MDThe pilot misjudged landing distance on the runway and his failure to perform a go-around.NTSB IAD97LA063Accident · No injuriesLimited investigationFinal reportCessna 172N · Annapolis, MDThe pilot's failure to raise the flaps during the go-around. Factors involved were the high wind conditions and the pilot's failure to remove the carburetor heat.NTSB IAD97LA062Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Woodbine, MDThe pilot misjudged his altitude during approach.NTSB NYC97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarksville, MDThe pilot's failure to maintain directional control and failure to abort the takeoff.NTSB NYC97LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Nanjemoy, MDthe pilot's inadequate compensate for the wind conditions and failure to maintain adequate obstacle clearance during the initial climb after takeoff. The unfavorable wind condition and proximity of trees were related factors.NTSB IAD97FA038Accident · 1 fatalField investigationFinal reportCessna 150F · Bittinger, MDVFR flight by the noninstrumented-rated pilot into instrument meteorological conditions (IMC), which lead to spatial disorientation of the pilot, his loss of aircraft control, and an uncontrolled collision with the terrain. Factors relating to the accident…NTSB NYC97LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Baltimore, MDthe student pilot's premature rotation and inadequate supervision by the flight instructor (CFI), which resulted in failure of the flight crew to obtain adequate airspeed during takeoff for a proper rate of climb. Trees at the departure end of the runway were…NTSB IAD97FA024Accident · Serious injuriesField investigationFinal reportCessna 182P · Fort Washington, MDLoss of engine power for undetermined reason(s).NTSB IAD97LA016Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Gaithersburg, MDthe pilot's inadequate preflight, and his failure to detect an insufficent fuel supply, which resulted in fuel exhaustion and a forced landing after takeoff. Uneven terrain (drop-off in the emergency landing area) was a related factor.NTSB NYC97LA007Accident · Serious injuriesLimited investigationFinal reportCessna 310Q · Pasadena, MDthe pilot's inadequate preflight planning/preparation and inadequate management of the airplane's fuel supply, which resulted in fuel exhaustion and a forced landing at night. Factors related to the accident were: an inaccurate fuel quantity indicating…NTSB IAD97FA001Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Brandywine, MDThe pilots failure to maintain his assigned altitude in IFR conditions. A related factor was the failure of the radar controller to prevent the descent of N2881W to an altitude below the minimum vectoring altitude. Additionally, the controller's failure to…NTSB IAD96LA155Accident · Serious injuriesLimited investigationFinal reportMerritt Acro Sport II · Cumberland, MDThe pilot's failure to select the electric fuel boost pump during take off which resulted in loss of engine power due to fuel starvation and the subsequent forced landing. A factor to this accident was the owner/builder alteration of the fuel system by…NTSB IAD96LA146Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Westminster, MDthe pilot's misjudgement of his speed and distance, his failure to attain the proper touchdown point during the landing, and his delay in executing a go-around (aborted landing), which resulted in an overrun.NTSB IAD96LA140Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Frederick, MDthe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in a stall and collision with the terrain.NTSB IAD96LA139Accident · Minor injuriesLimited investigationFinal reportAmerican AA-5 · Annapolis, MDfailure of the pilot to maintain adequate airspeed after takeoff, which resulted in a stall and subsequent collision with water.NTSB IAD96FA136Accident · 2 fatalField investigationFinal reportBellanca 8KCAB · Elkton, MDThe pilot's failure to maintain adequate altitude and control of the airplane while performing aerobatic maneuvers.