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 CHI91DEX03Accident · No injuriesFinal reportCessna 320F · Washington, INExceeding the aircraft's proper descent rate by the pilot in command. Factors related to the accident were inoperative runway edge lights, proper alignment not attained, improperly planned approach, and inadequate facility maintenance.NTSB CHI91DEP07Accident · No injuriesFinal reportCessna 182M · Wissota, WIThe pilot in command's misjudgment of the proper touchdown point during an emergency landing and the pilot in command's failure to refuel the airplane.NTSB BFO91DIA01Accident · Serious injuriesFinal reportHagaman Pitts Pitts S · Warrenton, VAThe pilot misjuded altitude and clearance above the terrain. Contributing to the accident was aerobatic maneuver performed at low altitude.NTSB ANC91LA069Accident · No injuriesLimited investigationFinal reportCessna 206 · Kahiltna River, AKThe pilot's excessive descent and lack of familiarity with the aircraft. Contributing to the accident was the soft condition of the sand bar.NTSB ANC91FA067Accident · Serious injuriesField investigationFinal reportPiper PA-18-150 · Wasilla, AKThe powerplant failure for undetermined reasons and the collision with the wires.NTSB SEA91LA128Accident · No injuriesLimited investigationFinal reportEnstrom F280C · Baggs, WYExhaust valve failure, resulting in a partial power loss. Contributing factors were low altitude and rough/uneven terrain.NTSB NYC91LA151Accident · No injuriesLimited investigationFinal reportAerofab 4/210 · Paulding, OHThe improper installation of the oil filter by the pilot which resulted in a leak and subsequent oil exhaustion.NTSB LAX91LA249Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Huron, CAThat unknown pilot(s) impoperly used the throttle control which caused an overspeed condition. Contributing to this accident was the connecting rod bolt fatigue failure.NTSB LAX91LA248Accident · Serious injuriesLimited investigationFinal reportBell 206B · Lihue, HIFuel exhaustion. Factors related to the accident was the failure of the pilot-in-command to ensure that sufficient fuel was available for the flight.NTSB LAX91FA251Accident · 1 fatalField investigationFinal reportVarga 2150A · Livermore, CAAn inflight collision with terrain for undetermined reasons.NTSB DEN91LA080Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Santa Fe, NMA forward aft pilot seat adjustment locking mechanism failure.NTSB CHI91DEP06Accident · No injuriesFinal reportAvid Flyer Avid Flyer · Endeavor, WIThe pilot in command's inability to effectively eliminate carburetor ice to avoid an emergency landing.NTSB ATL91FA108Accident · 2 fatalField investigationFinal reportCessna T37B · Chickamauga, GAThe T-37 pilot misjudged the clearance between his aircraft and the A-26.NTSB SEA91LA126Accident · Serious injuriesLimited investigationFinal reportBoeing 737-3G7 · Elko, NVAn unsecured cart. The factors to the accident were: turbulent weather conditions, and poor judgement by the flight attendant.NTSB NYC91IA137Incident · No injuriesIncident investigationFinal reportBoeing 727-214 · Boston, MAThe failure of the third stage turbine blade on the number two engine, due to high cycle fatigue.NTSB LAX91LA250Accident · Minor injuriesLimited investigationFinal reportEagle DW-1 · Stockton, CAFailure of the pilot to maintain an adequate visual outlook to detect power transmission wires in his flight path resulting in an abrupt maneuver and subsequent inadvertent stall.NTSB LAX91FA247Accident · 1 fatalField investigationFinal reportCessna C-172 · Lakeside, CAThe failure of the pilot to request radar assistance to avoid low ceilings in high terrain and the pilot's inadequate visual outlook which ultimately resulted in an inflight collision with high terrain. Contributing to the accident were the weather conditions…NTSB FTW91LA093Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Angleton, TXThe pilot's loss of consciousness due to a pre-existing infection.NTSB CHI91LA182Accident · No injuriesLimited investigationFinal reportCessna 310L · Fort Wayne, INThe improper installation of a bearing by maintenance personnel.NTSB CHI91FA181Accident · 2 fatalField investigationFinal reportCessna U206F · Muskegon, MIInadequate remedial action by the pilot after exhausting all the fuel from a selected fuel tank. Factors associated with the accident are the pilots inadequate transition and upgrade training and a lack of familiarity with the accident airplane.NTSB CHI91DER04Accident · No injuriesFinal reportBellanca Eagle DW-1 · Hector, MNThe loss of engine power due to the total failure of a connecting rod. Related factors are the low maneuvering altitude and the unsuitable (muddy) terrain encountered during the forced landing.NTSB ANC91LA066Accident · No injuriesLimited investigationFinal reportCessna 207A · Eek, AKWas fuel contamination. Contributing factors are the engine vibrations and the rough vegetation upon which the airplane landed.NTSB MIA91FA160Accident · 1 fatalField investigationFinal reportPiper PA38-112 · South Port, FLThe pilot in commands failure to maintain a safe altitude resulting in an inflight collision with electrical lines.NTSB LAX91LA246Accident · No injuriesLimited investigationFinal reportCessna 182 · Lincoln, CAThat the pilot-in-command improperly flared the airplane by misjudging the altitude and improper recovery from the bounced landing.NTSB LAX91LA245Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Williams, AZThat the flight encountered windshear and that aircraft control was not possible.NTSB FTW91LA091Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Peach Orchard, ARThe pilot's failure to maintain adequate main rotor RPM resulting in deteriorated helicopter performance. A factor was the tailwind condition.NTSB CHI91LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Pulaski, WIThe pilot's failure to select a proper touchdown point. A factor in the accident was inadequate runway maintenance by airport personnel.NTSB CHI91DEE06Accident · No injuriesFinal reportRobinson R22B · Mineral, ILFailure of the pilot to maintain clearance from the power line.NTSB ATL91LA107Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Spring Creek, NCThe pilot's inadequate preflight planning/preparation, and his failure to attain adequate airspeed to avoid obstructions and terrain, which resulted in a stall/mush. Factors related to the accident were: the unfavorable wind, obstructions, and terrain…NTSB ANC91LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Naknek, AKThe pilot's failure to maintain directional control during the attempted takeoff. Contributing to the accident was the rough takeoff area and the trees along the side of the takeoff area.NTSB LAX91LA287Accident · No injuriesLimited investigationFinal reportCessna C-U206B · Novato, CAThe pilot improperly used the mixture control, failed to attain the airspeed and delayed in aborting the takeoff.NTSB LAX91FA242Accident · 1 fatalField investigationFinal reportCessna C-A150L · Cottonwood, CAThe pilot's intentional low pass during which he performed an aerobatic maneuver with inadequate airspeed. Contributing factors were the pilot's low altitude and the tailwind condition which created the visual perception to the pilot of having an airspeed…NTSB FTW91LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Lawtell, LAThe pilot's exceeding the performance capability of the airplane. A factor was turbulence.NTSB ATL91LA106Accident · Minor injuriesLimited investigationFinal reportGlaser-Dirks DG-200 · Marshallville, GAThe pilot's failure to maintain airspeed and the inadvertent stall/spin. A factor was the loss of thermal lifting action.NTSB NYC91LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Dushore, PAThe pilot landed with excessive airspeed, which resulted in ineffective braking and a loss of control.NTSB MIA91LA159Accident · No injuriesLimited investigationFinal reportCessna 152 · Pensacola, FLThe pilot-in-command's improper flare and recovery from a bounced landing resulting in a hard landing and collapse of the nose landing gear.NTSB LAX91LA241Accident · No injuriesLimited investigationFinal reportCessna 172M · Crescent City, CAThe failure of the pilot to employ proper flight control positioning to maintain control of the airplane during taxi.NTSB LAX91LA240Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Stockton, CAThat the pilot-in-command used poor preflight planning, inflight decision, and fuel consumption calculations. Contributing to this accident was fuel exhaustion.NTSB DEN91LA078Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Fayetteville, ARThe pilot failed to apply carburetor heat.NTSB DEN91FA079Accident · 2 fatalField investigationFinal reportCessna 210M · Colorado City, TXThe pilot continuing flight into known adverse weather conditions and exceeding the design stress limits of the aircraft. Factors were: thunderstorm, updrafts and the pilot's disregard of the weather briefing.NTSB ANC91LA064Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll. The unfavorable wind was a related factor.NTSB SEA91LA125Accident · No injuriesLimited investigationFinal reportCessna C-182A · Buhl, IDThe intentional high speed buzzing by the pilot, and his failure to maintain clearance from obstacles on the ground.NTSB SEA91LA123Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · St. Xavier, MTThe pilot's improper use of the fuel system, and the overfilling of the fuel tank. Contributing to the accident was: aerobatics performed, the pilot's inattention and the design of the fuel system.NTSB SEA91LA122Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Friday Harbor, WAThe pilot's poor preflight planning/preparation. Contributing to the accident were: the pilot did not maintain a proper clearance from an object, the pilot misjudged the wind conditions, and delayed remedial action.NTSB SEA91FA121Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12-D · Naches, WAThe in flight physical incapacitation of the pilot in command.NTSB NYC91LA150Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Tuckhannock, PAThe failure of the pilot to achieve a proper touchdown point. A factor related to the accident was the pilot's failure to make a go-around.NTSB NYC91LA147Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Rhinebeck, NYThe failure of the pilot to attain flying speed, resulting in an inadvertent stall. Factors related to the accident were: improper use of the flight controls by the pilot, and the pilot's decision to make the takeoff under the existing conditions.NTSB NYC91LA146Accident · No injuriesLimited investigationFinal reportCessna 120 · Delaware, OHCarburetor ice and the pilot in command's improper use of carburetor heat. A factor in the accident was the carburetor icing conditions.NTSB MIA91TL#04Accident · No injuriesClass 3Final reportHughes 369D · Fort Lauderdale, FLNTSB MIA91LA158Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · High Springs, FLLoss of engine power due to disintegration of the impeller caused by a worn impeller bearing.