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 BFO94LA090Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA318C · Rassellas, PAThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and the lost of engine power. Factors in the accident were the pilot operating the helicopter with known deficiencies in equipment and no suitable terrain available for landing.NTSB ATL94LA114Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A · Lawrenceville, GAThe pilot's failure to maintain directional control during the landing. Factors which contributed to the accident were: the wet runway and the pilot's inattentiveness due to fatigue.NTSB SEA94LA152Accident · No injuriesLimited investigationFinal reportCessna T188C · Angela, MTDirectional control was not maintained. Factors to the accident were: wet terrain and inadequate aircraft preflight.NTSB LAX94LA238Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Valencia, CAthe pilot's selection of an unsuitable field for an off-airport landing and attempted takeoff.NTSB LAX94LA237Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Upper Lake, CAThe pilot's failure to maintain adequate airspeed during a go- around. Contributing factors were the pilot's delayed remedial action in initiating the go-around and his improper use of the carburetor heat during the attempted initial climb.NTSB FTW94LA193Accident · No injuriesLimited investigationFinal reportBell 47H-1 · Tulsa, OKThe pilot's failure to maintain rotor RPM, his delayed landing flare, and the improper touchdown.NTSB CHI94LA189Accident · 1 fatalLimited investigationFinal reportWaco UPF-7 · Good Hope, ILFailure of the pilot to maintain control of the aircraft, while maneuvering. A factor related to the accident was: the pilot's impairment due to use of a prescription drug that was not approved for use while flying.NTSB CHI94LA187Accident · No injuriesLimited investigationFinal reportBeech C-23 · Gary, INImproper preflight planning and preparation by the pilot-in-command which resulted in fuel exhaustion. A factor associated with the accident was the delay in emergency procedures by the pilot-in-command.NTSB BFO94LA089Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Troy, NYThe pilot's inadequate compensation for the wind conditions and failure to maintain alignment with the runway which resulted in an inflight collision with a tree. A factor is crosswinds.NTSB ATL94LA113Accident · Serious injuriesLimited investigationFinal reportBeech E18S · Laurens, SCThe loss of engine power on one engine followed by failure of the propeller to feather or be feathered.NTSB ANC94LA066Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Naknek, AKThe pilot's failure to maintain airspeed above the stall speed during maneuvering flight.NTSB ANC94LA064Accident · No injuriesLimited investigationFinal reportHiller FH1100 · Tyonek, AKThe pilot's selection of unsuitable terrain for landing which resulted in a dynamic rollover. A factor was the soft landing area selected.NTSB SEA94LA139Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Melba, IDThe pilot's inadequate remedial action, and his excessive brake application. Factors include improper recovery from a bounced landing, and a crosswind.NTSB FTW94LA188Accident · No injuriesLimited investigationFinal reportCessna 182H · Telluride, COWas the pilot's improper recovery from a bounced landing. Factors were gusty winds and runway downslope.NTSB CHI94LA188Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · New Paris, INthe pilot's inadequate visual lookout. Factors associated with the accident are a fence post, and the pilot's lack of familiarity with the geographic area (landing environment).NTSB BFO94LA087Accident · No injuriesLimited investigationFinal reportWSK PZL Krosno KR-03A · Morrisville, VTThe pilot's premature release from the tow plane. The lack of lift and the downdraft were factors.NTSB SEA94LA136Accident · No injuriesLimited investigationFinal reportAyres S2R · Burley, IDA loose carburetor. Factors include no suitable terrain for making a forced landing, and trees in the field where the forced landing took place.NTSB LAX94LA236Accident · 1 fatalLimited investigationFinal reportSharp Scorpion TOO · Beckwourth, CAthe failure of the tail rotor 'V' drive belt for undetermined reasons and the subsequent failure and separation of the tail rotor.NTSB LAX94LA235Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Chino, CAloss of aircraft control due to the pilot's failure to correctly configure the hydraulic system prior to takeoff.NTSB LAX94LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Simi Valley, CAThe student pilot's failure to properly align the airplane's flightpath over the runway during initial climb. A contributing factor was the student pilot's total lack of recent flying experience.NTSB CHI94DEM01Accident · No injuriesFinal reportGrumman G-164A · Muskegon, MIThe propeller not being able to be feathered by the pilot, inadequate altitude for a successful forced landing, and the failure of the combustion section. A factor associated with this accident was the stall/mush encountered by the pilot due to the…NTSB BFO94LA085Accident · 1 fatalLimited investigationFinal reportPecchio Marchetti 263MP · East Moriches, NYthe loss of control for undetermined reasons resulting in an uncontrolled descent and a subsequent collision with trees.NTSB BFO94LA084Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-260 · Montgomery, NYThe pilot's mismanagement of the fuel supply with an improper fuel selector position which resulted in fuel starvation and the loss of engine power. A factor is the instructor's inadequate supervision of the flight.NTSB BFO94FA086Accident · 1 fatalField investigationFinal reportCessna 150F · Bloomingburg, OHThe failure of the pilot-in-command to maintain adequate airspeed. This led to a stall during the initial takeoff and climb at an altitude that did not permit a recovery. A factor related to the accident was the presence of sunglare during the takeoff, which…NTSB ATL94LA112Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Summerdale, ALThe pilot's failure to maintain airspeed during takeoff.NTSB ATL94GA111Accident · No injuriesFinal reportGrumman G-164A · Savannah, GAThe pilot's improper landing flare which resulted in a hard landing. A factor was the operators failure to provide a formal emergency dump procedure.NTSB SEA94LA134Accident · Minor injuriesLimited investigationFinal reportKopp Kitfox II · Bremerton, WAThe pilot's inadequate remedial action. Factors include the pilot's failure to maintain directional control, and unfavorable winds.NTSB MIA94LA153Accident · 1 fatalLimited investigationFinal reportMaxair MU532 · Kissimmee, FLInadvertent stall/mush by the pilot-in-command resulting in the uncontrolled descent and collision with terrain.NTSB LAX94LA233Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Trinity Center, CAthe fatigue fracture of the crankshaft due to improper maintenance installation of the number 1 cylinder and the inadequate torquing of the case through bolts at that location.NTSB BFO94LA083Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-C · Fairfield, PAThe pilot-in-command's failure to maintain control of the airplane during the maneuver.NTSB ANC94LA063Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fairbanks, AKThe pilot's selection of an unsuitable landing area.NTSB ANC94LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKDirectional control not maintained by the pilot in command. A factor in the accident was the inadvertant ground loop/swerve.NTSB SEA94LA130Accident · Minor injuriesLimited investigationFinal reportLatter Christen Eagle II · Jackson Hole, WYThe failure of the pilot of the christen eagle ii, N246RL, to see and avoid the Cessna 172, N62463, and the pilot of the christen eagle ii diverting his attention from operation of his airplane.NTSB NYC94LA099Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Taunton, MAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A factor was unfavorable winds.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 MIA94LA152Accident · No injuriesLimited investigationFinal reportCessna 210L · Pahokee, FLThe improper positioning of the fuel selector valve by the pilot-in-command which caused an engine failure due to fuel starvation at an altitude too low for restart procedures.NTSB MIA94LA151Accident · No injuriesLimited investigationFinal reportCessna 150H · Sugarloaf Key, FLThe improper flare and improper recovery from a bounced landing by the pilot-in-command.NTSB LAX94LA231Accident · 1 fatalLimited investigationFinal reportCessna 172N · Roosevelt, AZthe pilot's selection of an inadequate terrain clearance altitude while maneuvering over a lake. A factor in the accident was the calm glassy water conditions which may have affected the pilot's perception of his actual height above the water.NTSB LAX94LA230Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Chino, CAThe right engine's failure for undetermined reasons to respond to throttle command during a go-around attempt, and both pilot's failure to maintain directional control of the aircraft. Inadequate supervision of the flight by the CFI is also considered a cause.NTSB LAX94FA232Accident · 2 fatalField investigationFinal reportBeech A-36 · Fullerton, CAthe pilot's lack of familiarity with the performance change of the airplane, and the lack of proper training/transition in the modified airplane. Contributing to the accident was inadequate substantiation process and insufficient review by the FAA; the…NTSB CHI94LA183Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bolivar, MOThe partial blockage of the carburetor's induction air opening by a plastic bag.NTSB NYC94LA098Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Burt, NYThe pilot's failure to maintain airspeed, resulting in an inadvertent stall and collision with trees.NTSB NYC94LA096Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Spring City, PAThe pilot's improper inflight planning and inaccurate fuel consumption calculations, resulting in fuel supply exhaustion, loss of engine power, and the subsequent collision with trees during a forced landing.NTSB LAX94LA229Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Calexico, CA1) the pilot's failure to correctly position the fuel selectors prior to takeoff, 2) the resultant fuel starvation failure of the left engine in the takeoff initial climb, and 3) the failure of the pilot to maintain directional control of the aircraft.NTSB LAX94LA228Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Sonoma, CAThe pilot's failure to attain the proper touchdown point and his failure to initiate a go-around.NTSB LAX94LA227Accident · Minor injuriesLimited investigationFinal reportPerth Amboy Bird BK · San Jose, CAthe separation of the right main landing gear axle from the gear strut for undetermined reasons related to component age.NTSB FTW94LA186Accident · No injuriesLimited investigationFinal reportDonner Pitts S-1 · Alvarado, TXThe pilot's improper compensation for wind conditions. A factor was the crosswind.NTSB CHI94LA186Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125-3A · Waukegan, ILwas the pilot-in-command disregarding the location of the flight manifest container in the cockpit. Factor's associated with the accident were a jammed control column and inadequate procedures for the use and storage of the flight manifest container on the…NTSB CHI94LA184Accident · No injuriesLimited investigationFinal reportCessna 150M · Concordia, KSthe pilot-in-command's misjudging of the altitude of the airplane and his diversion of attention during the landing. A factor was the improper use of the throttle by the pilot-in-command.NTSB ATL94FA110Accident · Serious injuriesField investigationFinal reportBeech 58P · Burnsville, NCThe failure of the pilot to attain a proper touchdown point, resulting in a long landing, and his delayed decision to go around. Factors were the mountainous conditions at the landing site, the existing tailwind, and the pilot's lack of familiarity with the…