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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB 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.NTSB 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.NTSB SEA94LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe student pilot failed to flare. His diverted attention was a factor.NTSB 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.NTSB CHI94LA037Accident · Serious injuriesLimited investigationFinal reportGrumman American AA-1B · Arcadia, WIthe loss of engine power for an undetermined reason(s).NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB LAX94WA053Accident · Serious injuriesForeign investigationPiper PA-32R-300 · Mulege, MexicoNTSB 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.NTSB 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.NTSB 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.NTSB BFO94LA023Accident · 1 fatalLimited investigationFinal reportQuicksilver MX · Montville, CTThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin.NTSB 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.NTSB 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.NTSB ATL94LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Charleston, SCThe failure of the right main landing gear to extend for undetermined reasons.NTSB 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.NTSB 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…NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB FTW94IA032Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Sugar Land, TXThe partial failure of the hydraulic pump (power pack).NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB FTW94LA030Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Fredericksburg, TXThe pilot's utilization of unsuitable terrain for takeoff.NTSB 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…NTSB CHI94LA035Accident · No injuriesLimited investigationFinal reportCessna 150G · Neosho, MOThe pilot-in-command's failure to maintain directional control during landing rollout.NTSB CHI94LA033Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Moberly, MOthe failure of the pilot-in-command to use all of the available runway.NTSB 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.NTSB 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.NTSB 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.NTSB SEA94LA027Accident · No injuriesLimited investigationFinal reportSpringer Christina Minicoupe · Spokane, WAThe pilot in command's failure to maintain a proper descent rate.NTSB 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.NTSB 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.NTSB LAX94LA041Accident · 2 fatalLimited investigationFinal reportHughes 369D · Pacific Ocean (Pacific Ocean)An undetermined event that resulted in the accident.NTSB FTW94LA027Accident · No injuriesLimited investigationFinal reportCessna 150G · Salem, ARPartial loss of engine power for undetermined reasons. A factor was unsuitable terrain for the forced landing.NTSB 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.