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 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,…Jul 12, 1993 · N531JD · DestroyedNTSB 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.Jul 12, 1993 · N818AN · DestroyedNTSB DEN93LA076Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Kaplan, LAFailure of the spray rig which sprayed chemicals into the pilot's eyes temporarily blinding him.Jul 12, 1993 · N9680 · Substantial damageNTSB 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.Jul 12, 1993 · N8906L · Substantial damageNTSB CHI93LA250Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Harvel, ILThe pilot-in-command's inadequate preflight planning.Jul 12, 1993 · N4201Y · DestroyedNTSB CHI93DEE03Accident · Serious injuriesFinal reportMaxair MU532 · Fox Lake, ILthe failure of the pilot to maintain the necessary altitude above the terrain.Jul 12, 1993 · NONE · Substantial damageNTSB BFO93WA141Accident · 4 fatalForeign investigationCessna 177RG · Marseille, FranceJul 12, 1993 · N1954Q · Substantial damageNTSB 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.Jul 12, 1993 · N4295X · DestroyedNTSB BFO93LA121Accident · No injuriesLimited investigationFinal reportCessna 404 · Cincinnati, OHThe failure of a number three engine cylinder hold down bolt due to fatigue.Jul 12, 1993 · N37167 · Substantial damageNTSB 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.Jul 12, 1993 · N88189 · DestroyedNTSB 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…Jul 12, 1993 · N9116F · Substantial damageNTSB 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.Jul 11, 1993 · N31349 · Substantial damageNTSB 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.Jul 11, 1993 · UNREG · DestroyedNTSB CHI93LA255Accident · No injuriesLimited investigationFinal reportCessna 182 · Prairie City, IAthe pilot's premature liftoff. Factors in the accident are the soft and wet sod runway.Jul 11, 1993 · N91162 · Substantial damageNTSB 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.Jul 11, 1993 · N7113E · Substantial damageNTSB 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…Jul 11, 1993 · N485MH · DestroyedNTSB 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.Jul 11, 1993 · N56476 · DestroyedNTSB ANC93LA122Accident · No injuriesLimited investigationFinal reportHelio H295 · Talkeetna, AKThe pilot in command's selection of unsuitable terrain. The rough/uneven terrain was a factor.Jul 11, 1993 · N67697 · Substantial damageNTSB 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.Jul 10, 1993 · N10050 · Substantial damageNTSB 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.Jul 10, 1993 · N47407 · Substantial damageNTSB 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…Jul 10, 1993 · N36L · DestroyedNTSB FTW93FA211Accident · 1 fatalField investigationFinal reportRockwell S-2R · Bastrop, LAThe pilot's failure to maintain terrain clearance.Jul 10, 1993 · N8512V · DestroyedNTSB CHI93LA261Accident · No injuriesLimited investigationFinal reportBeech F33A · Kahoka, MOThe pilot's premature liftoff. The soft runway condition was a factor.Jul 10, 1993 · N18RB · Substantial damageNTSB CHI93LA257Accident · No injuriesLimited investigationFinal reportCessna T188C · Wheaton, MNThe pilot's failure to maintain alignment during takeoff roll.Jul 10, 1993 · N3591J · Substantial damageNTSB 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.Jul 10, 1993 · N1630H · Substantial damageNTSB CHI93IA248Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-40 · Detroit, MIthe failure of a navigation system (#1 INS) for reason or reasons undetermined.Jul 10, 1993 · N158US · No damageNTSB CHI93FA249Accident · Serious injuriesField investigationFinal reportAmerican Eurocopter AS350BA · West Plains, MOUndetermined.Jul 10, 1993 · N350BA · DestroyedNTSB LAX93T#A05Accident · No injuriesClass 3Final reportGrumman GS-2F · Grass Valley, CAJul 9, 1993 · N450DF · Substantial damageNTSB 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…Jul 9, 1993 · N75901 · Substantial damageNTSB 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.Jul 9, 1993 · N8522V · Substantial damageNTSB CHI93LA253Accident · Minor injuriesLimited investigationFinal reportCessna 210 · West Bend, WIThe inadequate preflight by pilot-in-command. A factor was the rough terrain.Jul 9, 1993 · N50RD · Substantial damageNTSB 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.Jul 9, 1993 · N6279A · DestroyedNTSB 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.Jul 9, 1993 · N46116 · Substantial damageNTSB 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.Jul 9, 1993 · N1ZA · Substantial damageNTSB 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.Jul 9, 1993 · N9984M · Minor damageNTSB 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.Jul 9, 1993 · N5960H · 2 aircraft · Substantial damageNTSB SEA93LA150Accident · No injuriesLimited investigationFinal reportHoopes Hummelbird · Salt Lake City, UTA fractured crankshaft.Jul 8, 1993 · N2227S · Substantial damageNTSB SEA93FA151Accident · 1 fatalField investigationFinal reportPiper PA-12 · Laramie, WYPoor inflight planning and an inadvertent stall.Jul 8, 1993 · N3108M · Substantial damageNTSB MIA93LA151Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Magee, MSInstallation of an incorrect oil filter adapter plate stud which secures the plate to the accessory case.Jul 8, 1993 · N3896H · Substantial damageNTSB 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.Jul 8, 1993 · N9588F · Substantial damageNTSB 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…Jul 8, 1993 · N1392T · DestroyedNTSB 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…Jul 8, 1993 · N501R · DestroyedNTSB FTW93LA212Accident · No injuriesLimited investigationFinal reportCessna A188B · Temple, TXPilot's failure to maintain proper object/terrain clearance. Factors were tailwinds and high density altitude.Jul 8, 1993 · N4739R · Substantial damageNTSB 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.Jul 8, 1993 · N13722 · Substantial damageNTSB FTW93LA209Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Longview, TXThe pilot's failure to follow procedures.Jul 8, 1993 · N3631L · Minor damageNTSB 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.Jul 8, 1993 · N8967P · Substantial damageNTSB DEN93FA075Accident · 1 fatalField investigationFinal reportWiley Pitts S-1-E · Walters, OKPerformance of an aerobatic maneuver at an altitude insufficient for adequate terrain clearance.Jul 8, 1993 · N70BW · DestroyedNTSB SEA93LA149Accident · No injuriesLimited investigationFinal reportBeech V35B · Friday Harbor, WAFuel starvation and poor in-flight planning/decision.Jul 7, 1993 · N4084S · Substantial damageNTSB 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.Jul 7, 1993 · N7630C · DestroyedNTSB FTW93FA207Accident · 2 fatalField investigationFinal reportTaylorcraft BC12-D · Little Rock, ARThe pilot's loss of control of the airplane as a result of physical impairment.Jul 7, 1993 · N95851 · Substantial damage