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 LAX93LA299Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Oceano, CAThe student pilot's misjudging the landing flare altitude and his improper recovery from a bounced landing. Factors relating to this accident are the student pilot's lack of total experience and failure to raise the flaps.Jul 25, 1993 · N6331M · Substantial damageNTSB FTW93LA216Accident · No injuriesLimited investigationFinal reportCessna 172N · Purcell, OKThe lack of suitable terrain onto which to execute the forced landing which was neccesitated by the partial power loss. The power loss was a result of the fatigue failure of the exhaust valve rocker arm attachment stud. A factor was the night conditions.Jul 25, 1993 · N4884G · Substantial damageNTSB CHI93FA274Accident · 2 fatalField investigationFinal reportCessna A150K · Goshen, INFailure of both pilots to see and avoid each other. A factor in the accident was the position of the sun which resulted in sun glare for the pilot of the mong sport.Jul 25, 1993 · N8382M · 2 aircraft · DestroyedNTSB BFO93LA139Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12-65 · Sunappee, NHThe passenger's failure to follow proper procedures and inadequate supervision by the pilot.Jul 25, 1993 · N36452 · No damageNTSB BFO93FA138Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Clearfield, PAThe pilot's failure to maintain airspeed during the go-around.Jul 25, 1993 · N6697W · DestroyedNTSB ATL93LA134Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Ashford, ALThe failure of the engine supercharger assembly, which resulted in a loss of engine power. A factor was the trees at the forced landing site.Jul 25, 1993 · N8373 · DestroyedNTSB ANC93LA127Accident · Minor injuriesLimited investigationFinal reportBeech D18S · Kodiak, AKThe pilot's improper in flight planning/decision. A factor was the partial loss of power on one engine.Jul 25, 1993 · N2053D · Substantial damageNTSB ANC93LA126Accident · No injuriesLimited investigationFinal reportCessna 207 · Egegik, AKThe pilot-in-command's failure to see and avoid the truck.Jul 25, 1993 · N9993M · Substantial damageNTSB SEA93LA160Accident · Serious injuriesLimited investigationFinal reportCessna 337 · Jerome, IDThe pilot's improper fuel management procedures which resulted in fuel starvation. Factors include the pilot's lack of familiarity with this type aircraft, and rough/uneven terrain in the landing area.Jul 24, 1993 · N2269X · Substantial damageNTSB SEA93LA158Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Troutdale, ORThe pilot's poor inflight decision, and fuel exhaustion. Factors include unfavorable winds, a dark night, and trees in the attempted landing area.Jul 24, 1993 · N30170 · Substantial damageNTSB NYC93FA138Accident · 2 fatalField investigationFinal reportRobinson R22 · Warsaw, KYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance with ground obstacles, which resulted in an inflight collision with a power line.Jul 24, 1993 · N9021Z · DestroyedNTSB MIA93LA162Accident · No injuriesLimited investigationFinal reportCessna 152 · St. Augustine, FLA reported partial loss of engine power for undetermined reasons, resulting in a forced landing and subsequent ditching in the ocean.Jul 24, 1993 · N6091M · Substantial damageNTSB LAX93LA298Accident · No injuriesLimited investigationFinal reportCessna 172 · Vacaville, CAThe pilot's improper in-flight planning/decision by failing to allow enough time for the rotor wash to dissipate before attempting the approach. The wake turbulence (rotor wash) was a factor in this accident.Jul 24, 1993 · N51409 · Substantial damageNTSB FTW93LA217Accident · No injuriesLimited investigationFinal reportCessna 172P · Cookson, OKThe pilot's improper flare and his failure to maintain directional control during the aborted landing.Jul 24, 1993 · N65709 · Substantial damageNTSB DEN93LA086Accident · Serious injuriesLimited investigationFinal reportBalloon Works 7B-15 · Colorado Sprgs, COThe passenger's failure to assume the proper landing position as instructed by the pilot in command. A factor was: the high wind.Jul 24, 1993 · N9067Y · No damageNTSB DEN93LA085Accident · Minor injuriesLimited investigationFinal reportLet L-13 · Durango, COThe failure of the tow plane pilot to warn the glider pilot that he was releasing the tow line. A factor was: an inadvertent stall by the pilot in command.Jul 24, 1993 · N48069 · DestroyedNTSB CHI93LA279Accident · No injuriesLimited investigationFinal reportCessna 150M · Bridgman, MIthe pilot's premature lift-off.Jul 24, 1993 · N66155 · Substantial damageNTSB CHI93LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Sparta, MIthe separation of the rear landing light gasket into the air induction path.Jul 24, 1993 · N95478 · Substantial damageNTSB CHI93IA280Incident · No injuriesIncident investigationFinal reportCanadair CL600-2B19 · Danville, ILa lightning strike and associated engine flameout.Jul 24, 1993 · N915CA · Minor damageNTSB CHI93DEP02Accident · 1 fatalFinal reportStoeckler RV-4 · Lake Delton, WIthe pilot-in-command's failure to maintain proper altitude. A factor was trees.Jul 24, 1993 · N720DS · DestroyedNTSB BFO93LA136Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Pittsfield, MAThe failure of the pilot of the PA-28, N9044J, to properly tune his radios, and his failure to see and avoid the PA-38, N91357.Jul 24, 1993 · N9044J · 2 aircraft · Substantial damageNTSB BFO93FA135Accident · 2 fatalField investigationFinal reportKrowell Christen Eagle II · Lebanon, NHInadequate crew/group coordination.Jul 24, 1993 · N90BC · DestroyedNTSB ATL93LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Pelion, SCThe pilot's improper weather evaluation prior to commencing the flight. Factors were the fog and low ceiling weather conditions, and the rough, uneven terrain at the landing siteJul 24, 1993 · N6197T · Substantial damageNTSB ANC93LA125Accident · No injuriesLimited investigationFinal reportHughes 369D · Cordova, AKA loss of engine power for undetermined reasons. A factor was the rough/uneven terrain.Jul 24, 1993 · N3115Y · Substantial damageNTSB SEA93LA159Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau BU-131 · Arlington, WAThe pilot's improper use of the brakes. The gusty, crosswind was a factor.Jul 23, 1993 · N1XW · Substantial damageNTSB LAX93FA297Accident · 2 fatalField investigationFinal reportCessna 175B · Blythe, CAThe pilot's failure to see and avoid the cable due to drug impairment. Factors which contributed to the accident were: the pilot's intentional buzzing, his ostentatious display, and his failure to maintain an adequate altitude over the river.Jul 23, 1993 · N8264T · DestroyedNTSB CHI93LA277Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIThe pilot's inadequate preflight planning for determining the proper takeoff profile. A factor in the accident was the high density altitude.Jul 23, 1993 · N9307N · Substantial damageNTSB CHI93LA273Accident · No injuriesLimited investigationFinal reportCessna 305B · Fulton, MOfailure to maintain directional control. A factor related to the accident was the pilot's fatigue.Jul 23, 1993 · N26213 · Substantial damageNTSB CHI93FA272Accident · Serious injuriesField investigationFinal reportCessna 172N · Long Grove, ILThe pilot-in-command's failure to refuel the airplane prior to fuel exhaustion. Related factors to the accident were: inadequate certification/approval of the STC by the FAA, inadequate performance data, and unavailable fuel consumption information.Jul 23, 1993 · N733XS · Substantial damageNTSB BFO93LA134Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Belmar, NJThe pilot's inadequate compensation for wind and failure to maintain directional control during landing. Other related factors were the crosswind and the ravine.Jul 23, 1993 · N8431R · Substantial damageNTSB ATL93LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Atmore, ALThe total failure of the engine supercharger, which resulted in engine stoppage. A factor was the rough terrain at the forced landing site.Jul 23, 1993 · N4824 · Substantial damageNTSB MIA93LA161Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Vero Beach, FLImproper planning/decision by the pilot, and his delay in aborting the takeoff. Factors related to the accident were: the tailwind, wet runway, and soft terrain beyond the end of the runway.Jul 22, 1993 · N888CD · Substantial damageNTSB LAX93LA295Accident · Minor injuriesLimited investigationFinal reportCurry Varieze · Bisbee, AZThe pilot's improper use of the carburetor heat. The carburetor icing conditions were a factor.Jul 22, 1993 · N183RC · Substantial damageNTSB LAX93LA294Accident · No injuriesLimited investigationFinal reportCessna 150L · Hanford, CAThe student pilot's failure to maintain aircraft control. Factors related to this accident were the pilot's poorly planned approach, failure to maintain the proper glide path, delay in raising the flaps, and the improper use of the carburetor heat.Jul 22, 1993 · N7457G · Substantial damageNTSB DEN93LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Garner, ARTotal failure of one propeller blade. Factors were the continued operation of the engine during the forced landing, despite the pilot's efforts to shut it down, and the lack of suitable terrain for the forced landing.Jul 22, 1993 · N3650U · Substantial damageNTSB CHI93LA271Accident · No injuriesLimited investigationFinal reportBeech A36 · Fowlerville, MIThe pilot-in-command's (CFI) delay in aborting the takeoff.Jul 22, 1993 · N211BB · Substantial damageNTSB CHI93LA270Accident · No injuriesLimited investigationFinal reportCessna 152 · Howell, MIThe student pilot's failure to maintain directional control during the takeoff portion of a touch and go landing.Jul 22, 1993 · N64988 · Substantial damageNTSB CHI93LA268Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Elderon, WIThe pilot's failure to refuel the helicopter.Jul 22, 1993 · N9010C · Substantial damageNTSB CHI93FA267Accident · 4 fatalField investigationFinal reportCessna 310C · Norton, KSThe pilot's failure to maintain aircraft control due to alcohol impairment. Factors which contributed to the accident were: the pilot's intentional flight into adverse weather, fog, and the dark night.Jul 22, 1993 · N339R · DestroyedNTSB MIA93T#A01Accident · No injuriesClass 3Final reportBell 47G-3B · Orlando, FLJul 21, 1993 · N40SD · Substantial damageNTSB MIA93FA160Accident · 4 fatalField investigationFinal reportPiper PA-28 · Morriston, FLVFR flight by the pilot(s) into instrument meteorological conditions (IMC) and failure to maintain adequate altitude (or clearance) from the tower. The proximity of the tower/guy wires and weather condition were related factors.Jul 21, 1993 · N5096W · DestroyedNTSB CHI93LA317Accident · No injuriesLimited investigationFinal reportCessna 182M · Ironwood, MIThe pilot's improper flare for landing.Jul 21, 1993 · N91705 · Substantial damageNTSB CHI93LA269Accident · 1 fatalLimited investigationFinal reportBeech A23 · Boyceville, WIthe failure of the pilot to attain the proper touchdown point, and his failure to perform a go-around.Jul 21, 1993 · N3578R · DestroyedNTSB CHI93IA312Incident · No injuriesIncident investigationFinal reportBritish Aerospace 146-300A · Chicago, ILwas a crack in the fuel system fuel flow distribution manifold which resulted from an inadequate design by the manufacturer.Jul 21, 1993 · N611AW · Minor damageNTSB BFO93LA133Accident · Serious injuriesLimited investigationFinal reportBeatty Glasair SH-2 · Cape May, NJInadequate preflight by the pilot by not assuring the fuel selector was in the proper position for takeoff, which resulted in fuel starvation and subsequent loss of engine power; and failure of the pilot to maintain sufficient airspeed, which resulted in a…Jul 21, 1993 · N522EB · DestroyedNTSB ATL93LA131Accident · Minor injuriesLimited investigationFinal reportAero Commander 112 · Broadway, NCWater and contaminants in the aircraft fuel system, and the pilot's inadequate preflight of the aircraft. A factor was the rough terrain at the forced landing site.Jul 21, 1993 · N1035J · Substantial damageNTSB ANC93LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Port Alsworth, AKFuel contamination and the pilot in command's improper preflight planning/decision. A factor was the pilot's inadequate airspeed with which to make a normal landing following the engine power loss.Jul 21, 1993 · N472GF · Substantial damageNTSB ANC93FA123Accident · Serious injuriesField investigationFinal reportCessna A185F · Denali Nat'L Pk, AKFuel exaustion due to the the pilot-in-command's failure to refuel. Factors in the accident were: pressure by management personnel and lack of suitable terrain during the forced landing.Jul 21, 1993 · N124KT · DestroyedNTSB MIA93LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-105 · Jacksonville, FLThe improper procedures by the pilot-in-command.Jul 20, 1993 · N45124 · No damageNTSB LAX93LA293Accident · No injuriesLimited investigationFinal reportAviat A-1 · Selma, CAthe pilot-in-command's failure to maintain direction control, inadequate compensation for the existing wind conditions, and improper use of the rudder. The pilot's lack of total experience in the accident airplane make and model is a factor in this accident.Jul 20, 1993 · N9614L · Substantial damage