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 BFO94LA149Accident · Serious injuriesLimited investigationFinal reportMooney M20G · Bowling Green, OHfuel exhaustion for undetermined reason(s), which resulted in loss of engine power and a subsequent forced landing. A factor relating to the accident was: faulty fuel quantity gauge/system.Aug 24, 1994 · N3916N · Substantial damageNTSB BFO94LA147Accident · 1 fatalLimited investigationFinal reportRans S-14 Airaile · Phoenixville, PAthe pilot's failure to perform a preflight inspection, which resulted in a loss of engine power due to fuel contamination.Aug 24, 1994 · UNREG · DestroyedNTSB BFO94LA146Accident · Serious injuriesLimited investigationFinal reportAdvanced Acft Waco 10 GXE · Rochester, NHthe partial loss of engine power for undetermined reasons. Related factors were unsuitable terrain (trees) and the inadvertent stall.Aug 24, 1994 · NC5852 · DestroyedNTSB ATL94FA162Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Byromville, GAThe pilot's failure to maintain aircraft control, resulting in an inadvertent stall.Aug 24, 1994 · N7776D · DestroyedNTSB MIA94LA200Accident · No injuriesLimited investigationFinal reportCessna 152 · Osteen, FLEngine power loss due to blockage of the carburetor fuel discharge nozzle pickup by an insect that inadvertently entered the carburetor during overhaul resulting in fuel starvation.Aug 23, 1994 · N6088H · Substantial damageNTSB LAX94LA337Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Sedona, AZa tip over of the balloon and basket during a high wind landing due to the pilot's inability to compensate for the increased wind speed conditions during the final stages of the flight and landing.Aug 23, 1994 · N90299 · No damageNTSB FTW94LA277Accident · No injuriesLimited investigationFinal reportHodges P-51-51 · Beaumont, TXThe improper adjustment of the propeller system pitch.Aug 23, 1994 · N2073S · Substantial damageNTSB FTW94LA276Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Tulsa, OKLoss of engine power following fuel starvation caused by improper tank selection by the pilot. A factor was the lack of suitable terrain for the forced landing.Aug 23, 1994 · N94AA · Substantial damageNTSB CHI94LA294Accident · 1 fatalLimited investigationFinal reportWatson KR-2 · Pekin, ILAircraft control not maintained by the pilot and the subsequent stall. A factor associated with the accident was the pilot's lack of recent flight experience.Aug 23, 1994 · N121CW · DestroyedNTSB CHI94LA292Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Clifton, ILthe pilots failure to keep visual contact with and to avoid unmarked powerlines adjacent to the crop field he was spraying.Aug 23, 1994 · N8971H · DestroyedNTSB BFO94LA145Accident · No injuriesLimited investigationFinal reportMooney M-20B · Marion, OHInadequate maintenance which resulted in the throttle cable becoming disconnected from the carburetor.Aug 23, 1994 · N778R · Substantial damageNTSB BFO94LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Vestal, NYLoss of engine power during an aborted landing due to the throttle cable separating from the carburetor.Aug 23, 1994 · N61774 · Substantial damageNTSB ATL94LA164Accident · Serious injuriesLimited investigationFinal reportAdvance Buccaneer II · Townsville, NCThe failure of the pilot to maintain airspeed and aircraft control during the initial climb.Aug 23, 1994 · UNREG · Substantial damageNTSB SEA94T#A04Accident · No injuriesClass 3Final reportde Havilland DHC-6-300 · Mccall, IDAug 22, 1994 · N141Z · Substantial damageNTSB MIA94LA199Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Aguadilla, PRThe failure of the pilot-in-command to divert and refuel resulting in loss of engine power due to fuel exhaustion.Aug 22, 1994 · N6332P · Substantial damageNTSB LAX94LA334Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain directional control by his improper use of the flight controls. Factors related to this accident were the pilot's lack of total experience and the crosswind.Aug 22, 1994 · N172ST · Substantial damageNTSB FTW94LA278Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Lazbuddie, TXThe pilot's premature liftoff and the resultant stall during takeoff. A factor was the density altitude.Aug 22, 1994 · N4360S · Substantial damageNTSB ATL94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Washington, NCThe pilot's inadequate inflight planning that resulted in fuel exhaustion. A factor was the unsuitable terrain, a plowed field, available for landing.Aug 22, 1994 · N7726Z · Substantial damageNTSB ANC94LA118Accident · No injuriesLimited investigationFinal reportCessna 150J · Talkeentna, AKThe unsuitable takeoff area selected. A factor was the soft spot in the airstrip's surface.Aug 22, 1994 · N61272 · Substantial damageNTSB SEA94LA217Accident · Minor injuriesLimited investigationFinal reportAllen D. Potts WAG-A-BOND · Benton City, WAFuel starvation and inadequate compensation for wind conditions. A factor to the accident was soft terrain.Aug 21, 1994 · N47AT · Substantial damageNTSB LAX94LA338Accident · No injuriesLimited investigationFinal reportBeech A36 · So. Lake Tahoe, CAthe pilot's delayed decision to abort the takeoff when the performance deficiency first became apparent.Aug 21, 1994 · N36DY · Substantial damageNTSB LAX94LA335Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Simi Valley, CAFuel exhaustion after the student pilot became lost/disoriented. Factors related to the accident were: failure of the supervising flight instructor (CFI) to follow the FAA approved syllabus, inadequate supervision by the company/operator management, darkness,…Aug 21, 1994 · N739VY · Substantial damageNTSB CHI94LA295Accident · No injuriesLimited investigationFinal reportSchreiber-Stitts SA-3B · Muscatine, IAA loose intake manifold pipe on the airplane's engine which resulted from improper maintenance. Factors associated with this accident were the builder/pilot improperly installing the intake manifold pipe and the alternate landing area's high vegetation.Aug 21, 1994 · N79GJ · Substantial damageNTSB BFO94LA142Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Leesburg, OHThe pilot misjudged his altitude and airspeed during landing resulting in an overrun and collision with a fence. A related factor was the wet runway.Aug 21, 1994 · N92483 · Substantial damageNTSB ATL94LA159Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Columbia, NCThe failure of the aircraft carburetor that resulted in a total loss of engine power.Aug 21, 1994 · N8819L · Substantial damageNTSB ANC94LA120Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Northway, AKThe pilot's inadequate evaluation of the weather and his failure to maintain visual lookout during the maneuver. Factors were the low ceilings and obscuration.Aug 21, 1994 · N31670 · Substantial damageNTSB ANC94LA119Accident · No injuriesLimited investigationFinal reportCessna 150 · Delta Junction, AKThe pilot's inadequate preflight planning and preparation.Aug 21, 1994 · N2677J · Substantial damageNTSB SEA94LA218Accident · No injuriesLimited investigationFinal reportBeech 99 · Helena, MTLanding gear locking mechanism overload and improper rigging.Aug 20, 1994 · N14MV · Substantial damageNTSB NYC94FA161Accident · 1 fatalField investigationFinal reportRockwell 112A · Binghamton, NYThe pilot inadequate preflight preparation that resulted in the decision to attempt takeoff on a runway which was beyond the airplane takeoff performance capability to clear obstacles.Aug 20, 1994 · N1253J · DestroyedNTSB LAX94LA330Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Page, AZThe pilot's failure to follow procedures to assure that the landing gear was extended. His diverted attention due to the previous two go-arounds is a factor in this accident.Aug 20, 1994 · N88FC · DestroyedNTSB LAX94LA329Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oakdale, CA1) The flight instructor's failure to attain a proper touchdown point on the runway, 2) his failure to initiate a timely go around, and 3) his inadequate supervision of the flight.Aug 20, 1994 · N2436N · Substantial damageNTSB FTW94LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Russellville, ARVFR flight into IMC.Aug 20, 1994 · N41472 · Substantial damageNTSB BFO94LA141Accident · 1 fatalLimited investigationFinal reportLafrance V-Witt W2 · Wilmington, OHLoss of engine power for an undetermined reason, and failure of the pilot to maintain adequate airspeed while attempting a maneuver for an emergency landing, which resulted in a stall and collision with terrain. A factor related to the accident was: the lack…Aug 20, 1994 · N63VW · DestroyedNTSB ATL94LA161Accident · No injuriesLimited investigationFinal reportCessna 207 · Nags Head, NCThe failure of the mixture control cable which resulted in a loss of engine power.Aug 20, 1994 · N1670U · Substantial damageNTSB ANC94LA123Accident · No injuriesLimited investigationFinal reportHelio H295 · Artic Village, AKThe pilot selected unsuitable terrain for landing. A factor was the hidden obstruction (hole).Aug 20, 1994 · N6DB · Substantial damageNTSB ANC94LA122Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chickaloon, AKThe pilot's inadequate in-flight planning and a failure to maintain directional control of the airplane. Factors were the rising, rough/uneven terrain and the tailwind.Aug 20, 1994 · N2389M · Substantial damageNTSB ANC94LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Koliganek, AKThe pilot's inadequate in-flight planning and failure to attain a touchdown point in the landing area. An obstacle (tree) in the landing area was a factor in the accident.Aug 20, 1994 · N94FB · Substantial damageNTSB MIA94LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadia, FLThe pilot's inadequate compensation for wind conditions. The gusty, crosswind was a factor.Aug 19, 1994 · N757WM · Substantial damageNTSB LAX94LA333Accident · Serious injuriesLimited investigationFinal reportBoeing 757-200 · Phoenix, AZthe failure of the headset operator to adhere to established company safety procedures when he diverted his attention during pushback. A factor in the accident was the airline's failure to modify its ground handling procedures and equipment to eliminate the…Aug 19, 1994 · N901AW · No damageNTSB LAX94LA328Accident · No injuriesLimited investigationFinal reportCessna 180 · Sedona, AZthe pilot's inadvertant application of wheel brakes during a critical phase of landing rollout.Aug 19, 1994 · N9944N · Substantial damageNTSB LAX94LA327Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Firebaugh, CAthe loss of engine power due to the failure of the number 2 cylinder head. A factor was the dark night conditions which inhibited the pilot's ability to visually detect ground obstructions in the landing area.Aug 19, 1994 · N8843Q · Substantial damageNTSB LAX94LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Riverside, CAa total loss of engine power for undetermined reasons.Aug 19, 1994 · N3415M · Substantial damageNTSB LAX94IA331Incident · Minor injuriesIncident investigationFinal reportMcdonnell Douglas MD-82 · Reno, NVFailure of the area supervisor/departure controller (supvr/ctlr) to stay at his radar position and ensure that required communications were maintained. Factors related to the incident were: failure of the local tower controller instruct the flightcrew of…Aug 19, 1994 · N954AS · No damageNTSB FTW94FA274Accident · No injuriesField investigationFinal reportBell 230 · Albert Lea, MNThe pilot's failure to execute the proper approach and the ensuing settling with power. Factors were the tailwind, and the congestion around the airport.Aug 19, 1994 · N230EM · Substantial damageNTSB CHI94T#A03Accident · No injuriesFinal reportBellanca BL28 · Ellendale, NDAug 19, 1994 · N8621V · DestroyedNTSB CHI94MA290Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11F · Chicago, ILThe first officer's improper flare and improper use of flight controls during the landing flare/touchdown.Aug 19, 1994 · IDUPO · Substantial damageNTSB CHI94LA291Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Sublette, KSimproper preflight planning by the pilot. Factors associated with the accident were the delayed jettisoning of the airplane's hopper load and the inability of the airplane to climb.Aug 19, 1994 · N133MC · Substantial damageNTSB CHI94LA277Accident · No injuriesLimited investigationFinal reportBeech C90A · Janesville, WIthe pilot-in-command's exceeding the design structural limits of the airplane. Factors were turbulence in clouds and the pilot- in-command;s continued flight into known adverse weather.Aug 19, 1994 · N1553N · Substantial damageNTSB BFO94FA140Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Roanoke, VAThe disconnection of the throttle cable from the throttle arm on the fuel injector servo.Aug 19, 1994 · N4316X · DestroyedNTSB ATL94LA158Accident · No injuriesLimited investigationFinal reportCessna 172XP · Clarksburg, TNThe failure of the alternator drive coupling, and debris from the failed coupling that lodged in the engine oil pump, resulting in a sheared oil pump drive shaft. The engine subsequently failed because of oil starvation.Aug 19, 1994 · N9797V · Substantial damage