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 LAX98LA192Accident · No injuriesLimited investigationFinal reportArner Challenger II S · Pleasant Valley, AZLoss of engine power due to a loose spark plug wire cap caused by a broken spark plug retainer spring.Jun 7, 1998 · N2NX · Substantial damageNTSB LAX98LA187Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Descanso, CAthe certified flight instructor's disregard of the weather briefings and forecasted en route weather conditions, and, his failure to maintain adequate altitude/clearance in mountainous terrain. Contributing to the accident were instrument meteorological…Jun 7, 1998 · N5343M · DestroyedNTSB LAX98LA186Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · El Cajon, CAThe certified flight instructor's inadequate preflight which led to fuel exhaustion and subsequent loss of engine power. A related factor was the unsuitable terrain.Jun 7, 1998 · N84451 · Substantial damageNTSB FTW98LA260Accident · No injuriesLimited investigationFinal reportBell 206B · Corpus Christi, TXThe failure of the tail rotor drive shaft due to the separation of a bolt at one of the drive shaft disc couplings for an undetermined reason, which resulted in the pilot's inability to maintain directional control during landing.Jun 7, 1998 · N16814 · Substantial damageNTSB CHI98LA191Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Excelsior Spr, MOthe inadequate preflight planning by the pilot in command and exceeding the maximum gross weight for the aircraft. A factor was the berm.Jun 7, 1998 · N2302Q · DestroyedNTSB SEA98FA090Accident · 2 fatalField investigationFinal reportMaule M-5-220C · Kettle Falls, WAThe pilot's failure to maintain terrain clearance. A factor was an attempt to perform aerobatics at low altitude.Jun 6, 1998 · N16CB · DestroyedNTSB MIA98FA182Accident · 2 fatalField investigationFinal reportPiper PA-24-260 · Statesville, NCThe pilot's attempted flight into adverse weather, resulting in a loss of control in flight. Contributing factors were the pilot's failure to obtain updated weather information, rain, and fog.Jun 6, 1998 · TGHUH · DestroyedNTSB LAX98LA254Accident · Minor injuriesLimited investigationFinal reportGirgen Kitfox II · Peoria, AZAn engine failure due to a broken rotary valve for unknown reasons. Contributing factors to the accident was an inadequate inspection by the owner of a previously damaged engine during maintenance overhaul prior to installation in the airframe.Jun 6, 1998 · N62KF · Substantial damageNTSB LAX98LA184Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Burbank, CAThe separation of the tail rotor pitch link due to a fatigue fracture, which resulted in the separation of the tailboom.Jun 6, 1998 · N31621 · Substantial damageNTSB FTW98LA317Accident · No injuriesLimited investigationFinal reportCessna 152 · Dallas, TXThe inadequate visual lookout by the pilots of both airplanes.Jun 6, 1998 · N47354 · 2 aircraft · Substantial damageNTSB FTW98LA258Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Lazbuddie, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Jun 6, 1998 · N5087 · Substantial damageNTSB FTW98LA257Accident · 1 fatalLimited investigationFinal reportAero Commander S2R · Hondo, TXThe inadvertent stall due to the pilot's failure to maintain control of the airplane. Factors were the high winds and the wind induced turbulence.Jun 6, 1998 · N1765S · DestroyedNTSB DCA98WA051Accident · No injuriesForeign investigationMcDonnell Douglas MD-83 · Antalya, FranceJun 6, 1998 · FGGMDNTSB CHI98LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Harrison, NEthe pilot's improper positioning of the magneto switch and his improper use of the mixture control.Jun 6, 1998 · N4541R · Substantial damageNTSB CHI98LA197Accident · No injuriesLimited investigationFinal reportWolfe Pulsar 582 · Greenfield, INthe pilot's failure to obtain control of the aircraft during the recovery from a stall. Factors associated with the accident were the intentional stall initiated and the low altitude which did not allow a full recovery from the stall condition.Jun 6, 1998 · N177TW · Substantial damageNTSB CHI98LA192Accident · No injuriesLimited investigationFinal reportGrumman G164 · Somonauk, ILthe pilot's misjudgment of distance. Factors were wind gusts and crops.Jun 6, 1998 · N710Y · Substantial damageNTSB ANC98LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Naknek, AKThe pilot's inadequate compensation for wind conditions. A factor associated with this accident was a crosswind.Jun 6, 1998 · N8092B · Substantial damageNTSB NYC98LA125Accident · Serious injuriesLimited investigationFinal reportBeech BE 65-80 · Malone, NYThe pilot's failure to follow emergency procedures, and his failure to maintain control of the airplane after a loss of power from one engine. Factors include fuel filter blockage, inadequate maintenance, and the pilot's lack of experience in multi-engine…Jun 5, 1998 · N215AB · DestroyedNTSB MIA98LA192Accident · No injuriesLimited investigationFinal reportCessna 310K · Opa-Locka, FLThe fuel leak due to improper installation of the left auxiliary fuel tank by maintenance personnel. Also, inadequate annual inspection of the airplane by maintenance personnel for failure to identify the missing screw from the adel clamp resulting in chafing…Jun 5, 1998 · N366J · Substantial damageNTSB MIA98LA179Accident · No injuriesLimited investigationFinal reportRotorway Executive 162F · New Port Richey, FLThe pilot's improper use of the collective. Contributing to the accident was pilot fatigue due to lack of sleep.Jun 5, 1998 · N162WM · Substantial damageNTSB LAX98LA183Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mariposa, CAFuel exhaustion due to the pilot's inadequate preflight planning, and improper in-flight decision not to make a precautionary landing for additional fuel.Jun 5, 1998 · N2573L · Substantial damageNTSB FTW98LA259Accident · No injuriesLimited investigationFinal reportAyres S2R · Watson, ARThe partial loss of engine power due to the disconnection of the propeller governor control as a result of the stripped threads on the propeller governor control push-pull rod. A factor was the lack of suitable terrain for the forced landing.Jun 5, 1998 · N4007Y · Substantial damageNTSB FTW98FA256Accident · 3 fatalField investigationFinal reportEurocopter AS350BA · La Gloria, TXthe pilot's continued flight into adverse weather conditions resulting in a loss of control due to spatial disorientation. Contributing factors were the dark night illumination, the lack of visual cues, the pilot's lack of total instrument time, and the…Jun 5, 1998 · N911VA · DestroyedNTSB ANC98LA064Accident · No injuriesLimited investigationFinal reportCessna 185F · Iliamna, AKThe loss of engine power for undetermined reasons. A factor was the hilly terrain.Jun 5, 1998 · N32663 · Substantial damageNTSB SEA98WA086Incident · No injuriesForeign investigationDouglas MD-80 · Yuzhno, RussiaJun 4, 1998 · N965AS · Minor damageNTSB SEA98LA087Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Hailey, IDThe disconnection of the rear right-main brake pedal from the brake master cylinder, and the overloading of the right main landing gear. A factor was the oscillation of the tailwheel.Jun 4, 1998 · N912CP · Substantial damageNTSB SEA98LA085Accident · 1 fatalLimited investigationFinal reportPiper PA-30 · Everett, WAThe pilot-in-command's exiting the aircraft with both engines running to remove a wheel chock. A factor was the inadequate preflight of the aircraft (not removing the chock) prior to engine start.Jun 4, 1998 · N98NT · Minor damageNTSB SEA98FA088Accident · 3 fatalField investigationFinal reportCessna 172N · Prindle, WAThe pilot-in-command's failure to maintain control of the aircraft during attempted flight into instrument meteorological conditions. Factors contributing to the accident were clouds, dark night conditions, spatial disorientation, and drug impairment.Jun 4, 1998 · N6234D · DestroyedNTSB MIA98LA178Accident · No injuriesLimited investigationFinal reportAir Tractor 502 · Clarksdale, MSThe pilot's failure to extend the flaps for takeoff. A factor was his diverted attention to the loading of the airplane.Jun 4, 1998 · N1502U · Substantial damageNTSB MIA98FA177Accident · 3 fatalField investigationFinal reportCessna 182R · Bradenton, FLThe failure of the pilot to maintain airspeed during climb after a low level observation flight resulting in the aircraft entering into a stall and descending uncontrolled until it crashed into trees and a river.Jun 4, 1998 · N9846H · DestroyedNTSB LAX98LA182Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Livermore, CAThe missing nut/cotter pin on the throttle attachment assembly which resulted in the pilot's inability to control engine power, and the hidden obstruction (hole) in the landing area. A factor was the high vegetation.Jun 4, 1998 · N704ZA · Substantial damageNTSB CHI98LA190Accident · No injuriesLimited investigationFinal reportRotorway Exec 90 · Lexington, NEAn improper autorotation by the pilot in command. Factors contributing to this accident were the accumulation of ice in the carburetor resulting in a total loss of engine power, and the soft terrain.Jun 4, 1998 · N132RS · Substantial damageNTSB ANC98LA050Accident · No injuriesLimited investigationFinal reportCessna 170B · Russian Mission, AKThe pilot's inadequate compensation for wind conditions while landing. A factor associated with the accident was the presence of a tailwind condition.Jun 4, 1998 · N2235D · Substantial damageNTSB NYC98FA124Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · Dalton, MAThe pilot's decision to continue the flight into instrument meteorological conditions, resulting in a loss of control, and airplane stress limits to be exceeded. Factors in the accident, the pilot's decision to disregard the preflight weather briefing, and…Jun 3, 1998 · N75137 · DestroyedNTSB MIA98FA176Accident · 2 fatalField investigationFinal reportMooney M-20E · Winston-Salem, NCThe pilot's improper decision to conduct a maintenance test flight with a known unairworthy mechanical condition (unserviceable servo fuel injector), resulting in a partial loss of engine power on climb out, subsequent forced landing, and in-flight collision…Jun 3, 1998 · N9365V · DestroyedNTSB LAX98LA180Accident · 1 fatalLimited investigationFinal reportVickers MK XVI · Blue Canyon, CAthe pilot's failure to maintain adequate terrain clearance and his VFR flight into instrument meteorological condition. Mountainous terran and obscurations are contributing factos. inadvertent flight into instrument meteorological conditions in mountainous…Jun 3, 1998 · N382RW · DestroyedNTSB IAD98LA067Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Selbyville, DEInadequate compensation for wind conditions by the pilot, and his failure to maintain control of the airplane. High, gusting winds were contributing factors.Jun 3, 1998 · N3731J · Substantial damageNTSB SEA98FA084Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369FF · Shoshone, IDFailure to maintain clearance from wires. A transmission wire was a factor.Jun 2, 1998 · N16031 · Substantial damageNTSB MIA98LA175Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Clewiston, FLThe pilot's inadequate visual lookout while taxiing for takeoff.Jun 2, 1998 · N7318K · Substantial damageNTSB MIA98LA174Accident · No injuriesLimited investigationFinal reportCessna 180D · Natchez, MSThe pilot's improper use of brakes on landing rollout. The tailwind was a factor.Jun 2, 1998 · N6471X · Substantial damageNTSB MIA98LA173Accident · No injuriesLimited investigationFinal reportMejia Bacon II · Winter Haven, FLThe pilot's improper use of brakes on landing rollout.Jun 2, 1998 · N24EM · Substantial damageNTSB FTW98LA253Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Delaplaine, ARThe failure of maintenance personnel to comply with and airworthiness directive, which resulted in failure of the planetary gear due to lack of lubrication. A contributing factors was the lack of suitable terrain for the pilot to execute a forced landing.Jun 2, 1998 · N4028T · Substantial damageNTSB FTW98LA204Accident · No injuriesLimited investigationFinal reportCessna 150 · Mentone, TXa partial loss of engine power for undetermined reasons, and the pilot's failure to maintain directional control during landing.Jun 2, 1998 · N6486T · Substantial damageNTSB CHI98LA189Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · North Platte, NEthe pilot's failure to maintain control of the aircraft. Factors were the crosswind and runway light.Jun 2, 1998 · N8469W · Substantial damageNTSB CHI98LA186Accident · Minor injuriesLimited investigationFinal reportSheets Kitfox II · Greenfield, IAthe initial climb airspeed not obtained/maintained after liftoff by the pilot in command. A factor was the improper compensation for wind conditions by the pilot in command.Jun 2, 1998 · N487JS · DestroyedNTSB NYC98LA121Accident · Serious injuriesLimited investigationFinal reportCawood Fisher Classic · Abingdon, VAThe pilot's inadequate preflight of the airplane which resulted in water contamination of the fuel system. A factor was the location of the fuel tank's sump.Jun 1, 1998 · N485AJ · DestroyedNTSB NYC98LA120Accident · No injuriesLimited investigationFinal reportCessna 140 · Madison, CTThe pilot's improper in-flight decision to continue the landing and his delayed go-around attempt. A factor in this accident was the pilot's diverted attention.Jun 1, 1998 · N72657 · Substantial damageNTSB MIA98FA172Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Ocean Springs, MSan in-flight collision with a nylon rope (wire), resulting in a loss of engine power, an inadvertent stall, and subsequent impact with the ground.Jun 1, 1998 · N7736V · DestroyedNTSB IAD98LA065Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Floyd, VAThe pilot's improper selection of fuel tank position resulting in fuel starvation of both engines.Jun 1, 1998 · N7794Y · DestroyedNTSB FTW98LA252Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Coy, ARfailure of the left main tire, which resulted in the pilot's inability to maintain directional control of the airplane during the landing roll.Jun 1, 1998 · N943QC · Substantial damage