NTSB investigations
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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 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 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 NYC01LA043Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Londonderry, NHThe pilot's failure to obtain the proper touchdown point.NTSB MIA01LA032Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Wewahitchka, FLa loss of engine power due to the number 5 cylinder connecting rod separating at the rod cap, resulting in a forced landing and subsequent impact with rough uneven terrain.NTSB MIA01LA031Accident · Serious injuriesLimited investigationFinal reportLake LA-4-200 · Iuka, MSa loss of engine power due to fuel contamination resulting in fuel starvation, a forced landing and the subsequent in-flight collision with a wire.NTSB MIA01LA030Accident · Serious injuriesLimited investigationFinal reportAerospatiale ATR-72-212 · Ashevelle, NCthe flight encountered forecasted turbulence, which resulted in serious injury to a flight attendant. Factors in this accident were; the captain's inadequate briefing to the cabin crew; and the insufficient information about the known turbulence that would be…NTSB MIA01FA029Accident · 1 fatalField investigationFinal reportAirbus Industrie A300B4-605R · Miami, FLThe failure of the flight crew to perform the cabin pressurization manual control abnormal checklist after experiencing a pressurization system malfunction and switching to manual pressurization control, and the failure of the flight crew to perform the…NTSB FTW01LA022Accident · No injuriesLimited investigationFinal reportCessna 172K · Belcher, LAthe total loss of engine power due to carburetor ice. Contributing factors were the weather conditions conducive to carburetor icing and the lack of suitable terrain available for the forced landing.NTSB LAX01LA045Accident · Serious injuriesLimited investigationFinal reportCollette Glassair III · Guistine, CAMaintenance personnel misrouted the crankcase breather hose so that it was pinched when the cowling was installed. This pressurized the crankcase displacing the oil seal and forcing oil out of the engine. A factor was the unsuitable terrain encountered during…NTSB DEN01LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Wendover, UTa forced landing to unsuitable terrain due to a loss of engine power as a result of carburetor icing. Factors were insufficient weather information regarding carburetor icing in the pilot's operating handbook for the aircraft and delay by the pilot in…NTSB NYC01LA041Accident · No injuriesLimited investigationFinal reportCessna 182Q · Blacksburg, VAThe pilot's improper flare while landing.NTSB IAD01LA014Accident · No injuriesLimited investigationFinal reportGick Aerocomp CA6WB · White Post, VAThe pilot's inadequate preflight. Also causal in the accident was the under-inflated tire that flattened and locked during landing, and collapsed the nose landing gear.NTSB DEN01LA015Accident · No injuriesLimited investigationFinal reportMurdock RAF 2000 GTX · Ogden, UTThe pilot's improper touchdown which resulted in a hard landing. Factors were lack of familiarity with the aircraft and lack of total experience.NTSB CHI01LA040Accident · No injuriesLimited investigationFinal reportCessna 150K · Minot, NDthe student pilot's inability to maintain aircraft control on the ground. Factors relating to the accident were the high winds, the slush-covered taxiway, the snowbank, inadequate preflight planning by the flight instructor, and the instructor pilot's failure…NTSB CHI01LA039Accident · No injuriesLimited investigationFinal reportAeronca 7CCM-200 · Corning, IAThe pilot did not adequately compensate for the wind conditions and the subsequent failure to maintain control of the airplane. Factors associated with the accident were the crosswind, the runway light, and the tree.NTSB CHI01LA035Accident · No injuriesLimited investigationFinal reportCessna 177RG · Wautoma, WIthe deer that traveled onto the runway and contacted the airplane. Factors associated with the accident were the night light conditions and the light snow that was falling.NTSB SEA01LA023Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Stevensville, MTFatigue of the right propeller blade resulting in an in-flight separation of the blade tip. A contributing factor was the improper maintenance procedure.NTSB SEA01LA020Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ontario, ORInadequate remedial action by the first pilot. The student pilot's improper flare while landing was a factor.NTSB SEA01FA021Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Ontario, OROverstress loading to the left wing lift strut resulting in the left wing folding upward during the initial climb.NTSB NYC01LA039Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Montauk, NYThe pilot's failure to maintain runway alignment during touchdown and rollout. Factors in the accident were the pilot's inadequate crosswind compensation, and inadequate flare.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 LAX01LA044Accident · No injuriesLimited investigationFinal reportCessna 140 · Sacramento, CAThe pilot's failure to maintain directional control on landing rollout.NTSB FTW01FA021Accident · 1 fatalField investigationFinal reportEurocopter AS350B2 · Houston, TXthe pilot's failure to maintain obstacle clearance while maneuvering, which resulted in an in-flight collision with objects. Contributing factors were the dark night and low ceilings.NTSB CHI01LA038Accident · No injuriesLimited investigationFinal reportCessna T210L · Madison, WIThe cause of the loss of engine power is undetermined. Factors in the accident included the fence and the localizer antennas.NTSB SEA01FA100Accident · 2 fatalField investigationFinal reportCessna U206F · Cambridge, IDAirspeed not maintained and an inadvertent stall while maneuvering. Mountainous terrain was a factor.NTSB MIA01TA237Accident · No injuriesFinal reportAerofab Lake Seawolf · Frostproof, FLThe failure of the instructor pilot and dual student to begin the water takeoff with adequate clearance from the lake shore for the dual student to complete the takeoff and the failure of the instructor pilot to recognize in a timely manner during the takeoff…NTSB MIA01FA028Accident · 1 fatalField investigationFinal reportLockheed-Martin F-16CG · Bradenton, FLthe failure of the F-16 flight lead pilot and F-16 accident pilot to maintain an adequate visual lookout while maneuvering. Factors contributing to the accident were: the F-16 flight lead pilot’s decision to discontinue radar traffic advisory service, the…NTSB LAX01LA043Accident · No injuriesLimited investigationFinal reportCessna 210K · Oxnard, CAFailure of the internal cam gear in the remanufactured engine. A factor was the congested obstacles in the forced landing area.NTSB NYC01WA037Accident · 1 fatalForeign investigationPiper PA-28-140 · Sherbrooke, CanadaNTSB LAX01LA042Accident · No injuriesLimited investigationFinal reportEurocopter AS 350B-3 · Mesa, AZThe dual student's misjudged landing flare and level off, which resulted in a heel first touchdown and subsequent hard landing during a practice autorotation. Also causal was the instructor pilot's inadequate supervision of the student.NTSB LAX01LA041Accident · 2 fatalLimited investigationFinal reportExperimental Glasair 1RG · Temecula, CAthe pilot's failure to maintain an adequate terrain clearance altitude while performing aerobatic maneuvers, which resulted in the in-flight collision with terrain.NTSB FTW01FA020Accident · 1 fatalField investigationFinal reportCessna 185F · Jena, LAThe pilot's decision to land on a highway with vehicle traffic and obstacles and his failure to maintain proper clearance from the obstacles.NTSB DCA01WA004Incident · No injuriesForeign investigationBoeing 757-200 · Copenhagen, DenmarkNTSB CHI01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Kalkaska, MIThe student pilot's failure to maintain aircraft control on the ground. Factors relating to this accident were the student pilot's improper abort procedures, the sign, and the ditch.NTSB ATL01LA010Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Everglades City, FLThe pilot's failure to maintain control of the aircraft during landing.NTSB SEA01LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Broadus, MTThe pilot's failure to maintain aircraft control during the takeoff phase of the flight.NTSB LAX01LA039Accident · No injuriesLimited investigationFinal reportMesserschmitt-Boelkow-Blohm BO-105CBS-5 · Parumph, NVThe pilot's failure to verify the presence of wires near the remote landing site during the high reconnaissance, and his misjudgement of the clearance from the ground during the attempted hovering turn to avoid the wire obstacle. Factors were the dark night…NTSB ANC01LA019Accident · No injuriesLimited investigationFinal reportCessna 180 · Clarks Point, AKThe pilot's excessive application of the brakes during landing roll. Factors associated with the accident were water on the runway, low tire pressure, a sheared tire valve stem, and a fractured landing gear axle.NTSB NYC01LA036Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Winchester, VAThe pilot's failure to obtain a pre-departure or en route weather briefing, which led to fuel exhaustion, after his destination and alternate airports were covered by fog. A factor was the fog.NTSB NYC01LA035Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Babylon, NYThe student pilot's inadequate use of the collective, and the instructor pilot's inadequate remedial action.NTSB MIA01WA027Accident · 2 fatalForeign investigationBeech E-90 · Reims, FranceNTSB DEN01LA014Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Longmont, COthe total failure of the left main gear strut during the landing roll. A contributing factor was the 6-foot high snow bank that the airplane impacted when it left the runway.NTSB ANC01LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-790 · Anchorage, AKAn in-flight encounter with clear air turbulence.NTSB SEA01LA018Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Great Falls, MTThe pilot's improper decision to land on unsuitable terrain. Factors include snow covered terrain.NTSB LAX01LA040Accident · No injuriesLimited investigationFinal reportCessna 150E · Marana, AZThe partial loss of engine power during cruise flight due to an improper maintenance adjustment to the float valve retractor clip of the carburetor. Factors were the lack of suitable terrain for a forced landing and high vegetation.NTSB DEN01FA013Accident · 1 fatalField investigationFinal reportCessna 175 · Hanksville, UTthe pilot's failure to maintain control of the airplane while maneuvering at low altitude, and his physical impairment due to alcohol and drugs. A contributing factor was the downdraft.NTSB MIA01LA026Accident · 1 fatalLimited investigationFinal reportJ and J Tukan · Hayesville, NCThe ultralight pilot's in-flight loss of control for unknown reasons resulting in an in-flight collision with the terrain.NTSB LAX01LA038Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Lake Elsinore, CAThe pilot's misjudged altitude approaching the airstrip and his failure to maintain airspeed resulted in the glider's collision with trees.NTSB CHI01LA037Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Kankakee, ILThe unsuitable terrain encountered by the pilot during the emergency landing. Factors to the accident were the loss of engine power due to the failure of the crankshaft, the pilot misjudging the descent glide path, and the presence of the highway embankment…NTSB ANC01LA020Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B2 · Girdwood, AKThe pilot's failure to maintain adequate altitude/clearance from terrain. A factor in the accident was flat light conditions.NTSB SEA01FA017Accident · 2 fatalField investigationFinal reportCessna 425 · Idaho Falls, IDThe pilot-in-command's failure to maintain adequate airspeed with an asymmetric thrust condition, resulting in a loss of aircraft control. A factor was an asymmetric engine thrust condition, which was present for undetermined reasons.NTSB IAD01FA013Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stuart, VAPilot's continued flight into known adverse weather conditions during cruise flight. Factors in the accident were the low ceiling, dark night, and the pilot's failure to obtain in-flight weather advisories.