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 SEA98LA025Accident · No injuriesLimited investigationFinal reportCessna 177 · Thompson Falls, MTThe student pilot's improper remedial action when confronted with a porpoised landing. A factor was his failure to execute a go-around maneuver.Dec 18, 1997 · N2988X · Substantial damageNTSB NYC98LA059Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Perkasie, PAThe flight instructor failure to maintain directional control, which resulted in an off runway landing, after the left engine was reported to have lost power.Dec 18, 1997 · N6962Y · Substantial damageNTSB NYC98LA044Accident · Minor injuriesLimited investigationFinal reportConsolidated-Vultee BT-13A · Oxford, CTThe loss of power for undetermined reasons.Dec 18, 1997 · N67868 · Substantial damageNTSB IAD98LA017Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Steubenville, OHCollision with deer on runway during initial takeoff and climb.Dec 18, 1997 · N28122 · DestroyedNTSB FTW98TA072Accident · Serious injuriesFinal reportBell 206B-III · Reserve, NMThe pilot's inadvertent loss of tail rotor effectiveness. A factor was the high density altitude weather condition.Dec 18, 1997 · N124DA · Substantial damageNTSB FTW98LA070Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Gonzales, LAThe inadvertent stall resulting from the flight instructor's failure to maintain airspeed during his delayed recovery from the bounced landing. Factors were the student's failure to maintain the proper airspeed and the instructor's inadequate supervision…Dec 18, 1997 · N8426U · Substantial damageNTSB CHI98LA071Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Valley Center, KSthe pilot's excessive pull up after lift-off and failure to maintain adequate airspeed during the initial climb, which resulted in a stall and collision with wooded terrain.Dec 17, 1997 · N32737 · Substantial damageNTSB CHI98LA064Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wichita, KSthe pilot-in-command misjudged the fuel supply and selected an empty fuel tank which resulted in fuel exhaustion. A factor associated with the accident was the rough terrain encountered when the airplane touched down short of the runway.Dec 17, 1997 · N6377L · Substantial damageNTSB CHI98FA068Accident · 1 fatalField investigationFinal reportBeech C35 · Evansville, INImproper maintenance by the use of a loose fitting unapproved fuel line, which resulted in fuel starvation and the loss of engine power.Dec 17, 1997 · N782D · Substantial damageNTSB ATL98FA025Accident · 2 fatalField investigationFinal reportCessna A150K · Jacksonville, FLthe pilot's failure to maintain adequate flying speed following a banner pick up, which resulted in a stall and an uncontrolled collision with the ground. A related factor was: the pilot allowed the maximum certificated gross weight of the airplane to be…Dec 17, 1997 · N1218M · Substantial damageNTSB SEA98LA024Accident · No injuriesLimited investigationFinal reportBell 206L · Idaho Falls, IDloss of engine power for undetermined reason(s). A factor relating to the accident included a dirt berm/ridge in the field where the pilot executed the forced landing.Dec 16, 1997 · N206LT · Substantial damageNTSB NYC98LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Philadelphia, PAThe pilot's failure to maintain proper distance and altitude during approach which resulted in an undershoot and collision with a fence.Dec 16, 1997 · N2932X · Substantial damageNTSB NYC98LA043Accident · 1 fatalLimited investigationFinal reportRobinson R22 Beta · Belle Vernon, PAThe pilot's improper out-of-ground hover procedure, which resulted in a loss of tailrotor effectiveness.Dec 16, 1997 · N55TP · DestroyedNTSB IAD98LA016Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bally, PAThe pilot's failure to attain the proper touchdown point. Related factors were tailwind, and lack of total experience.Dec 16, 1997 · N8068Z · Substantial damageNTSB FTW98LA069Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Mckinney, TXThe pilot's inadequate in-flight/planning decision which resulted in continued flight until fuel exhaustion. Related factors were incorrect fuel gauge readings and trees.Dec 16, 1997 · N1371E · Substantial damageNTSB DCA98RA012Accident · Serious injuriesForeign investigationCanadair CL-600-2B19 · fredericton, CanadaDec 16, 1997 · CFSKINTSB CHI98LA065Accident · No injuriesLimited investigationFinal reportCessna 150M · Sidney, NEthe student pilot's inadequate compensation for the crosswind which resulted in a loss of directional control. Factors associated with the accident were the crosswind, the misunderstood radio communication, and the rough terrain which the airplane encountered.Dec 16, 1997 · N3820V · Substantial damageNTSB ANC98LA013Accident · No injuriesLimited investigationFinal reportCessna 206 · Mnt. Village, AKThe pilot's improper flare and recovery from a bounced landing.Dec 16, 1997 · N9575G · Substantial damageNTSB FTW98FA068Accident · 4 fatalField investigationFinal reportBell 407 · Littleton, COThe pilot's inability to maintain adequate visual lookout due to the lighting conditions and his failure to follow company procedures for departure from a landing zone. Factors were dark night conditions, bright lights in the landing zone which prevented…Dec 15, 1997 · N771AL · DestroyedNTSB ATL98IA024Incident · No injuriesIncident investigationFinal reportAirbus Industrie A-300-600 · Montego Bay, JamaicaThe pilot's improper recovery from a bounced landing, compounded by the automatic deployment of the ground spoilers on main wheel spin-up, resulting in a pitch angle beyond the tail strike pitch angle of the airplane, which led to the tail contacting the…Dec 15, 1997 · N90070 · Minor damageNTSB ANC98LA012Accident · No injuriesLimited investigationFinal reportCessna 207 · Alakanuk, AKthe pilot's mismanagement of the airplane's fuel which led to the loss of engine power due to fuel starvation.Dec 15, 1997 · N707FY · Substantial damageNTSB CHI98LA069Accident · No injuriesLimited investigationFinal reportCessna 150L · Litchfield, MNthe pilot's improper flare and improper recovery from a bounced landing, and his failure to maintain proper runway alignment during the attempted go-around. Factors relating to the accident were: the crosswind condition, and the proximity of trees.Dec 14, 1997 · N18031 · DestroyedNTSB CHI98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hillsdale, MIThe student pilot's failure to maintain. Contributing were icy conditions on the runway and a snowbank.Dec 14, 1997 · N23239 · Substantial damageNTSB CHI98LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Waukegan, ILthe pilot's not identifying unsuitable terrain (snowbank) in the landing area, and his not selecting the proper touchdown point. A factor was the snowbank.Dec 14, 1997 · N68318 · Substantial damageNTSB SEA98FA023Accident · 2 fatalField investigationFinal reportAero Commander 690A · Yakima, WAA loss of aircraft control for undetermined reasons.Dec 13, 1997 · N72VF · DestroyedNTSB LAX98LA060Accident · No injuriesLimited investigationFinal reportCessna 180H · Santa Ynez, CAThe pilot's improper flare. Related factors were the crosswind conditions.Dec 13, 1997 · N123LJ · Substantial damageNTSB FTW98LA082Accident · No injuriesLimited investigationFinal reportMooney M20 · Pocahontas, ARfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in an inadvertent ground swerve. A related factor was: the pilot's lack of recent experience in the make and model of airplane.Dec 13, 1997 · N6159E · Substantial damageNTSB FTW98LA062Accident · Minor injuriesLimited investigationFinal reportCessna 175A · Houston, TXThe total loss of engine power resulting from detonation and the ensuing failure of the engine piston and connecting rod components. Factors were: the instructor's decision to take off with a known deficiency (magneto drop over limit), the flight instructor's…Dec 13, 1997 · N6846E · Substantial damageNTSB DCA98RA011Accident · 10 fatalForeign investigationFairchild SA-226-TC · La Veriente, BoliviaDec 13, 1997 · CP1635NTSB CHI98LA061Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Sturtevant, WIThe pilot's misjudgment of altitude/distance and her failure to maintain adequate visual lookout. Also causal was the pilot's failure to maintain adequate obstacle clearance. A contributing factor was the pilot experiencing a visual illusion.Dec 13, 1997 · N5454S · DestroyedNTSB NYC98FA041Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Pittsville, MDthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision and flight in instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude while flying over wooded terrain. Factors…Dec 12, 1997 · N3448W · DestroyedNTSB FTW98RA076Accident · 10 fatalForeign investigationFairchild SA-2226-TC · La Vertiente, BoliviaDec 12, 1997 · CP-1635NTSB NYC98LA042Accident · No injuriesLimited investigationFinal reportCessna 182P · Chatham, MAloss of engine power for undetermined reason(s). The tail wind component and an encounter with a ditch were related factors.Dec 11, 1997 · N20710 · Substantial damageNTSB LAX98LA057Accident · Serious injuriesLimited investigationFinal reportSaab-Scania 340B · Ventura, CASeat belt not used. A related factor was the unforecasted severe air turbulence.Dec 11, 1997 · N329AE · No damageNTSB ATL98FA023Accident · 1 fatalField investigationFinal reportBeech A100 · Charlotte, NCThe pilot's continued approach below decision height without reference to the runway environment, and his failure to execute a missed approach.Dec 11, 1997 · N30SA · DestroyedNTSB SEA98LA022Accident · No injuriesLimited investigationFinal reportCessna 150J · Silverdale, WAIce accumulation in the carburetor throat. Factors include conditions conducive to serious carburetor icing, an inoperative starter due to a separated pull-to-start knob, and soft terrain at the location of the forced landing.Dec 10, 1997 · N51369 · Substantial damageNTSB IAD98FA015Accident · 1 fatalField investigationFinal reportSocata TB-20 Trinidad · Roanoke, VALoss of engine power for undetermined reasons. A related factor was the low ceiling.Dec 10, 1997 · N3041J · DestroyedNTSB FTW98LA066Accident · Minor injuriesLimited investigationFinal reportCessna 207 · Fruita, COThe total loss of engine power for undetermined reasons .Dec 10, 1997 · N91002 · Substantial damageNTSB CHI98LA063Accident · No injuriesLimited investigationFinal reportBeech 1900C · Rockford, ILimproper installation of aileron cables by the maintenance personnel, inadequate inspection by the company's maintenance personnel of maintenance performed, and inadequate preflight by the pilot.Dec 10, 1997 · N79GL · Substantial damageNTSB NYC98LA039Accident · 1 fatalLimited investigationFinal reportCessna 172M · New Salem, MAThe pilot's failure to maintain adequate altitude/clearance above the water due to his impairment by drugs. A factor in this accident was the glassy water condition.Dec 9, 1997 · N12219 · Substantial damageNTSB NYC98LA038Accident · No injuriesLimited investigationFinal reportCessna TR182 · Owenton, KYThe pilot's inadequate preflight/inflight decision and VFR flight in instrument meteorological conditions. Contributing was a low ceiling.Dec 9, 1997 · N4701S · Substantial damageNTSB LAX98LA056Accident · Serious injuriesLimited investigationFinal reportJohnson Bushrod · Corona, CAAn in-flight loss of control resulting from a malfunction in the wing flap operating system. The malfunction produced asymmetrical drag and induced a roll which could not be overcome by the pilot's flight control inputs.Dec 9, 1997 · N6232F · DestroyedNTSB CHI98LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dawson, NDThe pilot's improper use of carburetor heat. Factors were carburetor icing conditions and a fence.Dec 9, 1997 · N55259 · Substantial damageNTSB CHI98LA057Accident · No injuriesLimited investigationFinal reportCessna 402A · Milwaukee, WIInadequate preflight planning/preparation, which resulted in fuel exhaustion.Dec 9, 1997 · N728QA · Substantial damageNTSB ATL98LA021Accident · No injuriesLimited investigationFinal reportHughes TH-55 · Bushnell, FLThe pilot's failure to maintain clearance from the trees during a hover. A factor was the pilot's diverted attention.Dec 9, 1997 · N74914 · Substantial damageNTSB NYC98LA040Accident · No injuriesLimited investigationFinal reportCessna 172P · Mitchellville, MDThe pilot's improper recovery from a bounced landing.Dec 8, 1997 · N99510 · Substantial damageNTSB CHI98LA059Accident · 2 fatalLimited investigationFinal reportBellanca 17-30 · Independence, KSthe pilot's intentional flight into adverse weather. Contributing factors were low ceilings, fog, and the guy wire.Dec 8, 1997 · N4854V · DestroyedNTSB LAX98FA052Accident · 2 fatalField investigationFinal reportCessna 172N · Lytle Creek, CAthe non-instrument rated pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the adverse weather conditions (low ceiling…Dec 7, 1997 · N3548E · DestroyedNTSB FTW98FA063Accident · 3 fatalField investigationFinal reportPitts S-2B · Bozeman, MTThe failure of both pilots to maintain visual lookout. Factors were the pilot of N693SB not following procedures and directives, and the pilot of N693SB using poor judgment.Dec 7, 1997 · N693SB · 2 aircraft · DestroyedNTSB CHI98LA058Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas DC-9-50 · Memphis, TNthe flight attendant lost his balance during pushback and struck his head on a galley door.Dec 7, 1997 · N774NC · No damage