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 FTW98LA232Accident · Serious injuriesLimited investigationFinal reportGulfstream-Schweizer G-164B · Eunice, LAThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.May 19, 1998 · N8308K · DestroyedNTSB CHI98LA171Accident · No injuriesLimited investigationFinal reportStemme S10V · Plymouth, WIthe improper in-flight decision of the pilot in command to initiate a turn at a close proximity to the ground. Factors to the accident were the starting procedures not being followed and the inadequate altitude to initiate the engine restart.May 19, 1998 · N97MT · Substantial damageNTSB MIA98LA166Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Sumter, SCThe partial failure of the oil cooler bypass valve which resulted in the over-temperature and loss of oil pressure.May 18, 1998 · N9884U · Substantial damageNTSB FTW98LA222Accident · Minor injuriesLimited investigationFinal reportMooney M20E · Watkins, COThe pilot's failure to maintain visual contact with the taxiway. Factors were the pilot's disabling the electrical system by turning off the master switch, a dark night, and excessive taxi speed.May 18, 1998 · N1306W · Substantial damageNTSB FTW98FA229Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Guthrie, OKThe designated pilot examiner's decision to execute a single engine go-around which exceeded the airplane's engine out climb capability in the gear down configuration. Factors were the arcing of an electrical wire that grounded the engine starter and the high…May 18, 1998 · N4410P · DestroyedNTSB CHI98LA162Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Crookston, MNthe pilot inadvertently stalled the airplane. Factors included the loss of engine power due to fuel exhaustion when the pilot failed to refuel the airplane. Another factor was fatigue.May 18, 1998 · N4962Q · Substantial damageNTSB CHI98LA160Accident · Serious injuriesLimited investigationFinal reportPitts S-2A · Benton, KSthe pilot did not flare the airplane properly during the forced landing. A factor was the engine failure for undetermined reasons.May 18, 1998 · N31517 · Substantial damageNTSB CHI98IA164Incident · No injuriesIncident investigationFinal reportBoeing 747-123 · Minneapolis, MNthe open shielding on the #2 VHF transceiver coax connector which resulted in electromagnetic interference with the yaw damper system.May 18, 1998 · N675UP · No damageNTSB CHI98FA159Accident · 4 fatalField investigationFinal reportBell 206L-1 · Arlington Hgts, ILLoss of helicopter control for unknown reasons.May 18, 1998 · N41BL · DestroyedNTSB SEA98LA075Accident · No injuriesLimited investigationFinal reportCessna 170 · Auburn, WAThe pilot's inadequate compensation for gusty crosswind conditions. A related factor was gusty crosswinds.May 17, 1998 · N2534V · Substantial damageNTSB NYC98LA110Accident · 1 fatalLimited investigationFinal reportCessna 337B · Montgomery, NYthe pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).May 17, 1998 · N5471S · Substantial damageNTSB MIA98LA165Accident · No injuriesLimited investigationFinal reportCessna 172RG · Roberta, GAThe pilot's inadequate compliance with the emergency procedures for his failure to completely pump the main landing gear into the down and locked position. Contributing to the accident was the reported loss of electrical power for undetermined reasons.May 17, 1998 · N6562V · Substantial damageNTSB LAX98LA164Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Hollister, CAThe failure of the instructors and dual students in both aircraft to maintain an adequate visual lookout, which resulted in their combined failures to see and avoid each other. Inadequate supervision of the two flights by the respective instructor pilots were…May 17, 1998 · N36574 · 2 aircraft · Substantial damageNTSB LAX98LA163Accident · No injuriesLimited investigationFinal reportCessna 172A · Van Nuys, CAThe pilot's failure to maintain obstacle clearance due to his inadequate visual lookout and selection of the wrong taxi route. Contributing factors were the pilot's diverted attention while taxiing in the vicinity of a construction area.May 17, 1998 · N7222T · Substantial damageNTSB LAX98LA162Accident · No injuriesLimited investigationFinal reportSchweizer G164D · Richvale, CAThe separation of four compressor/turbine blades resulting in a sudden loss of engine power with a subsequent forced landing into unsuitable terrain.May 17, 1998 · N8177K · DestroyedNTSB IAD98FA059Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Fort Washington, MDThe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with trees.May 17, 1998 · N4537R · DestroyedNTSB FTW98LA231Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7-B · Longmont, COThe pilot's failure to properly position his foot for a high wind landing. Factors were high winds and windshear.May 17, 1998 · N1527M · No damageNTSB FTW98LA228Accident · Minor injuriesLimited investigationFinal reportAeronca 65-C · Ozark, ARThe pilot's failure to maintain aircraft control.May 17, 1998 · N23548 · Substantial damageNTSB FTW98LA225Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Parkin, ARthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees at the departure end of the airstrip. Related factors were: high density altitude and trees at the departure end of the airstrip.May 17, 1998 · N502JF · DestroyedNTSB FTW98LA224Accident · No injuriesLimited investigationFinal reportMooney M20F · Telluride, COThe pilot exceeded the crosswind capability performance of the aircraft, and his delayed response in initiating a go around. Factors were gusty, crosswind and tailwind conditions, and high density altitude.May 17, 1998 · N6444Q · Substantial damageNTSB FTW98LA220Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Monument Valley, UTThe pilot's failure to maintain directional control of the aircraft during landing. Factors were gusty, crosswind conditions, the pilot's lack of experience in type of operation and geographic area, mountainous terrain, and high density altitude.May 17, 1998 · N65759 · Substantial damageNTSB FTW98LA219Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Albuquerque, NMThe flight instructor's failure to maintain directional control of the aircraft. Factors were crosswind, high wind conditions, insufficient demonstrated crosswind component information provided by the manufacturer, and insufficient aircraft…May 17, 1998 · N64015 · DestroyedNTSB CHI98LA161Accident · No injuriesLimited investigationFinal reportGrumman American AA-1C · Manhattan, KSthe pilot did not attain proper flying speed. Factors included the high density altitude and crosswind condition.May 17, 1998 · N954OU · Substantial damageNTSB CHI98LA157Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Tower, MNthe pilot's inadequate preflight of the airplane's fuel system, and fuel exhaustion, which resulted in a loss of engine power, due to an inadequate supply of fuel.May 17, 1998 · N3803F · Substantial damageNTSB CHI98LA155Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Dawson, NDthe pilot's failure to maintain clearance with the telephone pole. Factors associated with the accident were the pole and the glare from the rising sun.May 17, 1998 · N2284B · Substantial damageNTSB CHI98FA165Accident · 2 fatalField investigationFinal reportCessna 172 · S. Sioux City, NEThe pilot's failure to maintain adequate flying airspeed during the climbing left turn resulting in a stall condition. Contributing factors were the gusty, crosswind conditions, and the pilot's excessively tight turn maneuver during the initial climb.May 17, 1998 · N8919B · DestroyedNTSB ANC98LA051Accident · No injuriesLimited investigationFinal reportCessna 182A · Palmer, AKThe pilot's failure to abort the landing. A factor associated with the accident is the presence of a variable wind condition.May 17, 1998 · N4827D · Substantial damageNTSB ANC98LA049Accident · No injuriesLimited investigationFinal reportCessna U206G · Iliamna, AKThe pilot's inadequate compensation for quartering tailwind conditions. A factor in the accident is the presence of a quartering tailwind.May 17, 1998 · N756HG · Substantial damageNTSB NYC98LA118Accident · No injuriesLimited investigationFinal reportMorrison Rans S-12 · Gum Spring, VAA loose/partially disconnected engine intake fuel line which resulted in a loss of engine power, and the pilot's delayed (late) flare prior to touchdown.May 16, 1998 · N91337 · Substantial damageNTSB NYC98FA107Accident · 2 fatalField investigationFinal reportErcoupe ERCO-415C · New Lisbon, NYDetonation within the No. 2 cylinder resulting in melting and breaching of the piston, and the pilot's selection of unsuitable terrain for landing. Contributing factors were the uphill terrain encountered during the landing and the visual perception…May 16, 1998 · N3230H · DestroyedNTSB MIA98LA164Accident · No injuriesLimited investigationFinal reportCessna 172P · Fort Myers, FLThe pilot's inadequate inflight decision and her selection of unsuitable terrain to conduct a precautionary landing.May 16, 1998 · N63012 · Substantial damageNTSB MIA98LA163Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Pageland, SCWas the inadvertent stall of the airplane by the pilot-in-command while attempting to clear trees beneath the airplane during the descent for the forced landing. Contributing to the accident was the partial loss of engine power due to separation of the No.9…May 16, 1998 · N158T · Substantial damageNTSB LAX98LA160Accident · No injuriesLimited investigationFinal reportRobinson R22B · San Jose, CAThe student pilot's failure to maintain adequate rotor rpm, and the flight instructor's inadequate supervision of the flight.May 16, 1998 · N2332G · Substantial damageNTSB IAD98LA069Accident · No injuriesLimited investigationFinal reportCessna 182L · Marlborough, MAThe pilot's improper flare. A related factor was the crosswind.May 16, 1998 · N42770 · Substantial damageNTSB IAD98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Princeton, NJA stuck carburetor float which restricted fuel flow to the engine that resulted in a loss of engine power.May 16, 1998 · N56969 · Substantial damageNTSB FTW98LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Searcy, ARThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor was the certified flight instructor's inadequate supervision.May 16, 1998 · N3711P · Substantial damageNTSB FTW98LA223Accident · Serious injuriesLimited investigationFinal reportAS+ AC-4 · Cedar Fort, UTFailure by the pilot to maintain control of the aircraft. A factor was lack of experience in make and model.May 16, 1998 · N158R · DestroyedNTSB FTW98LA221Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-260D · Richfield, UTthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power; and his failure to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in an inadvertent stall and collision with the terrain.May 16, 1998 · N9754P · DestroyedNTSB FTW98LA218Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Dumas, ARThe pilot's improper activation of the parking brake.May 16, 1998 · N6656K · Substantial damageNTSB FTW98FA216Accident · 3 fatalField investigationFinal reportBeagle B-206 · Vernon, TXThe pilot's failure to maintain the airplane's minimum controllable airspeed following a loss of left engine power after takeoff, which resulted in a loss of control. Contributing factors were the fractured exhaust valve guide on the left engine's # 2…May 16, 1998 · N1885S · DestroyedNTSB CHI98LA163Accident · No injuriesLimited investigationFinal reportButler Tool RAF 2000 · Rensselaer, INthe pilot excessively flared the gyroplane during the landing.May 16, 1998 · N4062H · Substantial damageNTSB ANC98LA047Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Talkeetna, AKThe pilot selected the wrong runway and intentionally ground looped to stop the airplane. Related factors were the tailwind and whiteout conditions.May 16, 1998 · N1473F · Substantial damageNTSB NYC98LA109Accident · Minor injuriesLimited investigationFinal reportDeberry Marquart MA-5 · Westminster, MDFailure of a fuel line fitting which led to an engine failure and fire. A factor was the lack of suitable terrain for the forced landing.May 15, 1998 · N83MC · DestroyedNTSB NYC98LA108Accident · Minor injuriesLimited investigationFinal reportCessna 175B · Farmingdale, NYThe engine's inability to provide full power, and the pilot's failure to use performance data. Factors in the accident were conditions conductive for carburetor icing at reduced power, and the unsuitable terrain during the forced landing.May 15, 1998 · N7SB · DestroyedNTSB LAX98LA159Accident · No injuriesLimited investigationFinal reportBell 206B · Temecula, CAA loss of engine power due to a deteriorated compressor air seal which resulted in the fracture and separation of several stator vanes. Deterioration was not detected as a result of an inadequate maintenance inspection frequency.May 15, 1998 · N90215 · DestroyedNTSB LAX98LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Clarksburg, CAA total loss of engine power for undetermined non-mechanical reasons. A contributing factor in the landing nose-over was the presence of the soft terrain.May 15, 1998 · N198TP · Substantial damageNTSB FTW98LA230Accident · No injuriesLimited investigationFinal reportCessna 180 · Abilene, TXThe pilot's improper compensation for the crosswind conditions resulting in a ground loop. A factor was the crosswind condition.May 15, 1998 · N4775B · Substantial damageNTSB CHI98FA153Accident · 4 fatalField investigationFinal reportCommander 114-B · Lagrange, WIthe pilot not maintaining aircraft control during cruise flight and exceeding the airplane's design stress limits. Factors in this accident was the pilot's lack of total experience in the airplane and the clouds.May 15, 1998 · N6059C · DestroyedNTSB ANC98FA048Accident · 2 fatalField investigationFinal reportCessna 172M · Palmer, AKThe pilot's intentional flight into known adverse weather conditions. Contributing factors were the terrain induced turbulence, clouds, the pilot's overconfidence in his abilities, and mountainous terrain conditions.May 15, 1998 · N9212H · Substantial damageNTSB MIA98FA162Accident · 1 fatalField investigationFinal reportTaylorcraft BC-12D · Mccalla, ALThe pilot's failure to maintain airspeed, which resulted in a stall.May 14, 1998 · N96750 · Substantial damage