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 LAX94LA177Accident · 2 fatalLimited investigationFinal reportGardner E-RACER Mark II · Parker, AZthe failure of the pilot to maintain control of the aircraft while maneuvering in the traffic pattern following a failure of the throttle control. A factor in the accident was a throttle linkage separation after takeoff.Apr 4, 1994 · N96WM · DestroyedNTSB DCA94RA055Accident · No injuriesForeign investigationLearjet 55 · Seville, SpainApr 4, 1994 · IKILONTSB CHI94LA127Accident · No injuriesLimited investigationFinal reportBeech 35 · Anderson, INthe pilot's failure to maintain directional control during the landing roll. A factor related to the accident was the rough terrain encountered following the loss of control.Apr 4, 1994 · N9597R · Substantial damageNTSB CHI94FA128Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Alliance, NEThe pilot's spatial disorientation and inadvertant entry into a spiral dive. Factors were the pilot's lack of total instrument experience and the weather conditions of blowing snow and turbulence.Apr 4, 1994 · N5399Y · DestroyedNTSB BFO94WA063Accident · No injuriesForeign investigationABC ABC 60 Plus · Romsley, United KingdomApr 4, 1994 · N2017A · Substantial damageNTSB BFO94LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Willimantic, CTThe instructor's inadequate supervision and the student's improper landing flare.Apr 4, 1994 · N30DW · Substantial damageNTSB BFO94LA060Accident · Serious injuriesLimited investigationFinal reportTalago Thundergull JT2 · Clarksburg, WVThe builder's inadequate maintenance adjustment which resulted in the aileron control assembly becoming disconnected.Apr 4, 1994 · N73ST · Substantial damageNTSB SEA94LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Spangle, WAThe pilot not maintaining clearance from the fence. A factor in the accident was the dusk light conditions.Apr 3, 1994 · N6746B · Substantial damageNTSB SEA94FA096Accident · 4 fatalField investigationFinal reportBell 206B3 · Lamoille, NVThe ingestion of foreign material (snow) in the engine, which resulted in a flameout (loss of engine power). Factors related to the accident were: the adverse weather conditions (snow falling & high density altitude), the lack of snow covers to protect the…Apr 3, 1994 · N27736 · DestroyedNTSB LAX94LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Gasquet, CAThe failure of the pilot to adequately compensate for the cross- wind conditions, and to maintain proper alignment with the runway.Apr 3, 1994 · N6290D · DestroyedNTSB FTW94LA119Accident · Serious injuriesLimited investigationFinal reportCessna 208 · Whitewright, TXThe inadvertent stall when too many parachutist hung on the outside of the aircraft.Apr 3, 1994 · N9421F · Minor damageNTSB FTW94LA116Accident · Serious injuriesLimited investigationFinal reportAero Commander 100-180 · Steamboat Sprgs, COAn inadvertent stall after liftoff. Factors were an unfavorable wind and high density altitude.Apr 3, 1994 · N4015X · Substantial damageNTSB BFO94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEInadequate clearance from obstacles, which resulted in birds strike. A factor was night conditions.Apr 3, 1994 · N2542L · Substantial damageNTSB MIA94LA109Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLFailure of the instructor pilot (CFI) to maintain minimum control speed (VMC) during the go-around, which resulted in a loss of control. A factor related to the accident was: the delay by the dual student to extend the landing gear.Apr 2, 1994 · N8303G · Substantial damageNTSB MIA94IA110Incident · No injuriesIncident investigationFinal reportBoeing 727-243 · Orlando, FLThe total failure of the left main landing gear door actuator fitting due to fatigue cracking in the fitting. Contributing to the accident was inadequate written inspection procedures by the aircraft manufacturer.Apr 2, 1994 · N59412 · Minor damageNTSB LAX94LA183Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beowawe, NVthe pilot's inadvertent application of the brakes combined with excessive forward control pressure during recovery from a bounced landing.Apr 2, 1994 · N8884D · Substantial damageNTSB LAX94LA180Accident · Serious injuriesLimited investigationFinal reportCurry FLY-BABY · Bisbee, AZa loss of engine power due a blockage in the fuel tank outlet which caused fuel starvation.Apr 2, 1994 · N183RC · DestroyedNTSB FTW94LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · San Angelo, TXThe partial loss of engine power. A factor was the lack of suitable terrain.Apr 2, 1994 · N3521K · Substantial damageNTSB CHI94DCQ01Accident · 1 fatalFinal reportRobert O. ELY STARDUSTER-II SA300 · Baxter Springs, KSthe pilot's failure to maintain altitude during an aerobatic maneuver on takeoff. A factor related to the accident was the pilot performing an aerobatic maneuver.Apr 2, 1994 · N107UP · DestroyedNTSB BFO94LA059Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Oneonta, NYThe pilot's failure to maintain directional control during takeoff. A related factor was the crosswind component.Apr 2, 1994 · N28224 · Substantial damageNTSB BFO94LA057Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Berea, KYThe pilot-in-command's failure to maintain adequate airspeed during the takeoff. A factor related to the accident is the gusty wind conditions.Apr 2, 1994 · N5868B · DestroyedNTSB ATL94LA074Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Winston-Salem, NCThe pilot's failure to place the aircraft fuel selector to the tank with fuel remaining.Apr 2, 1994 · N4298Y · Substantial damageNTSB ATL94LA073Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Boone, NCThe excessive speed used on final approach to the short runway by the pilot, and the failure of the pilot to use the proper touchdown point on the runway for landing.Apr 2, 1994 · N5704P · Substantial damageNTSB SEA94LA094Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Rimrock, WAFuel exhaustion, the pilot in command's failure to refuel the aircraft, and the inability to successfully execute an auto- rotation landing because of the low altitude.Apr 1, 1994 · N5211R · Substantial damageNTSB FTW94LA117Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Roswell, NMThe loss of control due to clear air turbulence.Apr 1, 1994 · N8961P · Substantial damageNTSB FTW94FA114Accident · Serious injuriesField investigationFinal reportAerospatiale AS-350-B2 · Telluride, COFailure by the pilot to maintain control of the aircraft. Factors were unfavorable winds and improper approach planning.Apr 1, 1994 · N59715 · Substantial damageNTSB CHI94LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-300 · Beloit, KSthe pilot's failure to maintain sufficient airspeed during the initial takeoff climb.Apr 1, 1994 · N3735E · Substantial damageNTSB CHI94LA125Accident · No injuriesLimited investigationFinal reportCessna T210-M · Pomona, MOThe seperation of the landing gear door actuator, resulting in total loss of hydraulic fluid.Mar 31, 1994 · N732YK · Substantial damageNTSB CHI94LA124Accident · No injuriesLimited investigationFinal reportCessna 177RG · Charlotte, MIthe deer which ran onto the runway. Factors related to the accident were the night conditions and the runway lights which were contacted.Mar 31, 1994 · N7581V · Substantial damageNTSB SEA94LA093Accident · No injuriesLimited investigationFinal reportCessna 210D · Cobalt, IDThe pilot selected unsuitable terrain for landing. Factors in the accident were: the wet runway and rising terrain that precluded a go-around.Mar 30, 1994 · N3820Y · Substantial damageNTSB SEA94LA092Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Levan, UTThe left main landing gear wheel bearing broke resulting in the wheel jamming and the airplane nosing over.Mar 30, 1994 · N6754Q · Substantial damageNTSB FTW94LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe loss of engine power for undetermined reasons. Factors were the wire strike and lack of suitable terrain.Mar 30, 1994 · N4646B · Substantial damageNTSB BFO94WA088Accident · No injuriesForeign investigationCessna CE-421C · Ingolstadt, GermanyMar 30, 1994 · N26563 · Substantial damageNTSB ATL94LA072Accident · Serious injuriesLimited investigationFinal reportFoote M1 Mustang · Marietta, GAThe failure of the pilot to maintain control of the aircraft. Factors in the accident were the lack of familiarization with the aircraft by the pilot, and throttle cable rigging in the experimental aircraft.Mar 30, 1994 · N130MJ · Substantial damageNTSB MIA94LA108Accident · No injuriesLimited investigationFinal reportCessna 170 · Olive Branch, MSFailure of the pilot-in-command to apply carburetor heat before reducing engine power to descend resulting in the partial loss of engine power due to carburetor ice. Contributing to the accident was the unsuitable terrain encountered during the forced landing…Mar 29, 1994 · N2509V · Substantial damageNTSB LAX94LA175Accident · No injuriesLimited investigationFinal reportMooney M-20C · Hyampom, CAThe pilot's failure to follow proper procedures by assuring that the landing gear locking mechanism was properly engaged.Mar 29, 1994 · N4045N · Substantial damageNTSB MIA94LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Parkland, FLImproper planning/decision by the director of operations, and failure of the instructor pilot to take adequate remedial action. A factor related to the accident was: the soft/wet runway condition.Mar 28, 1994 · N9786B · Substantial damageNTSB FTW94LA113Accident · No injuriesLimited investigationFinal reportNorth American SNJ-5 · Houston, TXThe pilot's failure to maintain directional control.Mar 28, 1994 · N73SL · Substantial damageNTSB ANC94IA049Incident · Minor injuriesIncident investigationFinal reportCessna 207 · Anchorage, AKThe partial failure of the no. 4 piston from over temperature (detonation).Mar 28, 1994 · N29CF · Minor damageNTSB NYC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hopedale, MAthe certified flight instructor's delay in taking remedial action by not initiating the go-around, resulting in the in-flight collision with the tree.Mar 27, 1994 · N2598Q · Substantial damageNTSB MIA94LA105Accident · 1 fatalLimited investigationFinal reportWallace Thorp T-18 · Boynton Beach, FLThe pilot in command's exceeding the designed stress limits of the aircraft resulting in overload failure of the left wing outboard attach fitting. This resulted in inflight separation of the outboard left wing, and subsequent inflight collision with the…Mar 27, 1994 · N215CK · DestroyedNTSB FTW94LA110Accident · No injuriesLimited investigationFinal reportBell 206B · Belen, NMThe hard landing due to a delayed flare and improper touchdown. A factor was the loss of engine power.Mar 27, 1994 · N2779B · Substantial damageNTSB ATL94FA071Accident · 1 fatalField investigationFinal reportBeech 58TC · Gulf Shores, ALThe pilot's failure to maintain aircraft control during the base turn. Factors were the pilot's inadequate preflight, high winds with gusts at the airport, and the pilot's diverted attention due to the open baggage door.Mar 27, 1994 · N200DL · DestroyedNTSB SEA94LA091Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Woodland, WAAirspeed was not maintained.Mar 26, 1994 · N5537E · Substantial damageNTSB MIA94WA101Accident · Serious injuriesForeign investigationCessna 402B · Cat Island, BahamasMar 26, 1994 · N7929Q · DestroyedNTSB MIA94LA107Accident · No injuriesLimited investigationFinal reportCessna 310Q · West Palm Beach, FLThe pilot-in-command's inadvertent landing with the brakes on, resulting in a bounced landing and his failure to maintain airspeed after a bounced landing which resulted in the aircraft stalling and landing hard.Mar 26, 1994 · N69978 · Substantial damageNTSB MIA94LA104Accident · No injuriesLimited investigationFinal reportCessna 172N · Stuart, FLPoor in-flight planning/decision by the pilot-in-command. Contributing to the accident was wind information disregarded by the pilot-in-command.Mar 26, 1994 · N6HV · Substantial damageNTSB MIA94LA103Accident · No injuriesLimited investigationFinal reportCessna 172RG · Boca Raton, FLThe failure of the aircraft operator to comply with engine manufacturers service bulletins which resulted in improper inspection of exhaust valves and subsequent sticking of the no. 4 exhaust valve.Mar 26, 1994 · N9781B · Substantial damageNTSB MIA94LA102Accident · Minor injuriesLimited investigationFinal reportCessna U206G · Key West, FLThe failure of the pilot-in-command to ensure the aircraft was at an adequate altitude above the water before initiating a turn which resulted in the right float contacting the water during the turn and the aircraft cartwheeling.Mar 26, 1994 · N5087R · Substantial damageNTSB LAX94LA174Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Hi. Nat'L Park, HIthe pilot's in-flight decision to maneuver the helicopter close to an active volcano steam vent which resulted in a whiteout condition from the steam, and the pilot's subsequent loss of visual contact with the ground.Mar 26, 1994 · N113RS · Substantial damage