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.

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.Oct 28, 1999 · N4A · Substantial damageNTSB 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.Oct 28, 1999 · N243RC · Substantial damageNTSB 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.Oct 28, 1999 · N31606 · Substantial damageNTSB 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…Oct 27, 1999 · N350SL · Substantial damageNTSB NYC00LA016Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Somerville, NJThe pilot's inadequate compensation for wind.Oct 27, 1999 · N195EL · Substantial damageNTSB 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.Oct 27, 1999 · N76N · DestroyedNTSB DEN00LA013Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Grand Junction, COA failure of the left main landing gear attachment (u-bolt) due to fatigue.Oct 27, 1999 · N8707V · Substantial damageNTSB 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.Oct 27, 1999 · N7906X · Substantial damageNTSB 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.Oct 27, 1999 · N52569 · Substantial damageNTSB 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,…Oct 27, 1999 · N207SE · Substantial damageNTSB NYC00LA019Accident · No injuriesLimited investigationFinal reportParsons Rans S-12 · Gainesville, VAThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.Oct 26, 1999 · N70197 · Substantial damageNTSB SEA00LA009Accident · No injuriesLimited investigationFinal reportCessna 182B · Atlanta, IDDirectional control not maintained by the pilot in command.Oct 25, 1999 · N7244E · Substantial damageNTSB NYC00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hopedale, MAThe nose landing gear was not locked in the extended position.Oct 25, 1999 · N16397 · Substantial damageNTSB LAX00LA026Accident · No injuriesLimited investigationFinal reportBeech D55 · Corona, CAThe pilot's failure to maintain directional control of the aircraft during takeoff.Oct 25, 1999 · N7674N · Substantial damageNTSB 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…Oct 25, 1999 · N904PD · DestroyedNTSB 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.Oct 25, 1999 · N47BA · DestroyedNTSB 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.Oct 25, 1999 · N4776E · Substantial damageNTSB 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.Oct 25, 1999 · N2285Z · Substantial damageNTSB 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.Oct 24, 1999 · N1231 · Substantial damageNTSB NYC00LA017Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orange, MAThe pilot's failure to maintain directional control during a sudden wind shift.Oct 24, 1999 · N7118H · Substantial damageNTSB 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.Oct 24, 1999 · N138MB · Substantial damageNTSB FTW00LA015Accident · 2 fatalLimited investigationFinal reportSturges Spezio Sport · Mathis, TXthe pilot's failure to maintain clearance with the power lines while maneuvering.Oct 24, 1999 · N75JS · DestroyedNTSB 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.Oct 24, 1999 · N8160X · Substantial damageNTSB 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.Oct 24, 1999 · N8865G · Substantial damageNTSB SEA00LA008Accident · No injuriesLimited investigationFinal reportCessna 150B · Sweet Home, ORCarburetor heat was not used prior to takeoff. Carburetor icing conditions and high vegetation were factors.Oct 23, 1999 · N1252Y · Substantial damageNTSB 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.Oct 23, 1999 · N54844 · 2 aircraft · Minor damageNTSB 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.Oct 23, 1999 · N36R · Substantial damageNTSB FTW00LA027Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Terrell, TXThe pilot's failure to maintain aircraft control during landing.Oct 23, 1999 · N8525K · Substantial damageNTSB 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.Oct 23, 1999 · N4807F · Substantial damageNTSB 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.Oct 23, 1999 · N583AF · Substantial damageNTSB 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.Oct 23, 1999 · N9548A · Substantial damageNTSB ATL00LA008Accident · No injuriesLimited investigationFinal reportCessna 310R · Columbus, GAThe pilot's improper flare that resulted in a hard landing.Oct 23, 1999 · N7571Q · Substantial damageNTSB 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.Oct 23, 1999 · N616FT · Substantial damageNTSB 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…Oct 22, 1999 · N62765 · Substantial damageNTSB 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.Oct 22, 1999 · N6774P · Substantial damageNTSB 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.Oct 22, 1999 · N7057V · DestroyedNTSB ATL00LA001Accident · No injuriesLimited investigationFinal reportCessna 305C · Morganton, NCThe pilot's inadequate compensation for a tailwind which resulted in the loss of control.Oct 22, 1999 · N3255H · Substantial damageNTSB SEA00LA005Accident · No injuriesLimited investigationFinal reportBeech S35 · Melstone, MTLoss of engine power for undetermined reasons.Oct 21, 1999 · N8811M · Substantial damageNTSB 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.Oct 21, 1999 · N6147M · Substantial damageNTSB 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.Oct 21, 1999 · N738FY · Substantial damageNTSB 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.Oct 21, 1999 · N2301C · Substantial damageNTSB 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.Oct 20, 1999 · N8078P · Substantial damageNTSB 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.Oct 20, 1999 · N541JT · Substantial damageNTSB 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.Oct 20, 1999 · N56268 · Substantial damageNTSB 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.Oct 20, 1999 · N2XT · DestroyedNTSB 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.Oct 20, 1999 · N731PU · Substantial damageNTSB 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.Oct 19, 1999 · N34GG · Substantial damageNTSB 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.Oct 19, 1999 · N8364Z · Substantial damageNTSB 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.Oct 19, 1999 · N22795 · Substantial damageNTSB 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.Oct 19, 1999 · N756LE · Substantial damage