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 FTW00FA268Accident · 2 fatalField investigationFinal reportCessna 152 · Navasota, TXthe pilot's failure to maintain control of the airplane due to spatial disorientation. Contributory factors were the clouds, dark night light conditions, the pilot's lack of total instrument flight time, and the pilot's self-induced pressure to complete the…NTSB DEN01LA006Accident · No injuriesLimited investigationFinal reportNorth American T-28D · Heber City, UTthe failure of the nose wheel landing gear shimmy damper, which resulted in failure and collapse of the nose wheel landing gear during landing roll.NTSB SEA00LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Burlington, WAMintenance personnel not following the mandatory service bulletin procedure of not exceeding 0.0005 inch paint thickness on the cylinder flange. Factors were the fatigue separation of multiple cylinder hold down bolts resulting in looseness of the cylinder;…NTSB NYC00LA266Accident · Serious injuriesLimited investigationFinal reportMorrison RANS-12 · Warrenton, VAThe pilot's inadequate airspeed which resulted in the inadvertent stall. A factor related to the accident was the gusting wind condition.NTSB LAX00LA349Accident · No injuriesLimited investigationFinal reportWoodruff Lancair 360 · Kernville, CAThe pilot failed to maintain an adequate airspeed margin, resulting in a stall/mush and hard landing, and failed to maintain directional control and the left main landing gear separated when it struck a rock.NTSB SEA00LA187Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Newberg, ORThe pilot's failure to maintain a proper glide path on final approach. Factors include a vehicle on the roadway and a downdraft.NTSB SEA00LA186Accident · 1 fatalLimited investigationFinal reportde Havilland DH-100 MK.6 · Ontario, ORThe pilot's failure to maintain adequate airspeed during low-altitude maneuvering flight, resulting in an accelerated stall and spin. A factor was the pilot's intentional low-altitude maneuvering flight.NTSB SEA00LA185Accident · Serious injuriesLimited investigationFinal reportRowe Pietenpol · Raymond, WAThe pilot's failure to maintain an airspeed above power-off stall speed (Vso) while attempting a forced landing after a total loss of engine power, and his failure to move the fuel selector switch to the 'ON' position prior to takeoff. Factors include the…NTSB NYC00LA265Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Greenville, METhe pilot's improper in-flight decision to continue his descent without visual contact with the runway, and his inattention to his altitude, in relation to the airport elevation.NTSB MIA00LA269Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Enochville, NCA loss of engine power for undetermined reasons.NTSB LAX00LA351Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty and variable crosswind conditions. Factors were the variable and gusty crosswinds.NTSB LAX00FA347Accident · Minor injuriesField investigationFinal reportCessna 207A · Valle, AZImproper maintenance and adjustment of the engine magnetos resulting in a loss of optimum performance during a critical takeoff that required peak engine performance.NTSB LAX00FA346Accident · 2 fatalField investigationFinal reportCessna 182G · Tuba City, AZthe pilot's inadvertent descent into terrain on the downwind leg for landing. Contributing to the accident was the dark night and sparse population.NTSB FTW00LA269Accident · Serious injuriesLimited investigationFinal reportRobinson R-22B · Tomball, TXThe student pilot's abrupt lowering of the collective. Factors were the student pilot's lack of experience in helicopters and the CFI's delayed remedial action.NTSB DEN00LA177Accident · No injuriesLimited investigationFinal reportCessna 340 · Broomfield, COThe pilot landing the aircraft hard exceeding the design stress limits. Factors were: Low ceiling, freezing rain, dark night, excessive descent rate, and improper glide path.NTSB ANC00LA132Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B-3 · Ketchikan, AKThe pilot's inadvertent activation of the collective flight stop/emergency fuel augmentation switch, which resulted in engine and main rotor overspeeds, thereby precipitating failures of the tail rotor drive shaft coupling and power turbine blades. A factor…NTSB SEA00LA183Accident · No injuriesLimited investigationFinal reportBeech B99 · Missoula, MTA loss of directional control due to a brake locked as a result of snow and ice contamination.NTSB LAX00RA358Accident · Serious injuriesForeign investigationde Havilland DHC-2T · Clearwater, CanadaNTSB LAX00LA345Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Tracy, CALoss of engine power due to failure and separation of the number one connecting rod.NTSB DEN00LA176Accident · No injuriesLimited investigationFinal reportBell 206B · Rawlins, WYThe company dispatching, and the pilot initiating, flight into known adverse weather with an aircraft which did not have the required anti-ice equipment installed. A factor was snow conditions.NTSB DCA00WA088Accident · Minor injuriesForeign investigationBoeing 707-312B · Niamey, NigerNTSB CHI00TA306Accident · Minor injuriesFinal reportBell 47G-5A · Economy, INThe pilot failed to maintain control of the helicopter while attempting a landing on unsuitable terrain. A factor associated with the accident was the grass covered, down slope in the terrain.NTSB CHI00LA304Accident · No injuriesLimited investigationFinal reportCessna 182S · Wichita, KSthe pilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the pilot's improper recovery from the bounced landing and his failure to go-around.NTSB SEA00TA182Accident · No injuriesFinal reportBell 206-L4 · Atlanta, IDThe pilot's failure to maintain clearance from an object. Trees and inadequate ground communications were a factor.NTSB LAX00LA344Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Corcoran, CAThe pilot's inadequate preflight inspection and his failure to maintain directional control during takeoff. Factors were the pilot's failure to ensure that the fuel tank cover was replaced properly, fuel contamination of the windscreen, and the sun angle that…NTSB FTW00LA267Accident · Minor injuriesLimited investigationFinal reportPZL-Mielec M-18A · Jacksonville, ARthe corrosion and fatigue cracking of the right wing attachment fitting, which resulted in the right wing separating in flight. A factor was the failure of the operator to perform the recommended wing attachment fitting inspection.NTSB CHI00LA305Accident · No injuriesLimited investigationFinal reportCessna 172 · Buffalo, MOThe inadvertent stall during a go-around. Factors relating to this accident were the student pilot's improper in-flight decisions and his failure to raise the flaps during the go around.NTSB ATL00LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Deland, FLA partial loss of engine power during initial climb following takeoff, due to the restricted movement of the number two cylinder's exhaust valve.NTSB ANC00LA129Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Anchorage, AKThe pilot's inadequate compensation for high, gusty wind conditions during water taxi. Factors associated with the accident are high and gusty wind conditions.NTSB SEA00LA181Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Brookings, ORThe pilot's loss of control during the landing attempt. Trees, a crosswind condition, the pilot's inadequate compensation for the wind conditions, and a delayed remedial action were factors.NTSB MIA00LA267Accident · Serious injuriesLimited investigationFinal reportBoeing 767-332ER · Atlanta, GAan in-flight encounter with turbulence in clouds during a normal descent, resulting in serious injuries.NTSB DEN00LA172Accident · No injuriesLimited investigationFinal reportBoeing Stearman D75N1 · Englewood, COthe flight instructor not maintaining supervision. Contributing factors were the student's hard landing due to excessive flare and subsequent inadvertent stall, and the student's failure to maintain directional control during landing roll.NTSB CHI00LA303Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · Jeffersonville, INthe pilot's inadequate normal braking and the pilot's inability to stop the airplane on the runway. Factors relating to this accident were the hydroplaning conditions, wet runway, the tailwind, the trees, and the ravine.NTSB CHI00FA302Accident · 2 fatalField investigationFinal reportCessna 150G · Jasper, INthe inadvertent stall by the pilot in command. Contributing factors were the approach airspeed not obtained/maintained by the pilot in command and the wind gusts.NTSB ANC00LA127Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Galena, AKThe pilot's inadequate compensation for the wind conditions. Factors were the crosswind, and a snow-covered ridge.NTSB ANC00FA128Accident · 1 fatalField investigationFinal reportCessna 207 · Aniak, AKThe pilot's decision to initiate visual flight into dark night instrument meteorological conditions. Factors associated with the accident are a low ceiling, a dark night, the pilot's failure to follow regulatory procedures and directives, and his self-induced…NTSB LAX00LA343Accident · Serious injuriesLimited investigationFinal reportBell 206BIII · Ojai, CAthe pilot encountered a loss of tail rotor effectiveness which led to an uncontrolled rotation and subsequent hard landing. Factors were unfavorable wind conditions, density altitude, and uneven terrain.NTSB IAD00LA084Accident · No injuriesLimited investigationFinal reportCessna 150G · Conesus, NYthe pilot's inadequate preflight performance planning.NTSB FTW00LA266Accident · No injuriesLimited investigationFinal reportCessna 150K · New Orleans, LAThe pilot's failure to maintain control of the aircraft during an aborted landing. A factor was the crosswind.NTSB LAX00FA342Accident · Minor injuriesField investigationFinal reportSikorsky/Orlando S-55 · Hoover Dam, AZ**This report was modified on 2/23/2016. Please refer to the public docket for this accident for more information.** The failure of Papillon maintenance personnel to recognize the significance of the increasing metal in the oil analysis test results and the…NTSB FTW00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blanchard, LAThe student pilot's failure to refuel, which resulted in fuel exhaustion. Factors were the dark night light conditions and lack of suitable terrain for the forced landing.NTSB CHI00LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-16 · Chesaning, MIThe pilot failed to maintain clearance from the trees. A factor was the trees.NTSB ANC00MA125Accident · 5 fatalMajor investigationFinal reportPiper PA-31T3 · Nuiqsut, AKThe pilot's failure to extend the landing gear, his improper aborted landing procedure, and inadvertent stall/mush. Factors in the accident were an improper adjustment of the landing gear warning horn system by company maintenance personnel, and the failure…NTSB NYC00LA264Accident · No injuriesLimited investigationFinal reportAeronca 11AC-991 · Gettysburg, PAThe pilot's failure to maintain control of the airplane after landing which resulted in the inadvertent ground loop.NTSB LAX00LA341Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Prescott, AZAn improper engine installation by other maintenance personnel that resulted in a fuel leak at the main fuel line fitting to the carburetor and subsequent fuel exhaustion during cruise flight.NTSB FTW00LA264Accident · No injuriesLimited investigationFinal reportBeech H35 · Wagoner, OKThe loss of engine power during the takeoff initial climb, for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB DEN00LA174Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Las Cruces, NMThe pilot's failure to maintain lateral clearance with terrain. Factors were the confined area used for takeoff, and the high vegetation alongside the road.NTSB DEN00FA175Accident · 2 fatalField investigationFinal reportBeech S35 · Longmont, COThe pilot/passenger's failure to maintain aircraft control, and the pilot in command's inadequate supervision of the flight. A factor was the pilot/passenger's lack of experience in aircraft type.NTSB CHI00LA301Accident · Minor injuriesLimited investigationFinal reportChampion 7GCBC · Valentine, NEthe delayed aborted takeoff. Factors relating to this accident were the pilot's inadequate planning/preparation for the flight, the high density altitude, and the ditch.NTSB ATL00LA092Accident · Serious injuriesLimited investigationFinal reportBombardier CRJ · Atlanta, GAThe inadvertent flight into turbulent weather conditions.