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 CHI94FA039Accident · No injuriesField investigationFinal reportBoeing 727-227 · Chicago, ILThe captain's failure to assure that the landing gear was extended for landing. Factors related to the accident were: traffic alert distractions, the flight crew's failure to use the checklist, and inadequate company systems training.Nov 15, 1993 · N16762 · Substantial damageNTSB BFO94LA011Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Elmira, NYA loss of engine power at a critical point on a practice autorotation, and failure of the pilot to attain a flare for the landing. Factors related to the accident were: the adverse wind and downdraft.Nov 15, 1993 · N41S · Substantial damageNTSB SEA94LA246Accident · 2 fatalLimited investigationFinal reportFlake Talon XP · Estacada, ORFailure of the pilot to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the terrain condition and flight into an area with adverse weather and unfavorable winds.Nov 14, 1993 · UNREG · Substantial damageNTSB SEA94LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe student pilot failed to flare. His diverted attention was a factor.Nov 14, 1993 · N5366M · Substantial damageNTSB LAX94LA046Accident · No injuriesLimited investigationFinal reportCessna 182 · Colusa, CAwas the poor major overhaul conducted by maintenance personnel by failing to properly service the cam shaft. The camshaft gears fatigue which led to its ultimate failure, the dark night conditions, and the power lines were factors in this accident.Nov 14, 1993 · N5723B · Substantial damageNTSB CHI94LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Arcadia, WIthe loss of engine power for an undetermined reason(s).Nov 14, 1993 · N9896L · Substantial damageNTSB CHI94FA036Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cedar Lake, INthe failure of the pilot to maintain proper altitude. A factor related to the accident was flight into known adverse weather by the pilot.Nov 14, 1993 · N32303 · DestroyedNTSB BFO94LA010Accident · Minor injuriesLimited investigationFinal reportGulfstream American AA-5B · Sterling, MASeparation of the number one exhaust valve due to fatigue cracking which resulted in loss of engine power. Other related factors were misjudgment of altitude and airspeed by the pilot resulting in on ground collision with the terrain and subsequent nose over.Nov 14, 1993 · N28215 · Substantial damageNTSB BFO94FA008Accident · 2 fatalField investigationFinal reportMooney MO-20J · Seekonk, MAThe pilot's inadequate in flight planning/decision to continue flight into known adverse weather conditions after the engine's dry air vacuum pump failed and the pilot's failure to maintain airplane control during approach. A factor in the accident was the…Nov 14, 1993 · N4224H · DestroyedNTSB ATL94LA017Accident · Minor injuriesLimited investigationFinal reportMaule M-7-235 · Lake City, SCThe pilot's failure to maintain a proper glidepath which resulted in collision with trees near the approach end of the runway.Nov 14, 1993 · N9226M · Substantial damageNTSB SEA94LA031Accident · Serious injuriesLimited investigationFinal reportCessna 150G · Kirkland, WAThe pilot in command's failure to maintain clearance with the tree. A factor contributing to the accident was the pilot in command's ostentatious display.Nov 13, 1993 · N2446J · DestroyedNTSB MIA94LA022Accident · Minor injuriesLimited investigationFinal reportScott LONG-EZ · Hernando, FLThe failure of the nose gear down relay on the landing gear retraction/extension assembly for undetermined reasons, resulting in the collapse of the nose wheel on landing, and subsequent nose over.Nov 13, 1993 · N83TS · Substantial damageNTSB MIA94LA021Accident · Serious injuriesLimited investigationFinal reportVacey MK-1 · Altoona, FLThe pilot-in-command's failure to maintain airspeed (VS) on initial takeoff climb while maneuvering to avoid power lines, resulting in an in-flight loss of control (stall) and subsequent in-flight collision with terrain.Nov 13, 1993 · N602 · Substantial damageNTSB LAX94WA053Accident · Serious injuriesForeign investigationPiper PA-32R-300 · Mulege, MexicoNov 13, 1993 · N6879J · Substantial damageNTSB LAX94LA044Accident · No injuriesLimited investigationFinal reportCessna 150 · Las Vegas, NVthe student pilot's failure to execute a go-around, premature flare, and improper use of the flight controls. Factors related to this accident are the student pilot's lack of total experience and diverted attention.Nov 13, 1993 · N9231U · Substantial damageNTSB LAX94LA043Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Salinas, CAThe pilot's improper handling of the helicopter which resulted in overloading of the rotor system in a maneuvering turn during aerial application of chemical, and subsequent failure of the main rotor paddle assembly.Nov 13, 1993 · N149HA · DestroyedNTSB LAX94LA042Accident · No injuriesLimited investigationFinal reportCooprider WOODY'S Pusher 1972 · San Diego, CAa delay in the application of carburetor heat by the pilot-in- command. Carburetor icing conditions were a factor in this accident.Nov 13, 1993 · N29717 · Substantial damageNTSB BFO94LA023Accident · 1 fatalLimited investigationFinal reportQuicksilver MX · Montville, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin.Nov 13, 1993 · UNREG · DestroyedNTSB BFO94LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Riverhead, NYThe pilot's preflight planning/preparation was inadequate which resulted in a loss of engine power due to fuel exhaustion.Nov 13, 1993 · N46897 · Substantial damageNTSB BFO94LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Greentown, PAThe pilot's selection of the wrong runway, and his delay in attempting a go-around which resulted in an inflight collision with the trees. A related factor was the unfavorable wind.Nov 13, 1993 · N7667F · DestroyedNTSB ATL94LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Charleston, SCThe failure of the right main landing gear to extend for undetermined reasons.Nov 13, 1993 · N1738H · Substantial damageNTSB SEA94LA030Accident · Minor injuriesLimited investigationFinal reportHawkins & Powers UH-1B · North Bend, WATotal failure of the intermediate gearbox. The lack of suitable terrain for an autorotation was a factor.Nov 12, 1993 · N91NW · Substantial damageNTSB MIA94FA020Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Orlando, FLWas in flight loss of control for failure of the pilot-in-command to maintain VMC shortly after takeoff. Contributing to the accident was partial loss of engine power from the left engine due to partial blockage of several of the fuel injector nozzles. Also…Nov 12, 1993 · N27687 · DestroyedNTSB LAX94FA048Accident · 4 fatalField investigationFinal reportBeech V-35 · Shaver Lake, CAAn in-flight breakup of the airplane following the pilot's continued VFR flight into IMC conditions during which directional control of the airplane was not maintained, and the design limits of the airplane were exceeded. The pilot's inadequate evaluation of…Nov 12, 1993 · N630AW · DestroyedNTSB ATL94LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Cumming, GAThe pilot's failure to use the carburetor heat system while maneuvering the airplane. A factor was conditions that were favorable for the formation of carburetor ice.Nov 12, 1993 · N6461G · Substantial damageNTSB ATL94LA015Accident · Serious injuriesLimited investigationFinal reportLuscombe 8F · Griffin, GAThe pilot's failure to maintain airspeed while maneuvering following a loss of engine power for unknown reasons.Nov 12, 1993 · N822B · Substantial damageNTSB ATL94LA014Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 Soloy · Atmore, ALThe pilot's inadequate pre-flight inspection. Factors were the lack of a filter on the refueling pump which would preclude water passage, and the high trees.Nov 12, 1993 · N3078G · Substantial damageNTSB FTW94IA032Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Sugar Land, TXThe partial failure of the hydraulic pump (power pack).Nov 11, 1993 · N688NE · Minor damageNTSB BFO94LA006Accident · Minor injuriesLimited investigationFinal reportCessna 150M · West Milford, NJThe loss of engine power due to an undetermined reason. A factor in this accident was the lack of suitable terrain to complete a forced landing.Nov 11, 1993 · N3481V · Substantial damageNTSB BFO94FA005Accident · 2 fatalField investigationFinal reportCessna 152 · Walkersville, MDImproper planning/decision by the instructor pilot (CFI) by teaching stalls and slow flight to a pre-solo student on a dark night, and the instructor's failure to maintain (or regain) control of the airplane, due to spatial disorientation. Factor's related to…Nov 11, 1993 · N47456 · DestroyedNTSB SEA94GA024Accident · Minor injuriesFinal reportCessna 182R · Salt Lake City, UTThe pilot in command's maintaining inadequate altitude while crossing over the ground track of the landing Boeing 757. A factor contributing to the accident was wake turbulence.Nov 10, 1993 · N9652X · DestroyedNTSB MIA94LA019Accident · No injuriesLimited investigationFinal reportCessna 421 · Miami, FLFailure of the pilot-in-command to obtain the proper assistance after being notified of a fuel leak from the left wing fuel tanks after refueling.Nov 10, 1993 · N1600B · Substantial damageNTSB FTW94FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Longview, TXPoor judgment of the pilot due to impairment from consumption of alcohol and use of a drug (marijuana), and his failure to correct a descent, while maneuvering at low altitude. A factor related to the accident was: the pilot's psychological condition.Nov 10, 1993 · N6651P · DestroyedNTSB CHI94LA034Accident · 1 fatalLimited investigationFinal reportCessna 175 · Hot Springs, SDThe failure of the pilots to maintain sufficient altitude to ensure terrain clearance. Factors which contributed to the accident were: the dark night and rising terrain.Nov 10, 1993 · N7112M · Substantial damageNTSB ATL94LA013Accident · Serious injuriesLimited investigationFinal reportBowermaster B-8M · Cowpens, SCFuel starvation which resulted from unported fuel in the fuel tank due to inadequate design of the tanks.Nov 10, 1993 · N10343 · Substantial damageNTSB SEA94LA029Accident · No injuriesLimited investigationFinal reportBell 47G3B2 · Toledo, WATransmission shear bolts failed causing a loss of power to the rotor system, and the pilot encountered unsuitable terrain during his autorotation attempt.Nov 9, 1993 · N8169J · Substantial damageNTSB LAX94LA040Accident · No injuriesLimited investigationFinal reportBeech D95A · Hollister, CAThe improper position of the fuel selector switch by the dual student during the before landing checklist and inadequate supervision by the CFI. Fuel starvation to both engines was a factor in this accident.Nov 9, 1993 · N566KK · Substantial damageNTSB FTW94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fredericksburg, TXThe pilot's utilization of unsuitable terrain for takeoff.Nov 9, 1993 · N6776W · Substantial damageNTSB FTW94FA028Accident · 3 fatalField investigationFinal reportCessna 182P · Marlow, OKAn inoperative vacuum system, an inoperative turn & bank indicator, and an inoperative directional gyro, which resulted in an inability of the pilot to control the airplane after it encountered instrument meteorological conditions (IMC). Factors related to…Nov 9, 1993 · N182JS · DestroyedNTSB CHI94LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Neosho, MOThe pilot-in-command's failure to maintain directional control during landing rollout.Nov 9, 1993 · N2263J · Substantial damageNTSB CHI94LA033Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Moberly, MOthe failure of the pilot-in-command to use all of the available runway.Nov 9, 1993 · N35537 · Substantial damageNTSB FTW94LA026Accident · Minor injuriesLimited investigationFinal reportRockwell 114 · Magnolia, TXWas the owner's failure to perform corrective maintenance on the airplane's fuel system and the pilot's decision to operate it with known maintenance deficiencies. A factor was the lack of suitable terrain onto which a forced landing could be executed.Nov 8, 1993 · N1237W · Substantial damageNTSB BFO94LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Manassas, VAThe loss of total engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain to enable the completion of a power-off forced landing.Nov 8, 1993 · N8223T · Substantial damageNTSB ANC94LA016Accident · No injuriesLimited investigationFinal reportCessna A185F · Chefornak, AKThe failure of the pilot-in-command to adequately compensate for the gusty cross wind condition. A factor in the accident was the wind gust.Nov 8, 1993 · N185FK · Substantial damageNTSB SEA94LA027Accident · No injuriesLimited investigationFinal reportSpringer Christina Minicoupe · Spokane, WAThe pilot in command's failure to maintain a proper descent rate.Nov 7, 1993 · N71GS · Substantial damageNTSB MIA94LA017Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, FLTotal failure of the crankshaft due to fatigue resulting in a forced landing and subsequent hard landing.Nov 7, 1993 · N9000M · Substantial damageNTSB MIA94LA016Accident · Minor injuriesLimited investigationFinal reportLovern Pitts S1C · Miami, FLInadequate preflight by the pilot-in-command resulting in the total loss of engine power due to fuel exhaustion.Nov 7, 1993 · N55SR · Substantial damageNTSB LAX94LA041Accident · 2 fatalLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)An undetermined event that resulted in the accident.Nov 7, 1993 · N5172K · DestroyedNTSB FTW94LA027Accident · No injuriesLimited investigationFinal reportCessna 150G · Salem, ARPartial loss of engine power for undetermined reasons. A factor was unsuitable terrain for the forced landing.Nov 7, 1993 · N2225J · Substantial damageNTSB BFO94LA003Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morrisville, VTThe pilot's lack of experience in soaring which resulted in inadequate altitude to clear the ridge and subsequent collision with the terrain. A related factor was the high terrain.Nov 7, 1993 · N1178S · Substantial damage