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 LAX93LA288Accident · 2 fatalLimited investigationFinal reportRobinson R22B · Weimar, CAThe failure of both pilots to see and avoid the charted power line. Factors which contributed to the accident were: the failure of the utility companies to adequately review the hazard posed by the wires following a previous collision at the same location,…NTSB LAX93FA287Accident · 3 fatalField investigationFinal reportCessna 402C · Las Vegas, NVThe pilot's failure to maintain adequate airspeed while maneuvering in the traffic pattern. A factor which contributed to the accident was the pilot's failure to assure that the nose baggage compartment door was secured.NTSB DEN93LA076Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAFailure of the spray rig which sprayed chemicals into the pilot's eyes temporarily blinding him.NTSB CHI93LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clarence, MOIs the pilot in command's failure to maintain proper clearance. A factor to the accident were the trees at the end of the field to be sprayed.NTSB CHI93LA250Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Harvel, ILThe pilot-in-command's inadequate preflight planning.NTSB CHI93DEE03Accident · Serious injuriesFinal reportMaxair MU532 · Fox Lake, ILthe failure of the pilot to maintain the necessary altitude above the terrain.NTSB BFO93WA141Accident · 4 fatalForeign investigationCessna 177RG · Marseille, FranceNTSB BFO93LA122Accident · Serious injuriesLimited investigationFinal reportSchultz/Bowers FLY Baby 1A · Conneaut, OHOperational failure of the left magneto's high tension wiring due to grease/corrosion, which resulted in a progressive power loss and subsequent forced landing.NTSB BFO93LA121Accident · No injuriesLimited investigationFinal reportCessna 404 · Cincinnati, OHThe failure of a number three engine cylinder hold down bolt due to fatigue.NTSB BFO93FA119Accident · 1 fatalField investigationFinal reportBellanca 8GCBC · Berlin, MDFailure of the pilot to maintain airspeed during pullup from an attempted banner pickup, which resulted in a stall.NTSB ATL93FA127Accident · 1 fatalField investigationFinal reportHughes 369HS · Talladega, ALThe pilot's poor in-flight decision to land downwind in a confined area that was surrounded by high obstructions, and his failure to properly compensate for the tailwind condition. A factor related to the accident was: the pilot's lack of total experience in…NTSB LAX93LA286Accident · No injuriesLimited investigationFinal reportStephens VP2 · Lodi, CAthe grounding of the magneto coil to the magneto case due to a crack in the coil sheath.NTSB DEN93LA077Accident · 2 fatalLimited investigationFinal reportWeedhopper B · Port Arthur, TXThe failure of the wing fabric and wing spar. Factors were: the improper design change, major repair, and rebuilding of the aircraft by the pilot in command.NTSB CHI93LA255Accident · No injuriesLimited investigationFinal reportCessna 182 · Prairie City, IAthe pilot's premature liftoff. Factors in the accident are the soft and wet sod runway.NTSB BFO93LA118Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Flemington, NJThe passenger's inadvertent activation of the burner after the landing, causing the terrain to burn and subsequently igniting the Balloon envelope.NTSB BFO93LA117Accident · Serious injuriesLimited investigationFinal reportHolmes Special · Chavies, KYFuel starvation due to the pilot's improper decision to take off with a low fuel level. Factors related to the accident were the low fuel level, the pilot's lack of familiarity with the characteristics of the fuel system, and the uneven terrain in the…NTSB BFO93LA116Accident · 1 fatalLimited investigationFinal reportMaule M-6-235 · Willoughby, OHFailure of the pilot to maintain adequate airspeed during a pullup maneuver, which resulted in a stall. A factor related to the accident was the lack of altitude for recovery.NTSB ANC93LA122Accident · No injuriesLimited investigationFinal reportHelio H295 · Talkeetna, AKThe pilot in command's selection of unsuitable terrain. The rough/uneven terrain was a factor.NTSB SEA93LA157Accident · No injuriesLimited investigationFinal reportCessna 150L · Ontario, ORThe pilot in command's failure to maintain proper clearance. A factor contributing to the accident was the pilot in command's delayed go around.NTSB MIA93LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Jacksonville, FLFailure of the pilot in command to maintain directional control during the landing. Contributing to the accident was the excessive airspeed while landing and failure of the pilot to recover from the bounced landing.NTSB MIA93LA152Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Atlantic Ocean (Atlantic Ocean)Total loss of engine power from both engines due to fuel exhaustion after the pilot became lost/disoriented. Contributing to the accident was the delay by the pilot-in-command to execute the emergency procedure by resetting the alternators and voltage…NTSB FTW93FA211Accident · 1 fatalField investigationFinal reportRockwell S-2R · Bastrop, LAThe pilot's failure to maintain terrain clearance.NTSB CHI93LA261Accident · No injuriesLimited investigationFinal reportBeech F33A · Kahoka, MOThe pilot's premature liftoff. The soft runway condition was a factor.NTSB CHI93LA257Accident · No injuriesLimited investigationFinal reportCessna T188C · Wheaton, MNThe pilot's failure to maintain alignment during takeoff roll.NTSB CHI93LA252Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Senter, MIThe pilot-in-command's inadequate pre-flight planning. Factors relating to this accident are fuel exhaustion, unsuitable terrain on which to make an emergency landing, as well as an inadvertent stall.NTSB CHI93IA248Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Detroit, MIthe failure of a navigation system (#1 INS) for reason or reasons undetermined.NTSB CHI93FA249Accident · Serious injuriesField investigationFinal reportAmerican Eurocopter AS350BA · West Plains, MOUndetermined.NTSB LAX93T#A05Accident · No injuriesClass 3Final reportGrumman GS-2F · Grass Valley, CANTSB LAX93LA284Accident · No injuriesLimited investigationFinal reportCessna 172N · Alturus, CAThe pilot's delay in aborting the takeoff. The pilot's premature rotation and his failure to follow the procedures in the airplane flight manual regarding use of the mixture control, the high density altitude condition and the pilot's lack of total flight…NTSB FTW93LA214Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Bono, ARThe airplane's takeoff performance being exceeded by the PIC. A factor was the pilot's inability to safely reject the takeoff.NTSB CHI93LA253Accident · Minor injuriesLimited investigationFinal reportCessna 210 · West Bend, WIThe inadequate preflight by pilot-in-command. A factor was the rough terrain.NTSB CHI93FA247Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Houghton, MIThe pilot's failure to maintain sufficient airspeed while maneuvering which resulted in a stall/mush. Intentional buzzing was a factor.NTSB BFO93LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Cuddy, PAThe student pilot's failure to maintain directional control during flare/touchdown. The proximity of the ravine and trees to the runway was a related factor.NTSB ANC93LA113Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe pilot-in-command's improper positioning of the fuel selector. Factor was the soft condition of the forced landing area.NTSB ANC93IA115Incident · No injuriesIncident investigationFinal reportCessna 207 · Nome, AKThe chafed fuel line and chafed electrical wire and the improper maintenance procedure used to secure the electrical wire with a tie wrap.NTSB ANC93FA114Accident · 4 fatalField investigationFinal reportPiper PA-16 · Fairbanks, AKFailure of the pilots of both airplanes to see and avoid each other, and the alcohol impairment of the pilot-in-command of the PA-16, N5960H. A factor which contributed to the accident was the sunglare.NTSB SEA93LA150Accident · No injuriesLimited investigationFinal reportHoopes Hummelbird · Salt Lake City, UTA fractured crankshaft.NTSB SEA93FA151Accident · 1 fatalField investigationFinal reportPiper PA-12 · Laramie, WYPoor inflight planning and an inadvertent stall.NTSB MIA93LA151Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Magee, MSInstallation of an incorrect oil filter adapter plate stud which secures the plate to the accessory case.NTSB LAX93LA285Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Rialto, CALoss of engine power for undetermined reasons, and the flight instructor's improper flare during the autorotation which resulted in a tail boom strike.NTSB LAX93FA282Accident · Minor injuriesField investigationFinal reportPiper PA-34-200 · La Verne, CAThe flight instructor's failure to obtain/maintain best the single-engine rate-of-climb airspeed, and his failure to ensure that the landing gear was retracted. A factor related to the accident was contamination in the fuel system, which blocked fuel flow…NTSB LAX93FA281Accident · 1 fatalField investigationFinal reportRobinson R22B · Honolulu, HIThe instructor allowing the student fly solo in wind conditions exceeding the maximum allowable winds in the training syllabus, and also near the maximum demonstrated controllability envelope for the helicopter. Factors which contributed to the accident were…NTSB FTW93LA212Accident · No injuriesLimited investigationFinal reportCessna A188B · Temple, TXPilot's failure to maintain proper object/terrain clearance. Factors were tailwinds and high density altitude.NTSB FTW93LA210Accident · No injuriesLimited investigationFinal reportCessna 172M · Lamesa, TXThe pilot's improper flare, improper recovery from a bounced landing and the inadvertent stall. A factor was the gusty wind.NTSB FTW93LA209Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Longview, TXThe pilot's failure to follow procedures.NTSB DEN93LA074Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Grand Junction, COFailure of the pilot in command to follow manual gear extension procedures. A factor was a total electrical failure.NTSB DEN93FA075Accident · 1 fatalField investigationFinal reportWiley Pitts S-1-E · Walters, OKPerformance of an aerobatic maneuver at an altitude insufficient for adequate terrain clearance.NTSB SEA93LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Friday Harbor, WAFuel starvation and poor in-flight planning/decision.NTSB FTW93LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Baton Rouge, LAThe student pilot's failure to abort the landing in a timely manner and his failure to maintain directional control.NTSB FTW93FA207Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Little Rock, ARThe pilot's loss of control of the airplane as a result of physical impairment.