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 IAD00LA002Accident · Minor injuriesLimited investigationFinal reportLoral GZ-22 · Mogadore, OHThe failure of the flight control system manufacturer to meet design (hardness) specifications that resulted in stripped splines.NTSB DEN00LA012Accident · No injuriesLimited investigationFinal reportBeech B-60 · Angel Fire, NMThe pilot's failure to maintain aircraft control, and the pilot's inadequate decision to attempt the takeoff. Factors were the strong left rear cross wind, and the dirt embankment.NTSB ANC00LA009Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Russian Mission, AKThe pilot's continued flight into adverse weather, and an inadvertent stall. Factors in the accident were adverse weather consisting of icing conditions, and airframe icing.NTSB NYC00LA021Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-BA · Westbury, NYthe failure of the operator to ensure the pilot was adequately trained to conduct all inspections required by the flight manual, which resulted in the pilot's inadequate preflight and subsequent failure of the tail rotor pitch change rod. Factors were the…NTSB NYC00LA016Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Somerville, NJThe pilot's inadequate compensation for wind.NTSB NYC00FA020Accident · 2 fatalField investigationFinal reportCessna 210L · Medina, OHThe pilot's failure to maintain proper altitude during the final approach segment of the visual approach. A factor was the diminishing light conditions of a deepening dusk.NTSB DEN00LA013Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Grand Junction, COA failure of the left main landing gear attachment (u-bolt) due to fatigue.NTSB DEN00LA011Accident · No injuriesLimited investigationFinal reportCessna 172B · Englewood, COThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the gusty crosswind and the runway light.NTSB CHI00LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Waukon, IAthe pilot failed to maintain directional control of the airplane during the aborted landing. Factors relating to the accident included the crosswinds, the fence, and the trees.NTSB ANC00LA008Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKThe pilot's inadequate evaluation of the weather, and his decision to initiate flight into adverse weather conditions. Factors in the accident were adverse weather consisting of low ceilings and icing conditions, inadequate supervision by company management,…NTSB NYC00LA019Accident · No injuriesLimited investigationFinal reportParsons Rans S-12 · Gainesville, VAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB SEA00LA009Accident · No injuriesLimited investigationFinal reportCessna 182B · Atlanta, IDDirectional control not maintained by the pilot in command.NTSB NYC00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hopedale, MAThe nose landing gear was not locked in the extended position.NTSB LAX00LA026Accident · No injuriesLimited investigationFinal reportBeech D55 · Corona, CAThe pilot's failure to maintain directional control of the aircraft during takeoff.NTSB LAX00GA025Accident · 2 fatalFinal reportMcDonnell Douglas 500N · San Jose, CAThe pilot's in-flight loss of control due to the failure and separation of the forward thruster control cable telescoping sleeve ball swivel fitting, which resulted in a stuck thruster and the entry into an uncontrollable yaw/spin. Also causal was the…NTSB DCA00MA005Accident · 6 fatalClass 1 · MajorFinal reportLearjet 35 · Aberdeen, SDIncapacitation of the flight crewmembers as a result of their failure to receive supplemental oxygen following a loss of cabin pressurization, for undetermined reasons.NTSB CHI00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Crandon, WIthe deer that ran out onto the runway and collided with the airplane. A factor associated with the accident was the night lighting conditions.NTSB ATL00LA003Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-MARINER · West Boca Raton, FLThe flight instructor's delayed response in taking remedial action during a practice autorotation. Factors were his inadequate planned approach and his improper use of powerplant controls.NTSB SEA00LA016Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Bremerton, WALoss of directional control by the student pilot during landing. Factors include inadequate remedial action by the flight instructor, and an airport sign that was struck by the airplane, collapsing the left main landing gear.NTSB NYC00LA017Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orange, MAThe pilot's failure to maintain directional control during a sudden wind shift.NTSB FTW00LA016Accident · Minor injuriesLimited investigationFinal reportBellanca 7ACA · No. Little Rock, ARThe pilot's delay in aborting the takeoff. A factor was the partial loss of engine power for an undetermined reason.NTSB FTW00LA015Accident · 2 fatalLimited investigationFinal reportSturges Spezio Sport · Mathis, TXthe pilot's failure to maintain clearance with the power lines while maneuvering.NTSB CHI00LA015Accident · Serious injuriesLimited investigationFinal reportWelch Murphy Rebel · Saint Johns, MIthe pilot not maintaining altitude and clearance. Factors were the trees, the flap control not fully engaged, and the pilot's lack of total experience in the kind of airplane flown.NTSB ATL00LA007Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Arecibo, PRThe pilot's failure to maintain altitude clearance during final approach to landing. A factor was the hay bundles.NTSB SEA00LA008Accident · No injuriesLimited investigationFinal reportCessna 150B · Sweet Home, ORCarburetor heat was not used prior to takeoff. Carburetor icing conditions and high vegetation were factors.NTSB SEA00IA007Incident · No injuriesIncident investigationFinal reportCessna 172P · Wenatchee, WAThe failure of the pilots in both aircraft to maintain an adequate visual lookout. Haze was a factor.NTSB LAX00LA024Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Santa Clarita, CAThe pilot's delay in adding power during a power-on recovery from an autorotation, which resulted in a hard landing and rollover. The flight instructor's inadequate supervision of the flight was also causal.NTSB FTW00LA027Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Terrell, TXThe pilot's failure to maintain aircraft control during landing.NTSB FTW00LA019Accident · No injuriesLimited investigationFinal reportCessna TU206A · Jeanerette, LAThe total loss of power for undetermined reasons and the pilot's failure to maintain airspeed, while clearing a ditch during a forced landing, resulting in an inadvertent stall. A factor was the ditch.NTSB FTW00LA017Accident · No injuriesLimited investigationFinal reportWright Avid Flyer Mark IV · Seabrook, TXThe pilot's failure to maintain directional control during a downwind landing. Factors were his improper weather evaluation, the prevailing tailwind, and the engine vibration.NTSB DEN00FA009Accident · 1 fatalField investigationFinal reportCessna 172R · Aspen, COthe pilot's improper decision to fly directly up the center of the valley and not circle climb to gain sufficient terrain clearance altitude. A factor was inadequate route performance planning by the pilot.NTSB ATL00LA008Accident · No injuriesLimited investigationFinal reportCessna 310R · Columbus, GAThe pilot's improper flare that resulted in a hard landing.NTSB ATL00LA002Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Wales, FLThe carburetor icing conditions that were present. Factors were the failure of the pilot to follow the emergency procedures checklist, and the objects that included a flag pole, a road sign and a tractor trailer vehicle.NTSB LAX00LA023Accident · 1 fatalLimited investigationFinal reportLuhnau BD-5B · Boulder City, NVThe pilot's failure to secure an electrical wire terminal in the propeller pitch control circuit following a maintenance adjustment, which resulted in the propeller malfunctioning and going to a flat pitch. The flat pitch of the propeller produced a high drag…NTSB FTW00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oklahoma City, OKThe failure of the pilot to follow the landing checklist and verify that the landing gear was down and locked, which resulted in a wheels up landing. A factor was the failure of the landing gear locking mechanism for an undetermined reason.NTSB CHI00LA014Accident · 1 fatalLimited investigationFinal reportHowlett KR-2 · Denison, IAthe pilot not maintaining altitude/clearance from rising terrain and the intentional low altitude flight. Factors were the known turbulence, rising terrain, and the inadequate in-flight decision to fly at low altitudes.NTSB ATL00LA001Accident · No injuriesLimited investigationFinal reportCessna 305C · Morganton, NCThe pilot's inadequate compensation for a tailwind which resulted in the loss of control.NTSB SEA00LA005Accident · No injuriesLimited investigationFinal reportBeech S35 · Melstone, MTLoss of engine power for undetermined reasons.NTSB SEA00LA003Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Laurel, MTThe pilot's inadequate compensation for wind conditions. Factors include a dust devil/whirlwind at the location where the pilot was trying to land.NTSB LAX00LA021Accident · No injuriesLimited investigationFinal reportCessna 172N · Deer Valley, AZFuel exhaustion due to the pilot's inadequate preflight verification of the fuel quantity, and, once he became aware of the critical fuel state, his decision to over-fly two alternate airports in order to continue to his destination.NTSB FTW00LA014Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Jonesboro, ARThe flight instructor's delay in taking remedial action to recover from a low rotor rpm situation. A factor was the student's failure to maintain adequate rotor rpm.NTSB SEA00LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bozeman, MTThe pilot-in-command's (CFI) failure to take remedial action. Factors include the private pilot letting the airspeed get too low.NTSB SEA00LA004Accident · No injuriesLimited investigationFinal reportThomson Vans RV-6 · Emmett, IDThe pilot's improper fuel management, resulting in fuel starvation. A factor was the aircraft's low altitude at the time engine power was lost.NTSB DEN00LA008Accident · No injuriesLimited investigationFinal reportFairchild M62A (PT-19) · Gallup, NMFailure by the pilot in command to maintain control of the aircraft during landing roll. Factors were a lack of experience of either pilot in kind and type of aircraft.NTSB CHI00LA013Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Custer, SDthe pilot's inadequate preflight planning and decision to perform an intersection takeoff, and the improper short field, rolling, intersection takeoff. A factor relating to this accident was the trees.NTSB CHI00LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Sprague, NEEngine failure due to fouled and rusted spark plugs, and a clogged fuel filter. Factors relating to this accident were the inadequate annual inspection performed on the airplane, the trees and the ditch.NTSB MIA00LA013Accident · No injuriesLimited investigationFinal reportBritish Aerospace HS 125-700A · Fayetteville, NCThe overstress failure of the lugs of the cylinder head of the left main landing gear jack for undetermined reasons. Also, inability of the flight crew to extend the left main landing gear.NTSB MIA00LA011Accident · No injuriesLimited investigationFinal reportRobinson R-44 · Ft. Lauderdale, FLThe PIC's improper use of cyclic control during landing which resulted in a main rotor strike of the terrain and the rotorcraft's tail boom.NTSB LAX00LA020Accident · Minor injuriesLimited investigationFinal reportCessna 150H · El Monte, CAA cracked No. 2 engine cylinder, which led to a loss of power. A factor was the ditch in the forced landing area.NTSB LAX00LA019Accident · No injuriesLimited investigationFinal reportCessna TR182 · Fresno, CAInadequate maintenance inspection mandated by the FAA, and the inadequate design of the exhaust heater core/muffler and deflectors that failed to divert hot exhaust gasses away from the battery and cabin heat valve.