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 SEA90FA047Accident · 2 fatalField investigationFinal reportBurton Cavalier Model 2 · Grants Pass, ORFuel exhaustion which resulted from the pilots intentionally operating the aircraft with a known deficiency. The pilot failed to maintain airspeed, resulting in a stall/spin and uncontrolled descent.NTSB LAX90FA106Accident · 1 fatalField investigationFinal reportPiper PA28-201T · Yountville, CAThe pilot used poor judgement by attempting a v.f.r. flight to an area with forecasted instrument meteorological conditions and continuing the flight when I.f.r. conditions were encountered.NTSB ANC90LA035Accident · No injuriesLimited investigationFinal reportCessna 207 · Takotna, AKImproper planning/decision by the pilot. Factors related to the accident were: the pilot's failure to attain the proper touchdown point for landing, his excessive airspeed, his failure to go around while he still had sufficient airspeed, the snow covered…NTSB MIA90FA074Accident · Serious injuriesField investigationFinal reportCessna 210-M · Sarasota, FLThe total loss of engine power caused by crankshaft failure, due to fatigue cracking of undetermined origin.NTSB LAX90DUD02Accident · 1 fatalFinal reportReid Long EZ · Santa Monica, CAThe pilot's inflight loss of control due to spatial disorientation.NTSB SEA90LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Vancouver, WAEngine loss of power was due to moisture damage to the coils in the magnetoes. During the forced landing in an open field, the airplane collided with a fence which resulted in substantial damage. The airplane had not undergone current maintenance inspections…NTSB MIA90LA073Accident · Minor injuriesLimited investigationFinal reportForney 415-CD · Tavernier, FLInadequate preflight by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the presence of trees in the emergency landing area.NTSB DEN90FA063Accident · 1 fatalField investigationFinal reportPiper PA-12-150 · Milliken, COThe pilot's poor judgement, intentional buzzing, and failure to see and avoid the obstruction (inadequate visual lookout). Factors related to the accident were: the power line and the absence of shoulder harnesses in the aircraft.NTSB ATL90LA067Accident · No injuriesLimited investigationFinal reportCessna 150M · Leitchfield, KYThe pilot's inadequate preflight, in that he did not assure that both fuel tank filler caps were secure prior to flight.NTSB SEA90LA044Accident · Serious injuriesLimited investigationFinal reportRansome Pitts Special S-1C · Troutdale, ORInadequate maintenance which resulted in a loss of engine power during the initial climb shortly after takeoff.NTSB LAX90LA105Accident · No injuriesLimited investigationFinal reportCessna 152 · Lucerne Valley, CAThe pilot's failure to use carburetor heat and improper emergency procedures. Contributing to the accident was the pilot's lack of total experience.NTSB LAX90LA104Accident · 1 fatalLimited investigationFinal reportI.C.A. Brasov 2902.11.01.001 Lark · Orland, CAThe pilots loss of aircraft control due to the likelihood of experiencing an epileptic seizure. A factor which may have contributed to the accident was the pilot's ingestion of an anticonvulsant drug that causes drowsiness.NTSB LAX90LA102Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Elsinore, CAThe pilot's failure to maintain visual lookout.NTSB FTW90LA074Accident · No injuriesLimited investigationFinal reportHughes 269C · Houma, LALoss of engine power for an unknown reason.NTSB DEN90LA065Accident · No injuriesLimited investigationFinal reportCessna P206A · Logan, UTThe pilot flew the aircraft with an improper modification to the fuel system, which resulted in a fuel leak and subsequent fire.NTSB CHI90IA089Incident · No injuriesIncident investigationFinal reportFokker F-27-200 · Marquette, MIThe pilot-in-command's failure to maintain directional control of the aircraft during touchdown and rollout.NTSB BFO90LA030Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Dungannon, VAThe pilot's improper planning/decision, which resulted in fuel starvation and loss of engine power, and failure of the pilot to maintain directional control of the aircraft during the emergency landing. Factors related to the accident were: the adverse…NTSB SEA90LA043Accident · No injuriesLimited investigationFinal reportCessna 152 · Yamhill, ORThe pilot's selection of unsuitable terrain. Factors related to the accident were: the runway conditions and the tree.NTSB LAX90LA103Accident · No injuriesLimited investigationFinal reportPitts S1T · Ramona, CAThe pilots loss of directional control during landing.NTSB LAX90DUG03Accident · No injuriesFinal reportGroves Cougar · Banning, CAPilot's improper wind evaluation and improper aircraft handling after landing. The tailwind and wind gusts were factors relating to the accident.NTSB DEN90LA067Accident · Minor injuriesLimited investigationFinal reportHeindenreich Fokker DR-1 · Kalispell, MTFailure of the pilot to maintain adequate airspeed, which resulted in a stall. His lack of familiarity with this aircraft was a related factor.NTSB DEN90LA064Accident · No injuriesLimited investigationFinal reportCessna 170A · Gallup, NMImproper operation of the engine during preflight preparation, which resulted in overheating of the engine and damage to internal components.NTSB CHI90LA088Accident · No injuriesLimited investigationFinal reportMitsubishi MU-300 · Gary, INFailure of snow removal personnel to recognize the potential hazard of the snow ridge on the runway and communicate this information to the control tower. Factors related to the accident were: the runway/terrain/light conditions, and failure of airport…NTSB CHI90IA090Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Cleveland, OHThe improper taxi speed to be able to negotiate a safe turn off the snow covered runway.NTSB CHI90FA087Accident · 3 fatalField investigationFinal reportPiper PA-32RT-300 · Lostant, ILFlight into known adverse weather conditions by the pilot and structural (wing) icing. Factors related to the accident were: the adverse weather conditions and the pilot's overconfidence in the aircraft's ability.NTSB NYC90LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orange, MAFailure of the pilot to maintain runway alignment while aborting the takeoff. The crosswind, turbulence, and snowbank were related factors.NTSB NYC90LA072Accident · Minor injuriesLimited investigationFinal reportBell 206B · Norwood, MAImproper planning/decision by the pilot. The turbulence was a related factor.NTSB FTW90DRD03Accident · No injuriesFinal reportGrumman G-164A · Glynn, LALoss of directional control on the ground, due to intermittent locking of the right brake during the landing roll.NTSB DEN90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nephi, UTFailure of the pilot to maintain direction control and correct the resultant ground swerve. The snow bank was a related factor.NTSB DEN90LA060Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Hungry Horse, MTFailure of the #4 connecting rod. Factors related to the accident were: the adverse weather conditions and lack of suitable terrain for a forced landing.NTSB DEN90FA059Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF260C · Agoura, CALoss of control of the aircraft during acrobatic flight and the pilot's failure to recover from a spin.NTSB LAX90LA100Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Fresno, CAThe pilot's improper handling of the airplane during taxi.NTSB FTW90LA073Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Carrollton, TXStarvation induced power loss caused by the pilot's improper selection/management of the appropriate fuel tank. Contributing to the accident was the pilot's poor inflight planning which resulted in running a fuel tank dry.NTSB DEN90FA066Accident · Serious injuriesField investigationFinal reportPiper PA-31-350 · Greeley, COThe improper identification of parts in the Piper PA-31-350 service manual pertaining to the aileron cables. This discrepancy resulted in the improper installation of the aileron cables on the right aileron bellcrank by a mechanic during the reconstruction of…NTSB DEN90FA058Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Pueblo, COThe pilot's failure to maintain a proper glide path and sufficient altitude to clear obstacles.NTSB CHI90LA086Accident · No injuriesLimited investigationFinal reportCessna 152 · Garrett, INThe student pilot's failure to maintain directional control which resulted in a ground swerve. The crosswind and soft runway were related factors.NTSB ATL90LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Roxboro, NCThe pilot's failure to use the before landing checklist which requires the application of carburetor heat. Factors were soft terrain at accident site, and condition favorable for the formation of carburetor ice.NTSB MKC90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Ely, MNImproper planning/decision by the pilot. A factor related to the accident was: the strong/gusty crosswind condition.NTSB MKC90LA055Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Columbia, MOExcessive taxi speed and inadequate visual outlook by the pilot. Factors related to the accident were: dark night and the ditch.NTSB MKC90LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Crane Lake, MNFailure of the connecting rod assembly. Factors related to the accident were: terrain conditions in the emergency landing area.NTSB MIA90IA072Incident · No injuriesIncident investigationFinal reportPiper PA-30 · Tallahassee, FLProper glidepath not maintained.NTSB LAX90LA099Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Big Bear, CAThe pilot's failure to maintain adequate clearance between the aircraft wing tip and the snow bank. A factor in the accident was the snow berms alongside the runway.NTSB LAX90LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Truckee, CAThe pilot's loss of directional control after landing on a recently plowed runway. Contributing to the accident was the four foot high snow berm alongside the runway and the icy spots on the runway.NTSB LAX90LA097Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Santa Ysabel, CAThe pilot's attempt to conduct visual flight into instrument meteorological conditions. Low ceilings and mountainous terrain were factors.NTSB LAX90IA101Incident · Minor injuriesIncident investigationFinal reportLockheed L-1011-385-1 · Los Angeles, CAThe failure of the weld holding the slip joint to the pneumatic dual compensator from the no. 2 engine.NTSB LAX90FA094Accident · 2 fatalField investigationFinal reportChampion 7KCAB · Ojai, CAThe pilot's performing aerobatic maneuvers at a low altitude and failure to maintain altitude.NTSB CHI90IA084Incident · No injuriesIncident investigationFinal reportShort Brothers SD3-60 · Chicago, ILFatigue failure of a first stage power turbine blade.NTSB BFO90LA027Accident · No injuriesLimited investigationFinal reportBeech H35 · College Park, MDThe pilot's inadequate compensation for wind conditions. The adverse wind was a related factor.NTSB BFO90DIG01Accident · 1 fatalFinal reportRolladen-Schneider LS-6 · Cabins, WVThe pilot failed to detect and remain clear of the power line which crossed the field in which he was attempting to land. Contributing to the accident was the moderate to severe turbulence in the area at the time of the accident.NTSB ATL90LA065Accident · No injuriesLimited investigationFinal reportPiper PA-31T1 · Chamblee, GAThe pilot misjudged the landing flare. Contributing to the accident was the pilot's failure to defrost the windshield during the approach.