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 ATL89FA190Accident · 4 fatalField investigationFinal reportMooney M20J · Suches, GAThe pilot elected to continue flight to the intended destination disregarding the recommendations of the in flight weather briefer. Contributing factor(s) was: the adverse weather conditions that existed at the time.NTSB ANC89LA126Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyac Mine, AKFailure of the left rudder pedal bar assembly and failure of the pilot to maintain control of the aircraft. Improper maintenance and the pilot's lack of total experience were considered to be contributing factors.NTSB SEA89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Meridian, IDThe pilot's failure to properly position the fuel selector, which resulted in fuel starvation, his failure to follow the emergency procedure, and his inadequate visual lookout (failure to see & avoid obstructions). The power line was a related factor.NTSB MIA89LA202Accident · No injuriesLimited investigationFinal reportBell TH-13T · Jay, FLInadequate planning/decision by the pilot and his failure to maintain clearance from the power line. Contributing factors were: light conditions at dusk, transmission (power) lines, and the pilot's lack of visual cues (visual perception) at dusk.NTSB LAX89IA242Incident · Minor injuriesIncident investigationFinal reportAerospatiale AS350D · Long Beach, CAThe failure of the engine driven fuel pump.NTSB DEN89LA182Accident · Minor injuriesLimited investigationFinal reportCessna 182C · Weston, COWater in the fuel and inadequate preflight by the pilot. A contributing factor was the ditch.NTSB CHI89DEP07Accident · Minor injuriesFinal reportHiller UH-12E · Blackriverfalls, WIPilot-in-command's failure to jettison the external load followed by his misjudgement of distance to avoid collision with the external load.NTSB ATL89FA182Accident · 3 fatalField investigationFinal reportCessna 172G · Ridgeland, SCImproper planning/decision by the pilot-in-command (PIC), which resulted in an inadvertent stall during takeoff. Factors related to the accident were: the excessive gross weight and improper lift-off by the PIC, the pilot/passenger's improper crew…NTSB SEA89LA138Accident · No injuriesLimited investigationFinal reportGrumman 164B · Hermiston, ORThe airport owners failure to mark a hidden hazard.NTSB SEA89LA136Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Albion, WAThe pilot failed to see and avoid a wooden utility pole while cruising at a low level. A contributing factor was the dusk light conditions.NTSB SEA89LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Albion, IDThe pilot's improper use of the mixture control during takeoff. The fence was a related factor.NTSB MIA89LA203Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Schlater, MSInadequate preflight planning/preparation by the pilot which resulted in the selection of the wrong runway. The tailwindand dirt bank were considered to be contributing factors.NTSB MIA89LA201Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Leesburg, FLFailure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall as he initiated a go-around.NTSB FTW89DRD11Accident · No injuriesFinal reportSchweizer G-164A · Lake Arthur, LALoss of engine power for undetermined reasons. The high weeds (vegetation) & levee (dirt bank) were considered to be related factors.NTSB DEN89LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Crested Butte, COFailure of the pilot to maintain sufficient altitude while flying over mountainous terrain. The terrain and weather conditions were related factors.NTSB DEN89LA173Accident · No injuriesLimited investigationFinal reportBeech A36 · Cimarron, NMFailure of the pilot to properly plan his flight. He failed to take into account the changable winds and the high density altitude that existed at the airstrip when he attempted to takeoff. A proper climb rate was not possible and theaircraft stalled/mushed…NTSB DCA89MA063Accident · 111 fatalClass 1 · MajorFinal reportMcdonnell Douglas DC-10-10 · Sioux City, IAThe inadequate consideration given to human factors limitations in the inspection and quality control procedures used by united airlines' engine overhaul facility which resulted in the failure to detect a fatigue crack originating from a previously…NTSB CHI89IA140Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILHydroplaning attributed to the physical condition of the runway, and the airport personnel's failure to adequately maintain the runway. Contributing factors were: the rain and the wet runway.NTSB BFO89FA059Accident · 2 fatalField investigationFinal reportBeech E18S · Glen Burnie, MDA fire that erupted in the cockpit of the aircraft (under a side panel). Related factors were: smoke and fumes in the cockpit which reduced the pilot's visual perception and ability to see.NTSB ATL89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Somerset, OHThe pilot's failure to adequately perform an airplane pre-flight inspection and drain water present in the airplane fuel supply. The airplane engine subsequently lost power due to the water contamination.NTSB ANC89LA125Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Golovin, AKThe pilot's poor judgement, his inadequate preflight planning/preparation, and his selection of the taxiway (wrong runway) for takeoff. Contributing factors were: the pilot's physical condition (fatigue), his self induced pressure, the weather conditions, and…NTSB SEA89LA134Accident · No injuriesLimited investigationFinal reportMirsepasy 3Q2 · Arlington, WAFuel starvation due to a blocked fuel line which resulted in the pilot having to land on unsuitable terrain.NTSB NYC89LA170Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Ithaca, NYA loss of control on takeoff due to improper takeoff techniques.NTSB MKC89LA162Accident · No injuriesLimited investigationFinal reportRockwell S2R · Bono, ARThe pilot's failure to maintain airspeed during a go-around resulting in the airplane stalling/mushing and descending out of control until collision with trees.NTSB MKC89LA161Accident · Minor injuriesLimited investigationFinal reportGates Learjet Learjet 35 · Des Moines, IAFailure of the pilot to maintain directional control and runway alignment during the landing. Factors related to the accident were: adverse weather/runway/terrain conditions, failure of the local controller to warn the pilot of possible hydroplaning…NTSB LAX89DVA08Accident · No injuriesFinal reportSchweizer G-164B · Livingston, CAThe pilot's decision to attempt a takeoff on unsuitable terrain. A factor was the water on the airstrip.NTSB FTW89LA140Accident · 2 fatalLimited investigationFinal reportAeronca 7AC · Gueydan, LAThe pilot's inadvertent spin entry at pattern altitude which resulted in ground collision.NTSB FTW89DRA08Accident · Minor injuriesFinal reportGrumman-Schweizer G-164B · Anahuac, TXFailure of the supercharger bearing. The dirt bank was a contributing factor.NTSB DEN89FA175Accident · 3 fatalField investigationFinal reportBell 206B · Duchesne, UTThe pilot failed to maintain clearance from the power line. Contributing factors were: lack of mission training provided by the company/operator, the pilot's lack of experience in this type of operation, his lack of familiarity with the geographic area, and…NTSB CHI89LA138Accident · No injuriesLimited investigationFinal reportCessna 182 · New Castle, INFailure of the pilot to maintian directional during the aborted takeoff, which resulted in an inadvertent ground swerve. The ditch was a contributing factor.NTSB BFO89FA060Accident · 1 fatalField investigationFinal reportBeech V35TC · Charlottesville, VAImproper installation of the throttle and variable absolute controller assemblies by maintenance personnel which resulted in a total loss of engine power.NTSB ATL89IA180Incident · No injuriesIncident investigationFinal reportMooney M20C · Marietta, GAThe pilot's failure to properly flare the airplane.NTSB NYC89FA166Accident · 3 fatalField investigationFinal reportPiper PA-28-236 · Thomasville, PAThe pilot's failure to fly the published approach procedure, which resulted in controlled flight into the terrain.NTSB LAX89LA240Accident · Minor injuriesLimited investigationFinal reportCessna T210 · Chandler, AZInadequat preflight planning/preparation and the improper flight planning/decisions, ie. Improper fuel consumption calculations, by the PIC.NTSB DEN89LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Haswell, COInadequate visual lookout by the pilot (failed to see & avoid) which resulted in his failure to maintain clearance from the obstruction. Contributing factors were: the unmarked guy wire & the pilot's lack of visual cues (visual perception).NTSB CHI89LA137Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Chippewa Falls, WIThe pilot's failure to maintain directional control while attempting to land in crosswind conditions. During the ensuing aborted landing, the pilot failed to ensure adequate obstacle clearance and the aircraft's left wing struck the wind sock pole.NTSB ATL89DMG04Accident · No injuriesFinal reportWittman, S.J. W-8 · Washington, NCPilot inadvertently stalled the airplane.NTSB SEA89LA133Accident · No injuriesLimited investigationFinal reportAeronca 7AC · American Falls, IDAn engine failure due to stripped and broken teeth on a magneto drive gear in the accessory gear box. A soft field caused the nose over during the forced landing.NTSB NYC89FA167Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Hartleton, PAThe pilot allowed the design stress limits of the aircraft to be exceeded after encountering adverse weather conditions. Weather was a related factor.NTSB MIA89LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Luquillo, PRFailure of the left exhaust stack which resulted in an engine fire, loss of engine power, and subsequent ditching of the acft in ocean waters.NTSB LAX89DVA07Accident · No injuriesFinal reportTexas Helicopter OH-13E/M74 · Hilmar, CAThe pilot's loss of directional control during an attempted takeoff from a loading platform.NTSB FTW89FA137Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Celina, TXImproper planning/decision by the pilot. Related factors were: failure of the pilot to use all of the available runway area, the runway/terrain conditions, and obstructions/power lines beyond the departure end of the runway.NTSB FTW89FA136Accident · 2 fatalField investigationFinal reportPiccard AX-6 · Houston, TXThe pilot's failure to abort the attempt to clear the obstacle. Factors in the accident were: the poor condition of the balloon envelope and the pilot's lack of experience as pilot in command of balloon operations.NTSB BFO89FA058Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Libertytown, MDContinued VFR flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), which resulted in the pilot's loss of aircraft control due to disorientation, and overload failure of the wings and stabilator due to the pilot exceeding…NTSB ATL89LA179Accident · No injuriesLimited investigationFinal reportCessna P210N · Jackson, SCThe pilot's mismanagement of the available fuel supply which resulted in a total loss of engine power. The fuel selector was not positioned to the tank which contained fuel. Contributing factor(s) was: the rough terrain encountered during the forced landing.NTSB ANC89LA124Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Quinhagak, AKPowerplant failure for an unknown reason, which resulted in an engine vibration, oil leak and a fire.NTSB LAX89LA245Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Maricopa, AZThe pilot's inability to maintain airspeed, resulting in a hard landing. Also causal to the accident was the opening of the canopy for undetermined reasons.NTSB LAX89DUJ07Accident · No injuriesFinal reportGrumman G-164A · Eloy, AZInaequate preflight by the pilot, which resulted in fuel starvation during the climb after takeoff, due to very little fuel remaining in the tanks. The rough/uneven desert terrain was considered to be a contributing factor.NTSB FTW89LA139Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Llano, TXThe pilot's inadvertent closing of the mixture control while his attention was diverted to the landing gear cycling. The engine subsequently quit followed by a forced landing and collision with trees.NTSB DEN89LA171Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Alpine, WYPilot's decision to land at an unlighted airport at night. The aircraft landed long and overran the runway.