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 CHI97FA187Accident · Serious injuriesField investigationFinal reportPiper PA-22-108 · Lenox Township, MIThe pilot's failure to follow the procedures and directives as listed on the placard in the aircraft resulting in fuel starvation and subsequent engine failure.Jun 25, 1997 · N4882Z · Substantial damageNTSB ANC97LA090Accident · No injuriesLimited investigationFinal reportBeech D18S · Willow, AKThe loss of engine power for an undetermined reason.Jun 25, 1997 · N765D · DestroyedNTSB NYC97LA128Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Bellwood, PAthe total loss of engine power due to failed connecting rods.Jun 24, 1997 · N6756N · Substantial damageNTSB MIA97LA195Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Tunica, MSThe pilots poor preflight planning preparation for attempting to takeoff with a tailwind and with the hopper loaded 3/4 full during a 93degree F., day at a density altitude of 2,400 feet.Jun 24, 1997 · N45461 · Substantial damageNTSB MIA97LA194Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Walls, MSThe poor in-flight planning by the pilot for her failure to divert to an alternate airport after recognizing that a low fuel quantity state existed when preflight and in-flight planning revealed sufficient fuel for the flight. Contributing to the accident was…Jun 24, 1997 · N3692M · Substantial damageNTSB LAX97LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Phoenix, AZThe dual student's premature rotation and failure to attain/maintain an adequate airspeed, which lead to a stall/mush and loss of control in-flight, and the flight instructor's inadequate supervision of the flight. A factor in this accident was the flight…Jun 24, 1997 · N96736 · Substantial damageNTSB FTW97LA233Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Swifton, ARthe pilot's improper planning/decision. Factors relating to the accident were: the pilot's lack of recent experience in type of airplane, the weather condition (high temperature and tailwind), and the proximity of the fence and trees to the runway.Jun 24, 1997 · N6740Q · DestroyedNTSB CHI97LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lansing, ILthe pilot's inadequate compensation for wind conditions, and his failure to maintain sufficient airspeed to flare during the landing. The crosswind was a related factor.Jun 24, 1997 · N99BF · Substantial damageNTSB ANC97IA089Incident · No injuriesIncident investigationFinal reportCessna 185 · Anchorage, AKThe pilot-in-command's failure to retract the landing gear which led to an inadvertent water landing with the amphibian float wheels extended. Associated factors are the pilot's habit interference and the FAA inspector's inadequate monitoring of the flight.Jun 24, 1997 · N4952E · Minor damageNTSB NYC97LA127Accident · No injuriesLimited investigationFinal reportEiriavion PIK-20E · Rochester, VTThe pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.Jun 23, 1997 · N1043G · Substantial damageNTSB NYC97LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Highgate, VTThe pilot's failure to secure the cargo. A factor was the pilot's failure to perform weight and balance calculations.Jun 23, 1997 · N8321Y · DestroyedNTSB FTW97LA232Accident · No injuriesLimited investigationFinal reportAero Commander Callair A-9B · El Indio, TXthe pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…Jun 23, 1997 · N7684V · Substantial damageNTSB CHI97LA179Accident · No injuriesLimited investigationFinal reportCessna A150M · Cumberland, INthe pilot's failure to use (or improper use of) carburetor heat. Factors associated with the accident were: carburetor icing (weather) conditions, and the lack of airspeed (or altitude) to clear an obstruction (barn) without stalling the airplane.Jun 23, 1997 · N9842J · Substantial damageNTSB ATL97LA088Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Ridgely, TNThe pilot's inadequate preflight planning in that he failed to account for the high temperature and high density altitude, which resulted in an aerodynamic stall and loss of control. Factors were the tall crops and the ditch.Jun 23, 1997 · N6128W · Substantial damageNTSB NYC97LA125Accident · 1 fatalLimited investigationFinal reportShafer SONERAI-I · W.Hampton Beach, NYfailure of the number two pilot (N77TY) to follow race procedures, and failure of the number three pilot (N20CS) to turn and avoid the number two airplane, when it decelerated into the number three pilot's blind spot.Jun 22, 1997 · N20CS · 2 aircraft · DestroyedNTSB LAX97LA222Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · San Diego, CAthe pilot-in-command's failure to maintain an adequate airspeed which resulted in a stall/mush.Jun 22, 1997 · N6471C · Substantial damageNTSB LAX97FA286Accident · 1 fatalField investigationFinal reportCessna 172N · Cuyama, CAundetermined.Jun 22, 1997 · N6141D · DestroyedNTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.Jun 22, 1997 · N4491R · Substantial damageNTSB CHI97LA180Accident · No injuriesLimited investigationFinal reportCessna 172RG · Chicago, ILthe pilot inadvertently executed a wheels up landing.Jun 22, 1997 · N6280R · Substantial damageNTSB ATL97LA089Accident · No injuriesLimited investigationFinal reportCessna 175A · Panama City Bch, FLfailure of the pilot to account for the reduced braking effectiveness on the wet/grass airstrip, which resulted in an overrun and encounter with a ditch. Factors relating to the accident were: failure of the pilot to obtain weather information before…Jun 22, 1997 · N6844E · Substantial damageNTSB ANC97LA105Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 MK-I · Juneau, AKThe pilot's misjudged touchdown which resulted in dragging the right wingtip and rupturing the fuel tank. A factor associated with the accident is the rough water conditions.Jun 22, 1997 · N470DB · Substantial damageNTSB ANC97LA087Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Hoonah, AKThe pilot's failure to maintain directional control while landing.Jun 22, 1997 · N7025B · Substantial damageNTSB SEA97LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Madras, ORThe pilot's failure to abort the takeoff. Factors include high vegetation, rough runway, and failure to attain adequate flying speed.Jun 21, 1997 · N1357T · Substantial damageNTSB SEA97FA148Accident · 2 fatalField investigationFinal reportBeech 77 · Cottage Grove, ORFuel exhaustion resulting from the pilot's inadequate preflight planning/preparation and his failure to maintain adequate airspeed during a forced landing approach, resulting in a stall. A related factor was the pilot's failure to refuel.Jun 21, 1997 · N6630C · Substantial damageNTSB NYC97LA146Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Charleston, WVthe pilot's inadequate compensation for unfavorable (variable) wind conditions, and his failure to maintain directional control of the airplane. The wind condition and proximity of a hangar were related factors.Jun 21, 1997 · N47282 · Substantial damageNTSB NYC97LA124Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Hammonton, NJA loss of engine power due to a partially blocked engine muffler.Jun 21, 1997 · N43464 · DestroyedNTSB MIA97WA189Accident · No injuriesForeign investigationAviat A-1 · San Fernando, ArgentinaJun 21, 1997 · N12HU · Substantial damageNTSB MIA97LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Orangeburg, SCFailure of the pilot to recover from the bounced landing. Contributing to the accident was the pilots complacency.Jun 21, 1997 · N64936 · Substantial damageNTSB MIA97LA192Accident · 1 fatalLimited investigationFinal reportUnknown Kolb Firestar II · Orlando, FLInadvertent stall by the pilot while turning from the upwind to the crosswind leg. Contributing to the accident was the pilots lack of total experience in the make and model airplane.Jun 21, 1997 · UNREG · Substantial damageNTSB MIA97LA191Accident · No injuriesLimited investigationFinal reportSherman Powell Kitfox IV · Concord, NCFailure of the pilot-in-command to maintain directional control and his poor preflight planning preparation for allowing the pilot rated passenger to manipulate the throttle control. Contributing to the accident was the pilots total lack of experience in make…Jun 21, 1997 · N582KF · Substantial damageNTSB MIA97FA188Accident · 1 fatalField investigationFinal reportBeech 77 · Fort Lauderdale, FLloss of engine power for undetermined reason(s), and failure of the student pilot to remain clear of obstructions, while attempting to make a forced landing.Jun 21, 1997 · N1821B · DestroyedNTSB IAD97LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Defiance, OHThe failure of a wheel rim due to overstress separation with no clear evidence initiating event.Jun 21, 1997 · N5716F · Substantial damageNTSB DCA97MA053Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11 · Honolulu, HIThe pilot's failure to apply adequate manual control inputs following his decision to disconnect the autopilot during the autoland operation, resulting in a subsequent loss of directional control. Also causal and contributing to the tail strike was the…Jun 21, 1997 · EICDK · Substantial damageNTSB CHI97LA182Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Willard, MOremedial action delayed by the flight instructor. A factor in this accident was the instructor's lack of recent experience in this type airplane.Jun 21, 1997 · N7506F · Substantial damageNTSB CHI97LA177Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Satanta, KSthe pilot not maintaining aircraft control shortly after it had touched down during its liftoff. A factor in this accident was the premature liftoff during takeoff by the pilot.Jun 21, 1997 · N4954R · Substantial damageNTSB CHI97LA176Accident · No injuriesLimited investigationFinal reportMaule M5C · Lino Lakes, MNthe flight instructor's inadequate preflight planning/preparation, his the improper lowering of flaps for takeoff, his failure to use a longer available area for takeoff, and his failure to abort the takeoff before there was an insufficient amount of area…Jun 21, 1997 · N5643Y · Substantial damageNTSB CHI97LA175Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Wamego, KSinaccurate preflight planning which resulted in an inadequate fuel supply for the flight and ultimately fuel exhaustion. Factors associated with the accident were the powerlines and the parachutists over the runway.Jun 21, 1997 · N6535R · Substantial damageNTSB CHI97LA174Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Faulkton, SDthe pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.Jun 21, 1997 · N7378Z · DestroyedNTSB ANC97LA088Accident · No injuriesLimited investigationFinal reportCessna 206 · Prudhoe Bay, AKThe pilot's improper preflight inspection of the airplane and failure to properly secure the baggage door.Jun 21, 1997 · N756DJ · Substantial damageNTSB SEA97LA150Accident · No injuriesLimited investigationFinal reportCorben Junior ACE · East Wenatchee, WAThe dual student's improper attempt to abort the takeoff and the flight instructor's inadequate supervision of the flight.Jun 20, 1997 · N9017 · Substantial damageNTSB SEA97LA147Accident · 1 fatalLimited investigationFinal reportWolf Smith M/P DSA-1 · Bend, ORAn inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…Jun 20, 1997 · N168RW · DestroyedNTSB SEA97LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Sweet Home, ORThe pilot's inadequate preflight preparation and his inadequate inflight planning which resulted in fuel exhaustion. A factor was lack of suitable terrain for a forced landing.Jun 20, 1997 · N6599S · Substantial damageNTSB SEA97LA145Accident · Minor injuriesLimited investigationFinal reportRoss/Stonecipher Vans RV-6 · Woods Cross, UTa bird strike, which penetrated the aircraft canopy. High grass (hay crop) in the forced landing area was a related factor.Jun 20, 1997 · N345JE · Substantial damageNTSB MIA97LA190Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Edwards, MSfailure of the distributor drive gear in the right magneto, resulting in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.Jun 20, 1997 · N6816Q · Substantial damageNTSB LAX97LA218Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Pacific Ocean (Pacific Ocean)The unapproved field modification of the cyclic trim switch, including the use of non-standard parts, which resulted in a hard-over lateral trim failure, and the pilot's subsequent failure to maintain control of the helicopter during a landing approach. A…Jun 20, 1997 · N4250N · DestroyedNTSB LAX97FA217Accident · 3 fatalField investigationFinal reportPiper PA 31-310 · San Diego, CAThe loss of power in the left engine for undetermined reasons and the pilot's subsequent failure to maintain minimum single-engine control airspeed. A contributing factor was the pilot's decision to fly with known deficiencies in the equipment.Jun 20, 1997 · N266MM · DestroyedNTSB FTW97LA231Accident · No injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Waldenburg, ARthe pilot's improper planning/decision. The short runway and failure to use up to 10 degrees of flaps were related factors.Jun 20, 1997 · N148RA · DestroyedNTSB DCA97WA067Incident · No injuriesForeign investigationBoeing 737-548 · Copenhagen, DenmarkJun 20, 1997 · EI-CDT · No damageNTSB CHI97LA178Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Benton, MOthe pilot's inadequate preflight by failing to insure that the secondary flight control lock was stowed properly, and subsequently the secondary flight control lock becoming engaged during the takeoff run. A factor relating to the accident was: inadequate…Jun 20, 1997 · N48FS · Substantial damageNTSB ATL97LA087Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301A · Labelle, FLfailure of the pilot to maintain adequate airspeed during a turn-around maneuver, which resulted in an aerodynamic stall/mush and collision with the terrain.Jun 20, 1997 · N23728 · Substantial damage