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 CHI96LA274Accident · No injuriesLimited investigationFinal reportBeech 35 · Yankton, SDan improper in-flight decision by the pilot when he shut the engine off as the airplane approached the landing runway. Factors associated with this accident were an inadequate maintenance inspection by the mechanic when the actuating arm fracture was not…Aug 3, 1996 · N3392V · Substantial damageNTSB CHI96LA266Accident · Serious injuriesLimited investigationFinal reportCessna 404 · Benton Harbor, MIthe pilot's delay in initiating a go-around after not attaining the proper touchdown point during the landing, and his failure to remain clear of obstructions (trees) during the go-around. Factors relating to the accident were the adverse weather condition…Aug 3, 1996 · N8919G · DestroyedNTSB ATL96LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Smithville, TNRestricted selector valve flow that resulted in fuel starvation. A factor was the automotive fuel that adversely affected an O-ring seal in the fuel selector valve.Aug 3, 1996 · N8584T · Substantial damageNTSB ANC96LA117Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Tuntutuliak, AKThe pilot's inadequate visual lookout.Aug 3, 1996 · N4170R · No damageNTSB ANC96LA113Accident · No injuriesLimited investigationFinal reportSportsman 2+2 · Wasilla, AKThe pilot's failure to maintain control of the airplane which resulted in an inadvertent stall/mush. A factor associated with the accident was the pilot's low altitude skidding maneuver.Aug 3, 1996 · N5045X · Substantial damageNTSB ANC96LA112Accident · No injuriesLimited investigationFinal reportCessna 172K · Nikiski, AKThe pilot's inadequate compensation for wind conditions. A factor was the windshear.Aug 3, 1996 · N78108 · Substantial damageNTSB SEA96FA175Accident · 2 fatalField investigationFinal reportMooney M20E · Purdy, WAThe noninstrument-rated pilot's continuation of VFR flight into instrument meteorological conditions which led to pilot spatial disorientation and loss of control of the aircraft. Factors were: pilot self-induced pressure, night conditions, low ceilings, and…Aug 2, 1996 · N9360M · DestroyedNTSB LAX96FA294Accident · 1 fatalField investigationFinal reportMooney M20K · Grand Canyon, AZdue to an in-flight loss of control resulting from a probable incapacitation for unknown reasons. The loss of control occurred while the aircraft was being flown in close proximity to a level 6 thunderstorm. The failure of the pilot to obtain current weather…Aug 2, 1996 · N4634H · DestroyedNTSB FTW96LA331Accident · No injuriesLimited investigationFinal reportScott Glass Goose · Aubrey, TXThe owner/builder's design change resulting in in-flight flutter of the flaperon, which led to the fuel tank rupture and separation of the flaperon.Aug 2, 1996 · N96GG · Substantial damageNTSB CHI96LA275Accident · No injuriesLimited investigationFinal reportBeech V35B · Walker, MNfailure of the pilot to properly flare the airplane for landing, and her improper recovery from a bounced landing.Aug 2, 1996 · N823T · Substantial damageNTSB CHI96LA273Accident · Minor injuriesLimited investigationFinal reportBeech 77 · South Elgin, ILwater contamination in the carburetor.Aug 2, 1996 · N18259 · Substantial damageNTSB CHI96LA271Accident · No injuriesLimited investigationFinal reportCessna 150 · Wisconsin Rapid, WIfuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel management.Aug 2, 1996 · N3238X · Substantial damageNTSB ATL96LA116Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mayersville, MSfailure of the pilot to maintain adequate clearance from an object (vehicle) on the ground.Aug 2, 1996 · N7362 · Substantial damageNTSB ATL96FA114Accident · 1 fatalField investigationFinal reportCessna TU206A · Greer, SCThe disintegration of the number 3 piston, and the pilot's inadequate selection of terrain for the landing.Aug 2, 1996 · N4813F · Substantial damageNTSB ANC96LA115Accident · No injuriesLimited investigationFinal reportde Havilland DHC-4 · New Stuyahok, AKThe collapse of the nosegear precipitated by the failure of the hydraulic nosegear drag strut locking actuator.Aug 2, 1996 · N800NC · Substantial damageNTSB ANC96LA114Accident · No injuriesLimited investigationFinal reportCessna 185 · Wainwright, AKThe pilot's excessive application of the brakes during the landing roll.Aug 2, 1996 · N20752 · Substantial damageNTSB SEA96LA181Accident · No injuriesLimited investigationFinal reportBeech 35 · Spokane, WAfailure (cracking) of the aft fuselage bulkhead for undetermined reason(s).Aug 1, 1996 · N2839V · Substantial damageNTSB MIA96LA199Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Victoria, MSThe pilot's improper fuel management resulting in a total loss of engine power due to fuel exhaustion.Aug 1, 1996 · N737DK · Substantial damageNTSB LAX96WA348Accident · No injuriesForeign investigationPiper PA-24-260C · FijiAug 1, 1996 · N9483P · Substantial damageNTSB CHI96LA268Accident · No injuriesLimited investigationFinal reportUltravia Aero Int'l Pelican · Winneconne, WIfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in a ground swerve. The location of the tree was a related factor.Aug 1, 1996 · CFPWZ · Substantial damageNTSB CHI96LA267Accident · No injuriesLimited investigationFinal reportYakovlev YAK-3UA · Fond Du Lac, WIthe pilot's inaccurate fuel consumption calculations, and his inadequate in-flight planning and decision making. The pilot's failure to declare an emergency fuel condition (inadequate communication) was a related factor.Aug 1, 1996 · N33UA · Substantial damageNTSB MIA96LA198Accident · Serious injuriesLimited investigationFinal reportCessna 210L · Sarasota, FLthe pilot's inadequate preflight inspection of the fuel tanks resulting in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Jul 31, 1996 · N397MS · Substantial damageNTSB FTW96LA329Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Burlington, COThe total loss of engine power resulting from a cracked cylinder. A factor was the unsuitable terrain for the forced landing.Jul 31, 1996 · N25SK · Substantial damageNTSB CHI96LA263Accident · Minor injuriesLimited investigationFinal reportRockwell S-2D · Bancroft, WIthe pilot's inadequate compensation for wind conditions and failure to maintain directional control, which resulted in a ground swerve, encounter with soft/sandy terrain, and a subsequent noseover. Factors relating to the accident were: the pilot's selection…Jul 31, 1996 · N1768S · Substantial damageNTSB CHI96LA262Accident · Minor injuriesLimited investigationFinal reportPiper PA-J3C · Camp Lake, WIseizure of the number 2 piston. Inadequate maintenance was a related factor.Jul 31, 1996 · N3445K · Substantial damageNTSB CHI96FA264Accident · 1 fatalField investigationFinal reportHoffman, Wolf, Flugzeugbau H-36 · Waukegan, ILfailure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in an inadvertent stalled and collision with the terrain. A factor relating to the accident was: the loose engine cowling.Jul 31, 1996 · N86PS · DestroyedNTSB MIA96LA197Accident · No injuriesLimited investigationFinal reportBell 47D1G · West Boca Raton, FLFailure of the pilot to apply carburetor heat following a loss of engine power due to inadequate altitude over a populated area. Contributing to the accident was the encounter with conditions favorable for carburetor icing.Jul 30, 1996 · N1200Z · Substantial damageNTSB LAX96LA292Accident · No injuriesLimited investigationFinal reportWaco UPF7 · Payson, AZthe failure of the pilot to maintain directional control on touchdown and the landing ground roll.Jul 30, 1996 · N29974 · Substantial damageNTSB CHI96LA269Accident · 1 fatalLimited investigationFinal reportVanwinkle Kitfox · Mt Vernon, ILfailure of the pilot to maintain control of the airplane.Jul 30, 1996 · N8200Q · DestroyedNTSB CHI96LA261Accident · No injuriesLimited investigationFinal reportCessna 188B · Cimarron, KSthe pilot's failure to make a timely decision to abort the takeoff or dump the payload.Jul 30, 1996 · N441Q · Substantial damageNTSB ANC96LA110Accident · No injuriesLimited investigationFinal reportCessna 180 · Mc Carthy, AKThe pilot's inadequate weather evaluation, and his inadvertent flight into instrument meteorological conditions.Jul 30, 1996 · N1746C · Substantial damageNTSB ANC96LA108Accident · No injuriesLimited investigationFinal reportCessna 170B · Northway, AKThe pilot's failure to maintain directional control of the airplane during landing.Jul 30, 1996 · N4464B · Substantial damageNTSB SEA96LA174Accident · No injuriesLimited investigationFinal reportCessna 182B · Metaline Falls, WAthe pilot's improper flare and improper recovery from a bounced landing. The inadvertent porpoise was a related factor.Jul 29, 1996 · N2793G · Substantial damageNTSB LAX96LA291Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Tracy, CAA loss of engine power due to the disengagement of the crankshaft gear from it's hub due to the overload shear of the eight retaining screws.Jul 29, 1996 · N68251 · DestroyedNTSB FTW96LA327Accident · No injuriesLimited investigationFinal reportBeech 95-B55B · Kingfisher, OKthe pilot's misjudgment of distance and speed, and his failure to attain a proper touchdown point, while landing. Related factors were: the short/wet runway, and uneven terrain and ditch beyond the end of the runway.Jul 29, 1996 · N8576R · Substantial damageNTSB CHI96LA257Accident · Minor injuriesLimited investigationFinal reportCessna 188 · Napoleon, NDthe pilot's improper use of the rudder to correct the airplane's drift to the right. A factor was the pilot's inadequate compensation for the crosswind.Jul 29, 1996 · N5708G · Substantial damageNTSB SEA96LA173Accident · Minor injuriesLimited investigationFinal reportCessna 182G · Portland, ORThe pilot's failure to maintain a proper glide path above the MD-80's wake turbulence.Jul 28, 1996 · N3135S · Substantial damageNTSB NYC96LA160Accident · No injuriesLimited investigationFinal reportCessna 152 · Castine, MEthe pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power, due to an inadequate supply of fuel. Factors relating to the accident were: false indication from the fuel quantity gauge, and soft terrain in the emergency…Jul 28, 1996 · N65530 · Substantial damageNTSB MIA96LA196Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCthe student pilot's improper recovery from a bounced landing by applying power and slight nose up elevator input.Jul 28, 1996 · N704WM · Substantial damageNTSB MIA96LA195Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Wedowee, ALThe failure of the pilot to obtain a preflight weather briefing and his failure to maintain directional control during the landing roll following a precautionary landing due to adverse weather encountered during the flight.Jul 28, 1996 · N3905E · Substantial damageNTSB LAX96LA293Accident · No injuriesLimited investigationFinal reportThompson Long EZ TR · Yucca Valley, CAFuel starvation due to the internal failure of the electric fuel pump and the subsequent fuel flow blockage to the gascolator.Jul 28, 1996 · N42DJ · Substantial damageNTSB FTW96LA321Accident · No injuriesLimited investigationFinal reportCessna 188A · Decatur, TXthe pilot's failure to maintain directional control. A factor was the prevailing crosswind.Jul 28, 1996 · N1556M · Substantial damageNTSB FTW96FA324Accident · 2 fatalField investigationFinal reportSlaybaugh Mustang II · Crested Butte, COThe pilot's failure to maintain aircraft control. A factor was the inadequatete altitude in which to effect a safe recovery.Jul 28, 1996 · N16WY · DestroyedNTSB CHI96LA258Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Liberal, KSthe pilot did not maintain aircraft control. A factor was a low altitude flight maneuver was performed.Jul 28, 1996 · N8837S · DestroyedNTSB CHI96LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · New Melle, MOthe pilot's selection of an unsuitable area for an emergency/precautionary landing. Factors relating to the accident were: the pilot's continual operation of the airplane with a known deficiency (broken trim switch); an uncommanded activation of the elevator…Jul 28, 1996 · N44059 · Substantial damageNTSB ANC96LA107Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate preflight planning for departure and his selection of unsuitable terrain. Factors in the accident were soft, snow covered terrain and the pilot's delay in aborting the takeoff.Jul 28, 1996 · N70018 · DestroyedNTSB SEA96LA172Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Dubois, IDfailure of the pilot to remain clear of an irrigation spray device, which resulted in inadvertent water ingestion and flameout of the aircraft's turboprop engine. Factors relating to the accident were: the proximity of the irrigation spray device (close to…Jul 27, 1996 · N5390 · Substantial damageNTSB SEA96FA171Accident · 2 fatalField investigationFinal reportCessna 340A · Richland, WAThe pilot-in-command's allowing the aircraft's airspeed to decrease below the single-engine minimum control speed (Vmc) resulting in a stall/spin condition. Factors contributing to the accident were the pilot-in-command's allowing the left engine to be shut…Jul 27, 1996 · N341TL · DestroyedNTSB FTW96LA325Accident · Minor injuriesLimited investigationFinal reportPezetel M-18A · Mcgehee, ARfailure of the brake system for undetermined reason(s), which resulted in a loss of directional control and a subsequent encounter with a ditch.Jul 27, 1996 · N7643J · Substantial damageNTSB FTW96LA323Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Moriarity, NMloss of engine power due to fuel exhaustion as a result of the pilot's failure to refuel. A factor was the lack of suitable terrain available for the forced landing.Jul 27, 1996 · N7469Z · Substantial damage